user2groupop.java

Java实现权限管理

package cn.com.wap.relaOP;

import javax.servlet.http.*;
import javax.servlet.*;
import cn.com.wap.role.DBManager;

public class User2GroupOP {

	int userid = -1;
	int num = 0;
	public int[] insert = new int[100];

	public User2GroupOP() {
		for (int i = 0; i < 100; i++)
			insert[i] = 0;
		insert[0] = 1;
	}

	public boolean dataRequest(HttpServletRequest request) {
		try {
			//System.out.println("BBBBBBBBBBBBBBBBB:::::: "
//					+ request.getParameter("userID"));
			userid = Integer.parseInt(request.getParameter("userID"));
			GroupOP group = new GroupOP();
			int max = group.recordCount();
			//System.out.println("max: " + max);
			for (int i = 0; i < max; i++) {
				//System.out.println("requet.getParameter(group+i): "
//						+ request.getParameter("group" + i));
				if (request.getParameter("group" + i) != null) {
					insert[num] = Integer.parseInt(request.getParameter("group"
							+ i));
					//System.out.println("i: " + i);
					num++;
					//System.out.println("num::::::::: " + num);
				}
			}
			return true;
		} catch (Exception ex) {
			ex.printStackTrace();
			//System.out.println("error...........pei______: " + ex.getMessage());
			return false;
		}
	}

	public boolean insertDel(HttpServletRequest request) {

		if (dataRequest(request) == false)
			return false;
		DBManager dba = new DBManager();

		try {
			if (dba.getStmt() == false)
				return false;
			// TODO 先删除以前的权限
			StringBuffer bf = new StringBuffer();
			bf.append("delete from WAP_TEST.T_User2Group where fld_UserID='"
					+ userid + "'");
			//System.out.println("BFinserDelSQL_____: " + bf.toString());
			dba.stmt.executeUpdate(bf.toString());
			bf.delete(0, bf.length());
			//System.out.println("num: " + num);
			// TODO 将新选的权限加入数据库
			for (int i = 0; i < num; i++) {
				bf
						.append("insert into WAP_TEST.T_User2Group (fld_UserID,fld_GroupID) values ('"
								+ userid + "','" + insert[i] + "')");
				//System.out.println("bfAppendSQL++++++++++: " + bf.toString());
				dba.stmt.executeUpdate(bf.toString());
				bf.delete(0, bf.length());
			}
			dba.close();
			return true;
		} catch (Exception ex) {
			ex.printStackTrace();
			//System.out.println("insertDel______error......." + ex.getMessage());
			return false;
		}

	}

}