📄 feellevel.jsp
字号:
<!-------------------------------------------------------------
* @ name: feelStatus.jsp
* @ func: show the mood char of the recent 5 days
* @ Author : ranxu
* @ date :2008-06-26
-------------------------------------------------------------->
<%@ page import='java.io.*,java.text.*,java.util.Date,java.util.Vector, 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="appConstants.jsp"%>
<%@ include file="formatUtil.jsp"%>
<%@ include file="../makeKOR.jsp"%>
<%
String mphone = request.getParameter("mphone");
String gphone = request.getParameter("gphone");
mphone = getStrPhone(getLong(mphone));
gphone = getStrPhone(getLong(gphone));
/*------------------------------------------------------------------------------------------------------
+ parmater of current page
-------------------------------------------------------------------------------------------------------*/
String minLevels[] = new String[12];
String maxLevels[] = new String[12];
String mainBgColors[] = new String[12];
String mainBgColorNames[] = new String[12];
int count = 0;
String strNickname = "";
/*------------------------------------------------------------------------------------------------------
+ DB 包访 函荐
-------------------------------------------------------------------------------------------------------*/
PreparedStatement pstmt = null;
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
String sql = "";
try
{
/*------------------------------------------------------------------------------------------------
* DB 目池记
-------------------------------------------------------------------------------------------------*/
%>
<%@ include file="../getConnection.jsp"%>
<%@ include file="bgColor.jsp"%>
<%
/*------------------------------------------------------------------------------------------------
* Host nickName
-------------------------------------------------------------------------------------------------*/
sql = " SELECT nickname FROM GT_User_Info WITH (READUNCOMMITTED) WHERE phonenum='"+gphone+"'" ;
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if( rs.next() ){
strNickname = rs.getString("nickname");
}else{
strNickname = "绝澜";
}
rs.close();
pstmt.close();
/*------------------------------------------------------------------------------------------------
* 郴 巩力 炼福扁 荤恩.
-------------------------------------------------------------------------------------------------*/
sql = " SELECT MIN(level) minLevel,MAX(level) maxLevel,mainBgColor,mainBgColorName FROM gt_nslevel WITH (READUNCOMMITTED) GROUP BY mainBgColor,mainBgColorName ORDER BY min(level)";
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
for(int i=0;rs.next();i++){
minLevels[i]=rs.getString("minLevel");
maxLevels[i]=rs.getString("maxLevel");
mainBgColors[i]=rs.getString("mainBgColor");
mainBgColorNames[i]=rs.getString("mainBgColorName");
}
rs.close();
pstmt.close();
%>
<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>
<form action="#">
<table width="176" border="0" cellspacing="0" cellpadding="0">
<!-- 鸥捞撇 矫累 -->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr height="19">
<td width="8" bgcolor="<%=mainBgColor %>"></td>
<td bgcolor="<%=mainBgColor %>"><font color="#ffffff">迄乔春胶Level救郴</font></td>
</tr>
</table>
</td>
</tr>
<!-- 鸥捞撇 场 -->
<!-- 咯归 矫累 -->
<tr height="6">
<td></td>
</tr>
<!-- 咯归 场 -->
<!-- 鸥捞撇 牧刨明 矫累 -->
<tr>
<td align="center">
<font color="#716e63">春胶Level俊 蝶扼 硅版祸捞 官豺聪促.</font><br><br>
<font color="<%=mainFontColor %>" size="3">拌加秦辑 饭骇阑 棵妨焊技夸!</font><br>
<font color="<%=mainFontColor %>" size="3">濒娄 捞亥飘档 霖厚登绢 乐嚼聪促.^^</font><br>
</td>
</tr>
<!-- 鸥捞撇 牧刨明 场 -->
<!--痢急 矫累-->
<tr>
<td align="center">
<font color="#cccccc" size="3" align="center">··········································</font>
</td>
</tr>
<!--痢急 场-->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr height="17">
<td width="9"></td>
<td width="75" bgcolor="<%=mainBgColors[10].trim() %>" align="center"><font color="#ffffff"><%if(minLevels[10].equals(maxLevels[10])){ %>Level<%=minLevels[10].trim() %><%}else{%>Level<%=minLevels[10].trim() %>~<%=maxLevels[10].trim() %><%} %> : <br><%=mainBgColorNames[10].trim() %></font></td>
<td width="2"></td>
<td width="75" bgcolor="" align="center"></td>
<td width="9"></td>
</tr>
<%
for(int i=minLevels.length-3;i>0;i=i-2){
%>
<tr height="17">
<td width="9"></td>
<%
if(mainBgColors[i]==null){
%>
<td width="75" bgcolor="" align="center"></td>
<%
}else{
%>
<td width="75" bgcolor="<%=mainBgColors[i].trim() %>" align="center"><font color="#ffffff"><%if(minLevels[i].equals(maxLevels[i])){ %>Level<%=minLevels[i].trim() %><%}else{%>Level<%=minLevels[i].trim() %>~<%=maxLevels[i].trim() %><%} %> : <br><%=mainBgColorNames[i].trim() %></font></td>
<%
}
%>
<td width="2"></td>
<td width="80" bgcolor="<%=mainBgColors[i-1].trim() %>" align="center"><font color="#ffffff"><%if(minLevels[i-1].equals(maxLevels[i-1])){ %>Level<%=minLevels[i-1].trim() %><%}else{%>Level<%=minLevels[i-1].trim() %>~<%=maxLevels[i-1].trim() %><%} %>: <br><%=mainBgColorNames[i-1].trim() %></font></td>
<td width="9"></td>
</tr>
<tr height="2">
<td colspan="5"></td>
</tr>
<%
}
%>
</table>
</td>
</tr>
<!--痢急 矫累-->
<tr>
<td align="center">
<font color="#cccccc" size="3" align="center">··········································</font>
</td>
</tr>
<!--痢急 场-->
<!-- 咯归 矫累 -->
<tr height="2">
<td></td>
</tr>
<!-- 咯归 场 -->
<!-- 滚瓢 矫累 -->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr height="16">
<td></td>
<td width="55" bgcolor="<%=mainBgColor %>" align="center" ><a href="<%=url_path%>/news/NewsMain.jsp?mphone=<%=mphone%>&gphone=<%=gphone %>"><font color="#ffffff">倒酒啊扁</font></a></td>
<td></td>
</tr>
</table>
</td>
</tr>
<!-- 滚瓢 场 -->
<!-- 咯归 矫累 -->
<tr height="11">
<td></td>
</tr>
<!-- 咯归 场 -->
<!--版肺钎矫 矫累-->
<%
String step1=url_path+"/main.jsp?mphone="+mphone+"&gphone="+gphone;//权
String step2=url_path+"/mypage/my_confirm.jsp?mphone="+mphone+"&gphone="+gphone;
String step3=url_path+"/news/NewsMain.jsp?mphone="+mphone+"&gphone="+gphone;
%>
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr height="15">
<td width="8" bgcolor="#BBC7C8"></td>
<td bgcolor="#DAE6E8"> <a href="<%=step1%>">权</a>><a href="<%=step2%>"><%=strNickname%>丛狼迄乔</a>><a href="<%=step3%>">春胶</a>>汲巩炼荤</td>
<td width="8" bgcolor="#BBC7C8"></td>
</tr>
</table>
</td>
</tr>
<!--版肺钎矫 场-->
</table>
</form>
<!--窍窜 版肺钎矫 矫累-->
<%@ 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 + -