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 pay{
  private int id;
  private int bh;
  private String name;
  private String memo;
  public void pay(){}
  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 int  getBh() {
    return bh;
  }
  public void setBh(int anew) {
    this.bh=anew;
  }
  public String  getName() {
    return name;
  }
  public void setName(String anew) {
    this.name=anew;
  }
  public String  getMemo() {
    return memo;
  }
  public void setMemo(String anew) {
    this.memo=anew;
  }
  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"); 
     bh=rs.getInt("bh"); 
     name=rs.getString("name"); 
     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"); 
   bh=StrFun.getInt(request,"bh"); 
   name=StrFun.getString(request,"name"); 
   memo=StrFun.getString(request,"memo"); 
   String Str="Update pay set bh="+bh+" ,name='"+name+"' ,memo='"+memo+"'  where id="+id;
   DBConnect dbc  = new DBConnect();
   dbc.executeUpdate(Str);
   dbc.close();
    }
  public void Add(HttpServletRequest request) throws Exception {
   bh=StrFun.getInt(request,"bh"); 
   name=StrFun.getString(request,"name"); 
   memo=StrFun.getString(request,"memo"); 
   String Str="Insert into pay(bh,name,memo) values("+bh+",'"+name+"','"+memo+"')";
   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();
   }

  }