📄 newsmain.jsp.svn-base
字号:
<%@ page import='java.io.*,java.text.*,java.util.*,java.util.Date,java.util.Vector, java.sql.*, com.entaz.lib.db.*, com.entaz.relay.net.*' contentType='text/html;charset=euc-kr'%>
<%@ include file="formatUtil.jsp"%>
<%@ include file="../imgpath.jsp"%>
<%@ include file="../common_func.jsp"%>
<%@ include file="../makeKOR.jsp"%>
<%
//*------------------------------------------------------------------------------------------------------
//+ 扁夯 颇扼固磐
//-------------------------------------------------------------------------------------------------------*/
String mphone= request.getParameter("mphone");
if (!mphone.isEmpty() && mphone != null)
mphone = getStrPhone(getLong(mphone));
String gphone= request.getParameter("gphone");
if (!gphone.isEmpty() && gphone != null)
gphone = getStrPhone(getLong(gphone));
//*------------------------------------------------------------------------------------------------------
//+ 傈开 函荐
//-------------------------------------------------------------------------------------------------------*/
String myname = "";
String nickName = ""; //葱匙烙
int count = 0;
String strTodayState = "";
int iTodayState = -1;
// img颇老肺沥
String imgFile = "";
long fLevel = 0;
// 橇肺鞘俊 包茄 函荐
int cProfileCount = 0;
String strToolTip = ""; //富浅急
String strToDo = ""; //坷疵狼 且老
String strMotto = ""; //坷疵狼 谅快疙
String strFriend = ""; //坷疵狼 模备
String strWish = ""; //坷疵狼 家盔
String strInterest = ""; //坷疵狼 包缴荤
String strFood = ""; //坷疵 冈篮 澜侥
String strMusic = ""; //坷疵 甸篮 澜厩
String strAgony = ""; //坷疵狼 绊刮
String strLookMan = ""; //瘤陛 焊绊锹 荤恩
String strFault = ""; //坷疵狼 角荐
int iToDorReCnt = 0; //坷疵狼 且老 瘩臂荐
int iMottoReCnt = 0; //坷疵狼 谅快疙 瘩臂荐
int iFriendReCnt = 0; //坷疵狼 模备 瘩臂荐
int iWishReCnt = 0; //坷疵狼 家盔 瘩臂荐
int iInterestReCnt = 0; //坷疵狼 包缴荤 瘩臂荐
int iFoodReCnt = 0; //坷疵 冈篮 澜侥 瘩臂荐
int iMusicReCnt = 0; //坷疵 甸篮 澜厩 瘩臂荐
int iAgonyReCnt = 0; //坷疵狼 绊刮 瘩臂荐
int iLookManReCnt = 0; //瘤陛 焊绊锹 荤恩 瘩臂荐
int iFaultReCnt = 0; //坷疵狼 角荐 瘩臂荐
int iTotCnt = 0; //醚 瘩臂荐
int iFace = 1; //倔奔钎沥
boolean boolState = false; //坷疵狼 橇肺鞘捞 乐绰啊 绝绰啊甫 魄窜.
//
String strNewsKind = ""; //臂 辆幅
int iNewsKind = 0; //臂辆幅(int)
String strNewsTitle = ""; //臂 力格
String strPrintNewsTitle = ""; //臂 力格 (畴免窍绰)
int iNewsReCnt = 0; //瘩臂荐
String strRegdate = ""; //矫埃
//
String strFriendPhone = ""; // 迄 NO.
int iQueryType = 0; // 炼雀 蜡屈
String strJSPLink = "";
int iIdx = 0;
// string蜡屈狼 辨捞
int cStringTypeLength = 0;
int cBestCount = 0;
//*------------------------------------------------------------------------------------------------------
//+ 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"%><%
if (neededExp == 0)
fLevel = 1;
else
fLevel = (long)(((float)(cumulatedExpNow - cumulatedExp)) / (float)neededExp * 10) + 1;
imgFile = img_path + "images/news/010_"+ fLevel +".png";
String sql = "SELECT NICKNAME FROM GT_USER_INFO WITH (READUNCOMMITTED) WHERE PHONENUM = '" + gphone + "'";
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if(rs.next())
{
nickName = rs.getString("NICKNAME");
}
rs.close();
pstmt.close();
// 扁盒
sql = "SELECT COUNT(*) FROM GT_NsMood WITH (READUNCOMMITTED) WHERE PHONENUM = " + Long.parseLong(gphone);
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if (rs.next())
{
count = rs.getInt(1);
rs.close();
pstmt.close();
}
if (count > 0)
{
String strState = "";
sql = "SELECT TOP 1 STATE FROM GT_NsMood WITH (READUNCOMMITTED) WHERE PHONENUM =" + Long.parseLong(gphone) + " ORDER BY REGDATE DESC";
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if(rs.next())
{
iTodayState = rs.getInt(1);
rs.close();
pstmt.close();
if (iTodayState == 1)
strState = "传拱捞 林疯林疯";
else if (iTodayState == 2)
strState = "困肺秦拎夸";
else if (iTodayState == 3)
strState = "哆舵固瘤辟";
else if (iTodayState == 4)
strState = "蜡蔫烹蔫";
else if (iTodayState == 5)
strState = "青格父顶";
strTodayState = "泅犁 "+ nickName +"丛篮 </font><b><a href='"+url_path+"/news/feelStatus.jsp?mphone="+mphone+"&gphone="+gphone+"'><font color='"+ mainFontColor + "' size='3'>"+ strState +"</font></a></b><font color='#928279' size='3'>惑怕涝聪促~≠";
}
}
else
{
if (mphone.equals(gphone))
strTodayState = "<a href='"+url_path+"/news/feelStatus.jsp?mphone="+mphone+"&gphone="+gphone+"'>扁盒阑 殿废秦林技夸.</a>";
else
strTodayState = "";
}
// 富浅急 棺 橇肺鞘
sql = "SELECT COUNT(*) FROM GT_NsProfile WITH (READUNCOMMITTED) WHERE PHONENUM = " + Long.parseLong(gphone) + " AND CONVERT(VARCHAR(20), regdate, 102) = CONVERT(VARCHAR(20), GETDATE(), 102)";
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if (rs.next())
{
cProfileCount = rs.getInt(1);
}
if (cProfileCount > 0)
{
boolState = true;
}
else
{
boolState = false;
}
rs.close();
pstmt.close();
sql = "SELECT TOP 1 idx, toolTip, toDo, motto, friend, wish, interest, ";
sql = sql + " food, music, agony, lookMan, fault, ToDorReCnt, ";
sql = sql + " mottoReCnt, friendReCnt, wishReCnt, interestReCnt, ";
sql = sql + " foodReCnt, musicReCnt, agonyReCnt, lookManReCnt, ";
sql = sql + " faultReCnt, totCnt, face FROM GT_NsProfile WITH (READUNCOMMITTED) ";
sql = sql + " WHERE PHONENUM = " + Long.parseLong(gphone) + " ORDER BY REGDATE DESC";
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if(rs.next())
{
iIdx = rs.getInt("idx");
strToolTip = rs.getString("toolTip").trim();
strToDo = rs.getString("toDo").trim();
strMotto = rs.getString("motto").trim();
strFriend = rs.getString("friend").trim();
strWish = rs.getString("wish").trim();
strInterest = rs.getString("interest").trim();
strFood = rs.getString("food").trim();
strMusic = rs.getString("music").trim();
strAgony = rs.getString("agony").trim();
strLookMan = rs.getString("lookMan").trim();
strFault = rs.getString("fault").trim();
iToDorReCnt = rs.getInt("ToDorReCnt");
iMottoReCnt = rs.getInt("mottoReCnt");
iFriendReCnt = rs.getInt("friendReCnt");
iWishReCnt = rs.getInt("wishReCnt");
iInterestReCnt = rs.getInt("interestReCnt");
iFoodReCnt = rs.getInt("foodReCnt");
iMusicReCnt = rs.getInt("musicReCnt");
iAgonyReCnt = rs.getInt("agonyReCnt");
iLookManReCnt = rs.getInt("lookManReCnt");
iFaultReCnt = rs.getInt("faultReCnt");
iTotCnt = rs.getInt("totCnt");
iFace = rs.getInt("face") == 0 ? 1 : rs.getInt("face");
rs.close();
pstmt.close();
}
if (strToolTip.equals(""))
{
strToolTip = "殿废等 春胶 橇肺鞘捞<br>绝嚼聪促.";
}
/*else
{
strToolTip = "救崇<br>" + strToolTip + "<br>窍咎~";
}
if (strToDo.equals("") && strMotto.equals("") && strFriend.equals("") && strWish.equals("")
&& strInterest.equals("") && strFood.equals("") && strMusic.equals("") && strAgony.equals("")
&& strLookMan.equals("") && strFault.equals(""))
boolState = false;
else
boolState = true;*/
%>
<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="176" border="0" cellspacing="0" cellpadding="0">
<!-- 冠胶 矫累 -->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0" bgcolor="<%=mainBgColor%>">
<tr height="18">
<td width="3"></td>
<td align="center"><font color="#ffffff">≮ <%=nickName%></font>丛狼 春胶 <font color="#ffffff">≮</font></td>
<td width="3"></td>
</tr>
<tr height="3">
<td width="3"></td>
<td bgcolor="#fffad2"></td>
<td width="3"></td>
</tr>
<%if (!strTodayState.equals("")) {%>
<tr>
<td width="3"></td>
<td bgcolor="#fffad2" align="center">
<font color="#928279" size="3"><%=strTodayState%></font>
</td>
<td width="3"></td>
</tr>
<%}%>
<tr height="3">
<td width="3"></td>
<td bgcolor="#fffad2"></td>
<td width="3"></td>
</tr>
<tr height="5">
<td width="3"></td>
<td bgcolor="#ffffff"></td>
<td width="3"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="3" bgcolor="<%=mainBgColor%>"></td>
<td width="5"></td>
<td width="50" height="56">
<!-- 酒官鸥 捞固瘤 矫累 -->
<table bgcolor="#ffede3" border="0" cellspacing="0" cellpadding="0">
<tr height="1">
<td colspan="3"></td>
</tr>
<tr height="54">
<td width="1"></td>
<td align="center"><img src="<%=ava_path%>display_thumb.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&face=<%=iFace%>" width="48" height="54" border="0"></td>
<td width="1"></td>
</tr>
<tr height="1">
<td colspan="3"></td>
</tr>
</table>
<!-- 酒官鸥 捞固瘤 场 -->
</td>
<td width="4"></td>
<!-- 富浅急 矫累 -->
<td width="6"><img src="<%=img_path%>images/news/003.png"></td>
<td>
<table border="0" cellspacing="0" cellpadding="0">
<tr height="3">
<td width="3"><img src="<%=img_path%>images/news/004.png"></td>
<td bgcolor="<%=contentBgColor%>" colspan="2"></td>
<td width="3"><img src="<%=img_path%>images/news/006.png"></td>
</tr>
<tr height="50">
<td width="3" bgcolor="<%=contentBgColor%>"></td>
<td width="5" bgcolor="<%=contentBgColor%>"></td>
<td bgcolor="<%=contentBgColor%>" width="100%">
<font color="#ffffff"><%=strToolTip%></font>
</td>
<td width="3" bgcolor="<%=contentBgColor%>"></td>
</tr>
<tr height="3">
<td width="3"><img src="<%=img_path%>images/news/005.png"></td>
<td bgcolor="<%=contentBgColor%>" colspan="2"></td>
<td width="3"><img src="<%=img_path%>images/news/007.png"></td>
</tr>
</table>
</td>
<!-- 富浅急 场 -->
<td width="5"></td>
<td width="2" bgcolor="<%=mainBgColor%>"></td>
</tr>
<tr height="5">
<td width="3" bgcolor="<%=mainBgColor%>"></td>
<td colspan="6"></td>
<td width="3" bgcolor="<%=mainBgColor%>"></td>
</tr>
<tr height="3">
<td colspan="8" width="2" bgcolor="<%=mainBgColor%>"></td>
</tr>
</table>
</td>
</tr>
<!-- 冠胶 场 -->
<!--痢急 矫累-->
<tr>
<td align="center" >
<font color="#cccccc" size="3" align="center">···································</font>
</td>
</tr>
<!--痢急 场-->
<!-- 春胶 鸥捞撇 矫累 -->
<tr>
<td align="center">
<img src="<%=img_path%>images/news/008.png">
<font color="#928279" size="3">春胶 Level </font><font color="<%=mainFontColor%>">-<b><a href="<%=url_path%>/news/feelLevel.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>"><font color="<%=mainFontColor%>"><%=level%>窜拌</font></a></b>-</font><font color="#928279" size="3"> (<%=mainBgColorName%>)</font>
</td>
</tr>
<!-- 春胶 鸥捞撇 场 -->
<!--痢急 矫累-->
<tr>
<td align="center">
<font color="#cccccc" size="3" align="center">···································</font>
</td>
</tr>
<!--痢急 场-->
<!-- 春胶 牧刨明 矫累 -->
<tr>
<td align="center">
<img src="<%=imgFile%>">
</td>
</tr>
<tr height="4">
<td align="center"></td>
</tr>
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="4"></td>
<td>
<%
strJSPLink = url_path+"/news/ProfileReple.jsp?mphone="+mphone+"&gphone="+gphone+"&nickname="+nickName+"&ref_idx="+iIdx;
if (!strToDo.isEmpty()) {%>
<font color="#928279" size="3">- 坷疵狼 且老 : </font><a href="<%=strJSPLink%>&news=<%=strToDo%>&colum_num=1"><%=strToDo%></a><font color="<%=mainFontColor%>" size="3"> [<%=iToDorReCnt%>]</font><br>
<%}if (!strMotto.isEmpty()) {%>
<font color="#928279" size="3">- 坷疵狼 谅快疙 : </font><a href="<%=strJSPLink%>&news=<%=strMotto%>&colum_num=2"><%=strMotto%></a><font color="<%=mainFontColor%>" size="3"> [<%=iMottoReCnt%>]</font><br>
<%}if (!strFriend.isEmpty()) {%>
<font color="#928279" size="3">- 坷疵狼 模备 : </font><a href="<%=strJSPLink%>&news=<%=strFriend%>&colum_num=3"><%=strFriend%></a><font color="<%=mainFontColor%>" size="3"> [<%=iFriendReCnt%>]</font><br>
<%}if (!strWish.isEmpty()) {%>
<font color="#928279" size="3">- 坷疵狼 家盔 : </font><a href="<%=strJSPLink%>&news=<%=strWish%>&colum_num=4"><%=strWish%></a><font color="<%=mainFontColor%>" size="3"> [<%=iWishReCnt%>]</font><br>
<%}if (!strInterest.isEmpty()) {%>
<font color="#928279" size="3">- 坷疵狼 包缴荤 : </font><a href="<%=strJSPLink%>&news=<%=strInterest%>&colum_num=5"><%=strInterest%></a><font color="<%=mainFontColor%>" size="3"> [<%=iInterestReCnt%>]</font><br>
<%}if (!strFood.isEmpty()){ %>
<font color="#928279" size="3">- 坷疵 冈篮 澜侥 : </font><a href="<%=strJSPLink%>&news=<%=strFood%>&colum_num=6"><%=strFood%></a><font color="<%=mainFontColor%>" size="3"> [<%=iFoodReCnt%>]</font><br>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -