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 XX{
  private int id;
  private String ygbh;
  private String name;
  private String passwd;
  private String js;
  public void XX(){}
  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  getYgbh() {
    return ygbh;
  }
  public void setYgbh(String anew) {
    this.ygbh=anew;
  }
  public String  getName() {
    return name;
  }
  public void setName(String anew) {
    this.name=anew;
  }
  public String  getPasswd() {
    return passwd;
  }
  public void setPasswd(String anew) {
    this.passwd=anew;
  }
  public String  getJs() {
    return js;
  }
  public void setJs(String anew) {
    this.js=anew;
  }
  public boolean excute() throws Exception {
	   String Str="Select * From XX 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"); 
     ygbh=rs.getString("ygbh"); 
     name=rs.getString("name"); 
     passwd=rs.getString("passwd"); 
     js=rs.getString("js"); 
	  }
    rs.close();
    dbc.close();
    return true;
    }
    catch (SQLException sqle){
	    return false;
    }
  } 
  public void Edit(HttpServletRequest request) throws Exception {
   id=StrFun.getInt(request,"id"); 
   ygbh=StrFun.getString(request,"ygbh"); 
   name=StrFun.getString(request,"name"); 
   passwd=StrFun.getString(request,"passwd"); 
   js=StrFun.getString(request,"js"); 
   String Str="Update XX set ygbh='"+ygbh+"' ,name='"+name+"' ,passwd='"+passwd+"' ,js='"+js+"'  where id="+id;
   DBConnect dbc  = new DBConnect();
   dbc.executeUpdate(Str);
   dbc.close();
    }
  public void Add(HttpServletRequest request) throws Exception {
   ygbh=StrFun.getString(request,"ygbh"); 
   name=StrFun.getString(request,"name"); 
   passwd=StrFun.getString(request,"passwd"); 
   js=StrFun.getString(request,"js"); 
   String Str="Insert into XX(ygbh,name,passwd,js) values('"+ygbh+"','"+name+"','"+passwd+"','"+js+"')";
   DBConnect dbc  = new DBConnect();
   dbc.executeUpdate(Str);
   dbc.close();
    }
  public void Del() throws Exception {
    String Str="Delete From XX where Id="+id;
    DBConnect dbc  = new DBConnect();
    dbc.executeUpdate(Str);
    dbc.close();
   }

  }