jdbc连接数据库 DBUtil

package com.zuoye0831;

import java.sql.*;

/**
 * 作者：猛男
 * 时间：2022-08
 */
public class DBUtil {
    static{//类加载执行一次

        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            throw new RuntimeException(e);
        }
    }
//获得连接
    public static Connection getConnectionInstance() {
       Connection connection = null;
        try {
            connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/student_message", "root", "123456");

        } catch (Exception e) {
            e.printStackTrace();
        }
        return connection;
    }
    //释放资源
    public static void CloseAll(Connection connection, Statement statement, ResultSet resultSet){
        try {
            if(resultSet!=null){
                resultSet.close();
            }
            if(statement!=null){
                statement.close();
            }
            if(connection!=null){
                connection.close();
            }
        } catch (SQLException e) {
           e.printStackTrace();
        }
    }

}

第二种

package com.zuoye0831;

import java.io.IOException;
import java.io.InputStream;
import java.sql.*;
import java.util.Properties;

/**
 * 作者：猛男
 * 时间：2022-08
 */
public class DBUtil {

        private static final Properties PROPERTIES = new Properties();//存储配置文件的map

        static {

            InputStream is = DBUtil.class.getResourceAsStream("/db.properties");

            try {
                PROPERTIES.load(is);//通过流，将配置文件内容加载到properties集合
                Class.forName(PROPERTIES.getProperty("driver"));
            } catch (IOException e) {
                e.printStackTrace();
            } catch (ClassNotFoundException e) {
                e.printStackTrace();
            }
        }

        public static Connection getConnection() {
            Connection connection = null;
            try {
                connection = DriverManager.getConnection(PROPERTIES.getProperty("url"), PROPERTIES.getProperty("user"), PROPERTIES.getProperty("password"));
            } catch (SQLException e) {
                e.printStackTrace();
            }
            return connection;
        }

        public static void closeAll(Connection connection, Statement statement, ResultSet resultSet) {
            try {
                if (resultSet != null) {
                    resultSet.close();
                }
                if (statement != null) {
                    statement.close();
                }
                if (connection != null) {
                    connection.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }

    }

db.properties文件

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/shopping
user=root
password=123456