person.java

web版的进销存系统

package jxc.web;
import jxc.com.DBConnect;
import java.lang.String;
import jxc.util.StrFun;
import java.sql.*;
import javax.servlet.http.*;

public class Person{
  private int ID;
  private String ygbh;
  private String name;
  private String sex;
  private String tel;
  private String address;
  private String bz;
  
   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 getAddress() {
		return address;
	}
	public void setAddress(String address) {
		this.address = address;
	}
	public String getBz() {
		return bz;
	}
	public void setBz(String bz) {
		this.bz = bz;
	}
	public String getYgbh() {
		return ygbh;
	}
	public void setYgbh(String ygbh) {
		this.ygbh = ygbh;
	}
  public String  getName() {
    return name;
  }
  public void setName(String anew) {
    this.name=anew;
  }
  public String  getSex() {
    return sex;
  }
  public void setSex(String anew) {
    this.sex=anew;
  }
  public boolean excute() throws Exception {
	   String Str="Select * From person 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"); 
     sex=rs.getString("sex"); 
     tel=rs.getString("tel"); 
     address=rs.getString("address"); 
     bz=rs.getString("bz"); 
	  }
    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"); 
   sex=StrFun.getString(request,"sex"); 
   tel=StrFun.getString(request,"tel"); 
   address=StrFun.getString(request,"address"); 
   bz=StrFun.getString(request,"bz"); 
   String Str="Update person set ygbh='"+ygbh+"' ,name='"+name+"' ,sex='"+sex+"' , tel='"+tel+"' ,address='"+address+"' ,bz='"+bz+"'  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"); 
   sex=StrFun.getString(request,"sex"); 
   tel=StrFun.getString(request,"tel"); 
   address=StrFun.getString(request,"address"); 
   bz=StrFun.getString(request,"bz"); 
   String Str="Insert into person(ygbh,name,sex,tel,address,bz) values('"+ygbh+"','"+name+"','"+sex+"','"+tel+"','"+address+"','"+bz+"')";
   DBConnect dbc  = new DBConnect();
   dbc.executeUpdate(Str);
   dbc.close();
    }
  public void Del() throws Exception {
    String Str="Delete From person where Id="+ID;
    DBConnect dbc  = new DBConnect();
    dbc.executeUpdate(Str);
    dbc.close();
   }
public String getTel() {
	return tel;
}
public void setTel(String tel) {
	this.tel = tel;
}



  }