druid连接池mysql5.7_集成Mybatis添加mysql客户端、druid连接池依赖实例

在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的数据会成功插入。