2021-7-11(mybatis)学习笔记——mybatis的多个参数传递

mybatis的多参数传递

1.UserDao接口如下：
@Param（“id”）等于第一个参数名字是id，后续在Mapper.xml文件中就可以直接使用#{id}获取id了！

public interface UserDao{
	//单个参数查询
	//public User getId(Integer id);

	//多个参数查询
	public User getIdAndName(@Param("id") Integer id,@Param("name")String name);
}

2.Mapper.xml如下：

<mapper namespace="UserDao的包名+类名">
	<select id="对应UserDao中的方法" resultType="实体类user的包名+类名">
		select * from user where id=#{id} and name=#{name}
	</select>
</mapper>

3.Test类如下:

@Test
public void test()throws IOException {
	String resource = "mybatis-config.xml";
	InputStream inputStream = Resources.getResourceAsStream(resource);
	SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
	
	//获取SqlSession
	SqlSession openSession=sqlSessionFactory.openSession(true);//自动提交
		try{
		UserDao mapper=openSession.getMapper(UserDao.class);
		User user=mapper.getIdAndName(2,"tom");
		syso(user);
	}finally{
		openSession.close();
	}
}