<%@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"%> <% String no=(String)session.getAttribute("userInfoid"); String username="";String lasttime="";String headimg=""; Map map=(Map)session.getAttribute("userInfo"); if(map!=null){ username=(String)map.get("name"); lasttime=(String)map.get("lastlogin"); headimg=(String)map.get("headimg"); no=(String)map.get("id"); } PoolManager pool = new PoolManager(); if (pool == null) { pool = new PoolManager(); } String offset = Common.getFormatInt(request.getParameter("offset")); Connection conn = null; DataManager db = new DataManager(); Pagination pagination = new Pagination(); int pageCount = 10; //pageCount = Integer.parseInt(Common.getFormatInt(request.getParameter("pageCount"))); if(pageCount==0){ pageCount = 10; } pagination.setCountOfPage(pageCount); String flag=Common.getFormatStr(request.getParameter("flag")); try { conn = pool.getConnection(); ResultSet prs=null; ResultSet part_rs =null; String pro_query="select * from jrcms_products_order where website_no='20150623163145344' and add_user='"+no+"' "; prs = db.executeQuery(conn,pro_query); int count=0; if(prs!=null&&prs.next()){ prs.last(); count=prs.getRow(); } String part_query="select * from jrcms_part_order where website_no='20150619082201914' and add_user='"+no+"' "; part_rs = db.executeQuery(conn,part_query); int partcount=0; if(part_rs!=null&&part_rs.next()){ part_rs.last(); partcount=part_rs.getRow(); } ResultSet pro_Rs=null; ResultSet part_Rs=null; if(!flag.equals("1")){ String partquery = "select * from jrcms_part_order where website_no='20150619082201914' and add_user='"+no+"'"; part_Rs = pagination.getQueryResult(partquery, request, conn); }else{ String proquery = "select * from jrcms_products_order where website_no='20150623163145344' and add_user='"+no+"'"; pro_Rs = pagination.getQueryResult(proquery, request, conn); } int showPages = 10;//底部页数显示个数 %> 我的订单_天津奥特泵业

欢迎您:<%=username%>退出返回奥特官网首页

奥特会员商务室

首页个人设置

我的商务室

我的订单

class="cur"<%}%> >产品订单<%=count%>
class="cur"<%}%>>配件订单<%=partcount%>

<%=pro_name%> |<%=pro_time%> <%=pro_state%>
<%=part_name%> |<%=part_time%> <%=part_state%>

<%if(pagination.getTotal()>pageCount){%>

上一页 <%String str = "";String pages[] = pagination.getPages();int nowp = pagination.getCurrenPages();nowp = nowp - nowp % (showPages + 1);for (int i = nowp - 1; i < (nowp + showPages) && i < pages.length; i++) {if (i < 0)i = 0;if (pagination.getCurrenPages() == (i + 1)) {str += "" + (i + 1) + " ";} else {str += " " + (i + 1) + " ";}}str=str.substring(0,str.length()-1);out.print(str); %> 下一页共<%=pagination.getTotalPages()%>页

<%}%>

网站地图| 服务条款| 联系我们

Copyright © <%=Common.getToday("yyyy-MM-dd")%> Aote Tianjin Pump Co., Ltd. 版权所有捷瑞数字制作维护津ICP备08001621号

<% } catch (Exception e) { e.printStackTrace(); } finally { pool.freeConnection(conn); } %>