What are the ways to realize multiple data sources by using SpringBoot

Using annotations on the class

@ Service@DS (DataSourceConstants.DS_KEY_SLAVE) public class TestUserService {@ Autowired private TestUserMapper testUserMapper; / * query the master library User * @ return * / / @ DS (DataSourceConstants.DS_KEY_MASTER) public List getMasterUser () {QueryWrapper queryWrapper = new QueryWrapper (); return testUserMapper.selectAll (queryWrapper.isNotNull ("name")) } / * query slave library User * @ return * / @ DS (DataSourceConstants.DS_KEY_MASTER) public List getSlaveUser () {return testUserMapper.selectList (null);}}

Effect.

Use annotations on the method

@ Service@DS (DataSourceConstants.DS_KEY_SLAVE) public class TestUserService {@ Autowired private TestUserMapper testUserMapper; / * query master library User * @ return * / @ DS (DataSourceConstants.DS_KEY_SLAVE) public List getMasterUser () {QueryWrapper queryWrapper = new QueryWrapper (); return testUserMapper.selectAll (queryWrapper.isNotNull ("name")) Query slave library User * @ return * / @ DS (DataSourceConstants.DS_KEY_MASTER) public List getSlaveUser () {return testUserMapper.selectList (null);}}

Effect.

This is the end of the content of "what are the ways to use SpringBoot to achieve multiple data sources". Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!