foldel.java

企业办公自动化管理系统

package com.zh.util;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import com.zh.conpool.*;
public class foldel{
	private String id;
	private String sql;
	private ResultSet rs=null;
	private Condata con=new Condata();
	public void Init(javax.servlet.http.HttpServletRequest req,javax.servlet.http.HttpServletResponse res)throws ServletException,IOException,SQLException{
		try{
			con.getConnection();
		}catch(Exception e){
			e.getMessage();
		}
		PrintWriter out=res.getWriter();
		id=req.getParameter("tag");
		sql="delete from tb_follow where Id='"+id+"'";
		int temp=con.executeUpdate(sql);
		if(temp>0){
			out.println("记录删除成功");
			res.sendRedirect("Follow_Index.jsp");
		}else if(temp==0){
			out.println("删除失败");
		}else{
			out.println("请与系统管理员取得联系");
		}
	}
	public void close(){
		try{
			con.close();
			con=null;
		}catch(Exception e){
			e.getMessage();
		}
		try{
			rs.close();
			rs=null;
		}catch(Exception e){
			e.getMessage();
		}
	}
}