<%@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"); PoolManager pool = new PoolManager(); if (pool == null) { pool = new PoolManager(); } 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); try { conn = pool.getConnection(); ResultSet partfileRs=null; String query="select * from jrcms_members where website_no='20150619082201914' and id='"+no+"'"; ResultSet mrs = db.executeQuery(conn,query); String username="";String lasttime=""; if(mrs!=null&&mrs.next()){ username=Common.getFormatStr(mrs.getString("name")); lasttime=Common.getFormatDate("yyyy-MM-dd ",mrs.getDate("last_login_date")); } String type = Common.getFormatPara((String)request.getParameter("type")); String pro_query="select * from jrcms_collection_set where add_user='"+no+"' "; ResultSet prs = db.executeQuery(conn,pro_query); int count=0; if(prs!=null&&prs.next()){ prs.last(); count=prs.getRow(); } String proa_query="select * from jrcms_collection_set where add_user='"+no+"' and encode_type='1' "; ResultSet prors = db.executeQuery(conn,proa_query); int count1=0; if(prors!=null&&prors.next()){ prors.last(); count1=prors.getRow(); } String part_query="select * from jrcms_collection_set where add_user='"+no+"' and encode_type='2' "; ResultSet partrs = db.executeQuery(conn,part_query); int count2=0; if(partrs!=null&&partrs.next()){ partrs.last(); count2=partrs.getRow(); } String proquery = "select * from jrcms_collection_set where add_user='"+no+"' "; if(!type.equals("")){ proquery+=" and encode_type='"+type+"' "; } ResultSet rs = pagination.getQueryResult(proquery, request, conn); int showPages = 10;//底部页数显示个数 %> 我的收藏_天津奥特泵业
欢迎您:<%=username%>退出 返回奥特官网首页

首页 个人设置
我的商务室

我的收藏

网站地图| 服务条款| 联系我们
Copyright © <%=Common.getToday("yyyy-MM-dd")%> Aote Tianjin Pump Co., Ltd. 版权所有 捷瑞数字 制作维护津ICP备08001621号
<% } catch (Exception e) { e.printStackTrace(); } finally { pool.freeConnection(conn); } %>