【数据库】JDBC课设（3）TYPE_SCROLL_INSENSITIVE使结果集可以前后滚动

public static void main(String[] args) { ResultSet rs = null ; Statement stmt = null ; Connection conn = null ; PreparedStatement pstm = null ; try { // 1.注册驱动 Class.forName( " com.mysql.cj.jdbc.Driver " ); // 2.建立连接 conn = (Connection) DriverManager.getConnection( " jdbc:mysql://localhost:3306/test?useUnicode=true&serverTimezone=Asia/Shanghai&characterEncoding=UTF-8&useSSL=FALSE " , " root " , "" ); // 3.处理结果集 // stmt = conn.createStatement(); // rs = stmt.executeQuery("select * from tablename1"); // // // while (rs.next()) { // int age = rs.getInt("age"); // /// / 输出查到的记录的各个字段的值 // System.out.println( " " + age); // } // 预编译语句 // String sql="select * from tablename1 where age = ?"; // pstm=conn.prepareStatement(sql); // pstm.setInt(1,21); // rs=pstm.executeQuery(); // while (rs.next()) { // int age = rs.getInt("age"); // /// / 输出查到的记录的各个字段的值 // System.out.println( " " + age); // } // addbatch方法 执行一组sql语句 // String sql1="insert into tablename1(age) values(?)"; // stmt = conn.createStatement(); // stmt.addBatch(sql1); // stmt.addBatch(sql2); // stmt.addBatch(sql3); // psmt的addbatch方法 // PreparedStatement psmt1=conn.prepareStatement(sql1); // psmt1.setInt(1,40); // psmt1.addBatch(); // psmt1.setInt(1,45); // psmt1.addBatch(); // int[] upRowS=psmt1.executeBatch(); // 执行命令所影响数据库中行数的更新计数 // int[] upRowS=stmt.executeBatch(); // for(int tmp:upRowS) // System.out.println(tmp); // psmt查询到的结果集 进行previous last等取值 String sql=( " select * from tablename1 " ); PreparedStatement psmt = conn.prepareStatement(sql,rs.TYPE_SCROLL_INSENSITIVE,rs.CONCUR_READ_ONLY); rs = psmt.executeQuery(); System. out .println( " 先按顺序输出所有内容 " ); while (rs.next()) { int tmp=rs.getInt( 1 ); System. out .print(tmp+ " " ); } System. out .println( " \n输出第一个值： " ); rs.first(); int tmp=rs.getInt( 1 ); System. out .println(tmp); System. out .println( " 输出最后一个值： " ); rs.last(); tmp =rs.getInt( 1 ); System. out .println(tmp); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } finally { try { // 4.关闭资源 if (rs != null ) { rs.close(); rs = null ; } if (stmt != null ) { stmt.close(); stmt = null ; } if (conn != null ) { conn.close(); conn = null ; } } catch (SQLException e) { e.printStackTrace(); } } } }

 

【数据库】JDBC课设（3）TYPE_SCROLL_INSENSITIVE使结果集可以前后滚动

标签：batch   ast   http   mys   main   建立   local   结果   ace   

查看更多关于【数据库】JDBC课设（3）TYPE_SCROLL_INSENSITIVE使结果集可以前后滚动的详细内容...