answerregisteraction.jsp

用手机浏览的一个类似于聊天室 博克 homepage 等 对这方面有 兴趣的朋友 有所帮助的

<%@ 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 max_idx 			= 0;
	int idx 				= 0;
	String nickname 		= "";
	String redirectPage		= "";
	String redirectPage1	= "";
	String content			= "";
	String questions[] 		= new String[30];
	String answers[] 		= new String[30];
	
	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=" INSERT INTO GT_Ns30question (phonenum,nickname,reCnt,regdate,type,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)"+
	       " VALUES (?,?,0,getdate(),?,"+
	       " ?,?,?,?,?,?,?,?,?,?,"+
	       " ?,?,?,?,?,?,?,?,?,?,"+
	       " ?,?,?,?,?,?,?,?,?,?,"+
	       " ?,?,?,?,?,?,?,?,?,?,"+
	       " ?,?,?,?,?,?,?,?,?,?,"+
	       " ?,?,?,?,?,?,?,?,?,?)";

		pstmt = con.prepareStatement(query1);
		int index = 4;
		pstmt.setLong(1,Long.parseLong(mphone));		
		pstmt.setString(2,nickname);
		pstmt.setInt(3,type);
	
		for(int i=0;i<questions.length;i++)	{
			pstmt.setString(index,questions[i]);
			index++;
		}
		for(int j=0;j<answers.length;j++){
			pstmt.setString(index,answers[j]);
			index++;
		}
		ret = pstmt.executeUpdate();
        pstmt.close();       
        /*------------------------------------------------------------------------------------------------
		 *	款技屏.
		 -------------------------------------------------------------------------------------------------*/		 
		query1 = " SELECT MAX(idx) max_idx FROM GT_Ns30question WITH (READUNCOMMITTED) WHERE phonenum = CONVERT( bigint,'"+mphone+"')";
		pstmt = con.prepareStatement(query1);
		rs = pstmt.executeQuery(); 
		if(rs.next()){ 
			idx = rs.getInt("max_idx");
		}
		rs.close();	  
		redirectPage1="30q&a_I_Show.jsp?mphone="+mphone+"&gphone="+gphone+"&idx="+idx;
		out.println(redirectPage1);
	    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);
	}
	%>