cgb.java

web版的进销存系统

package jxc.web;
import java.util.Date;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;

import jxc.com.DBConnect;
import jxc.util.StrFun;

public class Cgb{
	private int ID;
	private String djbh;
	private int csbh;
	private int ygbh; 
	private String tdr;
	private String xgr;
	private Date Xdate;
	private int ckbh;
	private Date Tdate;
	private float je;
	private int fkfs;
	private int fkbh;
	private String bz;
	private boolean isError=false;
	private String StrError=""; 
	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 boolean getIsError(){
		return this.isError;
	}
	public String getStrError(){
		return this.StrError;
	}
	public String  getDjbh() {
		return djbh;
	}
	public void setDjbh(String anew) {
		this.djbh=anew;
	}
	public int  getCsbh() {
		return csbh;
	}
	public void setCsbh(int anew) {
		this.csbh=anew;
	}
	public int  getFkbh() {
		return fkbh;
	}
	public void setFkbh(int anew) {
		this.fkbh=anew;
	}
	public int  getYgbh() {
		return ygbh;
	}
	public void setYgbh(int anew) {
		this.ygbh=anew;
	}
	public int  getCkbh() {
		return ckbh;
	}
	public void setCkbh(int anew) {
		this.ckbh=anew;
	}
	public Date getTdate() {
		return Tdate;
	}
	public void setTdate(Date tdate) {
		Tdate = tdate;
	}
	public String  getXgr() {
		return xgr;
	}
	public void setXgr(String anew) {
		this.xgr=anew;
	}
	public Date  getXdate() {
		return Xdate;
	}
	public void setXdate(Date anew) {
		this.Xdate=anew;
	}
	public String getTdr() {
		return tdr;
	}
	public void setTdr(String tdr) {
		this.tdr = tdr;
	}
	public float  getJe() {
		return je;
	}
	public void setJe(float anew) {
		this.je=anew;
	}
	public int  getFkfs() {
		return fkfs;
	}
	public void setFkfs(int anew) {
		this.fkfs=anew;
	}
	public String  getBz() {
		return bz;
	}
	public void setBz(String anew) {
		this.bz=anew;
	}


	public boolean excute() throws Exception {
		String Str="Select * From cgb 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"); 
				csbh=rs.getInt("csbh"); 
				ygbh=rs.getInt("ygbh"); 
				ckbh=rs.getInt("ckbh");
				fkbh  =rs.getInt("fkbh");
				Tdate=rs.getDate("Tdate"); 
				je=rs.getFloat("je"); 
				fkfs=rs.getInt("fkfs"); 
				bz=rs.getString("bz"); 
			}
			rs.close();
			dbc.close();
			return true;
		}
		catch (SQLException sqle){
			return false;
		}
	} 
	public void Add(HttpServletRequest request,HttpSession session) throws Exception {

		djbh=StrFun.getString(request,"djbh"); 
		csbh=StrFun.getInt(request,"csbh"); 
		ygbh=StrFun.getInt(request,"ygbh"); 
		ckbh=StrFun.getInt(request,"ckbh");
		fkbh=StrFun.getInt(request, "fkbh");
		tdr=String.valueOf(session.getAttribute("usname"));
		je=0; 
		xgr=null;
		fkfs=StrFun.getInt(request,"fkfs"); 
		bz=StrFun.getString(request,"bz"); 

		String Str="Select * From cgb where djbh='"+djbh+"'";
		DBConnect dbc  = new DBConnect();
		ResultSet rs=dbc.executeQuery(Str);
		if (rs.next()){
			isError=true;
			StrError=StrError+"此编号已经存在!<br>";      
		}
		else{ Str="Insert into cgb(Tdate,Xdate,djbh,csbh,ygbh,xgr,ckbh,fkbh,fkfs,je,bz,tdr) values(now(),now(),'"+djbh+"',"+csbh+","+ygbh+","+xgr+","+ckbh+","+fkbh+","+fkfs+",'"+je+"','"+bz+"','"+tdr+"')";
		dbc.executeUpdate(Str);
		}
		dbc.close();
	}

	public void Edit(HttpServletRequest request,HttpSession session) throws Exception {
		ID=StrFun.getInt(request,"id"); 
		fkbh=StrFun.getInt(request, "fkbh"); 
		fkfs=StrFun.getInt(request,"fkfs"); 
		xgr=String.valueOf(session.getAttribute("usname"));
		String Str="Update cgb set Xdate=now(),fkfs="+fkfs+" ,fkbh="+fkbh+",xgr='"+xgr+"'   where id="+ID;

		DBConnect dbc  = new DBConnect();
		dbc.executeUpdate(Str);
		dbc.close();
	}
	public void Edit1(HttpServletRequest request) throws Exception {
		ID=StrFun.getInt(request,"id"); 
		je=StrFun.getFloat(request,"je"); 
		String Str="Update cgb set je="+je+"  where id="+ID;
		DBConnect dbc  = new DBConnect();
		dbc.executeUpdate(Str);
		dbc.close();
	}




	public void Del(HttpServletRequest request) throws Exception {
		ID=StrFun.getInt(request,"id"); 
		String Str="Select * From cgmxb where djbh="+ID;
		DBConnect dbc  = new DBConnect();
		ResultSet rs=dbc.executeQuery(Str);
		if (rs.next()){
			isError=true;
			StrError=StrError+"需先将明细表中数据删除后方可进行该项操作！ <br>";	  	
		}
		else{    
			Str="Delete From cgb where Id="+ID;
			dbc.executeUpdate(Str);}
		dbc.close();

	}
}