1.首先需要配置驱动mysql-connector-java-5.1.6.jar
找到如下路径File->Project Structure->Modules
找到mysql-connector-java-5.1.6.jar,添加进来
加载完成后
配置完成左边lib下就会显示出来:
这样就配置好了,下面开始测试。
public class MyConnectionTest {
private Connection con;
public Connection getConnection(){
try {
Class.forName("com.mysql.jdbc.Driver");
this.con = DriverManager.getConnection("jdbc:mysql://localhost:3306/personal","root","123456");
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
return this.con;
}
public void closeConnection(){
try {
this.con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void main(String[] args) {
MyConnectionTest con = new MyConnectionTest();
System.out.println(con.getConnection());
con.closeConnection();
}
}
最后出现如下类似结果即可表明连接成功: