ordersservlet.java

旅馆预订系统.采用jstl+oracle,jsp/servlet,,供初学者学习用.

package com.night.Servlet;

import java.io.IOException;
import java.util.List;

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

import com.night.DAO.OrdersDAO;
import com.night.Factory.Factory;

public class OrdersServlet extends HttpServlet {

	protected void doGet(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {

		String action = request.getParameter("action").trim();
		if (action == null)
			return;
		if (action.equals("insert")) {
			insertOrUpdateOrder(request, response);
		} else if (action.equals("update")) {
			insertOrUpdateOrder(request, response);
			System.out.println("update执行。。。。");
		} else if (action.equals("del")) {
			deleteOrders(request, response);
		} else if (action.equals("list")) {
			listOrders(request, response);
		} else if (action.equals("load")) {
			loadOrder(request, response);
		}

	}

	protected void doPost(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		doGet(request, response);
	}

	private void listOrders(HttpServletRequest request,
			HttpServletResponse response) {
		OrdersDAO dao = Factory.getOrdersDAOInstance();
		List list = dao.showOrders();
		System.out.println(list);
		request.setAttribute("orders", list);
		try {
			request.getRequestDispatcher("/orders_list.jsp").forward(request,
					response);
		} catch (Exception e) {
			e.printStackTrace();
		}

	}

	private void loadOrder(HttpServletRequest request,
			HttpServletResponse response) {

		OrdersDAO dao = Factory.getOrdersDAOInstance();
		int id = Integer.parseInt(request.getParameter("orderid").trim());
		List list = dao.showOrderByOrderId(id);
		System.out.println(list);
		try {
			if (list == null) {
				request.setAttribute("message", "没有指定的记录！！");
				request.getRequestDispatcher("/error.jsp").forward(
						request, response);
			} else {
				request.setAttribute("orders", list);
				request.getRequestDispatcher("/orders_update.jsp").forward(
						request, response);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	private void deleteOrders(HttpServletRequest request,
			HttpServletResponse response) {

		OrdersDAO dao = Factory.getOrdersDAOInstance();
		int id = Integer.parseInt(request.getParameter("orderid").trim());
		dao.deleteOrderByOrderId(id);
		System.out.println("删除了" + id + "的数据!!");
		try {
			request.getRequestDispatcher("/OrdersServlet?action=list").forward(
					request, response);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	private void insertOrUpdateOrder(HttpServletRequest request,
			HttpServletResponse response) {
		String housestyle = request.getParameter("housestyle").trim();
		String city = request.getParameter("city").trim();
		int houseid = Integer.parseInt(request.getParameter("houseid").trim());
		String roomstyle = request.getParameter("roomstyle").trim();
		int num = Integer.parseInt(request.getParameter("num").trim());
		String custom = request.getParameter("custom").trim();
		String tel = request.getParameter("tel").trim();
		String email = request.getParameter("email").trim();
		OrdersDAO dao = Factory.getOrdersDAOInstance();
		dao.insertOrUpdateOrder(housestyle, houseid, roomstyle, num, custom,
				tel, email);
		System.out.println("恭喜，订单添加成功!!");
		listOrders(request, response);
	}

}