Java秒杀系统二集成Mybatis添加mysql客户端、druid连接池依赖

在pom.xml文件添加依赖

 <dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>1.3.2</version>
</dependency>
<dependency>
		<groupId>mysql</groupId>
		<artifactId>mysql-connector-java</artifactId>
	</dependency>
	
	<dependency>
		<groupId>com.alibaba</groupId>
		<artifactId>druid</artifactId>
		<version>1.0.5</version>
	</dependency>
	
	<dependency>
	    <groupId>redis.clients</groupId>
	    <artifactId>jedis</artifactId>
	</dependency>
	
	<dependency>
	    <groupId>com.alibaba</groupId>
	    <artifactId>fastjson</artifactId>
	    <version>1.2.38</version>
	</dependency>
	
	<dependency>
	    <groupId>commons-codec</groupId>
	    <artifactId>commons-codec</artifactId>
	</dependency>
	<dependency>
	    <groupId>org.apache.commons</groupId>
	    <artifactId>commons-lang3</artifactId>
	    <version>3.6</version>
	</dependency>
	
	<dependency>
	    <groupId>commons-codec</groupId>
	    <artifactId>commons-codec</artifactId>
	</dependency>
	<dependency>
	    <groupId>org.apache.commons</groupId>
	    <artifactId>commons-lang3</artifactId>
	    <version>3.6</version>
	</dependency>
	
	<dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-validation</artifactId>
    </dependency>
	<dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-web</artifactId>
    </dependency>
    
    <dependency>
	      <groupId>org.springframework.boot</groupId>
	      <artifactId>spring-boot-starter-thymeleaf</artifactId>
	</dependency>

配置Mybatis、druid、redis

新建一个数据库，创建一张表，里面添加数据。

package cn.tedu.miaosha.domain;

public class User {
	private int id;
	private String name;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
}

package cn.tedu.miaosha.dao;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.hibernate.validator.constraints.ParameterScriptAssert;

import cn.tedu.miaosha.domain.User;

@Mapper
public interface UserDao {
	@Select("select*from user where id=#{id}")
	public User getById(@Param("id")int id);
	@Insert("insert into user(id,name)values(#{id},#{name})")
	public int insert(User u1);

}

package cn.tedu.miaosha.service;


import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;


import cn.tedu.miaosha.dao.UserDao;
import cn.tedu.miaosha.domain.User;

@Service
public class UserService {
	
	@Autowired
	UserDao userDao;
	
    public User getById(int id){
    	return userDao.getById(id);
    }
//@Transactional
	public boolean tx() {
		User u1 = new User();
		u1.setId(3);
		u1.setName("haha");
		userDao.insert(u1);
		
		User u2 = new User();
		u2.setId(1);
		u2.setName("just");
		userDao.insert(u2);
		return true;
	}
}

出现以上内容说明插入成功

出现以上内容的原因是id为1的语句已经存在，但是id为3的数据会成功插入。