//單獨(dú)的bean類? 添加索要查詢的元素,提供get? set方法
private Stringusername;
private Stringphone;
private Stringpname;
private double pprice;
private int count;
private Stringtname;
private double tprice;
//xml的查新配置(五表聯(lián)查)
<mapper namespace="dtoMapper">
? ? <select id="getOne" resultType="dto.Dto">
? ? ? select u.name as username, u.phone, p.name as pname, p.price as pprice, d.count, t.name as tname, o.price as tprice
from users u
inner join orders o on o.uid = u.uid
inner join details d on o.oid = d.oid
inner join products p on d.pid = p.pid
inner join types t on p.tid = t.tid
where o.oid = #{i}
<select id="getAll" resultType="Book">
? ? select* from book
<insert id="saveBook" >
? ? insert into book values (#{id},#{userName},#{password},#{addr})
<update id="updateBook">
? ? update book set userName=#{userName},password=#{password},addr=#{addr} where id=#{id}
</update>
</mapper>
