permission.java

web版的进销存系统

package jxc.web;

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 Permission {

	private int ID;
	private String pmName;
	private String pmResource;
	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 getPmName() {
		return pmName;
	}
	public void setPmName(String pmName) {
		this.pmName = pmName;
	}
	public String getPmResource() {
		return pmResource;
	}
	public void setPmResource(String pmResource) {
		this.pmResource = pmResource;
	}
	
	public boolean excute() throws Exception {
		String Str="Select * From user_permission 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"); 
				pmName=rs.getString("pmName"); 
				pmResource=rs.getString("pmResource"); 
			}
			rs.close();
			dbc.close();
			return true;
		}
		catch (SQLException sqle){
			return false;
		}
	} 
	public void Add(HttpServletRequest request,HttpSession session) throws Exception {

		pmName=StrFun.getString(request,"pmName"); 
		pmResource=StrFun.getString(request,"pmResource");

		String Str="Select * From user_permission where pmName='"+pmName+"'";
		DBConnect dbc  = new DBConnect();
		ResultSet rs=dbc.executeQuery(Str);
		if (rs.next()){
			isError=true;
			StrError=StrError+"Role exist!<br>";      
		}
		else{ Str="Insert into user_permission(pmName,pmResource) values('"+pmName+"','"+pmResource+"',)";
		dbc.executeUpdate(Str);
		}
		dbc.close();
	}
	
	  public void Edit(HttpServletRequest request,HttpSession session) throws Exception {
		   ID=StrFun.getInt(request,"id"); 
		   pmName=StrFun.getString(request, "pmName"); 
		   pmResource=StrFun.getString(request,"pmResource"); 
		   String Str="Update user_permission set pmName='"+pmName+"' ,pmResource='"+pmResource+"' where id="+ID;
		   
		   DBConnect dbc  = new DBConnect();
		   dbc.executeUpdate(Str);
		   dbc.close();
		    }
	  
	  public void Del(HttpServletRequest request) throws Exception {
		    ID=StrFun.getInt(request,"id"); 

		    DBConnect dbc  = new DBConnect();
		    
		    String Str="Delete From user_permission where Id="+ID;
		    dbc.executeUpdate(Str);
		    dbc.close();
	   
	   }


}