reseop.java

Java实现权限管理

package cn.com.wap.reseOP;

import cn.com.wap.rese.Rese;
import cn.com.wap.util.Strings;
import java.util.Vector;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.Timestamp;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import cn.com.wap.role.DBManager;

public class ReseOP {
	
	public Vector Search(HttpServletRequest request){


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

		String pushpage2 = "";
		String allyidrequest = "";
		String accessdate2 = "";
		String servicecode2 = "";

		HttpSession session = request.getSession();
		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 ");
			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("bfSQL__________: "+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);
			}
			return vec;
		} catch (Exception e) {
			e.printStackTrace();
			e.toString();
			System.out.println("error..............");
			return null;
		}
	
	}
	
	public Vector QueryResource(HttpServletRequest request){


		String pushpage = "";
		String accessdate = "";
		String servicecode = "";
		String pushpage2 = "";
		String accessdate2 = "";
		String servicecode2 = "";
		HttpSession session = null;
		try {
			
			StringBuffer bf = new StringBuffer();
			bf.append("select id,PushPage,ServiceCode,Mobile,AllyID,date_format(AccessDate,'%Y-%m-%d') as ac,count(tw.id),ts.fld_ServiceCost ");
			bf.append(" from DB_WAP.T_WapPush tw,DB_WAP.T_Service ts where tw.ServiceCode = ts.fld_ServiceCode ");
			bf.append(" and AllyID='0' and Mobile is not null and Mobile != 0  ");
			String sql = "";
			int ii = 0;
			if (request.getContentLength() > 1) {
				pushpage = Strings
						.uniCodetoGB(request.getParameter("pushPage"));
				accessdate = Strings.uniCodetoGB(request
						.getParameter("accessDate"));
				servicecode = Strings.uniCodetoGB(request
						.getParameter("serviceCode"));

				if (pushpage.equals("") == false) {
					sql = sql + " and PushPage='" + pushpage + "'";
					ii = ii + 1;
				}
				if (accessdate.equals("") == false) {
					sql = sql + " and AccessDate='" + accessdate + "'";
					ii = ii + 1;
				}
				if (servicecode.equals("") == false) {
					sql = sql + " and ServiceCode='" + servicecode + "'";
					ii = ii + 1;
				}
				if (ii > 0) {
					bf.append(sql);
				}
			} else if (request.getContentLength() < 1) {
				int j = 0;
				String buffer = "";

				if (pushpage.length() < 1
						&& session.getAttribute("pushPage").equals("") == false) {
					pushpage2 = (String) session.getAttribute("pushPage");
					buffer = buffer + " and PushPage='" + pushpage2 + "'";
					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 (j > 0) {
					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("SQL: "+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));
				
				rese.setRecordCostCound(rs.getInt(8)*rs.getInt(7));
				vec.add(rese);

			}
			return vec;
		} catch (Exception e) {
			e.toString();
			System.out.println("error..........");
			return null;
		}
	
	}