當(dāng)前位置：首頁 > 编程资源 > 编程问答 >内容正文

编程问答

tkMapper的使用

發(fā)布時(shí)間：2024/1/1 编程问答 19 豆豆

生活随笔收集整理的這篇文章主要介紹了 tkMapper的使用小編覺得挺不錯(cuò)的,現(xiàn)在分享給大家,幫大家做個(gè)參考.

tkMapper的使用

- - - 1. 整合tkMapper
    - - 1.1 添加tkMapper依賴
      - 1.2 修改啟動類的`@MapperScan`注解的包為`tk.mybatis.spring.annotation.MapperScan`
    - 2.使用tkMapper
    - - 2.1 創(chuàng)建數(shù)據(jù)表
      - 2.2 創(chuàng)建實(shí)體類
      - 2.3 創(chuàng)建Dao
      - 2.4 測試
    - 3. tkMapper-條件查詢
    - 4.逆向工程
    - - 4.1 添加逆向工程依賴
      - 4.2 配置
      - 4.3 運(yùn)行

基于MyBatis提供了很多第三方插件，這些插件通常可以完成數(shù)據(jù)操作方法的封裝、數(shù)據(jù)庫逆向工程工作（根據(jù)數(shù)據(jù)表生成實(shí)體類、生成映射文件）

myBatis-plus
tkMapper

tkMapper是一個(gè)MyBatis插件，是在MyBatis的基礎(chǔ)上提供了很多的工具，讓開發(fā)變簡單，提高開發(fā)效率。

提供了針對單表通用的數(shù)據(jù)庫操作方法
提供了逆向工程（根據(jù)數(shù)據(jù)表生成實(shí)體類、Dao、映射文件）

1. 整合tkMapper

1.1 添加tkMapper依賴

<dependency><groupId>tk.mybatis</groupId><artifactId>mapper-spring-boot-starter</artifactId><version>2.1.5</version> </dependency>

1.2 修改啟動類的@MapperScan注解的包為tk.mybatis.spring.annotation.MapperScan

2.使用tkMapper

2.1 創(chuàng)建數(shù)據(jù)表

CREATE TABLE `schools` (`s_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '學(xué)校id',`s_name` varchar(100) NOT NULL COMMENT '學(xué)校名稱',`s_loc_provice` varchar(100) NOT NULL DEFAULT '' COMMENT '學(xué)校所處省',`s_loc_city` varchar(100) DEFAULT '' COMMENT '學(xué)校所處市',`s_loc_district` varchar(100) DEFAULT '' COMMENT '學(xué)校所處區(qū)',`s_loc_specific` varchar(100) DEFAULT '' COMMENT '學(xué)校區(qū)下的具體位置',PRIMARY KEY (`s_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='學(xué)校基本信息表';

2.2 創(chuàng)建實(shí)體類

@Data @NoArgsConstructor @AllArgsConstructor @Table(name = "schools") // 指定實(shí)體類對應(yīng)的數(shù)據(jù)表的表名 public class School {@Idprivate Integer sId;private String sName;private String sLocProvice;private String sLocCity;private String sLocDistrict;private String sLocSpecific; // 注意：該命名方式對應(yīng)數(shù)據(jù)表：s_loc_specific }

如果數(shù)據(jù)表的命名方式和實(shí)體類不一致，則可以采取注解的方式來對應(yīng)
比如：

public class School {@Column(name = "s_id")@Idprivate Integer sId; }

2.3 創(chuàng)建Dao

import com.computerskills.competition.entity.School; import tk.mybatis.mapper.common.Mapper; import tk.mybatis.mapper.common.MySqlMapper;public interface SchoolDao extends Mapper<School>, MySqlMapper<School> { }

2.4 測試

右鍵：
選擇test
選擇Junit4
添加依賴

<dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-test</artifactId><scope>test</scope> </dependency><dependency><groupId>junit</groupId><artifactId>junit</artifactId><scope>test</scope><version>4.13.2</version> </dependency>

編寫測試類

import com.computerskills.competition.CompetitionApplication; import com.computerskills.competition.entity.School; import org.junit.Test; import org.junit.runner.RunWith; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.boot.test.context.SpringBootTest; import org.springframework.test.context.junit4.SpringRunner;@RunWith(SpringRunner.class) @SpringBootTest(classes = CompetitionApplication.class) public class SchoolDaoTest {@Autowiredprivate SchoolDao schoolDao;@Testpublic void test() {School school = new School();school.setSName("成都大學(xué)");school.setSLocProvice("四川省");school.setSLocCity("成都市");school.setSLocDistrict("成華區(qū)");school.setSLocSpecific("成洛大道2025號");int i = schoolDao.insert(school);System.out.println(i);} }

3. tkMapper-條件查詢

基本查詢

@Test public void test() {// 條件查詢// 1. 創(chuàng)建一個(gè)Example封裝類別School查詢條件Example example = new Example(School.class);// 2. 創(chuàng)建條件容器Example.Criteria criteria = example.createCriteria();// 3.選擇sId == 1 或者 sId == 2的數(shù)據(jù) ,這里的sId對應(yīng)實(shí)體類的字段 // criteria.andEqualTo("sId",1); // criteria.orEqualTo("sId",2);// 4. 查詢sName中含有`大學(xué)`字樣的數(shù)據(jù)criteria.andLike("sName", "%大學(xué)");List<School> schoolList = schoolDao.selectByExample(example);for (School school: schoolList) {System.out.println(school);}// 查詢記錄總條數(shù)System.out.println(schoolDao.selectCount(new School()));// 查詢記錄總條數(shù)（滿足條件）System.out.println(schoolDao.selectCountByExample(example));

分頁查詢

@Test public void test2() {// 基本的分頁查詢int pageNum = 2;int pageSize = 10;int start = (pageNum-1)*pageSize;// 構(gòu)造分頁信息RowBounds rowBounds = new RowBounds(start, pageSize);List<School> schoolList = schoolDao.selectByRowBounds(new School(),rowBounds);for (School school: schoolList) {System.out.println(school);} } @Test public void test3() {// 帶有條件的分頁查詢Example example = new Example(School.class);Example.Criteria criteria = example.createCriteria();criteria.andEqualTo("sId",1);int pageNum = 1;int pageSize = 10;int start = (pageNum-1)*pageSize;RowBounds rowBounds = new RowBounds(start, pageSize);List<School> schoolList = schoolDao.selectByExampleAndRowBounds(example,rowBounds);for (School school: schoolList) {System.out.println(school);} }

4.逆向工程

4.1 添加逆向工程依賴

mybatis的一個(gè)maven依賴

<plugin><groupId>org.mybatis.generator</groupId><artifactId>mybatis-generator-maven-plugin</artifactId><version>1.3.5</version><dependencies><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>8.0.27</version></dependency><dependency><groupId>tk.mybatis</groupId><artifactId>mapper</artifactId><version>4.1.5</version></dependency></dependencies></plugin>

4.2 配置

在resources/generator目錄下創(chuàng)建generatorConfig.xml
內(nèi)容如下：

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE generatorConfigurationPUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN""http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd"><generatorConfiguration> <context id="Mysql" targetRuntime="MyBatis3Simple" defaultModelType="flat"><property name="beginningDelimiter" value=""></property><property name="endimgDelimiter" value=""></property> <plugin type="tk.mybatis.mapper.generator.MapperPlugin"><property name="mappers" value="com.computerskills.competition.general.GeneralDao"></property></plugin><jdbcConnection driverClass="com.mysql.jdbc.Driver"connectionURL="jdbc:mysql://localhost:3306/used"userId="root"password="123456"></jdbcConnection><javaModelGenerator targetPackage="com.computerskills.competition.entity" targetProject="src/main/java"/><sqlMapGenerator targetPackage="/" targetProject="src/main/resources/mappers"/><javaClientGenerator targetPackage="com.computerskills.competition.dao" targetProject="src/main/java" type="XMLMAPPER"/>   <table tableName="goods"><generatedKey column="g_id" sqlStatement="Mysql" identity="true"></generatedKey></table></context> </generatorConfiguration>

將配置文件設(shè)置到逆向工程的maven插件中

<configuration> <configurationFile>${basedir}/src/main/resources/generator/generatorConfig.xml</configurationFile></configuration>

4.3 運(yùn)行

總結(jié)

以上是生活随笔為你收集整理的tkMapper的使用的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。

tkmapper