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;}}