wpxx.java

web版的进销存系统

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

public class WPXX{
	private int ID;
	private String wpbh;
	private String wptypename;
	private String wpname;
	private int wptypeID;
	private String wppath;
	private String xh;
	private String dw;
	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 String getStrError() {
		return StrError;
	}
	public void setStrError(String strError) {
		StrError = strError;
	}
	public boolean isError() {
		return isError;
	}
	public void setError(boolean isError) {
		this.isError = isError;
	}
	public String getWppath() {
		return wppath;
	}
	public void setWppath(String wppath) {
		this.wppath = wppath;
	}
	public String getWpbh(){
		return wpbh;
	}
	public void setWpbh(String anew){
		this.wpbh=anew;
	}
	public String getWpname() {
		return wpname;
	}
	public void setWpname(String wpname) {
		this.wpname = wpname;
	}			
	public  String getXh(){
		return xh;
	}
	public void setXh(String anew){
		this.xh=anew;
	}
	public String getDw(){
		return dw;
	}
	public void setDw(String anew){
		this.dw=anew;
	}
	public String getBz() {
		return bz;
	}
	public void setBz(String bz) {
		this.bz = bz;
	}
	public int getWptypeID() {
		return wptypeID;
	}
	public void setWptypeID(int wptypeID) {
		this.wptypeID = wptypeID;
	}
	public String getWptypename() {
		return wptypename;
	}
	public void setWptypename(String wptypename) {
		this.wptypename = wptypename;
	}
	public boolean excute() throws Exception {
		String Str="Select * From wpb 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"); 
				wpbh=rs.getString("wpbh");	
				wpname=rs.getString("wpname");
				wptypeID=rs.getInt("wptypeID");
				wppath=rs.getString("wppath");
				wptypename=rs.getString("wptypename");  	
				xh=rs.getString("xh");
				dw=rs.getString("dw");				
				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");//为啥是小写id，写成大写就不对！
		wpbh  =StrFun.getString(request,"wpbh");
		wpname=StrFun.getString(request,"wpname");
		wptypeID=StrFun.getInt(request, "wptypeID");//物品类别ID
		
		String sql="Select * From wptype where ID="+wptypeID;
		try {
			DBConnect dbc = new DBConnect();
			ResultSet rs = dbc.executeQuery(sql);
			if (rs.next()) {
				wptypename = rs.getString("wptypename");//物品名称
				wppath = rs.getString("path");//物品类别path
			}
			rs.close();
			dbc.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		
		xh  =StrFun.getString(request,"xh");
		dw  =StrFun.getString(request,"dw");
		bz  =StrFun.getString(request,"bz"); 
		String Str="update wpb set wpbh='"+wpbh+"',wpname='"+wpname+"',wptypename='"+wptypename+"',wppath='"+wppath+"',xh='"+xh+"',dw='"+dw+"',bz='"+bz+"'  where ID="+ID;//此处ID大小写都行，为啥呢
		DBConnect dbc = new DBConnect();
		dbc.executeUpdate(Str);
		dbc.close();
	}
	
	public  void Add(HttpServletRequest request) throws Exception {
		wpbh  =StrFun.getString(request,"wpbh");
		wpname=StrFun.getString(request,"wpname");
		wptypeID=StrFun.getInt(request, "wptypeID");//物品类别ID

		String sql="Select * From wptype where ID="+wptypeID;
		try {
			DBConnect dbc = new DBConnect();
			ResultSet rs = dbc.executeQuery(sql);
			if (rs.next()) {
				wptypename = rs.getString("wptypename");
				wppath = rs.getString("path");
			}
			rs.close();
			dbc.close();
		} catch (Exception e) {
			e.printStackTrace();
		}

		xh  =StrFun.getString(request,"xh");
		dw  =StrFun.getString(request,"dw");
		bz  =StrFun.getString(request,"bz");
		
		DBConnect dbc  = new DBConnect();
		sql="Select * From wpb where wpbh="+wpbh;
		ResultSet rs = dbc.executeQuery(sql);
		if(rs.next()){
			isError=true;
			StrError=StrError+"此编号已经存在!<br>";
		}
		else{				
		String Str="Insert into wpb (wpname,wpbh,wptypename,wptypeID,wppath,xh,dw,bz) values('"+wpname+"','"+wpbh+"','"+wptypename+"','"+wptypeID+"','"+wppath+"','"+xh+"','"+dw+"','"+bz+"')";		
		dbc.executeUpdate(Str);
		}
		dbc.close();
	}

	public void Del() throws Exception {
		String Str="Delete From wpb where Id="+ID;
		DBConnect dbc  = new DBConnect();
		dbc.executeUpdate(Str);
		dbc.close();
	}

}