stockadd.java

企业办公自动化管理系统

/*
 * Stockadd.java
 *
 * Created on 2005年5月20日, 上午9:17
 */

/**
 *
 * @author  administrator
 */
package com.zh.util;
import java.sql.*;
import com.zh.conpool.*;
import javax.servlet.*;
import java.io.*;
import javax.servlet.http.*;
public class Stockadd {
    public String id;
    public String dattime;
    public String item;
    public int money;
    public String remark;
    String sql;
    String tag;
   	String tab;
    /** Creates a new instance of Stockadd */
    public Stockadd() {
    }
    public void Init(HttpServletRequest req,javax.servlet.http.HttpServletResponse res)throws ServletException,IOException,SQLException{
        boolean fag=false;
        Condata con=new Condata();
        PrintWriter out=res.getWriter();
        id=req.getParameter("id");
        dattime=req.getParameter("dattime");
        item=req.getParameter("it");
        try{
        	money=Integer.parseInt(req.getParameter("money"));
        }catch(Exception e){
        }
        remark=req.getParameter("remark");
        tag=req.getParameter("id");
        tab=req.getParameter("tab");
        if(tab!=null){
        	sql="delete from tb_Stcokadd where Id='"+tab+"'";
        }else{
        	sql="insert into tb_Stcokadd(ClientId,Dattime,Item,Money,Remark)values('"+id+"','"+dattime+"','"+item+"','"+money+"','"+remark+"')";
        }
        try{
           con.getConnection();
        }catch(Exception e){
            e.getMessage();
        }
        out.println(sql);
        fag=Updata();
        if(fag==true){
            out.println("数据库维护成功");
            out.println("<script language='javascript'>parent.bottomFrame.location.reload();</script>");
        	res.sendRedirect("Stock_Index.jsp?id="+id+"");
        }else{
            out.println("维护失败");
        }
         try{
            con.close();
            con=null;
        }catch(Exception e){
            e.getMessage();
        }
       }
    public boolean Updata(){
         Condata con=new Condata();
        try{
           con.getConnection();
        }catch(Exception e){
            e.getMessage();
        }
        boolean tag=false;
        int temp=con.executeUpdate(sql);
        if(temp>0){
            tag=true;
        }else{
            tag=false;
       }
        return tag;
    }
}