JDBC一简单饭卡系统

本文简单写了一个饭卡系统,简单实现了功能,还有很多功能要完善,分享给大家参考

上面这是项目的目录

我们先来看这个项目所需要建立的表、数据库

建立表的代码:

CREATE TABLE `tb_admin`  (

id` int(11) NOT NULL,

`username` varchar(255) CHARACTER SET utf8mb4 COLLATE 

utf8mb4_bin NULL DEFAULT NULL,

password` varchar(255) CHARACTER SET utf8mb4 COLLATE 

utf8mb4_bin NULL DEFAULT NULL,

PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

---

CREATE TABLE `tb_consumption`  (

`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '消费编号',

`type` int(11) NOT NULL COMMENT '消费类型',

`money` double(7, 2) NOT NULL COMMENT '消费金额',

`date` datetime NOT NULL COMMENT '消费时间',

consid` char(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '关联的学生',

PRIMARY KEY (`id`) USING BTREE,

 INDEX `sid`(`consid`) USING BTREE,
 
 CONSTRAINT `tb_consumption_ibfk_1` FOREIGN KEY (`consid`) REFERENCES `tb_meal_card` (`sid`) ON DELETE RESTRICT ON UPDATE RESTRICT
 
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

---

CREATE TABLE `tb_meal_card`  (

sid` char(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '学生学号',

sname` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '学生姓名',

`className` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '班级',

`money` double(7, 2) NOT NULL DEFAULT 0.00 COMMENT '饭卡的余额',

password` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '密码',

numOfBankCard` double(7, 2) NOT NULL DEFAULT 0.00 COMMENT '饭卡绑定卡的银行卡的余额',

 PRIMARY KEY (`sid`) USING BTREE
 
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

---

建完表我们来写项目代码

一、我们先建立一个properties文件

driverClass = com.mysql.jdbc.Driver
url = jdbc:mysql://localhost:3306/meal_card_system?useUnicode=true&characterEncoding=utf8&useSSL=false
username = root
password = 123456
这里要注意的是自己要数据库的名、用户名、密码,自行更改

二、建立实体类

pojo层

管理类

public class Admin {
private int id;
private String username;
private String password;

public Admin() {
}

public String getUsername() {
    return username;
}

public void setUsername(String username) {
    this.username = username;
}

public String getPassword() {
    return password;
}

public void setPassword(String password) {
    this.password = password;
}

@Override
public String toString() {
    return "Admin{" +
            "id=" + id +
            ", username='" + username + '\'' +
            ", password='" + password + '\'' +
            '}';
}
}

---

饭卡类:

public class MealCard {
private String sid;
private String sname;
private String className;
private double money;
private String password;
private double numOfBankCard;

public MealCard() {
}

public MealCard(String sid, String sname, String className, double money, String password, double numOfBankCard) {
    this.sid = sid;
    this.sname = sname;
    this.className = className;
    this.money = money;
    this.password = password;
    this.numOfBankCard = numOfBankCard;
}

public String getSid() {
    return sid;
}

public void setSid(String sid) {
    this.sid = sid;
}

public String getSname() {
    return sname;
}

public void setSname(String sname) {
    this.sname = sname;
}

public String getClassName() {
    return className;
}

public void setClassName(String className) {
    this.className = className;
}

public double getMoney() {
    return money;
}

public void setMoney(double money) {
    this.money = money;
}

public String getPassword() {
    return password;
}

public void setPassword(String password) {
    this.password = password;
}

public double getNumOfBankCard() {
    return numOfBankCard;
}

public void setNumOfBankCard(double numOfBankCard) {
    this.numOfBankCard = numOfBankCard;
}

@Override
public String toString() {
    final StringBuilder sb = new StringBuilder("MealCard").append('[')
            .append("sid=")
            .append(sid)
            .append("sname=")
            .append(sname)
            .append(",username=")
            .append(className)
            .append(",className=")
            .append(className)
            .append(",money=")
            .append(money)
            .append(",money=")
            .append(money)
            .append(",password=")
            .append(password)
            .append(",numOfBankCard")
            .append(numOfBankCard