build/classes/com/java1234/mappers/OrderMapper.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.OrderDao">

	<resultMap type="Order" id="OrderResult">
	    <result property="id" column="id"/>
		<result property="orderNo" column="orderNo"/>
		<result property="orderDate" column="orderDate" />
		<result property="address" column="address"/>
		<result property="state" column="state"/>
		<association property="customer" column="cusId" select="com.java1234.dao.CustomerDao.findById"></association>
	</resultMap>
	
	<select id="findOrder" parameterType="Map" resultMap="OrderResult">
		select * from t_customer_order
		<where>
			<if test="cusId!=null and cusId!=' ' ">
				and cusId = #{cusId}
			</if>
		</where>
		<if test="start!=null and size!=null">
			limit #{start},#{size}
		</if>
	</select>
	
	<select id="getTotalOrder" parameterType="Map" resultType="Long">
		select count(*) from t_customer_order
	</select>
	
	<select id="findById" parameterType="Integer" resultMap="OrderResult">
		select * from t_customer_order where id=#{id}
	</select>

	<select id="findLastByCusId" parameterType="Integer" resultMap="OrderResult">
		SELECT * FROM t_customer_order WHERE cusId=#{cusId} ORDER BY orderDate DESC LIMIT 0,1
	</select>
</mapper>