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 qydb{
  private int ID;
  private String djbh;
  private int yck;
  private int mck;
  private String Fdate;
  private int ygbh;
  private String memo;
  public void qydb(){}
  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  getDjbh() {
    return djbh;
  }
  public void setDjbh(String anew) {
    this.djbh=anew;
  }
  public int  getYck() {
    return yck;
  }
  public void setYck(int anew) {
    this.yck=anew;
  }
  public int  getMck() {
    return mck;
  }
  public void setMck(int anew) {
    this.mck=anew;
  }
  public String  getFdate() {
    return Fdate;
  }
  public void setFdate(String anew) {
    this.Fdate=anew;
  }
  public int  getYgbh() {
    return ygbh;
  }
  public void setYgbh(int anew) {
    this.ygbh=anew;
  }
  public String  getMemo() {
    return memo;
  }
  public void setMemo(String anew) {
    this.memo=anew;
  }
  public boolean excute() throws Exception {
	   String Str="Select * From qydb 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"); 
     yck=rs.getInt("yck"); 
     mck=rs.getInt("mck"); 
     Fdate=rs.getString("Fdate"); 
     ygbh=rs.getInt("ygbh"); 
     memo=rs.getString("memo"); 
	  }
    rs.close();
    dbc.close();
    return true;
    }
    catch (SQLException sqle){
	    return false;
    }
  } 
  public void Edit(HttpServletRequest request) throws Exception {
   ID=StrFun.getInt(request,"id"); 
   djbh=StrFun.getString(request,"djbh"); 
   yck=StrFun.getInt(request,"yck"); 
   mck=StrFun.getInt(request,"mck"); 
   Fdate=StrFun.getString(request,"Fdate"); 
   ygbh=StrFun.getInt(request,"ygbh"); 
   memo=StrFun.getString(request,"memo"); 
   String Str="Update qydb set djbh='"+djbh+"' ,yck="+yck+" ,mck="+mck+" ,Fdate='"+Fdate+"' ,ygbh="+ygbh+" ,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"); 
   yck=StrFun.getInt(request,"yck"); 
   mck=StrFun.getInt(request,"mck"); 
   Fdate=StrFun.getString(request,"Fdate"); 
   ygbh=StrFun.getInt(request,"ygbh"); 
   memo=StrFun.getString(request,"memo"); 
   String Str="Insert into qydb(djbh,yck,mck,Fdate,ygbh,memo) values('"+djbh+"',"+yck+","+mck+",'"+Fdate+"',"+ygbh+",'"+memo+"')";
   DBConnect dbc  = new DBConnect();
   dbc.executeUpdate(Str);
   dbc.close();
    }
  public void Del() throws Exception {
    String Str="Delete From qydb where Id="+ID;
    DBConnect dbc  = new DBConnect();
    dbc.executeUpdate(Str);
    dbc.close();
   }

  }