-
jdbc.properties配置<br> driver=com.mysql.jdbc.Driver<br> url=jdbc:mysql://127.0.0.1:3306/seckill?useUnicode=true&characterEncoding=utf8<br> username=root<br> password=admin查看全部
-
SeckillDao 设计<br> 1.减库存,int reduceNumber(long seckillId,Date killTime);<br> 2. 根据id查询秒杀对象 queryById(long seckillId);<br> 3. 根据偏移量查询秒杀商品列表:List<Seckill> queryALL(int offset,int limit);查看全部
-
库存业务分析查看全部
-
mvn archetype:generate -DgroupId=org.seckill -DartifactId=seckill -DarchetypeArtifactId=maven-archetype-webapp -DarchetypeCatalog=local查看全部
-
用maven命令创建Web骨架项目<br> mvn archetype:create -DgroupId=org.seckill -DartifactId=seckill -DarchetypeArtifactId=maven-archetype-webapp查看全部
-
logback.qos.ch/manual/configuration.html docs.spring.io/spring/docs/ mybatis.github.io/mybatis-3/zh/index.html查看全部
-
02.mybatis特点及与其他ORM框架的区别 1)sql写在xml文件或者注解当中,推荐写在xml文件当中 2)如何实现DAO接口, Mapper自动实现DAO接口 API编程方式实现DAO接口,推荐使用Mapper查看全部
-
PRIMARY KEY(seckill_id,user_phone) /*联合主键*/ 可以防止一个手机号有重复秒杀的情况查看全部
-
02.官网地址<br> logback, http://logback.qos.ch/manual/configuration.html<br> spring, <br> mybatis,http://www.mybatis.org/mybatis-3/zh/configuration.html查看全部
-
CREATE TABLE seckill( `seckill_id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '商品库存id', `name` VARCHAR(120) NOT NULL COMMENT '商品名称', `number` INT NOT NULL COMMENT '库存数量', `start_time` TIMESTAMP NOT NULL COMMENT '秒杀开启时间', `end_time` TIMESTAMP NOT NULL COMMENT '秒杀结束时间', `create_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', PRIMARY KEY (seckill_id), KEY idx_start_time(start_time), KEY idx_end_time(end_time), KEY idx_create_time(create_time) )ENGINE=INNODB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8 COMMENT='描述库存表'; INSERT INTO seckill(NAME,number,start_time,end_time) VALUES ('1000秒杀iPhone6s',100,'2016-06-15 00:00:00','2016-6-20 00:00:00'), ('500秒杀iPhone6s',200,'2016-06-15 00:00:00','2016-6-20 00:00:00'), ('300秒杀iPhone6s',300,'2016-06-15 00:00:00','2016-6-20 00:00:00'), ('200秒杀iPhone6s',400,'2016-06-15 00:00:00','2016-6-20 00:00:00');查看全部
-
CREATE TABLE success_killed( `seckill_id` BIGINT NOT NULL COMMENT '秒杀商品id', `user_phone` BIGINT NOT NULL COMMENT '用户手机号', `start` TINYINT NOT NULL DEFAULT -1 COMMENT '状态提示:-1无效 0:成功 1:已付款', `create_time` TIMESTAMP NOT NULL COMMENT '创建时间', PRIMARY KEY (seckill_id), KEY idx_create_time(create_time) )ENGINE=INNODB DEFAULT CHARSET=utf8 COMMENT='秒杀成功明细表';查看全部
-
mvn archetype:generate -DgroupId=org.seckill -DartifactId=seckill -DarchetypeArtifactId=maven-archetype-webapp -DarchetypeCatalog=local查看全部
-
<select id="queryByIdWithSeckill" resultType="SuccessKilled" parameterType="long"> select sk.seckill_id, sk.user_phone, sk.create_time, sk.state, sk.seckill_id "sckill.seckill_id", s.name "sckill.name", s.number "sckill.number", s.start_time "sckill.start_time", s.end_time "sckill.end_time", s.create_time "sckill.create_time" from success_killed sk inner join seckill s on sk.seckill_id=s.seckill_id where sk.seckill_id=#{seckillId} </select>查看全部
-
https://github.com/liyifeng1994/seckill 本章节源码在这里,包含所有注释查看全部
-
mvn archetype:generate -DgroupId=org.seckill -DartifactId=seckill -DarchetypeArtifactId=maven-archetype-webapp -DarchetypeCatalog=local查看全部
举报
0/150
提交
取消