?? fortunetip_love.jsp.svn-base
字號:
<!------------------------------------------------------------------
* @ 權> Xxx叢狼 迄喬 > 家匡皋撈飄 > 款技屏
* @ Author : 林妨唱 ( 2008-06-12 )
* @ 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;
}
/*------------------------------------------------------------------------------------------------------
+ 傈開 函薦
-------------------------------------------------------------------------------------------------------*/
int user_year = 0;
String user_name = "";
int user_month = 0;
int user_day = 0;
int user_sex = 0;
int opposite_user_sex = 0;
int idx = 0;
String name = "";
float s_date = 0;
float sex = 0;
List list = new ArrayList();
String rgTitle[] = new String[3];
String rgTableName[] = new String[3];
int n=0;
int randomtitle = -1;
int randomtitleTwo = -1;
/*------------------------------------------------------------------------------------------------------
+ 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,month,day,sex from GT_user_Info WITH (READUNCOMMITTED) where phonenum = '"+mphone+"'";
rs=stmt.executeQuery(query1);
if(rs.next())
{
user_name = rs.getString("nickname");
user_year=rs.getInt("year");
user_month = rs.getInt("month");
user_day = rs.getInt("day");
user_sex = rs.getInt("sex");
}
if(rs != null) rs.close();
//System.out.println("user_sex========"+user_sex);
if (user_sex==2){
opposite_user_sex = 0;
query1="select idx,name,s_date,sex from GT_LUCK_STARNAME WITH (READUNCOMMITTED) where sex ="+opposite_user_sex;
rs=stmt.executeQuery(query1);
while(rs.next())
{
Map map = new HashMap();
map.put("idx",new Integer(rs.getInt(1)));
map.put("name",rs.getString(2));
map.put("s_date",new Float(rs.getFloat(3)));
map.put("sex",new Float(rs.getFloat(4)));
list.add(map);
}
//System.out.println("list="+list);
if(rs != null) rs.close();
}else{
opposite_user_sex = 1 ;
query1="select idx,name,s_date,sex from GT_LUCK_STARNAME WITH (READUNCOMMITTED) where sex ="+opposite_user_sex;
rs=stmt.executeQuery(query1);
while(rs.next())
{
Map map = new HashMap();
map.put("idx",new Integer(rs.getInt(1)));
map.put("name",rs.getString(2));
map.put("s_date",new Float(rs.getFloat(3)));
map.put("sex",new Float(rs.getFloat(4)));
list.add(map);
}
if(rs != null) rs.close();
}
/*------------------------------------------------------------------------------------------------
* 款技屏.
-------------------------------------------------------------------------------------------------*/
//款技評 id 備竅綽 傍僥 矯累
Date todayDate1 = new Date();
randomtitle = todayDate1.getDate()+user_day;
randomtitle = Integer.parseInt(String.valueOf(randomtitle).substring(String.valueOf(randomtitle).length()-1));
randomtitleTwo = randomtitle+3;
if(randomtitle == 0){
randomtitle =10;
}
if(randomtitleTwo > 10){
randomtitleTwo = 10;
}
//款技評 id 備竅綽 傍僥 場
query1 = "select top 2 title,tablest from gt_luck_title WITH (READUNCOMMITTED) where idx = "+randomtitle+" or idx = "+randomtitleTwo;
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="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2" height="2" bgcolor="#c789ff"></td>
</tr>
<tr>
<td width="6" height="14" bgcolor="#9819e9"></td>
<td height="14" 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="4"></td>
</tr>
<!--咯歸 場-->
<!--惑炔喊 款技 焊扁 冠膠 矯累-->
<!--膠鷗客 礬宏 款技 冠膠 矯累-->
<tr>
<td>
<table width="176" bgcolor="#ecaaff" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="3" height="3"></td>
</tr>
<tr>
<td width="3"></td>
<td>
<!--殿廢等 龍鞏 郴儈 矯累-->
<table width="170" bgcolor="#ffffff" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="3" height="5"></td>
</tr>
<tr>
<td colspan="3" align="center"><font color="#9819e9"><b>膠鷗客 嘎苗焊綽 礬宏 款技!</b></font></td>
</tr>
<!--備盒扼牢 矯累-->
<tr>
<td width="7"></td>
<td><font color="#d5d1be" align="center">··························</font></td>
<td width="7"></td>
</tr>
<!--備盒扼牢 場-->
<!--郴儈 矯累-->
<tr>
<td colspan="3">
<table width="170" border="0" cellpadding="0" cellspacing="0">
<tr>
<td></td>
<td width="160" align="center"><font color="#909090">唱客 楷娟款闌 嘎苗 焊絆 酵籃</font><br>
<font color="#909090">楷局牢闌 急琶秦 林技夸.</font>
</td>
<td ></td>
</tr>
<tr>
<td colspan="3" height="8"></td>
</tr>
<tr>
<td></td>
<td align="center">
<form name = "love" action="fortunetip_love_show.jsp" method="post">
<input type="hidden" name="user_name" value="<%=java.net.URLEncoder.encode(user_name)%>"/>
<input type="hidden" name="user_year" value="<%=user_year%>"/>
<input type="hidden" name="user_month" value="<%=user_month%>"/>
<input type="hidden" name="user_day" value="<%=user_day%>"/>
<input type="hidden" name="mphone" value="<%=mphone%>"/>
<input type="hidden" name="gphone" value="<%=gphone%>"/>
<input type="hidden" name="gphone" value="<%=gphone%>"/>
<select name="opposite_user_date" size="1">
<%if(list.size()==0){ %>
<option value="">nothing!</option>
<%}else{ %>
<%
Map map1 = null;
for(int i=0;i<list.size();i++){
map1 = (Map)list.get(i);
idx = Integer.parseInt(String.valueOf(map1.get("idx")));
name = (String)map1.get("name");
s_date = Float.parseFloat(String.valueOf(map1.get("s_date")));
sex = Float.parseFloat(String.valueOf(map1.get("sex")));
%>
<option value="<%=s_date%>"><%=name%></option>
<%
}
}
%>
</select>
</form>
</td>
<td ></td>
</tr>
</table>
</td>
</tr>
<!--郴儈 場-->
<tr>
<td colspan="3" height="5"></td>
</tr>
<!--嘎苗焊扁 滾瓢 矯累-->
<tr>
<td colspan="3">
<table width="170" border="0" cellpadding="0" cellspacing="0">
<tr>
<td></td>
<td width="55" height="16" align="center" bgcolor="#c789ff"><a href="javascript:document.love.submit()"><font color="#ffffff">嘎苗焊扁</font></a></td>
<td></td>
</tr>
</table>
</td>
</tr>
<!--嘎苗焊扁 滾瓢 場-->
<tr>
<td colspan="3" height="8"></td>
</tr>
</table>
</td>
<td width="3"></td>
</tr>
<tr>
<td colspan="3" height="3"></td>
</tr>
</table>
</td>
</tr>
<!--膠鷗客 礬宏 款技 冠膠 場-->
<tr>
<td height="8"></td>
</tr>
<tr>
<td>
<!--竅竄 龍鞏 郴儈 矯累-->
<table width="176" border="0" cellspacing="0" cellpadding="0">
<%if(n!=0){
for(int i=0;i<n;i++){
%>
<tr>
<td width="5"></td>
<td width="166"><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="8"></td>
</tr>
<!--滾瓢 矯累-->
<tr>
<td>
<table width="176" height="16" border="0" cellspacing="0" cellpadding="0">
<tr>
<td></td>
<td width="55" height="16" 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="176" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10" bgcolor="#BBC7C8"></td>
<td width="156" bgcolor="#DAE6E8" height="15"> <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></td>
<td width="10" bgcolor="#BBC7C8"></td>
</tr>
<tr>
<td width="10" bgcolor="#BBC7C8"></td>
<td width="156" bgcolor="#DAE6E8" height="15"> ><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 + -