<select id="getPeople" parameterClass="java.lang.String" resultClass="java.util.Map">
select username,password,pname from student s,people p
where s.pid = #id# and p.pid = #id#
</select>用String将参数id传递过来,返回值用map,后台从map中取对应值即可,或者返回值用自定义的javabean,这时要配置一个resultMap对应你的javabean(假设为com.test.people.PersonBean),property对应javabean中的字段,column对应select出的字段:<select id="getPeople" parameterClass="java.lang.String" resultMap="peopleMap">
select username,password,pname from student s,people p
where s.pid = #id# and p.pid = #id#
</select><resultMap id="peopleMap" class="com.test.people.PersonBean">
<result property="name" column="username"/>
<result property="password" column="password"/>
<result property="realName" column="pname"/>
</resultMap>
select username,password,pname from student s,people p
where s.pid = #id# and p.pid = #id#
</select>用String将参数id传递过来,返回值用map,后台从map中取对应值即可,或者返回值用自定义的javabean,这时要配置一个resultMap对应你的javabean(假设为com.test.people.PersonBean),property对应javabean中的字段,column对应select出的字段:<select id="getPeople" parameterClass="java.lang.String" resultMap="peopleMap">
select username,password,pname from student s,people p
where s.pid = #id# and p.pid = #id#
</select><resultMap id="peopleMap" class="com.test.people.PersonBean">
<result property="name" column="username"/>
<result property="password" column="password"/>
<result property="realName" column="pname"/>
</resultMap>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货