jdbc事务工具类

/** * 工具类 提供数据库连接池 和数据库连接 */public class JDBCUtils {private static DataSource dataSource = new ComboPooledDataSource();public static DataSource getDataSource() {return dataSource;}/** * 当DBUtils需要手动控制事务时，调用该方法获得一个连接 */public static Connection getConnection() throws SQLException {return dataSource.getConnection();}}public class TransactionUtils {private static ThreadLocal<Connection> threadLocal = new ThreadLocal<Connection>();public synchronized static Connection getConnection() throws SQLException{if(threadLocal.get() == null){threadLocal.set(JDBCUtils.getConnection());}return threadLocal.get();}public static synchronized void commitAndClose(){Connection conn = threadLocal.get();try {conn.commit();conn.close();threadLocal.remove();} catch (SQLException e) {e.printStackTrace();}}public static synchronized void roolbackAndClose(){Connection conn = threadLocal.get();try {conn.rollback();conn.setAutoCommit(true);conn.close();threadLocal.remove();} catch(SQLException e){e.printStackTrace();}}}