📄 780653.xml
字号:
<?xml version='1.0' encoding='GB2312'?>
<?xml-stylesheet type='text/xsl' href='../csdn.xsl'?>
<Topic>
<Issue>
<PostUserNickName>天皇他爹</PostUserNickName>
<rank>三级(初级)</rank>
<ranknum>user3</ranknum>
<credit>100</credit>
<TopicId>780653</TopicId>
<TopicName>jsp中怎么运用 数据库的commit 和rollback</TopicName>
<PostUserId>185943</PostUserId>
<PostUserName>bbshero</PostUserName>
<RoomName>JSP</RoomName>
<ReplyNum>6</ReplyNum>
<PostDateTime>2002-6-5 15:55:37</PostDateTime>
<Point>20</Point>
<ReadNum>0</ReadNum>
<RoomId>28</RoomId>
<EndState>2</EndState>
<Content>public   String sDBDriver= "sun.jdbc.odbc.JdbcOdbcDriver";
public   String sConnStr= "jdbc:odbc:jsp";
public   Connection conn= null;
public   ResultSet RS=    null;
public   Statement st = null;
public   PreparedStatement pst;
public   String ms;
那么commit rollback 怎么写？</Content>
</Issue>
<Replys>
<Reply>
<PostUserNickName>晓彬</PostUserNickName>
<rank>两星(中级)</rank>
<ranknum>star2</ranknum>
<credit>135</credit>
<ReplyID>5075604</ReplyID>
<TopicID>780653</TopicID>
<PostUserId>173450</PostUserId>
<PostUserName>Andrawu</PostUserName>
<Point>5</Point>
<Content>try {
	conn.getConnection();    //连接数据库
	conn.setAutoCommit(false) ;
	//更新、删除操作..........
	conn.commit();
}catch(Exception se) {
	conn.rollback();
	se.printStackTrace(System.err);
}finally {
	conn.close();  //关闭数据库连接
}
</Content>
<PostDateTime>2002-6-5 16:09:04</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>晓彬</PostUserNickName>
<rank>两星(中级)</rank>
<ranknum>star2</ranknum>
<credit>135</credit>
<ReplyID>5075709</ReplyID>
<TopicID>780653</TopicID>
<PostUserId>173450</PostUserId>
<PostUserName>Andrawu</PostUserName>
<Point>0</Point>
<Content>try {
	conn.getConnection();    //连接数据库
	conn.setAutoCommit(false) ;
	//更新、删除操作..........
	conn.commit();
}catch(Exception se) {
	conn.rollback();
	se.printStackTrace(System.err);
}finally {
	conn.close();  //关闭数据库连接
}
</Content>
<PostDateTime>2002-6-5 16:13:05</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>saintKnight</PostUserNickName>
<rank>五级(中级)</rank>
<ranknum>user5</ranknum>
<credit>100</credit>
<ReplyID>5075913</ReplyID>
<TopicID>780653</TopicID>
<PostUserId>237709</PostUserId>
<PostUserName>saintKnight</PostUserName>
<Point>5</Point>
<Content>Connection conn;
Statement st;
try {
    conn = DriverManager.getConnection(url,user,pwd);
    conn.setAutoCommit(false);
    Statement Stmt = conn.createStatement();
    Stmt.executeQuery(sql);
    conn.setAutoCommit(true);
}catch(Exception ex) {
    conn.rollback();
}</Content>
<PostDateTime>2002-6-5 16:23:07</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>saintKnight</PostUserNickName>
<rank>五级(中级)</rank>
<ranknum>user5</ranknum>
<credit>100</credit>
<ReplyID>5075936</ReplyID>
<TopicID>780653</TopicID>
<PostUserId>237709</PostUserId>
<PostUserName>saintKnight</PostUserName>
<Point>5</Point>
<Content>Sorry，应该是conn.commit();而不是conn.setAutoCommit(true);</Content>
<PostDateTime>2002-6-5 16:24:24</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>卧龙</PostUserNickName>
<rank>四级(中级)</rank>
<ranknum>user4</ranknum>
<credit>100</credit>
<ReplyID>5075992</ReplyID>
<TopicID>780653</TopicID>
<PostUserId>223374</PostUserId>
<PostUserName>wjfxiao</PostUserName>
<Point>0</Point>
<Content>楼上的就是
标准用法！</Content>
<PostDateTime>2002-6-5 16:26:39</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>weidegong</PostUserNickName>
<rank>两星(中级)</rank>
<ranknum>star2</ranknum>
<credit>118</credit>
<ReplyID>5076048</ReplyID>
<TopicID>780653</TopicID>
<PostUserId>128268</PostUserId>
<PostUserName>weidegong</PostUserName>
<Point>5</Point>
<Content>boolean autoCommit;
//-------------------------------------------------------------
//事务处理的几个方法
public void beginTrans() throws SQLException
{ try
{
autoCommit=conn.getAutoCommit();
conn.setAutoCommit(false);
}
catch(SQLException ex)
{
ex.printStackTrace();
System.out.print("beginTrans Errors");
throw ex;
}
}
public void commit() throws SQLException
{
try
{
conn.commit();
conn.setAutoCommit(autoCommit);
}
catch(SQLException ex)
{
ex.printStackTrace();
System.out.print("Commit Errors");
throw ex;
}
}
public void rollback()
{
try
{
conn.rollback();
conn.setAutoCommit(autoCommit);
}
catch(SQLException ex)
{
ex.printStackTrace();
System.out.print("Rollback Errors");
//throw ex;
}
}
public boolean getAutoCommit() throws SQLException
{
boolean result=false;
try
{
result=conn.getAutoCommit();
}
catch(SQLException ex)
{
ex.printStackTrace();
System.out.println("getAutoCommit fail"+ex.getMessage());
throw ex;
}
return result;
}
//-------------------------------------------------------------
</Content>
<PostDateTime>2002-6-5 16:29:11</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>weidegong</PostUserNickName>
<rank>两星(中级)</rank>
<ranknum>star2</ranknum>
<credit>118</credit>
<ReplyID>5076059</ReplyID>
<TopicID>780653</TopicID>
<PostUserId>128268</PostUserId>
<PostUserName>weidegong</PostUserName>
<Point>0</Point>
<Content>boolean autoCommit;
//-------------------------------------------------------------
//事务处理的几个方法
public void beginTrans() throws SQLException
{ try
{
autoCommit=conn.getAutoCommit();
conn.setAutoCommit(false);
}
catch(SQLException ex)
{
ex.printStackTrace();
System.out.print("beginTrans Errors");
throw ex;
}
}
public void commit() throws SQLException
{
try
{
conn.commit();
conn.setAutoCommit(autoCommit);
}
catch(SQLException ex)
{
ex.printStackTrace();
System.out.print("Commit Errors");
throw ex;
}
}
public void rollback()
{
try
{
conn.rollback();
conn.setAutoCommit(autoCommit);
}
catch(SQLException ex)
{
ex.printStackTrace();
System.out.print("Rollback Errors");
//throw ex;
}
}
public boolean getAutoCommit() throws SQLException
{
boolean result=false;
try
{
result=conn.getAutoCommit();
}
catch(SQLException ex)
{
ex.printStackTrace();
System.out.println("getAutoCommit fail"+ex.getMessage());
throw ex;
}
return result;
}
//-------------------------------------------------------------
</Content>
<PostDateTime>2002-6-5 16:29:33</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>天皇他爹</PostUserNickName>
<rank>三级(初级)</rank>
<ranknum>user3</ranknum>
<credit>100</credit>
<ReplyID>5076434</ReplyID>
<TopicID>780653</TopicID>
<PostUserId>185943</PostUserId>
<PostUserName>bbshero</PostUserName>
<Point>0</Point>
<Content>谢谢 ！</Content>
<PostDateTime>2002-6-5 16:47:00</PostDateTime>
</Reply>
</Replys>
</Topic>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -