Statement smt = con.createStatement();
/* 组装语句 */
String insCode = "INSERT INTO ……";
smt.executeUpdate(insCode);//写入执行
smt.close();
……
con.close();
/* 组装语句 */
String insCode = "INSERT INTO ……";
smt.executeUpdate(insCode);//写入执行
smt.close();
……
con.close();
{
conn=DriverManager.getConnection(sConnStr,sUser,sPassword);
conn.setAutoCommit(false);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
stmt.executeUpdate("insert ……");
conn.commit();
return true;
}
catch(SQLException ex)
{
try{conn.rollback();}catch(SQLException excep) { }
return false;
}
finally{try{conn.close();}catch(SQLException ex){}}
.
.
.
String insCode = "INSERT INTO ……";
smt.executeUpdate(insCode);//写入执行
.
.
con.commit;(con.rollback;)//手工控制提交
使用Java的事务处理。JTA