messageadding.jsp.svn-base

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

<!--------------------------------------------------------------------------------------------------------------
*@霸烙皋牢
*@Author : zhou peng(2008-05-23)


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

<%@ 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 friendNum = request.getParameter("friendNum");
	String idx = request.getParameter("idx");
//	String message = request.getParameter("message");
	String friendNickName =	java.net.URLDecoder.decode(makeKOR(request.getParameter("friendNickName")));
	String name = request.getParameter("name");
	/*------------------------------------------------------------------------------------------------------
	+	DB 包访 函荐
	-------------------------------------------------------------------------------------------------------*/	
	
	Connection con = null;
	PreparedStatement pstmt=null;
	Statement stmt = null;
	ResultSet rs = null;
	ResultSet pageset = null;

	
	
	/*------------------------------------------------------------------------------------------------------
	+	傈开 函荐
	-------------------------------------------------------------------------------------------------------*/
	
		String query1 = null,query2 = null,query3 = null, sql = null;
		//String name = null;
		int id = 0;
		int Attention_point = 0;
		int Update_point = 0;
		
		
		
		boolean haveDate = true;
		boolean haveDateOne = true;
	
	try
	{
	%><%@ include file="../getConnection.jsp"%><%
	String message = "null";
	if(!(request.getParameter("message")==null||request.getParameter("message").equals(""))){
		message = java.net.URLDecoder.decode(makeKOR(request.getParameter("message")));
	}
	/*------------------------------------------------------------------------------------------------
	 *		
	 -------------------------------------------------------------------------------------------------*/
	
	query2 ="SELECT  idx  as  id  FROM GT_LUCKY_ATTENTION_POINT WITH (READUNCOMMITTED)"+
			" where phonenum = "+friendNum +"  and Guest_phone = " + mphone;
			
	pstmt = con.prepareStatement(query2);
	rs = pstmt.executeQuery();
	if(rs.next()){
		id = rs.getInt(1);
	}	
	
	if(id != 0){
	query3 = "SELECT  Attention_point WITH (READUNCOMMITTED) FROM GT_LUCKY_ATTENTION_POINT "+
			 "  where idx = "+ id;	
	pstmt = con.prepareStatement(query3);
	rs = pstmt.executeQuery();
	if(rs.next()){
		Attention_point = rs.getInt(1);
	}
	
	}	
			
	/*------------------------------------------------------------------------------------------------
	 *		急琶篮  龙巩阑  眠啊    
	 -------------------------------------------------------------------------------------------------*/
	 
	 sql = "SELECT * FROM GT_LUCK_POINT_DATE WITH (READUNCOMMITTED) WHERE mphone = ? and gphone = ?";
	pstmt = con.prepareStatement(sql);
	pstmt.setLong(1,Long.parseLong(mphone));
	pstmt.setLong(2,Long.parseLong(gphone));
	rs=pstmt.executeQuery();
	if(rs.next()){
		
	}else{
		haveDateOne = false;
	}
	rs.close();
	pstmt.close();
	
	
	if(haveDateOne){
		sql = "SELECT * FROM GT_LUCK_POINT_DATE WITH (READUNCOMMITTED) WHERE mphone = ? and gphone = ? and left(access_point_date,10) > left(getdate()-2,10)";
		pstmt = con.prepareStatement(sql);
		pstmt.setLong(1,Long.parseLong(mphone));
		pstmt.setLong(2,Long.parseLong(gphone));
		rs=pstmt.executeQuery();
		if(rs.next()){
			haveDate = false;
		}
		rs.close();
		pstmt.close();
		
		
		if(haveDate){
			sql = "UPDATE GT_LUCK_POINT_DATE SET access_point_date = getdate() WHERE gphone = ? and mphone = ?";
			pstmt = con.prepareStatement(sql);
			pstmt.setLong(1,Long.parseLong(gphone));
			pstmt.setLong(2,Long.parseLong(mphone));
			pstmt.executeUpdate();
			pstmt.close();
		}
	}else{
		sql = "insert into gt_luck_point_date (mphone,gphone,access_point_date) values (?,?,getdate())";
		pstmt = con.prepareStatement(sql);
		pstmt.setLong(1,Long.parseLong(mphone));
		pstmt.setLong(2,Long.parseLong(gphone));
		pstmt.executeUpdate();
		pstmt.close();
	}
	
	
	
	
	 
	 
	 if(id == 0){
	 
		 query1 ="INSERT INTO GT_guestbook "+
			    "( phonenum, nickname, guestbook_face,guestbook_date, "+
				" guestbook_text, guest_phone, guest_title, read_flag,lastdate,phonenum2) "+
				" VALUES("+gphone+",'"+friendNickName+"',2,getdate(),?,"+mphone+",'',0,"+
				"getdate(),"+friendNum+" )";
		if(haveDate){
			query1 = query1 +"INSERT INTO GT_LUCKY_ATTENTION_POINT  "+
					 "(phonenum, Guest_phone, Attention_point, Attention_point_old)"+
					 " VALUES("+gphone+","+mphone+",2,0)";
		}		
		
	}else{
		Update_point = Attention_point + 2;
		 query1 ="INSERT INTO GT_guestbook "+
			    "( phonenum, nickname, guestbook_face,guestbook_date, "+
				" guestbook_text, guest_phone, guest_title, read_flag,lastdate,phonenum2) "+
				" VALUES("+friendNum+",'"+friendNickName+"',2,getdate(),?,"+mphone+",'',0,"+
				"getdate() ,"+friendNum+")";	
		if(haveDate){		
			query1 = query1 +" UPDATE  GT_LUCKY_ATTENTION_POINT  " +
					 " SET  Attention_point= "+ Update_point+", Attention_point_old="+Attention_point+", regdate= getdate()"+
					 " WHERE idx =" + id;		
		}
	}		
		pstmt = con.prepareStatement(query1);
		pstmt.setString(1,message);
		pstmt.executeUpdate();
		pstmt.close();
	if(message.equals("null")){
		response.sendRedirect("messageWarn.jsp?mphone="+gphone+"&gphone="+gphone+"&name="+name);
	}else{
		response.sendRedirect("../mypage/my_confirm.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 ) { } }
}
	
	%>