Java连接数据库工具类

JDBC连接数据库工具类

import java.net.URL;
import java.sql.*;

public final class JdbcUtil {
    
    private static String  url ="jdbc:postgresql://localhost:5432/test";
    private static String userName ="postgres";
    private static String passWord ="postgres";

    //构造方法私有化，阻止外部直接实例化对象
    private JdbcUtil( ){

    }
    
    //静态代码块，类加载到虚拟机，只执行一次  注册驱动
    static {
        try {
            Class.forName("org.postgresql.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }
    
   //获取连接
    public static Connection getConnection() {
        Connection conn = null;
        try {
            conn =  DriverManager.getConnection(url,userName,passWord);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return conn;
    }

    //释放资源，重载方法
    public static void close(Connection conn) {
        try {
            if(conn != null){
                conn.close();
                conn = null;
            }
        }catch(SQLException e){
            e.printStackTrace();
        }
    }
    
    public static void close(Statement stmt){
        try{
            if(stmt != null){
                stmt.close();
                stmt = null;
            }
        }catch(SQLException e){
            e.printStackTrace();
        }
    }
    
    public static void close(ResultSet  rs){
        try{
            if(rs != null){
                rs.close();
                rs = null;
            }
        }catch (SQLException e) {
            e.printStackTrace();
        }
    }
}