JAVA JDBC 数据库的一点记录: ResultSet

来源：互联网发布：软件测试学习计划编辑：程序博客网时间：2024/05/17 22:09

JAVA JDBC 数据库的一点记录: ResultSet

Statement stmt =

conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);String table = "Student";String sql = "SELECT * FROM "+table;ResultSet rs = stmt.executeQuery(sql);public static void printData(ResultSet rs) throws SQLException{rs.beforeFirst();System.out.println("NO  name  age  add");while(rs.next()){int NO = rs.getInt("NO");String name = rs.getString("name");int age = rs.getInt("age");String add = rs.getString("add");System.out.println(NO+" "+name+" "+age+" "+add);}}public static void updateData(ResultSet rs) throws SQLException{rs.first();rs.updateString("name", "ken");rs.updateInt(3, 10);rs.updateRow();rs.moveToInsertRow();rs.updateInt(1, 8);rs.updateString(2, "Tim");rs.updateInt(3, 28);rs.updateString(4,"china");rs.insertRow();rs.moveToCurrentRow();}public static void delData(ResultSet rs,int rowid) throws SQLException{rs.absolute(rowid);rs.deleteRow();}