JDBCUtils 工具类

水深无声 2022-04-06 05:58 199阅读 0赞

package com.SiyualChen.day06.homeWorkNumb;
    
    
    import java.io.FileReader;
    import java.io.IOException;
    import java.sql.*;
    import java.util.Properties;
    
    public class JDBCUtils {
        private static final String driverClassName;
        private static  final String USERNAME;
        private static final String PASSWORD;
        private static final String URL;
    
        static{
            Properties properties = new Properties();
            try {
                properties.load(new FileReader("/Users/chensiyuan/IdeaProjects/strong/db.properties"));
            } catch (IOException e) {
                e.printStackTrace();
            }
            driverClassName = properties.getProperty("driverClassName");
            USERNAME = properties.getProperty("username");
            PASSWORD=properties.getProperty("password");
            URL = properties.getProperty("url");
        }
    
        public static void loadDriver(){
            try {
                Class.forName(driverClassName);
            } catch (ClassNotFoundException e) {
                e.printStackTrace();
            }
        }
        public static Connection getConnection(){
            Connection conn=null;
            loadDriver();
            try {
                conn= DriverManager.getConnection(URL, USERNAME, PASSWORD);
            } catch (SQLException e) {
                e.printStackTrace();
            }
            return conn;
        }
    
        public static void release(Statement stmt,Connection conn){
            if(stmt != null){
                try {
                    stmt.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
                stmt=null;
    
            }
            if (conn != null){
                try {
                    conn.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
                conn =null;
            }
    
        }
    
        public static void  release(ResultSet rs,Statement stmt,Connection conn){
            if (rs!=null){
                try {
                    rs.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
                rs =null;
            }
            release(stmt,conn);
        }
    
    }