📄 smsstatshow.java
字号:
sOut+=" </select>月<select size=\"1\" name=\"day2\">\r\n";
sOut+=" <option value=00></option>\r\n";
sOut+=" <option value=01>1</option>\r\n";
sOut+=" <option value=02>2</option>\r\n";
sOut+=" <option value=03>3</option>\r\n";
sOut+=" <option value=04>4</option>\r\n";
sOut+=" <option value=05>5</option>\r\n";
sOut+=" <option value=06>6</option>\r\n";
sOut+=" <option value=07>7</option>\r\n";
sOut+=" <option value=08>8</option>\r\n";
sOut+=" <option value=09>9</option>\r\n";
sOut+=" <option >10</option>\r\n";
sOut+=" <option>11</option>\r\n";
sOut+=" <option>12</option>\r\n";
sOut+=" <option>13</option>\r\n";
sOut+=" <option>14</option>\r\n";
sOut+=" <option>15</option>\r\n";
sOut+=" <option>16</option>\r\n";
sOut+=" <option>17</option>\r\n";
sOut+=" <option>18</option>\r\n";
sOut+=" <option>19</option>\r\n";
sOut+=" <option>20</option>\r\n";
sOut+=" <option>21</option>\r\n";
sOut+=" <option>22</option>\r\n";
sOut+=" <option>23</option>\r\n";
sOut+=" <option>24</option>\r\n";
sOut+=" <option>25</option>\r\n";
sOut+=" <option>26</option>\r\n";
sOut+=" <option>27</option>\r\n";
sOut+=" <option>28</option>\r\n";
sOut+=" <option>29</option>\r\n";
sOut+=" <option>30</option>\r\n";
sOut+=" <option >31</option>\r\n";
sOut+=" </select>日 类型:<select size=\"1\" name=\"type\">\r\n";
sOut+=" <option value=\"%\">全部</option>\r\n";
sOut+=" <option value=\"GP\">股票价格</option>\r\n";
sOut+=" <option value=\"TQ\">天气预报</option>\r\n";
sOut+=" <option value=\"KQ\">空气质量</option>\r\n";
sOut+=" <option value=\"CP\">福利彩票</option>\r\n";
sOut+=" </select>第<select size=\"1\" name=\"page\">\r\n";
//分页
if(smsStat==null)
sOut+=" <option value=0>1</option>\r\n";
else
{
for(int i=0;i<=smsStat.length/10;i++)
sOut+=" <option value=0>"+(i+1)+"</option>\r\n";
}
//
sOut+=" </select>页 </p>\r\n";
sOut+=" <p align=\"right\"> <input type=\"submit\" value=\"查询\" name=\"B1\"></p>\r\n";
sOut+=" <input type=\"hidden\" name=\"yw\" size=\"20\" value="+type.trim ()+">\r\n";
sOut+=" </form>\r\n";
sOut+=" </td>\r\n";
sOut+=" </tr>\r\n";
sOut+=" <tr bgcolor=\"#FFFFFF\"> \r\n";
sOut+=" <td colspan=\"2\" align=\"center\" background=\"/sms/images/bg0.gif\" bordercolor=\"#3366CC\" bordercolorlight=\"#3366CC\" bordercolordark=\"#3366CC\" bgcolor=\"#EEEEEE\" height=\"41\" width=\"571\"> \r\n";
sOut+=" <table border=\"1\" width=\"100%\" background=\"/sms/images/bg0.gif\" bgcolor=\"#DDDDDD\" style=\"border-style: solid; border-color: #3366CC\" cellspacing=\"0\" cellpadding=\"0\" height=\"43\">\r\n";
sOut+=" <tr>\r\n";
sOut+=" <td width=\"24%\" background=\"/sms/images/bg0.gif\" bordercolor=\"#3366CC\" bordercolorlight=\"#3366CC\" bordercolordark=\"#3366CC\" bgcolor=\"#EEEEEE\" height=\"20\">\r\n";
sOut+=" <p align=\"center\">发送时间</td>\r\n";
sOut+=" <td width=\"30%\" background=\"/sms/images/bg0.gif\" bordercolor=\"#3366CC\" bordercolorlight=\"#3366CC\" bordercolordark=\"#3366CC\" bgcolor=\"#EEEEEE\" height=\"20\">\r\n";
sOut+=" <p align=\"center\">消息类型</td>\r\n";
sOut+=" <td width=\"22%\" background=\"/sms/images/bg0.gif\" bordercolor=\"#3366CC\" bordercolorlight=\"#3366CC\" bordercolordark=\"#3366CC\" bgcolor=\"#EEEEEE\" height=\"20\">\r\n";
sOut+=" <p align=\"center\">收费标准（元/条）</td>\r\n";
sOut+=" <td width=\"24%\" background=\"/sms/images/bg0.gif\" bordercolor=\"#3366CC\" bordercolorlight=\"#3366CC\" bordercolordark=\"#3366CC\" bgcolor=\"#EEEEEE\" height=\"20\">\r\n";
sOut+=" <p align=\"center\">是否成功</td>\r\n";
sOut+=" </tr>\r\n";
//内容
sOut+=" <tr>\r\n";
if(smsStat!=null)
{
for(int i=0;i<smsStat.length;i++)
{
sOut+=" <td width=\"24%\" background=\"/sms/images/bg0.gif\" bordercolor=\"#3366CC\" bordercolorlight=\"#3366CC\" bordercolordark=\"#3366CC\" bgcolor=\"#EEEEEE\" height=\"19\">"+smsStat[i].sTime +"</td>\r\n";
sOut+=" <td width=\"30%\" background=\"/sms/images/bg0.gif\" bordercolor=\"#3366CC\" bordercolorlight=\"#3366CC\" bordercolordark=\"#3366CC\" bgcolor=\"#EEEEEE\" height=\"19\">"+getYwname(smsStat[i].sType )+"</td>\r\n";
sOut+=" <td width=\"22%\" background=\"/sms/images/bg0.gif\" bordercolor=\"#3366CC\" bordercolorlight=\"#3366CC\" bordercolordark=\"#3366CC\" bgcolor=\"#EEEEEE\" height=\"19\">"+formatFeecode(smsStat[i].sFeeCode) +"</td>\r\n";
sOut+=" <td width=\"24%\" background=\"/sms/images/bg0.gif\" bordercolor=\"#3366CC\" bordercolorlight=\"#3366CC\" bordercolordark=\"#3366CC\" bgcolor=\"#EEEEEE\" height=\"19\">"+smsStat[i].sSuccess +"</td>\r\n";
}
}
else{
sOut+=" <td width=\"24%\" background=\"/sms/images/bg0.gif\" bordercolor=\"#3366CC\" bordercolorlight=\"#3366CC\" bordercolordark=\"#3366CC\" bgcolor=\"#EEEEEE\" height=\"19\"> </td>\r\n";
sOut+=" <td width=\"30%\" background=\"/sms/images/bg0.gif\" bordercolor=\"#3366CC\" bordercolorlight=\"#3366CC\" bordercolordark=\"#3366CC\" bgcolor=\"#EEEEEE\" height=\"19\"> </td>\r\n";
sOut+=" <td width=\"22%\" background=\"/sms/images/bg0.gif\" bordercolor=\"#3366CC\" bordercolorlight=\"#3366CC\" bordercolordark=\"#3366CC\" bgcolor=\"#EEEEEE\" height=\"19\"> </td>\r\n";
sOut+=" <td width=\"24%\" background=\"/sms/images/bg0.gif\" bordercolor=\"#3366CC\" bordercolorlight=\"#3366CC\" bordercolordark=\"#3366CC\" bgcolor=\"#EEEEEE\" height=\"19\"> </td>\r\n";
}
/////
sOut+=" </tr>\r\n";
sOut+=" </table>\r\n";
sOut+=" </td>\r\n";
sOut+=" </tr>\r\n";
sOut+=" </form>\r\n";
sOut+=" </table>\r\n";
sOut+=" </td>\r\n";
sOut+=" </tr>\r\n";
sOut+=" </table>\r\n";
sOut+=" \r\n";
sOut+=" </td>\r\n";
sOut+=" </tr>\r\n";
sOut+="</table>\r\n";
sOut+=" <SCRIPT language=javascript body <> \r\n";
sOut+=" document.wform.month1.options["+begintime.substring (5,7)+"].selected=true; \r\n";
sOut+=" document.wform.month2.options["+endtime.substring (5,7)+"].selected=true; \r\n";
sOut+=" document.wform.day1.options["+begintime.substring (8,10) +"].selected=true; \r\n";
sOut+=" document.wform.day2.options["+endtime.substring (8,10)+"].selected=true; \r\n";
sOut+=" \r\n";
sOut+="</SCRIPT\r\n";
sOut+="</body>\r\n";
sOut+="<!-- #EndTemplate --></html>\r\n";
sOut+="\r\n";
return sOut;
}
public SMSStat[] getSMSStat(String sMobile,String type,String begintime,String endtime,String page)
{
SMSStat[] smsStat;
DBOperater DB=new DBOperater ("userstock");
begintime=begintime+" 00:00";
endtime=endtime+" 23:59";
int count=0,nPage=0;
try{
nPage=Integer.valueOf (page).intValue ();
}catch(Exception e){
nPage=0;
}
String sSql="select count(*) from stat_flow where mobile='"+sMobile
+"' and ywcode like '"+type.trim ()+"' and time>'"+begintime+"' and time<'"+endtime+"'";
System.out.println (sSql);
ResultSet rs=DB.executeQuery (sSql);
if(rs!=null){
try{
if(rs.next ()){
count=rs.getInt (1);
}
else
count=0;
}
catch(Exception e){
count=0;
}
}
if (count==0)
return null;
else{
if((count/10)>nPage)
count=10;
else
count=count%10;
}
smsStat=new SMSStat[count];
String sSql1="select time,success,feecode,ywcode from stat_flow where mobile='"+sMobile
+"' and type like '"+type.trim ()+"' and time>'"+begintime+"' and time<'"+endtime+"'";
ResultSet rs1=DB.executeQuery (sSql1);
int i=0,j=0;
if(rs1!=null){
try{
while(rs1.next ()){
if((j>=nPage*10)&&(j<(nPage+1)*10)){
smsStat[i].sTime =rs1.getString (1);
if(rs1.getInt (2)==0)
smsStat[i].sSuccess ="成功";
else
smsStat[i].sSuccess ="失败";
smsStat[i].sFeeCode =rs1.getString (3);
smsStat[i].sType =rs1.getString (4);
i++;
if (i>count)
break;
}
j++;
}
}
catch(Exception e){
System.out.println ("get warnmax,warnmin error:"+e.toString ());
}
}
DB.close ();
return smsStat;
}
public class SMSStat{
String sTime;
String sType;
String sFeeCode;
String sSuccess;
}
public String formatFeecode(String sFeecode)
{
return CommonMethods.FormatDouble (CommonMethods.GetInt (sFeecode,0)/100,2);
}
public String getYwname(String ywcode)
{
if (ywcode==null)
return "";
String sYwname="";
DBOperater DB=new DBOperater ("icpywcode");
String sSql="select ywname from icpywcode where ywcode='"+ywcode+"'";
ResultSet rs=DB.executeQuery (sSql);
if(rs!=null){
try{
if(rs.next ()){
sYwname=rs.getString (1);
}
}
catch(Exception e){
sYwname="";
}
}
DB.close ();
return sYwname;
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -