将相本无种，男儿当自强。这篇文章主要讲述通用Mapper一相关的知识，希望能为你提供帮助。
1 引入 1.1 作用

• 替我们生成常用的增删改查操作的SQL语句。

1.2 代码官方发布地址

• 通用mapper

 
2 快速入门 2.1 创建测试数据

• sql脚本

文章图片

文章图片

SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for employee -- ---------------------------- DROP TABLE IF EXISTS `employee`; CREATE TABLE `employee`( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ‘姓名‘, `salary` decimal(10, 2) NULL DEFAULT NULL COMMENT ‘工资‘, `age` int(11) NULL DEFAULT NULL COMMENT ‘年龄‘, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of employee -- ---------------------------- INSERT INTO `employee` VALUES (1, ‘tom‘, 12345.65, 26); INSERT INTO `employee` VALUES (2, ‘jerry‘, 5468.10, 15); INSERT INTO `employee` VALUES (3, ‘xuweiwei‘, 12345678.90, 27); INSERT INTO `employee` VALUES (4, ‘sunxiaping‘, 11111.11, 28); INSERT INTO `employee` VALUES (5, ‘haha‘, 5648.12, 58); SET FOREIGN_KEY_CHECKS = 1;

View Code

• 实体类

文章图片

文章图片

package com.xuweiwei.commonmapper.model; /** * @describe: * @author: 不为往事扰，余生只爱笑。 * @version: 1.0 */ public class Employee {private Integer id; private String name; private Double salary; private Integer age; public Integer getId() { return id; }public void setId(Integer id) { this.id = id; }public String getName() { return name; }public void setName(String name) { this.name = name; }public Double getSalary() { return salary; }public void setSalary(Double salary) { this.salary = salary; }public Integer getAge() { return age; }public void setAge(Integer age) { this.age = age; } }

View Code 2.2 mybatis整合Spring环境

• pom.xml

文章图片

文章图片

< dependency> < groupId> junit< /groupId> < artifactId> junit< /artifactId> < version> 4.12< /version> < scope> test< /scope> < /dependency> < dependency> < groupId> log4j< /groupId> < artifactId> log4j< /artifactId> < version> 1.2.17< /version> < /dependency> < dependency> < groupId> cglib< /groupId> < artifactId> cglib< /artifactId> < version> 2.2< /version> < /dependency> < dependency> < groupId> org.aspectj< /groupId> < artifactId> aspectjweaver< /artifactId> < version> 1.6.8< /version> < /dependency> < dependency> < groupId> org.slf4j< /groupId> < artifactId> slf4j-api< /artifactId> < version> 1.7.7< /version> < /dependency> < dependency> < groupId> org.slf4j< /groupId> < artifactId> slf4j-log4j12< /artifactId> < version> 1.7.7< /version> < /dependency> < dependency> < groupId> org.mybatis< /groupId> < artifactId> mybatis< /artifactId> < version> 3.2.8< /version> < /dependency> < dependency> < groupId> org.mybatis< /groupId> < artifactId> mybatis-spring< /artifactId> < version> 1.2.2< /version> < /dependency> < dependency> < groupId> com.mchange< /groupId> < artifactId> c3p0< /artifactId> < version> 0.9.2< /version> < /dependency> < dependency> < groupId> org.springframework< /groupId> < artifactId> spring-context< /artifactId> < version> 4.3.10.RELEASE< /version> < /dependency> < dependency> < groupId> mysql< /groupId> < artifactId> mysql-connector-java< /artifactId> < version> 5.1.37< /version> < /dependency> < dependency> < groupId> org.springframework< /groupId> < artifactId> spring-orm< /artifactId> < version> 4.3.10.RELEASE< /version> < /dependency> < dependency> < groupId> org.springframework< /groupId> < artifactId> spring-test< /artifactId> < version> 4.3.10.RELEASE< /version> < /dependency>

View Code

• jdbc.properties

文章图片

文章图片

jdbc.user=root jdbc.password=123456 jdbc.url=jdbc:mysql://localhost:3306/mapper?useUnicode=true& characterEncoding=utf8 jdbc.driver=com.mysql.jdbc.Driver

View Code

• mybatis-config.xml

文章图片

文章图片

< ?xml version="1.0" encoding="UTF-8"?> < !DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> < configuration> < /configuration>

View Code

• log4j.properties

文章图片

文章图片

log4j.rootLogger=DEBUG,myConsole log4j.appender.myConsole=org.apache.log4j.ConsoleAppender log4j.appender.myConsole.ImmediateFlush=true log4j.appender.myConsole.Target=System.out log4j.appender.myConsole.layout=org.apache.log4j.PatternLayout log4j.appender.myConsole.layout.ConversionPattern=[%-5p] %d(%r) --> [%t] %l: %m %x %nlog4j.logger.com.mchange.v2=debug

View Code

• applicationContext.xml

文章图片

文章图片

< ?xml version="1.0" encoding="UTF-8"?> < beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.3.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd"> < context:component-scan base-package="com.xuweiwei.commonmapper"> < /context:component-scan> < !-- 配置数据源 --> < context:property-placeholder location="classpath:jdbc.properties"/> < bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> < property name="user" value="https://www.songbingjia.com/android/${jdbc.user}"/> < property name="password" value="https://www.songbingjia.com/android/${jdbc.password}"/> < property name="jdbcUrl" value="https://www.songbingjia.com/android/${jdbc.url}"/> < property name="driverClass" value="https://www.songbingjia.com/android/${jdbc.driver}"/> < /bean> < !-- 整合MyBatis --> < bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean"> < property name="configLocation" value="https://www.songbingjia.com/android/classpath:mybatis-config.xml"/> < property name="dataSource" ref="dataSource"/> < /bean> < !-- 整合通用Mapper所需要做的配置修改： --> < bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> < property name="basePackage" value="https://www.songbingjia.com/android/com.xuweiwei.commonmapper.mapper"/> < /bean> < !-- 配置声明式事务 --> < bean id="dataSourceTransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> < property name="dataSource" ref="dataSource"/> < /bean> < tx:annotation-driven transaction-manager="dataSourceTransactionManager"/> < /beans>

View Code

• 测试

文章图片

文章图片

package com.xuweiwei.commonmapper; import org.junit.Test; import org.junit.runner.RunWith; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.test.context.ContextConfiguration; import org.springframework.test.context.junit4.SpringJUnit4ClassRunner; import javax.sql.DataSource; /** * @describe: * @author: 不为往事扰，余生只爱笑。 * @version: 1.0 */ @RunWith(value = https://www.songbingjia.com/android/SpringJUnit4ClassRunner.class) @ContextConfiguration(locations ="classpath:applicationContext.xml") public class CommonMapperTest {@Autowired private DataSource dataSource; @Test public void testDataSource() { System.out.println(dataSource); }}

View Code 2.3 集成通用mapper

• 加入通用mapper的jar包

< dependency> < groupId> tk.mybatis< /groupId> < artifactId> mapper< /artifactId> < version> 4.1.5< /version> < /dependency>

• 修改applicationContext.xml文件

< !-- 整合通用Mapper所需要做的配置修改： --> < !--原生mybatis org.mybatis.spring.mapper.MapperScannerConfigurer--> < !--通用mapper tk.mybatis.spring.mapper.MapperScannerConfigurer--> < bean class="tk.mybatis.spring.mapper.MapperScannerConfigurer"> < property name="basePackage" value="https://www.songbingjia.com/android/com.xuweiwei.commonmapper.mapper"/> < /bean>

文章图片

文章图片

< ?xml version="1.0" encoding="UTF-8"?> < beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.3.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd"> < context:component-scan base-package="com.xuweiwei.commonmapper"> < /context:component-scan> < !-- 配置数据源 --> < context:property-placeholder location="classpath:jdbc.properties"/> < bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> < property name="user" value="https://www.songbingjia.com/android/${jdbc.user}"/> < property name="password" value="https://www.songbingjia.com/android/${jdbc.password}"/> < property name="jdbcUrl" value="https://www.songbingjia.com/android/${jdbc.url}"/> < property name="driverClass" value="https://www.songbingjia.com/android/${jdbc.driver}"/> < /bean> < !-- 整合MyBatis --> < bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean"> < property name="configLocation" value="https://www.songbingjia.com/android/classpath:mybatis-config.xml"/> < property name="dataSource" ref="dataSource"/> < /bean> < !-- 整合通用Mapper所需要做的配置修改： --> < !--原生mybatis org.mybatis.spring.mapper.MapperScannerConfigurer--> < !--通用mapper tk.mybatis.spring.mapper.MapperScannerConfigurer--> < bean class="tk.mybatis.spring.mapper.MapperScannerConfigurer"> < property name="basePackage" value="https://www.songbingjia.com/android/com.xuweiwei.commonmapper.mapper"/> < /bean> < !-- 配置声明式事务 --> < bean id="dataSourceTransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> < property name="dataSource" ref="dataSource"/> < /bean> < tx:annotation-driven transaction-manager="dataSourceTransactionManager"/> < /beans>

View Code 2.4 创建具体的Mapper接口

• EmployeeMapper.java

【通用Mapper一】 

推荐阅读

• 

  第一次使用微波炉要清洗吗，微波炉清洗完可以直接用吗
• 

  副科级相当于什么军衔
• 

  【WordPress】提升网站打开速度，图片优化神器ShortPixel Image Optimizer使用教程
• 

  网上报税下载哪个app etax网上报税哪里下载，网上报税用什么软件
• 

  林内即享热水器代码是什么故障,出现这故障是什么原因
• 

  罗勒酱是什么酱 罗勒酱是什么
• 

  哪些娱乐圈八卦你听了觉得难以置信？
• 

  血管|秋冬输液能通血管？医生根本没推荐过！这个害死人的“秘方”别再信了
• 

  屏幕跳到最下方
• 

  玩吧app怎么加好友 关于在玩吧APP中添加好友的图文教程
• 

  伊万格琳娜·艾格洛蒲露丝伊万格丽娜
• 

  庆东锅炉锅炉面板显示16故障怎么解决,只要注意好这几点就行
• 

  水星MW310R，水星MW310R怎么样水星MW310R好吗
• 

  卡片相机一般用哪种三脚架比较好？
• 

  爱上了比自己大16岁的已婚大叔,是否是不好的结局？
• 

  vue-cli|vue-cli rem自适应 px to rem
• 

  聊聊springboot项目全局异常处理那些事儿
• 

  司机抱小孩开车算违章吗 司机抱着小孩开车怎么处罚
• 

  鲁滨逊漂流记与格列佛游记的不同
• 

  车载导航系统刷机方法有哪些

• android 全屏dialog dialogfragment
• Vant Weapp小程序蹲坑Page is not constructed because it
• 如何使用Basic R制作直方图
• SQLite入门指南（图解）
• Python中的SQLite用法指南
• 电子表格中的VLOOKUP进行数据整理
• SQL Where子句用法简介
• Power BI和SQL用法实例
• 18个最常见的Python列表问题