以下选项中( )不是JDBC访问数据库时常用的接口和类
A. Record
B. Connection
C. Statement
D. ResultSet
查看答案
DriverManager类的哪个方法用于加载注册驱动程序?
A. Class.forName()
B. getConnection()
C. getDriver()
D. close()
在JSP页面中使用JDBC技术访问数据库,可以正确导入SQL类库的语句是()
A. <%@ page import="java.sql.*" %>
B. <%@ page import="sql.*" %>
C. <% page import="java.sql.*" %>
D. <%@ import="java.sql.*" %>
JSP页面中有一行代码“String id = request.getParameter("id");”,以下选项中,可以正确地从“score”表中查询“stuID”字段(该字段类型为vchar)的值等于id的记录的select语句是( )
A. String sql="select * from score";
B. String sql="select * from score where stuID='" + id;
C. String sql="select * from score where stuID='" + id + "'";
D. String sql="select * from score where stuID=" + id + "'";
以下选项中,可以正确地从“employee”表的“name”字段中找出值包含“玛丽”的记录的select语句是( )
A. Select * from employee where name =’_玛丽_’
B. Select * from employee where name =’%玛丽_’
C. Select * from employee where name like ‘_玛丽%’
D. Select * from employee where name like ‘%玛丽%’