smspollutedz.java

JAVA邮件系统

/*
 *
 */

import java.io.*;
import java.text.*;
import java.sql.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;

/**
 *
 *
 * @author Chen Xin Wu
 */

public class SMSPolluteDZ extends SmsDZBase {

    public void doGet(HttpServletRequest request,
                      HttpServletResponse response)
        throws IOException, ServletException
    {
  		response.setContentType("text/html;charset=GB2312");
	    // 得到手机号和口令
		  String sMobile,sPassword,sUsername;
      sMobile=CommonMethods.GetUserMobile (request);
		  sPassword = CommonMethods.GetUserPass (request);
      sUsername = getUserName(sMobile,sPassword);

      if ((sUsername==null)||(sUsername.trim().length()==0))
          	response.sendRedirect ("/sms/LoginFail.htm");
      else
      {
        int i=0 ,length=0;
		    String[] result =request.getParameterValues ("col");
        SaveDZ(result,sUsername);
    		String sHours=new String ();
		    sHours = request.getParameter ("hour");
        if ((sHours==null)||(sHours.trim ().length ()==0))
    		{
		    	sHours="0";
		    }
        if (result==null)
            UpdatePerson(sUsername,"0",0);
        else
            UpdatePerson(sUsername,sHours,1);
        response.sendRedirect ("/sms/selectok.htm");
      }
    }
    public void doPost(HttpServletRequest request,
                      HttpServletResponse response)
        throws IOException, ServletException
    {
  		doGet(request,response);
    }
    public void SaveDZ(String[] city,String sUsername)
    {
		if (city==null){
        		DBOperater DB = new DBOperater ("ps_pollute");
		        DB.executeUpdate ( "delete from  ps_pollute where username='"+ sUsername +"'" );
				DB.close ();
				return;
		}
        else
        {
            int nLength=0,i=0;
            //将用户定制的城市信息插入ps_weather表中
        		DBOperater DB = new DBOperater ("ps_pollute");
		        DB.executeUpdate ( "delete from  ps_pollute where username='"+ sUsername +"'" );
            for(i=0;i<city.length;i++)
            {
 	               city[i]= CommonMethods.DealWithGBCodeOfRequest (city[i]);
                 DB.executeUpdate ( "INSERT INTO ps_pollute(username, cityname) VALUES('"+sUsername+"','"+city[i]+"')");
            }
            DB.close ();
        }
     }
      public void UpdatePerson(String sUsername,String sHour,int awoke)
    {
          	DBOperater DB = new DBOperater ("smsuser");
		        DB.executeUpdate ( "update "+CommonMethods.sTableName+" set pollutetx="+awoke+" , pollutetxhour="+sHour+" where username='"+ sUsername +"'" );
            DB.close ();
     }
     
}