举一反三
- Student 是SQL Server数据库School中的一个数据表,为执行SQL语句:SELECT * FROM Student,应调用SqlCommand对象的________方法。 A: ExecuteScalar B: ExecuteXmlReader C: ExecuteReader D: ExecuteNonQuery
- 根据用户在文本框txtName中输入的姓名对Student表进行查询,以下SQL语句定义正确的是__________________。 A: String sql=Select * from Student where Sname=+txtName.getText(); B: String sql=Select * from Student where Sname='+txtName.getText()+'; C: String sql=Select * from Student where Sname like +txtName.getText(); D: String sql=Select * from Student where Sname like '+txtName.getText()+';
- 数据库中有一张表名称为Student,有列Name,Age,IDCard,Sex。要求写SQL语句查询出表中年龄介于20和30岁之间的数据,下列哪个SQL语句是正确的?() A: Select* From Student Where Age>=20 ANDAge>=30 B: Select* From Student Where Age>=20 ANDAge<=30 C: Select* From Student Where Age BET WENN 20AND30 D: Select* From Student Where Age>=20&&Age>=30"
- 为创建在SQL Server 2000 中执行Select 语句的Command 对象,可先建立到SQL Server2000 数据库的连接,然后使用连接对象的_______方法创建SqlCommand 对象
- 表student中的包含两个字段,整型的id,字符串型的name。只显示表student中name列记录的SQL语句正确的是() A: select name from student B: select * from student C: select from name in student D: select name
内容
- 0
检索student中所有记录的语句如下 String sql="select * from student"; 执行命令,返回执行结果的语句为() A: ResultSet rs=stmt.executeQuery(sql); B: ResultSet rs=stmt.execute(sql); C: ResultSet rs=stmt.executeUpdate(sql);
- 1
查询student表中的gender字段(gender代表性别),使其查询记录中不能出现重复值的SQL语句是(1.0分) A: SELECT gender FROM student; B: SELECT DISTINCT * FROM student; C: SELECT DISTINCT gender FROM student; D: SELECT * FROM student;
- 2
若想查询student表中name为空值的记录,则正确的SQL语句是( )。 A: SELECT * FROM student WHERE name = NULL; B: SELECT * FROM student WHERE name like NULL; C: SELECT * FROM student WHERE name = 'NULL'; D: SELECT * FROM student WHERE name is NULL;
- 3
在 SQL 语句“select * from student”中,“*”号的含义是
- 4
根据用户在文本框txtName中输入的姓名对Student表进行查询,以下SQL语句定义正确的是__________________。 A: String sql="Select * from Student where Sname="+txtName.getText(); B: String sql="Select * from Student where Sname='"+txtName.getText()+"'"; C: String sql="Select * from Student where Sname like "+txtName.getText(); D: String sql="Select * from Student where Sname like '"+txtName.getText()+"'";