insertstudent.java

数据库系统教材中附录的课程设计accomodation宿舍管理系统源码

package cn.kmp.accommodation.servlet;

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

import cn.kmp.accommodation.domain.*;
import cn.kmp.accommodation.service.*;

import java.io.*;

public class InsertStudent extends HttpServlet{
	private static final long serialVersionUID=-2264452574922395713L;
	private ServletConfig servletConfig=null;
	private String successView=null;
	private String failureView=null;
	//private String sessionUserInfo=null;
	
	public void doPost(HttpServletRequest request,HttpServletResponse response)throws IOException,ServletException{
		successView=request.getContextPath()+servletConfig.getInitParameter("successView");
		failureView=request.getContextPath()+servletConfig.getInitParameter("failureView");
		//sessionUserInfo=servletConfig.getInitParameter("sessionUserInfo");
		
		int studentNum=Integer.parseInt(request.getParameter("studentNum"));
		String lname=request.getParameter("lname");
		String fname=request.getParameter("fname");
		String birthday=request.getParameter("birthday");
		String sex=request.getParameter("sex");
		int category=Integer.parseInt(request.getParameter("category"));
		String nationality=request.getParameter("nationality");
		int isSmoker=Integer.parseInt(request.getParameter("isSmoker"));
		String specialNeeds=request.getParameter("specialNeeds");
		String additionalComment=request.getParameter("additionalComment");
		int advisorNum=Integer.parseInt(request.getParameter("advisorNum"));
		String city=request.getParameter("city");
		String street=request.getParameter("street");
		int postcode=Integer.parseInt(request.getParameter("postcode"));
		
		StudentService ss=ServiceFactory.getStudentService();
		Student st=ss.getStudentByStudentNum(studentNum);
		if(st!=null){
			String existed="existedStudent";
			response.sendRedirect(failureView+"?err="+existed);
		}
		else {
			Student s=new Student();
			s.setStudentNum(studentNum);
			s.setLname(lname);
			s.setFname(fname);
			s.setBirthday(birthday);
			s.setSex(sex);
			s.setSpecialNeeds(specialNeeds);
			s.setAdditionalComment(additionalComment);
			s.setAdvisorNum(advisorNum);
			s.setCategory(category);
			s.setIsSmoker(isSmoker);
			s.setNationality(nationality);
			s.setCity(city);
			s.setStreet(street);
			s.setPostcode(postcode);
			s.setStatus(0);
			if(ss.insertStudent(s)){
				response.sendRedirect(successView+"?studentNum="+studentNum);
			}
			else{
				response.sendRedirect(failureView);
			}
		}
	}
	public void init(ServletConfig servletConfig)throws ServletException{
		this.servletConfig=servletConfig;
	}
}