JSP | 基础 | 连接数据库

 

package util;

import java.sql.DriverManager;
import java.sql.SQLException;

import com.mysql.jdbc.*;



public class DBConfgier {
                         
    private static final String driver = "com.mysql.jdbc.Driver";
    //定义连接URL、数据用户及密码
    private static final String dbURL = "jdbc:mysql://localhost:3306/School_info?characterEncoding=utf8&useSSL=true&serverTimezone=UTC";
    private static final String dbUser = "root";
    private static final String dbPassword = "root";
            
    private static Connection conn = null;
    
    
    //载入JDBC驱动程序
    static
    {
        try
        {
            Class.forName("com.mysql.jdbc.Driver");
        } catch(Exception ex) {
            ex.printStackTrace();
        }
    }
    
    
    public static Connection getConnnection() throws Exception {
        if(conn == null) {
            conn =  (Connection) DriverManager.getConnection(dbURL, dbUser, dbPassword);
            return conn;
        }
        return conn;
    }

    public static void main(String[] args) throws Exception {
        Connection conn = DBConfgier.getConnnection();
        if(conn != null) {
            System.out.println("连接成功！");
        } else {
            System.out.println("连接失败！");
        }
    }
    
            
            
}