📄 smspolluteshow.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 SMSPolluteShow extends SmsDZBase {
public void doGet(HttpServletRequest request,
HttpServletResponse response)
throws IOException, ServletException
{
HtmlOut htmlOut = new HtmlOut (response);
// 得到手机号和口令
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
{
String sOut="";
String[] sCitys= getCitys(sUsername) ;
String awoke=getAwoke(sUsername) ;
sOut=beginString();
System.out.println("test3");
if (sCitys==null)
sOut+=htmlString(awoke);
else
sOut+=htmlString(sCitys,awoke);
htmlOut.addString (sOut);
htmlOut.outHtml ();
}
}
public void doPost(HttpServletRequest request,
HttpServletResponse response)
throws IOException, ServletException
{
doGet(request,response);
}
public String[] getCitys(String sUsername)
{
int count=0;
if (sUsername==null)
return null;
DBOperater DB = new DBOperater("ps_weatehr");
String sql="SELECT count(*) FROM ps_pollute WHERE username = '"+sUsername.trim ()+"' ";
String sSql="SELECT cityname FROM ps_pollute WHERE username = '"+sUsername.trim ()+"' ";
ResultSet rs1 = DB.executeQuery(sql);
try
{
while(rs1.next()){
count = rs1.getInt (1);
}
}catch(Exception ex){
}
if (count==0){
DB.close();
return null;
}
else{
String[] sCitys=new String[count];
int i=0;
ResultSet rs = DB.executeQuery(sSql);
try
{
while(rs.next()){
sCitys[i] = rs.getString(1);
i++;
if(i>=count)
break;
}
}catch(Exception ex){
DB.close ();
return null;
}
DB.close();
return sCitys;
}
}
public String getAwoke(String sUsername)
{
String awoke="0";
if (sUsername==null)
return awoke;
DBOperater DB = new DBOperater("smsuser");
String sSql="SELECT pollutetxhour FROM "+CommonMethods.sTableName +" WHERE username = '"+sUsername.trim ()+"' ";
ResultSet rs = DB.executeQuery(sSql);
try
{
if(rs.next()){
awoke = rs.getString(1);
}
}catch(Exception ex){
}
DB.close();
if(awoke==null || awoke.compareTo("null")==0 )
awoke ="0";
return awoke;
}
public String beginString()
{
String sOut=new String ();
sOut+="<html>\r\n";
sOut+="<head>\r\n";
sOut+="<title>欢迎光临365do短信息点播中心</title>\r\n";
sOut+="<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n";
sOut+="<meta http-equiv=pragma content=no-cache>";
sOut+="<link rel=\"stylesheet\" href=\"/sms/style_sms.css\">\r\n";
sOut+=" <style type=\"text/css\">\r\n";
sOut+=" <!--";
sOut+=" .box { font-family: \"Verdana\", \"Arial\", \"Helvetica\", \"sans-serif\", \"楷体_GB2312\"; font-size: 7pt; background-color:white; border:none; width:70px}";
sOut+=" -->\r\n";
sOut+=" </style>\r\n";
sOut+=" <script language=\"JavaScript\"> ";
sOut+="function check() ";
sOut+="{ var len=0; ";
sOut+=" var weather=document.wform.col; ";
sOut+=" for(var i=0;i<weather.length;i++) ";
sOut+=" { if(weather[i].checked) len++; } ";
sOut+=" if(len>2) ";
sOut+=" { alert('您最多只能选择两个城市!'); return false; } ";
sOut+=" return true;";
sOut+="} ";
sOut+=" function gourl(url){ ";
sOut+=" location = url; ";
sOut+=" } ";
sOut+=" function setvalue(val) ";
sOut+=" { var weather=document.wform.col; ";
sOut+=" for(var i=0;i<weather.length;i++) ";
sOut+=" { if(weather[i].value==val) ";
sOut+=" { weather[i].checked=true; ";
sOut+=" return true; } } ";
sOut+=" return false;} ";
sOut+=" </script> ";
sOut+=" </head>\r\n";
sOut+=" <body bgcolor=\"#CCCCCC\" leftmargin=\"10\" topmargin=\"10\" marginwidth=\"10\" marginheight=\"10\" onLoad=\"\">\r\n";
sOut+=" <table border=\"0\" cellspacing=\"0\" cellpadding=\"4\" bordercolorlight=\"#FFFFFF\" bgcolor=\"#FFFFFF\" width=\"100%\">\r\n";
sOut+=" <tr> ";
sOut+=" <td bgcolor=\"#7A7B8B\"><b><font color=\"#FFFFFF\">空气质量报告</font></b></td>\r\n";
sOut+=" </tr>\r\n";
sOut+=" <tr> ";
sOut+=" <td align=\"center\" bgcolor=\"#FFFFFF\"> ";
sOut+=" <form method=\"post\" action=\"/SMSPolluteDZ\" name=wform onsubmit=\"return(check())\">\r\n";
sOut+=" <table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"3\" align=\"center\">\r\n";
sOut+=" <tr> ";
sOut+=" <td> ";
sOut+=" <table border=\"0\" cellspacing=\"0\" cellpadding=\"3\">\r\n";
sOut+=" <tr> ";
sOut+=" <td> ";
sOut+=" <input name=col type=checkbox value=北京>\r\n";
sOut+=" </td>\r\n";
sOut+=" <td>北京</td>\r\n";
sOut+=" <td> ";
sOut+=" <input name=col type=checkbox value=天津>\r\n";
sOut+=" </td>\r\n";
sOut+=" <td>天津</td>\r\n";
sOut+=" <td> ";
sOut+=" <input name=col type=checkbox value=石家庄>\r\n";
sOut+=" </td>\r\n";
sOut+=" <td>石家庄</td>\r\n";
sOut+=" <td> ";
sOut+=" <input name=col type=checkbox value=太原>\r\n";
sOut+=" </td>\r\n";
sOut+=" <td>太原</td>\r\n";
sOut+=" <td> ";
sOut+=" <input name=col type=checkbox value=烟台>\r\n";
sOut+=" </td>\r\n";
sOut+=" <td>烟台</td>\r\n";
sOut+=" <td> ";
sOut+=" <input name=col type=checkbox value=济南>\r\n";
sOut+=" </td>\r\n";
sOut+=" <td>济南</td>\r\n";
sOut+=" <td> ";
sOut+=" <input name=col type=checkbox value=青岛>\r\n";
sOut+=" </td>\r\n";
sOut+=" <td>青岛</td>\r\n";
sOut+=" </tr>\r\n";
sOut+=" <tr> ";
sOut+=" <td> ";
sOut+=" <input name=col type=checkbox value=哈尔滨>\r\n";
sOut+=" </td>\r\n";
sOut+=" <td>哈尔滨</td>\r\n";
sOut+=" <td> ";
sOut+=" <input name=col type=checkbox value=沈阳>\r\n";
sOut+=" </td>\r\n";
sOut+=" <td>沈阳</td>\r\n";
sOut+=" <td> ";
sOut+=" <input name=col type=checkbox value=长春>\r\n";
sOut+=" </td>\r\n";
sOut+=" <td>长春</td>\r\n";
sOut+=" <td> ";
sOut+=" <input name=col type=checkbox value=大连>\r\n";
sOut+=" </td>\r\n";
sOut+=" <td>大连</td>\r\n";
sOut+=" <td> ";
sOut+=" <input name=col type=checkbox value=西安>\r\n";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -