roomdao.java

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

/**
 * 
 */
package edu.yinhe.mis.model;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import edu.yinhe.mis.dto.RoomDTO;
import edu.yinhe.mis.vo.RoomVO;
import edu.yinhe.system.model.BaseDAO;
import edu.yinhe.system.model.IBaseDAO;

/**
 * @author 陈忠
 * Creation date:04-30-2008 
 */
public class RoomDAO extends BaseDAO {
	
	/**
	 * 根据schoolno，删除room表中的信息
	 *@throws SQLException
	 * @param arg0 roomDTO对象
	 * @return flag 删除成功返回true，反之为false。
	 * @author 陈忠
	 * Creation date:04-30-2008 
	 */
	public Object delete(Object obj) throws SQLException {
		boolean flag=false;
		String sql=null;
		String sno = (String) obj;
		PreparedStatement ps=null;
		StringBuffer strbuf=new StringBuffer("DELETE FROM room WHERE SCHOOL_NO='"+sno+"'");
		
		sql=strbuf.toString();
		ps = conn.prepareStatement(sql);
		ps.executeUpdate();
		flag=true;
		
		if(ps!=null)ps=null;
		return flag;
	}

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

	/**
	 * 根据id，删除room表中的信息
	 *@throws SQLException
	 * @param arg0 id号
	 * @return flag 删除成功返回true，反之为false。
	 * @author 陈忠
	 * Creation date:04-30-2008 
	 */
	public Object find(Object arg0) throws SQLException {
		boolean flag=false;
		String sql=null;
		String oid=(String)arg0;
		String []str=oid.split(" ");
		PreparedStatement ps=null;
		sql="DELETE FROM room WHERE id=?";
		ps = conn.prepareStatement(sql);
		if(str!=null){
			for(int i=0;i<str.length;i++){
				if(str[i]!=null&&!"".equals(str[i])){
					ps.setInt(1,Integer.parseInt(str[i]));
					ps.executeUpdate();
				}
			}
		}
		flag=true;
		
		if(ps!=null)ps=null;
		return flag;
	}

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

	/**
	 * 查询room表中的所有信息
	 * @param arg0 传入RoomDTO对象
	 *@throws SQLException
	 * @return obj 查询完成，返回Object[]的数组。
	 *  @author 陈忠
	 * Creation date:04-30-2008
	 */
	public Object findAll(Object arg0) throws SQLException {
		ArrayList list=new ArrayList();
		Integer count =new Integer(0);
		Object[] objs=new Object[2];
		String sql=null;
		RoomVO roomVO=null;
		PreparedStatement ps=null;
		ResultSet rs=null;
		RoomDTO roomDTO=(RoomDTO)arg0;
		StringBuffer strbuf=new StringBuffer("SELECT ID,CLASSROOM_NO,CLASSROOM_TYPE,SCHOOL_NO,CLASSROOM_CONTENT,COMPUTER_NUM,SCOPE, STATUES  FROM room WHERE 1=1");
		count=this.getCount(arg0);
		if(roomDTO.getClassroomNo()!=null&&!"".equals(roomDTO.getClassroomNo())){
			strbuf.append(" AND CLASSROOM_NO='"+roomDTO.getClassroomNo()+"'");
		}
		if(roomDTO.getClassroomContent()!=0&&!"".equals(roomDTO.getClassroomContent())){
			strbuf.append("  AND CLASSROOM_CONTENT='"+roomDTO.getClassroomContent()+"'");
		}
		if(roomDTO.getClassroomType()!=null&&!"".equals(roomDTO.getClassroomType())){
			strbuf.append(" AND CLASSROOM_TYPE='"+roomDTO.getClassroomType()+"'");
		}
		if(roomDTO.getSchoolNo()!=null&&!"".equals(roomDTO.getSchoolNo())){
			strbuf.append(" AND SCHOOL_NO='"+roomDTO.getSchoolNo()+"'");
		}
		if(roomDTO.getComputerNum()!=0&&!"".equals(roomDTO.getComputerNum())){
			strbuf.append(" AND COMPUTER_NUM='"+roomDTO.getComputerNum()+"'");
		}
		if(roomDTO.getScope()!=null&&!"".equals(roomDTO.getScope())){
			strbuf.append(" AND SCOPE='"+roomDTO.getScope()+"'");
		}
		if(roomDTO.getStatues()!=null&&!"".equals(roomDTO.getStatues())){
			strbuf.append(" AND STATUES='"+roomDTO.getStatues()+"'");
		}
		int i =(Integer.parseInt(roomDTO.getCurrentPage())-1)*(Integer.parseInt(roomDTO.getRowPerPage()));
		strbuf.append(" ORDER BY ID DESC LIMIT "+i+","+roomDTO.getRowPerPage());
		sql=strbuf.toString();
		ps = conn.prepareStatement(sql);
		rs = ps.executeQuery();
		while(rs.next()){
			roomVO=new RoomVO();
			roomVO.setId(rs.getInt("id"));
			roomVO.setClassroomNo(rs.getString("classroom_No"));
			roomVO.setClassroomType(rs.getString("classroom_Type"));
			roomVO.setClassroomContent(rs.getInt("classroom_Content"));
			roomVO.setSchoolNo(rs.getString("school_No"));
			roomVO.setComputerNum(rs.getInt("computer_Num"));
			roomVO.setScope(rs.getString("scope"));
			roomVO.setStatues(rs.getString("statues"));
			list.add(roomVO);
		}
		objs[0]=count;
		objs[1]=list;
		
		if(ps!=null)ps=null;
		if(rs!=null)rs=null;
		roomVO=null;
		roomDTO=null;
		sql=null;
		return objs;
	}
	
	/**
	 * 根据id查询room表中的所有信息
	 * @param arg0 传入RoomDTO对象
	 *@throws SQLException
	 * @return list 返回一个ArrayList的集合。
	 *  @author 陈忠
	 * Creation date:04-30-2008
	 */
	public Object findById(Object arg0) throws SQLException {
		RoomDTO roomDTO=(RoomDTO)arg0;
		ArrayList list=new ArrayList();
		String sql=null;
		RoomVO roomVO=null;
		PreparedStatement  ps=null;
		ResultSet  rs=null;
		sql="SELECT ID,CLASSROOM_NO,CLASSROOM_TYPE,SCHOOL_NO,CLASSROOM_CONTENT,COMPUTER_NUM,SCOPE, STATUES  FROM room WHERE id=?";
		ps = conn.prepareStatement(sql);
		ps.setInt(1,roomDTO.getId());
		rs = ps.executeQuery();
		while(rs.next()){
			roomVO=new RoomVO();
			roomVO.setId(rs.getInt("id"));
			roomVO.setClassroomNo(rs.getString("classroom_No"));
			roomVO.setClassroomType(rs.getString("classroom_Type"));
			roomVO.setClassroomContent(rs.getInt("classroom_Content"));
			roomVO.setSchoolNo(rs.getString("school_No"));
			roomVO.setComputerNum(rs.getInt("computer_Num"));
			roomVO.setScope(rs.getString("scope"));
			roomVO.setStatues(rs.getString("statues"));
			list.add(roomVO);
		}
		return list;
	}

	/**
	 * 根据id查询room表中的所有信息
	 * @param arg0 传入一个值
	 *@throws SQLException
	 * @return list 返回一个ArrayList的集合。
	 *  @author 陈忠
	 * Creation date:04-30-2008
	 */
	public Object findByObject(Object obj) throws SQLException {
		ArrayList list=new ArrayList();
		Integer count =new Integer(0);
		Object[] objs=new Object[1];
		String sql=null;
		RoomVO roomVO=null;
		PreparedStatement ps=null;
		ResultSet rs=null;

		String schoolno = (String) obj;
		StringBuffer strbuf=new StringBuffer("SELECT ID,CLASSROOM_NO,CLASSROOM_TYPE,SCHOOL_NO,CLASSROOM_CONTENT,COMPUTER_NUM,SCOPE, STATUES  FROM room WHERE SCHOOL_NO='"+schoolno+"'");
		
		sql=strbuf.toString();
		ps = conn.prepareStatement(sql);
		rs = ps.executeQuery();
		while(rs.next()){
			roomVO=new RoomVO();
			roomVO.setId(rs.getInt("id"));
			roomVO.setClassroomNo(rs.getString("classroom_No"));
			roomVO.setClassroomType(rs.getString("classroom_Type"));
			roomVO.setClassroomContent(rs.getInt("classroom_Content"));
			roomVO.setSchoolNo(rs.getString("school_No"));
			roomVO.setComputerNum(rs.getInt("computer_Num"));
			roomVO.setScope(rs.getString("scope"));
			roomVO.setStatues(rs.getString("statues"));
			list.add(roomVO);
		}
		
		objs[0]=list;
		
		if(ps!=null)ps=null;
		if(rs!=null)rs=null;
		roomVO=null;
		sql=null;
		return objs;
	}

	/**
	 * 查询room表中的所有信息的条数
	 * @param arg0 传入RoomDTO对象
	 *@throws SQLException
	 * @return count 查询完成，int型的整数。
	 *  @author 陈忠
	 * Creation date:04-30-2008
	 */
	public int getCount(Object arg0) throws SQLException {
		
		Integer count =new Integer(0);
		String sql=null;
		RoomVO roomVO=null;
		PreparedStatement ps=null;
		ResultSet rs=null;
		RoomDTO roomDTO=(RoomDTO)arg0;
		StringBuffer strbuf=new StringBuffer("SELECT COUNT(*)aa FROM room WHERE 1=1");
		if(roomDTO.getClassroomNo()!=null&&!"".equals(roomDTO.getClassroomNo())){
			strbuf.append(" AND CLASSROOM_NO='"+roomDTO.getClassroomNo()+"'");
		}
		if(roomDTO.getClassroomContent()!=0&&!"".equals(roomDTO.getClassroomContent())){
			strbuf.append("  AND CLASSROOM_CONTENT='"+roomDTO.getClassroomContent()+"'");
		}
		if(roomDTO.getClassroomType()!=null&&!"".equals(roomDTO.getClassroomType())){
			strbuf.append(" AND CLASSROOM_TYPE='"+roomDTO.getClassroomType()+"'");
		}
		if(roomDTO.getSchoolNo()!=null&&!"".equals(roomDTO.getSchoolNo())){
			strbuf.append(" AND SCHOOL_NO='"+roomDTO.getSchoolNo()+"'");
		}
		if(roomDTO.getComputerNum()!=0&&!"".equals(roomDTO.getComputerNum())){
			strbuf.append(" AND COMPUTER_NUM='"+roomDTO.getComputerNum()+"'");
		}
		if(roomDTO.getScope()!=null&&!"".equals(roomDTO.getScope())){
			strbuf.append(" AND SCOPE='"+roomDTO.getScope()+"'");
		}
		if(roomDTO.getStatues()!=null&&!"".equals(roomDTO.getStatues())){
			strbuf.append(" AND STATUES='"+roomDTO.getStatues()+"'");
		}
		sql=strbuf.toString();
		ps = conn.prepareStatement(sql);
		rs = ps.executeQuery();
		while(rs.next()){
			count=new Integer(rs.getInt("aa"));
		}
		
		
		if(ps!=null)ps=null;
		if(rs!=null)rs=null;
		roomVO=null;
		roomDTO=null;
		sql=null;
		return count;
	}

	public Object getMaxId(Object arg0) throws SQLException {
		// TODO Auto-generated method stub
		return null;
	}

	/**
	 * 向room表中添加信息
	 * @param arg0 传入RoomDTO对象
	 *@throws SQLException
	 * @return flag 添加成功 返回true。
	 *  @author 陈忠
	 * Creation date:04-30-2008
	 */
	public Object insert(Object arg0) throws SQLException {
		boolean flag=false;
		RoomDTO roomDTO=(RoomDTO)arg0;
		String sql=null;
		int index=1;
		PreparedStatement ps=null;
		sql="INSERT INTO room(CLASSROOM_NO,CLASSROOM_TYPE,SCHOOL_NO,CLASSROOM_CONTENT,COMPUTER_NUM,SCOPE, STATUES) VALUE(?,?,?,?,?,?,?)";
		ps = conn.prepareStatement(sql);
		ps.setString(index++,roomDTO.getClassroomNo());
		ps.setString(index++,roomDTO.getClassroomType());
		ps.setString(index++,roomDTO.getSchoolNo());
		ps.setInt(index++,roomDTO.getClassroomContent());
		ps.setInt(index++,roomDTO.getComputerNum());
		ps.setString(index++,roomDTO.getScope());
		ps.setString(index++,roomDTO.getStatues());
		ps.executeUpdate();
		conn.commit();
		flag=true;
		
		if(ps!=null)ps=null;
		roomDTO=null;
		return flag;
	}

	/**
	 * 根据id修改room表中的信息
	 * @param arg0 传入RoomDTO对象
	 *@throws SQLException
	 * @return flag 修改成功 返回true。
	 *  @author 陈忠
	 * Creation date:04-30-2008
	 */
	public Object update(Object arg0) throws SQLException {
		boolean flag=false;
		RoomDTO roomDTO=(RoomDTO)arg0;
		String sql=null;
		int index=1;
		PreparedStatement ps=null;
		sql="UPDATE room SET CLASSROOM_NO=?,CLASSROOM_TYPE=?,SCHOOL_NO=?,CLASSROOM_CONTENT=?,COMPUTER_NUM=?,SCOPE=?, STATUES=? WHERE ID=?";
		ps = conn.prepareStatement(sql);
		ps.setString(index++,roomDTO.getClassroomNo());
		ps.setString(index++,roomDTO.getClassroomType());
		ps.setString(index++,roomDTO.getSchoolNo());
		ps.setInt(index++,roomDTO.getClassroomContent());
		ps.setInt(index++,roomDTO.getComputerNum());
		ps.setString(index++,roomDTO.getScope());
		ps.setString(index++,roomDTO.getStatues());
		ps.setInt(index++,roomDTO.getId());
		ps.executeUpdate();
		conn.commit();
		flag=true;
		
		if(ps!=null)ps=null;
		roomDTO=null;
		return flag;
	}

}