Java基于jsp的新闻发布管理系统的实现.zip

/* Navicat MySQL Data Transfer Source Server : 222 Source Server Version : 50045 Source Host : localhost:3307 Source Database : xinwen Target Server Type : MYSQL Target Server Version : 50045 File Encoding : 65001 Date: 2019-05-14 12:26:28 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `allusers` -- ---------------------------- DROP TABLE IF EXISTS `allusers`; CREATE TABLE `allusers` ( `ID` int(11) NOT NULL auto_increment, `username` varchar(50) default NULL, `pwd` varchar(50) default NULL, `cx` varchar(50) default '超级管理员', `addtime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of allusers -- ---------------------------- INSERT INTO `allusers` VALUES ('1', 'admin', 'admin', '超级管理员', '2019-05-14 09:48:40'); -- ---------------------------- -- Table structure for `dx` -- ---------------------------- DROP TABLE IF EXISTS `dx`; CREATE TABLE `dx` ( `ID` int(11) NOT NULL auto_increment, `leibie` varchar(50) default NULL, `content` longtext, PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of dx -- ---------------------------- INSERT INTO `dx` VALUES ('1', '系统公告', '<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"height:66px; width:100%\">\r\n <tbody>\r\n <tr>\r\n <td>&nbsp;</td>\r\n <td>\r\n <p>高校校内新闻发布系统</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n'); INSERT INTO `dx` VALUES ('2', '系统简介', '<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"height:66px; width:100%\">\r\n <tbody>\r\n <tr>\r\n <td>&nbsp;</td>\r\n <td>\r\n <p>高校校内新闻发布系统</p>\r\n </td>\r\n </tr>\r\n </tbody>\r\n</table>\r\n'); -- ---------------------------- -- Table structure for `gonggao` -- ---------------------------- DROP TABLE IF EXISTS `gonggao`; CREATE TABLE `gonggao` ( `id` int(11) NOT NULL auto_increment, `biaoti` varchar(255) default NULL, `neirong` varchar(800) default NULL, `addtime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gonggao -- ---------------------------- -- ---------------------------- -- Table structure for `leibie` -- ---------------------------- DROP TABLE IF EXISTS `leibie`; CREATE TABLE `leibie` ( `ID` int(11) NOT NULL auto_increment, `lb` varchar(50) default NULL, `addtime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of leibie -- ---------------------------- INSERT INTO `leibie` VALUES ('35', '校园视频', '2019-05-14 10:43:37'); -- ---------------------------- -- Table structure for `liuyanban` -- ---------------------------- DROP TABLE IF EXISTS `liuyanban`; CREATE TABLE `liuyanban` ( `ID` int(11) NOT NULL auto_increment, `cheng` varchar(50) default NULL, `xingbie` varchar(2) default NULL, `QQ` varchar(50) default NULL, `youxiang` varchar(50) default NULL, `dianhua` varchar(50) default NULL, `neirong` varchar(800) default NULL, `addtime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `huifuneirong` varchar(800) default NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of liuyanban -- ---------------------------- INSERT INTO `liuyanban` VALUES ('36', '444', '2', '', '', '', 'haha', '2019-05-14 10:58:11', null); INSERT INTO `liuyanban` VALUES ('37', '4444', '2', '', '', '', 'FFF', '2019-05-14 12:17:37', null); -- ---------------------------- -- Table structure for `pingjia` -- ---------------------------- DROP TABLE IF EXISTS `pingjia`; CREATE TABLE `pingjia` ( `ID` int(11) NOT NULL auto_increment, `neirong` varchar(500) default NULL, `addby` varchar(50) default NULL, `addtime` timestamp NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `proid` int(11) NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of pingjia -- ---------------------------- INSERT INTO `pingjia` VALUES ('21', '哈哈', 'null', '2019-05-14 10:55:19', '60'); INSERT INTO `pingjia` VALUES ('22', '哈哈', 'null', '2019-05-14 12:14:22', '60'); -- ---------------------------- -- Table structure for `shipinxinxi` -- ---------------------------- DROP TABLE IF EXISTS `shipinxinxi`; CREATE TABLE `shipinxinxi` ( `ID` int(11) NOT NULL auto_increment, `bianhao` varchar(50) default NULL, `mingcheng` varchar(255) default NULL, `leibie` varchar(50) default NULL, `leixing` varchar(50) default NULL, `tupian` varchar(50) default NULL, `wenjian` varchar(50) default NULL, `addby` varchar(50) default NULL, `addtime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `dianjilv` int(11) default '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of shipinxinxi -- ---------------------------- INSERT INTO `shipinxinxi` VALUES ('9', 'sp001', 'XXX校园视频展示', '校园视频', 'wmv', 'admin/upload/1557542777812.jpg', 'admin/upload/1557542785857.wmv', 'admin', '2019-05-14 12:18:45', '4'); -- ---------------------------- -- Table structure for `ttupian` -- ---------------------------- DROP TABLE IF EXISTS `ttupian`; CREATE TABLE `ttupian` ( `ID` int(11) NOT NULL auto_increment, `tupian` varchar(50) default NULL, `mingcheng` varchar(255) default NULL, `addtime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of ttupian -- ---------------------------- INSERT INTO `ttupian` VALUES ('15', 'admin/upload/1557542922600.jpg', '图片新闻1', '2019-05-14 10:48:47'); INSERT INTO `ttupian` VALUES ('16', 'admin/upload/1557542948924.jpg', '图片新闻2', '2019-05-14 10:49:11'); INSERT INTO `ttupian` VALUES ('17', 'admin/upload/1557542982922.jpg', '图片新闻3', '2019-05-14 10:49:46'); INSERT INTO `ttupian` VALUES ('18', 'admin/upload/1557542994015.jpg', '图片新闻4', '2019-05-14 10:49:56'); INSERT INTO `ttupian` VALUES ('19', 'admin/upload/1557543020201.jpg', '图片新闻5', '2019-05-14 10:50:22'); -- ---------------------------- -- Table structure for `xinwentongzhi` -- ---------------------------- DROP TABLE IF EXISTS `xinwentongzhi`; CREATE TABLE `xinwentongzhi` ( `ID` int(11) NOT NULL auto_increment, `biaoti` varchar(255) default NULL, `leibie` varchar(50) default NULL, `neirong` varchar(800) default NULL, `tianjiaren` varchar(50) default NULL, `shouyetupian` varchar(50) default NULL, `dianjilv` varchar(10) default NULL, `addtime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `issh` varchar(100) default '否', PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=61 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of xinwentongzhi -- ---------------------------- INSERT INTO `xinwentongzhi` VALUES ('56', '高校快讯1', '高校快讯', '<p>高校快讯1高校快讯1高校快讯1高校快讯1高校快讯1</p>\r\n', 'admin', 'admin/upload/1557542364306.jpg', '1', '2019-05-14 10:53:44', '是'); INSERT INTO `xinwentongzhi` VALUES ('57', '高校快讯2', '高校快讯', '<p>高校快讯2高校快讯2高校快讯2高校快讯