📄 answerupdateaction.jsp
字号:
<!-------------------------------------------------------------
* @ name: answerUpdateAction.jsp
* @ Author : linaZhou
* @ date :2008-06-25
-------------------------------------------------------------->
<%@ 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="formatUtil.jsp"%>
<%@ include file="../makeKOR.jsp"%>
<%!
public static String isNull(String str){
if (str == null)
return "";
else
return str;
}
public String getStrQuestions(String questions){
int questionsLength = 0;
String questionsLast = "";
if(questions==null||questions.equalsIgnoreCase("")){
questions="";
}else{
questionsLength = questions.length();
questionsLast = questions.substring(questions.length()-1,questions.length());
if (questionsLast.equals(":")){
questions = questions;
}else{
questions = questions + ":";
}
}
return questions;
}
public String getStrAnswers(String answers){
int answersLength = 0;
if(answers==null||answers.equalsIgnoreCase("")){
answers="";
}else{
answers = answers;
}
return answers;
}
%>
<%
/*------------------------------------------------------------------------------------------------------
+ 扁夯 颇扼固磐
-------------------------------------------------------------------------------------------------------*/
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));
/*------------------------------------------------------------------------------------------------------
+ 傈开 函荐
-------------------------------------------------------------------------------------------------------*/
int type = 0;
int idx = 0;
int max_idx = 0;
String nickname = "";
String redirectPage = "";
String redirectPage1 = "";
String content = "";
String questions[] = new String[30];
String answers[] = new String[30];
idx = Integer.parseInt(request.getParameter("idx"));
type = Integer.parseInt(request.getParameter("type"));
nickname = java.net.URLDecoder.decode(makeKOR(request.getParameter("nickname")));
questions[0] = java.net.URLDecoder.decode(makeKOR(getStrQuestions(request.getParameter("question01"))));
questions[1] = java.net.URLDecoder.decode(makeKOR(getStrQuestions(request.getParameter("question02"))));
questions[2] = java.net.URLDecoder.decode(makeKOR(getStrQuestions(request.getParameter("question03"))));
questions[3] = java.net.URLDecoder.decode(makeKOR(getStrQuestions(request.getParameter("question04"))));
questions[4] = java.net.URLDecoder.decode(makeKOR(getStrQuestions(request.getParameter("question05"))));
questions[5] = java.net.URLDecoder.decode(makeKOR(getStrQuestions(request.getParameter("question06"))));
questions[6] = java.net.URLDecoder.decode(makeKOR(getStrQuestions(request.getParameter("question07"))));
questions[7] = java.net.URLDecoder.decode(makeKOR(getStrQuestions(request.getParameter("question08"))));
questions[8] = java.net.URLDecoder.decode(makeKOR(getStrQuestions(request.getParameter("question09"))));
questions[9] = java.net.URLDecoder.decode(makeKOR(getStrQuestions(request.getParameter("question10"))));
questions[10] = java.net.URLDecoder.decode(makeKOR(getStrQuestions(request.getParameter("question11"))));
questions[11] = java.net.URLDecoder.decode(makeKOR(getStrQuestions(request.getParameter("question12"))));
questions[12] = java.net.URLDecoder.decode(makeKOR(getStrQuestions(request.getParameter("question13"))));
questions[13] = java.net.URLDecoder.decode(makeKOR(getStrQuestions(request.getParameter("question14"))));
questions[14] = java.net.URLDecoder.decode(makeKOR(getStrQuestions(request.getParameter("question15"))));
questions[15] = java.net.URLDecoder.decode(makeKOR(getStrQuestions(request.getParameter("question16"))));
questions[16] = java.net.URLDecoder.decode(makeKOR(getStrQuestions(request.getParameter("question17"))));
questions[17] = java.net.URLDecoder.decode(makeKOR(getStrQuestions(request.getParameter("question18"))));
questions[18] = java.net.URLDecoder.decode(makeKOR(getStrQuestions(request.getParameter("question19"))));
questions[19] = java.net.URLDecoder.decode(makeKOR(getStrQuestions(request.getParameter("question20"))));
questions[20] = java.net.URLDecoder.decode(makeKOR(getStrQuestions(request.getParameter("question21"))));
questions[21] = java.net.URLDecoder.decode(makeKOR(getStrQuestions(request.getParameter("question22"))));
questions[22] = java.net.URLDecoder.decode(makeKOR(getStrQuestions(request.getParameter("question23"))));
questions[23] = java.net.URLDecoder.decode(makeKOR(getStrQuestions(request.getParameter("question24"))));
questions[24] = java.net.URLDecoder.decode(makeKOR(getStrQuestions(request.getParameter("question25"))));
questions[25] = java.net.URLDecoder.decode(makeKOR(getStrQuestions(request.getParameter("question26"))));
questions[26] = java.net.URLDecoder.decode(makeKOR(getStrQuestions(request.getParameter("question27"))));
questions[27] = java.net.URLDecoder.decode(makeKOR(getStrQuestions(request.getParameter("question28"))));
questions[28] = java.net.URLDecoder.decode(makeKOR(getStrQuestions(request.getParameter("question29"))));
questions[29] = java.net.URLDecoder.decode(makeKOR(getStrQuestions(request.getParameter("question30"))));
answers[0] = java.net.URLDecoder.decode(getStrAnswers(makeKOR(request.getParameter("answer01"))));
answers[1] = java.net.URLDecoder.decode(getStrAnswers(makeKOR(request.getParameter("answer02"))));
answers[2] = java.net.URLDecoder.decode(getStrAnswers(makeKOR(request.getParameter("answer03"))));
answers[3] = java.net.URLDecoder.decode(getStrAnswers(makeKOR(request.getParameter("answer04"))));
answers[4] = java.net.URLDecoder.decode(getStrAnswers(makeKOR(request.getParameter("answer05"))));
answers[5] = java.net.URLDecoder.decode(getStrAnswers(makeKOR(request.getParameter("answer06"))));
answers[6] = java.net.URLDecoder.decode(getStrAnswers(makeKOR(request.getParameter("answer07"))));
answers[7] = java.net.URLDecoder.decode(getStrAnswers(makeKOR(request.getParameter("answer08"))));
answers[8] = java.net.URLDecoder.decode(getStrAnswers(makeKOR(request.getParameter("answer09"))));
answers[9] = java.net.URLDecoder.decode(getStrAnswers(makeKOR(request.getParameter("answer10"))));
answers[10] = java.net.URLDecoder.decode(getStrAnswers(makeKOR(request.getParameter("answer11"))));
answers[11] = java.net.URLDecoder.decode(getStrAnswers(makeKOR(request.getParameter("answer12"))));
answers[12] = java.net.URLDecoder.decode(getStrAnswers(makeKOR(request.getParameter("answer13"))));
answers[13] = java.net.URLDecoder.decode(getStrAnswers(makeKOR(request.getParameter("answer14"))));
answers[14] = java.net.URLDecoder.decode(getStrAnswers(makeKOR(request.getParameter("answer15"))));
answers[15] = java.net.URLDecoder.decode(getStrAnswers(makeKOR(request.getParameter("answer16"))));
answers[16] = java.net.URLDecoder.decode(getStrAnswers(makeKOR(request.getParameter("answer17"))));
answers[17] = java.net.URLDecoder.decode(getStrAnswers(makeKOR(request.getParameter("answer18"))));
answers[18] = java.net.URLDecoder.decode(getStrAnswers(makeKOR(request.getParameter("answer19"))));
answers[19] = java.net.URLDecoder.decode(getStrAnswers(makeKOR(request.getParameter("answer20"))));
answers[20] = java.net.URLDecoder.decode(getStrAnswers(makeKOR(request.getParameter("answer21"))));
answers[21] = java.net.URLDecoder.decode(getStrAnswers(makeKOR(request.getParameter("answer22"))));
answers[22] = java.net.URLDecoder.decode(getStrAnswers(makeKOR(request.getParameter("answer23"))));
answers[23] = java.net.URLDecoder.decode(getStrAnswers(makeKOR(request.getParameter("answer24"))));
answers[24] = java.net.URLDecoder.decode(getStrAnswers(makeKOR(request.getParameter("answer25"))));
answers[25] = java.net.URLDecoder.decode(getStrAnswers(makeKOR(request.getParameter("answer26"))));
answers[26] = java.net.URLDecoder.decode(getStrAnswers(makeKOR(request.getParameter("answer27"))));
answers[27] = java.net.URLDecoder.decode(getStrAnswers(makeKOR(request.getParameter("answer28"))));
answers[28] = java.net.URLDecoder.decode(getStrAnswers(makeKOR(request.getParameter("answer29"))));
answers[29] = java.net.URLDecoder.decode(getStrAnswers(makeKOR(request.getParameter("answer30"))));
StringBuffer bufferQ = new StringBuffer();
for(int k=0;k<questions.length;k++){
bufferQ.append(questions[k]);
}
String ifNullQ = bufferQ.toString();
StringBuffer bufferA = new StringBuffer();
for(int i=0;i<answers.length;i++){
bufferA.append(answers[i]);
}
String ifNullA = bufferA.toString();
if(ifNullA.trim().equals("")&&!ifNullQ.trim().equals("")){
content = "Problems can not all be empty!!!";
redirectPage="answerAddError.jsp";
}else if(!ifNullA.trim().equals("")&&ifNullQ.trim().equals("")){
content = "The answer can not all be empty!!!";
redirectPage="answerAddError.jsp";
}else if(ifNullA.trim().equals("")&&ifNullQ.trim().equals(""))
content = "Questions and answers can not all be empty!!!";
redirectPage="answerAddError.jsp";
if(type == 1){
for(int i=0;i<questions.length;i++){
if(questions[i]!=null && !questions[i].trim().equals("") && answers[i].trim().equals("")){
content = "Questions and answers do not match!!!";
redirectPage="answerAddError.jsp";
}else if(answers[i]!=null && questions[i].trim().equals("") && !answers[i].trim().equals("")){
content = "Questions and answers do not match!!!";
redirectPage="answerAddError.jsp";
}
}
}
if(content != null && !content.trim().equals("") && content.length()>2 ){
response.sendRedirect(redirectPage+"?mphone="+mphone+"&gphone="+gphone+"&content="+content);
}else{
/*------------------------------------------------------------------------------------------------------
+ DB 包访 函荐
-------------------------------------------------------------------------------------------------------*/
PreparedStatement pstmt = null;
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
String query1 = null;
String sql = null;
int ret = -1;
/*------------------------------------------------------------------------------------------------------
+ 朝楼 包访
-------------------------------------------------------------------------------------------------------*/
Timestamp di_date = null;
Date today = new Date();
SimpleDateFormat timeform;
timeform = new SimpleDateFormat("MM/dd HH:mm");
try
{
/*------------------------------------------------------------------------------------------------
* DB 目池记
-------------------------------------------------------------------------------------------------*/
%>
<%@ include file="../getConnection.jsp"%>
<%
/**************************************
胶鸥客 嘎苗焊绰 矾宏款技!
***************************************/
stmt = con.createStatement();
query1=" UPDATE GT_Ns30question SET question1=?,question2=?,question3=?,question4=?,question5=?,"+
" question6=?,question7=?,question8=?,question9=?,question10=?,question11=?,question12=?,"+
" question13=?,question14=?,question15=?,question16=?,question17=?,question18=?,question19=?,"+
" question20=?,question21=?,question22=?,question23=?,question24=?,question25=?,question26=?,"+
" question27=?,question28=?,question29=?,question30=?,"+
" anser1=?,anser2=?,anser3=?,anser4=?,anser5=?,anser6=?,anser7=?,anser8=?,anser9=?,anser10=?,"+
" anser11=?,anser12=?,anser13=?,anser14=?,anser15=?,anser16=?,anser17=?,anser18=?,anser19=?,"+
" anser20=?,anser21=?,anser22=?,anser23=?,anser24=?,anser25=?,anser26=?,anser27=?,anser28=?,"+
" anser29=?,anser30=?"+
" WHERE idx = "+idx;
pstmt = con.prepareStatement(query1);
int index = 1;
for(int i=0;i<30;i++){
pstmt.setString(index,questions[i]);
index++;
}
for(int j=0;j<30;j++){
pstmt.setString(index,answers[j]);
index++;
}
ret = pstmt.executeUpdate();
if(ret==-1){
return;
}else{
redirectPage1="30q&a_I_Show.jsp?mphone="+mphone+"&gphone="+gphone+"&idx="+idx;
}
pstmt.close();
}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){}
}
response.sendRedirect(redirectPage1);
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -