本來打算寫個使用Sharding-JDBC的例程，但是在搭建Mybatis的過程中，一波三折，因為好久沒搭建項目了，另外加上換了電腦。所以很破折，在這里記錄一下Spring Boot整合Mybatis吧。可能很簡單，但是我長時間沒用忘記了，我這里備忘一下吧。

一、項目目錄結構

注意這里Application文件的位置，它是與controller、entity、mapper、service等包處于并列的關系。

二、數(shù)據(jù)庫文件

SET NAMES utf8mb4;SET FOREIGN_KEY_CHECKS = 0;-- ------------------------------ Table structure for t_user_00-- ----------------------------DROP TABLE IF EXISTS `t_user_00`;CREATE TABLE `t_user_00` ( `id` int(0) NOT NULL AUTO_INCREMENT, `user_id` int(0) NOT NULL, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `age` int(0) NOT NULL, PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;SET FOREIGN_KEY_CHECKS = 1;

三、pom.xml

<?xml version='1.0' encoding='UTF-8'?><project xmlns='http://maven.apache.org/POM/4.0.0' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xsi:schemaLocation='http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd'> <modelVersion>4.0.0</modelVersion> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>2.1.13.RELEASE</version> <relativePath/> <!-- lookup parent from repository --> </parent> <groupId>com.gougou</groupId> <artifactId>shardingjdbc-shardingtable-demo</artifactId> <version>0.0.1-SNAPSHOT</version> <name>shardingjdbc-shardingtable-demo</name> <description>shardingjdbc-shardingtable-demo</description> <properties> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> <java.version>1.8</java.version> </properties> <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> <optional>true</optional> </dependency> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>1.3.2</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> </dependency> </dependencies> <build> <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> </plugin> </plugins> </build></project>

四、application.yml

# 數(shù)據(jù)源spring: application: name: shardingjdbc-shardingtable-demo datasource: url: jdbc:mysql://localhost:3306/sharding_0?serverTimezone=UTC username: root password: root driver-class-name: com.mysql.jdbc.Driver dbcp2: min-idle: 5# 數(shù)據(jù)庫連接池的最小維持連接數(shù) initial-size: 5 # 初始化連接數(shù) max-total: 5# 最大連接數(shù) max-wait-millis: 150 # 等待連接獲取的最大超時時間# mybatis配置mybatis: mapper-locations: classpath:mapper/*.xml # mapper映射文件位置 type-aliases-package: com.gouggou.shardingtable.entity # 實體類所在的位置 configuration: log-impl: org.apache.ibatis.logging.stdout.StdOutImpl #用于控制臺打印sql語句

五、啟動類Application

說明：

1、@MapperScan的：掃描mapper接口的位置

2、@ComponentScan：如果Application文件的位置不是與controller、entity、mapper、service等包處于并列的關系。就要用此注解，否則可以不用；

@MapperScan('com.gouggou.shardingtable.mapper')@SpringBootApplicationpublic class Application { public static void main(String[] args) { SpringApplication.run(Application.class, args); }}

六、controller

@RequestMapping('student')@RestControllerpublic class UserController { @Autowired private UserService userService; @RequestMapping('save') public String save() { User user = new User(); user.setUserId(new Random().nextInt( 1000 ) + 1); user.setName('張三'+user.getUserId()); user.setAge(new Random().nextInt( 80 ) + 1); userService.insert(user); return user.getName()+'創(chuàng)建成功！'; }}

七、service

public interface UserService { Integer insert(User u); List<User> findAll(); List<User> findByUserIds(List<Integer> userIds);}

@Servicepublic class UserServiceImpl implements UserService { @Autowired private UserMapper userMapper; @Override public Integer insert(User u) { return userMapper.insert(u); } @Override public List<User> findAll() { return userMapper.findAll(); } @Override public List<User> findByUserIds(List<Integer> userIds) { return userMapper.findByUserIds(userIds); }}

八、entity

@Datapublic class User implements Serializable { private static final long serialVersionUID = -5514139686858156155L; private Integer id; private Integer userId; private String name; private Integer age;}

九、Mapper

@Repositorypublic interface UserMapper { Integer insert(User u); List<User> findAll(); List<User> findByUserIds(List<Integer> userIds);}

<?xml version='1.0' encoding='UTF-8' ?><!DOCTYPE mapper PUBLIC '-//mybatis.org//DTD Mapper 3.0//EN' 'http://mybatis.org/dtd/mybatis-3-mapper.dtd' ><mapper namespace='com.gouggou.shardingtable.mapper.UserMapper' > <resultMap type='com.gouggou.shardingtable.entity.User' > <id column='id' property='id' jdbcType='INTEGER' /> <result column='user_id' property='userId' jdbcType='INTEGER' /> <result column='name' property='name' jdbcType='VARCHAR' /> <result column='age' property='age' jdbcType='INTEGER' /> </resultMap> <insert id='insert'> insert into t_user_00 (user_id,name,age) values (#{userId},#{name},#{age}) </insert> <select resultMap='resultMap'> select <include refid='columnsName'/> from t_user_00 </select> <select resultMap='resultMap'> select <include refid='columnsName'/> from t_user_00 where user_id in ( <foreach collection='list' item='item' separator=','> #{item} </foreach> ) </select> <sql id='columnsName'> id,user_id,name,age </sql></mapper>

十、遇到的問題

1、idea 右鍵無java class選項

2、maven倉庫中產生后綴是LastUpdated的文件

以上就是本文的全部內容，希望對大家的學習有所幫助，也希望大家多多支持好吧啦網(wǎng)。