项目描述
主要功能有:采购管理、库存管理、销售管理、查询统计、资料管理、系统管理等
运行环境
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;