📄 myquizanswermodify.jsp
字号:
<%@ 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"%>
<%@ include file="appConstants.jsp"%>
<%@ include file="formatUtil.jsp"%>
<%@ include file="../makeKOR.jsp"%>
<style type="text/css">
A:hover {
COLOR: #000000; TEXT-DECORATION: underline
}
A:link {
COLOR: #000000; TEXT-DECORATION: underline
}
A:visited {
COLOR: #000000; TEXT-DECORATION: underline
}
</style>
<%!
public static String isNull(String str)
{
if (str == null)
return "";
else
return str;
}
%><%
/*------------------------------------------------------------------------------------------------------
+ 扁夯 颇扼固磐
-------------------------------------------------------------------------------------------------------*/
String mphone = request.getParameter("mphone");
String gphone = request.getParameter("gphone");
if(mphone == null){
mphone= "09900100081";
}
if(gphone == null){
gphone = mphone;
}
mphone = getStrPhone(getLong(mphone));
gphone = getStrPhone(getLong(gphone));
String idx = request.getParameter("idx");
String re_idx = request.getParameter("re_idx");
String name = java.net.URLDecoder.decode(makeKOR(request.getParameter("name")));
String click = request.getParameter("click");
String upFlag = request.getParameter("upFlag");
/*------------------------------------------------------------------------------------------------------
+ DB 包访 函荐
-------------------------------------------------------------------------------------------------------*/
Connection con = null;
PreparedStatement pstmt=null;
Statement stmt = null;
ResultSet rs = null;
ResultSet pageset = null;
/*------------------------------------------------------------------------------------------------------
+ 傈开 函荐
-------------------------------------------------------------------------------------------------------*/
String query1 = null, sql = null, query2 = null;
String re_text ="";
%>
<%
try
{
/*------------------------------------------------------------------------------------------------
* DB 目池记
-------------------------------------------------------------------------------------------------*/
%>
<%@ include file="../getConnection.jsp"%>
<%@ include file="bgColor.jsp"%>
<%
/*------------------------------------------------------------------------------------------------
* 急琶篮 措函 惑技 啊廉柯促
-------------------------------------------------------------------------------------------------*/
query1 = "SELECT text FROM GT_NsQuizRe WITH (READUNCOMMITTED) WHERE idx="+re_idx;
pstmt = con.prepareStatement(query1);
rs = pstmt.executeQuery();
if(rs.next()){
re_text = rs.getString(1);
}
rs.close();
pstmt.close();
/*-------------------------------------------------------------------------------------------------
* 惑包 措函 累技
--------------------------------------------------------------------------------------------------*/
if(click.equals("1")){
sql = "DELETE FROM GT_NsQuizRe WHERE idx ="+re_idx ;
sql = sql + " UPDATE GT_NsQuiz SET reCnt =reCnt-"+1+" WHERE idx="+idx +"AND reCnt >0";
pstmt = con.prepareStatement(sql);
pstmt.executeUpdate();
pstmt.close();
response.sendRedirect("myQuizView.jsp?mphone="+mphone+"&gphone="+gphone+"&idx="+idx+"&name="+name+"&upFlag="+upFlag);
}
%>
<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="form1" method="post" action="<%=url_path%>/news/myQuizAnswerModifing.jsp">
<input type="hidden" name="mphone" value="<%=mphone%>">
<input type="hidden" name="gphone" value="<%=gphone%>">
<input type="hidden" name="name" value="<%=name%>">
<input type="hidden" name="idx" value="<%=idx%>">
<input type="hidden" name="re_idx" value="<%=re_idx%>">
<table width="176" border="0" cellspacing="0" cellpadding="0">
<!-- 鸥捞撇 矫累 -->
<tr>
<td>
<table width="176" 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="4">
<td></td>
</tr>
<!-- 咯归 场 -->
<!-- 冠胶 矫累 -->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="8"></td>
<td>
<font color="#acacac" size="3">郴侩涝仿(800byte)</font>
</td>
<td width="8"></td>
</tr>
<tr>
<td width="8"></td>
<td>
<textarea name="re_text" width="160" height="100" cols="29" rows="20" defaultimemode="1" imemode="0" maxlength="800"><%=re_text%></textarea>
</td>
<td width="8"></td>
</tr>
</table>
</td>
</tr>
<!-- 冠胶 场 -->
<!--咯归 矫累-->
<tr>
<td height="4"></td>
</tr>
<!--咯归 场-->
<!-- 滚瓢 矫累 -->
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr height="16">
<td></td>
<td width="35" bgcolor="<%=mainBgColor%>" align="center" ><a href="javascript:form1.submit();"><font color="#ffffff">荐沥</font></a></td>
<td width="2"></td>
<td width="35" bgcolor="<%=mainBgColor%>" align="center" ><a href="<%=url_path%>/news/myQuizAnswerModify.jsp?mphone=<%=mphone%>&gphone=<%=gphone%>&idx=<%=idx%>&name=<%=name%>&re_idx=<%=re_idx%>&click=1"><font color="#ffffff">昏力</font></a></td>
<td width="2"></td>
<td width="35" bgcolor="<%=mainBgColor%>" align="center" ><a href="javascript:history.back();"><font color="#ffffff">秒家</font></a></td>
<td></td>
</tr>
</table>
</td>
</tr>
<!-- 滚瓢 场 -->
<!-- 咯归 矫累 -->
<tr height="12">
<td></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+"/news/NewsMain.jsp?mphone="+mphone+"&gphone="+gphone;
%>
<tr>
<td>
<table width="176" border="0" cellspacing="0" cellpadding="0">
<tr height="15">
<td width="8" bgcolor="#BBC7C8"></td>
<td bgcolor="#DAE6E8">
<a href="<%=step1%>">权</a>>
<a href="<%=step2%>"><%=name%>狼迄乔</a>>
<a href="<%=step3%>">春胶</a>>柠令殿废
</td>
<td width="8" 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(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 + -