role.java

web版的进销存系统

package jxc.web;

import java.sql.ResultSet;
import java.sql.SQLException;

import javax.servlet.http.HttpServletRequest;

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

public class Role {

	private int ID;
	private String roleName;
	private String pms;
	private boolean isError=false;
	private String StrError=""; 	

	public boolean isError() {
		return isError;
	}
	public void setError(boolean isError) {
		this.isError = isError;
	}
	public String getStrError() {
		return StrError;
	}
	public void setStrError(String strError) {
		StrError = 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 getRoleName() {
		return roleName;
	}
	public void setRoleName(String roleName) {
		this.roleName = roleName;
	}
	public String getPms() {
		return pms;
	}
	public void setPms(String pms) {
		this.pms = pms;
	}

	public boolean excute() throws Exception {
		String Str="Select * From user_role 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"); 
				roleName=rs.getString("roleName"); 
				pms=rs.getString("pms"); 
			}
			rs.close();
			dbc.close();
			return true;
		}
		catch (SQLException sqle){
			return false;
		}
	} 
	public void Add(HttpServletRequest request) throws Exception {

		roleName=StrFun.getString(request,"roleName");

		String[] str = request.getParameterValues("pm");
		if(str!=null){
			pms="";
			for(int i = 0; str!=null && i < str.length; i++){  
				pms  +=  str[i];
			}
			System.out.println(pms);
		}
		else{
			pms="";	
		}
		String Str="Select * From user_role where roleName='"+roleName+"'";
		DBConnect dbc  = new DBConnect();
		ResultSet rs=dbc.executeQuery(Str);
		if (rs.next()){
			isError=true;
			StrError=StrError+"Role exist!<br>";      
		}
		else{ Str="Insert into user_role(roleName,pms) values('"+roleName+"','"+pms+"')";
		dbc.executeUpdate(Str);
		}
		dbc.close();
	}

	public void Edit(HttpServletRequest request) throws Exception {
		ID=StrFun.getInt(request,"id"); 
		roleName=StrFun.getString(request, "roleName"); 
		
		String[] str = request.getParameterValues("pm");
		if(str!=null){
			pms="";
			for(int i = 0; str!=null && i < str.length; i++){  
				pms  +=  str[i];
			}
			System.out.println(pms);
		}
		else{
			pms="";	
		}
		String Str="Update user_role set roleName='"+roleName+"' ,pms='"+pms+"' where id="+ID;

		DBConnect dbc  = new DBConnect();
		dbc.executeUpdate(Str);
		dbc.close();
	}

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



}