import java.sql. * ; public class TestPrepStmt ... { public static void main(String[] args) ...{ Statement stmt = null; Connection conn = null; try ...{ Class.forName("com.mysql.jdbc.Driver"); String url = "jdbc:mysql://localhost/data?user=root&password=123456"; conn = DriverManager.getConnection(url); //注意处理可更新的结果集时,只能处理一张表,而且表中必须有主键。 stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE); ResultSet rs=stmt.executeQuery("select * from user"); rs.next();//定位到下一条记录 //更新一行数据 rs.updateString("name","AAAA"); rs.updateRow(); //插入新行 rs.moveToInsertRow(); //rs.updateInt(1, 99); rs.updateString("name","AABB"); rs.updateString("address", "BBBB"); rs.insertRow(); //将光标移动到新建的行 rs.moveToCurrentRow(); //删除行 rs.absolute(5); rs.deleteRow(); //取消更新 //rs.cancelRowUpdates(); } catch (ClassNotFoundException e) ...{ e.printStackTrace(); } catch (SQLException e) ...{ e.printStackTrace(); } finally ...{ try ...{ if(stmt != null) ...{ stmt.close(); stmt = null; } if(conn != null) ...{ conn.close(); conn = null; } } catch (SQLException e) ...{ e.printStackTrace(); } } }}