JDBC事务处理，以及提交点保存的代码

lvhuiqing

浏览: 258003 次
性别:
来自: 沈阳

最近访客更多访客>>

zjd621102

恋欲兰渊

yhook

seavisiocode

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

<p><textarea cols="50" rows="15" name="code" class="c-sharp">static void test() throws SQLException {
Connection conn = null;
Statement st = null;
ResultSet rs = null;
Savepoint sp = null;
try {
conn = JdbcUtils.getConnection();
conn.setAutoCommit(false);
st = conn.createStatement();
String sql = "update user set money=money-10 where id=1";
st.executeUpdate(sql);
sp = conn.setSavepoint();

sql = "update user set money=money-10 where id=3";
st.executeUpdate(sql);

sql = "select money from user where id=2";
rs = st.executeQuery(sql);
float money = 0.0f;
if (rs.next()) {
money = rs.getFloat("money");
}
if (money > 300)
throw new RuntimeException("已经超过最大值！");

sql = "update user set money=money+10 where id=2";
st.executeUpdate(sql);

conn.commit();
} catch (RuntimeException e) {
if (conn != null && sp != null) {
conn.rollback(sp);
conn.commit();
}
throw e;
} catch (SQLException e) {
if (conn != null)
conn.rollback();
throw e;
} finally {
JdbcUtils.free(rs, st, conn);
}
}</textarea><textarea cols="50" rows="15" name="code" class="java">Connection conn = null;
Statement st = null;
ResultSet rs = null;
try {
conn = JdbcUtils.getConnection();
conn.setAutoCommit(false);
conn.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);

st = conn.createStatement();
String sql = "update user set money=money-10 where id=1";
st.executeUpdate(sql);

sql = "select money from user where id=2";
rs = st.executeQuery(sql);
float money = 0.0f;
if (rs.next()) {
money = rs.getFloat("money");
}
if (money > 400)
throw new RuntimeException("已经超过最大值！");
sql = "update user set money=money+10 where id=2";
st.executeUpdate(sql);
conn.commit();
} catch (SQLException e) {
if (conn != null)
conn.rollback();
throw e;
} finally {
JdbcUtils.free(rs, st, conn);
}</textarea></p>

分享到：