一、导包
链接:https://pan.baidu.com/s/1iqerhiKSeH1I0SXu1NQHpg?pwd=rt7w
提取码:rt7w
二、代码
import java.sql.*;
public class Test {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
//1.加载驱动
Class.forName("com.mysql.cj.jdbc.Driver");
//2.获取连接
String url="jdbc:mysql://127.0.0.1:3306/book_store?serverTimezone=UTC&characterEncoding=utf-8";
String username="root";
String password="123456";
Connection conn= DriverManager.getConnection(url,username,password);
//3.创建会话
Statement sta=conn.createStatement();
//4.发送SQl
// int i = sta.executeUpdate("insert into t_book(id,name,author,price) values(2,\"西游记\",\"吴承恩\",39.9);");
ResultSet rs = sta.executeQuery("select * from t_book;");
//5.处理结果
// if(i>0){ //证明对数据库的数据条数有影响
// System.out.println("插入成功!");
// }else{
// System.out.println("插入失败!");
// }
while (rs.next()){ //判断是否有记录存在
System.out.println(rs.getInt("id")+"---"+rs.getString("name")+"---"+rs.getString("author")+"---"+rs.getDouble("price"));
}
//6.关闭资源
sta.close();
conn.close();
}
}