基于SSM框架的仓库管理系统

                介绍：

基于SSM框架的仓库管理系统
spring,springmvc,mysql,Navicat,eclipse或者idea,maven

效果截图：

数据库表：
CREATE TABLE (
RECORD_ID int(11) NOT NULL AUTO_INCREMENT,
USER_ID int(11) NOT NULL,
USER_NAME varchar(50) NOT NULL,
ACCESS_TYPE varchar(30) NOT NULL,
ACCESS_TIME datetime NOT NULL,
ACCESS_IP varchar(45) NOT NULL,
PRIMARY KEY (RECORD_ID)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

---

– Records of wms_access_record

---

INSERT INTO wms_access_record VALUES (‘1’, ‘1010’, ‘user’, ‘login’, ‘2019-07-12 18:02:33’, ‘0:0:0:0:0:0:0:1’); INSERT INTO wms_access_record VALUES (‘2’, ‘1010’, ‘user’, ‘logout’, ‘2019-07-12 18:06:12’, ‘-’); INSERT INTO wms_access_record VALUES (‘3’, ‘1010’, ‘user’, ‘login’, ‘2019-07-12 18:06:28’, ‘0:0:0:0:0:0:0:1’); INSERT INTO wms_access_record VALUES (‘4’, ‘1010’, ‘user’, ‘login’, ‘2019-07-12 18:08:47’, ‘0:0:0:0:0:0:0:1’); INSERT INTO wms_access_record VALUES (‘5’, ‘1010’, ‘user’, ‘logout’, ‘2019-07-12 18:23:08’, ‘-’); INSERT INTO wms_access_record VALUES (‘6’, ‘1020’, ‘周周’, ‘login’, ‘2019-07-12 18:24:03’, ‘0:0:0:0:0:0:0:1’);

---

– Table structure for wms_action

---

DROP TABLE IF EXISTS wms_action; CREATE TABLE wms_action ( ACTION_ID int(11) NOT NULL AUTO_INCREMENT, ACTION_NAME varchar(30) NOT NULL, ACTION_DESC varchar(30) DEFAULT NULL, ACTION_PARAM varchar(50) NOT NULL, PRIMARY KEY ( ACTION_ID) ) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8;

---

– Records of wms_action