在pom.xml文件添加依赖
org.mybatis.spring.boot
mybatis-spring-boot-starter
1.3.2
mysql-connector-java
com.alibaba
druid
1.0.5
redis.clients
jedis
com.alibaba
fastjson
1.2.38
commons-codec
commons-codec
org.apache.commons
commons-lang3
3.6
commons-codec
commons-codec
org.apache.commons
commons-lang3
3.6
org.springframework.boot
spring-boot-starter-validation
org.springframework.boot
spring-boot-starter-web
org.springframework.boot
spring-boot-starter-thymeleaf
配置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的数据会成功插入。