java Web 中小企业门户网站用eclipse定制开发mysql数据库BS模式java编程jdbc 源码

/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50067 Source Host : localhost:3306 Source Database : jspportal Target Server Type : MYSQL Target Server Version : 50067 File Encoding : 65001 Date: 2022-05-04 15:45:48 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for chanpin -- ---------------------------- DROP TABLE IF EXISTS `chanpin`; CREATE TABLE `chanpin` ( `cpid` int(11) NOT NULL auto_increment, `cpmc` varchar(40) default NULL COMMENT '产品名称', `js` varchar(4000) default NULL COMMENT '介绍', `tp` varchar(40) default NULL COMMENT '图片', `jg` varchar(40) default NULL COMMENT '价格', `sm` varchar(4000) default NULL COMMENT '说明', PRIMARY KEY (`cpid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of chanpin -- ---------------------------- INSERT INTO `chanpin` VALUES ('1', '显示器', '显示器显示器显示器', '1651639576354.jpg', '12321', '显示器'); INSERT INTO `chanpin` VALUES ('2', '硬盘', '硬盘硬盘硬盘', '1651650252472.jpg', '1150', '132123'); -- ---------------------------- -- Table structure for dgyx -- ---------------------------- DROP TABLE IF EXISTS `dgyx`; CREATE TABLE `dgyx` ( `dgyxid` int(11) NOT NULL auto_increment, `bt` varchar(40) default NULL COMMENT '标题', `cp` varchar(40) default NULL COMMENT '产品', `sm` varchar(40) default NULL COMMENT '说明', `kh` varchar(40) default NULL COMMENT '客户', `zt` varchar(40) default NULL COMMENT '状态', PRIMARY KEY (`dgyxid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of dgyx -- ---------------------------- INSERT INTO `dgyx` VALUES ('1', '订购阿', '显示器', '订购阿订购阿订购阿', '123', '已处理'); INSERT INTO `dgyx` VALUES ('2', '31232131', '显示器', '12312321', '666', '已处理'); -- ---------------------------- -- 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 kehu -- ---------------------------- DROP TABLE IF EXISTS `kehu`; CREATE TABLE `kehu` ( `khid` 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 (`khid`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of kehu -- ---------------------------- INSERT INTO `kehu` VALUES ('1', '123', '123', '123', '12312312', '31231232'); INSERT INTO `kehu` VALUES ('2', '333', '333', '333', '123213', '13131'); INSERT INTO `kehu` VALUES ('3', '666', '666', '666', '123213213', '213123213'); INSERT INTO `kehu` VALUES ('4', '777', '777', '1231', '2312321312', '3123123'); -- ---------------------------- -- Table structure for liuyan -- ---------------------------- DROP TABLE IF EXISTS `liuyan`; CREATE TABLE `liuyan` ( `lyid` int(11) NOT NULL auto_increment, `ly` varchar(40) default NULL COMMENT '留言', `kh` varchar(40) default NULL COMMENT '客户', `lysj` varchar(40) default NULL COMMENT '留言时间', `zt` varchar(40) default NULL COMMENT '状态', `hf` varchar(40) default NULL COMMENT '回复', PRIMARY KEY (`lyid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of liuyan -- ---------------------------- INSERT INTO `liuyan` VALUES ('1', '鞍山师范', '123', '2022-05-04 13:54:09', '已回复', '阿萨德发'); INSERT INTO `liuyan` VALUES ('2', '123123213', '666', '2022-05-04 15:43:25', '已回复', '阿萨法'); -- ---------------------------- -- Table structure for qyjs -- ---------------------------- DROP TABLE IF EXISTS `qyjs`; CREATE TABLE `qyjs` ( `qyjsid` 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 (`qyjsid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of qyjs -- ---------------------------- INSERT INTO `qyjs` VALUES ('1', '企业介绍', '企业介绍企业介绍企业介绍', '2022-05-04 12:59:10'); INSERT INTO `qyjs` VALUES ('2', '留言阿', '留言阿留言阿留言阿', '2022-05-04 15:44:24');