answerdeleterepleaction.jsp

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

<!-------------------------------------------------------------
* @ name: answerDeleteRepleAction.jsp
* @ Author : linaZhou 
* @ date :2008-06-30
-------------------------------------------------------------->
<%@ 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"%>
<%@ include file="formatUtil.jsp"%>
<%@ include file="../makeKOR.jsp"%>
<%! 	 
public static String isNull(String str){ 
	if (str == null) 
		return ""; 
	else 
		return str; 
} 	
%>
<%
	/*------------------------------------------------------------------------------------------------------
	+	扁夯 颇扼固磐
	-------------------------------------------------------------------------------------------------------*/
	String mphone = request.getParameter("mphone");
	String gphone = request.getParameter("gphone");
	if(mphone == null){
		mphone= "09900100081";
	}	
	if(gphone == null){
		gphone = mphone;
	}
	mphone = getStrPhone(getLong(mphone));
 	gphone = getStrPhone(getLong(gphone));	
    /*------------------------------------------------------------------------------------------------------
	+	傈开 函荐
	-------------------------------------------------------------------------------------------------------*/	
	int reple_idx 		= 0;
	int ref_idx 		= 0;
	String redirectPage = "";
	
   	reple_idx = Integer.parseInt(request.getParameter("reple_idx"));
    ref_idx = Integer.parseInt(request.getParameter("idx")); 
	/*------------------------------------------------------------------------------------------------------
	+	DB 包访 函荐
	-------------------------------------------------------------------------------------------------------*/
	PreparedStatement pstmt = null;
	Connection con = null;
	Statement stmt = null;
	ResultSet rs = null;
	String query1 = null;
    String sql = null;
    int ret = -1;
	/*------------------------------------------------------------------------------------------------------
	+	朝楼 包访	
	-------------------------------------------------------------------------------------------------------*/
	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=" DELETE FROM GT_Ns30questionRe WHERE idx = "+reple_idx;
	pstmt = con.prepareStatement(query1);	
	ret = pstmt.executeUpdate();
	if(ret==-1){
		return;  
	}else{
		redirectPage = "30q&a_repleList.jsp";
	}
	pstmt.close();	        
	/**************************************
			胶鸥客 嘎苗焊绰 矾宏款技!
	***************************************/
	stmt = con.createStatement(); 
	query1=" UPDATE GT_Ns30question SET reCnt = reCnt-1 WHERE idx ="+ref_idx;	
	pstmt = con.prepareStatement(query1);				
	pstmt.executeUpdate();	
	pstmt.close();          
	      	        
	}catch(Exception e){
		System.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){}
	}
	response.sendRedirect(redirectPage+"?mphone="+mphone+"&gphone="+gphone+"&idx="+ref_idx);
	%>