transaction .txt

来自「jdbc transaction processing」· 文本 代码 · 共 52 行

public boolean addSeatInfo(TSeatInfo ts,String OrderDetailID)throws Exception
{
   boolean b=false;
   Connection conn=null;
   PreparedStatement ps = null;
   Statement st = null;
   ResultSet rs=null;
   try
   {
    conn = DBMgr.getInstance().getConn(); 
    conn.setAutoCommit(false);
   
    String sql="insert into t_seat_info(seq_seat_info_id,Creator,CreateTime,SeatDesc,WhichSell,WhoSell,WhenSell,Num)"
     +"values(seq_seat_info.nextval,?,sysdate,?,?,?,sysdate,?)";
    ps = conn.prepareStatement(sql);
    ps.setString(1,ts.getCreator());
    ps.setString(2,ts.getSeatDesc());
    ps.setString(3,ts.getWhichSell());
    ps.setString(4,ts.getWhoSell());
    ps.setFloat(5,ts.getNum());
    ps.executeUpdate();
   
    st = conn.createStatement();
    String key="";
    rs= st.executeQuery("select seq_seat_info.currval from dual");
    if(rs.next())
    {
     key=rs.getString(1);
    }
   
    sql="update t_order_detail set seq_seat_info_id=? where seq_order_detail_id=?";
    ps = conn.prepareStatement(sql);
    ps.setString(1,key);
    ps.setString(2,OrderDetailID);   
    ps.executeUpdate();
   
    conn.commit();
    b=true;
   
   }
   catch(Exception e)
   {   
    conn.rollback();
    e.printStackTrace();
   }
   finally
   {
    if(ps!=null)
    {
     ps.close();
    }
}