%@page contentType="text/html;charset=utf-8" import="java.sql.*,java.util.*,jerehnet.jsp.database.*,jerehnet.jsp.util.*,java.text.SimpleDateFormat,java.util.regex.Matcher,java.util.regex.Pattern"%> <% PoolManager pool = new PoolManager(); if (pool == null) { pool = new PoolManager(); } Connection conn = null; Pagination pagination = new Pagination(); //设置每页显示条数 int pageCount = 9; //pageCount = Integer.parseInt(Common.getFormatInt(request.getParameter("pageCount"))); if(pageCount==0){ pageCount = 10; } pagination.setCountOfPage(pageCount); DataManager db = new DataManager(); try { conn = pool.getConnection(); String offset = Common.getFormatInt(request.getParameter("offset")); //搜索条件形成 String searchStr = " where website_no='20150619082201914' and channel_node ='20150718105336947' and is_show=1 "; String query = "select * from jrcms_products" + searchStr; ResultSet rs = pagination.getQueryResult(query, request, conn); int showPages = 9;//底部页数显示个数 %>