schoolservice.java

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

package edu.yinhe.mis.services;

/**
 * @author 李亭 <p>
 * 下面给出如何调用Service中删除方法的例子
 * <p>
 * 	<blockquote>
 * 		<pre>
 * 			SchoolService schoolservice =SchoolService();
 * 			schoolservice.remove(obj);
 * 		</pre>
 * 	</blockquote>
 * @version	jdk1.6.0_03
 * @since 从jdk1.0版本开始	
 */

import java.sql.SQLException;
import java.util.ArrayList;
import edu.yinhe.system.common.AppException;
import edu.yinhe.mis.model.DAOFactory;
import edu.yinhe.mis.vo.SchoolVO;
import edu.yinhe.system.model.IBaseDAO;
import edu.yinhe.system.services.Service;

public class SchoolService extends Service {
	
	private IBaseDAO SchoolDAO = null;
	private IBaseDAO RoomDAO = null;
	private IBaseDAO DictionaryDAO = null;
	private IBaseDAO ClassesDAO = null;
	public Object alllist() throws AppException {
		// TODO Auto-generated method stub
		return null;
	}

	/**
	 * @author 李亭 <p>
	 * Creation date:04-30-2008
	 * 根据条件查询schools表中的相应信息
	 * @param obj 传入SchoolDTO对象
	 *@throws AppException
	 * @return objs 返回一个objs数组 objs[0]为信息集合;objs[1]为集合的总记录数;			
	 */
	public Object alllist(Object obj) throws AppException {
		Object[] objs = null;
		try {
			IBaseDAO SchoolDAO = DAOFactory.getSchoolDAO(conn);
			objs = (Object[]) SchoolDAO.findAll(obj);
		} catch (SQLException e) {
			try {
				conn.rollback();
			} catch (SQLException e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			}
			e.printStackTrace();
		}finally{
			closeConnection(); 
		}
		return objs;
	}

	/**
	 * @author 李亭 <p>
	 * Creation date:04-30-2008
	 * 查询schools表中的信息的总条数
	 * @param obj 传入SchoolDTO对象
	 *@throws AppException
	 * @return 	integer 当为1表示插入数据库成功 为0就表示插入失败
	 */
	public Object create(Object obj) throws AppException {
		SchoolDAO = DAOFactory.getSchoolDAO(conn);
		Integer create = 0;
		try {
			SchoolDAO.insert(obj);
			create=1;
		} catch (SQLException e) {
			try {
				conn.rollback();
			} catch (SQLException e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			}
			e.printStackTrace();
		}finally{
			closeConnection(); 
			SchoolDAO = null;
		}
		return create;
	}

	public Object findAll() throws AppException {
		// TODO Auto-generated method stub
		return null;
	}

	/**
	 * @author 李亭 <p>
	 * Creation date:05-08-2008        
	 * 同时本身也可以通过schoolName来查询信息
	 * @param obj 传入SchoolDTO对象
	 *@throws AppException
	 * @return list 
	 * 当是本模块调用时，list.size()为0则表示该名称可用；不为0就表示该名称不可用		
	 */
	public Object findAll(Object obj) throws AppException {
		SchoolDAO = DAOFactory.getSchoolDAO(conn);
		ArrayList list = null;
		try {
			list = (ArrayList) SchoolDAO.getMaxId(obj);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			closeConnection();
			SchoolDAO = null;
		}
		return list;
	}

	/**
	 * @author 李亭 <p>
	 * Creation date:05-04-2008
	 * 根据ID获得该条信息
	 * @param obj ID
	 *@throws AppException
	 * @return ClassesVO 返回ClassesVO对象;			
	 */
	public Object findById(Object obj) throws AppException {
		SchoolVO schoolvo = null;
		try {
			IBaseDAO SchoolDAO = DAOFactory.getSchoolDAO(conn);
			schoolvo = (SchoolVO) SchoolDAO.findById(obj);
		} catch (SQLException e) {
			try {
				conn.rollback();
			} catch (SQLException e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			}
			e.printStackTrace();
		}finally{
			closeConnection(); 
		}
		return schoolvo;
	}

	/**
	 * @author 李亭 <p>
	 * Creation date:04-30-2008        
	 * 查询schools表中的信息提供给其他模块调用 同时本身也可以通过schoolNo来查询信息
	 * @param obj 传入SchoolDTO对象
	 *@throws AppException
	 * @return list 当是提供给其他模块调用的时候是列表集合，调用者可以提取需要的信息使用。
	 * 当是本模块调用时，list.size()为0则表示该编号可用；不为0就表示该编号不可用		
	 */
	public Object findByObject(Object obj) throws AppException {
		SchoolDAO = DAOFactory.getSchoolDAO(conn);
		ArrayList list = null;
		try {
			list = (ArrayList) SchoolDAO.findByObject(obj);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			closeConnection();
			SchoolDAO = null;
		}
		return list;
	}

	public int getcount() throws AppException {
		// TODO Auto-generated method stub
		return 0;
	}

	public int getcount(Object obj) throws AppException {
		// TODO Auto-generated method stub
		return 0;
	}

	public Object list() throws AppException {
		// TODO Auto-generated method stub
		return null;
	}

	/**
	 * @author 李亭 <p>
	 * Creation date:05-06-2008
	 * 根据传入的 参数 查询出需要的信息
	 * @param obj ID
	 *@throws AppException
	 * @return objs 返回Object[]数组对象;			
	 */
	public Object list(Object obj) throws AppException {
		Object[] objs = null;
		try {

			DictionaryDAO = DAOFactory.getDictionaryDAO(conn);
			objs = (Object[]) DictionaryDAO.findAll(obj);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			closeConnection();
			DictionaryDAO = null;
		}
		return objs;
	}

	public Object load(Object obj) throws AppException {
		// TODO Auto-generated method stub
		return null;
	}

	/**
	 * @author 李亭 <p>
	 * Creation date:05-05-2008
	 * 根据ID修改校区信息
	 * @param obj 传入ClassesDTO对象
	 *@throws AppException
	 * @return 	integer 当为1表示修改数据成功 为0就表示修改失败
	 */
	public Object modify(Object obj) throws AppException {
		SchoolDAO = DAOFactory.getSchoolDAO(conn);
		Integer modify = 0;
		try {
			SchoolDAO.update(obj);
			modify=1;
		} catch (SQLException e) {
			try {
				conn.rollback();
			} catch (SQLException e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			}
			e.printStackTrace();
		}finally{
			closeConnection(); 
			SchoolDAO = null;
		}
		return modify;
	}

	/**
	 * @author 李亭 <p>
	 * Creation date:04-30-2008
	 * 根据schoolNo删除schools表中的相应信息
	 * @param obj 传入schoolNo
	 *@throws AppException
	 * @return delete 返回一个Integer类型起值为1则删除成功 为0则删除不成功
	 */
	public Object remove(Object obj) throws AppException {
		SchoolDAO = DAOFactory.getSchoolDAO(conn);
		RoomDAO = DAOFactory.getRoomDAO(conn);
		ClassesDAO = DAOFactory.getClassesDAO(conn);
		Integer remove = 0;
		try {
			SchoolDAO.delete(obj);
			remove=1;
			RoomDAO.delete(obj);
			
		} catch (SQLException e) {
			try {
				conn.rollback();
			} catch (SQLException e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			}
			e.printStackTrace();
		}finally{
			closeConnection(); 
			SchoolDAO = null;
			RoomDAO = null;
			ClassesDAO = null;
		}
		return remove;
	}



}