updatesh.java

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

/**
 * UpdateSH.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 UpdateSH 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=(Student)session.getAttribute("student");
        HouseControl housecontrol=new HouseControl();
        StudentControl studentcontrol=new StudentControl();
        
        String donghao=request.getParameter("donghao");
        String houseid=request.getParameter("houseid");
        String intime=request.getParameter("intime");
      
		//处理数据
        try
        {
        	if(housecontrol.isExistHouse(donghao,houseid))
        	{
        		House house=housecontrol.getHouseInfo(donghao,houseid);
        		if(house.getSex().equals(student.getSex()))
        		{
        			student.setDonghao(donghao);
        			student.setHouseid(houseid);
        			student.setIntime(java.sql.Date.valueOf(intime));
        			studentcontrol.UpdateStudentHouse(student);
        			studentcontrol.close();
        			session.setAttribute("student",null);
        			out.print("<script>alert('成功修改！');window.location.href='/MyDesign/SearchStudent'</script>");
        		}else  out.print("<script>alert('性别不符！');history.back()</script>");
        	}else  out.print("<script>alert('该房间不存在！');history.back()</script>");
        }
        catch(Exception e)
        {
            System.out.print("UpdateHouseServlet error:"+e.getMessage());            
        }
        finally
        {  
        }
    }
    
    //Clean up resources
    public void destroy()
    {
    }
}