1. 需求:
实现 SSM 工程构建, 规范依赖管理. 场景: 根据 id 展示商品信息
2. 准备数据库
- SET FOREIGN_KEY_CHECKS=0;
- -- ----------------------------
- -- Table structure for `items`
- -- ----------------------------
- DROP TABLE IF EXISTS `items`;
- CREATE TABLE `items` (
- `id` INT(10) NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(20) DEFAULT NULL,
- `price` FLOAT(10,0) DEFAULT NULL,
- `pic` VARCHAR(40) DEFAULT NULL,
- `createtime` DATETIME DEFAULT NULL,
- `detail` VARCHAR(200) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=INNODB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
- -- ----------------------------
- -- Records of items
- -- ----------------------------
- INSERT INTO `items` VALUES ('1', '传智播客', '1000', NULL, '2018-03-13 09:29:30', '带我走上人生巅峰');
- INSERT INTO `items` VALUES ('2', '黑马 310', NULL, NULL, '2018-03-28 10:05:52', '插入测试');
- INSERT INTO `items` VALUES ('3', '黑马 307', '199', NULL, '2018-03-07 10:08:04', '插入测试');
- INSERT INTO `items` VALUES ('7', '插入测试', NULL, NULL, NULL, NULL);
- INSERT INTO `items` VALUES ('8', '插入测试', NULL, NULL, NULL, NULL);
来源: http://www.bubuko.com/infodetail-3092779.html