jsp页面easyui多选下拉框的实现与mapper文件的实现

来源:互联网 发布:centos rpm package 编辑:程序博客网 时间:2024/06/05 03:30

JSP页面实现       

<span>公司</span>

             <select class="easyui-combobox" name="mrcType" id="mrcType" multiple="true">
             <option value="">--请选择--</option>
                           <option value="10">客户</option>
             <option value="20">供应商</option>
             <option value="30">货主</option>
             <option value="40">承运商</option>
  

             </select>



mapper文件中实现

<select id="queryForList" parameterType="java.util.HashMap" resultType="java.util.HashMap">
SELECT * FROM (
SELECT DISTINCT mrc.* FROM MstRelCom mrc,mstrelatedcomtype mrct 
where CompId = MrcId and mrc.EnableFlag = 'Y' and mrct.EnableFlag = 'Y' 

<include refid="queryCondition"/> order by mrc.UpdateTime desc 
) F limit #{page}, #{rows}
</select>


<select id="queryForCount" parameterType="java.util.HashMap" resultType="java.lang.Long">
SELECT count(distinct mrc.MrcId) FROM MstRelCom mrc,mstrelatedcomtype mrct 
where CompId = MrcId and mrc.EnableFlag = 'Y' and mrct.EnableFlag = 'Y' 
<include refid="queryCondition"/>
</select>

<sql id="queryCondition">
<if test="mrcType != null and mrcType != '' ">
and CompTypeCode = #{mrcType,jdbcType=VARCHAR} 
</if>
<if test="mrcTypes != null and mrcTypes != '' ">
and CompTypeCode in 
<foreach item="item" index="index" collection="mrcTypes" 
           open="(" separator="," close=")">
           #{item}
            </foreach>
</if>
</sql>

0 0