package JXC.web;
import JXC.Com.DBConnect;
import java.lang.String;
import JXC.util.StrFun;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
/**
 * Title:       明細單信息
 * Description:
 * Copyright:    Copyright (c) 2003
 * Company:      torch
 * @author:		 wind
 * @version 1.0
 */
public class ckb{
  private int ID;
  private String ckbh;
  private String ckname;
  private String fzr;
  public void ckb(){}
  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  getCkbh() {
    return ckbh;
  }
  public void setCkbh(String anew) {
    this.ckbh=anew;
  }
  public String  getCkname() {
    return ckname;
  }
  public void setCkname(String anew) {
    this.ckname=anew;
  }
  public String  getFzr() {
    return fzr;
  }
  public void setFzr(String anew) {
    this.fzr=anew;
  }
  public boolean excute() throws Exception {
	   String Str="Select * From ckb 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"); 
     ckbh=rs.getString("ckbh"); 
     ckname=rs.getString("ckname"); 
     fzr=rs.getString("fzr"); 
	  }
    rs.close();
    dbc.close();
    return true;
    }
    catch (SQLException sqle){
	    return false;
    }
  } 
  public void Edit(HttpServletRequest request) throws Exception {
   ID=StrFun.getInt(request,"id"); 
   ckbh=StrFun.getString(request,"ckbh"); 
   ckname=StrFun.getString(request,"ckname"); 
   fzr=StrFun.getString(request,"fzr"); 
   String Str="Update ckb set ckbh='"+ckbh+"' ,ckname='"+ckname+"' ,fzr='"+fzr+"'  where id="+ID;
   DBConnect dbc  = new DBConnect();
   dbc.executeUpdate(Str);
   dbc.close();
    }
  public void Add(HttpServletRequest request) throws Exception {
   ckbh=StrFun.getString(request,"ckbh"); 
   ckname=StrFun.getString(request,"ckname"); 
   fzr=StrFun.getString(request,"fzr"); 
   String Str="Insert into ckb(ckbh,ckname,fzr) values('"+ckbh+"','"+ckname+"','"+fzr+"')";
   DBConnect dbc  = new DBConnect();
   dbc.executeUpdate(Str);
   dbc.close();
    }
  public void Del() throws Exception {
    String Str="Delete From ckb where Id="+ID;
    DBConnect dbc  = new DBConnect();
    dbc.executeUpdate(Str);
    dbc.close();
   }

  }