Java+SSM+JSP+Mysql+Tomcat实现Web药品

2022-03-18 本文已影响0人水坚石青

一、系统介绍
1.开发环境
开发工具：IDEA2018

JDK版本：Jdk1.8

Mysql版本：8.0.13

2.技术选型
Java+Jsp+Mysql

3.系统功能
1.登录系统；

2.管理员对人员的增删改查，管理员对进药信息的增删改查，管理员对售药信息的增删改查，管理员对库存信息的管理；

3.销售人员对售药信息的增删改查，对库存信息的管理；

4.仓库人员对进药信息的增删改查，对库存信息的管理；

4.数据库文件
/*
Navicat Premium Data Transfer
Source Server : MySQL
Source Server Type : MySQL
Source Server Version : 80013
Source Host : 127.0.0.1:3306
Source Schema : ssm_medicine_management
Target Server Type : MySQL
Target Server Version : 80013
File Encoding : 65001
Date: 19/02/2022 19:55:57
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- Table structure for log4

DROP TABLE IF EXISTS log4;
CREATE TABLE log4 (
date varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
category varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
message varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- Records of log4

-- Table structure for saledrug

DROP TABLE IF EXISTS saledrug;
CREATE TABLE saledrug (
id int(11) NOT NULL AUTO_INCREMENT,
customer_id varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
drug_id varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
sale_number int(11) NULL DEFAULT NULL,
date varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
price double NULL DEFAULT NULL,
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- Records of saledrug

INSERT INTO saledrug VALUES (7, '1', '1003', 10, '2022-02-19', 20);
INSERT INTO saledrug VALUES (8, '2', '1004', 20, '2022-02-19', 10);

-- Table structure for stockdrug

DROP TABLE IF EXISTS stockdrug;
CREATE TABLE stockdrug (
id int(11) NOT NULL AUTO_INCREMENT,
bill_id varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
drug_id varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
price double NULL DEFAULT NULL,
buy_num int(11) NULL DEFAULT NULL,
date varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
supplier varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 42 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- Records of stockdrug

INSERT INTO stockdrug VALUES (42, '2', '1003', 10, 200, '2022-02-19', '北京医药厂');
INSERT INTO stockdrug VALUES (43, '1', '1002', 30, 300, '2022-02-19', '武汉医药厂');
INSERT INTO stockdrug VALUES (44, '3', '1004', 5, 500, '2022-02-19', '长沙医药厂');

-- Table structure for user

DROP TABLE IF EXISTS user;
CREATE TABLE user (
id int(11) NOT NULL AUTO_INCREMENT,
username varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
password varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
usertype int(11) NULL DEFAULT NULL,
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- Records of user

INSERT INTO user VALUES (1, 'admin', 'admin', 0);
INSERT INTO user VALUES (11, 'saler', '123456', 1);
INSERT INTO user VALUES (28, 'warehouser', '123456', 2);

-- Table structure for warehouse

DROP TABLE IF EXISTS warehouse;
CREATE TABLE warehouse (
id int(11) NOT NULL AUTO_INCREMENT,
drug_id varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
stock_number int(11) NULL DEFAULT NULL,
manufacturer varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
standard varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
sale_price double NULL DEFAULT NULL,
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 31 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- Records of warehouse

INSERT INTO warehouse VALUES (31, '1003', 190, '北京医药厂', '30粒/瓶', 20);
INSERT INTO warehouse VALUES (32, '1002', 300, '武汉医药厂', '30粒/瓶', 50);
INSERT INTO warehouse VALUES (33, '1004', 480, '长沙医药厂', '20粒/瓶', 10);

SET FOREIGN_KEY_CHECKS = 1;

二、系统展示
1.登录系统