adduser.java

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

package com.bluedot.web.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.net.URLEncoder;
import java.util.Locale;
import java.util.ResourceBundle;

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

public class AddUser extends HttpServlet {

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

		User user = new User();
		user.setLoginName(loginName);
		user.setPwd(pwd);
		user.setAge(Integer.parseInt(age));
		Role role = new Role();
		role.setId(Integer.parseInt(roleId));

		user.setRole(role);

		try {
			UserManager m = new UserManagerImpl();
			m.registUser(user);

			response.sendRedirect("ok.jsp?msg=" + URLEncoder.encode("添加用户","utf-8"));
		} catch (DataAccessException e) {
			Locale l = request.getLocale();
			ResourceBundle rb = ResourceBundle.getBundle(
					"com.bluedot.resource.Res", l);
			String msg = rb.getString(e.getMessage());
			request.setAttribute("msg", msg);
			request.getRequestDispatcher("addUser.jsp").forward(request,
					response);
		} catch (ApplicationException e) {
			Locale l = request.getLocale();
			ResourceBundle rb = ResourceBundle.getBundle(
					"com.bluedot.resource.Res", l);
			String msg = rb.getString(e.getMessage());

			response.sendRedirect("error.jsp?msg="
					+ URLEncoder.encode(msg, "utf-8"));
		}
	}

}