MyBatis多参数查询方法

---

前言

上一篇:使用MyBatis框架实现的简单增删改查

---

提示：以下是本篇文章正文内容，下面案例可供参考

一、建表t_user

二、多参数查询

2.1 方法一 arg0 arg1…

UserMapper.java

import com.my.vo.User;

public interface UserMapper {
   
//	多参数查询
	public User queryUserByNameAndId1(Integer id,String username);
}

UserMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org/DTD Mapper 3.0" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.my.mapper.UserMapper">
	<!-- 多参数查询方法 -->
	<select id="queryUserByNameAndId1" resultType="user">
		select * from
		t_user where id=#{
   arg0} and username=#{
   arg1}
	</select>
</mapper>

MyBatisTest.java

import java.io.IOException;
import java.io.InputStream;
import java.util.HashMap;
import java.util.Map;

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 com.my.mapper.UserMapper;
import com.my.vo.User;

public class MybatisSelectOneTest {
   
	public static void main(String[] args) throws IOException {
   
		String resource = "mybatis.config.xml";
		InputStream inputstream = Resources.getResourceAsStream(resource);
		SqlSessionFactory salsessionfactory = new SqlSessionFactoryBuilder().build(inputstream);
		SqlSession sqlsession = salsessionfactory.openSession();
		UserMapper userMapper = sqlsession.getMapper(UserMapper.class);

		// 方法一 arg0 arg1.....
		User user1 = userMapper.queryUserByNameAndId1(1, "燕绘绘");
		System.out.println(user1);
	}
}

运行结果:

DEBUG - > Preparing: select * from t_user where id=? and username=?
DEBUG - > Parameters: 1(Integer), 燕绘绘(String)
DEBUG - < Total: 1
User [id=1, username=燕绘绘, passward=qweqw1, gender=1, registTime=Thu Aug 15 14:22:56 CST 2019]

2.2 方法二 param1 param2…

UserMapper.java

import com.