build/classes/com/java1234/mappers/OrderDetailsMapper.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.java1234.dao.OrderDetailsDao">

	<resultMap type="OrderDetails" id="OrderDetailsResult">
	    <result property="id" column="id"/>
		<result property="goodsName" column="goodsName"/>
		<result property="goodsNum" column="goodsNum" />
		<result property="unit" column="unit"/>
		<result property="price" column="price"/>
		<result property="sum" column="sum"/>
		<association property="order" column="orderId" select="com.java1234.dao.OrderDao.findById"></association>
	</resultMap>
	
	<select id="findOrderDetails" parameterType="Map" resultMap="OrderDetailsResult">
		select * from t_order_details
		<where>
			<if test="orderId!=null and orderId!=' ' ">
				and orderId = #{orderId}
			</if>
		</where>
		<if test="start!=null and size!=null">
			limit #{start},#{size}
		</if>
	</select>
	
	<select id="getTotalOrderDetails" parameterType="Map" resultType="Long">
		select count(*) from t_order_details
		<where>
			<if test="orderId!=null and orderId!=' ' ">
				and orderId = #{orderId}
			</if>
		</where>
	</select>

	<select id="getTotalPriceByOrderId" parameterType="Integer" resultType="Float">
		select sum(sum) from t_order_details where orderId=#{orderId}
	</select>
</mapper>