IDEA+Java+SSM

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.登录系统

---

2.管理员-主页

---

3.管理员-人员信息管理

---

4.管理员-进药信息管理

---

---

5.管理员-售药信息管理

---

6.管理员-库存信息管理

---

7.销售员-主页

---

---

8.仓库员-主页

---

三、部分代码

======

LoginController

---

package com.sjsq.controller;

import java.io.UnsupportedEncodingException;

import java.net.URLEncoder;

import javax.servlet.http.Cookie;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Controller;

import org.springframework.web.bind