📄 lovematch_g.jsp
字号:
long guestPhone_db = 0;
String hostNickname_db = "";
String guestNickname_db = "";
if(Long.parseLong(mphone)>Long.parseLong(gphone)){
hostPhone_db = Long.parseLong(mphone) ;
guestPhone_db = Long.parseLong(gphone);
hostNickname_db = guestNickname;
guestNickname_db = hostNickname ;
}else{
hostPhone_db = Long.parseLong(gphone) ;
guestPhone_db = Long.parseLong(mphone);
hostNickname_db = hostNickname;
guestNickname_db = guestNickname ;
}
sql = "SELECT * FROM GT_LUCK_POINT_DATE WITH (READUNCOMMITTED) WHERE mphone = ? and gphone = ?";
pstmt = con.prepareStatement(sql);
pstmt.setLong(1,Long.parseLong(mphone));
pstmt.setLong(2,Long.parseLong(gphone));
rs=pstmt.executeQuery();
if(rs.next()){
ktv = false;
}else{
haveDateOne = false;
}
rs.close();
pstmt.close();
if(!ktv){
sql = "SELECT * FROM GT_LUCKY_LOVE WITH (READUNCOMMITTED) WHERE Guest_phone = ? and phonenum = ? and left(regdate,10) = left(getdate(),10)";
pstmt = con.prepareStatement(sql);
pstmt.setLong(1,Long.parseLong(mphone));
pstmt.setLong(2,Long.parseLong(gphone));
rs=pstmt.executeQuery();
if(rs.next()){
str_Flag = false;
}
rs.close();
pstmt.close();
}
if(haveDateOne){
sql = "SELECT * FROM GT_LUCK_POINT_DATE WITH (READUNCOMMITTED) WHERE mphone = ? and gphone = ? and left(love_point_date,10) > left(getdate()-2,10)";
pstmt = con.prepareStatement(sql);
pstmt.setLong(1,Long.parseLong(mphone));
pstmt.setLong(2,Long.parseLong(gphone));
rs=pstmt.executeQuery();
if(rs.next()){
haveDate = false;
}
rs.close();
pstmt.close();
if(haveDate){
sql = "UPDATE GT_LUCK_POINT_DATE SET love_point_date = getdate() WHERE gphone = ? and mphone = ?";
pstmt = con.prepareStatement(sql);
pstmt.setLong(1,Long.parseLong(gphone));
pstmt.setLong(2,Long.parseLong(mphone));
ret = pstmt.executeUpdate();
pstmt.close();
}
}else{
sql = "insert into gt_luck_point_date (mphone,gphone,love_point_date) values (?,?,getdate())";
pstmt = con.prepareStatement(sql);
pstmt.setLong(1,Long.parseLong(mphone));
pstmt.setLong(2,Long.parseLong(gphone));
ret = pstmt.executeUpdate();
pstmt.close();
}
if(haveDate){
sql = "select * from gt_lucky_attention_point WITH (READUNCOMMITTED) where phonenum=? and guest_phone=? ";
pstmt = con.prepareStatement(sql);
pstmt.setLong(1,Long.parseLong(gphone));
pstmt.setLong(2,Long.parseLong(mphone));
rs=pstmt.executeQuery();
if(rs.next()){
sql = "update gt_lucky_attention_point set attention_point=attention_point+1 where phonenum=? and guest_phone=?";
pstmt = con.prepareStatement(sql);
pstmt.setLong(1,Long.parseLong(gphone));
pstmt.setLong(2,Long.parseLong(mphone));
ret = pstmt.executeUpdate();
pstmt.close();
}else{
sql = "insert into gt_lucky_attention_point (phonenum,guest_phone,attention_point,attention_point_old,regdate) values (?,?,?,?,getdate())";
pstmt = con.prepareStatement(sql);
pstmt.setLong(1,Long.parseLong(gphone));
pstmt.setLong(2,Long.parseLong(mphone));
pstmt.setLong(3,1);
pstmt.setLong(4,0);
//pstmt.setString(5,riqi);
ret = pstmt.executeUpdate();
pstmt.close();
}
rs.close();
}
if(str_Flag){
sql="insert into gt_lucky_love (phonenum,guest_phone,nickname,guest_nickname,love_point,title,text,flag,nregdate,regdate)values (?,?,?,?,?,?,?,?,?,?)";
Date nowTime=new Date(System.currentTimeMillis());
SimpleDateFormat sDateFormat=new SimpleDateFormat("yyyyMMdd");
String todayTime=sDateFormat.format(nowTime);
int nngdate = Integer.parseInt(todayTime);
pstmt = con.prepareStatement(sql);
pstmt.setLong(1,hostPhone_db);
pstmt.setLong(2,guestPhone_db);
pstmt.setString(3,hostNickname_db);
pstmt.setString(4,guestNickname_db);
pstmt.setInt(5,lovePoint);
pstmt.setString(6,luckNum);
pstmt.setString(7,comment);
pstmt.setInt(8,0);
pstmt.setInt(9,nngdate);
pstmt.setString(10,riqi);
ret = pstmt.executeUpdate();
if(ret==-1){
return;
}
rs.close();
pstmt.close();
}
//sql="select * from GT_paper_recv where (phonenum = ? and phonenum_my = ?) or (phonenum = ? and phonenum_my = ?)";
//pstmt = con.prepareStatement(sql);
//pstmt.setLong(1, Long.parseLong(mphone));
//pstmt.setLong(2, Long.parseLong(gphone));
//pstmt.setLong(3, Long.parseLong(gphone));
//pstmt.setLong(4, Long.parseLong(mphone));
//rs = pstmt.executeQuery();
//if (rs.next()) {
// str_Flag = false;
//}
//rs.close();
//pstmt.close();
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<head>
<link href="http://entaz.mugeta.com/client/mugeta_v2_test/web/user/mobile.css" rel="stylesheet" type="text/css" />
<title>权> 公霸鸥 局沥 嘎眠扁</title>
</head>
<body>
<form name="form1" action="infolovematch_g.jsp" method="post">
<input type="hidden" name="mphone" value="<%=mphone%>" />
<input type="hidden" name="gphone" value="<%=gphone%>" />
<input type="hidden" name="lovePoint" value="<%=getLovePoint(lovePoint) %>" />
<input type="hidden" name="hostNickname" value="<%=hostNickname %>" />
<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>
<table width="240" bgcolor="#ecaaff" border="0" cellspacing="0"
cellpadding="0">
<tr>
<td colspan="3" height="3"></td>
</tr>
<tr>
<td width="3"></td>
<td>
<!--殿废等 龙巩 郴侩 矫累-->
<table width="234" 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="3"></td>
<td align="center">
<font color="#cccccc" size="3">········································</font>
</td>
<td width="3"></td>
</tr>
<!--备盒扼牢 场-->
<!--酒官鸥 矫累-->
<tr>
<td colspan="3">
<table width="234" border="0" cellspacing="0"
cellpadding="0">
<tr>
<td></td>
<td width="54">
<table width="54" bgcolor="#e8f2f2" 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=<%=mphone%>&gphone=<%=mphone%>" width="48" height="54" />
</td>
<td width="3"></td>
</tr>
<tr>
<td colspan="3" height="3"></td>
</tr>
</table>
</td>
<td width="5"></td>
<td width="54">
<table width="54" bgcolor="#e8f2f2" 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=<%=mphone%>&gphone=<%=gphone%>" width="48" height="54" />
</td>
<td width="3"></td>
</tr>
<tr>
<td colspan="3" height="3"></td>
</tr>
</table>
</td>
<td></td>
</tr>
</table>
</td>
</tr>
<!--酒官鸥 场-->
<tr>
<td colspan="3" height="5"></td>
</tr>
<!--郴侩 矫累-->
<tr>
<td colspan="3">
<table width="234" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="15"></td>
<td>
<font color="#464646">喊磊府 : <%=getStar(guestStar)%> / <%=getStar(hostStar)%> </font>
<br />
<font color="#464646">趋咀屈 : <%=getBlood(guestBlood)%>屈 / <%=getBlood(hostBlood)%>屈</font>
<br />
<font color="#464646">唱 捞 : <%=guestAge%>技 / <%=hostAge%>技</font>
</td>
<td width="15"></td>
</tr>
</table>
</td>
</tr>
<!--郴侩 场-->
<tr>
<td colspan="3" height="5"></td>
</tr>
<!--局沥档 乞啊 郴侩 矫累-->
<tr>
<td colspan="3">
<table width="234" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="5"></td>
<td colspan="3" height="3" bgcolor="#e8f2f2"></td>
<td width="5"></td>
</tr>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -