queryservice.java

中应用程序的访问权限对Java Web Console 中应用程序的访问权限 成功登录 Web 控制台后,可能无法自动访问在该控制台中注册的所有应用程序。通常,必须安装应用程序,才能让所有的用户在控制

package edu.yinhe.mis.services;

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

import edu.yinhe.mis.dto.QueryDTO;
import edu.yinhe.mis.model.DAOFactory;
import edu.yinhe.system.common.AppException;
import edu.yinhe.system.model.IBaseDAO;
import edu.yinhe.system.services.Service;
/**
 * 
 * @author 王熙亮
 *
 */
public class QueryService extends Service {
	private IBaseDAO QueryDAO=null;
	public Object load(Object obj) throws AppException {
		   QueryDTO dto = new QueryDTO();
		   Object[] objs = null;
		   try {
			dto = (QueryDTO) obj;
			QueryDAO = DAOFactory.getQueryDAO(conn);
			objs = (Object[]) QueryDAO.findById(dto);
		} catch (SQLException e) {
			try {
				conn.rollback();
			} catch (SQLException e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			}
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
		  closeConnection();
		  dto = null;
		  QueryDAO = null;
		}
		   
		return objs;
		}
	public Object alllist() throws AppException {
		// TODO Auto-generated method stub
		return null;
	}
	public Object list(Object obj) throws AppException {
		QueryDTO dto = new QueryDTO();
		 Object[] objs = new Object[2];
		try {
			dto = (QueryDTO) obj;
			QueryDAO = DAOFactory.getQueryDAO(conn);
			objs = (Object[]) QueryDAO.find(dto);
		} catch (SQLException e) {
			try {
				conn.rollback();
			} catch (SQLException e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			}
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			closeConnection();
			dto = null;
			QueryDAO = null;
		}
		return objs;
	}
	public Object alllist(Object obj) throws AppException {
	    QueryDTO queryDTO = new QueryDTO();
	    Object[] objs = new Object[2];

	    try {
			queryDTO = (QueryDTO) obj;
			QueryDAO = DAOFactory.getQueryDAO(conn);
			objs = (Object[]) QueryDAO.findAll(queryDTO);
		} catch (SQLException e) {
			try {
				conn.rollback();
			} catch (SQLException e1) {
				throw new AppException(e.getMessage()+"危险！");
			}
			e.printStackTrace();
		} finally{
			closeConnection();
			queryDTO = null;
			QueryDAO = null;
		
			
		}
		return objs;
	
	}
	public Object create(Object obj) throws AppException {
		QueryDTO dto = new QueryDTO();
		boolean flag = false;
		try {
			dto = (QueryDTO) obj;
			QueryDAO = DAOFactory.getQueryDAO(conn);
			 flag = (Boolean) QueryDAO.delete(dto);
		} catch (RuntimeException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return flag;
	}
	public Object findAll() throws AppException {
		// TODO Auto-generated method stub
		return null;
	}
	public Object findAll(Object arg0) throws AppException {
		// TODO Auto-generated method stub
		return null;
	}
	public Object findById(Object obj) throws AppException {
		QueryDTO dto = new QueryDTO();
		ArrayList list = new ArrayList();
		try {
			dto = (QueryDTO) obj;
			QueryDAO = DAOFactory.getQueryDAO(conn);
			 list = (ArrayList) QueryDAO.findByObject(dto);
		} catch (SQLException e) {
			try {
				conn.rollback();
			} catch (SQLException e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			}
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			closeConnection();
			dto = null;
			QueryDAO = null;
		}
		return list;
	}
	public Object findByObject(Object arg0) throws AppException {
		// TODO Auto-generated method stub
		return null;
	}
	public int getcount() throws AppException {
		// TODO Auto-generated method stub
		return 0;
	}
	public int getcount(Object arg0) throws AppException {
		// TODO Auto-generated method stub
		return 0;
	}
	public Object list() throws AppException {
		// TODO Auto-generated method stub
		return null;
	}
	public Object modify(Object arg0) throws AppException {
		// TODO Auto-generated method stub
		return null;
	}
	public Object remove(Object arg0) throws AppException {
		// TODO Auto-generated method stub
		return null;
	}
}