questionadding.jsp

用手机浏览的一个类似于聊天室 博克 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="../makeKOR.jsp"%>

	
 <%
	String mphone = request.getParameter("mphone");
	String gphone = request.getParameter("gphone");
	//String text = request.getParameter("text");
	//String text = java.net.URLDecoder.decode(makeKOR(request.getParameter("text")));
	String name = request.getParameter("name");
	
	/*------------------------------------------------------------------------------------------------------
	+	DB 包访 函荐
	-------------------------------------------------------------------------------------------------------*/	
	
	Connection con = null;
	PreparedStatement pstmt=null;
	Statement stmt = null;
	ResultSet rs = null;
	ResultSet pageset = null;

	
	
	/*------------------------------------------------------------------------------------------------------
	+	傈开 函荐
	-------------------------------------------------------------------------------------------------------*/
	
		String query1 = null, sql = null;
		//String name = null;
	
	try
	{
	%><%@ include file="../getConnection.jsp"%><%
	String text = "null";
	if(!(request.getParameter("text")==null || request.getParameter("text").equals("")))
	{
		text = java.net.URLDecoder.decode(makeKOR(request.getParameter("text")));
	}
	
	/*------------------------------------------------------------------------------------------------
	 *		急琶篮  龙巩阑  眠啊    
	 -------------------------------------------------------------------------------------------------*/
	 if(text.equals("null")){
	 	response.sendRedirect("questionAddEorr.jsp?mphone="+mphone+"&gphone="+gphone+"&name="+name);
	 }else{
	query1 = "INSERT INTO GT_LUCKY_TARO "+
			 "( [phonenum], [comment], [text],[nregdate],[regdate]) "+
			 "VALUES("+ mphone +",0,"+" ? ,convert(char(8),getdate(),112),getdate())";
	pstmt = con.prepareStatement(query1);
	pstmt.setString(1,text);
	pstmt.executeUpdate();
	pstmt.close();
	response.sendRedirect("questionAdded.jsp?mphone="+mphone+"&gphone="+gphone);
 
}
	
	

	}

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 ) { } }
}
	
	%>