本文内容

• 复制粘贴,然后运行main文件,快速确定数据库是否能正常连接
• 记得检查是否已经导入驱动jar包

前置知识

• JDBC
• Eclipse/IDEA 等工具

package club.test;
import java.sql.*; 
public class TestMySQLConnection { 
  
  public static void main(String[] args) { 
        String driver = "com.mysql.jdbc.Driver";
        String URL = "jdbc:mysql://localhost:3306/test_2019?useSSL=false";//数据库地址,注意数据库名称.useSSL=false 不加就报一个警告
        String username="root";//用户名
        String password="123456";//密码
        Connection conn = null;
        try {
            Class.forName(driver);
        } catch (java.lang.ClassNotFoundException e) {
            System.out.println("Connect Successful.");
            System.out.println("Cant't load Driver");
        }
        try {
            conn = DriverManager.getConnection(URL, username, password);
            System.out.println("Connect Successful.");
        } catch (Exception e) {
            System.out.println("Connect fail:" + e.getMessage());
        }finally {
            try {
                conn.close();
            } catch (Exception e2) {
                System.out.println("Close Connection error.");
            }
        }

    }
}