myquizadding.jsp.svn-base

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

<%@ 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="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 String getTime(){
	  Calendar now=Calendar.getInstance();
	  String time=now.get(Calendar.YEAR)+"-"+
	   (now.get(Calendar.MONTH)+1)+"-"+
	   now.get(Calendar.DAY_OF_MONTH)+" "+
	   now.get(Calendar.HOUR_OF_DAY)+":"+
	   now.get(Calendar.MINUTE)+":"+
	   now.get(Calendar.SECOND);
	  return time;
	 }
  %>
 <%
	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 name =  java.net.URLDecoder.decode(makeKOR(request.getParameter("name")));
	String text = java.net.URLDecoder.decode(makeKOR(request.getParameter("text")));
	String title =java.net.URLDecoder.decode(makeKOR(request.getParameter("title")));
	String kind =request.getParameter("kind");
	/*------------------------------------------------------------------------------------------------------
	+	DB 包访 函荐
	-------------------------------------------------------------------------------------------------------*/	
	
	Connection con = null;
	PreparedStatement pstmt=null;
	Statement stmt = null;
	ResultSet rs = null;
	ResultSet pageset = null;
	/*------------------------------------------------------------------------------------------------------
	+	傈开 函荐
	-------------------------------------------------------------------------------------------------------*/
	
	String query1 = null, sql = null;
	int idx = 0;
		
	try
	{
	%>
	<%@ include file="../getConnection.jsp"%>
	<%
	if (kind .equals("0")||text.getBytes().length>800||title.getBytes().length>60||text.trim().length() == 0||title.trim().length() == 0){
	response.sendRedirect("myQuizAddError.jsp?mphone="+mphone+"&gphone="+gphone+"&name="+name);
	}else{
	/*-------------------------------------------------------------------------------------------------
	 *      货 柠令甫  涝仿 
	 --------------------------------------------------------------------------------------------------*/
	sql = "INSERT INTO GT_NsQuiz (phonenum,nickname,kind,title,text,reCnt,seCnt,takeIdx,regdate)" +
	 	   " VALUES  ("+gphone + ",?,?,?,?,0,0,0,?)"	;
	pstmt = con.prepareStatement(sql);
	pstmt.setString(1,name);
	pstmt.setString(2,kind);
	pstmt.setString(3,title);
	pstmt.setString(4,text);
	pstmt.setString(5,getTime());
	pstmt.executeUpdate();
	pstmt.close();
	/*-------------------------------------------------------------------------------------------------
	 *    货肺款  柠令狼  idx 炼雀 
	 --------------------------------------------------------------------------------------------------*/
	 query1 = "SELECT TOP 1 idx "+
			  " FROM GT_NsQuiz WITH (READUNCOMMITTED) "+
			  " WHERE phonenum = " + gphone + 
			  " ORDER BY regdate DESC" ;
	 pstmt = con.prepareStatement(query1);
	 rs = pstmt.executeQuery();
	 if(rs.next()){
		idx = rs.getInt(1);
	 }	
	response.sendRedirect("myQuizView.jsp?mphone="+mphone+"&gphone="+gphone+"&idx="+idx+"&name="+name+"&upFlag=0");
		}
	}
catch(Exception e)
{
	throw e;
}
finally
{ 
	if ( rs != null ) { try { rs.close(); } catch ( Exception e ) { } }
	if ( stmt != null ) { try { stmt.close(); } catch ( Exception e ) { } }
	if ( con != null ) { try { con.close(); } catch ( Exception e ) { } }
}
%>