题目内容

{在【1】-【5】处填写代码,使得程序能实现显示数据表student的内容。public class Demo175 {public static void main(String[] args) {try{Class.forName("oracle.jdbc.driver.OracleDriver");String url = "jdbc:oracle:thin:@localhost:1521:MyDB";Connection conn = 【1】(url, "root", "root");Statement 【2】;String sql = "select * from student";ResultSet rs = 【3】;int i=0;while(【4】){System.out.print((++i)+"\t");System.out.print(rs.getString("stuNo")+"\t");System.out.print(rs.getString("stuName")+"\t");System.out.println(rs.getDouble("score"));}【5】;stmt.close();conn.close();}catch (SQLException e) {e.printStackTrace();} catch (ClassNotFoundException e){e.printStackTrace();}}}}

查看答案

搜索结果不匹配？点我反馈

更多问题

{在【1】-【5】处填写代码,使得程序能实现修改数据表student的记录。public class Demo174 {public static void main(String[] args) {try{【1】("com.microsoft.sqlserver.jdbc.SQLServerDriver");String url = "jdbc:sqlserver://localhost:1433; DatabaseName=MyDB";String user = "root";String password = "root";Connection conn = DriverManager.getConnection(url, user, password);String sql = "update student set score=? where stuNo=?";PreparedStatement 【2】;【3】(1, 80.0);pstmt.setString(2,"001");int count = 【4】;pstmt.close();【5】;}catch (SQLException e) {e.printStackTrace();} catch (ClassNotFoundException e){e.printStackTrace();}}}

在JDBC中,要执行SQL语句,必须获得java.sql.Statement实例。

A. 对
B. 错

语句“Statement s=new Statement();”创建了Statement的实例对象。然后可通过Statement的方法executeQuery执行删除记录的处理。( )

A. 对
B. 错

每个java.sql.Statement实例对象只能对应一个Java.sql.ResultSet实例对象,所以如果执行SQL语句返回多个结果,一般需要分多次取得返回结果。( )

A. 对
B. 错