接上一张分库分表分析。项目代码地址: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)