csb.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 Csb{
  private int ID;
  private String csbh;
  private String csname;
  private String csjc;
  private String lxr;
  private String address;
  private String tel;
  private String fax;
  private String email;
  private String bz;
  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  getCsbh() {
    return csbh;
  }
  public void setCsbh(String anew) {
    this.csbh=anew;
  }
  public String  getCsname() {
    return csname;
  }
  public void setCsname(String anew) {
    this.csname=anew;
  }
  public String  getCsjc() {
    return csjc;
  }
  public void setCsjc(String anew) {
    this.csjc=anew;
  }
  public String  getAddress() {
    return address;
  }
  public void setAddress(String anew) {
    this.address=anew;
  }
  public String  getTel() {
    return tel;
  }
  public void setTel(String anew) {
    this.tel=anew;
  }
  public String  getEmail() {
    return email;
  }
  public void setEmail(String anew) {
    this.email=anew;
  }
  public String getBz() {
		return bz;
	}
	public void setBz(String bz) {
		this.bz = bz;
	}
	public String getFax() {
		return fax;
	}
	public void setFax(String fax) {
		this.fax = fax;
	}
	public String getLxr() {
		return lxr;
	}
	public void setLxr(String lxr) {
		this.lxr = lxr;
	}    
  public boolean excute() throws Exception {
	   String Str="Select * From csb 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"); 
     csbh=rs.getString("csbh"); 
     csname=rs.getString("csname"); 
     csjc=rs.getString("csjc"); 
     lxr=rs.getString("lxr"); 
     address=rs.getString("address"); 
     tel=rs.getString("tel"); 
     fax=rs.getString("fax"); 
     email=rs.getString("email"); 
     bz=rs.getString("bz"); 
	  }
    rs.close();
    dbc.close();
    return true;
    }
    catch (SQLException sqle){
	    return false;
    }
  } 
  public void Edit(HttpServletRequest request) throws Exception {
   ID=StrFun.getInt(request,"id"); 
   csbh=StrFun.getString(request,"csbh"); 
   csname=StrFun.getString(request,"csname"); 
   csjc=StrFun.getString(request,"csjc"); 
   lxr=StrFun.getString(request,"lxr"); 
   address=StrFun.getString(request,"address"); 
   tel=StrFun.getString(request,"tel"); 
   fax=StrFun.getString(request,"fax"); 
   email=StrFun.getString(request,"email"); 
  bz=StrFun.getString(request,"bz"); 
   String Str="Update csb set csbh='"+csbh+"' ,csname='"+csname+"' ,csjc='"+csjc+"' ,lxr='"+lxr+"' ,address='"+address+"' ,tel='"+tel+"' ,fax='"+fax+"' ,email='"+email+"' ,bz='"+bz+"'  where id="+ID;
   DBConnect dbc  = new DBConnect();
   dbc.executeUpdate(Str);
   dbc.close();
    }
  public void Add(HttpServletRequest request) throws Exception {
   csbh=StrFun.getString(request,"csbh"); 
   csname=StrFun.getString(request,"csname"); 
   csjc=StrFun.getString(request,"csjc"); 
   lxr=StrFun.getString(request,"lxr"); 
   address=StrFun.getString(request,"address"); 
   tel=StrFun.getString(request,"tel"); 
   fax=StrFun.getString(request,"fax"); 
   email=StrFun.getString(request,"email"); 
   bz=StrFun.getString(request,"bz"); 
   String Str="Insert into csb(csbh,csname,csjc,lxr,address,tel,fax,email,bz) values('"+csbh+"','"+csname+"','"+csjc+"','"+lxr+"','"+address+"','"+tel+"','"+fax+"','"+email+"','"+bz+"')";
   DBConnect dbc  = new DBConnect();
   dbc.executeUpdate(Str);
   dbc.close();
    }
  public void Del() throws Exception {
    String Str="Delete From csb where Id="+ID;
    DBConnect dbc  = new DBConnect();
    dbc.executeUpdate(Str);
    dbc.close();
   }


  }