stmt 为Statement对象,执行String sqlStatement=”delete from book where bid=’tp1001’”;语句后,删除数据库表的记录需要执行____语句
stmt.executeUpdate()
举一反三
- stmt为Statement对象，执行String sqlStatement = "delete from book where bid='tp1001' ";语句后，删除数据库表的记录需要执行stmt.executeUpdate ( )语句
- 删除demo表中id为1001的记录。其SQL语句为（ ）。 A: delete from demo where id=1001 B: delete demo C: delete from dmeo where id=1001 D: delete demo where id=1001
- 下列语句用来删除表对象或表数据，其中不正确的语句是（）。 A: TRUNCATE TABLE book B: DELETE * FROM book C: DROP TABLE book D: DELETE FROM book
- 下列语句用来删除数据表中指定记录，正确的语句是（ ）。 A: DELETE FROM book WHERE 单价>20 B: DELETE * FROM book C: DELETE FROM book HAVING 单价>20 D: DELETE FROM book
- 已知企业员工管理数据库中员工表结构如下：员工（工号，姓名，性别，年龄，部门）。现要从该表删除一条工号为“1001”的员工记录，则删除语句应该是（） A: delete from 员工 where 工号=1001 B: delete * from员工where工号=1001 C: delete员工where工号 is 1001 D: delete * from员工where工号 is 1001
内容
- 0
从学生表中删除学号为“1001”的学生记录，正确的SQL语句是______。 A: DELETE FROM 学生 WHERE 学号="1001" B: DROP FROM 学生 FOR 学号="1001" C: DROP FROM 学生 WHERE 学号="1001" D: DELETE FROM 学生 FOR 学号="1001"
- 1
从学生表中删除学号为“1001”的学生记录，正确的SQL语句是______。 A: DROP FROM Student WHERE 学号="1001" B: DROP FROM Student FOR 学号="1001" C: DELETE FROM Student WHERE 学号="1001" D: DELETE FROM Student FOR 学号="1001"
- 2
Statement对象提供了int executeQuery(String sqlStatement)方法，用于实现对数据库中数据的查询操作，执行后返回值为1。（ ）
- 3
从订单表中删除客户号为“1001“的订单记录，正确的SQL语句是()。 A: DROP FROM 订单 WHERE 客户号='1001' B: DROP FROM 订单 FOR 客户号='1001' C: DELETE FROM 订单 WHERE 客户号='1001' D: DELETE FROM 订单FOR 客户号='1001'
- 4
若要删除book表中所有数据,以下语句正确的是( )。 A: delete table book B: delete * from book C: drop book D: delete from book