4.创建模块boot-dao

接下来的非应用模块创建我们可以参考 模块model 的创建过程，但是会给出必要的步骤供参考。

---

创建模块 boot-dao

图一 检查dao模块的参数

创建完毕后，将目录改造成图二红框中的样子，并修改boot-dao的pom.xml文件

图二 改造目录

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <parent>
        <artifactId>boot-parent</artifactId>
        <groupId>com.demo</groupId>
        <version>0.0.1-SNAPSHOT</version>
        <relativePath>../pom.xml</relativePath>
    </parent>
    <modelVersion>4.0.0</modelVersion>

    <artifactId>boot-dao</artifactId>

    <dependencies>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.2</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.11</version>
        </dependency>

        <dependency>
            <groupId>com.gitee.sunchenbin.mybatis.actable</groupId>
            <artifactId>mybatis-enhance-actable</artifactId>
            <version>1.0.3</version>
        </dependency>

        <dependency>
            <groupId>com.demo</groupId>
            <artifactId>boot-model</artifactId>
            <version>0.0.1-SNAPSHOT</version>
        </dependency>
    </dependencies>

</project>

同时修改父工程中的文件pom.xml 。将新增的boot-dao模块加入，请看文件中的注释部分。

    <modules>
        <module>boot-model</module>
       
       <!-- 将新增的boot-dao模块加入 -->
        <module>boot-dao</module>
    </modules>

    <dependencyManagement>
        <dependencies>

            <dependency>
                <groupId>boot-parent</groupId>
                <artifactId>boot-model</artifactId>
                <version>0.0.1-SNAPSHOT</version>
            </dependency>

           <!-- 将新增的boot-dao模块加入 -->
            <dependency>
                <groupId>boot-parent</groupId>
                <artifactId>boot-dao</artifactId>
                <version>0.0.1-SNAPSHOT</version>
            </dependency>

        </dependencies>
    </dependencyManagement>

---

在目录com.demo.dao.mapper下增加一个接口

图三 增加接口

package com.demo.dao.mapper;

import com.demo.model.db.AdminUser;
import org.apache.ibatis.annotations.*;
import org.springframework.stereotype.Component;

import java.util.List;

@Mapper
@Component(value = "adminUserDaoMapper")
public interface AdminUserDaoMapper {

    @Results(id = "adminUser", value = {
            @Result(property="loginNo",column="login_no"),
            @Result(property="password",column="password"),
            @Result(property="nickname",column="nickname"),
            @Result(property="sex",column="sex"),
            @Result(property="createTime",column="create_time"),
            @Result(property="updateTime",column="update_time"),
            @Result(property="remark",column="remark"),
    })
    @Select("SELECT * FROM admin_user ORDER BY create_time DESC")
    List<AdminUser> getAdminUserAllByDesc();

    @ResultMap("adminUser")
    @Select("SELECT * FROM admin_user nickname = #{nickname} limit 1;")
    AdminUser getAdminUserByName(@Param("nickname") String nickname);

    @Insert("insert into admin_user (" +
            "login_no, " +
            "password, " +
            "nickname, " +
            "sex, " +
            "create_time, " +
            "update_time, " +
            "remark) " +
            "values (" +
            "#{loginNo}, " +
            "#{password}, " +
            "#{nickname}, " +
            "'man', " +
            "sysdate(), " +
            "sysdate(), " +
            "'')")
    int insert(AdminUser data);

    @Update("UPDATE admin_user SET " +
            "password = #{password}," +
            "update_time = sysdate() " +
            "WHERE nickname = #{nickname}")
    void update(AdminUser data);

    @Update("delete admin_user WHERE nickname=#{nickname}")
    void delete(String nickname);
}