package JXC.web;
import JXC.Com.DBConnect;
import JXC.util.StrFun;
import java.lang.String;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class fkdjb {
private int ID;
private String djbh;
private int csbh;
private int ygbh;
private String Fdate;
private int fkfs;
private float je;
private String memo;
public int getID() {
return ID;}
public void setID (int newID) {
this.ID=newID;}
  public void setID(String anew) {
     if (anew!=null)
    this.ID=Integer.parseInt(anew);
  }
public String getdjbh() {
return djbh;}
public void setdjbh (String newdjbh) {
this.djbh=newdjbh;}
public int getcsbh() {
return csbh;}
public void setcsbh (int newcsbh) {
this.csbh=newcsbh;}
public int getygbh() {
return ygbh;}
public void setygbh (int newygbh) {
this.ygbh=newygbh;}
public String getFdate() {
return Fdate;}
public void setFdate (String newFdate) {
this.Fdate=newFdate;}
public int getfkfs() {
return fkfs;}
public void setfkfs (int newfkfs) {
this.fkfs=newfkfs;}
public float getje() {
return je;}
public void setje (float newje) {
this.je=newje;}
public String getmemo() {
return memo;}
public void setmemo (String newmemo) {
this.memo=newmemo;}
public boolean excute() throws Exception {
String Str="Select * From fkdjb 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");
Fdate= rs.getString("Fdate");
fkfs= rs.getInt("fkfs");
je= rs.getFloat("je");
memo= rs.getString("memo");
}rs.close();
dbc.close();
return true;}
catch (SQLException sqle){
return false;}	}
public void Del() throws Exception {
String Str="Delete From fkdjb where ID="+ID;
DBConnect dbc  = new DBConnect();
dbc.executeUpdate(Str);
dbc.close();}
public  void Edit(HttpServletRequest request) throws Exception {
String id=StrFun.getString(request,"id");
djbh=StrFun.getString(request,"djbh");
csbh=StrFun.getInt(request,"csbh");
ygbh=StrFun.getInt(request,"ygbh");
Fdate=StrFun.getString(request,"Fdate");
fkfs=StrFun.getInt(request,"fkfs");
je=StrFun.getFloat(request,"je");
memo=StrFun.getString(request,"memo");
String Str="Update fkdjb set djbh='"+djbh+"',csbh="+csbh+",ygbh="+ygbh+",Fdate='"+Fdate+"',fkfs="+fkfs+",je="+je+",memo='"+memo+"' where ID="+id;
DBConnect dbc  = new DBConnect();
dbc.executeUpdate(Str);
dbc.close();}
public  void Add(HttpServletRequest request) throws Exception {
djbh=StrFun.getString(request,"djbh");
csbh=StrFun.getInt(request,"csbh");
ygbh=StrFun.getInt(request,"ygbh");
Fdate=StrFun.getString(request,"Fdate");
fkfs=StrFun.getInt(request,"fkfs");
je=StrFun.getFloat(request,"je");
memo=StrFun.getString(request,"memo");
String Str="insert into fkdjb (djbh,csbh,ygbh,Fdate,fkfs,je,memo) values('"+djbh+"',"+csbh+","+ygbh+",'"+Fdate+"',"+fkfs+","+je+",'"+memo+"')";
DBConnect dbc  = new DBConnect();
dbc.executeUpdate(Str);
dbc.close();}}