我的第一个SSM项目（4）：集成MyBatic框架

前面我们已经在IDEA中配置了maven与tomcat
配置maven与tomcat教程
IEDA集成Spring
IEDA集成SpringMVC

这一章节我们来在IDEA中集成MyBatis框架

1.配置pom.xml

<!--MyBatis-->
    <mybatis.version>3.4.6</mybatis.version>
    <mysql.connector.java.version>5.1.32</mysql.connector.java.version>
    <druid.version>1.1.9</druid.version>
    <mybatis.spring.version>1.3.2</mybatis.spring.version>

<!--MyBatis-->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>${mysql.connector.java.version}</version>
      <scope>runtime</scope>
    </dependency>
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>druid</artifactId>
      <version>${druid.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>${spring.version}</version>
    </dependency>
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>${mybatis.version}</version>
    </dependency>
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis-spring</artifactId>
      <version>${mybatis.spring.version}</version>
    </dependency>

2.创建jdbc.properties配置文件
在/src/main/resource中创建，该配置文件主要设置驱动和连接数据库配置信息

//驱动
jdbc.driverClassName=com.mysql.jdbc.Driver
//mysql连接信息
jdbc.url=jdbc.mysql://127.0.0.1:3306/idea_db?serverTimezone=GMT
//用户名
jdbc.username=root
//密码
jdbc.password=123

3.配置applicationContext.xml
添加如下代码：

<!--集成MyBatis -->
    <!--1.配置数据库相关参数 -->
    <context:property-placeholder location="classpath:jdbc.properties" ignore-unresolvable="true"/>
    <!--2.数据源druid -->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"
    init-method="init" destroy-method="close">
        <property name="driverClassName" value="${jdbc.driverClassName}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="jdbc.username"/>
        <property name="password" value="jdbc.password"/>

    </bean>
    <!--3.配置SqlSessionFactory对象 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!--注入数据库连接池 -->
        <property name="dataSource" ref="dataSource"/>
        <!--扫描sql配置文件：mapper需要的xml文件 -->
        <property name="mapperLocations" value="classpath:mapper/*.xml"/>
    </bean>

    <!--扫描basePackage下所有的@MyBatisDao注解的接口 -->
    <bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
        <property name="basePackage" value="com.hermit.dao"/>
    </bean>

4.创建数据库
在MySQL中创建表hermit_user
id bigint 自增 主键
username varchar
password varchar

5.创建实体类对象HermitUser
创建对象位置：/src/main/java/com.hermit.model

public class HermitUser implements Serializable {
    private Integer id;
    private String username;
    private String password;

    public void setId(int id){
        this.id = id;
    }
    public int getId(){
        return id;
    }

    public void setUsername(String username){
        this.username = username;
    }
    public String getUsername(){
        return username;
    }
    public void setPassword(String password){
        this.password = password;
    }
    public String getPassword(){
        return password;
    }

}

6.创建接口HermitUserDao
创建对象位置：/src/main/java/com.hermit.dao
HermitUserDao是一个接口，我们在这个接口里提供一个findAll的方法

package com.hermit.dao;

import com.hermit.model.HermitUser;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface HermitUserDao {
    List<HermitUser> findAll();
}

7.创建服务层接口HermitUserService
创建对象位置：/src/main/java/com.hermit.service

package com.hermit.service;

import com.hermit.model.HermitUser;

import java.util.List;

public interface HermitUserService {
    List<HermitUser> findAll();
}

8.创建服务层实现类HermitUserServiceImpl
创建对象位置：/src/main/java/com.hermit.service.impl

package com.hermit.service.impl;

import com.hermit.dao.HermitUserDao;
import com.hermit.model.HermitUser;
import com.hermit.service.HermitUserService;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.util.List;

@Service
public class HermitUserServiceImpl implements HermitUserService {
    @Resource
    private HermitUserDao hermitUserDao;
    public List<HermitUser> findAll(){
        return hermitUserDao.findAll();
    }
}

实现类注入HermitUserDao接口，实现finAll方法，在findAll方法中调用HermitUserDao的findAll方法
9.创建控制层HermitUserController
创建对象位置：/src/main/java/com.hermit.controller

package com.hermit.controller;

import com.hermit.model.HermitUser;
import com.hermit.service.HermitUserService;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;

import javax.annotation.Resource;
import java.util.List;

@Controller
@RequestMapping(value = "/user")
public class HermitUserController {
    @Resource
    private HermitUserService hermitUserService;
    @GetMapping("/findAll")
    public String finAll(Model model){
        List<HermitUser> hermitUserList = hermitUserService.findAll();
        for(HermitUser hermitUser:hermitUserList){
            System.out.println("id"+hermitUser.getId());
            System.out.println("username"+hermitUser.getUsername());
        }
        return "hello";
    }
}

10.创建HermitUserMapper.xml
创建对象位置：/src/main/resources/mapper

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.hermit.dao.HermitUserDao">
    <sql id="userField">
        a.id as "id",
        a.username = "username",
        a.password = "password"
    </sql>
    <!--获取所有用户 -->
    <select id="findAll" resultType="com.hermit.model.HermitUser">
        select
        <include refid="userField"/>
        from hermit_user as a
    </select>
</mapper>

用tomca运行 可以在控制台看到输出的数据库信息，集成MyBatis成功。