📄 tracedelete.jsp
字号:
<!--------------------------------------------------------------------------------------------------------------
*@橇肺鞘 昏力
*@Author : 弥眠岿 (2008-7-11)
--------------------------------------------------------------------------------------------------------------->
<%@ 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"%>
<%@ include file="../common_func.jsp"%>
<%@ include file="appConstants.jsp"%>
<%@ include file="formatUtil.jsp"%>
<%@ include file="../makeKOR.jsp"%>
<%
/*------------------------------------------------------------------------------------------------------
+ 扁夯 颇扼固磐
-------------------------------------------------------------------------------------------------------*/
String mphone= request.getParameter("mphone");
String gphone= request.getParameter("gphone");
String year = "";
if(request.getParameter("year")!=null){year=request.getParameter("year");};
String month = "";
if(request.getParameter("month")!=null){month=request.getParameter("month");};
String day = "";
if(request.getParameter("day")!=null){day=request.getParameter("day");};
String type="";
if(request.getParameter("type")!=null){type=request.getParameter("type");};
String yy = "";
if(request.getParameter("yy")!=null){yy=request.getParameter("yy");};
String mm = "";
if(request.getParameter("mm")!=null){mm=request.getParameter("mm");};
String dd = "";
if(request.getParameter("dd")!=null){dd=request.getParameter("dd");};
/*------------------------------------------------------------------------------------------------------
+ 傈开 函荐
-------------------------------------------------------------------------------------------------------*/
String nickname = "";
/*------------------------------------------------------------------------------------------------------
+ DB
-------------------------------------------------------------------------------------------------------*/
PreparedStatement pstmt = null;
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
String query1 = null;
try
{
/*------------------------------------------------------------------------------------------------
* DB 目池记
-------------------------------------------------------------------------------------------------*/
%><%@ include file="../getConnection.jsp"%><%@ include file="bgColor.jsp"%><%
/*------------------------------------------------------------------------------------------------
* 橇肺鞘 nickname
-------------------------------------------------------------------------------------------------*/
query1 = "SELECT name FROM gt_user_info WITH (READUNCOMMITTED) WHERE phonenum = ?";
pstmt = con.prepareStatement(query1);
pstmt.setString(1,gphone);
rs = pstmt.executeQuery();
if(rs.next())
{
nickname = rs.getString("name");
}
rs.close();
pstmt.close();
/*------------------------------------------------------------------------------------------------
* 橇肺鞘 delete
-------------------------------------------------------------------------------------------------*/
if(request.getParameter("flag")!=null&&request.getParameter("flag").equals("1"))
{
query1 ="DELETE FROM GT_NsProfile WHERE phonenum=? AND CONVERT(char(10),regdate,120)=CONVERT(char(10), '"+year+"-"+month+"-"+day+"',120)";
pstmt = con.prepareStatement(query1);
pstmt.setLong(1,getLong(mphone));
pstmt.executeUpdate();
pstmt.close();
response.sendRedirect("NewsMain.jsp?mphone="+mphone+"&gphone="+gphone);
}
%>
<html>
<head>
<title></title>
<link href="http://entaz.mugeta.com/client/mugeta_v2_test/web/user/mobile.css" rel="stylesheet" type="text/css">
</head>
<body>
<form name="deleteForm" action="TraceDelete.jsp" method="post" >
<table width="240" border="0" cellspacing="0" cellpadding="0">
<!-- 鸥捞撇 矫累 -->
<tr>
<td>
<input type="hidden" name="mphone" value="<%=mphone%>">
<input type="hidden" name="gphone" value="<%=gphone%>">
<input type="hidden" name="year" value="<%=year%>">
<input type="hidden" name="month" value="<%=month%>">
<input type="hidden" name="day" value="<%=day%>">
<input type="hidden" name="flag" value="1">
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr height="19">
<td width="8" bgcolor="<%=mainBgColor%>"></td>
<td bgcolor="<%=mainBgColor%>"><font color="#ffffff">舅覆芒</font></td>
</tr>
</table>
</td>
</tr>
<!-- 鸥捞撇 场 -->
<!-- 咯归 矫累 -->
<tr height="8">
<td></td>
</tr>
<!-- 咯归 场 -->
<!-- 冠胶 矫累 -->
<tr>
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr height="3">
<td colspan="3" bgcolor="#dae6e8"></td>
</tr>
<tr height="20">
<td bgcolor="#dae6e8" width="3"></td>
<td></td>
<td bgcolor="#dae6e8" width="3"></td>
</tr>
<tr>
<td bgcolor="#dae6e8" width="3"></td>
<td align="center">沥富 昏力窍矫摆嚼聪鳖?</td>
<td bgcolor="#dae6e8" width="3"></td>
</tr>
<tr height="20">
<td bgcolor="#dae6e8" width="3"></td>
<td></td>
<td bgcolor="#dae6e8" width="3"></td>
</tr>
<tr height="3">
<td colspan="3" bgcolor="#dae6e8"></td>
</tr>
</table>
</td>
</tr>
<!-- 冠胶 场 -->
<!-- 咯归 矫累 -->
<tr height="4">
<td></td>
</tr>
<!-- 咯归 场 -->
<!-- 滚瓢 矫累 -->
<tr>
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr height="17">
<td></td>
<td width="44" bgcolor="<%=mainBgColor%>" align="center" ><a href="javascript:deleteForm.submit();"><font color="#ffffff">犬牢</font></a></td>
<td width="2"></td>
<td width="44" bgcolor="<%=mainBgColor%>" align="center" ><a href="Trace.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&year=<%=year%>&month=<%=month%>&day=<%=day%>&yy=<%=yy%>&mm=<%=mm%>&dd=<%=dd%>&type=<%=type%>"><font color="#ffffff">秒家</font></a></td>
<td></td>
</tr>
</table>
</td>
</tr>
<!-- 滚瓢 场 -->
<!-- 咯归 矫累 -->
<tr height="143">
<td></td>
</tr>
<!-- 咯归 场 -->
<!--版肺钎矫 矫累-->
<tr>
<td>
<table width="240" border="0" cellspacing="0" cellpadding="0">
<tr height="19">
<td width="10" bgcolor="#BBC7C8"></td>
<td bgcolor="#DAE6E8"> <a href="<%=url_path%>/main.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>">权</a>><a href="<%=url_path%>/mypage/my_confirm.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>"><%=nickname%>丛狼 迄乔</a>><a href="<%=url_path%>/news/NewsMain.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>">春胶</a>>舅覆芒
</td>
<td width="10" bgcolor="#BBC7C8"></td>
</tr>
</table>
</td>
</tr>
<!--版肺钎矫 场-->
</table>
</form>
<!--窍窜 版肺钎矫 矫累-->
<%@ include file="../newbottom.jsp"%>
<!--窍窜 版肺钎矫 场-->
</body>
</html>
<%
}catch(Exception e)
{
System.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){}
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -