writeexpense.java

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

/**
 * WriteExpense.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 WriteExpense 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 
    {
        request.setCharacterEncoding("gb2312");
        response.setContentType("text/html; charset=gb2312");
        PrintWriter out = response.getWriter();
        
        HouseControl housecontrol=new HouseControl();
        ExpenseControl expensecontrol=new ExpenseControl();
        StandardControl standardcontrol=new StandardControl();
        
        String table=request.getParameter("table");
        String donghao=request.getParameter("donghao");
        String houseid=request.getParameter("houseid");
        String xianshu=request.getParameter("xianshu");
        String newdate=request.getParameter("newdate");
        
        Expense expense=expensecontrol.getExpenseInfo(table,donghao,houseid);
      
		//处理数据
        try
        {
        	if(housecontrol.isExistHouse(donghao,houseid))
        	{
        		if(housecontrol.getHouseInfo(donghao,houseid).getRuzhu()!=0)
        		{
        			if(!String.valueOf(expense.getXianshu()).equals(null)) expense.setDishu(expense.getXianshu());
        	    	if(!String.valueOf(expense.getNewdate()).equals(null)) expense.setShangci(expense.getNewdate());
        			expense.setDonghao(donghao);
                	expense.setHouseid(houseid);
        	    	expense.setXianshu(Float.parseFloat(xianshu));
        	    	expense.setNewdate(java.sql.Date.valueOf(newdate));
        	    	Standard standard=standardcontrol.getStandardInfo();
        	    	float x=standard.getWstd();
        	    	x=x*(expense.getXianshu()-expense.getDishu());
        	    	expense.setExpense(x);
        	    	expensecontrol.WriteExpense(table,expense);
        	    	out.print(expense.getDishu()+"<br>"+expense.getXianshu()+"<br>"+expense.getShangci()+"<br>"+expense.getNewdate()+"<br>"+expense.getExpense());
        	    	out.print((table.equals("water"))?"<script>alert('成功登记！');window.location.href='water.jsp'</script>":"<script>alert('成功登记！');window.location.href='electric.jsp'</script>");
        	    	housecontrol.close();
        	    }else{
        	    	out.print("<script>alert('该房间无人居住！');history.back()</script>");
        	    }
        	}else{
        		out.print("<script>alert('该房间不存在！');history.back()</script>");
        	}
        }
        catch(Exception e)
        {
            System.out.print("WriteExpense Servlet error:"+e.getMessage());            
        }
    }
    
    //Clean up resources
    public void destroy()
    {
    }
}