epiboly.java

企业办公自动化管理系统

package com.zh.util;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import com.bwm.string.Str;
import com.zh.conpool.Condata;
import java.sql.*;
import javax.servlet.jsp.tagext.*;
import java.util.Date;
public class epiboly{
	String dattime;
	int money;
	Str str=new Str();
	String item1;
	String modify;
	String create;
	String sql;
	String id;
	String clientname;
	String cid;
	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();
		}
		dattime=req.getParameter("dattime");
		try{
			money=Integer.parseInt(req.getParameter("money"));
		}catch(NumberFormatException er){
			er.getMessage();
		}
		item1=str.toChinese(req.getParameter("item1"));
		id=req.getParameter("id");
		String del=req.getParameter("del");
		create=req.getParameter("create");
		clientname=req.getParameter("clientName");
		cid=req.getParameter("cid");
		if(create!=null&&create.equals("create")){
			sql="insert into tb_epiboly(ContId,Dattime,Money,Item1)values('"+id+"','"+dattime+"','"+money+"','"+item1+"')";
		}else if(modify!=null&&modify.equals("modify")){
			//sql="update "
		}else if(del!=null&&del.equals("del")){
			sql="delete from tb_epiboly where Id='"+cid+"'";
		}
		int temp=con.executeUpdate(sql);
		if(temp>0){
			out.println("数据库更新成功");
			res.sendRedirect("Epiboly_Index.jsp?id="+id+"&&clientName="+clientname+"");
		}else{
			out.println("更新数据库失败");
		}
		try{
			con.close();
			con=null;
		}catch(Exception e){
			e.getMessage();
		}
	}
}