CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(32) NOT NULL COMMENT '用户名称',
`password` varchar(32) NOT NULL COMMENT '密码',
`birthday` date DEFAULT NULL COMMENT '生日',
`sex` char(1) DEFAULT NULL COMMENT '性别',
`address` varchar(256) DEFAULT NULL COMMENT '地址',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
select*from user;
CREATE TABLE `items` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL COMMENT '商品名称',
`price` float(10,1) NOT NULL COMMENT '商品定价',
`detail` text COMMENT '商品描述',
`pic` varchar(64) DEFAULT NULL COMMENT '商品图片',
`createtime` datetime NOT NULL COMMENT '生产日期',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
insert into user values(default,'admin','admin',NOW(),'1','中国贵阳');
insert into items values(default,'美女','1000.00','很漂亮','1.jpg','2017-12-14');
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
SSM完成的商品管理系统Commodity_system源码,毕业设计, 整个商品管理系统使用技术: spring4.0 +springmvc4.0.2 +mybatis3.2.7 +bootstrap3 +Ajax +Jquery +拦截器 +文件上传+日期转换等功能都有。 博文同步讲解:https://blog.csdn.net/itbiggod/article/details/79948705
资源推荐
资源详情
资源评论
收起资源包目录
SSM搭建的商品管理系统Commodity_system源码 (163个子文件)
ItemsController.class 5KB
LoginIncetepor.class 2KB
UserController.class 2KB
Items.class 2KB
User.class 2KB
ItemsBizImpl.class 1KB
DateConverter.class 1KB
UserBizImpl.class 937B
UserMapper.class 386B
ItemsDaoMapper.class 351B
ItemsBiz.class 336B
UserBiz.class 241B
.classpath 1KB
org.eclipse.wst.common.component 585B
org.eclipse.wst.jsdt.ui.superType.container 49B
bootstrap.css 143KB
bootstrap.min.css 107KB
bootstrap-datetimepicker.min.css 11KB
~$ Microsoft Word 文档.docx 162B
glyphicons-halflings-regular.eot 20KB
spring-context-4.0.2.RELEASE-javadoc.jar 2.22MB
aspectjweaver-1.6.11.jar 1.61MB
spring-web-4.0.2.RELEASE-javadoc.jar 1.6MB
spring-webmvc-4.0.2.RELEASE-javadoc.jar 1.52MB
spring-beans-4.0.2.RELEASE-javadoc.jar 1.32MB
spring-core-4.0.2.RELEASE-javadoc.jar 1.21MB
spring-jdbc-4.0.2.RELEASE-javadoc.jar 1.09MB
spring-context-4.0.2.RELEASE.jar 951KB
spring-core-4.0.2.RELEASE.jar 938KB
spring-context-4.0.2.RELEASE-sources.jar 879KB
spring-test-4.0.2.RELEASE-javadoc.jar 851KB
spring-aop-4.0.2.RELEASE-javadoc.jar 801KB
spring-tx-4.0.2.RELEASE-javadoc.jar 789KB
jackson-mapper-asl-1.9.11.jar 762KB
mybatis-3.2.7.jar 696KB
javassist-3.17.1-GA.jar 695KB
mysql-connector-java-5.1.7-bin.jar 693KB
log4j-core-2.0-rc1.jar 686KB
spring-orm-4.0.2.RELEASE-javadoc.jar 673KB
spring-beans-4.0.2.RELEASE.jar 653KB
spring-web-4.0.2.RELEASE.jar 649KB
spring-webmvc-4.0.2.RELEASE.jar 645KB
spring-web-4.0.2.RELEASE-sources.jar 621KB
spring-webmvc-4.0.2.RELEASE-sources.jar 612KB
spring-core-4.0.2.RELEASE-sources.jar 595KB
spring-websocket-4.0.2.RELEASE-javadoc.jar 572KB
spring-messaging-4.0.2.RELEASE-javadoc.jar 554KB
spring-beans-4.0.2.RELEASE-sources.jar 552KB
log4j-1.2.17.jar 478KB
spring-test-4.0.2.RELEASE.jar 437KB
spring-jms-4.0.2.RELEASE-javadoc.jar 427KB
spring-webmvc-portlet-4.0.2.RELEASE-javadoc.jar 419KB
spring-jdbc-4.0.2.RELEASE-sources.jar 416KB
spring-jdbc-4.0.2.RELEASE.jar 410KB
spring-expression-4.0.2.RELEASE-javadoc.jar 407KB
jstl-1.2.jar 405KB
spring-context-support-4.0.2.RELEASE-javadoc.jar 383KB
spring-orm-4.0.2.RELEASE.jar 358KB
spring-aop-4.0.2.RELEASE.jar 344KB
spring-test-4.0.2.RELEASE-sources.jar 325KB
spring-aop-4.0.2.RELEASE-sources.jar 321KB
spring-orm-4.0.2.RELEASE-sources.jar 296KB
jsqlparser-0.9.4.jar 295KB
cglib-2.2.2.jar 280KB
spring-tx-4.0.2.RELEASE-sources.jar 271KB
spring-websocket-4.0.2.RELEASE.jar 254KB
junit-4.9.jar 243KB
spring-tx-4.0.2.RELEASE.jar 242KB
spring-messaging-4.0.2.RELEASE.jar 235KB
jackson-core-asl-1.9.11.jar 227KB
spring-jms-4.0.2.RELEASE.jar 206KB
spring-expression-4.0.2.RELEASE.jar 200KB
spring-websocket-4.0.2.RELEASE-sources.jar 198KB
spring-messaging-4.0.2.RELEASE-sources.jar 184KB
commons-io-2.4.jar 181KB
spring-oxm-4.0.2.RELEASE-javadoc.jar 178KB
spring-webmvc-portlet-4.0.2.RELEASE.jar 171KB
spring-jms-4.0.2.RELEASE-sources.jar 168KB
spring-expression-4.0.2.RELEASE-sources.jar 159KB
spring-webmvc-portlet-4.0.2.RELEASE-sources.jar 158KB
spring-context-support-4.0.2.RELEASE-sources.jar 135KB
spring-context-support-4.0.2.RELEASE.jar 132KB
commons-dbcp-1.2.2.jar 119KB
log4j-api-2.0-rc1.jar 113KB
spring-oxm-4.0.2.RELEASE.jar 78KB
spring-build-src-4.0.2.RELEASE.jar 71KB
pagehelper-5.0.0.jar 63KB
commons-pool-1.3.jar 61KB
spring-oxm-4.0.2.RELEASE-sources.jar 60KB
commons-logging-1.1.1.jar 59KB
spring-aspects-4.0.2.RELEASE-javadoc.jar 59KB
commons-fileupload-1.2.2.jar 58KB
spring-aspects-4.0.2.RELEASE.jar 51KB
mybatis-spring-1.2.2.jar 48KB
asm-3.3.1.jar 43KB
spring-instrument-tomcat-4.0.2.RELEASE-javadoc.jar 32KB
spring-aspects-4.0.2.RELEASE-sources.jar 31KB
slf4j-api-1.7.5.jar 25KB
spring-instrument-4.0.2.RELEASE-javadoc.jar 20KB
spring-instrument-tomcat-4.0.2.RELEASE.jar 10KB
共 163 条
- 1
- 2
资源评论
- 平梨花开2020-10-23惭愧,还没实现,没有看,借鉴一下
江湖一点雨
- 粉丝: 5552
- 资源: 38
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功