📄 profilesearch.jsp
字号:
<!--------------------------------------------------------------------------------------------------------------
*@橇肺鞘 八祸
*@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 year1 = "";
if(request.getParameter("year")!=null){year1=request.getParameter("year");}
String month = "";
if(request.getParameter("month")!=null){month=request.getParameter("month");}
String day = "";
if(request.getParameter("day")!=null){day=request.getParameter("day");}
/*------------------------------------------------------------------------------------------------------
+ 傈开 函荐
-------------------------------------------------------------------------------------------------------*/
String nickname = "";
String name[] = new String[3];
int year[]=new int[3];
int sex[]=new int[3];
String phonenum[]=new String[3];
int n=0;
int nyear = 0;
String regdate = "";
String y= "";
String m= "";
String d= "";
/*------------------------------------------------------------------------------------------------------
+ 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();
/*------------------------------------------------------------------------------------------------------
+ 弥辟 top3 橇肺鞘
-------------------------------------------------------------------------------------------------------*/
query1="SELECT DISTINCT nickname,year,sex,phonenum FROM gt_user_info WITH (READUNCOMMITTED) WHERE phonenum IN(SELECT TOP 3 phonenum FROM"
+"(SELECT TOP 100 phonenum FROM GT_NsProfile WITH (READUNCOMMITTED) WHERE regdate>=dateadd(day,-1,getdate()) AND regdate<=getdate()"
+"ORDER BY totCnt DESC) a ORDER BY newid())";
pstmt = con.prepareStatement(query1);
rs=pstmt.executeQuery();
for(int i=0;rs.next();i++)
{
name[i]=rs.getString("nickname");
year[i]=rs.getInt("year");
sex[i]=rs.getInt("sex");
phonenum[i]=rs.getString("phonenum");
n=i+1;
}
pstmt.close();
rs.close();
Calendar calendar=Calendar.getInstance();
nyear=calendar.get(Calendar.YEAR);
%>
<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>
<!-- 咯归 场 -->
<!-- 橇肺鞘 八祸 惑窜 矫累 -->
<tr>
<td align="center">
<font color="#716e63">泅犁 鸥款 模备甸 吝 春胶 橇肺鞘狼 <br>
馆览捞 啊厘 哆芭款 模备甸涝聪促.<br></font>
</td>
</tr>
<!--痢急 矫累-->
<tr>
<td align="center">
<font color="#cccccc" size="3" align="center">······································</font>
</td>
</tr>
<!--痢急 场-->
<tr>
<td>
<%
if(n!=0)
{
for(int i=0;i<n;i++)
{
/*------------------------------------------------------------------------------------------------------
+ 弥辟 top3 橇肺鞘
-------------------------------------------------------------------------------------------------------*/
query1="SELECT TOP 1 regdate FROM GT_NsProfile WITH (READUNCOMMITTED) WHERE regdate>=dateadd(day,-1,getdate()) AND regdate<=getdate()"
+" AND phonenum = ? ORDER BY regdate DESC";
pstmt= con.prepareStatement(query1);
pstmt.setLong(1,getLong(phonenum[i]));
rs=pstmt.executeQuery();
if(rs.next())
{
regdate = rs.getString("regdate");
y = regdate.substring(0,4);
m = regdate.substring(5,7);
d = regdate.substring(8,10);
}
pstmt.close();
rs.close();
%>
<font color="<%=mainBgColor %>"><b>+
<a href="Trace.jsp?mphone=<%=mphone%>&gphone=<%=phonenum[i]%>&year=<%=y%>&month=<%=m%>&day=<%=d%>&yy=<%=year1%>&mm=<%=month%>&dd=<%=day%>&type=<%=1%>">
<%=name[i] %></a></b></font><b> (<%=getSex(sex[i]) %>) <%=nyear-year[i] %>混</b><br>
<%
}
}
%>
</td>
</tr>
<!-- 咯归 矫累 -->
<tr height="15">
<td></td>
</tr>
<!-- 咯归 场 -->
<!-- 橇肺鞘 八祸 惑窜 场 -->
<!-- 橇肺鞘 八祸 窍窜 矫累 -->
<tr>
<!-- 橇肺鞘 八祸 鸥捞撇 矫累 -->
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr height="17">
<td width="8" bgcolor="<%=mainBgColor %>"></td>
<td bgcolor="<%=mainBgColor %>"><font color="#ffffff">橇肺鞘 八祸</font></td>
</tr>
</table>
</td>
<!-- 橇肺鞘 八祸 鸥捞撇 场 -->
</tr>
<!-- 咯归 矫累 -->
<tr height="4">
<td></td>
</tr>
<!-- 咯归 场 -->
<tr>
<td>
<form name="form1" action="ProfileResult.jsp" method="post">
<table width="240" border="0" cellspacing="0" cellpadding="0" bgcolor="<%=contentBgColor%>">
<tr height="8">
<td colspan="3">
<input type="hidden" name="mphone" value="<%=mphone%>">
<input type="hidden" name="gphone" value="<%=gphone%>">
<input type="hidden" name="year" value="<%=year1%>">
<input type="hidden" name="month" value="<%=month%>">
<input type="hidden" name="day" value="<%=day%>">
</td>
</tr>
<tr>
<td width="8"></td>
<td>
<table border="0" cellspacing="0" cellpadding="0" bgcolor="<%=contentBgColor%>">
<tr>
<td width="70">
<select name="selectsex" align="center" valign="middle">
<option value=""> 己喊 </option>
<option value="0"> 傈眉 </option>
<option value="2"> 巢磊 </option>
<option value="1"> 咯磊 </option>
</select>
</td>
<td width="2"></td>
<td width="70">
<select name="selectage" align="center" valign="middle">
<option value=""> 唱捞 </option>
<option value="0"> 傈眉 </option>
<option value="10"> 10措 </option>
<option value="20"> 20措 </option>
<option value="30"> 30措 </option>
<option value="40"> 40措 </option>
<option value="50"> 50措 </option>
<option value="60"> 60措 </option>
</select>
</td>
<td></td>
</tr>
</table>
</td>
<td width="8"></td>
</tr>
<tr height="2">
<td colspan="3"></td>
</tr>
<tr>
<td width="8"></td>
<td>
<table border="0" cellspacing="0" cellpadding="0" bgcolor="<%=contentBgColor%>">
<tr>
<td width="90">
<select name="todayprofile" align="center" valign="middle">
<option value="1">坷疵狼且老</option>
<option value="2">坷疵狼谅快疙</option>
<option value="3">坷疵狼模备</option>
<option value="4">坷疵狼家盔</option>
<option value="5">坷疵狼包缴荤</option>
<option value="6">坷疵冈篮澜侥</option>
<option value="7">坷疵甸篮澜厩</option>
<option value="8">坷疵狼绊刮</option>
<option value="9">焊绊锹荤恩</option>
<option value="10">坷疵狼角荐</option>
</select>
</td>
<td width="2"></td>
<td width="80">
<input type="text" name="textprofile" width="80" defaultimemode="1" imemode="0" maxlength="12">
</td>
<td width="2"></td>
<td width="33" align="center">
<font color="<%=btnFontColor%>"><a href="javascript:form1.submit();">八祸</a></font>
</td>
<td></td>
</tr>
</table>
</td>
<td width="8"></td>
</tr>
<tr height="8">
<td colspan="3"></td>
</tr>
</table>
</form>
</td>
</tr>
<!-- 橇肺鞘 八祸 窍窜 场 -->
<!-- 咯归 矫累 -->
<tr height="11">
<td></td>
</tr>
<!-- 咯归 场 -->
<!-- 滚瓢 矫累 -->
<tr>
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr height="17">
<td></td>
<td width="60" bgcolor="<%=mainBgColor %>" align="center" >
<a href="Trace.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&year=<%=year1%>&month=<%=month%>&day=<%=day%>"><font color="#ffffff">倒酒啊扁</font></a></td>
<td></td>
</tr>
</table>
</td>
</tr>
<!-- 滚瓢 场 -->
<!-- 咯归 矫累 -->
<tr height="11">
<td></td>
</tr>
<!-- 咯归 场 -->
<!--版肺钎矫 矫累-->
<tr>
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr height="19">
<td width="10" bgcolor="#BBC7C8"></td>
<td bgcolor="#DAE6E8">
<a href="<%=url_path+"/main.jsp?mphone="+mphone+"&gphone="+gphone%>">权</a>><a href="<%=url_path%>/mypage/my_confirm.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>"><%=nickname %>丛狼迄乔</a>><a href="NewsMain.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>">春胶</a>>橇肺鞘八祸
</td>
<td width="10" bgcolor="#BBC7C8"></td>
</tr>
</table>
</td>
</tr>
<!--版肺钎矫 场-->
</table>
<!--窍窜 版肺钎矫 矫累-->
<%@ include file="../newbottom.jsp"%>
<!--窍窜 版肺钎矫 场-->
</body>
</html>
<%
}catch(Exception e)
{
System.out.println(e);
}
finally
{
if(rs != null) try{ rs.close(); }catch(Exception se){}
if(pstmt != null) try{ pstmt.close(); }catch(Exception se){}
if(stmt != null) try{ stmt.close(); }catch(Exception se){}
if(con != null) try{ con.close(); }catch(Exception se){}
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -