Mybatis(三)

一、目录结构

 二、代码

1、UserDao

package cn.bijian.dao;

import cn.bijian.model.User;
import cn.bijian.model.User2;
import cn.bijian.pojo.QueryVo;

import java.util.List;

public interface UserDao {
    /*
    根据QueryVo中的条件查询用户
     */
    List<User> findByVo(QueryVo queryVo);
    /*
    查询所有用户(使用别名)
     */
    List<User2> findAll2();

    /*
    查询所有用户(使用resultMap)
     */
    List<User2> findAll3();
}

2、User2

package cn.bijian.model;

import java.util.Date;

public class User2 {
    private Integer userId;
    private String userName;
    private Date userBirthday;
    private String userSex;
    private String userAddress;

    public Integer getUserId() {
        return userId;
    }

    public void setUserId(Integer userId) {
        this.userId = userId;
    }

    public String getUserName() {
        return userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public Date getUserBirthday() {
        return userBirthday;
    }

    public void setUserBirthday(Date userBirthday) {
        this.userBirthday = userBirthday;
    }

    public String getUserSex() {
        return userSex;
    }

    public void setUserSex(String userSex) {
        this.userSex = userSex;
    }

    public String getUserAddress() {
        return userAddress;
    }

    public void setUserAddress(String userAddress) {
        this.userAddress = userAddress;
    }

    @Override
    public String toString() {
        return "User2{" +
                "userId=" + userId +
                ", userName='" + userName + '\'' +
                ", userBirthday=" + userBirthday +
                ", userSex='" + userSex + '\'' +
                ", userAddress='" + userAddress + '\'' +
                '}';
    }
}

3、QueryVo

package cn.bijian.pojo;

import cn.bijian.model.User;

import java.io.Serializable;

public class QueryVo implements Serializable {
    private User user;

    public User getUser() {
        return user;
    }

    public void setUser(User user) {
        this.user = user;
    }

    @Override
    public String toString() {
        return "QueryVo{" +
                "user=" + user +
                '}';
    }
}

4、UserDao.xml

<?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="cn.bijian.dao.UserDao">
    <select id="findByVo" parameterType="cn.bijian.pojo.QueryVo" resultType="cn.bijian.model.User">
        select * from user where username like #{user.username}
    </select>
    <!--使用别名-->
    <select id="findAll2"  resultType="cn.bijian.model.User2">
        select id as userId,username as userName,birthday as userBirthday,sex as userSex,address as userAddress from user
    </select>
    <!-- 使用resultMap-->
    <resultMap id="userMap" type="cn.bijian.model.User2">
        <id column="id" property="userId"></id>
        <result column="username" property="userName"></result>
        <result column="birthday" property="userBirthday"></result>
        <result column="sex" property="userSex"></result>
        <result column="address" property="userAddress"></result>
    </resultMap>
    <select id="findAll3" resultMap="userMap">
        select * from user
    </select>

</mapper>

5、db.properties

jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC
jdbc.username=root
jdbc.password=123456

6、SqlMapConfig.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>
    <environments default="mysql">
        <environment id="mysql">
            <!--JDBC 事务管理器被用作当应用程序负责管理数据库连接的生命周期（提交、回退等等）的时候。当你将
            TransactionManager 属性设置成 JDBC，MyBatis 内部将使用 JdbcTransactionFactory 类创建
            TransactionManager。例如，部署到 Apache Tomcat 的应用程序，需要应用程序自己管理事务。-->
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">  <!--连接池-->
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>
            </dataSource>
        </environment>
    </environments>

    <mappers>
<!--        <mapper resource="cn/bijian/dao/UserDao.xml"></mapper>-->
        <!--用注解方式，需移除dao.xml映射配置-->
<!--       <mapper class="cn.bijian.dao.UserDao"></mapper>  -->
        <!--注册指定包下的所有dao接口-->
        <package name="cn.bijian.dao"/>
    </mappers>
</configuration>

7、MybatisCURDTest2

package cn.bijian.test;

import cn.bijian.dao.UserDao;
import cn.bijian.model.User;
import cn.bijian.model.User2;
import cn.bijian.pojo.QueryVo;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;

import java.io.IOException;
import java.io.InputStream;
import java.util.List;


public class MybatisCURDTest2 {
    private InputStream in;
    private SqlSessionFactory sessionFactory;
    private SqlSession session;
    private UserDao userDao;

    @Test
    public void testFindByVo(){
        User user = new User();
        QueryVo queryVo = new QueryVo();
        user.setUsername("%王%");
        queryVo.setUser(user);
        List<User> users = userDao.findByVo(queryVo);
        for (User u:users) {
            System.out.println(u);
        }
    }
    @Test
    public void testFindAll2(){
        List<User2> users = userDao.findAll2();
        for (User2 user:users) {
            System.out.println(user);
        }
    }

    @Test
    public void testFindAll3(){
        List<User2> users = userDao.findAll3();
        for (User2 user:users) {
            System.out.println(user);
        }
    }

    @Before
    public void init() throws IOException {
        in = Resources.getResourceAsStream("SqlMapConfig.xml");
        SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
        sessionFactory = builder.build(in);
        session = sessionFactory.openSession();
        userDao = session.getMapper(UserDao.class);
    }

    @After
    public void destroy() throws IOException {
        session.commit();
        session.close();
        in.close();
    }

}