fkb.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 Fkb{
  private int ID;
  private int fkfs;
  private String fkfsname;
  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 getBz() {
		return bz;
	}
	public void setBz(String bz) {
		this.bz = bz;
	}
	public int getFkfs() {
		return fkfs;
	}
	public void setFkfs(int fkfs) {
		this.fkfs = fkfs;
	}
	public String getFkfsname() {
		return fkfsname;
	}
	public void setFkfsname(String fkfsname) {
		this.fkfsname = fkfsname;
	}
  public boolean excute() throws Exception {
	String Str="Select * From fkb 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"); 
     fkfs=rs.getInt("fkfs"); 
     fkfsname=rs.getString("fkfsname"); 
     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"); 
   fkfs=StrFun.getInt(request,"fkfs"); 
   fkfsname=StrFun.getString(request,"fkfsname"); 
   bz=StrFun.getString(request,"bz"); 
   String Str="Update fkb set fkfs="+fkfs+" ,fkfsname='"+fkfsname+"' ,bz='"+bz+"'  where id="+ID;
   DBConnect dbc  = new DBConnect();
   dbc.executeUpdate(Str);
   dbc.close();
    }
  public void Add(HttpServletRequest request) throws Exception {
   fkfs=StrFun.getInt(request,"fkfs"); 
   fkfsname=StrFun.getString(request,"fkfsname"); 
   bz=StrFun.getString(request,"bz"); 
   String Str="Insert into fkb(fkfs,fkfsname,bz) values("+fkfs+",'"+fkfsname+"','"+bz+"')";
   DBConnect dbc  = new DBConnect();
   dbc.executeUpdate(Str);
   dbc.close();
    }
  public void Del() throws Exception {
    String Str="Delete From fkb where Id="+ID;
    DBConnect dbc  = new DBConnect();
    dbc.executeUpdate(Str);
    dbc.close();
   }


  }