JDBC实现水果库存管理（非WEB）2-脚本及实体类

一、创建库及相关表的脚本（MYSQL版本）

CREATE DATABASE `fruitdb`;

CREATE TABLE `t_fruit` (
  `fid` int(11) NOT NULL AUTO_INCREMENT,
  `fname` varchar(20) NOT NULL,
  `price` int(11) DEFAULT NULL,
  `fcount` int(11) DEFAULT NULL,
  `remark` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`fid`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;

insert  into `t_fruit`
(`fid`,`fname`,`price`,`fcount`,`remark`) 
values 
(2,'西瓜',3,31,'西瓜很好吃'),
(4,'菠萝',5,63,'OK'),
(8,'红富士',5,50,'红富士很好吃'),
(9,'香蕉',3,50,'香蕉很好吃'),
(10,'榴莲',19,100,'榴莲是一种神奇的水果'),
(11,'山竹',8,55,'山竹是一种神奇的水果'),
(12,'甘蔗',7,100,'甘蔗是一种神奇的水果'),
(13,'萝卜',5,55,'萝卜是一种神奇的水果'),
(14,'圣女果',3,99,'好吃'),
(15,'哈密瓜',7,77,'哈密瓜很好吃'),
(16,'火龙果',5,66,'好吃'),
(33,'猕猴桃',15,100,'猕猴桃是水果之王'),
(34,'榴莲',15,100,'榴莲是一种神奇的水果');

二、新建实体类

1、右击src，选择new，点击Java Class 

2、在弹出的窗口中输入包名和类名后点击回车，实体类就创建好了

 3、根据Fruit表字段，添加实体类的变量，然后添加get、set方法，添加构造方法，重写toString方法

package com.happyStudy.fruit.pojo;

public class Fruit {
    //主键编号
    private Integer fid;
    //水果名称
    private String fname;
    //水果单价
    private Integer price;
    //水果库存量
    private Integer fcount;
    //备注
    private String remark;

    public Fruit() {
    }

    public Fruit(Integer fid, String fname, Integer price, Integer fcount, String remark) {
        this.fid = fid;
        this.fname = fname;
        this.price = price;
        this.fcount = fcount;
        this.remark = remark;
    }

    public Integer getFid() {
        return fid;
    }

    public void setFid(Integer fid) {
        this.fid = fid;
    }

    public String getFname() {
        return fname;
    }

    public void setFname(String fname) {
        this.fname = fname;
    }

    public Integer getPrice() {
        return price;
    }

    public void setPrice(Integer price) {
        this.price = price;
    }

    public Integer getFcount() {
        return fcount;
    }

    public void setFcount(Integer fcount) {
        this.fcount = fcount;
    }

    public String getRemark() {
        return remark;
    }

    public void setRemark(String remark) {
        this.remark = remark;
    }

    @Override
    public String toString() {
        return "Fruit{" +
                "fid=" + fid +
                ", fname='" + fname + '\'' +
                ", price=" + price +
                ", fcount=" + fcount +
                ", remark='" + remark + '\'' +
                '}';
    }
}

到此为止，实体类已经完成