OrderMapper.xml

[html]代码库

<?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.liang.bike.dao.base.OrderMapper">
    <resultMap id="BaseResultMap" type="com.liang.bike.bean.base.OrderBase">
        <id column="order_id" property="orderId" jdbcType="INTEGER"/>
        <result column="bike_id" property="bikeId" jdbcType="INTEGER"/>
        <result column="user_id" property="userId" jdbcType="INTEGER"/>
        <result column="create_by" property="createBy" jdbcType="VARCHAR"/>
        <result column="create_date" property="createDate" jdbcType="TIMESTAMP"/>
        <result column="return_by" property="returnBy" jdbcType="VARCHAR"/>
        <result column="return_date" property="returnDate" jdbcType="TIMESTAMP"/>
        <result column="update_by" property="updateBy" jdbcType="VARCHAR"/>
        <result column="update_date" property="updateDate" jdbcType="TIMESTAMP"/>
    </resultMap>
    <sql id="Base_Column_List">
    order_id, bike_id, user_id, create_by, create_date, return_by, return_date, update_by, 
    update_date
  </sql>
    <select id="selectOrder" resultMap="BaseResultMap" parameterType="java.lang.Integer">
        select
        <include refid="Base_Column_List"/>
        from public.order
        <where>
            <if test="orderId != null">
                orderId = #{orderId,jdbcType=INTEGER}
            </if>
            <if test="bikeId != null">
                and bike_id = #{bikeId,jdbcType=INTEGER}
            </if>
            <if test="userId != null">
                and user_id = #{userId,jdbcType=INTEGER}
            </if>
            <if test="createBy != null">
                and create_by = #{createBy,jdbcType=VARCHAR}
            </if>
            <if test="createDate != null">
                and create_date = #{createDate,jdbcType=TIMESTAMP}
            </if>
            <if test="returnBy != null">
                and return_by = #{returnBy,jdbcType=VARCHAR}
            </if>
            <if test="returnDate != null">
                and return_date = #{returnDate,jdbcType=TIMESTAMP}
            </if>
            <if test="updateBy != null">
                and update_by = #{updateBy,jdbcType=VARCHAR}
            </if>
            <if test="updateDate != null">
                and update_date = #{updateDate,jdbcType=TIMESTAMP}
            </if>
        </where>
    </select>
</mapper>