mysoulmate_server.jsp

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

<!--------------------------------------------------------------------------------------------------------------
*@霸烙皋牢
*@Author : cmquan(2008-06-05)


--------------------------------------------------------------------------------------------------------------->

<%@ page import='java.io.*,java.text.*,java.util.Date,java.util.Vector,java.text.SimpleDateFormat, 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 nickname= request.getParameter("nickname");
	String title= java.net.URLDecoder.decode(makeKOR(request.getParameter("title")));
	int toNextIdx = Integer.parseInt(request.getParameter("toNextIdx"));
	String guestAnswer = java.net.URLDecoder.decode(makeKOR(request.getParameter("ox")));
	
	
	
	String guestphone[] = new String[10000];
	int nflag = 0;
	
	
	
	String riqi = null;
	int intRiqi = 0;
	
	Date regdater = new Date();
	SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd");
	riqi = sf.format(regdater);

	intRiqi = Integer.parseInt(riqi.replace("-",""));
	
	String nextUrl = "MYQAmatchMate.jsp?mphone="+mphone+"&gphone="+gphone+"&name="+nickname+"&panduan=2";
	
	
	/*------------------------------------------------------------------------------------------------------
	+	DB 
	-------------------------------------------------------------------------------------------------------*/
	PreparedStatement pstmt = null;
	Connection con = null;
	Statement stmt = null;
	ResultSet rs = null;
	String sql = null;
	
	try
	{
	
	
	
	/*------------------------------------------------------------------------------------------------
	 *		DB 目池记
	 -------------------------------------------------------------------------------------------------*/
	%><%@ include file="../getConnection.jsp"%><%
	/*------------------------------------------------------------------------------------------------
	 *		All Quiz answerCount
	 -------------------------------------------------------------------------------------------------*/
	 
	 sql="insert into gt_lucky_quiz_mylog (quiz_idx,title,answer,phonenum,guest_phone,regdate,nregdate)values (?,?,?,?,?,getdate(),?)";
			
	 pstmt = con.prepareStatement(sql);	
	 pstmt.setInt(1,toNextIdx);	
	 pstmt.setString(2,title);		
	 pstmt.setString(3,guestAnswer);	
	 pstmt.setString(4,gphone);	
	 pstmt.setString(5,mphone);
	 pstmt.setInt(6,intRiqi);

	 pstmt.executeUpdate();
	 pstmt.close();
	 	 
	 sql = "select  distinct guest_phone from GT_LUCKY_REQUEST WITH (READUNCOMMITTED) where phonenum = ?";
     
     pstmt = con.prepareStatement(sql);
     
     pstmt.setLong(1,Long.parseLong(mphone));
     
     rs = pstmt.executeQuery();
     
     for(int i=0;rs.next();i++)
     {
       guestphone[i]=String.valueOf(rs.getInt("guest_phone"));
       
       nflag = i+1;
     }
     
     rs.close();
     
     pstmt.close();
	 
	 
	 
	 
	 
	 for(int j=0;j<nflag;j++){
	 	String txt = java.net.URLDecoder.decode(makeKOR(nickname))+"丛捞 巩力甫 歹 钱绢 初疽嚼聪促.";
	
		String sqlSendMsg = "exec GT_SendMessage2_beta ?,?,?,?,?";
		pstmt = con.prepareStatement(sqlSendMsg);
		pstmt.setString(1, mphone);
		pstmt.setString(2, "0"+guestphone[j]);
		pstmt.setString(3, txt);
		pstmt.setString(4, txt);
		pstmt.setInt(5, 0);
		pstmt.executeUpdate();
	 }
	 
	 
	 
	 
	 
	 
	 request.getRequestDispatcher(nextUrl).forward(request,response);
	 
	 }
	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 ) { } }
	}
%>