finduser.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.Page;
import com.bluedot.domain.Role;
import com.bluedot.domain.User;
import com.bluedot.exceptions.ApplicationException;
import com.bluedot.exceptions.DataAccessException;
import com.bluedot.service.UserManager;
import com.bluedot.service.UserManagerImpl;

public class FindUser extends HttpServlet {
	@Override
	protected void doGet(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		doPost(req, resp);
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		String loginName = request.getParameter("loginName");
		String age = request.getParameter("age");
		String roleId = request.getParameter("roleId");

		User user = new User();

		if (loginName != null && loginName.length() > 0) {
			user.setLoginName(loginName);
		}
		if (age != null && age.length() > 0) {
			user.setAge(Integer.parseInt(age));
		} else {
			user.setAge(-1);
		}

		Role role = new Role();
		role.setId(Integer.parseInt(roleId));

		user.setRole(role);

		int curPage = 1;

		String str = request.getParameter("curPage");
		if (str != null && str.length() > 0) {
			curPage = Integer.parseInt(str);
		}

		try {
			UserManager m = new UserManagerImpl();
			// List<User> list = m.advancedFindUser(user);

			Page p = m.advancedFindUser(user, curPage);

			request.setAttribute("p", p);
			request.setAttribute("loginName", loginName);
			request.setAttribute("age", age);
			request.setAttribute("roleId", roleId);
			request.getRequestDispatcher("viewUser2.jsp").forward(request,
					response);

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

}