String sql=”delete from book where bookName=?”;
PreparedStatement pst=con.preparedStatement(sql);
____________________________
pst.execute();
举一反三
- 要删除book表中书籍(bookName)是”java”的记录,以下代码正确的是(AString sql=”delete from book where bookName=?”;PreparedStatement pst=con.preparedStatement(sql);______________________________pst.execute(); A: pst.setString(1,”java”); B: pst.setString(0,”java”); C: pst.setInt(0,”java”); D: 以上选项都不正确
- 要删除book表中书籍(bookName)是”java”的记录,横线上应填写的正确代码的是 ( )<br/>String sql=”delete from book where bookName=?”;<br/>PreparedStatement pst=con.preparedStatement(sql);<br/>______________________________<br/>pst.execute(); A: pst.setString(1,”java”); B: pst.setString(0,”java”); C: pst.setInt(0,”java”); D: 以上选项都不正确
- 要删除book表中图书名称(bookName)是“java程序设计语言”的记录,应该填入空白处的语句是String sql= "DELETE FROM book WHERE bookName=?";PreparedStatement pst=con.preparedStatement(sql);______________________________pst.execute(); A: pst.setString(1,"java程序设计语言"); B: pst.setString(0,"java程序设计语言"); C: pst.setInt(0,"java程序设计语言"); D: 以上选项都不正确
- 要删除book表中书籍名称(bookName)是“java”的记录,以下代码正确的是( )Stringsql="deletefrombookwherebookName=?";PreparedStatementpst=con.prepareStatement(sql);―――――――――――――――――pst.execute(); A: pst.setString(1,"java"); B: pst.setString(0,"java"); C: pst.setInt(0,"java"); D: 以上选项都不正确
- BookStore数据库中有图书表 Book(BookCode, BookName, Author, PublisherCode, PublishTime,BookSort, ISBN, BookPicture, ContentInro, Price, Discount) 查询图书名称(BookName)含有“程序”的图书信息。SQL语句: SELECT BookCode,BookName,Author,Price,Discount FROM Book WHERE Name=“%程序%”
内容
- 0
BookStore数据库中有图书表 Book(BookCode, BookName, Author, PublisherCode, PublishTime,BookSort, ISBN, BookPicture, ContentInro, Price, Discount) 查询作者名长度大于等于8的图书信息,显示书名(BookName)及作者(Author)。SQL语句: SELECT BookName, Author FROM Book WHERE Lenth(Author)= 8
- 1
下列语句用来删除数据表中指定记录,正确的语句是( )。 A: DELETE FROM book WHERE 单价>20 B: DELETE * FROM book C: DELETE FROM book HAVING 单价>20 D: DELETE FROM book
- 2
若要删除book表中所有数据,以下语句正确的是( )。 A: delete table book B: delete * from book C: drop book D: delete from book
- 3
查询图书名称含有“程序”的图书信息。语句如下:SELECT BookCode, BookName, Author, Price, DiscountFROM BookWHERE BookName LIKE ________
- 4
BookStore数据库中有图书表Book(BookCode, BookName, Author, PublisherCode, PublishTime,BookSort, ISBN, BookPicture, ContentInro, Price, Discount),其中 PublishTime是datetime类型。 查询Book表中的图书类别(BookSort),要求每个类别只显示一次。SQL语句: SELECT _________ BookSort FROM Book