session中的sessionOne()方法

来源:互联网 发布:淘宝销量数据分析电客 编辑:程序博客网 时间:2024/05/17 09:43


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中