multe_lhl.jsp

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

<%@ page language="java" pageEncoding="EUC-KR"%>
<%@ page import="java.io.*,java.text.*,java.util.Date,java.util.Vector, java.sql.*, com.entaz.lib.db.*, com.entaz.relay.net.* "%>
<%@ include file="../imgpath.jsp"%>
<%@ include file="../common_func.jsp"%>

<%
	String mphone = request.getParameter("mphone");
	String gphone = request.getParameter("gphone");
	String taroid = request.getParameter("idx");
	
	//String mphone = "13366103";			//test db		fang ke
	//String gphone = "1020591111";			//test db		zu ren
	//String isTrue = "true";
	
	String tableGT_LUCKY_TARO = "GT_LUCKY_TARO";
	String tableGT_LUCKY_TARO_COMMENT = "GT_LUCKY_TARO_COMMENT";
	
	
	String falseUrl = "tarofornoquestion_lhl.jsp?mphone="+mphone+"&gphone="+gphone;
	String trueUrl = "taroforhavequestion_lhl.jsp?mphone="+mphone+"&gphone="+gphone;
	
	//System.out.println("mphone=" + mphone);
	//System.out.println("gphone=" + gphone);
	//System.out.println("isTrue=" + isTrue);
	
	
	Connection con = null;
	PreparedStatement pstmt	= null;
	Statement stmt = null;
	ResultSet rs = null;
	ResultSet pageset = null;
	
	
	int txtid = 0 ;
	
	try {
%>
<%@ include file="../getConnection.jsp"%>
<%		
		String sqlComment0 = "select * from GT_LUCKY_TARO_COMMENT where taro_idx = " + taroid + " and convert(bigint,phonenum) = convert(bigint,"+mphone+")";
		System.out.println("=====0202020202 sqlComment0=" + sqlComment0);
		
		stmt = con.createStatement();
		rs = stmt.executeQuery(sqlComment0);
		while(rs.next())
		{
			
			txtid = rs.getInt("Taro_idx");
			System.out.println("=====0202020202 txt=" + txtid);
		}
		
		
		if(txtid == 0)
			request.getRequestDispatcher(trueUrl).forward(request,response);
		else
			request.getRequestDispatcher(falseUrl).forward(request,response);
			
		rs.close();
		stmt.close();
		con.close();
	}
	catch(Exception e)
	{
		e.printStackTrace();
	}
	
	
%>