?? fortunetip_animalsign.jsp
字號:
<!------------------------------------------------------------------
* @ 權> Xxx叢狼 迄喬 > 家匡皋撈飄 > 款技屏
* @ Author : 林妨唱 ( 2008-06-06 )
* @ Images :
--------------------------------------------------------------------->
<%@ page import='java.io.*,java.text.*,java.util.Date,java.util.*, java.sql.*, com.entaz.lib.db.*, com.entaz.relay.net.*' contentType='text/html;charset=euc-kr'%>
<%@ include file="../imgpath.jsp"%>
<%!
public static String isNull(String str)
{
if (str == null)
return "";
else
return str;
}
%>
<%
/*------------------------------------------------------------------------------------------------------
+ 扁夯 頗扼固磐
-------------------------------------------------------------------------------------------------------*/
String mphone= request.getParameter("mphone");
//if(mphone == null){
// mphone= "13269404505";
//}
String gphone= request.getParameter("gphone");
if(null == gphone){
gphone = mphone;
}
/*------------------------------------------------------------------------------------------------------
+ 傈開 函薦
-------------------------------------------------------------------------------------------------------*/
String user_name = "";
int user_year = 0;
int now_year = 0;
int now_month = 0;
int now_day = 0;
int result01 = 0;
int result02 = 0;
int result03 = 0;
String detail = "";
String rgTitle[] = new String[3];
String rgTableName[] = new String[3];
int n=0;
/*------------------------------------------------------------------------------------------------------
+ DB 包訪 函薦
-------------------------------------------------------------------------------------------------------*/
PreparedStatement pstmt = null;
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
String query1 = null;
String ssql = null;
/*------------------------------------------------------------------------------------------------------
+ 朝樓 包訪
-------------------------------------------------------------------------------------------------------*/
Timestamp di_date=null;
Date today = new Date();
SimpleDateFormat timeform;
timeform = new SimpleDateFormat("MM/dd HH:mm");
try
{
/*------------------------------------------------------------------------------------------------
* DB 目池記
-------------------------------------------------------------------------------------------------*/
%><%@ include file="../getConnection.jsp"%><%
/**************************************
膠鷗客 嘎苗焊綽 礬宏款技!
***************************************/
stmt = con.createStatement();
query1="select nickname,year from GT_user_Info where phonenum = '"+mphone+"'";
rs=stmt.executeQuery(query1);
if(rs.next())
{
user_name = rs.getString("nickname");
user_year=rs.getInt("year");
}
if(rs != null) rs.close();
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");
Date now= new Date();
String date=df.format(now);
int yyyy,mm,dd = 0;
now_year = Integer.parseInt(date.substring(0,4));
now_month = Integer.parseInt(date.substring(5,7));
now_day = Integer.parseInt(date.substring(8,date.length()));
//System.out.println("user_year:"+user_year);
//System.out.println("year========="+now_year);
//System.out.println("month=========="+now_month);
//System.out.println("day==========="+now_day);
result01 = user_year%12;
//System.out.println("result01:"+result01);
result02 = 10*now_day+now_month+now_day;
//System.out.println("result02:"+result02);
result03 = result01+1+12*result02;
//System.out.println("result03:"+result03);
query1="select detail from GT_LUCK_ANIMALSIGN where idx="+result03;
rs=stmt.executeQuery(query1);
if(rs.next())
{
detail = rs.getString("detail");
}
if(rs != null) rs.close();
/*------------------------------------------------------------------------------------------------
* 款技屏.
-------------------------------------------------------------------------------------------------*/
query1 = "select top 3 title,tablest from gt_luck_title order by newid()";
pstmt = con.prepareStatement(query1);
rs = pstmt.executeQuery();
for(int i=0;rs.next();i++)
{
rgTitle[i]=rs.getString("title");
rgTableName[i]=rs.getString("tablest");
n=i+1;
}
rs.close();
pstmt.close();
}catch(Exception e){
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){}
}
%>
<html>
<head>
<link href="http://entaz.mugeta.com/client/mugeta_v2_test/web/user/mobile.css" rel="stylesheet" type="text/css">
<title>權><%=user_name%>叢狼 迄喬 > 家匡皋撈飄 > 款技屏</title>
</head>
<body>
<!--劇僥
<tr>
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr>
<td></td>
</tr>
</table>
</td>
</tr>
-->
<table width="240" border="0" cellspacing="0" cellpadding="0">
<!--鷗撈撇 矯累-->
<tr>
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2" height="2" bgcolor="#c789ff"></td>
</tr>
<tr>
<td width="10" height="15" bgcolor="#9819e9"></td>
<td height="15" bgcolor="#9819e9"><font color="#ffffff">款技屏!</font></td>
</tr>
<tr>
<td colspan="2" height="2" bgcolor="#c789ff"></td>
</tr>
<tr>
<td colspan="2" height="1" bgcolor="#9819e9"></td>
</tr>
</table>
</td>
</tr>
<!--鷗撈撇 場-->
<!--咯歸 矯累-->
<tr>
<td height="8"></td>
</tr>
<!--咯歸 場-->
<!--輯宏 鷗撈撇 矯累-->
<tr>
<td align="center"><font color="#9819e9"><b>坷疵狼 鵝喊 款技 焊扁</b></font></td>
</tr>
<!--輯宏 鷗撈撇 場-->
<!--咯歸 矯累-->
<tr>
<td height="11"></td>
</tr>
<!--咯歸 場-->
<!--搬苞焊扁 冠膠 矯累-->
<tr>
<td >
<table width="240" border="0" cellspacing="0" cellpadding="0">
<!--搬苞焊扁 鷗撈撇 矯累-->
<tr>
<td width="3"></td>
<td height="19"><font color="#c789ff"><b>♂</b></font><font color="#7c7c7c"><b> 搬苞 焊扁</b></font></td>
<td width="3"></td>
</tr>
<!--備盒急 矯累-->
<tr>
<td width="3"></td>
<td height="2" bgcolor="#ecaaff"></td>
<td width="3"></td>
</tr>
<!--備盒急 場-->
<tr>
<td colspan="3" height="3"></td>
</tr>
<!--搬苞焊扁 鷗撈撇 場-->
<!--搬苞焊扁 郴儈 冠膠 矯累-->
<tr>
<td colspan="3">
<table width="240" bgcolor="#e8f2f2" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="5" height="7"></td>
</tr>
<%if(detail == null | detail.equals("")){ %>
<tr>
<td width="3" bgcolor="#ffffff"></td>
<td width="5"></td>
<td><font color="#9819e9">nothing!!!</font></td>
<td width="5"></td>
<td width="3" bgcolor="#ffffff"></td>
</tr>
<%}else{ %>
<tr>
<td width="3" bgcolor="#ffffff"></td>
<td width="5"></td>
<td><font color="#9819e9"><%=detail%></font></td>
<td width="5"></td>
<td width="3" bgcolor="#ffffff"></td>
</tr>
<%} %>
<tr>
<td colspan="5" height="7"></td>
</tr>
</table>
</td>
</tr>
<!--搬苞焊扁 郴儈 冠膠 場-->
</table>
</td>
</tr>
<!--搬苞焊扁 冠膠 場-->
<tr>
<td height="8"></td>
</tr>
<tr>
<td>
<!--竅竄 龍鞏 郴儈 矯累-->
<table width="240" border="0" cellspacing="0" cellpadding="0">
<%if(n!=0){
for(int i=0;i<n;i++){
%>
<tr>
<td width="5"></td>
<td width="230"><font color="#c789ff"><b>*</b></font><font color="#545454">
<%
if(rgTableName[i].equals("GT_LUCK_STARTEXT")){
out.print("<a href="+url_path+"/soulmate/fortunetip_love.jsp?mphone="+mphone+"&gphone="+gphone+">");
}else if(rgTableName[i].equals("GT_LUCK_DREAM")){
out.print("<a href="+url_path+"/soulmate/fortunetip_dream.jsp?mphone="+mphone+"&gphone="+gphone+">");
}else if(rgTableName[i].equals("GT_LUCK_BLOODTYPE")){
out.print("<a href="+url_path+"/soulmate/fortunetip_bloodtype.jsp?mphone="+mphone+"&gphone="+gphone+">");
}else if(rgTableName[i].equals("GT_LUCK_FIRSTDATE")){
out.print("<a href="+url_path+"/soulmate/fortunetip_date.jsp?mphone="+mphone+"&gphone="+gphone+">");
}else if(rgTableName[i].equals("GT_LUCK_ANIMALSIGN")){
out.print("<a href="+url_path+"/soulmate/fortunetip_animalsign.jsp?mphone="+mphone+"&gphone="+gphone+">");
}else if(rgTableName[i].equals("GT_LUCK_TODAYSAYING")){
out.print("<a href="+url_path+"/soulmate/fortunetip_todaysaying.jsp?mphone="+mphone+"&gphone="+gphone+">");
}else if(rgTableName[i].equals("GT_LUCK_BORN")){
out.print("<a href="+url_path+"/soulmate/fortunetip_born.jsp?mphone="+mphone+"&gphone="+gphone+">");
}else if(rgTableName[i].equals("GT_LUCK_LOTO")){
out.print("<a href="+url_path+"/soulmate/fortunetip_loto.jsp?mphone="+mphone+"&gphone="+gphone+">");
}else if(rgTableName[i].equals("GT_LUCK_MARRY")){
out.print("<a href="+url_path+"/soulmate/fortunetip_marry.jsp?mphone="+mphone+"&gphone="+gphone+">");
}else if(rgTableName[i].equals("GT_LUCK_FLOWER")){
out.print("<a href="+url_path+"/soulmate/fortunetip_flower.jsp?mphone="+mphone+"&gphone="+gphone+">");
}
%>
<%=rgTitle[i]%>
</a></font></td>
<td width="5"></td>
</tr>
<%}
}
%>
</table>
<!--竅竄 龍鞏 郴儈 場-->
</td>
</tr>
<tr>
<td height="13"></td>
</tr>
<!--滾瓢 矯累-->
<tr>
<td>
<table width="240" height="17" border="0" cellspacing="0" cellpadding="0">
<tr>
<td></td>
<td width="60" height="17" bgcolor="#c789ff" align="center"><a href="<%=url_path%>/soulmate/MySoulmate.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>"><font color="#ffffff">倒酒啊扁</font></a></td>
<td></td>
</tr>
</table>
</td>
</tr>
<!--滾瓢 場-->
<!--咯歸 矯累-->
<tr>
<td height="11"></td>
</tr>
<!--咯歸 場-->
<!--竅竄 版肺釬矯 矯累-->
<tr>
<td>
<table width="240" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10" bgcolor="#BBC7C8"></td>
<td width="220" bgcolor="#DAE6E8" height="19"> <a href="<%=url_path%>/main.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>">權</a>><a href="<%=url_path%>/mypage/my_confirm.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>"><%=user_name%>叢狼 迄喬包府</a>><a href="<%=url_path%>/soulmate/MySoulmate.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>">家匡皋撈飄</a>>款技屏</td>
<td width="10" bgcolor="#BBC7C8"></td>
</tr>
</table>
</td>
</tr>
<!--竅竄 版肺釬矯 場-->
</table>
<!--竅竄 版肺釬矯 矯累-->
<%@ include file="../newbottom.jsp"%>
<!--竅竄 版肺釬矯 場-->
</body>
</html>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -