group2actionop.java

Java实现权限管理

package cn.com.wap.relaOP;

import javax.servlet.http.HttpServletRequest;

import cn.com.wap.role.*;

public class Group2ActionOP {
	int[] insert = new int[100];
	int groupid = -1;
	int num = 0;

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

	public boolean dataRequest(HttpServletRequest request) {
		try {
			//System.out.println(request.getParameter("groupID"));
			groupid = Integer.parseInt(request.getParameter("groupID"));
			GroupActionOP action = new GroupActionOP();
			int max = action.recordCount();
			for (int i = 0; i < max; i++) {
				if (request.getParameter("action" + i) != null) {
					insert[num] = Integer.parseInt(request
							.getParameter("action" + i));
					num++;
				}
			}
			return true;
		} catch (Exception ex) {
			ex.printStackTrace();
			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_GroupRelation where fld_GroupID='"
							+ groupid + "'");
			//System.out.println("SQL________:: " + bf.toString());
			dba.stmt.executeUpdate(bf.toString());
			bf.delete(0, bf.length());

			// TODO 将新选的权限加入数据库
			//System.out.println("num(Group2ActionOP): " + num);
			for (int i = 0; i < num; i++) {
				bf
						.append("insert into WAP_TEST.T_GroupRelation(fld_GroupID,fld_ActionID) values ('"
								+ groupid + "','" + insert[i] + "')");
				//System.out.println("bfAppend______SQL:: " + bf.toString());
				dba.stmt.executeUpdate(bf.toString());
				bf.delete(0, bf.length());
			}
			dba.close();
			return true;
		} catch (Exception ex) {
			return false;
		}
	}
}