www.pudn.com > OA.rar > Del.java

/* 
 * Created on 2004-9-24 
 * 
 * To change the template for this generated file go to 
 * Window>Preferences>Java>Code Generation>Code and Comments 
 */ 
package com.affice; 
 
import oa.sys.*; 
 
import java.io.*; 
import java.sql.*; 
import javax.servlet.*; 
import javax.servlet.http.*; 
/** 
 **************************************************** 
 *类名称：	Del
 
 *类功能：	删除公告信息
 
 *创建：	白伟明	2004年10月6日
 
 **************************************************** 
 * To change the template for this generated type comment go to 
 * Window>Preferences>Java>Code Generation>Code and Comments 
 */ 
public class Del extends HttpServlet{ 
	private HttpSession session=null; 
	private Statement stmt=null; 
	private ResultSet rs=null; 
	private String sqld; 
	private int temp=0,id=0; 
	 
	public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException{ 
		request.setCharacterEncoding("gb2312"); 
		response.setContentType("text/html; charset=gb2312"); 
		Db db=new Db(); 
		PrintWriter out=response.getWriter(); 
		session=request.getSession(); 
		try{ 
			id=Integer.parseInt((String)request.getParameter("afficeid")); 
		}catch(NumberFormatException e){ 
			e.printStackTrace(); 
		} 
		sqld="DELETE FROM affice WHERE afficeid="+id; 
		try { 
				//删除公告 
				stmt=db.getStmt(); 
				temp=stmt.executeUpdate(sqld); 
				if(temp>0){ 
					request.setAttribute("msg","删除成功"); 
				}else{ 
					request.setAttribute("msg","删除失败"); 
				} 
		} catch (SQLException e) { 
			e.printStackTrace(); 
		}finally{ 
			db.close(); 
			RequestDispatcher dispatcher=request.getRequestDispatcher("view"); 
			dispatcher.forward(request,response); 
		} 
	} 
	public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException{ 
		doPost(request,response); 
	} 
}