📄 profileresult.jsp.svn-base
字号:
<!--------------------------------------------------------------------------------------------------------------
*@橇肺鞘 八祸 搬苞
*@Author : 弥眠岿 (2008-6-27)
--------------------------------------------------------------------------------------------------------------->
<%@ page import='java.io.*,java.text.*,java.util.Date,java.util.Vector, javax.servlet.http.HttpSession,java.sql.*, com.entaz.lib.db.*, com.entaz.relay.net.*' contentType='text/html;charset=euc-kr'%>
<%@ include file="../imgpath.jsp"%>
<%@ include file="../common_func.jsp"%>
<%@ include file="../makeKOR.jsp"%>
<%@ include file="appConstants.jsp"%>
<%@ include file="formatUtil.jsp"%>
<%
/*------------------------------------------------------------------------------------------------------
+ 扁夯 颇扼固磐
-------------------------------------------------------------------------------------------------------*/
String mphone= request.getParameter("mphone");
String gphone= request.getParameter("gphone");
mphone = getStrPhone(getLong(mphone));
gphone = getStrPhone(getLong(gphone));
String selectsex = "";
if(request.getParameter("selectsex")!=null){selectsex=request.getParameter("selectsex");};
String selectage = "";
if(request.getParameter("selectage")!=null){selectage=request.getParameter("selectage");};
String todayprofile = "";
if(request.getParameter("todayprofile")!=null){todayprofile=request.getParameter("todayprofile");};
String textprofile = "";
if(request.getParameter("textprofile")!=null){textprofile=java.net.URLDecoder.decode(makeKOR(request.getParameter("textprofile")));};
int flag = 0;
if(request.getParameter("flag")!=null){flag=Integer.parseInt(request.getParameter("flag"));};
if(flag == 0){
request.getSession().setAttribute("selectsex",selectsex);
request.getSession().setAttribute("selectage",selectage);
request.getSession().setAttribute("todayprofile",todayprofile);
request.getSession().setAttribute("textprofile",textprofile);
}
if(flag == 1)
{
selectsex=request.getSession().getAttribute("selectsex").toString();
selectage=request.getSession().getAttribute("selectage").toString();
todayprofile=request.getSession().getAttribute("todayprofile").toString();
textprofile=request.getSession().getAttribute("textprofile").toString();
}
String year1 = "";
if(request.getParameter("year")!=null){year1=request.getParameter("year");};
String month1 = "";
if(request.getParameter("month")!=null){month1=request.getParameter("month");};
String day1 = "";
if(request.getParameter("day")!=null){day1=request.getParameter("day");};
/*------------------------------------------------------------------------------------------------------
+ 傈开 函荐
-------------------------------------------------------------------------------------------------------*/
String nickname = "";
String keyword = "";
Calendar calendar=Calendar.getInstance();
int nyear=calendar.get(Calendar.YEAR);
/*------------------------------------------------------------------------------------------------------
+ 其捞瘤 备泅 眠啊 函荐
-------------------------------------------------------------------------------------------------------*/
String pageurl = null;
int pagesize = 10; // 茄其捞瘤寸 10俺 免仿拱
int pageNUM=1; // 其捞瘤 锅龋
int pagecount=1 ; // 其捞瘤 肮荐 瘤沥 函荐
int absolutepage=1; // 例措 困摹 其捞瘤 锅龋
int num = 0; // DB 救俊 臂 肮荐 历厘 函荐
int isNoPage = 0; //茄俺档 绝蠢衬.. 绝栏搁0, 乐栏搁1
/*------------------------------------------------------------------------------------------------------
+ DB 包访 函荐
-------------------------------------------------------------------------------------------------------*/
PreparedStatement pstmt = null;
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
String query1 = null;
ResultSet pageRs = null;
try
{
/*------------------------------------------------------------------------------------------------
* DB 目池记
-------------------------------------------------------------------------------------------------*/
%><%@ include file="../getConnection.jsp"%><%@ include file="bgColor.jsp"%><%
/*------------------------------------------------------------------------------------------------
* 橇肺鞘 nickname
-------------------------------------------------------------------------------------------------*/
query1 = "SELECT nickname FROM gt_user_info WITH (READUNCOMMITTED) WHERE phonenum = ?";
pstmt = con.prepareStatement(query1);
pstmt.setString(1,gphone);
rs = pstmt.executeQuery();
if(rs.next())
{
nickname = rs.getString("nickname");
}
rs.close();
pstmt.close();
/*------------------------------------------------------------------------------------------------------
+ 八祸 搬苞
-------------------------------------------------------------------------------------------------------*/
switch(Integer.parseInt(todayprofile))
{
case 1: keyword= "b.toDo"; break;
case 2: keyword= "b.motto"; break;
case 3: keyword="b.friend"; break;
case 4: keyword="b.wish"; break;
case 5: keyword="b.interest"; break;
case 6: keyword="b.food"; break;
case 7: keyword="b.music"; break;
case 8: keyword="b.agony"; break;
case 9: keyword="b.lookMan"; break;
case 10: keyword="b.fault"; break;
}
query1 ="SELECT "+ keyword+",a.nickname,a.sex,a.year,a.phonenum,b.regdate FROM gt_user_info a WITH (READUNCOMMITTED),GT_NsProfile b WITH (READUNCOMMITTED) WHERE convert(bigint,a.phonenum) = convert(bigint,b.phonenum)"
+" AND a.phonenum <> '"+mphone+"' AND "+keyword+"<> ''";
if(selectsex!="" && !selectsex.equals("0"))
{
query1=query1+" AND a.sex=?";
}
if(selectage!="" && !selectage.equals("0"))
{
query1=query1+" AND a.year>? AND a.year<?";
}
if(todayprofile!=null && textprofile.equals(""))
{
switch(Integer.parseInt(todayprofile))
{
case 1: query1=query1+" AND b.toDo LIKE '%'+?+'%'"; break;
case 2: query1=query1+" AND b.motto LIKE '%'+?+'%'"; break;
case 3: query1=query1+" AND b.friend LIKE '%'+?+'%'"; break;
case 4: query1=query1+" AND b.wish LIKE '%'+?+'%'"; break;
case 5: query1=query1+" AND b.interest LIKE '%'+?+'%'"; break;
case 6: query1=query1+" AND b.food LIKE '%'+?+'%'"; break;
case 7: query1=query1+" AND b.music LIKE '%'+?+'%'"; break;
case 8: query1=query1+" AND b.agony LIKE '%'+?+'%'"; break;
case 9: query1=query1+" AND b.lookMan LIKE '%'+?+'%'"; break;
case 10: query1=query1+" AND b.fault LIKE '%'+?+'%'"; break;
}
}
query1=query1+" GROUP BY "+keyword+", a.nickname ,a.sex ,a.year ,a.phonenum ,b.regdate";
query1=query1+ " ORDER BY b.regdate DESC";
pstmt = con.prepareStatement(query1);
if(selectsex!="" && !selectsex.equals("0"))
{
pstmt.setInt(1,Integer.parseInt(selectsex));
if(selectage!="" && !selectage.equals("0"))
{
pstmt.setInt(2,nyear-Integer.parseInt(selectage)-10);
pstmt.setInt(3,nyear-Integer.parseInt(selectage));
if(todayprofile!=null)
{
pstmt.setString(4,textprofile);
}
}else if(todayprofile!=null)
{
pstmt.setString(2,textprofile);
}
}else if(selectage!="" && !selectage.equals("0"))
{
pstmt.setInt(1,nyear-Integer.parseInt(selectage)-10);
pstmt.setInt(2,nyear-Integer.parseInt(selectage));
if(todayprofile!=null)
{
pstmt.setString(3,textprofile);
}
}else if(todayprofile!=null && textprofile.equals(""))
{
pstmt.setString(1,textprofile);
}
rs= pstmt.executeQuery();
for(int i=0;rs.next();i++)
{
num=i+1;
}
if(num%pagesize == 0)
{
pagecount = num/(pagesize); // 醚 其捞瘤荐 备窍扁
}else
{
pagecount = num/(pagesize)+1; // 醚 其捞瘤荐 备窍扁
}
if(request.getParameter("pageNUM")!=null)
{
pageNUM=Integer.parseInt(request.getParameter("pageNUM"));//瘤沥等 其捞瘤 焊咯林扁
absolutepage=(pageNUM-1)*pagesize+1;
}
rs.close();
pageRs= pstmt.executeQuery();
if(!pageRs.next()) // 蔼捞 绝阑锭
{
isNoPage = 1;
pagesize=0;
}else // 蔼捞 乐阑锭 //rs.absolute(absolutepage);
{
for(int s=0; s<absolutepage-1; s++)
pageRs.next();
}
%>
<html>
<head>
<title></title>
<link href="http://entaz.mugeta.com/client/mugeta_v2_test/web/user/mobile.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<!-- 鸥捞撇 矫累 -->
<tr>
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr height="19">
<td width="8" bgcolor="<%=mainBgColor %>"></td>
<td bgcolor="<%=mainBgColor %>"><font color="#ffffff">橇肺鞘 八祸搬苞</font></td>
</tr>
</table>
</td>
</tr>
<!-- 鸥捞撇 场 -->
<!-- 咯归 矫累 -->
<tr height="8">
<td></td>
</tr>
<!-- 咯归 场 -->
<%if(num!=0){ %>
<tr>
<td align="center">
<font color="#716e63">八祸 搬苞 <%=num %>扒狼 搬苞啊 乐嚼聪促.<br>寸脚苞 迭 嘎绰 模备老瘤 隔扼夸.</font>
</td>
</tr>
<!-- 咯归 矫累 -->
<tr height="8">
<td></td>
</tr>
<!-- 咯归 场 -->
<!--捞傈/促澜 傅农 冠胶 矫累-->
<%
pageurl=url_path+"/news/ProfileResult.jsp?mphone="+mphone+"&gphone="+gphone+"&selectsex="+selectsex+"&selectage="+selectage+"&todayprofile="+todayprofile+"&textprofile="+java.net.URLEncoder.encode(textprofile);
String [] szSplit = pagePathTop(pageurl, num, pageNUM, pagecount);
%>
<tr>
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0" bgcolor="<%=pageBgColor %>">
<tr>
<td width="25"></td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -