银行营业网点管理系统——dao包（BaseDao）

package BranchesMgr.dao;  
/** 
 * 数据库操作类 
 * @author Administrator 
 * 
 */  
import java.sql.*;  
import java.util.List;  
public class BaseDao {  
    Connection conn=null;  
    PreparedStatement ps=null;  
    ResultSet rs=null;  
    public void getConnection(){  
        try {  
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");  
        } catch (ClassNotFoundException e) {  
            // TODO Auto-generated catch block  
            e.printStackTrace();  
        }  
        if(conn==null){  
            try {  
                conn=DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;databasename=CityDB;User=sa;Password=171268");  
            } catch (SQLException e) {  
                // TODO Auto-generated catch block  
                e.printStackTrace();  
            }  
        }  
    }  
      
    //增删改  
    public int excuteUpdate(String sql,List<Object> prams) throws SQLException{  
        int rel=0;  
        getConnection();  
        ps=conn.prepareStatement(sql);  
        if(prams!=null){  
            for (int i = 0; i < prams.size(); i++) {  
                ps.setObject(i+1, prams.get(i));  
            }  
        }  
         rel=ps.executeUpdate();  
        return rel;  
    }  
      
    //查询  
    public ResultSet excuteQurey(String sql,List<Object>prams) throws SQLException{  
        getConnection();  
        ps=conn.prepareStatement(sql);  
        if(prams!=null){  
            for (int i = 0; i < prams.size(); i++) {  
                ps.setObject(i+1, prams.get(i));  
            }  
        }  
        rs=ps.executeQuery();  
        return rs;  
    }  
  
    //关闭资源  
    public void closeAll(){  
        if(rs!=null){  
            try {  
                rs.close();  
            } catch (SQLException e) {  
                // TODO Auto-generated catch block  
                e.printStackTrace();  
            }  
        }  
        if(ps!=null){  
            try {  
                ps.close();  
            } catch (SQLException e) {  
                // TODO Auto-generated catch block  
                e.printStackTrace();  
            }  
        }  
        if(conn!=null){  
            try {  
                conn.close();  
                conn=null;  
            } catch (SQLException e) {  
                // TODO Auto-generated catch block  
                e.printStackTrace();  
            }  
        }  
    }  
}