毕业设计-Jsp+MySql的酒品销售系统（完整源码+说明）.zip

/* Navicat MySQL Data Transfer Source Server : test Source Server Version : 50045 Source Host : localhost:3306 Source Database : jiupinxiaoshou Target Server Type : MYSQL Target Server Version : 50045 File Encoding : 65001 Date: 2017-03-30 13:26:12 */ 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 NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of allusers -- ---------------------------- INSERT INTO `allusers` VALUES ('1', 'admin', 'admin', '超级管理员', '2017-03-23 12:37:40'); -- ---------------------------- -- Table structure for `chukujilu` -- ---------------------------- DROP TABLE IF EXISTS `chukujilu`; CREATE TABLE `chukujilu` ( `ID` int(11) NOT NULL auto_increment, `bianhao` varchar(50) default NULL, `mingcheng` varchar(50) default NULL, `chukushuliang` varchar(50) default NULL, `kehu` varchar(50) default NULL, `beizhu` varchar(50) default NULL, `caozuoyuan` varchar(50) default NULL, `addtime` timestamp NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of chukujilu -- ---------------------------- INSERT INTO `chukujilu` VALUES ('15', 'sp001', '客家黄酒', '1', '111', '111', 'yg001', '2017-03-30 13:25:22'); INSERT INTO `chukujilu` VALUES ('14', 'sp005', '葡萄酒1', '10', 'XX', 'XXX', 'yg001', '2017-03-30 13:21:49'); INSERT INTO `chukujilu` VALUES ('13', 'sp001', '客家黄酒', '10', 'XXXX公司', 'XXXX', 'admin', '2017-03-30 11:24:36'); -- ---------------------------- -- 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` mediumtext, PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of dx -- ---------------------------- INSERT INTO `dx` VALUES ('1', '系统公告', '<P>test\r\n<P>test</P>'); INSERT INTO `dx` VALUES ('2', '系统简介', '<P>XXXXXXXXXXXXXXXX</P>'); -- ---------------------------- -- Table structure for `gongyingshangxinxi` -- ---------------------------- DROP TABLE IF EXISTS `gongyingshangxinxi`; CREATE TABLE `gongyingshangxinxi` ( `ID` int(11) NOT NULL auto_increment, `bianhao` varchar(50) default NULL, `gongsimingcheng` varchar(50) default NULL, `dianhua` varchar(50) default NULL, `chuanzhen` varchar(50) default NULL, `youxiang` varchar(50) default NULL, `dizhi` varchar(50) default NULL, `zhuyingchanpin` varchar(50) default NULL, `beizhu` varchar(50) default NULL, `addtime` timestamp NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gongyingshangxinxi -- ---------------------------- INSERT INTO `gongyingshangxinxi` VALUES ('13', 'gs002', 'XXX酒业公司2', '14322222112', '13611112222', '2222@qq.com', 'XXXXXXX路XXXX号', '葡萄酒，XXX酒等', 'XXXX', '2017-03-30 11:11:58'); INSERT INTO `gongyingshangxinxi` VALUES ('12', 'gs001', 'XXX酒业公司', '13611112222', '13611112222', '7322222233@qq.com', 'XXXXXX路', 'XXXX红酒', 'XXXXX', '2017-03-30 11:09:44'); INSERT INTO `gongyingshangxinxi` VALUES ('14', 'gs003', 'XXXX外国酒业公司', '13222223333', '222222333', '2222@qq.com', '美国XXXXX', '进口酒', 'XXXXXX', '2017-03-30 11:13:39'); -- ---------------------------- -- Table structure for `gs_fw` -- ---------------------------- DROP TABLE IF EXISTS `gs_fw`; CREATE TABLE `gs_fw` ( `id` int(11) NOT NULL auto_increment, `gsid` int(255) default NULL, `fangwei` varchar(255) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gs_fw -- ---------------------------- INSERT INTO `gs_fw` VALUES ('3', '13', 'fw0001'); INSERT INTO `gs_fw` VALUES ('4', '13', 'fw0003'); INSERT INTO `gs_fw` VALUES ('5', '12', 'fw0004'); INSERT INTO `gs_fw` VALUES ('6', '14', 'fw009'); -- ---------------------------- -- Table structure for `gwc` -- ---------------------------- DROP TABLE IF EXISTS `gwc`; CREATE TABLE `gwc` ( `ID` int(11) NOT NULL auto_increment, `username` varchar(50) default NULL, `bianhao` varchar(50) default NULL, `mingcheng` varchar(50) default NULL, `tupian` varchar(50) default NULL, `jiage` double default '0', `addtime` timestamp NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `shuliang` int(11) default '1', `isfk` varchar(50) default '否', `fangwei` varchar(50) default '10', `fkzt` varchar(50) default '未付款', PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=48 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gwc -- ---------------------------- INSERT INTO `gwc` VALUES ('47', 'yh001', 'sp001', '客家黄酒', 'admin/upload/1490783810821.jpg', '60', '2017-03-30 13:24:52', '1', '否', 'fw0005', '已付款'); INSERT INTO `gwc` VALUES ('45', 'yh002', 'sp004', 'BLue', 'admin/upload/1490785258213.jpg', '20', '2017-03-30 13:16:58', '1', '否', 'fw0003', '已付款'); -- ---------------------------- -- Table structure for `kehuxinxi` -- ---------------------------- DROP TABLE IF EXISTS `kehuxinxi`; CREATE TABLE `kehuxinxi` ( `ID` int(11) NOT NULL auto_increment, `bianhao` varchar(50) default NULL, `xingming` varchar(50) default NULL, `gongsimingcheng` varchar(50) default NULL, `dianhua` varchar(50) default NULL, `chuanzhen` varchar(50) default NULL, `youxiang` varchar(50) default NULL, `dizhi` varchar(50) default NULL, `beizhu` varchar(50) default NULL, `addtime` timestamp NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of kehuxinxi -- ---------------------------- -- ---------------------------- -- 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` longtext, `addtime` timestamp NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `huifuneirong` longtext, PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of liuyanban -- ---------------------------- -- ---------------------------- -- Table structure for `rukujilu` -- ---------------------------- DROP TABLE IF EXISTS `rukujilu`; CREATE TABLE `rukujilu` ( `ID` int(11) NOT NULL auto_increment, `bianhao` varchar(50) default NULL, `mingcheng` varchar(50) default NULL, `kucun` varchar(50) default NULL, `rukushuliang` varchar(50) default NULL, `gongyingshang` varchar(50) default NULL, `beizhu` varchar(50) default NULL, `caozuoyuan` varchar(50) default NULL, `addtime` timestamp NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of rukujilu -- --------------