JAVA_BaseDAO數據處理類，java_basedao

JAVA_BaseDAO數據處理類，java_basedao

package dao;

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


public class BaseDao {
    private String drive="com.microsoft.sqlserver.jdbc.SQLServerDriver";
    private String url="jdbc:sqlserver://localhost:1433;DatabaseName=BookManage";
    private String user="sa";
    private String password="";
    protected Connection conn;
    protected PreparedStatement ps;
    protected ResultSet rs;
    public Connection getCon(){
        try {
            Class.forName(drive);
            conn=DriverManager.getConnection(url, user, password);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        
        return conn;
    }
    public void allClos(ResultSet rs,PreparedStatement ps,Connection conn){
    
            try {
                if(rs!=null){
                rs.close();
                }
                if(ps!=null){
                    ps.close();
                    }
                if(conn!=null){
                    conn.close();
                    }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
public int executeUpdate(String sql,Object...str){
    int num=0;
    try {
        ps=getCon().prepareStatement(sql);
        if(ps!=null){
            for(int i=0;i<str.length;i++){
                ps.setObject(i+1, str[i]);            }
        }
        num=ps.executeUpdate();
    } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }finally 
    {
        allClos(rs, ps, conn);
    }
    return num;
}

}