～本当のおいしさを～いかりスーパー

<%@ page contentType="text/html; charset=euc-jp" %> <%@ page import = "java.util.*, java.io.*, java.text.*, java.sql.*, java.net.*" %> <%@ page errorPage="/syserror.jsp" %> <%! private String NumFormat(String num) { int n = Integer.valueOf(num).intValue(); DecimalFormat NumFormat = new DecimalFormat("###,###"); return NumFormat.format(n); } private String StrConv(String val) throws UnsupportedEncodingException { if(val!=null){ StringBuffer sb = new StringBuffer(); StringCharacterIterator sci = new StringCharacterIterator(val); for(char c = sci.current(); c != StringCharacterIterator.DONE; c = sci.next()){ if(c == '\n') { sb.append("
"); } else if(c == '\r') { sb.append(""); } else { sb.append(c); } } return sb.toString(); } else { return ""; } } %> <% String query; String[] id = new String[10]; String[] title = new String[10]; String[] img = new String[10]; String[] comment = new String[10]; db.open(); query = "SELECT count(*) FROM category WHERE del is not true"; ResultSet cnt = db.select(query); cnt.next(); int count = cnt.getInt("count"); %> <% String uriQuery = "", tmpStr; Enumeration queryList = request.getParameterNames(); while(queryList.hasMoreElements()) { String key = (String) (queryList.nextElement()); if (key.equals("offset") || key.equals("submit")) { continue; } tmpStr = new String(request.getParameter(key).getBytes("8859_1"), "EUC-JP"); uriQuery += key + "=" + URLEncoder.encode(tmpStr, "Shift_JIS") + "&"; } int offset, limit = 10, max; String uri = request.getRequestURI() + "?" + uriQuery; String prev = "", next = "", box = ""; if(request.getParameter("offset") != null) { offset = Integer.parseInt(request.getParameter("offset")); } else { offset = 0; } int l = 10; String[] defDspCount = new String[]{"１","２","３","４","５","６","７","８","９"}; int pagecount = 0; String dspcount = null; for(int i=0; i pagecount) { dspcount = defDspCount[pagecount-1]; } else { dspcount = new Integer(pagecount).toString(); } if(offset>i) { box += "" + dspcount + " "; prev = "<前ページ"; } else if(offset+l<=i) { box += "" + dspcount + " "; next = "次ページ>"; } else { box += dspcount + " "; } } String PageNavi = prev + "[" + box + "]" + next; if ((offset + limit) ～本当のおいしさを～いかりスーパー

トップページ＞ショッピング