spring 整合通用mapper

spring 搭建mybatis

1.创建一个maven工程,可以是web类型的,也可以不是.

2.在pom.xml中导入依赖

    <dependencies>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.11</version>
            <scope>test</scope>
        </dependency>

        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>5.1.9.RELEASE</version>
        </dependency>

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.21</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.17</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>5.1.9.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.3</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>1.3.0</version>
        </dependency>
        <dependency>
            <groupId>tk.mybatis</groupId>
            <artifactId>mapper</artifactId>
            <version>4.1.5</version>
        </dependency>
    </dependencies>

其中通用mapper最重要的jar包是

然后在applicationContext.xml中进行mybatis的配置

?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:context="http://www.springframework.org/schema/context"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
        https://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context
        https://www.springframework.org/schema/context/spring-context.xsd">
    <context:property-placeholder location="classpath:*.properties"/>

    <bean name="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
        <property name="driverClassName" value="${jdbc.driver}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
    </bean>
<!--  注入InforDao-->
    <bean id="inforService" class="rui.dong.service.imp.InforServiceImp">
        <property name="inforDao" ref="inforDao"/>
    </bean>
    <bean class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <property name="typeAliasesPackage" value="rui.dong.domain"/>
<!--        配置该配置,可以让InforDao.xml文件和InforDao的目录不必相同-->
<!--        <property name="mapperLocations" value="classpath:InforDao.xml"/>-->
    </bean>

<!--    加载mybatis映射配置的扫描，将其作为spring的bean进行管理-->
<!--    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="rui.dong.dao"/>
    </bean>--> 
<!--    通用mapper   该步的配置是通用mapper的重点之处,内容的注入的InforDao的接口-->   
    <bean class="tk.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="rui.dong.dao"/>
    </bean>

数据库的连接使用阿里爸爸的第三方bean进行配置,使用Druid的中的dataSource

mybatis整合完毕后,就是数据层和业务层的代码的处理

先创建一个pojo 对应数据表中的属性

package rui.dong.domain;

import com.sun.javafx.beans.IDProperty;

import javax.persistence.Id;
import javax.persistence.Table;
import java.io.Serializable;
public class Infor implements Serializable {
    @Id
    private Integer id;
    private String name;
    private String money;

    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 String getMoney() {
        return money;
    }

    public void setMoney(String money) {
        this.money = money;
    }

    @Override
    public String toString() {
        return "Infor{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", money='" + money + '\'' +
                '}';
    }
}

注意:@Id 注释是不能够省略的,代表该表的主键的位置所在

Dao数据层 接口书写要求

package rui.dong.dao;

import rui.dong.domain.Infor;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

public interface InforDao extends Mapper<Infor> {
}

该接口要继承 tk.mybatis.mapper.common.Mapper mapper接口,泛型为pojo类的类型 该接口中有大量的方法使用,可以不用写sql语句就可以对表格进行使用

业务层的实现类

package rui.dong.service.imp;

import rui.dong.dao.InforDao;
import rui.dong.domain.Infor;
import rui.dong.service.InforService;

import java.util.List;

public class InforServiceImp implements InforService {
    private InforDao inforDao;

    public void setInforDao(InforDao inforDao) {
        this.inforDao = inforDao;
    }

    @Override
    public Infor findById(Integer id) {
        return inforDao.selectByPrimaryKey(id);
    }

    @Override
    public List<Infor> findByAll() {
        return inforDao.selectAll();
    }
}

前面的applicationContext.xml已经将InforDao类型对象进行注入操作,然后调用mapper里面的方法来实现所需要的功能 ,但是注意    

自己书写的方法的名称最好不要和mapper接口自带的方法名字冲突 ,不然会报错误!

最后一步就可以进行功能的实现

package rui.dong;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import rui.dong.domain.Infor;
import rui.dong.service.InforService;

import java.util.List;

public class AppTest {
    public static void main(String[] args) {
        ApplicationContext applicationContext = new ClassPathXmlApplicationContext("applicationContext.xml");
        InforService inforService = applicationContext.getBean(InforService.class);
        List<Infor> all = inforService.findByAll();
        for (Infor infor : all) {
            System.out.println(infor);
        }
        Infor id = inforService.findById(1);
        System.out.println(id);
    }
}

就不需要mybatis自带的映射文件,

运行结果: