transdao.java

oa rar it is the jsp

package com.accp.oa.dao.imple;

import java.sql.*;

import com.accp.oa.common.*;

/**
 * 这个是事务处理类,用于删除记录
 *
 */
public class TransDAO {
	private static Connection con;
	/**
	 * 获得一个连接
	 * @return 返回一个连接
	 * @throws Exception 抛出一个异常
	 */
	public static Connection getConnection() throws Exception{
		if(con == null || con.isClosed()){
			con = DbUtil.connectToDB();
		}
		con.setAutoCommit(false);
		return con;
	}
	/**
	 * 提交事务
	 *
	 */
	public static void myCommit(){
		try {
			con.commit();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	/**
	 * 回滚事务
	 *
	 */
	public static void myrollback(){
		try {
			con.rollback();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	/**
	 * 关闭连接
	 *
	 */
	public static void myClose(){
		if(con != null){
			try {
				con.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}

}