MyBatis学习记录(三) 映射参数绑定的几种写法

package com.zyc.dao;

import com.zyc.entity.User;
import org.apache.ibatis.annotations.Param;

import java.util.Map;

/**
 * Author: zyc
 * Date: 2021/4/30
 * Time: 14:06
 */

public interface UserDAO {
	//用 arg1
    User queryUserById(Integer id);
	//param1 param2
    User queryUserByIdAndUsername(Integer id, String username);
	//@param("")  注解
    User queryUserByIdAndPassword(@Param("id") Integer id, @Param("password")String password);
	//map
    User queryUserByIdAndPassword2(Map map);
	//对象
    User queryUserByIdAndPassword3(User user);


}

<?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.zyc.dao.UserDAO">
    <select id="queryUserById" resultType="User">
    <!-- com.zyc.dao.User AKA user_zyc-->
<!--    <select id="queryUserById" resultType="user_zyc">-->
        select id, username, password, gender, regist_time as registTime
        from t_user
        where id = #{arg0}
    </select>
    <select id="queryUserByIdAndUsername" resultType="User">
        select id, username, password, gender, regist_time as registTime
        from t_user
        where id = #{param1} and username=#{param2}
    </select>
    <select id="queryUserByIdAndPassword" resultType="User">
        select id, username, password, gender, regist_time as registTime
        from t_user
        where id = #{id} and password=#{password}
    </select>
    <select id="queryUserByIdAndPassword2" resultType="User">
        select id, username, password, gender, regist_time as registTime
        from t_user
        where id = #{id} and password=#{password}
    </select>
    <select id="queryUserByIdAndPassword3" resultType="User">
        select id, username, password, gender, regist_time as registTime
        from t_user
        where id = #{id} and password=#{password}
    </select>
</mapper>

package com.zyc.test;

import com.zyc.dao.UserDAO;
import com.zyc.entity.User;
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 java.io.IOException;
import java.io.InputStream;
import java.util.HashMap;
import java.util.Map;

/**
 * Author: zyc
 * Date: 2021/4/30
 * Time: 14:24
 */

public class TestMyBatis {
    public static void main(String[] args) throws IOException {
        // MyBatis API
        // 1.加载配置文件
        InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");

        //2.构建SqlSessionFactory
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

        //3.通过SqlSessionFactory 创建 SqlSession
        SqlSession sqlSession = sqlSessionFactory.openSession();

        //4.通过sqlSession获得DAO实现类的对象
        UserDAO mapper = sqlSession.getMapper(UserDAO.class);//获取UserDAO对应的实现类的对象

        //5.测试查询方法
        //用arg0 arg1
        User user1 = mapper.queryUserById(1);
        //用param1 param2
        User user2 = mapper.queryUserByIdAndUsername(1, "zyc");
        //用 @param 注解
        User user3 = mapper.queryUserByIdAndPassword(1, "123");
        //用map进行查询
        Map map = new HashMap();
        map.put("id", 2);
        map.put("password", "123");
        User user4 = mapper.queryUserByIdAndPassword2(map);
        //用对象进行查询
        User user51 = mapper.queryUserByIdAndPassword3(user1);

        System.out.println(user1);
        System.out.println(user2);
        System.out.println(user3);

        System.out.println(user4);
        System.out.println(user51);
    }
}