1671jsp教材管理系统Myeclipse开发mysql数据库web结构java编程计算机网页项目 源码

/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50067 Source Host : localhost:3306 Source Database : jspjcgl Target Server Type : MYSQL Target Server Version : 50067 File Encoding : 65001 Date: 2021-03-12 19:09:37 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for gly -- ---------------------------- DROP TABLE IF EXISTS `gly`; CREATE TABLE `gly` ( `glyid` int(11) NOT NULL auto_increment, `yhm` varchar(40) default NULL COMMENT '用户名', `mm` varchar(40) default NULL COMMENT '密码', `xm` varchar(40) default NULL COMMENT '姓名', PRIMARY KEY (`glyid`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of gly -- ---------------------------- INSERT INTO `gly` VALUES ('1', 'admin', 'admin', 'admin'); -- ---------------------------- -- Table structure for gonggao -- ---------------------------- DROP TABLE IF EXISTS `gonggao`; CREATE TABLE `gonggao` ( `ggid` int(11) NOT NULL auto_increment, `bt` varchar(40) default NULL COMMENT '标题', `nr` varchar(4000) default NULL COMMENT '内容', `fbsj` varchar(40) default NULL COMMENT '发布时间', PRIMARY KEY (`ggid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of gonggao -- ---------------------------- INSERT INTO `gonggao` VALUES ('1', '系统公告', '系统公告系统公告', '2021-03-12 11:59:28'); INSERT INTO `gonggao` VALUES ('2', '顶顶顶顶', '顶顶顶顶', '2021-03-12 17:31:15'); -- ---------------------------- -- Table structure for jclb -- ---------------------------- DROP TABLE IF EXISTS `jclb`; CREATE TABLE `jclb` ( `jclbid` int(11) NOT NULL auto_increment, `lb` varchar(40) default NULL COMMENT '类别', PRIMARY KEY (`jclbid`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of jclb -- ---------------------------- INSERT INTO `jclb` VALUES ('1', '物理'); INSERT INTO `jclb` VALUES ('2', '计算机'); INSERT INTO `jclb` VALUES ('3', '历史'); -- ---------------------------- -- Table structure for jiaocai -- ---------------------------- DROP TABLE IF EXISTS `jiaocai`; CREATE TABLE `jiaocai` ( `jcid` int(11) NOT NULL auto_increment, `jcmc` varchar(40) default NULL COMMENT '教材名称', `lb` varchar(40) default NULL COMMENT '类别', `js` varchar(4000) default NULL COMMENT '介绍', `cbs` varchar(40) default NULL COMMENT '出版社', `kcl` int(40) default NULL COMMENT '库存量', `tp` varchar(40) default NULL COMMENT '图片', `jg` varchar(40) default NULL COMMENT '价格', PRIMARY KEY (`jcid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of jiaocai -- ---------------------------- INSERT INTO `jiaocai` VALUES ('1', '计算机原理', '物理', '计算机原理计算机原理', '清华', '490', '1615522661210.jpg', '20'); INSERT INTO `jiaocai` VALUES ('2', '历史教育', '历史', '历史教育历史教育', '清华', '1988', '1615541531544.jpg', '20'); -- ---------------------------- -- Table structure for jiaoshi -- ---------------------------- DROP TABLE IF EXISTS `jiaoshi`; CREATE TABLE `jiaoshi` ( `jsid` int(11) NOT NULL auto_increment, `yhm` varchar(40) default NULL COMMENT '用户名', `mm` varchar(40) default NULL COMMENT '密码', `xm` varchar(40) default NULL COMMENT '姓名', `lxdh` varchar(40) default NULL COMMENT '联系电话', `lxdz` varchar(40) default NULL COMMENT '联系地址', PRIMARY KEY (`jsid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of jiaoshi -- ---------------------------- INSERT INTO `jiaoshi` VALUES ('1', 'js', 'js', 'js', '120321030', '12301023'); INSERT INTO `jiaoshi` VALUES ('2', 'js2', 'js2', 'js2', '120310230', '1203012'); -- ---------------------------- -- Table structure for kcjc -- ---------------------------- DROP TABLE IF EXISTS `kcjc`; CREATE TABLE `kcjc` ( `kcjcid` int(11) NOT NULL auto_increment, `kc` varchar(40) default NULL COMMENT '课程', `jc` varchar(40) default NULL COMMENT '教材', PRIMARY KEY (`kcjcid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of kcjc -- ---------------------------- INSERT INTO `kcjc` VALUES ('1', '1', '1'); INSERT INTO `kcjc` VALUES ('2', '2', '2'); -- ---------------------------- -- Table structure for kecheng -- ---------------------------- DROP TABLE IF EXISTS `kecheng`; CREATE TABLE `kecheng` ( `kcid` int(11) NOT NULL auto_increment, `kcmc` varchar(40) default NULL COMMENT '课程名称', `js` varchar(4000) default NULL COMMENT '介绍', `rkjs` varchar(40) default NULL COMMENT '任课教师', PRIMARY KEY (`kcid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of kecheng -- ---------------------------- INSERT INTO `kecheng` VALUES ('1', '课程信息', '课程信息课程信息课程信息', 'js'); INSERT INTO `kecheng` VALUES ('2', '历史课程', '历史课程历史课程', 'js'); -- ---------------------------- -- Table structure for ruku -- ---------------------------- DROP TABLE IF EXISTS `ruku`; CREATE TABLE `ruku` ( `rkid` int(11) NOT NULL auto_increment, `jc` varchar(40) default NULL COMMENT '教材', `rksl` varchar(40) default NULL COMMENT '入库数量', `rksj` varchar(40) default NULL COMMENT '入库时间', `sm` varchar(40) default NULL COMMENT '说明', `czr` varchar(40) default NULL COMMENT '操作人', PRIMARY KEY (`rkid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of ruku -- ---------------------------- INSERT INTO `ruku` VALUES ('1', '1', '500', '2021-03-12 13:44:24', '123123', 'js'); INSERT INTO `ruku` VALUES ('2', '2', '2000', '2021-03-12 17:32:42', '010', 'js'); -- ---------------------------- -- Table structure for xsly -- ---------------------------- DROP TABLE IF EXISTS `xsly`; CREATE TABLE `xsly` ( `xslyid` int(11) NOT NULL auto_increment, `jc` varchar(40) default NULL COMMENT '教材', `lysl` varchar(40) default NULL COMMENT '领用数量', `bj` varchar(40) default NULL COMMENT '班级', `sm` varchar(4000) default NULL COMMENT '说明', `lysj` varchar(40) default NULL COMMENT '领用时间', `lyr` varchar(40) default NULL COMMENT '领用人', `zt` varchar(40) default NULL COMMENT '状态', PRIMARY KEY (`xslyid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of xsly -- ---------------------------- INSERT INTO `xsly` VALUES ('1', '1', '10', '02班', '123123', '2021-03-12 16:26:18', '123', '同意'); INSERT INTO `xsly` VALUES ('2', '2', '12', '02班', '123', '2021-03-12 17:33:34', '123', '同意'); -- ---------------------------- -- Table structure for xuesheng -- ---------------------------- DROP TABLE IF EXISTS `xuesheng`; CREATE TABLE `xuesheng` ( `xsid` int(11) NOT NULL auto_increment, `yhm` varchar(40) default NULL COMMENT '用户名', `mm` varchar(40) default NULL COMMENT '密码', `xm` varchar(40) default NULL COMMENT '姓名', `lxdh` varchar(40) default NULL COMMENT '联系电话', `lxdz` varchar(40) default NULL COMMENT '联系地址', `zy` varchar(40) default NULL COMMENT '专业', PRIMARY KEY (`xsid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of xuesheng -- ---------------------------- INSERT INTO `xuesheng` VALUES ('1', '123', '123', '123', '120301230123', '123123', '计算机专业'); INSERT INTO `xuesheng` VALUES ('2', '333', '333', '333', '123123', '12312', '计算机');