User.xml
<?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.lyx.models.UserMapper">
<select id="selectUserByID" parameterType="int" resultType="User">
select * from `user` where id = #{id}
</select>
</mapper>
User user = (User) session.selectOne("com.lyx.models.UserMapper.selectUserByID", 1);
System.out.println(user.getUserAddress());
System.out.println(user.getUserName());
划红线的意思是取到ID为selectUserByID的语句,第二个参数的意思是把1付给#{id}
而User.xml中的resultType即使你要取得的结果的返回类型。假如你还有另外一张表为teacher,实体类teacher,修改resulttype=teacher,以及修改SQL语句即可以映射到teacher中