import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.SQLException;
public class Conn {
Connection con;
//驱动程序名
String driver = "com.mysql.jdbc.Driver";
//URL指向要访问的数据库
String url = "jdbc:mysql://localhost:3306/mysql";
//MySQL配置时的用户名
String user = "root";
//MySQL配置时的密码
String password = "root";
public Connection getConnection(){
try {
Class.forName(driver);
System.out.println("数据库驱动加载成功");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
try {
DriverManager.getConnection(url,user,password);
System.out.println("数据库连接成功");
} catch (SQLException e) {
e.printStackTrace();
}
return con;
}
public static void main(String[] args) {
Conn c=new Conn();
c.getConnection();
}
}
pom文件添加依赖
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.24</version>
</dependency>
注意mysql-connector-java的版本号,若是版本过高会出现如下错误
Unknown system variable ‘language’
改低版本即可