pay.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 Pay{
  private int id;
  private int fkbh;
  private String fkname;
  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 getFkbh() {
		return fkbh;
	}
	public void setFkbh(int fkbh) {
		this.fkbh = fkbh;
	}
	public String getFkname() {
		return fkname;
	}
	public void setFkname(String fkname) {
		this.fkname = fkname;
	}
  public boolean excute() throws Exception {
	   String Str="Select * From pay 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"); 
     fkbh=rs.getInt("fkbh"); 
     fkname=rs.getString("fkname"); 
     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"); 
   fkbh=StrFun.getInt(request,"fkbh"); 
   fkname=StrFun.getString(request,"fkname"); 
   bz=StrFun.getString(request,"bz"); 
   String Str="Update pay set fkbh="+fkbh+" ,fkname='"+fkname+"' ,bz='"+bz+"'  where id="+id;
   DBConnect dbc  = new DBConnect();
   dbc.executeUpdate(Str);
   dbc.close();
    }
  public void Add(HttpServletRequest request) throws Exception {
   fkbh=StrFun.getInt(request,"fkbh"); 
   fkname=StrFun.getString(request,"fkname"); 
   bz=StrFun.getString(request,"bz"); 
   String Str="Insert into pay(fkbh,fkname,bz) values("+fkbh+",'"+fkname+"','"+bz+"')";
   DBConnect dbc  = new DBConnect();
   dbc.executeUpdate(Str);
   dbc.close();
    }
  public void Del() throws Exception {
    String Str="Delete From pay where Id="+id;
    DBConnect dbc  = new DBConnect();
    dbc.executeUpdate(Str);
    dbc.close();
   }


  }