insertstudent2.java

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

package cn.kmp.accommodation.servlet.ext;

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 InsertStudent2 extends HttpServlet{
	private static final long serialVersionUID=-2264452574922395713L;
	
	public void doPost(HttpServletRequest request,HttpServletResponse response)throws IOException,ServletException{
		
		PrintWriter out=response.getWriter();
		
		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");
		String category=request.getParameter("category");
		
		int c=Integer.parseInt(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";
			out.println("{success:true,msg:\'existedStudent\'}");
		}
		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(c);
			s.setIsSmoker(isSmoker);
			s.setNationality(nationality);
			s.setCity(city);
			s.setStreet(street);
			s.setPostcode(postcode);
			s.setStatus(0);
			if(ss.insertStudent(s)){
				out.println("{success:true,msg:\'success\'}");
			}
			else{
				out.println("{success:true,msg:\'failure\'}");
			}
		}
	}
}