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();
}
}
}
}
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();
}
}
}
}