先去下载与Mysql数据库版本匹配的架包,然后导入到项目中,在这里我用的是Mysql8.0
Mysql8.0的驱动类名是 com.mysql.cj.jdbc.Driver
首先新建一个Demo类,然后进行数据库的连接即检验,代码如下
package cb.meizu.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class Demo {
private static String driver = "com.mysql.cj.jdbc.Driver"; //获取mysql 8.0数据库的驱动类
private static String url = "jdbc:mysql://localhost:3306/meizu?useSSL=false&serverTimezone=UTC&allowPublicKeyRetrieval=true"; //连接数据库(meizu是数据库名)
private static String name = "root";//连接mysql的用户名
private static String pwd = "123456";//连接mysql的密码
static {
try {
Class.forName(driver); //加载JDBC驱动程序
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static Connection getConnection(){
try{
Connection conn = DriverManager.getConnection(url,name,pwd);//获取连接对象
return conn;
}catch(SQLException e){
e.printStackTrace();
return null;
}
}
public static void closeAll(Connection conn,PreparedStatement psmt,ResultSet rs){
try{
if(rs!=null){
rs.close();
}
}catch(SQLException e){
e.printStackTrace();
}
try{
if(psmt!=null){
psmt.close();
}
}catch(SQLException e){
e.printStackTrace();
}
try{
if(conn!=null){
conn.close();
}
}catch(SQLException e){
e.printStackTrace();
}
}
public static void main(String[] args) throws SQLException {
Connection conn = null;
PreparedStatement psmt = null;
ResultSet rs = null;
conn = Demo.getConnection();
String sql = "select * from user"; //sql语句,从user表中查询
psmt = conn.prepareStatement(sql);
rs = psmt.executeQuery();
if(!conn.isClosed()) {
System.out.println("Succeeded connecting to the Database!");
}
//将查询结果输出
while(rs.next()) {
System.out.println(rs.getString("username")); //查询username这一列的值
}
}
}