基于spring boot开发的进销存管理系统

项目描述
主要功能有：采购管理、库存管理、销售管理、查询统计、资料管理、系统管理等
运行环境
jdk8+tomcat8+mysql+eclipse+maven

项目技术
spring boot、JPA、mysql、jQuery

截图：





数据库表：

CREATE TABLE customer (
customer_id bigint(20) NOT NULL AUTO_INCREMENT,
address varchar(255) DEFAULT NULL,
bank varchar(255) DEFAULT NULL,
bank_account bigint(20) DEFAULT NULL,
email varchar(255) DEFAULT NULL,
link_man varchar(255) DEFAULT NULL,
link_tel varchar(255) DEFAULT NULL,
customer_name varchar(255) DEFAULT NULL,
tel_phone varchar(255) DEFAULT NULL,
zip varchar(255) DEFAULT NULL,
PRIMARY KEY (customer_id)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

/*Data for the table customer */

insert into customer(customer_id,address,bank,bank_account,email,link_man,link_tel,customer_name,tel_phone,zip) values (1,‘江西省南昌市昌北经开区’,‘南昌银行’,137347874478935,‘abc@123.com’,‘王琦’,‘123456789’,‘XXX电子上午有限公司’,‘0790-7378785789’,‘3274837’);

/*Table structure for table dept */

DROP TABLE IF EXISTS dept;

CREATE TABLE dept (
dept_id bigint(20) NOT NULL AUTO_INCREMENT,
dept_name varchar(255) DEFAULT NULL,
PRIMARY KEY (dept_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table dept */

/*Table structure for table dept_emp */

DROP TABLE IF EXISTS dept_emp;

CREATE TABLE dept_emp (
dept_dept_id bigint(20) NOT NULL,
emp_employee_id bigint(20) NOT NULL,
PRIMARY KEY (dept_dept_id,emp_employee_id),
UNIQUE KEY UK_qq4f5qwsx62pxd4n9e36o2bo8 (emp_employee_id),
CONSTRAINT FKdoe5h9vyfn8rgkctpgf5187ek FOREIGN KEY (dept_dept_id) REFERENCES dept (dept_id),
CONSTRAINT FKm56w74ah1p47kryw5g8owdcws FOREIGN KEY (emp_employee_id) REFERENCES employee (employee_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table dept_emp */

/*Table structure for table dept_man */

DROP TABLE IF EXISTS dept_man;

CREATE TABLE dept_man (
dept_dept_id bigint(20) NOT NULL,
man_managers_id bigint(20) NOT NULL,
PRIMARY KEY (dept_dept_id,man_managers_id),
UNIQUE KEY UK_kng1bmi31mltq7sp124vbrxw8 (man_managers_id),
CONSTRAINT FKcy4hbwca5nvv48pqmhmtyo9jg FOREIGN KEY (man_managers_id) REFERENCES managers (managers_id),
CONSTRAINT FKrby2ojom9201o9raqmi0ohh9c FOREIGN KEY (dept_dept_id) REFERENCES dept (dept_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table dept_man */

/*Table structure for table employee */

DROP TABLE IF EXISTS employee;

CREATE TABLE employee (
employee_id bigint(20) NOT NULL AUTO_INCREMENT,
employee_age bigint(20) DEFAULT NULL,
employee_gender varchar(255) DEFAULT NULL,
employee_name varchar(255) DEFAULT NULL,
employee_password varchar(255) DEFAULT NULL,
employee_phonenumber varchar(255) DEFAULT NULL,
PRIMARY KEY (employee_id)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;