/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50553
Source Host : localhost:3306
Source Database : jspm09714xxcsxsglxt
Target Server Type : MYSQL
Target Server Version : 50553
File Encoding : 65001
Date: 2021-12-17 00:54:04
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `admins`
-- ----------------------------
DROP TABLE IF EXISTS `admins`;
CREATE TABLE `admins` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(50) NOT NULL DEFAULT '' COMMENT '账号',
`pwd` varchar(50) NOT NULL DEFAULT '' COMMENT '密码',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='管理员';
-- ----------------------------
-- Records of admins
-- ----------------------------
INSERT INTO `admins` VALUES ('1', 'admin', 'admin');
-- ----------------------------
-- Table structure for `caigouqingdan`
-- ----------------------------
DROP TABLE IF EXISTS `caigouqingdan`;
CREATE TABLE `caigouqingdan` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`shangpinxinxiid` int(10) unsigned NOT NULL COMMENT '信息id',
`shangpinbianhao` varchar(50) NOT NULL DEFAULT '' COMMENT '编号',
`shangpinmingcheng` varchar(255) NOT NULL DEFAULT '' COMMENT '名称',
`fenlei` int(10) unsigned NOT NULL COMMENT '分类',
`jinjia` varchar(50) NOT NULL DEFAULT '' COMMENT '价格',
`caigoushijian` varchar(25) NOT NULL COMMENT '添加时间',
`jinhuoshuliang` int(11) NOT NULL DEFAULT '0' COMMENT '添加数量',
`xiaoji` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '小计',
`caigouren` varchar(64) NOT NULL DEFAULT '' COMMENT '添加人',
PRIMARY KEY (`id`),
KEY `caigouqingdan_shangpinxinxiid_index` (`shangpinxinxiid`),
KEY `caigouqingdan_fenlei_index` (`fenlei`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='添加清单';
-- ----------------------------
-- Records of caigouqingdan
-- ----------------------------
INSERT INTO `caigouqingdan` VALUES ('1', '2', '12162345329076', '毛巾', '2', '18', '17', '50', '900.00', '001');
INSERT INTO `caigouqingdan` VALUES ('2', '2', '12162345329076', '毛巾', '2', '18', '19', '47', '846.00', '001');
INSERT INTO `caigouqingdan` VALUES ('3', '1', '12162345111296', '牙膏', '2', '88', '17', '25', '2200.00', '001');
INSERT INTO `caigouqingdan` VALUES ('4', '1', '12162345111296', '牙膏', '2', '88', '17', '200', '17600.00', '001');
INSERT INTO `caigouqingdan` VALUES ('5', '5', '12170051112003', ' 良品如意枣 ', '1', '25', '17', '200', '5000.00', '005');
INSERT INTO `caigouqingdan` VALUES ('6', '5', '12170051112003', ' 良品如意枣 ', '1', '25', '18', '300', '7500.00', '005');
-- ----------------------------
-- Table structure for `shangpinfenlei`
-- ----------------------------
DROP TABLE IF EXISTS `shangpinfenlei`;
CREATE TABLE `shangpinfenlei` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`fenleimingcheng` varchar(255) NOT NULL DEFAULT '' COMMENT '分类名称',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='商品分类';
-- ----------------------------
-- Records of shangpinfenlei
-- ----------------------------
INSERT INTO `shangpinfenlei` VALUES ('1', '零食系列');
INSERT INTO `shangpinfenlei` VALUES ('2', '生活用品');
-- ----------------------------
-- Table structure for `shangpinxinxi`
-- ----------------------------
DROP TABLE IF EXISTS `shangpinxinxi`;
CREATE TABLE `shangpinxinxi` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`shangpinbianhao` varchar(50) NOT NULL DEFAULT '' COMMENT '商品编号',
`shangpinmingcheng` varchar(255) NOT NULL DEFAULT '' COMMENT '商品名称',
`fenlei` int(10) unsigned NOT NULL COMMENT '分类',
`jinjia` varchar(50) NOT NULL DEFAULT '' COMMENT '进价',
`xiaoshoujia` varchar(50) NOT NULL DEFAULT '' COMMENT '销售价',
`kucun` int(11) NOT NULL DEFAULT '0' COMMENT '库存',
`tianjiaren` varchar(64) NOT NULL DEFAULT '' COMMENT '添加人',
`shangpinxiangqing` longtext NOT NULL COMMENT '商品详情',
PRIMARY KEY (`id`),
KEY `shangpinxinxi_fenlei_index` (`fenlei`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='商品信息';
-- ----------------------------
-- Records of shangpinxinxi
-- ----------------------------
INSERT INTO `shangpinxinxi` VALUES ('1', '12162345111296', '牙膏', '2', '88', '120', '402', '001', '<p><span style=\"font-family: 微软雅黑, "Microsoft YaHei", sans-serif, Arial, "Times New Roman", -apple-system, BlinkMacSystemFont, sans-serif; font-size: 15px; font-weight: 700; text-align: right; white-space: normal;\">商品详情</span><span style=\"font-family: 微软雅黑, "Microsoft YaHei", sans-serif, Arial, "Times New Roman", -apple-system, BlinkMacSystemFont, sans-serif; font-size: 15px; font-weight: 700; text-align: right; white-space: normal;\">商品详情</span><span style=\"font-family: 微软雅黑, "Microsoft YaHei", sans-serif, Arial, "Times New Roman", -apple-system, BlinkMacSystemFont, sans-serif; font-size: 15px; font-weight: 700; text-align: right; white-space: normal;\">商品详情</span><span style=\"font-family: 微软雅黑, "Microsoft YaHei", sans-serif, Arial, "Times New Roman", -apple-system, BlinkMacSystemFont, sans-serif; font-size: 15px; font-weight: 700; text-align: right; white-space: normal;\">商品详情</span><span style=\"font-family: 微软雅黑, "Microsoft YaHei", sans-serif, Arial, "Times New Roman", -apple-system, BlinkMacSystemFont, sans-serif; font-size: 15px; font-weight: 700; text-align: right; white-space: normal;\">商品详情</span><span style=\"font-family: 微软雅黑, "Microsoft YaHei", sans-serif, Arial, "Times New Roman", -apple-system, BlinkMacSystemFont, sans-serif; font-size: 15px; font-weight: 700; text-align: right; white-space: normal;\">商品详情</span><span style=\"font-family: 微软雅黑, "Microsoft YaHei", sans-serif, Arial, "Times New Roman", -apple-system, BlinkMacSystemFont, sans-serif; font-size: 15px; font-weight: 700; text-align: right; white-space: normal;\">商品详情</span><span style=\"font-family: 微软雅黑, "Microsoft YaHei", sans-serif, Arial, "Times New Roman", -apple-system, BlinkMacSystemFont, sans-serif; font-size: 15px; font-weight: 700; text-align: right; white-space: normal;\">商品详情</span><span style=\"font-family: 微软雅黑, "Microsoft YaHei", sans-serif, Arial, "Times New Roman", -apple-system, BlinkMacSystemFont, sans-serif; font-size: 15px; font-weight: 700; text-align: right; white-space: normal;\">商品详情</span><span style=\"font-family: 微软雅黑, "Microsoft YaHei", sans-serif, Arial, "Times New Roman", -apple-system, BlinkMacSystemFont, sans-serif; font-size: 15px; font-weight: 700; text-align: right; white-space: normal;\">商品详情</span><span style=\"font-family: 微软雅黑, "Microsoft YaHei", sans-serif, Arial, "Times New Roman", -apple-system, BlinkMacSystemFont, sans-serif; font-size: 15px; font-weight: 700; text-align: right; white-space: normal;\">商品详情</span><span style=\"font-family: 微软雅黑, "Microsoft YaHei", sans-serif, Arial, "Times New Roman", -apple-system, BlinkMacSystemFont, sans-serif; font-size: 15px; font-weight: 700; text-align: right; white-space: normal;\">商品详情</span><span style=\"font-family: 微软雅黑, "Microsoft YaHei", sans-serif, Arial, "Times New Roman", -apple-system, BlinkMacSystemFont, sans-serif; font-size: 15px; font-weight: 700; text-align: right; white-space: normal;\">商品详情</span><span style=\"font-family: 微软雅黑, "Microsoft YaHei", san
基于Java web的小型超市销售管理系统（源码+数据库脚本+数据库结构表）.zip
版权申诉
156 浏览量
2024-04-09
00:19:45
上传
评论
收藏 20.31MB ZIP 举报
基于Java web的小型超市销售管理系统（源码+数据库脚本+数据库结构表）.zip （853个子文件） 
CommDAO.class 11KB Execl.class 10KB Uploader.class 9KB Collect.class 8KB LoginCtrl.class 6KB SetChar$HttpServletRequestImpl.class 4KB SetChar$LocalRequestContext.class 3KB SetChar.class 3KB Query.class 2KB Request.class 2KB Info.class 1024B Query$1.class 629B .classpath 745B bootstrap.min.css 149KB style.min.css 106KB bootstrap.min.css 98KB glyphicons.css 58KB video-js-cdn.css 45KB video-js-cdn.min.css 40KB video-js.min.css 40KB font-awesome-ie7.min.css 37KB font-awesome.css 37KB font-awesome.min.css 30KB halflings.css 25KB bootstrap-theme.min.css 23KB swiper.css 22KB style.css 21KB swiper.min.css 19KB umeditor.css 18KB font-awesome.min.css 17KB dark-unica.css 16KB sand-signika.css 15KB grid-light.css 15KB highcharts.css 15KB layer.css 14KB umeditor.min.css 14KB jquery.mCustomScrollbar.css 13KB gui.css 6KB layer.css 5KB popup.css 5KB datepicker.css 4KB datepicker.css 4KB image.css 3KB CssAdmin.css 3KB video.css 3KB emotion.css 2KB formula.css 869B WdatePicker.css 192B Thumbs.db 51KB
数据库表结构.doc 8KB fontawesome-webfont.eot 162KB glyphicons-regular.eot 81KB fontawesome-webfont.eot 37KB glyphicons-filetypes-regular.eot 22KB glyphicons-halflings-regular.eot 20KB glyphicons-halflings-regular.eot 20KB glyphicons-social-regular.eot 13KB VideoJS.eot 6KB
wface.gif 49KB jxface2.gif 40KB yface.gif 28KB bface.gif 27KB icons.gif 20KB tface.gif 19KB fface.gif 18KB cface.gif 8KB loading-0.gif 6KB buttons.gif 3KB 4.gif 2KB 5.gif 2KB spinner-mini.gif 2KB loading-2.gif 2KB progress.gif 2KB img.gif 2KB videologo.gif 2KB img.gif 2KB 3.gif 1KB 2.gif 1KB 1.gif 1KB datePicker.gif 1KB ok.gif 866B loading-1.gif 701B crop.gif 329B dialogclose.gif 114B toolbar.gif 68B spacer.gif 43B 0.gif 43B .gitignore 265B
index.html 10KB formula.html 7KB upload.html 6KB map.html 6KB Y1.iml 1KB jspm.iml 986B
ecj-4.6.3.jar 2.34MB mysql-connector-java-8.0.11.jar 1.94MB catalina.jar 1.58MB tomcat-coyote.jar 801KB fastjson-1.2.78.jar 646KB jxl.jar 597KB共 853 条
- 1
- 2
- 3
- 4
- 5
- 6
- 9
资源评论
