通用Mapper一 _通用mapper

将相本无种，男儿当自强。这篇文章主要讲述通用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接口