preadduser.java

用jdbc写的一个存储过程的代码

package com.bluedot.web.servlet;

import java.io.IOException;
import java.io.PrintWriter;
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.bluedot.domain.Role;
import com.bluedot.exceptions.ApplicationException;
import com.bluedot.exceptions.DataAccessException;
import com.bluedot.service.PriviligeManager;
import com.bluedot.service.PriviligeManagerImpl;

public class PreAddUser extends HttpServlet {

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

		doPost(request, response);
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		PriviligeManager m = new PriviligeManagerImpl();

		try {
			List<Role> list = m.findAllRoles();

			request.setAttribute("list", list);
			request.getRequestDispatcher("addUser.jsp").forward(request,
					response);
		} catch (DataAccessException e) {
			response.sendRedirect("error.jsp");
		} catch (ApplicationException e) {
			response.sendRedirect("error.jsp");
		}
	}

}