package com.zh.util;
import java.sql.*;
import com.zh.conpool.Condata;
import javax.servlet.*;
import javax.servlet.http.*;
import com.bwm.string.Str;
import java.io.*;
public class demand{
	String file;
	String create;
	String modify;
	String demand;
	String  money;
	int mon=0;
	String explain;
	String sql;
	String id;
	String demid;
	Str str=new Str();
	Condata con=new Condata();
	public void Init(javax.servlet.http.HttpServletRequest req,javax.servlet.http.HttpServletResponse res)throws ServletException,IOException,SQLException{
		PrintWriter out=res.getWriter();
		try{
			con.getConnection();
		}catch(Exception e){
			e.getMessage();
		}
		
		file=req.getParameter("file");
		create=req.getParameter("create");
		modify=req.getParameter("modify");
		demand=str.toChinese(req.getParameter("demand"));
		money=req.getParameter("money");
		try{
			mon=Integer.parseInt(money);
		}catch(NumberFormatException er){
				er.getMessage();
			}
		explain=str.toChinese(req.getParameter("explain"));
		id=req.getParameter("id");
		demid=req.getParameter("demid");
		int tem=0;
		int temp=0;
		
		try{
		if(create!=null&&create.equals("create")){
			sql="insert into tb_demand(Clientid,Demand,Money,Explain)values('"+id+"','"+demand+"','"+mon+"','"+explain+"')";
			temp=con.executeUpdate(sql);
		if(temp>0){
			out.println("數據庫維護成功");
			res.sendRedirect("Demand_Index.jsp?id="+id+"");
		}else if(temp==0){
			out.println("數據庫維護失敗");
		}else{
			out.println("系統發生內部故障請與系統管理員取得聯系");
		}
		}
		
		if(modify!=null&&modify.equals("modify")){
			sql="delete tb_demand where Id='"+demid+"'";
			out.println(sql);
			out.println(modify);
			tem=con.executeUpdate(sql);
			if(tem>0){
				out.println("數據庫維護成功");
				res.sendRedirect("Demand_Index.jsp?id="+id+"");
			}else if(temp==0){
				out.println("數據庫維護失敗");
			}else{
				out.println("系統發生內部故障請與系統管理員取得聯系");
		}
		}
	
		}catch(Exception e){
			e.getMessage();
		}	
		try{
			con.close();
			con=null;
		}catch(Exception e){
			e.getMessage();
		}
	}

}