Shulou(Shulou.com)06/03 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.