酒店管理系统（SpringMVC+Extjs）附带数据库sql

酒店管理系统(SpringMVC+Extjs)附带数据库sql

package com.hotelmaster.action;

import java.io.PrintWriter;
import java.sql.Timestamp;
import java.util.Iterator;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import net.sf.json.JSONArray;
import net.sf.json.JSONobject;

import org.apache.log4j.Logger;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.multiaction.MultiActionController;

import com.hotelmaster.po.Operator;
import com.hotelmaster.po.Page;
import com.hotelmaster.po.Room;
import com.hotelmaster.po.RoomCatalog;
import com.hotelmaster.service.BusinessService;

public class BasicSettingController extends MultiActionController {
		private final static Logger log = Logger.getLogger（BasicSettingController.class）;
		private BusinessService businessService;
		public String json;
		String start = null; 
		String limit = null;
		public ModelAndView init（HttpServletRequest request
				HttpServletResponse response） throws Exception {
			// start to write something to the log
			log.info（“Someone come from ip address <“
					+ request.getRemoteAddr（） + “>“）;
			System.out.println（“reach BasicSettingController“）;
			
			//roomInfo=businessService.findRoomDetails（“8108“）;
			
			return new ModelAndView（“basicsetting“）;
		}
		
		public void listAllRooms（HttpServletRequest request
				HttpServletResponse response） throws Exception {	
			JSONArray jsonItems=new JSONArray（）;
			/*if （（String） request.getParameter（“start“）.trim（） != null） {
				start = （String） request.getParameter（“start“）.trim（）;
				log.info（start）;
			} else {
				log.info（“start is null“）;
				return;
			}
			if （（String） request.getParameter（“limit“）.trim（） != null） {
				limit = （String） request.getParameter（“limit“）.trim（）;
				log.info（limit）;
			} else {
				log.info（“limit is null“）;
				return;
			}
			Page page = new Page（Integer.parseInt（start） Integer.parseInt（limit））;*/
			Page page = new Page（0）;
			List roomList=businessService.findAllRooms（page）;
			long cout = businessService.queryRoomCount（）;
			Iterator i=roomList.iterator（）;
			Room room=new Room（）;
			while（i.hasNext（））{
				room=（Room）i.next（）;
				JSONobject json = JSONobject.fromobject（room）;
				json.put（“isNew“ “0“）;
				jsonItems.add（json）;
				
			}
			JSONobject jsonBack=new JSONobject（）;
			jsonBack.put（“rooms“ jsonItems）;
			jsonBack.put（“totalSize“ cout）;
			System.out.println（jsonBack）;
			request.setCharacterEncoding（“utf-8“）;   
			response.setContentType（“application/json;charset=utf-8“）;
			PrintWriter out = response.getWriter（）;
			out.print（jsonBack）;
		}
		
		/**
		 * Methohs description goes here.
		 * 
		 * @parameter 
		 * @Date May 21 2008
		 *
		 */
		public void dealRoomUpdateRequest（HttpServletRequest request
				HttpServletResponse response） throws Exception {
			/*
			 * String gtId = null; String gtName = null; gt

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     文件       22894  2010-02-02 15:34  db_hotelmaster.sql
     目录           0  2013-07-02 14:11  JavaPrj_9\
     文件        2780  2013-07-02 12:09  JavaPrj_9\.classpath
     文件         300  2013-07-02 12:40  JavaPrj_9\.mymetadata
     文件        1227  2009-12-02 15:34  JavaPrj_9\.project
     目录           0  2013-07-02 12:01  JavaPrj_9\.settings\
     文件         215  2013-07-02 13:57  JavaPrj_9\.settings\org.eclipse.core.resources.prefs
     文件         330  2009-12-02 15:30  JavaPrj_9\.settings\org.eclipse.jdt.core.prefs
     目录           0  2013-07-02 12:01  JavaPrj_9\src\
     目录           0  2013-07-02 12:01  JavaPrj_9\src\com\
     目录           0  2013-07-02 12:01  JavaPrj_9\src\com\hotelmaster\
     目录           0  2013-07-02 12:01  JavaPrj_9\src\com\hotelmaster\action\
     文件       19190  2010-01-29 16:44  JavaPrj_9\src\com\hotelmaster\action\BasicSettingController.java
     文件        2200  2009-12-04 09:30  JavaPrj_9\src\com\hotelmaster\action\BusinessCalculationController.java
     文件        8904  2009-12-06 10:50  JavaPrj_9\src\com\hotelmaster\action\CheckinController.java
     文件        2384  2009-12-06 18:42  JavaPrj_9\src\com\hotelmaster\action\CheckoutController.java
     文件        6343  2013-07-04 15:59  JavaPrj_9\src\com\hotelmaster\action\FrontdeskController.java
     文件        9761  2009-12-04 09:30  JavaPrj_9\src\com\hotelmaster\action\GuestHistoryController.java
     文件       12890  2009-12-04 17:03  JavaPrj_9\src\com\hotelmaster\action\GuestInforController.java
     文件         819  2009-12-04 09:30  JavaPrj_9\src\com\hotelmaster\action\HomeController.java
     文件       13026  2009-12-04 09:30  JavaPrj_9\src\com\hotelmaster\action\ReservController.java
     目录           0  2013-07-02 12:01  JavaPrj_9\src\com\hotelmaster\dao\
     目录           0  2013-07-02 12:01  JavaPrj_9\src\com\hotelmaster\daoimpl\
     文件        1308  2009-12-06 18:21  JavaPrj_9\src\com\hotelmaster\daoimpl\BalancementDaoImpl.java
     文件         572  2009-12-03 15:58  JavaPrj_9\src\com\hotelmaster\daoimpl\baseInfoDaoImpl.java
     文件         336  2009-12-03 15:58  JavaPrj_9\src\com\hotelmaster\daoimpl\CheckinItemDaoImpl.java
     文件        6414  2009-12-06 11:29  JavaPrj_9\src\com\hotelmaster\daoimpl\CheckinOrderDaoImpl.java
     文件        9756  2013-07-02 17:04  JavaPrj_9\src\com\hotelmaster\daoimpl\GenericHibernateDao.java
     文件        3021  2009-12-04 16:52  JavaPrj_9\src\com\hotelmaster\daoimpl\GuestDaoImpl.java
     文件        1807  2009-12-03 15:58  JavaPrj_9\src\com\hotelmaster\daoimpl\GuestHistoryDaoImpl.java
     文件        1647  2009-12-03 15:58  JavaPrj_9\src\com\hotelmaster\daoimpl\OperatorDaoImpl.java
............此处省略2225个文件信息