main.jsp.svn-base

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

<%@ page import="java.lang.*,java.io.*, java.net.*, java.awt.*, java.util.Vector, javax.imageio.*,  java.sql.*, com.entaz.lib.db.*" contentType="text/html;charset=euc-kr"%>
<%@ include file="../imgpath.jsp"%>
<%@ include file="../definePath.jsp"%>
<%@ include file="../makeKOR.jsp"%>
<%@ include file="../common_func.jsp"%>
<%@ include file="define.jsp"%>

<%
   response.setHeader("cache-control","no-cache");
   response.setHeader("expires","0");
   response.setHeader("pragma","no-cache");
%><%
	/**
	 *	酒捞袍讥 皋牢
	 *
	 *	@ version			:	1.0.0
	 *	@ author			:	realbeast ( [e-mail] )
	 *	@ last modified	:	2008-03-19
	 */
	/*------------------------------------------------------------------------------------------------------
	+		扁夯 颇扼固磐
	-------------------------------------------------------------------------------------------------------*/
	String		mphone				=	request.getParameter("mphone");
	String		gphone				=	request.getParameter("gphone");
	String		szPageParam		=	request.getParameter("pageNUM");
	
	String		szQuery				=	null;


	/**
	* this is only for test code
	*/
	
	if(mphone==null){
		mphone="0";
	}
	
	/*********************************end test code***/

	long			lMphone			=	Long.parseLong(mphone);


	/*------------------------------------------------------------------------------------------------
	 *		酒捞袍 沥焊 函荐
	 -------------------------------------------------------------------------------------------------*/
	int				nItemMax						=		3;
	int				nItemCount					=		0;
	String[]		aszItemName					=		null;
	int[]			anItemIdx						=		null;
	int[]			anItemPrice					=		null;
	int[]			anItemSex						=		null;

	aszItemName									=		new String[nItemMax];
	anItemIdx										=		new int[nItemMax];
	anItemPrice									=		new int[nItemMax];
	anItemSex										=		new int[nItemMax];
	
	/*------------------------------------------------------------------------------------------------
	 *		牢扁炉, 能抛胶飘  内叼匙捞磐
	 -------------------------------------------------------------------------------------------------*/
	int				nBoardCount		=	0;
	int				nArrSize			=	4;
	String[]		aszTitle				=	new String[nArrSize];
	String[]		aszURL				=	new String[nArrSize];
	String[]		aszNickName		=	new String[nArrSize];
	String[]		aszSubject			=	new String[nArrSize];
	String[]		aszPhoneNum	=	new String[nArrSize];
	String[]		aRegDate			=	new String[nArrSize];
	boolean[]	isMineRe			=	new boolean[nArrSize];
	int	[]			anIdx					=	new int[nArrSize];
	int	[]			anPurchase		=	new int[nArrSize];
	int	[]			anAge				=	new int[nArrSize];
	int	[]			anHit					=	new int[nArrSize];
	int	[]			anReplyCount		=	new int[nArrSize];
	int	[]			anPoint				=	new int[nArrSize];


	Connection					con		= null;
	PreparedStatement		pstmt	= null;
	Statement					stmt		= null;
	ResultSet					rs			= null;

	try
	{
	
	/*------------------------------------------------------------------------------------------------
	 *		DB 目池记
	 -------------------------------------------------------------------------------------------------*/
	%>
	<%@ include file="../getConnection.jsp"%>
	<%
	

	/*------------------------------------------------------------------------------------------------
	 *		牢扁 酒捞袍 啊廉坷扁
	 -------------------------------------------------------------------------------------------------*/
	szQuery = "SELECT TOP "+nItemMax+" item_idx, item_price, item_name, item_sex FROM GT_item_step2 WHERE item_class != 5 AND item_flag = 1 ORDER BY item_hit,item_idx DESC";
	pstmt = con.prepareStatement(szQuery);
	rs = pstmt.executeQuery();
	while( rs.next() )
	{
		aszItemName[nItemCount]		=		rs.getString("item_name");
		anItemIdx[nItemCount]			=		rs.getInt("item_idx");
		anItemPrice[nItemCount]		=		rs.getInt("item_price");
		anItemSex[nItemCount]			=		rs.getInt("item_sex");
		
		nItemCount++;
	}
	rs.close();
	pstmt.close();
	

	/*------------------------------------------------------------------------------------------------
	 *		牢扁炉 葛官鸥
	 -------------------------------------------------------------------------------------------------*/
	 aszTitle[nBoardCount]					=		"牢扁炉 葛官鸥";
	aszURL[nBoardCount]						=		URL_ITEMSHOP_CONTEST + "&orderBy=hit";

	szQuery = "SELECT TOP 1 B. *,((Year(getdate())+1)- age) as Ages FROM GT_MovataContest_TOP A INNER JOIN GT_MovataContest B ON A.refIdx = B.idx ORDER BY newid()";
	pstmt = con.prepareStatement(szQuery);
	rs = pstmt.executeQuery();
	if( rs.next() )
	{	
		anIdx[nBoardCount]					=		rs.getInt("idx");
		aszNickName[nBoardCount]			=		rs.getString("nickname");
		anAge[nBoardCount]					=		rs.getInt("Ages");
		aszSubject	[nBoardCount]			=		rs.getString("title");
		aszPhoneNum[nBoardCount]		=		rs.getString("phonenum");
		anPoint[nBoardCount]					=		rs.getInt("point");
		anPurchase[nBoardCount]			=		rs.getInt("purchase");
		anReplyCount[nBoardCount]		=		rs.getInt("replycnt");
		anHit[nBoardCount]					=		rs.getInt("hit");
		aRegDate[nBoardCount]				=		rs.getString("regdate");
		aRegDate[nBoardCount]				=		replaceDateFormat( aRegDate[nBoardCount] , "MM/dd HH:mm" );

		// 怕弊 棺 俺青 贸府
		//
		aszSubject[nBoardCount]			=		replaceCRLFtoBR( aszSubject[nBoardCount] );
		aszSubject[nBoardCount]			=		StrConvert( aszSubject[nBoardCount] );
		
		// 迄锅龋 犁炼钦
		//
		aszPhoneNum[nBoardCount] = makeFullUserNumber( aszPhoneNum[nBoardCount] );
	}
	rs.close();
	pstmt.close();
	nBoardCount++;


	/*------------------------------------------------------------------------------------------------
	 *		NEW 葛官鸥
	 -------------------------------------------------------------------------------------------------*/
	 aszTitle[nBoardCount]					=		"NEW 葛官鸥";
	aszURL[nBoardCount]						=		URL_ITEMSHOP_CONTEST + "&orderBy=idx";

	szQuery = "SELECT TOP 1 *,((Year(getdate())+1)- age) as Ages FROM GT_MovataContest ORDER BY idx DESC";
	pstmt = con.prepareStatement(szQuery);
	rs = pstmt.executeQuery();
	if( rs.next() )
	{
		anIdx[nBoardCount]					=		rs.getInt("idx");
		aszNickName[nBoardCount]			=		rs.getString("nickname");
		anAge[nBoardCount]					=		rs.getInt("Ages");
		aszSubject	[nBoardCount]			=		rs.getString("title");
		aszPhoneNum[nBoardCount]		=		rs.getString("phonenum");
		anPoint[nBoardCount]					=		rs.getInt("point");
		anPurchase[nBoardCount]			=		rs.getInt("purchase");
		anReplyCount[nBoardCount]		=		rs.getInt("replycnt");
		anHit[nBoardCount]					=		rs.getInt("hit");
		aRegDate[nBoardCount]				=		rs.getString("regdate");
		aRegDate[nBoardCount]				=		replaceDateFormat( aRegDate[nBoardCount] , "MM/dd HH:mm" );

		// 怕弊 棺 俺青 贸府
		//
		aszSubject[nBoardCount]			=		replaceCRLFtoBR( aszSubject[nBoardCount] );
		aszSubject[nBoardCount]			=		StrConvert( aszSubject[nBoardCount] );
		
		// 迄锅龋 犁炼钦
		//
		aszPhoneNum[nBoardCount] = makeFullUserNumber( aszPhoneNum[nBoardCount] );
	}
	rs.close();
	pstmt.close();
	nBoardCount++;


	/*------------------------------------------------------------------------------------------------
	 *		牢扁炉 内叼匙捞磐
	 -------------------------------------------------------------------------------------------------*/
	 aszTitle[nBoardCount]					=		"牢扁炉 内叼匙捞磐";
	aszURL[nBoardCount]						=		URL_ITEMSHOP_COORDINATION + "&orderBy=hit";
	
	szQuery = "SELECT TOP 1 B. *,((Year(getdate())+1)- age) as Ages FROM GT_MovataCoordination_TOP A INNER JOIN GT_MovataCoordination B ON A.refIdx = B.idx ORDER BY newid()";
	pstmt = con.prepareStatement(szQuery);
	rs = pstmt.executeQuery();
	if( rs.next() )
	{
		anIdx[nBoardCount]					=		rs.getInt("idx");
		aszNickName[nBoardCount]			=		rs.getString("nickname");
		anAge[nBoardCount]					=		rs.getInt("Ages");
		aszSubject	[nBoardCount]			=		rs.getString("title");
		aszPhoneNum[nBoardCount]		=		rs.getString("phonenum");
		anPoint[nBoardCount]					=		rs.getInt("point");
		anPurchase[nBoardCount]			=		rs.getInt("purchase");
		anReplyCount[nBoardCount]		=		rs.getInt("replycnt");
		anHit[nBoardCount]					=		rs.getInt("hit");
		aRegDate[nBoardCount]				=		rs.getString("regdate");
		aRegDate[nBoardCount]				=		replaceDateFormat( aRegDate[nBoardCount] , "MM/dd HH:mm" );

		// 怕弊 棺 俺青 贸府
		//
		aszSubject[nBoardCount]			=		replaceCRLFtoBR( aszSubject[nBoardCount] );
		aszSubject[nBoardCount]			=		StrConvert( aszSubject[nBoardCount] );
		
		// 迄锅龋 犁炼钦
		//
		aszPhoneNum[nBoardCount] = makeFullUserNumber( aszPhoneNum[nBoardCount] );
	}
	rs.close();
	pstmt.close();
	nBoardCount++;


	/*------------------------------------------------------------------------------------------------
	 *		NEW 内叼匙捞磐
	 -------------------------------------------------------------------------------------------------*/
	 aszTitle[nBoardCount]					=		"脚涝 内叼匙捞磐";
	aszURL[nBoardCount]						=		URL_ITEMSHOP_COORDINATION + "orderBy=idx";

	szQuery = "SELECT TOP 1 *,((Year(getdate())+1)- age) as Ages FROM GT_MovataCoordination ORDER BY idx DESC";
	pstmt = con.prepareStatement(szQuery);
	rs = pstmt.executeQuery();
	if( rs.next() )
	{
		anIdx[nBoardCount]					=		rs.getInt("idx");
		aszNickName[nBoardCount]			=		rs.getString("nickname");
		anAge[nBoardCount]					=		rs.getInt("Ages");
		aszSubject	[nBoardCount]			=		rs.getString("title");
		aszPhoneNum[nBoardCount]		=		rs.getString("phonenum");
		anPoint[nBoardCount]					=		rs.getInt("point");
		anPurchase[nBoardCount]			=		rs.getInt("purchase");
		anReplyCount[nBoardCount]		=		rs.getInt("replycnt");
		anHit[nBoardCount]					=		rs.getInt("hit");
		aRegDate[nBoardCount]				=		rs.getString("regdate");
		aRegDate[nBoardCount]				=		replaceDateFormat( aRegDate[nBoardCount] , "MM/dd HH:mm" );


		// 怕弊 棺 俺青 贸府
		//
		aszSubject[nBoardCount]			=		replaceCRLFtoBR( aszSubject[nBoardCount] );
		aszSubject[nBoardCount]			=		StrConvert( aszSubject[nBoardCount] );
		
		// 迄锅龋 犁炼钦
		//
		aszPhoneNum[nBoardCount] = makeFullUserNumber( aszPhoneNum[nBoardCount] );
	}
	rs.close();
	pstmt.close();
	
	con.close();
}
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 ) { } }
}

// QVGA HTML
//
if( isQVGA )
{
	%><%@ include file="HTML/main.jsp"%><%
}
// QCIF HTML
//
else
{
	%><%@ include file="HTML/main.jsp"%><%
}
%>