reseop.java

Java实现权限管理

	
	public Vector SearchOw(HttpServletRequest request) {

		String pushpage = "";
		String allyid = "";
		String accessdate = "";
		String servicecode = "";

		try {
			StringBuffer bf = new StringBuffer();
			bf
					.append("select id,PushPage,ServiceCode,Mobile,AllyID,time_format(Accessdate,'%H') as acc,count(*) from DB_WAP.T_WapPush ");
			if (request != null) {
				pushpage = Strings
						.uniCodetoGB(request.getParameter("PushPage"));
				allyid = Strings.uniCodetoGB(request.getParameter("AllyID"));
				accessdate = Strings.uniCodetoGB(request
						.getParameter("AccessDate"));
				servicecode = Strings.uniCodetoGB(request
						.getParameter("ServiceCode"));
			}
			bf.append(" where PushPage='" + pushpage + "'");
			bf.append(" and ServiceCode='" + servicecode + "'");
			bf.append(" and AllyID='" + allyid + "'");
			bf.append(" and date_format(AccessDate,'%Y-%m-%d')='" + accessdate
					+ "'");
			bf.append(" group by time_format(Accessdate,'%H') ");
			bf.append(" order by time_format(Accessdate,'%H') desc ");
			DBManager dba = new DBManager();
			Connection conn = dba.getConnection();
			Statement stmt = conn.createStatement();
			ResultSet rs = stmt.executeQuery(bf.toString());
			Vector vec = new Vector();
			while (rs.next()) {
				Rese rese = new Rese();

				rese.setId(rs.getInt("id"));
				rese.setPushPage(rs.getString("PushPage"));
				rese.setServiceCode(rs.getString("ServiceCode"));
				rese.setMobile(rs.getString("Mobile"));
				rese.setAllyID(rs.getString("AllyID"));
				rese.setAccessDate(rs.getString("acc"));
				rese.setRecordCount(rs.getInt(7));
				
				vec.add(rese);
			}
			return vec;
		} catch (Exception e) {
			e.printStackTrace();
			e.toString();
			System.out.println("error..............");
			return null;
		}
	}

	public Vector SearchAmply(HttpServletRequest request) {

		String pushpage = "";
		String allyid = "";
		String accessdate = "";
		String servicecode = "";
		String accdate = "";
		try {
			StringBuffer bf = new StringBuffer();
			if (request != null) {
				pushpage = Strings
						.uniCodetoGB(request.getParameter("PushPage"));
				allyid = Strings.uniCodetoGB(request.getParameter("AllyID"));
				accessdate = Strings.uniCodetoGB(request
						.getParameter("AccessDate"));
				servicecode = Strings.uniCodetoGB(request
						.getParameter("ServiceCode"));
				accdate = Strings.uniCodetoGB(request.getParameter("assdate"));
			}
			bf.append("select id,PushPage,ServiceCode,Mobile,AllyID,");
			bf.append("time_format(Accessdate,'%H:%i:%S') as acce ");
			bf.append(" from DB_WAP.T_WapPush ");
			bf.append(" where time_format(Accessdate,'%H')='" + accessdate
					+ "'");
			bf.append(" and date_format(Accessdate,'%Y-%m-%d')='" + accdate
					+ "'");
			bf.append(" and PushPage='" + pushpage + "'");
			bf.append(" and ServiceCode='" + servicecode + "'");
			bf.append(" and AllyID='" + allyid + "'");
			bf.append(" order by time_format(Accessdate,'%H:%i:%S') desc ");

			DBManager db = new DBManager();
			Connection conn = db.getConnection();
			Statement stmt = conn.createStatement();
			ResultSet rs = stmt.executeQuery(bf.toString());
			Vector vec = new Vector();
			while (rs.next()) {
				Rese re = new Rese();

				re.setId(rs.getInt("id"));
				re.setPushPage(rs.getString("PushPage"));
				re.setServiceCode(rs.getString("ServiceCode"));
				re.setMobile(rs.getString("Mobile"));
				re.setAllyID(rs.getString("AllyID"));
				re.setAccessDate(rs.getString("acce"));
				
				vec.add(re);
			}
			return vec;
		} catch (Exception e) {
			e.printStackTrace();
			System.out.println("error.............");
			return null;
		}
	}

	public Vector Searchre(HttpServletRequest request) {

		String pushpage = "";
		String allyid = "";
		String accessdate = "";
		String servicecode = "";
		String accdate = "";
		
		String allyidrequest = "";
		String pushpage2 = "";
		String servicecode2 = "";
		String accessdate2 = "";
		
		HttpSession session = request.getSession();
		allyid = (String) session.getAttribute("allyID");

		try {
			StringBuffer bf = new StringBuffer();
			bf.append("select id,PushPage,ServiceCode,Mobile,AllyID,date_format(AccessDate,'%Y-%m-%d') as ac,count(*) ");
			bf.append(" from DB_WAP.T_WapPush where AllyID='"+allyid+"' and Mobile is not null and Mobile != 0 ");
			String sql = "";
			int ii = 0;
			if (request.getContentLength() > 1) {
				pushpage = Strings
						.uniCodetoGB(request.getParameter("pushPage"));
//				allyid = (String) session.getAttribute("allyID");
				allyidrequest = Strings.uniCodetoGB(request.getParameter("allyID"));
				accessdate = Strings.uniCodetoGB(request.getParameter("accessDate"));
				servicecode = Strings.uniCodetoGB(request.getParameter("serviceCode"));
				session.setAttribute("pushPage", pushpage);
				session.setAttribute("serviceCode", servicecode);
				session.setAttribute("accessDate", accessdate);
				if (pushpage.equals("") == false) {
					sql = sql + " and  PushPage='" + pushpage + "'";
					ii = ii + 1;
				}
				if (servicecode.equals("") == false) {
					sql = sql + " and  ServiceCode='" + servicecode + "'";
					ii = ii + 1;
				}
//				if (Integer.parseInt(String.valueOf(allyid)) == 0) {
//					if (allyidrequest.equals("") == false) {
//						sql = sql + " and AllyID='" + allyidrequest + "'";
//						ii = ii + 1;
//					} else {
//					}
//				} else {
//					if (allyid.equals("") == false) {
//						sql = sql + " and AllyID='" + allyid + "'";
//						ii = ii + 1;
//					} else {
//						sql = sql + " and AllyID='" + allyidrequest + "'";
//						ii = ii + 1;
//					}
//				}
				if (accessdate.equals("") == false) {
					sql = sql + " and AccessDate='" + accessdate + "'";
					ii = ii + 1;
				}
				int j = 0;
				String buffer = "";
				if (pushpage.length() < 1) {
					pushpage2 = pushpage;
					if (pushpage.equals("") == true) {
					} else {
						buffer = buffer + " and PushPage='" + pushpage2 + "'";
						j = j + 1;
					}
				} else if (session.getAttribute("pushPage").equals("") == false) {
					pushpage2 = (String) session.getAttribute("pushPage");
					buffer = buffer + " and PushPage='" + pushpage2 + "'";
					j = j + 1;
				}
				if (Integer.parseInt(String.valueOf(allyid)) == 0) {
					if (allyidrequest.equals("") == false
							&& allyid.equals("") == false) {
						buffer = buffer + " and AllyID='" + allyidrequest + "'";
						j = j + 1;
					}
				} else {
					if (allyidrequest.length() < 1
							&& allyid.equals("") == false) {
						buffer = buffer + " and AllyID='" + allyid + "'";
						j = j + 1;
					}
				}
				if (servicecode.length() < 1
						&& session.getAttribute("serviceCode").equals("") == false) {
					servicecode2 = (String) session.getAttribute("serviceCode");
					buffer = buffer + " and ServiceCode='" + servicecode2 + "'";
					j = j + 1;
				}
				if (accessdate.length() < 1
						&& session.getAttribute("accessDate").equals("") == false) {
					accessdate2 = (String) session.getAttribute("accessDate");
					buffer = buffer + " and AccessDate='" + accessdate2 + "'";
					j = j + 1;
				}

				if (ii > 0) {
//					if (sql.startsWith(" and")) {
//						sql = sql.substring(4, sql.length());
//					}
//					bf.append(" where ");
					bf.append(sql);
				} else if (j > 0) {
//					if (buffer.startsWith(" and")) {
//						buffer = buffer.substring(4, buffer.length());
//					}
//					bf.append(" where ");
					bf.append(buffer);
				}
			}
			bf.append(" group by PushPage,ServiceCode,AllyID,date_format(AccessDate,'%Y-%m-%d') ");
			bf.append(" order by date_format(AccessDate,'%Y-%m-%d') desc ");
			System.out.println(bf.toString());
			DBManager dba = new DBManager();
			Connection conn = dba.getConnection();
			Statement stmt = conn.createStatement();
			ResultSet rs = stmt.executeQuery(bf.toString());
			Vector vec = new Vector();
			while (rs.next()) {
				Rese rese = new Rese();

				rese.setId(rs.getInt("id"));
				rese.setPushPage(rs.getString("PushPage"));
				rese.setServiceCode(rs.getString("ServiceCode"));
				rese.setMobile(rs.getString("Mobile"));
				rese.setAllyID(rs.getString("AllyID"));
				rese.setAccessDate(rs.getString("ac"));
				rese.setRecordCount(rs.getInt(7));
				vec.add(rese);
			}
			System.out.println("System.currentTimeMillis(): "+System.currentTimeMillis());
			return vec;
		} catch (Exception e) {
			e.printStackTrace();
			System.out.println("error..............");
			return null;
		}
	}

	public static void main(String args[]) {
		ReseOP re = new ReseOP();
		re.Searchre(null);

	}

}