1. 下载Driver驱动 https://dev.mysql.com/downloads/connector/j/
2. 基本代码
package shop.db;
import java.util.*;
import java.sql.*;
public class connectDb {
public static void main(String []args)
{
try
{
Class.forName("com.mysql.cj.jdbc.Driver");
System.out.println("成功加载mysql");
}
catch(ClassNotFoundException e)
{
System.out.println("没有找到mysql驱动");
e.printStackTrace();
}
String url ="jdbc:mysql://localhost:3306/conferenceData?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false";
Connection conn;
try
{
conn = DriverManager.getConnection(url, "root", "你的密码");
System.out.println("连接db");
Statement cur = (Statement)conn.createStatement();
System.out.println("成功连接数据库");
ResultSet rs= cur.executeQuery("select * from pages");
System.out.println(rs.toString());
while(rs.next())
{
System.out.println(rs.getString("title"));
}
cur.close();
conn.close();
}
catch(SQLException e) {
System.out.println("连接失败");
e.printStackTrace();
}
}
}
3. 注意事项: String ulr的格式很重要 : jdbc:mysqp://localhost:3306/库名?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false
库名后面的是固定的,不能省略,否则会出错。