📄 smsweathershow.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 SMSWeatherShow extends SmsDZBase { public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { HtmlOut htmlOut = new HtmlOut (response); System.out.println("test1"); // 得到手机号和口令 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(); 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 sql1="SELECT count(*) FROM ps_weather WHERE user_name = '"+sUsername.trim ()+"' "; String sSql="SELECT qx_dz FROM ps_weather WHERE user_name = '"+sUsername.trim ()+"' "; ResultSet rs1 = DB.executeQuery(sql1); try { while(rs1.next()){ count = rs1.getInt (1); } }catch(Exception ex){ DB.close(); return null; } 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 weatherawokehour 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+=""; sOut+=" "; sOut+=" </script>\r\n"; 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=\"/SMSWeatherDZ\" 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+=" <p><b>华北地区</b></p>\r\n"; sOut+=" </td>\r\n"; sOut+=" </tr>\r\n"; sOut+=" <tr> "; sOut+=" <td> "; sOut+=" <table border=\"0\" cellspacing=\"0\" cellpadding=\"2\">\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+=" </table>\r\n"; sOut+=" </td>\r\n"; sOut+=" </tr>\r\n"; sOut+=" <tr> "; sOut+=" <td><b>华东地区</b></td>\r\n"; sOut+=" </tr>\r\n"; sOut+=" <tr> "; sOut+=" <td> "; sOut+=" <table border=\"0\" cellspacing=\"0\" cellpadding=\"2\">\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+=" </tr>\r\n"; sOut+=" </table>\r\n"; sOut+=" </td>\r\n"; sOut+=" </tr>\r\n"; sOut+=" <tr> "; sOut+=" <td><b>华南地区</b></td>\r\n"; sOut+=" </tr>\r\n"; sOut+=" <tr> "; sOut+=" <td> "; sOut+=" <table border=\"0\" cellspacing=\"0\" cellpadding=\"2\">\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+=" </table>\r\n"; sOut+=" </td>\r\n"; sOut+=" </tr>\r\n"; sOut+=" <tr> "; sOut+=" <td><b>东北地区</b></td>\r\n"; sOut+=" </tr>\r\n"; sOut+=" <tr> "; sOut+=" <td> "; sOut+=" <table border=\"0\" cellspacing=\"0\" cellpadding=\"2\">\r\n"; sOut+=" <tr> ";⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -