图书管理项目

图书管理项目

一、具体表结构

图书管理项目：

图书表:
book_id | book_name | price | store | des | book_type
借出表:
borrow_id | uid | book_id | borrow_date
归还表:
back_id | borrow_id | back_date | delay_money
购买记录表:
book_id | buy_id | buy_date | buy_num | total_price
用户表:
user_id | user_name | grade | phone | user_type
图书类型表:
type_id | type_name | default_date | delay_money_per_day

二、建表语句

CREATE TABLE tb_books (
book_id INT(11) PRIMARY KEY AUTO_INCREMENT,
book_name VARCHAR(20) ,
price DOUBLE(20,2) ,
store INT(20) ,
des VARCHAR(200),
book_type INT(11)
)

CREATE TABLE tb_borrow (
book_id INT(11) PRIMARY KEY AUTO_INCREMENT,
borrow_id INT(11) ,
borrow_date DATE ，
back_date DATE ，
delay_money` DOUBLE(50,2)
)```

CREATE TABLE tb_back (
book_id INT(11) PRIMARY KEY AUTO_INCREMENT,
borrow_id INT(11),
back_date DATE ,
delay_money DOUBLE(50,2),
)

CREATE TABLE tb_buy (
book_id INT(11) PRIMARY KEY AUTO_INCREMENT,
buy_id INT(11) ,
buy_date DATE ,
buy_num INT(50) ,
total_price DOUBLE(50,2)
)

CREATE TABLE tb_user (
user_id INT(11) PRIMARY KEY AUTO_INCREMENT,
user_name VARCHAR(20),
grade VARCHAR(20),
phone VARCHAR(50),
user_type INT(11)
)

CREATE TABLE tb_booktype (
type_id INT(11) PRIMARY KEY AUTO_INCREMENT,
type_name VARCHAR(20),
default_date DATE,
delay_money_per_day DOUBLE(50,2),
)

三、Mybatis连接数据库

1）导入相关的jar包

2）编写对应的实体类、

/**
 * @Author Cuimuhan
 * @Date 2020/6/15
 * @Description
 */
package cn.kgc.kb07.entity;

public class Books {
   
    private int book_id;
    private String book_name;
    private double price;
    private int store;
    private String des;
    private int book_type;

    public Books() {
   
    }

    public Books(int book_id, String book_name, double price, int store, String des, int book_type) {
   
        this.book_id = book_id;
        this.book_name = book_name;
        this.price = price;
        this.store = store;
        this.des = des;
        this.book_type = book_type;
    }

    public int getBook_id() {
   
        return book_id;
    }

    public void setBook_id(int book_id) {
   
        this.book_id = book_id;
    }

    public String getBook_name() {
   
        return book_name;
    }

    public void setBook_name(String book_name)