delstudenthouse.java

学生宿舍管理系统(含源代码) 使用SQL Server 2000的企业管理器

/**
 * DelStudentHouse.java
 * author:liuhaijing
 * @version 1.0
 */
 
 package mydesign;//包名

import java.io.*;
import mydesign.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class DelStudentHouse extends HttpServlet
{
  
    //Initialize global variables
    public void init() throws ServletException 
    {
    }
    
    //Process the HTTP Post request
    public void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException 
    {
    	HttpSession session=request.getSession(true);
        request.setCharacterEncoding("gb2312");
        response.setContentType("text/html; charset=gb2312");
        PrintWriter out = response.getWriter();
        
        Student student=new Student();
        StudentControl studentcontrol=new StudentControl();
        HouseControl housecontrol=new HouseControl();
        
        String studentid=request.getParameter("studentid");
        String donghao=request.getParameter("donghao");
        String houseid=request.getParameter("houseid");

      
		//处理数据
        try
        {
        	student.setStudentid(studentid);
        	student.setDonghao(donghao);
        	student.setHouseid(houseid);
        	if(studentcontrol.isExistStudent(studentid))
        	{
        		if(housecontrol.isExistHouse(donghao,houseid))
        		{
        			if(studentcontrol.isExistStudentHouse(student))
        			{
        				studentcontrol.DelStudentHouse(student);
        				studentcontrol.close();
        				housecontrol.delStudent(donghao,houseid);
        				housecontrol.close();
        				out.print("<script>alert('成功登记迁出！');window.location.href='student_out.jsp'</script>");
        			}
        			else  out.print("<script>alert('该学生不在此房间！');window.location.href='student_out.jsp'</script>");
        		}
        		else  out.print("<script>alert('该房间不存在！');window.location.href='student_out.jsp'</script>");
        	}
        	else  out.print("<script>alert('没有该学生的资料！');window.location.href='student_out.jsp'</script>");
        }
        catch(Exception e)
        {
            System.out.print("DelStudentHouseServlet error:"+e.getMessage());            
        }
        finally
        {  
        }
    }
    
    //Clean up resources
    public void destroy()
    {
    }
}