jdbc链接数据库增加删除修改操作事物控制

最新推荐文章于 2023-03-02 16:23:22 发布

weixin_30572613

最新推荐文章于 2023-03-02 16:23:22 发布

阅读量79

点赞数

原文链接：http://www.cnblogs.com/l-liu/p/4578703.html

版权

public void executeUpdateBySql(){
        
    Connection ct = null;
    Statement sta = null;
    
    try {
        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
    } catch (ClassNotFoundException e1) {
        // TODO Auto-generated catch block
        e1.printStackTrace();
    }
    try {
        ct=DriverManager.getConnection("jdbc:sqlserver://192.168.1.119:1433;DatabaseName=lsrzhn","sa","epassport");
        ct.setAutoCommit(false);
        sta = ct.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
    } catch (SQLException e1) {
        // TODO Auto-generated catch block
        e1.printStackTrace();
    }
    try {
        sta.executeUpdate("delete from *********");
        sta.executeUpdate("insert into (***) value (****)");
        sta.executeUpdate("insert into (***) value (****)");
        ct.commit();
    } catch (Exception e) {
        try {
            ct.rollback();
        } catch (SQLException e1) {
            e1.printStackTrace();
        }
    }finally{
        close(null, sta, ct);
    }
}

public static void close(ResultSet rs, Statement sta, Connection ct) {  
        if(rs!=null){  
            try{  
                rs.close();  
                rs=null;  
       }catch(SQLException e){  
                e.printStackTrace();  
            }  
        }  
        if(sta!=null){  
            try{  
                sta.close();  
                sta=null;  
            }catch(SQLException e){  
                e.printStackTrace();  
            }  
        }  
        if(ct!=null){  
            try{  
                ct.close();  
                ct=null;  
            }catch(SQLException e){  
                e.printStackTrace();  
            }  
        }  
    }