groupop.java

Java实现权限管理

package cn.com.wap.relaOP;

import javax.servlet.http.HttpServletRequest;

import cn.com.wap.rela.Group;
import cn.com.wap.role.DBManager;
import java.sql.*;
import java.lang.Integer;
import java.util.Vector;
import cn.com.wap.rela.User2Group;
import cn.com.wap.rela.User;
import cn.com.wap.util.Strings;

public class GroupOP {

	public boolean insert(HttpServletRequest request) {

		DBManager db = new DBManager();

		String groupname = Strings.uniCodetoGB(request
				.getParameter("groupName"));
		StringBuffer bf = new StringBuffer();
		bf.append("insert into WAP_TEST.T_Group(fld_GroupName) values ('"
				+ groupname + "')");

		//System.out.println("bfSQL____________: " + bf.toString());
		return db.execsql(bf.toString());
	}

	public Vector search(HttpServletRequest request) {
		Vector vc = new Vector();

		StringBuffer bf = new StringBuffer();
		bf.append("select fld_GroupID,fld_GroupName from WAP_TEST.T_Group ");
		String groupname = "";
		groupname = Strings.uniCodetoGB(request.getParameter("groupName"));
		try {
			if (request != null) {
				groupname = Strings.uniCodetoGB(request
						.getParameter("groupName"));
				if (groupname.equals("") == false) {
					bf.append(" where fld_GroupName = '" + groupname + "'");
				}
			}
			//System.out.println("SelectGroup::: " + bf.toString());
			DBManager dba = new DBManager();
			//System.out.println("vvvvvvvvvvvvvvvvvvvvvvvvvv");
			dba.executesqlret(bf.toString());
			//System.currentTimeMillis();
			while (dba.rs.next()) {
				Group group = new Group();
				group.setFld_GroupID(dba.rs.getInt(1));
				group.setFld_GroupName(dba.rs.getString(2));
				vc.add(group);
			}

			dba.close();
			return vc;
		} catch (SQLException ex) {
			ex.printStackTrace();
			//System.out.println("executeSQL error.................");
			return null;
		}
	}

	public Vector searchOwner(HttpServletRequest request) {
		Vector vc = new Vector();
		int userid = Integer.parseInt(request.getParameter("userID"));
		StringBuffer bf = new StringBuffer();

		bf.append("select ug.fld_UserID,gr.fld_GroupID,gr.fld_GroupName ");
		bf.append(" from WAP_TEST.T_User2Group ug ,WAP_TEST.T_Group gr ");
		bf.append(" where gr.fld_GroupID = ug.fld_GroupID ");
		bf.append("and ug.fld_UserID='" + userid + "'");

		// bf.append("select ug.fld_UserID,gr.fld_GroupID,gr.fld_GroupName ");
		// bf.append(" from WAP_TEST.T_User2Group ug,WAP_TEST.T_Group
		// gr,WAP_TEST.T_User u ");
		// bf.append(" where ug.fld_UserID='" + userid + "'");
		// bf.append(" and ug.fld_GroupID = gr.fld_GroupID");

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

				ug.setFld_userID(dba.rs.getInt(1));
				ug.setFld_GroupID(dba.rs.getInt(2));
				User user = new User();
				user.setUserID(dba.rs.getInt(1));

				//System.out.println("ug.userID: " + dba.rs.getInt(1)
				//		+ " ::: gr.fld_GroupID: " + dba.rs.getInt(2));
				// //System.out.println("user.setUserID: " + user.getUserID());
				vc.add(ug);
			}
			dba.close();
			return vc;
		} catch (SQLException ex) {
			ex.printStackTrace();
			//System.out.println("executeSQL error.................");
			return null;
		}
	}

	public Vector SearchTest() {
		Vector vec = new Vector();

		StringBuffer bf = new StringBuffer();
		bf
				.append("select fld_UserID,fld_GroupID from WAP_TEST.T_User2Group WAP_TEST.T_Group where ");
		return vec;
	}

	public boolean delete(HttpServletRequest request) {
		String groupid = "";
		groupid = Strings.uniCodetoGB(request.getParameter("groupID"));
		//System.out.println("}}}}}}}}}}}}}}}::: " + groupid);
		StringBuffer bf = new StringBuffer();
		bf
				.append("delete from WAP_TEST.T_Group where fld_GroupID = "
						+ groupid);
		DBManager dba = new DBManager();

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

	public boolean update(HttpServletRequest request) {

		Group group = new Group();
		group.setFld_GroupID(Integer.parseInt(request.getParameter("groupID")));
		group.setFld_GroupName(Strings.uniCodetoGB(request
				.getParameter("groupName")));

		StringBuffer bf = new StringBuffer();
		bf.append("update WAP_TEST.T_Group set ");
		bf.append(" fld_GroupName='" + group.getFld_GroupName() + "'");
		bf.append(" where fld_GroupID='" + group.getFld_GroupID() + "'");
		//System.out.println("bfUpdateSQL__________: " + bf.toString());
		DBManager dba = new DBManager();

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

	public Vector updateSearch(HttpServletRequest request) {

		int groupid = -1;
		groupid = Integer.parseInt(request.getParameter("groupID"));
		StringBuffer bf = new StringBuffer();
		bf
				.append("select * from WAP_TEST.T_Group where fld_GroupID="
						+ groupid);
		try {
			DBManager dba = new DBManager();
			dba.executesqlret(bf.toString());
			Vector vec = new Vector();
			while (dba.rs.next()) {
				Group group = new Group();
				group.setFld_GroupID(dba.rs.getInt(1));
				group.setFld_GroupName(dba.rs.getString(2));
				vec.add(group);
			}
			return vec;
		} catch (SQLException ex) {
			ex.printStackTrace();
			//System.out.println("updateSearchSQL_________: " + ex.getMessage());
			return null;
		}
	}

	public int recordCount() {

		int recordcount = -1;

		StringBuffer bf = new StringBuffer();
		bf.append("select count(*) from WAP_TEST.T_Group ");
		//System.out.println("bf(GroupOP)recordCountSQL: " + bf.toString());
		try {
			DBManager dba = new DBManager();
			dba.executesqlret(bf.toString());
			if (dba.rs.next()) {
				recordcount = dba.rs.getInt(1);
				//System.out.println("bf(GroupOP)recordCount: "
				//		+ dba.rs.getInt(1));
			}
			return recordcount;
		} catch (SQLException ex) {
			ex.printStackTrace();
			//System.out.println("error.............");
			return -1;
		}
	}
}