CREATE DATABASE 3DPRINT DEFAULT CHARSET UTF8; -- 创建数据库3D打印商城系统
USE 3DPRINT; -- 切换到3D打印商城系统数据库系统数据库
CREATE TABLE USER(
ID INT AUTO_INCREMENT PRIMARY KEY, -- 用户ID 主键和自增长
NAME VARCHAR(20) NOT NULL UNIQUE , -- 用户登录帐号1
PWD VARCHAR(20) NOT NULL , -- 用户登录密码2
NIKENAME VARCHAR(30) NOT NULL UNIQUE, -- 用户账户昵称3
IDCARD VARCHAR(20) UNIQUE, -- 用户身份证号码实名制4
PHONE VARCHAR(12) UNIQUE , -- 用户手机号码验证5
TIME DATETIME , -- 用户数据创建时间6
QUALITY CHAR(10), -- 用户数据状态7
LEV CHAR(20) , -- 用户权限等级8
SIGNATURE VARCHAR(80), -- 用户签名9
IMGTOP VARCHAR(60), -- 用户头像10
SEX CHAR(4) , -- 用户性别11
BRITH VARCHAR(20) , -- 用户生日12
JOB VARCHAR(20) , -- 用户职业13
JOBPLACE VARCHAR(100) , -- 用户工作学习地14
EMAIL VARCHAR(30) UNIQUE, -- 用户邮箱绑定15
QQ VARCHAR(12) UNIQUE , -- 用户QQ绑定16
WECHAT VARCHAR(30) UNIQUE , -- 用户微信绑定17
ALIPAY VARCHAR(30) UNIQUE, -- 用户支付宝绑定18
MICROBLOG VARCHAR(30) UNIQUE, -- 用户微博绑定19
ADDRESS VARCHAR(100) -- 用户所在地址20
);
INSERT INTO USER (NAME,PWD,NIKENAME,PHONE,IDCARD,IMGTOP,LEV,QUALITY,TIME,SEX) VALUES
('ADMIN397','3306Rt@cs.n','User','18451977101','3002399199901016233','1.pg','数据管理员','使用',now(),'男'),
('chunfeng','223853465', '张三','15906853212','3702392198008304521','2.pg','后台管理员','使用',now(),'男'),
('heisewuyu','30285644', '李斯','15906853213','3002399199901016222','3.pg','用户管理员','使用',now(),'男'),
('liuhai','545664646', '老刘', '15906853214','3702392198008304523','4.pg','用户管理员','删除',now(),'男'),
('zhuyu','45886454563','叶二', '18451977115','3002399199901016224','5.pg','普通会员','删除',now(),'男'),
('modan','224585852', '陈思', '15906853216','3702392198008304525','6.pg','青铜会员','使用',now(),'男'),
('wuheisan','85665332', '王兰', '15906853217','3002399199901016226','7.pg','白银会员','使用',now(),'男'),
('luoyuan','656523263', '李范', '15906853218','3702392198008304527','8.pg','黄金会员','使用',now(),'男'),
('zuoyan','3306Rt@cs.n','alily', '18451977109','3002399199901016228','9.pg','铂金会员','使用',now(),'男'),
('dfihfas','223853465', '阿苏', '15906853220','3702392198008304529','10.pg','钻石会员','使用',now(),'男'),
('safaishi','30285644', '刘军', '15906853221','3002399199901016230','11.pg','星曜会员','使用',now(),'男'),
('asfjashh','545664646', '李渊','15906853222','3702392198008304531','12.pg','至尊会员','使用',now(),'男'),
('adghuha','45886454563','陈都', '18451977123','3002399199901016232','13.pg','普通会员','使用',now(),'男'),
('asjfias','22458585','阿瑟多哈','15906853224','3702392198008304533','14.pg','铂金会员','使用',now(),'男'),
('sadfhd','85665332', '雕塑家', '15906853225','3002399199901016434','15.pg','钻石会员','删除',now(),'男'),
('admin','admin', 'sads', '15906853226','3002399199901016435','16.pg','钻石会员','使用',now(),'男'),
('asfdjig','656523263', '橘子', '15906853227','3702392198008304536','17.pg','青铜会员','使用',now(),'男');
UPDATE USER SET SIGNATURE='人生如戏！', BRITH='1999-01-01',JOB='程序员',JOBPLACE ='南京网博', EMAIL='1904351529@qq.com',QQ='1904351529',WECHAT='rxy-397',ALIPAY='15906853212',MICROBLOG='无',ADDRESS='保密' WHERE ID=1;
UPDATE USER SET SIGNATURE='空空如也！', BRITH='1998-07-05',JOB='教师',JOBPLACE ='江苏镇江', EMAIL='1904351530@qq.com',QQ='1904351530',WECHAT='rxy-398',ALIPAY='15906853213',MICROBLOG='保密',ADDRESS='江江苏南京浦口区' WHERE ID=2;
UPDATE USER SET SIGNATURE='如果时间能够倒流，你最愿意停留在哪一刻?', BRITH='1997-09-21',JOB='焊工',JOBPLACE ='江苏镇江句容市', EMAIL='1904351531@qq.com',QQ='1904351531',WECHAT='rxy-399',ALIPAY='15906853214',MICROBLOG='null',ADDRESS='保密' WHERE ID=3;
UPDATE USER SET SIGNATURE='素颜朝天怼地球。', BRITH='1999-08-07',JOB='数控加工操作员',JOBPLACE ='湖北武汉', EMAIL='1904351532@qq.com',QQ='1904351532',WECHAT='rxy-400',ALIPAY='15906853215',MICROBLOG='wu',ADDRESS='四川宜宾' WHERE ID=4;
UPDATE USER SET SIGNATURE='惊鸿一面', BRITH='1970-01-20',JOB='UG编程工程师',JOBPLACE ='江苏连云港', EMAIL='1904351533@qq.com',QQ='1904351533',WECHAT='rxy-401',ALIPAY='15906853216',MICROBLOG='307',ADDRESS='安徽淮北' WHERE ID=5;
UPDATE USER SET SIGNATURE='精彩的昙花一现。', BRITH='1980-05-01',JOB='卫生监督员',JOBPLACE ='浙江杭州', EMAIL='1904351534@qq.com',QQ='1904351534',WECHAT='rxy-402',ALIPAY='15906853217',MICROBLOG='308',ADDRESS='浙江温州' WHERE ID=6;
UPDATE USER SET SIGNATURE='昨天不可留，明天尤可期。', BRITH='1988-07-06',JOB='淘宝卖家',JOBPLACE ='浙江绍兴', EMAIL='1904351535@qq.com',QQ='1904351535',WECHAT='rxy-403',ALIPAY='155906853218',MICROBLOG='309',ADDRESS='江苏盐城' WHERE ID=7;
UPDATE USER SET SIGNATURE='朝夕闻道', BRITH='1999-08-05',JOB='厨师',JOBPLACE ='四川绵阳', EMAIL='1904351536@qq.com',QQ='190351536',WECHAT='rxy-404',ALIPAY='15906853219',MICROBLOG='310',ADDRESS='安徽安庆' WHERE ID=8;
UPDATE USER SET SIGNATURE='最后的挽留没有说出口', BRITH='1999-04-03',JOB='会计师',JOBPLACE ='中国台湾', EMAIL='1904351537@qq.com',QQ='1904351537',WECHAT='rxy-405',ALIPAY='15906853220',MICROBLOG='311',ADDRESS='安徽马鞍山' WHERE ID=9;
UPDATE USER SET SIGNATURE='你的世界没有我的地盘', BRITH='1998-07-05',JOB='英语教师',JOBPLACE ='中国香港', EMAIL='1904351538@qq.com',QQ='1904351538',WECHAT='rxy-406',ALIPAY='15906853221',MICROBLOG='312',ADDRESS='江苏盐城' WHERE ID=10;
UPDATE USER SET SIGNATURE='我的世界我做主', BRITH='1999-08-05',JOB='超市收银员',JOBPLACE ='中国澳门', EMAIL='1904351539@qq.com',QQ='1904351539',WECHAT='rxy-407',ALIPAY='15906853222',MICROBLOG='313',ADDRESS='江苏江苏' WHERE ID=11;
UPDATE USER SET SIGNATURE='难忘的是怀念某瞬间', BRITH='2000-01-01',JOB='醒酒师',JOBPLACE ='北京', EMAIL='1904351540@qq.com',QQ='1904351540',WECHAT='rxy-408',ALIPAY='15906853223',MICROBLOG='314',ADDRESS='河北保定' WHERE ID=12;
UPDATE USER SET SIGNATURE='有你的地方才是家', BRITH='1997-08-14',JOB='新闻记者',JOBPLACE ='上海浦东', EMAIL='1904351541@qq.com',QQ='1904351541',WECHAT='rxy-409',ALIPAY='15906853224',MICROBLOG='315',ADDRESS='江苏南京' WHERE ID=13;
UPDATE USER SET SIGNATURE='想念是一个一种愁', BRITH='1999-12-12',JOB='摄影师',JOBPLACE ='江苏南京', EMAIL='1904351542@qq.com',QQ='1904351542',WECHAT='rxy-410',ALIPAY='15906853225',MICROBLOG='316',ADDRESS='湖北武汉' WHERE ID=14;
UPDATE USER SET SIGNATURE='回眸一瞬很清纯', BRITH='1999-12-30',JOB='运动员',JOBPLACE ='天津', EMAIL='1904351543@qq.com',QQ='1904351543',WECHAT='rxy-411',ALIPAY='15906853226',MICROBLOG='317',ADDRESS='河北唐山' WHERE ID=15;
UPDATE USER SET SIGNATURE='啊啊啊啊', BRITH='1999-11-15',JOB='潜水员',JOBPLACE ='广东深圳', EMAIL='1904351544@qq.com',QQ='1904351544',WECHAT='rxy-412',ALIPAY='15906853227',MICROBLOG='318',ADDRESS='浙江绍兴' WHERE ID=16;
UPDATE USER SET SIGNATURE='手机又要没电了。', BRITH='1998-07-26',JOB='摸金校尉',JOBPLACE ='贵州贵阳', EMAIL='1904351545@qq.com',QQ='1904351545',WECHAT='rxy-413',ALIPAY='15906853228',MICROBLOG='319',ADDRESS='浙江金华' WHERE ID=17;
商品管理系统完整源码（java+mysql+ui）(原创)
需积分: 37 101 浏览量
2019-10-29
18:06:18
上传
评论 36
收藏 1.35MB ZIP 举报
商品管理系统完整源码（java+mysql+ui）(原创) （280个子文件） 
GoodsManagerFrom0.class 30KB UserManagerFrom.class 27KB PersonalCenterFrom.class 23KB ShopCartManagerFrom0.class 18KB CommentManagerFrom.class 18KB OrdersManagerFrom.class 17KB GoodsTypeManagerFrom.class 17KB AddressManagerFrom.class 17KB EnrollFrom.class 9KB UserDaoImpl.class 9KB GoodsDaoImpl.class 8KB UserServiceImpl.class 8KB UserLoginFrom.class 8KB Main.class 8KB Goods.class 6KB User.class 6KB CommentDaoImpl.class 6KB GoodsServiceImpl.class 6KB OrderDaoImpl.class 5KB CartDaoImpl.class 5KB GoodsTypeServiceImpl.class 5KB AddressDaoImpl.class 5KB AddressServiceImpl.class 4KB GoodsTypeDaoImpl.class 4KB CommentServiceImpl.class 3KB OrderServiceImpl.class 3KB CartServiceImpl.class 3KB Comment.class 3KB Cart.class 3KB Order.class 3KB JDBCUtil.class 2KB JDBCTemplate.class 2KB UserMapperImpl.class 2KB GoodsMapperImpl.class 2KB ObjectFactory.class 2KB Address.class 2KB GoodsType.class 2KB CommentMapperImpl.class 2KB CartMapperImpl.class 2KB OrderMapperImpl.class 2KB ResJson.class 1KB AddressMapperImpl.class 1KB GoodsTypeMapperImpl.class 1KB ShopCartManagerFrom0$8.class 899B ShopCartManagerFrom0$7.class 899B CommentManagerFrom$8.class 879B CommentManagerFrom$7.class 879B GoodsTypeManagerFrom$10.class 875B GoodsTypeManagerFrom$2.class 873B GoodsTypeManagerFrom$9.class 873B GoodsTypeManagerFrom$8.class 873B GoodsTypeManagerFrom$5.class 873B GoodsTypeManagerFrom$6.class 873B GoodsTypeManagerFrom$7.class 873B GoodsTypeManagerFrom$3.class 873B GoodsTypeManagerFrom$4.class 873B GoodsTypeManagerFrom$1.class 873B ShopCartManagerFrom0$12.class 870B ShopCartManagerFrom0$11.class 870B ShopCartManagerFrom0$10.class 869B ShopCartManagerFrom0$4.class 867B ShopCartManagerFrom0$2.class 867B ShopCartManagerFrom0$5.class 867B ShopCartManagerFrom0$3.class 867B ShopCartManagerFrom0$1.class 867B ShopCartManagerFrom0$6.class 867B ShopCartManagerFrom0$9.class 867B OrdersManagerFrom$7.class 866B OrdersManagerFrom$8.class 866B PersonalCenterFrom$4.class 861B CommentManagerFrom$11.class 850B CommentManagerFrom$12.class 850B AddressManagerFrom$10.class 849B CommentManagerFrom$10.class 849B AddressManagerFrom$9.class 847B AddressManagerFrom$7.class 847B AddressManagerFrom$8.class 847B AddressManagerFrom$1.class 847B AddressManagerFrom$2.class 847B AddressManagerFrom$6.class 847B AddressManagerFrom$3.class 847B AddressManagerFrom$4.class 847B AddressManagerFrom$5.class 847B CommentManagerFrom$1.class 847B CommentManagerFrom$9.class 847B CommentManagerFrom$5.class 847B CommentManagerFrom$3.class 847B CommentManagerFrom$2.class 847B CommentManagerFrom$4.class 847B CommentManagerFrom$6.class 847B UserManagerFrom$1.class 840B OrdersManagerFrom$11.class 837B OrdersManagerFrom$12.class 837B OrdersManagerFrom$10.class 836B OrdersManagerFrom$2.class 834B OrdersManagerFrom$4.class 834B OrdersManagerFrom$1.class 834B OrdersManagerFrom$9.class 834B OrdersManagerFrom$3.class 834B OrdersManagerFrom$5.class 834B共 280 条
- 1
- 2
- 3
资源评论
