meetingroomdaoimpl.java

一段很有意义的源码,看了就知道,不信试一试啊!

package com.wondersgroup.businessmodule.meetingmanage.dao.impl;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;

import com.wondersgroup.businessmodule.meetingmanage.bo.BusinessMeetingRoom;
import com.wondersgroup.businessmodule.meetingmanage.dao.BusinessMeetingRoomDAO;
import com.wondersgroup.framework.core.dao.impl.AbstractHibernateDAOImpl;

public class MeetingRoomDAOImpl extends AbstractHibernateDAOImpl implements
		BusinessMeetingRoomDAO {
	public Class getEntityClass(){
		return BusinessMeetingRoom.class;
	}
	/**
	 * 会议状态
	 * @param cuurDate
	 * @return
	 */
	public List getMeetingStatsRequestList(String cuurDate){ 
		List list=new ArrayList();
		Connection conn = this.getHibernateTemplate().getSessionFactory().
		getCurrentSession().connection();
		String sql = "select room.ass_ro_inf,roominfo.name,meetinginfo.title,meetinginfo.start_time,meetinginfo.end_time ";
		sql +="	from "; 
		sql +="	BUSINESS_ASSEMBLY_ROOM room,"; 
		sql +="	BUSINESS_ASSEMBLY_ROOM_INFO roominfo,"; 
		sql +="	BUSINESS_ASSEMBLY meeting,"; 
		sql +="	BUSINESS_ASSEMBLY_INFO meetinginfo"; 
		sql +="	where room.removed=0 and room.ass_ro_inf=roominfo.id and roominfo.removed=0 "; 
		sql +="	and room.ass_ro_inf =meetinginfo.position"; 
		sql +="	and DATE(meetinginfo.start_time)>=DATE('"+cuurDate+" 00:00:00')"; 
		sql +="	and DATE(meetinginfo.end_time)<=DATE('"+cuurDate+" 23:59:59')"; 
		sql +="	and meetinginfo.id=meeting.ass_info_id"; 
		sql +="	and meeting.status=4"; 
		sql +="	and meeting.removed=0"; 
		sql +="	and meetinginfo.removed=0";  
		String sql0="select room.ass_ro_inf,roominfo.name from BUSINESS_ASSEMBLY_ROOM room,BUSINESS_ASSEMBLY_ROOM_INFO roominfo where room.removed=0 and room.ass_ro_inf=roominfo.id and roominfo.removed=0";
		List listtemp=new ArrayList();
		List listtemp0=new ArrayList();
		try{
			java.sql.Statement stmt= conn.createStatement(); 
			java.sql.ResultSet rs=stmt.executeQuery(sql);
			while(rs.next()){ 
				Map m=new HashMap();
				m.put("ASS_RO_INF",rs.getString("ASS_RO_INF"));
				m.put("NAME",rs.getString("NAME"));
				m.put("TITLE", rs.getString("TITLE"));
				m.put("START_TIME", rs.getString("START_TIME"));
				m.put("END_TIME", rs.getString("END_TIME"));
				listtemp.add(m);
			}
			
			java.sql.ResultSet rs0=stmt.executeQuery(sql0);
			while(rs0.next()){ 
				Map m=new HashMap(); 
				m.put("ASS_RO_INF",rs0.getString("ASS_RO_INF"));
				m.put("NAME",rs0.getString("NAME"));
				listtemp0.add(m);
			}
		}catch(SQLException e){
			e.printStackTrace();
		}finally{
			try {
				if(!conn.isClosed())
					conn.close();
			} catch (SQLException e) { 
				e.printStackTrace();
			}
		}
		/*
		 * 处理list
		 */
		try{ 
			Iterator si=listtemp0.iterator();
			while(si.hasNext()){
				Map rid=(HashMap)si.next();
				Map mm=new HashMap();
				mm.put("ROOMID",rid.get("ASS_RO_INF"));
				mm.put("NAME", rid.get("NAME")); 
				String pmTitle="",amTitle="";
				for(int i=0;i<listtemp.size();i++){
					Map m=(HashMap)listtemp.get(i);
					
					if(rid.get("ASS_RO_INF").equals(m.get("ASS_RO_INF"))){  
						int sHour=Integer.parseInt(m.get("START_TIME").toString().substring(11, 13));
						int eHour=Integer.parseInt(m.get("END_TIME").toString().substring(11, 13));
						int sMi=Integer.parseInt(m.get("START_TIME").toString().substring(14, 16));
						int eMi=Integer.parseInt(m.get("END_TIME").toString().substring(14, 16));
						if(sHour<=12){
							amTitle+=sHour+":"+sMi+" "+eHour+":"+eMi+"0 "+m.get("TITLE")+"；<BR>"; 
						}
						if(eHour>12){
							pmTitle+=sHour+":"+sMi+" "+eHour+":"+eMi+"0 "+m.get("TITLE")+"；<BR>"; 
						}
					}
				}
				mm.put("AMTITLE",amTitle);
				mm.put("PMTITLE",pmTitle);
				list.add(mm);
			}
		}catch(Exception ex){ex.printStackTrace();} 
		return list;
	}
}