public List<ProductInfo>getAllByVO(ProductInfoVO vo);
在ProductInfoMapper.xml文件中编写查询语句
<select id="getAllByVO" parameterType="com.oracle.xiaomi.pojo.vo.ProductInfoVO" resultMap="BaseResultMap">
select
<include refid="Base_Column_List"></include>
from product_info
<!--拼条件--><where><if test="pname!='' and pname!=null">
and p_name like '%${pname}%'</if><if test="typeid!=null and typeid!=-1">
and type_id=#{typeid}</if><if test="lprice!=null and hprice==null">
and p_price>=#{lprice}</if><if test="lprice==null and hprice!=null">
and p_price <=#{hprice}</if><if test="lprice!=null and hprice!=null">
and p_price between #{lprice} and #{hprice}</if></where>
order by p_id desc
</select>
@RequestMapping("/split")public String split(ProductInfoVO vo, Model model){
PageInfo info = productInfoService.splitPageVO(vo,PAGE_SIZE);
model.addAttribute("info", info);return"product";}
修改product.jsp页面 info传入查询条件内容 showPage为下面异步处理方法
<!--分页的AJAX实现--><script type="text/javascript">
function showPage(page){//第二页//取出所有的条件
var pname=$("#pname").val();
var typeid=$("#typeid").val();
var lprice=$("#lprice").val();
var hprice=$("#hprice").val();if(page==0)
page=1;
$("#table").load("http://localhost:8080/prod/split.action #table",{"page":page,"pname":pname,"typeid":typeid,"lprice":lprice,"hprice":hprice})}</script>