java技术点

java 连接 SQL

Connection con = null;
try {
con = DBConnectPoolFactory.getInstance().getConnection();
String sql = "select * from table where id =?";
uh.bindParam(id);
UpdateHelper uh = new UpdateHelper(sql);
con.commit();
} catch (Exception e) {
    try {
        con.rollback();
    } catch (Exception e) {
        e.printStackTrace();
    }
}finally {
    try {
        con.close();
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

三部曲
con.commit();//提交事务
con.rollback(); //事务回滚
con.close();//关闭事务