超市管理系统-jsp大作业-java大作业-sql文件-源码-word文档

/* Navicat MySQL Data Transfer Source Server : ceshi Source Server Version : 50636 Source Host : localhost:3306 Source Database : eims Target Server Type : MYSQL Target Server Version : 50636 File Encoding : 65001 Date: 2018-01-05 09:56:44 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for contact -- ---------------------------- DROP TABLE IF EXISTS `contact`; CREATE TABLE `contact` ( `clientName` varchar(255) DEFAULT NULL, `contactName` varchar(255) DEFAULT NULL, `contactContents` varchar(255) DEFAULT NULL, `contactStart` varchar(255) DEFAULT NULL, `contactEnd` varchar(255) DEFAULT NULL, `StaffName` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of contact -- ---------------------------- INSERT INTO `contact` VALUES ('王纪纲', '水杯购买', '1000个', '2017年12月1日', '10年', '王纪纲'); INSERT INTO `contact` VALUES ('胡潇', '矿泉水', '1000瓶', '2017年12月26日', '10年', '王纪纲'); INSERT INTO `contact` VALUES ('12', '12', '12', '12', '12', '12'); -- ---------------------------- -- Table structure for cs -- ---------------------------- DROP TABLE IF EXISTS `cs`; CREATE TABLE `cs` ( `clientName` varchar(255) DEFAULT NULL, `clientOpinion` varchar(255) DEFAULT NULL, `StaffName` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of cs -- ---------------------------- INSERT INTO `cs` VALUES ('水杯', '水杯破碎', '张三'); INSERT INTO `cs` VALUES ('矿泉水', '过期', '张三'); -- ---------------------------- -- Table structure for good -- ---------------------------- DROP TABLE IF EXISTS `good`; CREATE TABLE `good` ( `goodName` varchar(255) DEFAULT NULL, `peopleName` varchar(255) DEFAULT NULL, `peopleTelephone` varchar(255) DEFAULT NULL, `goodAddress` varchar(255) DEFAULT NULL, `goodRest` varchar(255) DEFAULT NULL, `goodPurchase` varchar(255) DEFAULT NULL, `goodPrice` varchar(200) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of good -- ---------------------------- INSERT INTO `good` VALUES ('矿泉水', '尹立军', '15512345678', '北京', '500', '1', '2'); INSERT INTO `good` VALUES ('水杯', '李刚', '15512345679', '烟台', '200', '5', '10'); INSERT INTO `good` VALUES ('qqqq', '郭小宇', '12345678910', '潍坊', '1', '1', '1'); INSERT INTO `good` VALUES ('12', '13', '13', '13', '13', '13', '13'); INSERT INTO `good` VALUES ('110', '11', '11', '11', '11', '11', '1'); INSERT INTO `good` VALUES ('123', '1', '', '1', '1', '1', '1'); INSERT INTO `good` VALUES ('45', '23', '4', '45', '56', '56', '56'); -- ---------------------------- -- Table structure for images -- ---------------------------- DROP TABLE IF EXISTS `images`; CREATE TABLE `images` ( `name` varchar(255) DEFAULT NULL, `filename` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of images -- ---------------------------- INSERT INTO `images` VALUES ('水', 'water.jpg'); INSERT INTO `images` VALUES ('水杯', 'glass.jpg'); INSERT INTO `images` VALUES ('', 'glass.jpg'); INSERT INTO `images` VALUES ('', 'bb3.jpg'); INSERT INTO `images` VALUES ('', 'bottom.jpg'); -- ---------------------------- -- Table structure for product -- ---------------------------- DROP TABLE IF EXISTS `product`; CREATE TABLE `product` ( `productName` varchar(255) DEFAULT NULL, `productModel` varchar(255) DEFAULT NULL, `productNumber` varchar(255) DEFAULT NULL, `productPrice` varchar(255) DEFAULT NULL, `productProfit` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of product -- ---------------------------- INSERT INTO `product` VALUES ('矿泉水', '1234', '200', '1', '200'); INSERT INTO `product` VALUES ('水杯', '1111', '100', '5', '500'); INSERT INTO `product` VALUES ('12', '12', '12', '12', '20'); INSERT INTO `product` VALUES ('12', '12', '12', '12', '12'); -- ---------------------------- -- Table structure for staff -- ---------------------------- DROP TABLE IF EXISTS `staff`; CREATE TABLE `staff` ( `staffName` varchar(255) DEFAULT NULL, `staffSex` varchar(255) DEFAULT NULL, `staffAge` varchar(255) DEFAULT NULL, `staffEducation` varchar(255) DEFAULT NULL, `staffDepartment` varchar(255) DEFAULT NULL, `staffDate` varchar(255) DEFAULT NULL, `staffDuty` varchar(255) DEFAULT NULL, `staffWage` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of staff -- ---------------------------- INSERT INTO `staff` VALUES ('亓国照', '男', '26', '硕士', '市场部', '2015年5月16日', '会计', '5000'); INSERT INTO `staff` VALUES ('12', '12', '12', '12', '12', '12', '12', '12'); INSERT INTO `staff` VALUES ('胡潇', '男', '21', '博士', '销售', '2016年6月15日', '导购员', '6000'); -- ---------------------------- -- Table structure for user -- ---------------------------- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `userName` varchar(255) DEFAULT NULL, `password` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of user -- ---------------------------- INSERT INTO `user` VALUES ('zzf', '123'); INSERT INTO `user` VALUES ('123', '123'); INSERT INTO `user` VALUES (null, null);