fortunetip_born.jsp

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

<!------------------------------------------------------------------
* @ 权> Xxx丛狼 迄乔 > 家匡皋捞飘 > 款技屏
* @ Author : 林妨唱 ( 2008-06-06 )
* @ Images : 
--------------------------------------------------------------------->
<%@ page import='java.io.*,java.text.*,java.util.Date,java.util.*, java.sql.*, com.entaz.lib.db.*, com.entaz.relay.net.*' contentType='text/html;charset=euc-kr'%>
<%@ include file="../imgpath.jsp"%>
<%! 	 
	public static String isNull(String str) 
	{ 
		if (str == null) 
			return ""; 
		else 
			return str; 
	} 
%>
<%
	/*------------------------------------------------------------------------------------------------------
	+	扁夯 颇扼固磐
	-------------------------------------------------------------------------------------------------------*/
	String mphone= request.getParameter("mphone");
	//if(mphone == null){
	//	mphone= "13269404505";
	//}
	
	String gphone= request.getParameter("gphone");
	if(null == gphone){
		gphone = mphone;
	}
	
	
	
	
    /*------------------------------------------------------------------------------------------------------
	+	傈开 函荐
	-------------------------------------------------------------------------------------------------------*/
    String user_name = "";
    int now_month = 0;
    int now_day = 0;
    int now_month_day= 0;
    
    String detail = "";   
    
    String rgTitle[] = new String[3];
	String rgTableName[] = new String[3];
	int n=0;   
	/*------------------------------------------------------------------------------------------------------
	+	DB 包访 函荐
	-------------------------------------------------------------------------------------------------------*/
	PreparedStatement pstmt = null;
	Connection con = null;
	Statement stmt = null;
	ResultSet rs = null;
	String query1 = null;
    String ssql = null;
	/*------------------------------------------------------------------------------------------------------
	+	朝楼 包访	
	-------------------------------------------------------------------------------------------------------*/
	Timestamp di_date=null;
	Date today = new Date();
	SimpleDateFormat timeform;
	timeform = new SimpleDateFormat("MM/dd HH:mm");

	try
	{
	/*------------------------------------------------------------------------------------------------
	 *		DB 目池记
	 -------------------------------------------------------------------------------------------------*/
	%><%@ include file="../getConnection.jsp"%><%
	
	/**************************************
			胶鸥客 嘎苗焊绰 矾宏款技!
	***************************************/
       
    stmt = con.createStatement(); 
	
	query1="select nickname from GT_user_Info where phonenum = '"+mphone+"'";

		rs=stmt.executeQuery(query1);

		if(rs.next())
		{
		    user_name = rs.getString("nickname");				
		}
        
		if(rs != null)  rs.close(); 
		
		SimpleDateFormat   df   =   new   SimpleDateFormat("yyyy-MM-dd");   
		Date   now=   new   Date();   
		String   date=df.format(now);   
		int   yyyy,mm,dd   =   0;   
		
		now_month_day   =   Integer.parseInt(date.substring(5,7)+date.substring(8,date.length()));

        //System.out.println("now_month_day:"+now_month_day);
        
        query1="select detail from GT_LUCK_BORN where idx="+now_month_day;

		rs=stmt.executeQuery(query1);

		if(rs.next())
		{
		    detail = rs.getString("detail");	
		}
        
		if(rs != null)  rs.close(); 
		
		
	/*------------------------------------------------------------------------------------------------
	 *	款技屏.
	 -------------------------------------------------------------------------------------------------*/
	 query1 = "select top 2 title,tablest from gt_luck_title order by newid()";
	 
	 pstmt = con.prepareStatement(query1);
	 
	 rs = pstmt.executeQuery();
	 
	 for(int i=0;rs.next();i++)
	 {
	    rgTitle[i]=rs.getString("title");
	    rgTableName[i]=rs.getString("tablest");
	    n=i+1;
	 }
	 rs.close();	 
	 pstmt.close();       
		
	}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){}
	}
	// QVGA HTML
	//
	if( isQVGA )
	{
		%><%@ include file="/html/fortunetip_born.jsp"%><%
	}
	// QCIF HTML
	//
	else
	{
		%><%@ include file="/html/qcif/fortunetip_born.jsp"%><%
	}	
	
%>