Mybatis 传值

 

List<RepairWorkpointsConfigVo> selectList(RepairWorkpointsConfigPo o);

<select id="selectList" resultMap="BaseResultMap" parameterType="com.po.RepairWorkpointsConfigPo" >
		SELECT rwc.id,rwc.city_code,rwc.city_name,rwc.work_order_type,rwc.workpoints_standard,rwi.workpoints_item_name from repair_workpoints_config rwc
        LEFT JOIN repair_workpoints_item rwi ON rwc.workpoints_item_code = rwi.workpoints_item_code where  1==1
        <if test="cityCode != null and cityCode != ''">
			and rwc.city_code = #{cityCode}
		</if>
		<if test="workOrderType != null">
			and rwc.work_order_type = #{workOrderType}
		</if>
		<if test="postCode != null and postCode != ''">
			and rwc.post_code = #{postCode}
		</if>
	</select>