一个简单的dbutil类

public class DBConn {
    private final static String DRIVER = "com.microsoft.jdbc.sqlserver.SQLServerDriver";                 // 数据库驱动
    private final static String URL    = "jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=medical";   // url
    private final static String DBNAME = "sa";                                                           // 数据库用户名
    private final static String DBPASS = "";                                                           // 数据库密码
    public static DBConn DB=new DBConn();
    /**
     * 得到数据库连接
     * @throws ClassNotFoundException
     * @throws SQLException
     * @return 数据库连接
     */
    public Connection getConn() throws ClassNotFoundException, SQLException{
        Class.forName(DRIVER);                                                    //注册驱动
        Connection conn = DriverManager.getConnection(URL,DBNAME,DBPASS);        //获得数据库连接
        return conn ; 
}
    /**
     * 释放资源
     * @param conn 数据库连接
     * @param pstmt PreparedStatement对象
     * @param rs 结果集
     */
    public void closeAll( Connection conn, PreparedStatement pstmt, ResultSet rs ) {
        /*  如果rs不空，关闭rs  */
        if(rs != null){
            try { rs.close();} catch (SQLException e) {e.printStackTrace();}
        }
        /*  如果pstmt不空，关闭pstmt  */
        if(pstmt != null){
            try { pstmt.close();} catch (SQLException e) {e.printStackTrace();}
        }
        /*  如果conn不空，关闭conn  */
        if(conn != null){
            try { conn.close();} catch (SQLException e) {e.printStackTrace();}
        }
    }
}