BaseDao.java

package com.wolf.pub;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

/**
 *
 * @author zhengbin
 */
public abstract  class BaseDao {
    protected Connection conn=null;

    protected BaseDao(){
        conn=localConnect.getConnection();
    }
    //回滚
    protected void rollback() throws SQLException{
        if(conn==null){
            throw new SQLException();
        } else{
            conn.rollback();
        }
    }
    //提交
    protected void commit() throws SQLException{
        if(conn==null){
            throw new SQLException();
        } else{
            conn.commit();
        }
    }
    //创建PreparedStatement
    protected PreparedStatement PreparedStatement(String sql) throws SQLException{
        if(conn==null){
            throw new SQLException();
        }else{
            return conn.prepareStatement(sql);
        }
    }
    //
    public void close(){
        if (conn!=null){
            try{
               conn.close();
            }catch(SQLException e){
               e.printStackTrace();
        }  }
    }
}