JDBC:事务处理

public class BaseDao(){ 2 //静态加载数据库驱动包(这里是Oracle数据库) 3 static{ 4 try { 5 Class.forName("oracle.jdbc.driver.OracleDriver"); 6 } catch (ClassNotFoundException e) { 7 e.printStackTrace(); 8 } 9 } 10 11 //获取数据库链接对象 12 public static Connection getConnection(){ 13 String url="jdbc:oracle:thin:@localhost:1521:orcl"; 14 try { 15 return DriverManager.getConnection(url,"scott","tiger"); 16 } catch (SQLException e) { 17 e.printStackTrace(); 18 } 19 return null; 20 } 21 22 } JDBC获取数据库连接对象

<span style="color: #008080"> 1</span> <span style="color: #008000">//</span><span style="color: #008000">使用Jdbc执行持久化(Dept)</span>
<span style="color: #008080"> 2</span>     <span style="color: #0000ff">public</span> <span style="color: #0000ff">static</span> <span style="color: #0000ff">void</span><span style="color: #000000"> main(String[] args) {
</span><span style="color: #008080"> 3</span>         Connection conn=<span style="color: #000000">getConnection();
</span><span style="color: #008080"> 4</span>         Statement st=<span style="color: #0000ff">null</span><span style="color: #000000">;
</span><span style="color: #008080"> 5</span>         <span style="color: #0000ff">try</span><span style="color: #000000"> {
</span><span style="color: #008080"> 6</span>             conn.setAutoCommit(<span style="color: #0000ff">false</span>);<span style="color: #008000">//</span><span style="color: #008000">设置不自动提交</span>
<span style="color: #008080"> 7</span>             st=<span style="color: #000000">conn.createStatement();
</span><span style="color: #008080"> 8</span>             String sql="insert into dept values(40,‘后勤‘,‘XXX‘)"<span style="color: #000000">;
</span><span style="color: #008080"> 9</span> <span style="color: #000000">            st.executeUpdate(sql);
</span><span style="color: #008080">10</span>             conn.commit();<span style="color: #008000">//</span><span style="color: #008000">提交事务
</span><span style="color: #008080">11</span>             <span style="color: #008000">//</span><span style="color: #008000">conn.rollback();</span><span style="color: #008000">//</span><span style="color: #008000">回滚事务</span>
<span style="color: #008080">12</span> <span style="color: #000000">            conn.close();
</span><span style="color: #008080">13</span>         } <span style="color: #0000ff">catch</span><span style="color: #000000"> (SQLException e) {
</span><span style="color: #008080">14</span> <span style="color: #000000">            e.printStackTrace();
</span><span style="color: #008080">15</span> <span style="color: #000000">        }
</span><span style="color: #008080">16</span>     }

持久化操作及关闭事务自动提交

 

　　根据上面的两段代码，应该不难知晓。关闭自动提交只需要 conn.setAutoCommit(false) 即可，其次如果事务正常,则事务提交 conn.commit() 如果失败，则需要conn.rollback()

以上便是JDBC的事务处理。

JDBC:事务处理

标签：col   nsis   getc   rman   close   完整性   com   mic   一个