2017-02-22

最新推荐文章于 2023-07-03 15:14:53 发布

nancarpli

最新推荐文章于 2023-07-03 15:14:53 发布

阅读量271

点赞数

分类专栏：学习

本文链接：https://blog.csdn.net/nancarpli/article/details/56486766

版权

学习专栏收录该内容

11 篇文章 0 订阅

订阅专栏

一、实现色系管理模糊查询

1.color.html

<div class="page-container">
<div class="cl pd-5 bg-1 bk-gray"> <span class="l"><a href="javascript:;" οnclick="_add()" class="btn btn-primary radius"><i class="Hui-iconfont"></i> 添加色系管理</a></span> <span class="r" style="line-height:31px;">共有数据：<strong>${totalrow}</strong> 条</span>
<span class="l ml-10" style="width: 170px">
<input type="text" class="input-text" placeholder="输入色系查询" value="${fcolor!}" id="fcolor" maxlength="20">
</span>
<input class="btn btn-primary ml-10" type="submit" value="查找" οnclick="color_search()">
</div>

2ManageProductCtrl.java

/*********************色系管理*********************/
//管理色系
public void color(){
Integer pageno = getParaToInt(0)==null?1:getParaToInt(0);
String fcolor = getPara(1);
try {
fcolor = URLDecoder.decode(fcolor==null?"":fcolor, "utf-8");
} catch (UnsupportedEncodingException e) {
e.printStackTrace();
}
Page<Record> page = MCDao.getColor(pageno, 16, fcolor);
setAttr("fcolor", fcolor);
setAttr("pageno", page.getPageNumber());
setAttr("totalpage", page.getTotalPage());
setAttr("totalrow", page.getTotalRow());
setAttr("colorlist", page.getList());
render("color.html");

}

3.MCDao.java

//获得色系列表
public static Page<Record> getColor(int pageno, int pagesize, String fcolor){
String sqlExceptSelect = " from f_color a where 1=1";
if(fcolor != ""){
sqlExceptSelect += " and a.name like '%"+ fcolor +"%'";
}
return Db.paginate(pageno, pagesize, "select id,name,jh", sqlExceptSelect);
}