使用JDBC连接Mysql数据库的步骤

-- 创建数据库
create database book_test;
use book_test;
-- 创建图书信息表
create table bookinfo(
book_id int primary key auto_increment,
book_name varchar(20) not null,
price float(6,2) not null,
public_date date not null,
store int not null
);
-- 插入图书数据
insert into bookinfo(book_name,price,public_date,store) values('Android移动应用开发',39.8,'2021-12-26',6);
insert into bookinfo(book_name,price,public_date,store) values('Java程序设计',56.2,'2011-12-26',15);
insert into bookinfo(book_name,price,public_date,store) values('算法与数据结构',20,'2015-02-10',18);

/**
 * @author 蓝多多的小仓库
 * @title: JDBC
 * @projectName ldd_firstpro
 * @description: ldd_annotation
 * @date 2021/12/26 2:29
 */
import java.math.BigDecimal;
import java.sql.*;
public class JDBC {
  //数据库url、用户名和密码
  static final String DB_URL="jdbc:mysql://localhost:3306/book_test?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf-8";
  static final String USER="root";
  static final String PASS="123456";
  public static void main(String[] args) {
    try {
      //1、注册JDBC驱动
      Class.forName("com.mysql.cj.jdbc.Driver");
      //2、获取数据库连接
      Connection connection = DriverManager.getConnection(DB_URL, USER, PASS);
      //3、操作数据库
      Statement statement = connection.createStatement();//获取操作数据库的对象
      String sql="select * from bookinfo";
      ResultSet resultSet = statement.executeQuery(sql);//执行sql，获取结果集
      while(resultSet.next()){ //遍历结果集，取出数据
        int book_id = resultSet.getInt("book_id");
        String book_name = resultSet.getString("book_name");
        BigDecimal price = resultSet.getBigDecimal("price");
        Date public_date = resultSet.getDate("public_date");
        String store = resultSet.getString("store");
        //输出数据
        System.out.print("图书编号："+book_id);
        System.out.print("，图书名称："+book_name);
        System.out.print("，价格"+price);
        System.out.print("，出版日期"+public_date);
        System.out.print(",库存"+store);
        System.out.println();
      }
      //4、关闭结果集、数据库操作对象、数据库连接
      resultSet.close();
      statement.close();
      connection.close();
    } catch (ClassNotFoundException e) {
      e.printStackTrace();
    } catch(SQLException e){
      e.printStackTrace();
    } catch(Exception e){
      e.printStackTrace();
    }
  }
}