📄 answerdetail.jsp.svn-base
字号:
<!------------------------------------------------------------------
* @ 权> Xxx丛狼 迄乔 > 家匡皋捞飘 > 鸥肺痢
* @ Author : 碍辑康 ( 2008-05-21 )
* @ Images : temp_01.png - 墨靛
temp_03.png - 酒官鸥
--------------------------------------------------------------------->
<%@ 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"%>
<%!
public static String isNull(String str)
{
if (str == null)
return "";
else
return str;
}
%>
<%
/*------------------------------------------------------------------------------------------------------
+ 扁夯 颇扼固磐
-------------------------------------------------------------------------------------------------------*/
String mphone = request.getParameter("mphone");
String gphone = request.getParameter("gphone");
String id1 = request.getParameter("idx");
int idx = Integer.parseInt(id1);
/*------------------------------------------------------------------------------------------------------
+ DB 包访 函荐
-------------------------------------------------------------------------------------------------------*/
Connection con = null;
PreparedStatement pstmt=null;
Statement stmt = null;
ResultSet rs = null;
ResultSet pageset = null;
/*------------------------------------------------------------------------------------------------------
+ 傈开 函荐
-------------------------------------------------------------------------------------------------------*/
String query1=null , query2 = null ,query3 = null,sql = null;
int phonenum = 0;
String text = "";
String friendName = "";
String friendNickName = null;
int friendNum = 0;
String cardName = null;
String answer = null;
int cardIdx = 0;
String explan = null;
int date = 0;
String str_date = null;
String year = null;
String month = null;
String day = null;
String name = "";
%>
<%
try
{
/*------------------------------------------------------------------------------------------------
* DB 目池记
-------------------------------------------------------------------------------------------------*/
%><%@ include file="../getConnection.jsp"%><%
con.setAutoCommit(false);
stmt=con.createStatement();
/*------------------------------------------------------------------------------------------------
* 匙 name 阑 啊廉柯促
-------------------------------------------------------------------------------------------------*/
sql = "select nickname from GT_user_info WITH (READUNCOMMITTED) where phonenum = '"+mphone+"'";
pstmt = con.prepareStatement(sql);
rs = pstmt.executeQuery();
if(rs.next()){
name = rs.getString("nickname");
}
/*------------------------------------------------------------------------------------------------
* 龙巩 惑技
-------------------------------------------------------------------------------------------------*/
query1 = "select nregdate ,text from GT_LUCKY_TARO WITH (READUNCOMMITTED) where idx = "+idx;
pstmt = con.prepareStatement(query1);
rs = pstmt.executeQuery();
if(rs.next()){
date = rs.getInt(1);
text = rs.getString(2);
str_date = String.valueOf(date);
year = str_date.substring(0,4);
month = str_date.substring(4,6);
day = str_date.substring(6,str_date.length());
}
rs.close();
pstmt.close();
/*------------------------------------------------------------------------------------------------
* 翠函 惑技
-------------------------------------------------------------------------------------------------*/
query2 ="select D.cardname,D.idx as cardidx,D.explan,T.Taro_card_idx " +
" from GT_taro_db as D WITH (READUNCOMMITTED) inner join GT_LUCKY_TARO_COMMENT as T WITH (READUNCOMMITTED)" +
" on D.idx = T.Taro_card_idx" +
" where T.Taro_idx="+idx;
pstmt = con.prepareStatement(query2);
rs = pstmt.executeQuery();
if(rs.next()){
cardName = rs.getString(1);
cardIdx = rs.getInt(2);
explan = rs.getString(3);
}
rs.close();
pstmt.close();
/*------------------------------------------------------------------------------------------------
* 翠函磊 惑技
-------------------------------------------------------------------------------------------------*/
query3 = "select U.name,T.text as answer ,T.phonenum as friendNum ,U.nickname as friendNickname" +
" from GT_user_info as U WITH (READUNCOMMITTED) inner join GT_LUCKY_TARO_COMMENT as T WITH (READUNCOMMITTED)"+
" on convert(bigint,U.phonenum)= T.phonenum "+
" where T.Taro_idx="+idx +" and T.phonenum = convert(bigint,"+gphone+")";
pstmt = con.prepareStatement(query3);
rs = pstmt.executeQuery();
if(rs.next()){
friendName = rs.getString(1);
answer = rs.getString(2);
friendNum = rs.getInt(3);
friendNickName = rs.getString(4);
}
%>
<html>
<head>
<link href="http://entaz.mugeta.com/client/mugeta_v2_test/web/user/mobile.css" rel="stylesheet" type="text/css">
<title>权><%=name %>丛狼 迄乔 > 家匡皋捞飘 > 鸥肺痢</title>
</head>
<body>
<form name = "form1" method = "post" action="<%=url_path%>/soulmate/messageAdding.jsp">
<input type="hidden" name="mphone" value="<%=mphone%>"/>
<input type="hidden" name="gphone" value="<%=gphone%>"/>
<input type="hidden" name="friendNum" value="<%=friendNum%>"/>
<input type="hidden" name="friendNickName" value="<%=friendNickName%>"/>
<input type="hidden" name="idx" value="<%=idx%>"/>
<input type="hidden" name="name" value="<%=name%>"/>
<table width="176" 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="3"></td>
</tr>
<tr>
<td width="3"></td>
<td><font color="#464646"><%=year %>斥 <%=month %>岿<%=day %>老 殿废等 龙巩</font></td>
<td width="3"></td>
</tr>
<!--备盒扼牢 矫累-->
<tr>
<td width="3"></td>
<td align="center">
<font color="#d5d1be" align="center">··························</font>
</td>
<td width="3"></td>
</tr>
<!--备盒扼牢 场-->
<!--龙巩郴侩 矫累-->
<tr>
<td width="3"></td>
<td>
<font color="#464646">龙巩郴侩:</font>
<font color="#9819e9"><%=text %></font>
</td>
<td width="3"></td>
</tr>
<!--龙巩郴侩 场-->
<tr>
<td colspan="3" height="3"></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">
<tr>
<td></td>
<td width="150" align="center"><font color="7c7c7c"><b>急琶等 墨靛</b></font></td>
<td></td>
</tr>
<tr>
<td colspan="3" height="4"></td>
</tr>
<tr>
<td></td>
<td align="center"><img src="<%=img_path%>images/soulmate/<%=cardIdx%>.png" width="50" height="68"></td>
<td></td>
</tr>
</table>
</td>
</tr>
<!--急琶墨靛 场-->
<!--咯归 矫累-->
<tr>
<td height="8"></td>
</tr>
<!--咯归 场-->
<!--墨靛狼固 郴侩 矫累-->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="3"></td>
<td>
<table width="170" bgcolor="#e8f2f2" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="3"></td>
<td height="19" align="center"><font color="#9819e9"><b><%=cardName%></b></font></td>
<td width="3"></td>
</tr>
<tr>
<td width="3"></td>
<td><font color="#464646"><%=explan%></font><br></td>
<td width="3"></td>
</tr>
<tr>
<td colspan="3" height="5"></td>
</tr>
</table>
</td>
<td width="3"></td>
</tr>
</table>
</td>
</tr>
<!--墨靛狼固 郴侩 场-->
<tr>
<td height="8"></td>
</tr>
<!--翠 累己 冠胶 矫累-->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="13" align="center" valign="top"><font color="#ecaaff"><b>≮</b></font></td>
<td><font color="#9819e9">罐篮 鸥肺痢 翠 郴侩 :</font></td>
<td width="5"></td>
</tr>
<tr>
<td colspan="3">
</td>
</tr>
<tr>
<td colspan="3" height="3">
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="4"></td>
<!--酒官鸥 矫累-->
<td width="54">
<table width="54" bgcolor="#e8fefe" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="3" height="3"></td>
</tr>
<tr>
<td width="3"></td>
<td valign="top"><img src="<%=ava_path%>display_thumb.jsp?mphone=<%=friendNum%>&gphone=<%=friendNum%>" width="48" height="54"></td>
<td width="5"></td>
</tr>
<tr>
<td colspan="3" height="3"></td>
</tr>
</table>
</td>
<!--酒官鸥 场-->
<!--郴侩 矫累-->
<td width="114">
<table width="114" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="2"></td>
<td>
<font color="#464646"><%=friendNickName%>丛<br>
<%=answer %><br></font>
</td>
</tr>
</table>
</td>
<!--郴侩 场-->
<td width="4"></td>
</tr>
</table>
</td>
</tr>
<!--text冠胶 矫累-->
<tr>
<td colspan="3">
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="5"></td>
<td height="16"><font color="#909090"><%=friendNickName%>丛俊霸 臂 巢败林扁</font></td>
<td width="5"></td>
</tr>
<tr>
<td width="5"></td>
<td height="16" align="right"><font color="#909090">(规疙废)</font></td>
<td width="5"></td>
</tr>
<tr>
<td colspan="3" height="3"></td>
</tr>
<tr>
<td width="5"></td>
<td align="center">
<input type="text" name="message" size="28" maxlength="80">
</td>
<td width="5"></td>
</tr>
</table>
</td>
</tr>
<!--text冠胶 场-->
</table>
</td>
</tr>
<!--翠 累己 冠胶 场-->
<tr>
<td height="3"></td>
</tr>
<!--滚瓢 矫累-->
<tr>
<td>
<table width="176" height="16" border="0" cellspacing="0" cellpadding="0">
<tr>
<td></td>
<td width="75" height="16" bgcolor="#c789ff" align="center"><a href="javascript:document.form1.submit();"><font color="#ffffff">规疙废臂殿废</font></a></td>
<td width="2"></td>
<td width="75" height="16" bgcolor="#c789ff" align="center"><a href="<%=url_path%>/soulmate/questionself.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>"><font color="#ffffff">倒酒啊扁</font></a></td>
<td></td>
</tr>
</table>
</td>
</tr>
<!--滚瓢 场-->
<!--咯归 矫累-->
<tr>
<td height="11"></td>
</tr>
<!--咯归 场-->
<!--窍窜 版肺钎矫 矫累-->
<%
String step1=url_path+"/main.jsp?mphone="+gphone+"&gphone="+gphone;//权
String step2=url_path+"mypage/my_confirm.jsp?mphone="+gphone+"&gphone="+gphone;
String step3=url_path+"/soulmate/Soulmate_zp.jsp?mphone="+gphone+"&gphone="+gphone;
%>
<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="<%=step1%>">权</a>><a href="<%=step2%>"><b><%=name%></b> 丛狼 迄乔</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="<%=step3%>">家匡皋捞飘</a>>鸥肺痢</td>
<td width="10" bgcolor="#BBC7C8"></td>
</tr>
</table>
</td>
</tr>
<!--窍窜 版肺钎矫 场-->
</table>
</form>
<!--窍窜 版肺钎矫 矫累-->
<%@ include file="../newbottom.jsp"%>
<!--窍窜 版肺钎矫 场-->
</body>
</html>
<%
}
catch (Exception e)
{
out.println(e);
}
finally
{
if(rs != null) try{rs.close();}catch(Exception se){}
if(pageset != null) try{pageset.close();}catch(Exception se){}
if(pstmt != null) try{pstmt.close();}catch(Exception es){}
if(stmt != null) try{stmt.close();}catch(Exception es){}
if(con != null) try{con.close();}catch(Exception es){}
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -