myfortune.jsp.svn-base

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

<!--------------------------------------------------------------------------------------------------------------
*@目敲霸烙 娄茫扁 
*@Author : 弥眠岿 (2008-6-05)
*@Images : 其捞瘤 救俊 甸绢啊绰 捞固瘤
	1) bg_01.png - 抛捞喉 弥惑窜 硅版捞固瘤(仟弗祸)
--------------------------------------------------------------------------------------------------------------->
<%@ page import='java.io.*,java.text.*,java.util.Date,java.util.Vector, javax.servlet.http.HttpSession,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"%>
<%

	/***********************************************************************
	
	@ Page Description
	 	霸烙 皋牢 其捞瘤
	
	@ Parameter

	***********************************************************************/

	/*------------------------------------------------------------------------------------------------------
	+	扁夯 颇扼固磐
	-------------------------------------------------------------------------------------------------------*/	
	String mphone= request.getParameter("mphone");

	String gphone= request.getParameter("gphone");
	
	String nickname = java.net.URLDecoder.decode(makeKOR(request.getParameter("nickname")));
	
	/*------------------------------------------------------------------------------------------------------
	+	傈开 函荐
	-------------------------------------------------------------------------------------------------------*/
	int star = 0;
	
	int sY = 0;
	
	int sM =0;
	
	int sD= 0;

    int year = 0;
    
    int month = 0;
    
    int day = 0;
	
	int sajuNum =0;
	
	String saju_text ="" ;
	
	int idx = 0;
	
	String keytext = "" ;
	

	/*------------------------------------------------------------------------------------------------------
	+	DB 包访 函荐
	-------------------------------------------------------------------------------------------------------*/
	PreparedStatement pstmt = null;
	
	Connection con = null;
	
	Statement stmt = null;
	
	ResultSet rs = null;
	
	String query1 = null;

	
	
	try
	{

	/*------------------------------------------------------------------------------------------------
	 *		DB 目池记
	 -------------------------------------------------------------------------------------------------*/
	%><%@ include file="../getConnection.jsp"%><%
	/*------------------------------------------------------------------------------------------------
	 *	坷疵狼 喊磊府 痢 
	 -------------------------------------------------------------------------------------------------*/
	 query1 = "select star,year,month,day from gt_user_info where phonenum = '"+mphone+"'";
	 
	 pstmt = con.prepareStatement(query1);
	 
	 rs= pstmt.executeQuery();

	 if(rs.next())
	 {	
	   star = rs.getInt("star");
	   
	   year = rs.getInt("year");
	   
	   month = rs.getInt("month");
	   
	   day = rs.getInt("day");
	 }

    Calendar calendar=Calendar.getInstance();
	 
	sY=calendar.get(Calendar.YEAR);
    
    sM=calendar.get(Calendar.MONTH)+1;
    
    sD=calendar.get(Calendar.DATE);

	rs.close();
	
	pstmt.close();

    sajuNum=((sD*13)+(sM*11)+(sY*9)+(star*7))%100;
    
    query1 = "select saju_text from gt_saju where saju_idx =?";
	
	 pstmt = con.prepareStatement(query1);
	 
	 pstmt.setInt(1,sajuNum);
	 
	 rs= pstmt.executeQuery();

	 if(rs.next())
	 {	
	   saju_text = rs.getString("saju_text");
	 }

	rs.close();
	
	pstmt.close();
	
	/*------------------------------------------------------------------------------------------------
	 *	坷疵狼 青款 虐况靛  ((蜡历狼 积斥滴磊府) + (蜡历狼 积岿) + (蜡历狼 积老) + (瘤陛 岿) + (瘤陛 老) ) x 6  / 95 = 唱赣瘤俊 秦寸窍绰 idx 免仿
	 -------------------------------------------------------------------------------------------------*/
	
	idx = ((year + month+day+sM+sD) * 6 )%95 ;

	query1 = "select text from gt_luck_keyword where idx = ?";
	
	pstmt = con.prepareStatement(query1);
	
	pstmt.setInt(1,idx);

	rs = pstmt.executeQuery();

	if(rs.next())
	{
	  keytext = rs.getString("text");
	}
	
	rs.close();
	
	pstmt.close();
	
	// QVGA HTML
	//
	if( isQVGA )
	{
		%><%@ include file="/html/MyFortune.jsp"%><%
	}
	// QCIF HTML
	//
	else
	{
		%><%@ include file="/html/qcif/MyFortune.jsp"%><%
	}
}catch(Exception e)
	{
		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){}
	}
%>