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);
	}