AI时代，找源码已成为过去式，纪念我过去的十年0(回)
69天前
还有人吗2(回)
87天前会python真的可以为所欲为0(回)
567天前
这里还有人吗2(回)
752天前这里还有人吗0(回)
752天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
977天前<?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> |
