springboot+mybatis+sharding-jdbc整合分库分表实战

接上一张分库分表分析。项目代码地址：https://gitee.com/wuhan1/sharding-jdbc.git
1.引入jar包

	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>2.1.5.RELEASE</version>
		<relativePath />
	</parent>


		<!-- springboot -->
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>

		<!-- 添加 MySQL -->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
		</dependency>

		<!-- Mybatis -->
		<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>1.2.0</version>
		</dependency>

		<!-- druid -->
		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>druid</artifactId>
			<version>1.1.9</version>
		</dependency>

		<!-- sharding-jdbc -->
		<dependency>
			<groupId>io.shardingsphere</groupId>
			<artifactId>sharding-jdbc-spring-boot-starter</artifactId>
			<version>3.1.0</version>
		</dependency>

2.新建表t_user_1和t_user_2，表结构完全一样



3.新建工程sharding-jdbc，结构

mapper接口

public interface TUserMapper {

	int insert(TUser user);
}

mapper接口对应的xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.xqc.dao.TUserMapper" >

    <insert id="insert" parameterType="TUser" >
        INSERT INTO
        t_user
        (user_name,age,remark)
        VALUES
        (#{userName}, #{age}, #{remark})
    </insert>

</mapper>

service接口

public interface TUserService {
	boolean  insert(TUser user);
}

service接口实现类

@Service
public class TUserServiceImpl implements TUserService{

	@Autowired
	private TUserMapper tUserMapper;
	
	@Override
	public boolean insert(TUser user) {
		return this.tUserMapper.insert(user) == 1;
	}

}

TUser实体类

public cl