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();
}
}