logmanageimpl.java

本代码是一个权限管理系统源代码

/**
 * 
 */

	package com.seavision.PermissionManage.components;

import java.util.Date;
import java.sql.Connection;


import java.util.List;

import com.seavision.PermissionManage.help.HibernateUtil;
import com.seavision.PermissionManage.vo.LogVO;


import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

import java.util.Map;

import net.sf.hibernate.HibernateException;



public class LogManageImpl implements LogManage{
/**
 * 1.根据参数值，添加到日志表中
 */

	public void addLog( String operator, String  url, String ipAddress,String  actionName) {
	
		LogVO logVo = new LogVO();
		logVo.setActionName(actionName);
		logVo.setIpAddress(ipAddress);
		logVo.setLogDate(new Date());
		
		logVo.setOperator(operator);
		logVo.setUrl(url);
	
		HibernateUtil.save(logVo);
	
	}
/**
 * 2.从map中得到所需条件进行拼接，得到日志表的信息
 */
	public List getLogListByCondition(Map map) {
		
		List result = new ArrayList();
		if (map == null || map.size() == 0) {
			return result;
		}

		String companyId = "";//公司编号
		String departmentId = "";//部门编号
		String operator = "";//操作者
		String ipAddress = "";//IP地址
		String logDate = "";//日期
		
		companyId = (String)map.get("companyId");
		departmentId = (String)map.get("departmentId");
		operator = (String)map.get("operator");
		ipAddress = (String)map.get("ipAddress");
		logDate = (String)map.get("logDate");
		System.out.println("departmentId===="+departmentId);
		System.out.println("companyId===="+companyId);
		System.out.println("operator===="+operator);
		System.out.println("logDate===="+logDate);
		System.out.println("ipAddress===="+ipAddress);
	
		StringBuffer hql = new StringBuffer("select logVO from LogVO as logVO ");
		

		try {
			if (companyId.trim().equals("") && departmentId.trim().equals("")&& operator.trim().equals("")) {
				if(ipAddress.trim().equals("") && logDate.trim().equals("")){

					result = HibernateUtil.queryHQL(hql.toString());	
				} else {
					hql.append("where ");
					if (!ipAddress.trim().equals("")) {						
						hql.append("logVO.ipAddress = '"+ipAddress+"' ");
					}
					if(!ipAddress.trim().equals("")&&!logDate.trim().equals("")){
						hql.append("and ");
					}
					if (!logDate.trim().equals("")) {
						hql.append("logVO.logDate = '"+logDate+"' ");
					}
					
					result = HibernateUtil.queryHQL(hql.toString());
//					System.out.println("resultSize===="+result.size());
				}						
			} else {
				if(!companyId.trim().equals("")&& departmentId.trim().equals("")&& operator.trim().equals("")){
					hql.append(",UserVO as userVO where userVO.companyId = '"+companyId+"' and userVO.userName = logVO.operator ");
					if (!ipAddress.trim().equals("")) {						
						hql.append("and logVO.ipAddress = '"+ipAddress+"' ");
					}
					if (!logDate.trim().equals("")) {
						hql.append("and logVO.logDate = '"+logDate+"' ");
					}
					result = HibernateUtil.queryHQL(hql.toString());
				}
				if(!companyId.trim().equals("")&& !departmentId.trim().equals("")&& operator.trim().equals("")){
					hql.append(",UserVO as userVO where userVO.companyId = '"+companyId+"' and userVO.departmentId = '"+departmentId+"' and userVO.userName = logVO.operator ");
					if (!ipAddress.trim().equals("")) {						
						hql.append("and logVO.ipAddress = '"+ipAddress+"' ");
					}
					if (!logDate.trim().equals("")) {
						hql.append("and logVO.logDate = '"+logDate+"' ");
					}
					result = HibernateUtil.queryHQL(hql.toString());
//					System.out.println("resultSize===="+result.size());
				}
				if(!companyId.trim().equals("")&& !departmentId.trim().equals("")&& !operator.trim().equals("")){
					hql.append(" where logVO.operator = '"+operator+"' ");
					if (!ipAddress.trim().equals("")) {						
						hql.append("and logVO.ipAddress = '"+ipAddress+"' ");
					}
					if (!logDate.trim().equals("")) {
						hql.append("and logVO.logDate = '"+logDate+"' ");
					}
//					System.out.println("==hql=="+hql);
					result = HibernateUtil.queryHQL(hql.toString());
				}
				////////////////////////////
				if(companyId.trim().equals("")&& !departmentId.trim().equals("")&& !operator.trim().equals("")){
					hql.append(" where logVO.operator = '"+operator+"' ");
					if (!ipAddress.trim().equals("")) {						
						hql.append("and logVO.ipAddress = '"+ipAddress+"' ");
					}
					if (!logDate.trim().equals("")) {
						hql.append("and logVO.logDate = '"+logDate+"' ");
					}
//					System.out.println("==hql=="+hql);
					result = HibernateUtil.queryHQL(hql.toString());
				}
				if(companyId.trim().equals("")&& !departmentId.trim().equals("")&& operator.trim().equals("")){
					result = HibernateUtil.queryHQL(hql.toString());
				}
				////////////////////////////
				if(companyId.trim().equals("")&& departmentId.trim().equals("")&& !operator.trim().equals("")){
					hql.append(" where logVO.operator = '"+operator+"' ");
					if (!ipAddress.trim().equals("")) {						
						hql.append("and logVO.ipAddress = '"+ipAddress+"' ");
					}
					if (!logDate.trim().equals("")) {
						hql.append("and logVO.logDate = '"+logDate+"' ");
					}
//					System.out.println("==hql=="+hql);
					result = HibernateUtil.queryHQL(hql.toString());
				}
			}
			System.out.println("==hql=="+hql);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
//		System.out.println("resultSize===="+result.size());
		return result;
	}
}