dbcon.java~4~

宠物医院 JSP项目 我是一个初学者 请大家多多指教

package da0;
import java.sql.*;

public class DBcon {
    private Connection con = null;

    public DBcon() {
    }
    public Connection GetConnection(){
        try {
            String driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver";
		String	url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=petmanage";
            Class.forName(driverClassName);
            con=DriverManager.getConnection(url);



        } catch (Exception ex) {
            ex.printStackTrace();
        }
        finally{
            return con;
        }
    }
    public void CloseRs(ResultSet rs){
        try {
            if(rs!=null){
            rs.close();
        }

        } catch (Exception ex) {
            ex.printStackTrace();
        }

    }
    public void CloseCon(Connection con){
        try {
            if(con!=null){
                con.close();
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }
    public void ClosePs(PreparedStatement ps){
        try {
            if(ps!=null){
                ps.close();
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

}