java jdbc连接sql server

package com.userInfo.commons;

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

public class BaseDao {
    private Connection conn=null;
    private ResultSet rs=null;
    private PreparedStatement ps=null;
    public Connection getConn(){
        try {
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            
                conn=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=clubDB","用户名","密码");
        } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
         catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return conn;
    }
    public void Allclose(){
        
            try {
                if(rs !=null){
                rs.close();
                }
                if(ps !=null){
                    ps.close();
                }
                if(conn !=null){
                    conn.close();
                }
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
    }
    public int executeUpdate(String sql,Object []params){
        int rset=0;
        this.getConn();
        try {
            ps=conn.prepareStatement(sql);
            if(params !=null && params.length!=0){
                for (int i = 0; i < params.length; i++) {
                    ps.setObject(i+1,params[i]);
                }
            }
            rset=ps.executeUpdate();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }finally{
            this.Allclose();
        }
        return rset;
    }
    public ResultSet executeQuery(String sql,Object[]params) throws SQLException{
        this.getConn();
        ps=conn.prepareStatement(sql);
        if(params !=null && params.length !=0){
            for (int i = 0; i < params.length; i++) {
                ps.setObject(i+1, params[i]);
            }
        }
        rs=ps.executeQuery();
        return rs;
    }
}