MyBatis通用Mapper是一款MyBatis增强插件,可以根据数据库表快速生成实体Entity、数据访问对象模型DAO,数据库映射文件Mapper。
一、新建数据库hello
1.1新建用户(user)表
1.2新建entity,dao,service,controller包,并在service下建类UserService,controller下建类UserController
二、整合通用Mapper
2.1在项目pom.xml中添加依赖
在pom.xml中<dependencies> </dependencies>标签下添加以下代码
<dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> <version>1.18.8</version> <scope>provided</scope> </dependency> <dependency> <groupId>tk.mybatis</groupId> <artifactId>mapper-spring-boot-starter</artifactId> <version>2.1.5</version> </dependency>
2.2、使新导入的依赖生效
注意:如果pom.xml中还继续报红线,可以先clean ,clean完要点击闪电标志后在nstall
2.3、在pom.xml中添加插件
继续添加依赖,整合通用代码生成器
在pom.xml中<dependencies> </dependencies>标签下添加以下代码
<plugin> <groupId>org.mybatis.generator</groupId> <artifactId>mybatis-generator-maven-plugin</artifactId> <version>1.3.6</version> <configuration> <configurationFile> ${basedir}/src/main/resources/generator/generatorConfig.xml </configurationFile> <overwrite>true</overwrite> <verbose>true</verbose> </configuration> <dependencies> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.16</version> </dependency> <dependency> <groupId>tk.mybatis</groupId> <artifactId>mapper</artifactId> <version>4.1.5</version> </dependency> </dependencies> </plugin>
2.4、在application.yml中添加数据库配置属性
将application.properties重命名成application.yml(并将以下代码写到里边)
spring: datasource: url: jdbc:mysql://localhost:3306/hello?serverTimezone=UTC username: root password: Aa123123. driver-class-name: com.mysql.cj.jdbc.Driver # driver-class-name: com.mysql.jdbc.Driver
注意:
driver-class-name: com.mysql.cj.jdbc.Driver用于mysql版本8.0.x以上
driver-class-name: com.mysql.jdbc.Driver用于mysql版本8.0.x版本以下
2.5、 配置通用mapper
在resource中创建文件夹generator及配置文件config.properties和generatorConfig.xml
2.5.1、配置config.properties
#jdbc.driverClass=com.mysql.cj.jdbc.Driver jdbc.driverClass=com.mysql.jdbc.Driver jdbc.url=jdbc:mysql://localhost:3306/hello?serverTimezone=UTC jdbc.user=root jdbc.password=Aa123123. # 模块名 moduleName=user # 表名 tableName=user
注意:jdbc.url=jdbc:mysql://localhost:3306/hello?serverTimezone=UTC时区要与application.yml的时区一致
2.5.2、配置generatorConfig.xml
<!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN" "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd"> <generatorConfiguration> <properties resource="generator/config.properties"/> <context id="Mysql" targetRuntime="MyBatis3Simple" defaultModelType="flat"> <property name="beginningDelimiter" value="`"/> <property name="endingDelimiter" value="`"/> <plugin type="tk.mybatis.mapper.generator.MapperPlugin"> <property name="mappers" value="tk.mybatis.mapper.common.Mapper"/> <property name="caseSensitive" value="true"/> <property name="lombok" value="Getter,Setter,ToString"/> </plugin> <jdbcConnection driverClass="${jdbc.driverClass}" connectionURL="${jdbc.url}" userId="${jdbc.user}" password="${jdbc.password}"> </jdbcConnection> <!--实体--> <javaModelGenerator targetPackage="com.example.user.entity.${moduleName}" targetProject="src/main/java"/> <!--mapper.xml--> <sqlMapGenerator targetPackage="com.example.user.dao.${moduleName}" targetProject="src/main/resources"/> <!--mapper接口--> <javaClientGenerator targetPackage="com.example.user.dao.${moduleName}" targetProject="src/main/java" type="XMLMAPPER"/> <!--为哪张表生成代码--> <table tableName="${tableName}"> <generatedKey column="id" sqlStatement="JDBC"/> </table> </context> </generatorConfiguration>
注意:红色的部分要与对应的包匹配
2.6、通过mybatis-generator生成代码
代码生成器的使用方式:可以自动生成实体、dao和mapper.xml
在项目目录中可以看到已经生成的User和UserMapper
三、测试
3.1 在BootApplication中添加@MapperScan注解扫描dao
3.2在UserService中写方法(代码如下)
public class UserService { @Autowired(required = false) private UserMapper userMapper; public String getSex(String username){ String result=""; User u=new User(); u.setUsername(username); List<User> urs = userMapper.select(u); int res=urs.get(0).getSex(); if(res==1){ result="男"; }else if (res==2){ result="女"; } return result; }
3.3在UserController中写方法(代码如下)
public class UserController { @Autowired private UserService userService; @GetMapping("/getSex/{username}") public String getSex(@PathVariable String username){ return userService.getSex(username); }