springboot项目整合sharding-jdbd实现一主二从读写分离项目

package com.has.shardingjdbcdemo.controller; import com.has.shardingjdbcdemo.entity.User; import com.has.shardingjdbcdemo.mapper.UserMapper; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.transaction.annotation.Transactional; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import java.util.List; @RestController @RequestMapping("/sharding/jdbc") public class ReadWriteController { @Autowired private UserMapper userMapper; @RequestMapping("/testInsert") public void testInsert(){ User user =new User(); user.setUname("四千年"); userMapper.insert(user); } @RequestMapping("/testInsertAndQueryNoTransactional") public void testInsertandQueryNoTrans(){ User user =new User(); user.setUname("鞠婧祎"); userMapper.insert(user); List<User> users = userMapper.selectList(null); } @Transactional @RequestMapping("/testInsertAndQueryHasTransactional") public void testInsertandQueryHasTrans(){ User user =new User(); user.setUname("千年之狐"); userMapper.insert(user); List<User> users = userMapper.selectList(null); } }