Skip to content

Commit da902e1

Browse files
ityouknowityouknow
committed
mybatis multi datasouce demo
1 parent a1166aa commit da902e1

File tree

35 files changed

+177
-179
lines changed

35 files changed

+177
-179
lines changed

‎spring-boot-mybatis-annotation-mulidatasource/src/main/resources/application.properties

Lines changed: 0 additions & 13 deletions
This file was deleted.

‎spring-boot-mybatis-mulidatasource/src/main/java/com/neo/mapper/test1/User1Mapper.java

Lines changed: 0 additions & 19 deletions
This file was deleted.

‎spring-boot-mybatis-mulidatasource/src/main/java/com/neo/mapper/test2/User2Mapper.java

Lines changed: 0 additions & 19 deletions
This file was deleted.

‎spring-boot-mybatis-mulidatasource/src/main/resources/application.properties

Lines changed: 0 additions & 13 deletions
This file was deleted.

‎spring-boot-mybatis-annotation-mulidatasource/pom.xml renamed to ‎spring-boot-mybatis/spring-boot-mybatis-annotation-mulidatasource/pom.xml

Lines changed: 6 additions & 18 deletions
Original file line numberDiff line numberDiff line change
@@ -14,7 +14,7 @@
1414
<parent>
1515
<groupId>org.springframework.boot</groupId>
1616
<artifactId>spring-boot-starter-parent</artifactId>
17-
<version>1.4.2.RELEASE</version>
17+
<version>2.1.0.RELEASE</version>
1818
<relativePath/> <!-- lookup parent from repository -->
1919
</parent>
2020

@@ -24,32 +24,23 @@
2424
</properties>
2525

2626
<dependencies>
27-
<dependency>
28-
<groupId>org.springframework.boot</groupId>
29-
<artifactId>spring-boot-starter</artifactId>
30-
</dependency>
31-
<dependency>
32-
<groupId>org.springframework.boot</groupId>
33-
<artifactId>spring-boot-starter-test</artifactId>
34-
<scope>test</scope>
35-
</dependency>
3627
<dependency>
3728
<groupId>org.springframework.boot</groupId>
3829
<artifactId>spring-boot-starter-web</artifactId>
3930
</dependency>
4031
<dependency>
4132
<groupId>org.mybatis.spring.boot</groupId>
4233
<artifactId>mybatis-spring-boot-starter</artifactId>
43-
<version>1.1.1</version>
34+
<version>2.0.0</version>
4435
</dependency>
4536
<dependency>
4637
<groupId>mysql</groupId>
4738
<artifactId>mysql-connector-java</artifactId>
4839
</dependency>
49-
<dependency>
50-
<groupId>org.springframework.boot</groupId>
51-
<artifactId>spring-boot-devtools</artifactId>
52-
<optional>true</optional>
40+
<dependency>
41+
<groupId>org.springframework.boot</groupId>
42+
<artifactId>spring-boot-starter-test</artifactId>
43+
<scope>test</scope>
5344
</dependency>
5445
</dependencies>
5546

@@ -58,9 +49,6 @@
5849
<plugin>
5950
<groupId>org.springframework.boot</groupId>
6051
<artifactId>spring-boot-maven-plugin</artifactId>
61-
<configuration>
62-
<fork>true</fork>
63-
</configuration>
6452
</plugin>
6553
</plugins>
6654
</build>

‎spring-boot-mybatis-annotation-mulidatasource/src/main/java/com/neo/Application.java renamed to ‎spring-boot-mybatis/spring-boot-mybatis-annotation-mulidatasource/src/main/java/com/neo/MAMApplication.java

Lines changed: 2 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,13 +1,12 @@
11
package com.neo;
22

3-
import org.mybatis.spring.annotation.MapperScan;
43
import org.springframework.boot.SpringApplication;
54
import org.springframework.boot.autoconfigure.SpringBootApplication;
65

76
@SpringBootApplication
8-
public class Application {
7+
public class MAMApplication {
98

109
public static void main(String[] args) {
11-
SpringApplication.run(Application.class, args);
10+
SpringApplication.run(MAMApplication.class, args);
1211
}
1312
}

‎spring-boot-mybatis-annotation-mulidatasource/src/main/java/com/neo/datasource/DataSource1Config.java renamed to ‎spring-boot-mybatis/spring-boot-mybatis-annotation-mulidatasource/src/main/java/com/neo/datasource/DataSource1Config.java

Lines changed: 1 addition & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -5,12 +5,11 @@
55
import org.mybatis.spring.SqlSessionTemplate;
66
import org.mybatis.spring.annotation.MapperScan;
77
import org.springframework.beans.factory.annotation.Qualifier;
8-
import org.springframework.boot.autoconfigure.jdbc.DataSourceBuilder;
98
import org.springframework.boot.context.properties.ConfigurationProperties;
9+
import org.springframework.boot.jdbc.DataSourceBuilder;
1010
import org.springframework.context.annotation.Bean;
1111
import org.springframework.context.annotation.Configuration;
1212
import org.springframework.context.annotation.Primary;
13-
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
1413
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
1514

1615
import javax.sql.DataSource;

‎spring-boot-mybatis-annotation-mulidatasource/src/main/java/com/neo/datasource/DataSource2Config.java renamed to ‎spring-boot-mybatis/spring-boot-mybatis-annotation-mulidatasource/src/main/java/com/neo/datasource/DataSource2Config.java

Lines changed: 1 addition & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -5,11 +5,10 @@
55
import org.mybatis.spring.SqlSessionTemplate;
66
import org.mybatis.spring.annotation.MapperScan;
77
import org.springframework.beans.factory.annotation.Qualifier;
8-
import org.springframework.boot.autoconfigure.jdbc.DataSourceBuilder;
98
import org.springframework.boot.context.properties.ConfigurationProperties;
9+
import org.springframework.boot.jdbc.DataSourceBuilder;
1010
import org.springframework.context.annotation.Bean;
1111
import org.springframework.context.annotation.Configuration;
12-
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
1312
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
1413

1514
import javax.sql.DataSource;

‎spring-boot-mybatis-annotation-mulidatasource/src/main/java/com/neo/enums/UserSexEnum.java renamed to ‎spring-boot-mybatis/spring-boot-mybatis-annotation-mulidatasource/src/main/java/com/neo/enums/UserSexEnum.java

File renamed without changes.

‎spring-boot-mybatis-annotation-mulidatasource/src/main/java/com/neo/mapper/test1/User1Mapper.java renamed to ‎spring-boot-mybatis/spring-boot-mybatis-annotation-mulidatasource/src/main/java/com/neo/mapper/test1/User1Mapper.java

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,6 @@
11
package com.neo.mapper.test1;
22

3-
import com.neo.entity.UserEntity;
3+
import com.neo.model.User;
44
import com.neo.enums.UserSexEnum;
55
import org.apache.ibatis.annotations.*;
66

@@ -14,20 +14,20 @@ public interface User1Mapper {
1414
@Result(property = "userSex", column = "user_sex", javaType = UserSexEnum.class),
1515
@Result(property = "nickName", column = "nick_name")
1616
})
17-
List<UserEntity> getAll();
17+
List<User> getAll();
1818

1919
@Select("SELECT * FROM users WHERE id = #{id}")
2020
@Results({
2121
@Result(property = "userSex", column = "user_sex", javaType = UserSexEnum.class),
2222
@Result(property = "nickName", column = "nick_name")
2323
})
24-
UserEntity getOne(Long id);
24+
User getOne(Long id);
2525

2626
@Insert("INSERT INTO users(userName,passWord,user_sex) VALUES(#{userName}, #{passWord}, #{userSex})")
27-
void insert(UserEntity user);
27+
void insert(User user);
2828

2929
@Update("UPDATE users SET userName=#{userName},nick_name=#{nickName} WHERE id =#{id}")
30-
void update(UserEntity user);
30+
void update(User user);
3131

3232
@Delete("DELETE FROM users WHERE id =#{id}")
3333
void delete(Long id);

‎spring-boot-mybatis-annotation-mulidatasource/src/main/java/com/neo/mapper/test2/User2Mapper.java renamed to ‎spring-boot-mybatis/spring-boot-mybatis-annotation-mulidatasource/src/main/java/com/neo/mapper/test2/User2Mapper.java

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22

33
import java.util.List;
44

5-
import com.neo.entity.UserEntity;
5+
import com.neo.model.User;
66
import com.neo.enums.UserSexEnum;
77
import org.apache.ibatis.annotations.*;
88

@@ -14,20 +14,20 @@ public interface User2Mapper {
1414
@Result(property = "userSex", column = "user_sex", javaType = UserSexEnum.class),
1515
@Result(property = "nickName", column = "nick_name")
1616
})
17-
List<UserEntity> getAll();
17+
List<User> getAll();
1818

1919
@Select("SELECT * FROM users WHERE id = #{id}")
2020
@Results({
2121
@Result(property = "userSex", column = "user_sex", javaType = UserSexEnum.class),
2222
@Result(property = "nickName", column = "nick_name")
2323
})
24-
UserEntity getOne(Long id);
24+
User getOne(Long id);
2525

2626
@Insert("INSERT INTO users(userName,passWord,user_sex) VALUES(#{userName}, #{passWord}, #{userSex})")
27-
void insert(UserEntity user);
27+
void insert(User user);
2828

2929
@Update("UPDATE users SET userName=#{userName},nick_name=#{nickName} WHERE id =#{id}")
30-
void update(UserEntity user);
30+
void update(User user);
3131

3232
@Delete("DELETE FROM users WHERE id =#{id}")
3333
void delete(Long id);

‎spring-boot-mybatis-annotation-mulidatasource/src/main/java/com/neo/entity/UserEntity.java renamed to ‎spring-boot-mybatis/spring-boot-mybatis-annotation-mulidatasource/src/main/java/com/neo/model/User.java

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1,10 +1,10 @@
1-
package com.neo.entity;
1+
package com.neo.model;
22

33
import java.io.Serializable;
44

55
import com.neo.enums.UserSexEnum;
66

7-
public class UserEntity implements Serializable {
7+
public class User implements Serializable {
88

99
private static final long serialVersionUID = 1L;
1010
private Long id;
@@ -13,11 +13,11 @@ public class UserEntity implements Serializable {
1313
private UserSexEnum userSex;
1414
private String nickName;
1515

16-
public UserEntity() {
16+
public User() {
1717
super();
1818
}
1919

20-
public UserEntity(String userName, String passWord, UserSexEnum userSex) {
20+
public User(String userName, String passWord, UserSexEnum userSex) {
2121
super();
2222
this.passWord = passWord;
2323
this.userName = userName;

‎spring-boot-mybatis-annotation-mulidatasource/src/main/java/com/neo/web/UserController.java renamed to ‎spring-boot-mybatis/spring-boot-mybatis-annotation-mulidatasource/src/main/java/com/neo/web/UserController.java

Lines changed: 7 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -3,12 +3,12 @@
33
import java.util.List;
44

55
import com.neo.mapper.test1.User1Mapper;
6+
import com.neo.model.User;
67
import org.springframework.beans.factory.annotation.Autowired;
78
import org.springframework.web.bind.annotation.PathVariable;
89
import org.springframework.web.bind.annotation.RequestMapping;
910
import org.springframework.web.bind.annotation.RestController;
1011

11-
import com.neo.entity.UserEntity;
1212
import com.neo.mapper.test2.User2Mapper;
1313

1414
@RestController
@@ -21,24 +21,24 @@ public class UserController {
2121
private User2Mapper user2Mapper;
2222

2323
@RequestMapping("/getUsers")
24-
public List<UserEntity> getUsers() {
25-
List<UserEntity> users=user1Mapper.getAll();
24+
public List<User> getUsers() {
25+
List<User> users=user1Mapper.getAll();
2626
return users;
2727
}
2828

2929
@RequestMapping("/getUser")
30-
public UserEntity getUser(Long id) {
31-
UserEntity user=user2Mapper.getOne(id);
30+
public User getUser(Long id) {
31+
User user=user2Mapper.getOne(id);
3232
return user;
3333
}
3434

3535
@RequestMapping("/add")
36-
public void save(UserEntity user) {
36+
public void save(User user) {
3737
user2Mapper.insert(user);
3838
}
3939

4040
@RequestMapping(value="update")
41-
public void update(UserEntity user) {
41+
public void update(User user) {
4242
user2Mapper.update(user);
4343
}
4444

‎spring-boot-mybatis/spring-boot-mybatis-annotation-mulidatasource/src/main/resources/application.properties

Lines changed: 12 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,12 @@
1+
mybatis.type-aliases-package=com.neo.model
2+
3+
spring.datasource.test1.jdbc-url=jdbc:mysql://localhost:3306/test1?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8&useSSL=true
4+
spring.datasource.test1.username=root
5+
spring.datasource.test1.password=root
6+
spring.datasource.test1.driver-class-name=com.mysql.cj.jdbc.Driver
7+
8+
spring.datasource.test2.jdbc-url=jdbc:mysql://localhost:3306/test2?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8&useSSL=true
9+
spring.datasource.test2.username=root
10+
spring.datasource.test2.password=root
11+
spring.datasource.test2.driver-class-name=com.mysql.cj.jdbc.Driver
12+

‎spring-boot-mybatis-mulidatasource/src/test/java/com/neo/ApplicationTests.java renamed to ‎spring-boot-mybatis/spring-boot-mybatis-annotation-mulidatasource/src/test/java/com/neo/MAMApplicationTests.java

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -7,7 +7,7 @@
77

88
@RunWith(SpringRunner.class)
99
@SpringBootTest
10-
public class ApplicationTests {
10+
public class MAMApplicationTests {
1111

1212
@Test
1313
public void contextLoads() {

‎spring-boot-mybatis-mulidatasource/src/test/java/com/neo/mapper/User1MapperTest.java renamed to ‎spring-boot-mybatis/spring-boot-mybatis-annotation-mulidatasource/src/test/java/com/neo/mapper/User1MapperTest.java

Lines changed: 6 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -3,14 +3,14 @@
33
import java.util.List;
44

55
import com.neo.mapper.test1.User1Mapper;
6+
import com.neo.model.User;
67
import org.junit.Assert;
78
import org.junit.Test;
89
import org.junit.runner.RunWith;
910
import org.springframework.beans.factory.annotation.Autowired;
1011
import org.springframework.boot.test.context.SpringBootTest;
1112
import org.springframework.test.context.junit4.SpringRunner;
1213

13-
import com.neo.entity.UserEntity;
1414
import com.neo.enums.UserSexEnum;
1515

1616
@RunWith(SpringRunner.class)
@@ -22,16 +22,16 @@ public class User1MapperTest {
2222

2323
@Test
2424
public void testInsert() throws Exception {
25-
userMapper.insert(new UserEntity("aa", "a123456", UserSexEnum.MAN));
26-
userMapper.insert(new UserEntity("bb", "b123456", UserSexEnum.WOMAN));
27-
userMapper.insert(new UserEntity("cc", "b123456", UserSexEnum.WOMAN));
25+
userMapper.insert(new User("aa", "a123456", UserSexEnum.MAN));
26+
userMapper.insert(new User("bb", "b123456", UserSexEnum.WOMAN));
27+
userMapper.insert(new User("cc", "b123456", UserSexEnum.WOMAN));
2828

2929
Assert.assertEquals(3, userMapper.getAll().size());
3030
}
3131

3232
@Test
3333
public void testQuery() throws Exception {
34-
List<UserEntity> users = userMapper.getAll();
34+
List<User> users = userMapper.getAll();
3535
if(users==null || users.size()==0){
3636
System.out.println("is null");
3737
}else{
@@ -42,7 +42,7 @@ public void testQuery() throws Exception {
4242

4343
@Test
4444
public void testUpdate() throws Exception {
45-
UserEntity user = userMapper.getOne(6l);
45+
User user = userMapper.getOne(6l);
4646
System.out.println(user.toString());
4747
user.setNickName("neo");
4848
userMapper.update(user);

0 commit comments

Comments
 (0)