能做事務的JdbcUtils工具

標籤：jdbc   事務   filter   jdbcutils   

JdbcUtils工具類的封裝

package cn.wht.utils;import java.sql.Connection;import java.sql.SQLException;import javax.sql.DataSource;import com.mchange.v2.c3p0.ComboPooledDataSource;public class JdbcUtils {private static DataSource dataSource=null;                             //資料來源private static final ThreadLocal<Connection> threadLocal=new ThreadLocal<Connection>();   //綁定串連的線程容器static{dataSource=new ComboPooledDataSource();}/** * 擷取串連池 * @return */public static DataSource getDataSource(){return dataSource;}/** * 擷取串連 * @return 資料庫的一個串連 */public static Connection  getConnection(){try {Connection connection=threadLocal.get();if(connection==null){connection=dataSource.getConnection();threadLocal.set(connection);return connection;}else{return connection;} } catch (SQLException e) {throw new RuntimeException(e);}}/** * 關閉串連 */public static void close(){Connection connection=threadLocal.get();if(connection!=null){try {connection.close();} catch (SQLException e) {throw new RuntimeException(e);}finally{threadLocal.remove();}}}/** *  * 開啟事務 */public static void startTransaction(){try {Connection connection=getConnection();threadLocal.set(connection);connection.setAutoCommit(true);} catch (SQLException e) {throw new RuntimeException(e);}}/** * 提交事務 */public static void commit(){try {Connection connection=threadLocal.get();if(connection!=null){connection.commit();}} catch (SQLException e) {throw new RuntimeException(e);}}/** * 復原事務 */public static void rollback(){try {Connection connection=threadLocal.get();if(connection!=null){connection.rollback();}} catch (SQLException e) {throw new RuntimeException(e);}}}

這Filter中做事務

package cn.wht.filter;import java.io.IOException;import javax.servlet.Filter;import javax.servlet.FilterChain;import javax.servlet.FilterConfig;import javax.servlet.ServletException;import javax.servlet.ServletRequest;import javax.servlet.ServletResponse;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import cn.wht.utils.JdbcUtils;public class OpenTransactionInViewFilter implements Filter {@Overridepublic void init(FilterConfig filterConfig) throws ServletException {// TODO Auto-generated method stub}@Overridepublic void doFilter(ServletRequest request, ServletResponse response,FilterChain chain) throws IOException, ServletException {// TODO Auto-generated method stubrequest=(HttpServletRequest) request;response=(HttpServletResponse) response;try{JdbcUtils.startTransaction();chain.doFilter(request, response);JdbcUtils.commit();}catch(Exception e){JdbcUtils.rollback();//跳轉到錯誤頁面                        request.getRequestDispatcher("/error.jsp").forward(request, response);}finally{JdbcUtils.close();}}@Overridepublic void destroy() {// TODO Auto-generated method stub}}

能做事務的JdbcUtils工具