contranctdel.java

企业办公自动化管理系统

package com.zh.util;
import java.sql.*;
import java.io.*;
import com.bwm.string.Str;
import javax.servlet.*;
import javax.servlet.http.*;
import com.zh.conpool.*;
public class contranctdel{
	String id;
	String sql;
	Condata con=new Condata();
	int temp;
	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("id");
		sql="delete tb_contract where Id='"+id+"'";
		temp=con.executeUpdate(sql);
		if(temp>0){
			out.println("<br>");
			out.println("数据库删除成功");
			out.println("<script language='javascript'>parent.bottomFrame.location.reload();</script>");
		}else if(temp==0){
			out.println("<br>");
			out.println("数据库删除失败");
		}else{
			out.println("<br>");
			out.println("系统内部故障");
		}
	}
}