khb.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 Khb{
  private int ID;
  private String khbh;
  private String khname;
  private String khjc;
  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 getKhbh() {
		return khbh;
	}
	public void setKhbh(String anew) {
		this.khbh = anew;
	}
	public String getKhname() {
		return khname;
	}
	public void setKhname(String anew) {
		this.khname = anew;
	}
  public String  getKhjc() {
    return khjc;
  }
  public void setCsjc(String anew) {
    this.khjc=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 khb 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"); 
     khbh=rs.getString("khbh"); 
     khname=rs.getString("khname"); 
     khjc=rs.getString("khjc"); 
     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"); 
   khbh=StrFun.getString(request,"khbh"); 
   khname=StrFun.getString(request,"khname"); 
   khjc=StrFun.getString(request,"khjc"); 
  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 khb set khbh='"+khbh+"' ,khname='"+khname+"' ,khjc='"+khjc+"' ,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 {
   khbh=StrFun.getString(request,"khbh"); 
   khname=StrFun.getString(request,"khname"); 
   khjc=StrFun.getString(request,"khjc"); 
   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 khb(khbh,khname,khjc,lxr,address,tel,fax,email,bz) values('"+khbh+"','"+khname+"','"+khjc+"','"+lxr+"','"+address+"','"+tel+"','"+fax+"','"+email+"','"+bz+"')";
   DBConnect dbc  = new DBConnect();
   dbc.executeUpdate(Str);
   dbc.close();
    }
  public void Del() throws Exception {
    String Str="Delete From khb where Id="+ID;
    DBConnect dbc  = new DBConnect();
    dbc.executeUpdate(Str);
    dbc.close();
   }
  

  }