创建表单
后台接收 表单提交的元素
执行sql查询的方法
<form id="queryForm" method="post">
<table>
<tr>
<td>商品名称:</td>
<td><input id="product_name" name="product_name" type="text" style="width: 230px;" /></td>
<td>供应商名称:</td>
<td><input id="basic_seller_name" name="basic_seller_name" type="text" style="width: 230px;" /></td>
<td><button type="button" onclick="searchHandler();"><span class="icon_find">查询</span></button></td>
<td><button type="button" onclick="resetSearch();"><span class="icon_reload">重置</span></button></td>
</tr>
</table>
</form>
后台接收 表单提交的元素
Map<String, Object> map = new HashMap<String, Object>();
String product_name = request.getParameter("product_name");
if(product_name!=null && !"null".equals(product_name) && !"".equals(product_name)){
map.put("product_name like", "%" + product_name + "%");
}
String basic_seller_name = request.getParameter("basic_seller_name");
if(basic_seller_name!=null && !"null".equals(basic_seller_name) && !"".equals(basic_seller_name)){
map.put("basic_seller_name like", "%" + basic_seller_name + "%");
}
List<Map<String, Object>> list = productService.findViewByMapPage(map, Integer.parseInt(pageNo), Integer.parseInt(pageSize));
执行sql查询的方法
public List<Map<String, Object>> findViewByMapPage(Map<String, Object> map,
int pageNo, int pageSize) {
StringBuffer sql = new StringBuffer("select * from " + TableName.product_view);
Iterator it = map.entrySet().iterator();
Object object[] = new Object[map.size()];
int i = 0;
if (map.size() > 0) {
while (it.hasNext()) {
Map.Entry entry = (Map.Entry) it.next();
String key = entry.getKey().toString();
Object value = entry.getValue();
if (i==0) {
sql.append(" where " + key + " ?");
object[i] = value;
} else if (i==1){
sql.append(" and " + key + " ?");
object[i] = value;
}
i++;
}
}
sql.append(" order by product_id desc");
return baseDao.queryForList(sql.toString(), object, this.findViewByMapCount(map), pageNo, pageSize, ProductServiceImpl.class);
}