1clone
2nguSeckillsqlMySQL
3nguSeckillsrc/main/resourcesjdbc.properties
4IntelliJ IDEAnguSeckill
5enjoy it
4
Githubhttps://github.com/nnngu https://github.com/nnngu/nguSeckill
IntelliJ IDEAFile > New > Project > Maven
Next
Next
Finish
Enable Auto-Import
File > Project Structure
1
2
3
4
5
6
7
8
Mavenjarpom.xml
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.nnngu</groupId>
<artifactId>nguSeckill</artifactId>
<version>1.0-SNAPSHOT</version>
<!-- -->
... ...
pom.xml
12/3/
12MySQL
MySQLAid10MySQL123id4Bid10AMySQLid10B4
123Dao
--
CREATE DATABASE ngu_seckill;
--
USE ngu_seckill;
-- ...
... ...
sqlsql``ngu_seckill.sql
com/nnngu/entity/Seckill.java
package com.nnngu.entity;
import java.io.Serializable;
import java.time.LocalDateTime;
/**
*
*/
public class Seckill implements Serializable {
private static final long serialVersionUID = 2912164127598660137L;
/* ID*/
private long seckillId;
/* */
private String name;
/* */
... ...
com/nnngu/entity/SuccessKilled.java
package com.nnngu.entity;
import java.io.Serializable;
import java.time.LocalDateTime;
/**
*
*/
public class SuccessKilled implements Serializable {
private static final long serialVersionUID = 1834437127882846202L;
private long seckillId;
/* */
private long userPhone;
/* */
... ...
com/nnngu/dao/SeckillMapper.java
package com.nnngu.dao;
import com.nnngu.entity.Seckill;
import org.apache.ibatis.annotations.Param;
import java.time.LocalDateTime;
import java.util.List;
import java.util.Map;
public interface SeckillMapper {
/* */
... ...
}
com/nnngu/dao/SuccessKilledMapper.java
package com.nnngu.dao;
import com.nnngu.entity.SuccessKilled;
import org.apache.ibatis.annotations.Param;
public interface SuccessKilledMapper {
/* */
... ...
}
mapper.xml
resources``com.nnngu.dao``SeckillMapper.xml
SuccessKilledMapper.xml
com.nnngu.dao/SeckillMapper.xml
<!-- -->
<!-- -->
com.nnngu.dao/SuccessKilledMapper.xml
<!-- -->
<!-- -->
mybatis-config.xml
jdbc.properties
**** jdbc.properties
applicationContext-dao.xml
applicationContext-dao.xml
com/nnngu/dao/SeckillMapperTest.java
queryAll()
Dao