第springbootmybatisdruid配置多數(shù)據(jù)源教程packagecom.study.multisource.mybatis.twoDao;

importcom.study.multisource.entity.ItemOrder;

importjava.util.List;

publicinterfaceItemOrderMapper{

ListItemOrdergetAllItemOrder();

}

dao層對應(yīng)的xml配置文件：

UserMapper.xml

xmlversion="1.0"encoding="UTF-8"

!DOCTYPEmapperPUBLIC"-////DTDMapper3.0//EN""/dtd/mybatis-3-mapper.dtd"

mappernamespace="com.study.multisource.mybatis.oneDao.UserMapper"

selectid="getAllUser"resultType="com.study.multisource.entity.User"

select*

from`user`

/select

/mapper

ItemOrderMapper.xml

xmlversion="1.0"encoding="UTF-8"

!DOCTYPEmapperPUBLIC"-////DTDMapper3.0//EN""/dtd/mybatis-3-mapper.dtd"

mappernamespace="com.study.multisource.mybatis.twoDao.ItemOrderMapper"

resultMapid="BaseResultMap"type="com.study.multisource.entity.ItemOrder"

idcolumn="id"jdbcType="BIGINT"property="id"/

resultcolumn="item_id"jdbcType="INTEGER"property="itemId"/

resultcolumn="item_name"jdbcType="VARCHAR"property="itemName"/

/resultMap

selectid="getAllItemOrder"resultMap="BaseResultMap"

select*

fromt_item_order

/select

/mapper

service層：

接口：

packagecom.study.multisource.service;

importcom.study.multisource.entity.ItemOrder;

importcom.study.multisource.entity.User;

importjava.util.List;

*@authorliuhui

*@date2025/5/1417:24

publicinterfaceTestService{

publicListUsergetAllUser();

publicListItemOrdergetAllItemOrder();

}

實現(xiàn)類：

packagecom.study.multisource.service.impl;

importcom.study.multisource.entity.ItemOrder;

importcom.study.multisource.entity.User;

importcom.study.multisource.mybatis.oneDao.UserMapper;

importcom.study.multisource.mybatis.twoDao.ItemOrderMapper;

importcom.study.multisource.service.TestService;

importorg.springframework.beans.factory.annotation.Autowired;

importorg.springframework.stereotype.Service;

importjava.util.List;

*@authorliuhui

*@date2025/5/1417:25

@Service

publicclassTestServiceImplimplementsTestService{

@Autowired

UserMapperuserMapper;

@Autowired

ItemOrderMapperitemOrderMapper;

@Override

publicListUsergetAllUser(){

returnuserMapper.getAllUser();

@Override

publicListItemOrdergetAllItemOrder(){

returnitemOrderMapper.getAllItemOrder();

}

下面進(jìn)行測試：

packagecom.study.multisource.multisource;

importcom.study.multisource.service.TestService;

importlombok.ToString;

importorg.junit.jupiter.api.Test;

importorg.springframework.beans.factory.annotation.Autowired;

importorg.springframework.boot.test.context.SpringBootTest;

@SpringBootTest

classMultisourceApplicationTests{

@Autowired

TestServicetestService;

@Test

voidcontextLoads(){

@Test

voidtestS(){

System.out.println(testService.getAllItemOrder());

System.out.println(testService.getAllUser());

}

結(jié)果：

2025-05-1608:54:17.566INFO12556---[main]com.alibaba.druid.pool.DruidDataSource:{dataSource-1}inited

[ItemOrder(id=1,itemId=101,itemName=泡泡糖)]

--------------------------

2025-05-1608:54:17.752INFO12556---[main]com.alibaba.druid.pool.DruidDataSource:{dataSource-2}inited

[User(id=2,name=Lucy),User(id=4,name=Lina)]

當(dāng)然也可以不用向上面分的那么細(xì)，也可以把多個數(shù)據(jù)