1.找到驱动对应MySQL版本的的jar包
https://mvnrepository.com/artifact/mysql/mysql-connector-java
2.Idea创建新目录lib并把jar包放进来
3.把jar压入库中
4.执行语句
public static void main(String[] args) throws ClassNotFoundException, SQLException {
//1.加载驱动
Class.forName("com.mysql.jdbc.Driver");//固定写法,加载驱动
//2.用户信息和url
/*
注意 "jdbc:mysql//localhost;3306/
[这里填写的是database名]
?useUnicode=true&characterEncoding=utf8&useSSL=true"
*/
String url = "jdbc:mysql://localhost:3306/book_system?useUnicode=true&characterEncoding=utf8&useSSL=true";
String username = "root";
String password = "123456";
//3.连接成功,数据库对象
Connection connection = DriverManager.getConnection(url,username,password);
//4.执行sql的对象 statement 执行sql的对象
Statement statement = connection.createStatement();
//5.执行SQL的对象 去执行SQL ,可能存在结果,查看返回结果
String sql = "SELECT * FROM teacher";
ResultSet resultSet = statement.executeQuery(sql);
while(resultSet.next()){
System.out.println("num="+resultSet.getObject("num"));
System.out.println("pwd="+resultSet.getObject("sw"));
System.out.println("name="+resultSet.getObject("name"));
System.out.println("sex="+resultSet.getObject("teacher_sex"));
System.out.println("address="+resultSet.getObject("teacher_address"));
System.out.println("birth="+resultSet.getObject("teacher_birthday"));
System.out.println("email="+resultSet.getObject("teacher_email"));
}
//6.释放连接
resultSet.close();
statement.close();
connection.close();
}
5.执行语句,完成
对比MySQL内的表格(剩下的留给前端处理就行)