groupactionop.java

Java实现权限管理

package cn.com.wap.relaOP;

import java.sql.*;
import javax.servlet.http.*;
import cn.com.wap.role.DBManager;
import cn.com.wap.rela.GroupAction;
import cn.com.wap.rela.Pri;

import java.util.Vector;
import cn.com.wap.rela.Group2Action;
import cn.com.wap.util.*;

public class GroupActionOP {

	public boolean insert(HttpServletRequest request) {

		String actionName = "";
		String actionUrl = "";
		int pri = -1;
		actionName = Strings.uniCodetoGB(request.getParameter("ActionName"));
		actionUrl = Strings.uniCodetoGB(request.getParameter("ActionUrl"));
		pri = Integer.parseInt(request.getParameter("Pri"));

		StringBuffer bf = new StringBuffer();
		bf
				.append("insert into WAP_TEST.T_GroupAction (fld_ActionName,fld_URL,fld_PRI) values ('"
						+ actionName + "',");
		bf.append("'" + actionUrl + "',");
		bf.append("'"+ pri +"')");

		//System.out.println("BFAPPEND___SQL: " + bf.toString());
		DBManager dba = new DBManager();

		return dba.execsql(bf.toString());
	}

	public Vector search(HttpServletRequest request) {

		try {
			String actionname = "";
			StringBuffer bf = new StringBuffer();
			bf.append("select * from WAP_TEST.T_GroupAction");
			if (request != null) {
				actionname = Strings.uniCodetoGB(request
						.getParameter("actionName"));
				//System.out.println("uuuuuuuuu::: " + actionname);
				if (actionname.equals("") == false) {
					bf.append(" where fld_ActionName='" + actionname + "'");
				}
			}
			bf.append(" order by T_GroupAction.fld_PRI,T_GroupAction.fld_ActionID ");
			//System.out.println("5555555555555555555555555555: "+bf.toString());
			DBManager dba = new DBManager();
			dba.executesqlret(bf.toString());
			Vector vec = new Vector();
			while (dba.rs.next()) {
				GroupAction action = new GroupAction();
				action.setFld_ActionID(dba.rs.getInt(1));
				action.setFld_ActionName(dba.rs.getString(2));
				action.setFld_URL(dba.rs.getString(3));
				action.setFld_PRI(dba.rs.getInt(4));
				vec.add(action);
			}
			dba.close();
			return vec;
		} catch (Exception ex) {
			ex.printStackTrace();
			//System.out.println("search___Error...........");
			return null;
		}
	}

	public Vector searchOwner(HttpServletRequest request) {
		Vector vec = new Vector();
		int groupid = Integer.parseInt(request.getParameter("groupID"));
		StringBuffer bf = new StringBuffer();

		//System.out.println("groupid::::::: " + groupid);

		bf.append("select rel.fld_GroupID,ga.fld_ActionID,ga.fld_ActionName ");
		bf
				.append(" from WAP_TEST.T_GroupRelation rel,WAP_TEST.T_GroupAction ga ");
		bf.append(" where ga.fld_ActionID = rel.fld_ActionID ");
		bf.append(" and rel.fld_GroupID='" + groupid + "'");

		try {
			//System.out.println("SQL: " + bf.toString());
			DBManager dba = new DBManager();
			dba.executesqlret(bf.toString());
			while (dba.rs.next()) {

				Group2Action gta = new Group2Action();
				gta.setFld_GroupID(dba.rs.getInt(1));
				gta.setFld_ActionID(dba.rs.getInt(2));
				
				vec.add(gta);
				////System.out.println("vec.add(): " + vec.toString());
			}
			dba.close();
			return vec;
		} catch (Exception ex) {
			ex.printStackTrace();
			//System.out.println("error.................");
			return null;
		}
	}

	public boolean delete(HttpServletRequest request) {

		int actionid = -1;
		actionid = Integer.parseInt(request.getParameter("ActionID"));
		//System.out.println("actionid_______: " + actionid);

		StringBuffer bf = new StringBuffer();
		bf.append("delete from WAP_TEST.T_GroupAction where fld_ActionID='"
				+ actionid + "'");

		//System.out.println("BFDeleteSQL_______: " + bf.toString());

		DBManager dba = new DBManager();
		return dba.execsql(bf.toString());
	}

	public boolean update(HttpServletRequest request) {

		int actionid = -1;
		String actionName = "";
		String actionUrl = "";
		int actionpri = -1;
		//System.out.println(request.getParameter("ActionID"));
		actionid = Integer.parseInt(request.getParameter("ActionID"));
		actionName = Strings.uniCodetoGB(request.getParameter("ActionName"));
		actionUrl = Strings.uniCodetoGB(request.getParameter("ActionUrl"));
		actionpri = Integer.parseInt(request.getParameter("Pri"));

		StringBuffer bf = new StringBuffer("update WAP_TEST.T_GroupAction set ");
		bf.append("fld_ActionName='" + actionName + "',");
		bf.append("fld_URL='" + actionUrl + "',");
		bf.append("fld_PRI='"+ actionpri +"' ");
		bf.append(" where fld_ActionID='" + actionid + "'");

		//System.out.println("BF.APPENDSQL________: " + bf.toString());

		DBManager dba = new DBManager();

		return dba.execsql(bf.toString());
	}

	public Vector updateSearch(HttpServletRequest request) {

		int actionid = -1;
		actionid = Integer.parseInt(request.getParameter("ActionID"));
		//System.out.println(actionid);
		StringBuffer bf = new StringBuffer();
		try {
			bf
					.append("select * from WAP_TEST.T_GroupAction where fld_ActionID='"
							+ actionid + "'");
			DBManager dba = new DBManager();
			dba.executesqlret(bf.toString());
			Vector vec = new Vector();
			while (dba.rs.next()) {
				GroupAction groupaction = new GroupAction();
				groupaction.setFld_ActionID(dba.rs.getInt(1));
				groupaction.setFld_ActionName(dba.rs.getString(2));
				groupaction.setFld_URL(dba.rs.getString(3));
				groupaction.setFld_PRI(dba.rs.getInt(4));

				vec.add(groupaction);
			}
			return vec;
		} catch (SQLException ex) {
			ex.printStackTrace();
			//System.out.println("UpdateSearchSQL....error....");
			return null;
		}
	}

	public int recordCount() {
		try {
			int recordcount = -1;

			StringBuffer bf = new StringBuffer(
					"select count(*) from WAP_TEST.T_GroupAction");

			//System.out.println("bf(GroupActionOP)recordCountSQL: "
			//		+ bf.toString());
			DBManager dba = new DBManager();
			dba.executesqlret(bf.toString());
			if (dba.rs.next()) {
				recordcount = dba.rs.getInt(1);
				//System.out.println("bf(GroupActionOP)recordCountSQL: "
				//		+ dba.rs.getInt(1));
			}
			return recordcount;
		} catch (SQLException e) {
			return -1;
		}
	}
	
	public static void main(String args[]){
		GroupActionOP gap = new GroupActionOP();
//		gap.search(null);
	}
}