fortunetip_love.jsp.svn-base

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

<!------------------------------------------------------------------
* @ 权> 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;
	}

    /*------------------------------------------------------------------------------------------------------
	+	傈开 函荐
	-------------------------------------------------------------------------------------------------------*/
    int user_year = 0;
    String user_name = "";
	int user_month = 0;
	int user_day = 0;
	int user_sex = 0;
	int opposite_user_sex = 0;
	int idx = 0;
	String name = "";
	float s_date = 0;
	float sex = 0;
	
	List list = new ArrayList();
	        
    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(); 	
		//System.out.println("user_sex========"+user_sex);
		
		if (user_sex==2){
		    opposite_user_sex = 0; 
			query1="select idx,name,s_date,sex from GT_LUCK_STARNAME where sex ="+opposite_user_sex;
			
			rs=stmt.executeQuery(query1);			        
					while(rs.next())
					{
						Map map = new HashMap();
						map.put("idx",new Integer(rs.getInt(1)));
						map.put("name",rs.getString(2));
						map.put("s_date",new Float(rs.getFloat(3)));
						map.put("sex",new Float(rs.getFloat(4)));
						list.add(map);
					}
					//System.out.println("list="+list);
					if(rs != null)  rs.close(); 
					
         }else{
            opposite_user_sex = 1 ; 
			query1="select idx,name,s_date,sex from GT_LUCK_STARNAME where sex ="+opposite_user_sex;
			rs=stmt.executeQuery(query1);
					while(rs.next())
					{
						Map map = new HashMap();
						map.put("idx",new Integer(rs.getInt(1)));
						map.put("name",rs.getString(2));
						map.put("s_date",new Float(rs.getFloat(3)));
						map.put("sex",new Float(rs.getFloat(4)));
						list.add(map);		
					}
					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_love.jsp"%><%
	}
	// QCIF HTML
	//
	else
	{
		%><%@ include file="/html/qcif/fortunetip_love.jsp"%><%
	}	
	
%>