easyui table select 下拉框做status状态区分

最新推荐文章于 2023-09-15 17:39:57 发布

JesseCary

最新推荐文章于 2023-09-15 17:39:57 发布

阅读量1.2k

点赞数

分类专栏： oracle json 字符串转对象 springmvc +mybatis +ajax 文章标签： easyui oracle mybatis javaweb

本文链接：https://blog.csdn.net/JesseCary/article/details/75033991

版权

json 字符串转对象 springmvc +mybatis +ajax 同时被 2 个专栏收录

32 篇文章 0 订阅

订阅专栏

oracle

17 篇文章 0 订阅

订阅专栏

</html>

后台代码

/**
* 查询营销管理数据并分页
*/
@RequestMapping("/findSaleChance")
public String findSaleChance(@RequestParam(value="page")String page,@RequestParam(value="rows")String rows,
SaleChance saleChance,HttpServletResponse response ) throws Exception{
PageBean pageBean =new PageBean(Integer.parseInt(page),Integer.parseInt(rows));
Map<String, Object> map=new HashMap<String,Object>();
map.put("customerName", saleChance.getCustomerName());
map.put("overView", saleChance.getOverView());
map.put("createMan", saleChance.getCreateMan());
map.put("state", saleChance.getState());
map.put("start", pageBean.getStartRow());
map.put("size", pageBean.getEndRow());
List<SaleChance> list=saleChanceService.findSaleChanceList(map);
int total=saleChanceService.getTotalSaleChanceCount(map);
JSONObject result=new JSONObject();
JsonConfig jsonConfig=new JsonConfig();
jsonConfig.registerJsonValueProcessor(java.util.Date.class, new DateJsonValueProcessor("yyyy-MM-dd HH:mm"));//转换时间
JSONArray jsonArray=JSONArray.fromObject(list,jsonConfig);
result.put("rows", jsonArray);
result.put("total", total);
ResponseUtil.write(response, result);
return null;
}

sql:

<mapper namespace="ssmy.dao.SaleChanceDao">
<resultMap type="ssmy.dto.SaleChance" id="SaleChance">


<id property="id" column="id" jdbcType="INTEGER"/>

<result property="chanceSource" column="chanceSource" jdbcType="VARCHAR"/>
<result property="customerName" column="customerName" jdbcType="VARCHAR"/>
<result property="cgjl" column="cgjl" jdbcType="INTEGER"/>
<result property="overView" column="overView" jdbcType="VARCHAR"/>
<result property="linkMan" column="linkMan" jdbcType="VARCHAR"/>
<result property="linkPhone" column="linkPhone" jdbcType="VARCHAR"/>
<result property="description" column="description" jdbcType="VARCHAR"/>
<result property="createMan" column="createMan" jdbcType="VARCHAR"/>
<result property="createTime" column="createTime" jdbcType="TIMESTAMP"/>
<result property="assignMan" column="assignMan" jdbcType="VARCHAR"/>
<result property="assignTime" column="assignTime" jdbcType="TIMESTAMP"/>
<result property="state" column="state" jdbcType="INTEGER"/>
<result property="devResult" column="devResult" jdbcType="INTEGER"/>
</resultMap>

<select id="findSaleChanceList" resultMap="SaleChance" parameterType="Map">
select t2.* from
( select t1.*,rownum rn from t_sale_chance t1
<where>
<if test ="customerName !=null and customerName !='' ">
and t1.customerName like '%'||#{customerName,jdbcType=VARCHAR}||'%'
</if>
<if test ="overView !=null and overView !='' ">
and t1.overView like '%'||#{overView,jdbcType=VARCHAR}||'%'
</if>
<if test ="createMan !=null and createMan !='' ">
and t1.createMan like '%'||#{createMan,jdbcType=VARCHAR}||'%'
</if>
<if test ="state !=null ">
and t1.state =#{state,jdbcType=NUMERIC}
</if>
</where>
) t2
<where>
<if test ="start !=null and start !=''">
<![CDATA[and t2.rn >=#{start}]]>
</if>

<if test ="size !=null and size !=''">
<![CDATA[and t2.rn < #{size}]]>
</if>
</where>
</select>

<select id="getTotalSaleChanceCount" parameterType="Map" resultType="java.lang.Integer">
select count(1) from t_sale_chance t1
<where>
<if test ="customerName !=null and customerName !='' ">
and t1.customerName like '%'||#{customerName,jdbcType=VARCHAR}||'%'
</if>
<if test ="overView !=null and overView !='' ">
and t1.overView like '%'||#{overView,jdbcType=VARCHAR}||'%'
</if>
<if test ="createMan !=null and createMan !='' ">
and t1.createMan like '%'||#{createMan,jdbcType=VARCHAR}||'%'
</if>
<if test ="state !=null ">
and t1.state = #{state,jdbcType=NUMERIC}
</if>
</where>
</select>

JesseCary

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
easyui table select 下拉框做status状态区分

function searchSaleChance(){$("#dg").datagrid('load',{"customerName":$("#s_customerName").val(), "overView":$("#s_overView").val(), "createMan":$("#s_createMan").val(), "state":$("#s_state")
复制链接

扫一扫