📄 taroforviewinfo_lhl.jsp.svn-base
字号:
<%@ page language="java" pageEncoding="EUC-KR"%>
<%@ page import="java.io.*,java.text.*,java.util.Date,java.util.Vector, java.sql.*, com.entaz.lib.db.*, com.entaz.relay.net.* "%>
<%@ include file="../imgpath.jsp"%>
<%@ include file="../common_func.jsp"%>
<%
Connection con = null;
PreparedStatement pstmt = null;
Statement stmt = null;
ResultSet rs = null;
ResultSet pageset = null;
String sqlStrTwo = "";
String mphone = request.getParameter("mphone");
String gphone = request.getParameter("gphone");
String picnum = request.getParameter("picnum");
String taroid = "0";
if(request.getParameter("taroid") != null){
taroid = request.getParameter("taroid");
}
String picid = "0";
if(request.getParameter("picid") != null){
picid = request.getParameter("picid");
}
//String mphone = "13366103"; //test db fang ke
//String gphone = "9900100081"; //test db zu ren
//String picnum = "first";
String tableGT_TARO_DB = "GT_TARO_DB";
String tableGT_USER_INFO = "GT_USER_INFO";
String tableGT_LUCKY_TARO = "GT_LUCKY_TARO";
String tableGT_LUCKY_TARO_COMMENT = "GT_LUCKY_TARO_COMMENT";
String username = "No name";
int taroId = 0;
int taroIdTwo = 0;
String cardName = "";
String explan = "";
boolean flagtrao = true;
try {
%>
<%@ include file="../getConnection.jsp"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=EUC-KR">
<title>10权 > Xxx丛狼 迄乔 > 家匡皋捞飘 > 鸥肺痢</title>
<link rel="stylesheet" href="../mobile.css" type="text/css"></link>
</head>
<body>
<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>
<%
String commentdate = "";
String commentquestion = "";
stmt = con.createStatement();
String sqlComment0 = "SELECT TOP 1 nregdate,text FROM " + tableGT_LUCKY_TARO + " WITH (READUNCOMMITTED) where idx = "+taroid;
rs = stmt.executeQuery(sqlComment0);
while(rs.next())
{
commentdate = rs.getString("nregdate");
commentquestion = rs.getString("text");
}
%>
<tr>
<td width="3"></td>
<td><font color="#464646"><%= getTime2(commentdate) %> 殿废等 龙巩</font></td>
<td width="3"></td>
</tr>
<!--龙巩郴侩 矫累-->
<tr>
<td width="3"></td>
<td><font color="#464646">龙巩郴侩 : </font><font color="#9819e9"><%= commentquestion %></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="7"></td>
</tr>
<%
String taro_idxQCM = "";
String SqlFlagTaro = "SELECT * FROM GT_TAROR_FLAG WITH (READUNCOMMITTED) WHERE mphone=? and gphone=? and title_idx=?";
pstmt = con.prepareStatement(SqlFlagTaro);
pstmt.setLong(1,Long.parseLong(mphone));
pstmt.setLong(2,Long.parseLong(gphone));
pstmt.setInt(3,Integer.parseInt(taroid));
rs = pstmt.executeQuery();
if(rs.next()){
flagtrao = false;
taro_idxQCM = rs.getString("taro_idx");
}
rs.close();
pstmt.close();
String sqlStr = "";
if(flagtrao){
sqlStr = "SELECT TOP 1 * FROM " + tableGT_TARO_DB + " WITH (READUNCOMMITTED) ORDER BY newid()";
}else{
sqlStr = "SELECT * FROM " + tableGT_TARO_DB + " WITH (READUNCOMMITTED) WHERE idx = "+taro_idxQCM;
}
String sqlName = "SELECT nickname FROM " + tableGT_USER_INFO + " WITH (READUNCOMMITTED) WHERE phonenum='" + gphone + "'";
//stmt = con.createStatement();
rs = stmt.executeQuery(sqlStr);
while(rs.next())
{
taroId = rs.getInt("idx");
cardName = rs.getString("cardname");
explan = rs.getString("explan");
}
rs = stmt.executeQuery(sqlName);
while(rs.next())
{
username = rs.getString("nickname");
}
rs.close();
//pstmt.close();
if(Integer.parseInt(picid) != 0){
taroId = Integer.parseInt(picid);
}
if(flagtrao){
String taroFalgSql = "INSERT INTO GT_TAROR_FLAG (mphone,gphone,taro_idx,picnum,title_idx,flag) VALUES(?,?,?,?,?,?)";
pstmt = con.prepareStatement(taroFalgSql);
pstmt.setLong(1,Long.parseLong(mphone));
pstmt.setLong(2,Long.parseLong(gphone));
pstmt.setInt(3,taroId);
pstmt.setString(4,picnum);
pstmt.setInt(5,Integer.parseInt(taroid));
pstmt.setInt(6,1);
pstmt.executeUpdate();
pstmt.close();
}
%>
<tr>
<td></td>
<td align="center">
<table width="150" border="0" cellspacing="0" cellpadding="0">
<tr>
<td></td>
<%
if(picnum.equals("first"))
{
%>
<td width="50" align="center" valign="middle"><img src="<%=img_path%>images/soulmate/<%=taroId%>.png" width="50" height="68"></td>
<td width="10"></td>
<td width="50" align="center" valign="middle"><img src="<%=img_path%>images/soulmate/0.png" width="50" height="68"></td>
<%
}
else
{
%>
<td width="50" align="center" valign="middle"><img src="<%=img_path%>images/soulmate/0.png" width="50" height="68"></td>
<td width="10"></td>
<td width="50" align="center" valign="middle"><img src="<%=img_path%>images/soulmate/<%=taroId%>.png" width="50" height="68"></td>
<%
}
%>
<td></td>
</tr>
</table>
</td>
<td></td>
</tr>
</table>
</td>
</tr>
<!--鸥肺墨靛 凯扁 冠胶 矫累-->
<!--咯归 矫累-->
<tr>
<td height="10"></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></td>
<td width="10"></td>
</tr>
<tr>
<td colspan="3" height="5"></td>
</tr>
</table>
</td>
<td width="3"></td>
</tr>
</table>
</td>
</tr>
<!--墨靛狼固 郴侩 场-->
<tr>
<td height="10"></td>
</tr>
<!--膏飘 矫累-->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="13" align="center" valign="top"><font color="#ecaaff">≮</font></td>
<td><font color="#616667">捞 墨靛肺 翠阑 林矫摆绢夸?</font><br>
<font color="#616667">酒丛 促弗 墨靛肺 促矫 茄锅 惶酒 焊矫摆绢夸? 促弗 墨靛肺 促矫 惶栏搁 官曹 扁雀绰 绝绢夸.</font></td>
<td width="5"></td>
</tr>
</table>
</td>
</tr>
<!--膏飘 场-->
<tr>
<td height="7"></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+"/soulmate/soulmate_g.jsp?mphone="+mphone+"&gphone="+gphone+"&picid="+taroId+"&picnum="+picnum;
%>
<!--滚瓢 矫累-->
<tr>
<td>
<table width="176" height="16" border="0" cellspacing="0" cellpadding="0">
<tr>
<td></td>
<td width="80" height="16" bgcolor="#c789ff" align="center"><a href="taroforanswer_lhl.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&taroID=<%=taroId%>&taroidda=<%=taroid%>&picnum=<%=picnum%>"><font color="#ffffff">捞吧肺窍扁</font></a></td>
<td width="2"></td>
<%
if(taroId > 22)
{
sqlStrTwo = "SELECT TOP 1 * FROM " + tableGT_TARO_DB + " WITH (READUNCOMMITTED) WHERE idx != "+taroId+" and idx != "+(taroId-22)+" ORDER BY newid()";
rs = stmt.executeQuery(sqlStrTwo);
while(rs.next())
{
taroIdTwo = rs.getInt("idx");
}
stmt.close();
rs.close();
con.close();
}
else
{
sqlStrTwo = "SELECT TOP 1 * FROM " + tableGT_TARO_DB + " WITH (READUNCOMMITTED) WHERE idx != "+taroId+" and idx != "+(taroId+22)+" ORDER BY newid()";
rs = stmt.executeQuery(sqlStrTwo);
while(rs.next())
{
taroIdTwo = rs.getInt("idx");
}
stmt.close();
rs.close();
con.close();
}
%>
<td width="90" height="16" bgcolor="#c789ff" align="center"><a href="taroforanswer_lhl.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&taroID=<%=taroIdTwo%>&taroidda=<%=taroid%>&picnum=<%=picnum%>"><font color="#ffffff">促弗墨靛肺窍扁</font></a></td>
<td></td>
</tr>
<tr>
<td colspan="5" height="2"></td>
</tr>
<tr>
<td></td>
<td colspan="3" width="80" height="16" bgcolor="#c789ff" align="center"><a href="<%=step3%>"><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="<%= step1 %>">权</a>><a href="<%= step2 %>"><%=username%>丛狼 迄乔</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>
<!--窍窜 版肺钎矫 矫累-->
<%@ include file="../newbottom.jsp"%>
<!--窍窜 版肺钎矫 场-->
</body>
</html>
<%
} catch(Exception e) {
e.printStackTrace();
}
%>
<%!
public String getTime1(String input)
{
//System.out.println("input.length" + input.length());
return new String(input.substring(2, 4)+"/"+input.substring(4, 6)+"/"+input.substring(6, 8));
}
public String getTime2(String input)
{
//System.out.println("input.length" + input.length());
return new String(input.substring(0, 4)+"斥"+input.substring(4, 6)+"岿"+input.substring(6, 8)+"老");
//return new String(input.substring(2, 4)+"/"+input.substring(4, 6)+"/"+input.substring(6, 8));
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -