<!------------------------------------------------------------------
* @ 權> Xxx叢狼 迄喬 > 家匡皋撈飄 > 款技屏
* @ Author : 林妨唱  ( 2008-06-05 )
* @ 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 user_year = 0;
	int user_month = 0;
	int user_day = 0;
	int user_sex = 0;
	List dream_list = new ArrayList();

	int idx = 0;
	String total_type = "";
	    
    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,year,month,day,sex from GT_user_Info where phonenum = '"+mphone+"'";

		rs=stmt.executeQuery(query1);

		if(rs.next())
		{
		    user_name = rs.getString("nickname");
			user_year=rs.getInt("year");			
			user_month = rs.getInt("month");
			user_day = rs.getInt("day");
			user_sex = rs.getInt("sex");	
		}
        
		if(rs != null)  rs.close(); 	

	query1="select idx,total_type from GT_LUCK_DREAM";	
	
	    rs=stmt.executeQuery(query1);
		
		while(rs.next())
		{
		Map map = new HashMap();
		map.put("idx",new Integer(rs.getInt(1)));
		map.put("total_type",rs.getString(2));
		dream_list.add(map);		
		}               
        if(rs != null)  rs.close(); 
        //System.out.print("dream_list========="+dream_list);
        
     /*------------------------------------------------------------------------------------------------
	 *	款技屏.
	 -------------------------------------------------------------------------------------------------*/
	 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_dream.jsp"%><%
	}
	// QCIF HTML
	//
	else
	{
		%><%@ include file="/html/qcif/fortunetip_dream.jsp"%><%
	}	
	
%>