stmt为Statement对象,执行String sqlStatement = "delete from book where bid='tp1001' ";语句后,删除数据库表的记录需要执行stmt.executeUpdate ( )语句
举一反三
- stmt 为Statement对象,执行String sqlStatement=”delete from book where bid=’tp1001’”;语句后,删除数据库表的记录需要执行____语句
- 要执行str="select * from customer"语句,假设Statement对象stmt,执行SQL语句的代码哪个正确? A: stmt.executeQuery(str) B: stmt.executeUpdate(str) C: stmt.executeSelect(str) D: stmt.executeDelete(str)
- 下面是创建Statement接口并执行executeUpdate方法的代码片段: conn=DriverManager.getConnection(“jdbc.odbc:book”,””,””); stmt=conn.createStatement(); String strsql=”insert into book values(‘TP003’,’ASP.NET’,’李’,’清华出版社’,35)”; n=stmt.executeUpdate(strsql); 代码执行后n的值为
- 下面是创建Statement接口并执行executeUpdate方法的代码片段:conn=DriverManager.getConnection(“jdbc.odbc:book”,””,””);stmt=conn.createStatement();String strsql=”insert into book values(‘TP003’,’ASP.NET’,’李’,’清华出版社’,35)”;n=stmt.executeUpdate(strsql);代码执行后n的值为( ) A: 1 B: 0 C: -1 D: 一个整数
- 删除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