spthb.java

web版的进销存系统

package jxc.web;
import jxc.com.DBConnect;
import java.lang.String;
import jxc.util.StrFun;
import java.sql.*;

import javax.servlet.http.*;

public class Spthb{
  private int ID;
  private String djbh;
  private int csbh;
  private int ygbh;
  private int xgbh;
  private int ckbh;
  private String tdbh;
  private int fkfs;
  private int fkbh;
  private String Tdate;
  private String Xdate;
  private float je;
  private String bz;
  private boolean isError=false;
  private String StrError="";
  public int  getID() {
    return ID;
  }
  public void setID(int anew) {
    this.ID=anew;
  }
  public void setID(String anew) {
     if (anew!=null)
    this.ID=Integer.parseInt(anew);
  }
  public String  getDjbh() {
    return djbh;
  }
  public void setDjbh(String anew) {
    this.djbh=anew;
  }
  public int  getCsbh() {
    return csbh;
  }
  public void setCsbh(int anew) {
    this.csbh=anew;
  }
  public int  getYgbh() {
    return ygbh;
  }
  public void setYgbh(int anew) {
    this.ygbh=anew;
  }

  public int  getCkbh() {
    return ckbh;
  }
  public void setCkbh(int anew) {
    this.ckbh=anew;
  }
  public int  getFkfs() {
	return fkfs;
	  }
  public void setFkfs(int anew) {
	this.fkfs=anew;
	  }
  public int  getXgbh() {
	  return xgbh; }
  public void setXgbh(int anew) {
	   this.xgbh=anew;  }
  public float  getJe() {
    return je;
  }
  public void setJe(float anew) {
    this.je=anew;
  }
  public String getBz() {
		return bz;
	}
	public void setBz(String bz) {
		this.bz = bz;
	}
	public int getFkbh() {
		return fkbh;
	}
	public void setFkbh(int fkbh) {
		this.fkbh = fkbh;
	}
	public String getTdate() {
		return Tdate;
	}
	public void setTdate(String tdate) {
		Tdate = tdate;
	}
	public String getXdate() {
		return Xdate;
	}
	public void setXdate(String xdate) {
		Xdate = xdate;
	}
	public String getTdbh() {
		return tdbh;
	  }
    public void setTdbh(String tdbh) {
		this.tdbh = tdbh;
	  }
	public void setError(boolean isError) {
		this.isError = isError;
	}
	public void setStrError(String strError) {
		StrError = strError;
	}
    public boolean getIsError(){
	return this.isError;
    }
    public String getStrError(){
	    return this.StrError;
     }
  public boolean excute() throws Exception {
	   String Str="Select * From spthb where Id="+ID;
    try {
	   DBConnect dbc  = new DBConnect(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
	   ResultSet rs = dbc.executeQuery(Str);
    if (rs.next()){
     ID=rs.getInt("ID"); 
     djbh=rs.getString("djbh"); 
     csbh=rs.getInt("csbh"); 
     ygbh=rs.getInt("ygbh");
     fkbh=rs.getInt("bh");
     xgbh=rs.getInt("xgbh");
     //tdbh=rs.getString("tdbh");
     ckbh=rs.getInt("ckbh"); 
     fkfs=rs.getInt("fkfs");
     Tdate=rs.getString("TFdate");
     Xdate=rs.getString("Xdate"); 
     je=rs.getFloat("je"); 
     bz=rs.getString("bz"); 
	  }
    rs.close();
    dbc.close();
    return true;
    }
    catch (SQLException sqle){
	    return false;
    }
  } 
  public void Add(HttpServletRequest request) throws Exception {
	   djbh=StrFun.getString(request,"djbh"); 
	   csbh=StrFun.getInt(request,"csbh"); 
	   ygbh=StrFun.getInt(request,"ygbh"); 
	   ckbh=StrFun.getInt(request,"ckbh");
	   fkbh=StrFun.getInt(request, "fkbh");
	   tdbh=StrFun.getString(request, "tdbh");
	   Tdate=StrFun.getString(request,"Tdate"); 
	   je=0; 
	   xgbh=0;
	   fkfs=StrFun.getInt(request,"fkfs"); 
	   bz=StrFun.getString(request,"bz"); 
	   
	   String Str="Select * From spthb where djbh='"+djbh+"'";
	   DBConnect dbc  = new DBConnect();
	   ResultSet rs=dbc.executeQuery(Str);
	   if (rs.next()){
	      isError=true;
	      StrError=StrError+"此编号已经存在!<br>";      
	   }
	   else{ Str="Insert into spthb(Tdate,Xdate,djbh,csbh,ygbh,tdbh,xgbh,ckbh,fkbh,fkfs,je,bz) values(now(),now(),'"+djbh+"',"+csbh+","+ygbh+",'"+tdbh+"',"+xgbh+","+ckbh+","+fkbh+","+fkfs+",'"+je+"','"+bz+"')";
   dbc.executeUpdate(Str);
	   }
	   dbc.close();
	   }   
	   
	   
	   
	  
  public void Edit(HttpServletRequest request) throws Exception {
   ID=StrFun.getInt(request,"id"); 
   djbh=StrFun.getString(request,"djbh"); 
   csbh=StrFun.getInt(request,"csbh"); 
   ygbh=StrFun.getInt(request,"ygbh"); 
   ckbh=StrFun.getInt(request,"ckbh"); 
   fkbh=StrFun.getInt(request, "fkbh");
   fkfs=StrFun.getInt(request, "fkfs");
   Tdate=StrFun.getString(request,"Tdate"); 
   je=StrFun.getFloat(request,"je");
   bz=StrFun.getString(request,"bz"); 
   String Str="Update spthb set djbh='"+djbh+"' ,csbh="+csbh+" ,ygbh="+ygbh+" ,ckbh="+ckbh+" ,fkbh="+fkbh+" ,fkfs="+fkfs+" ,Tdate='"+Tdate+"' ,je="+je+" ,bz='"+bz+"'  where id="+ID;
   DBConnect dbc  = new DBConnect();
   dbc.executeUpdate(Str);
   dbc.close();
    } 
  public void Edit1(HttpServletRequest request) throws Exception {
	   ID=StrFun.getInt(request,"id"); 
	   je=StrFun.getFloat(request,"je"); 
	   String Str="Update spthb set je="+je+"  where id="+ID;
	   DBConnect dbc  = new DBConnect();
	   dbc.executeUpdate(Str);
	   dbc.close();
	    }
  public void Del(HttpServletRequest request) throws Exception {
	    ID=StrFun.getInt(request,"id"); 
	    String Str="Select * From spthmxb where djbh="+ID;
	    DBConnect dbc  = new DBConnect();
		ResultSet rs=dbc.executeQuery(Str);
		if (rs.next()){
	   	      isError=true;
	   	      StrError=StrError+"需先将明细表中数据删除后方可进行该项操作！ <br>";	  	
		    }
		else{    
	    Str="Delete From spthb where Id="+ID;
	    dbc.executeUpdate(Str);}
	    dbc.close();
 
 }

}