<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"https://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.atguigu.mybatis.mapper.UserMapper">
<!--User checkLogin(String username,String password);-->
<select id="checkLogin" resultType="User">
<!--select * from t_user where username = #{arg0} and password = #{arg1}-->
select * from t_user where username = '${arg0}' and password = '${arg1}'
</select>
</mapper>
测试
public class ParameterTest {
@Test
public void testCheckLogin(){
SqlSession sqlSession = SqlSessionUtil.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
User user = mapper.checkLogin("admin", "123456");
System.out.println(user);
}
}