test.java~1~

WAP PUSH后台源码,WAP PUSH后台源码

package com.hnuninet.ebiz.sgip;
import java.sql.*;
import java.io.*;
import java.util.*;
import java.net.*;
import java.text.*;
import com.hnuninet.ebiz.common.*;
import com.hnuninet.ebiz.smscenter.SMSQueue;

public class test implements Runnable {
     private static String smscHost = "192.168.8.111";
//     private static String smscHost = "192.168.0.188";
     private static int smscPort = 8801;
     private static int spPort = 8808;
//     private static int spPort = 8801;
     private static String loginName = "internet";
     private static String loginPassword = "internet";
     /** 数据库连接 */
     private Connection m_dbConn1;
//     private static String loginName = "qq";
//     private static String loginPassword = "qq";
//     private static int loginType=2;

     public java.net.Socket m_sk;
     /**
      * test 构造子注解。
      */
     protected static Connection getConnection() throws Exception {
          String driverName = "oracle.jdbc.driver.OracleDriver";
          String url = "jdbc:oracle:thin:@10.0.0.99:1521:ora8";
          String user="xjuninet";
          String password="xjuninet";
//          String url = "jdbc:oracle:thin:@10.255.255.209:1521:orcl";
//          String user="hnuninet";
//          String password="hnuninet";
          Connection con = null;
//          con=ConnPoolHandler.getConnection();

          //连接数据库
          Class.forName(driverName).newInstance();
          con = DriverManager.getConnection(url,user,password);
          return con;
     }
     public test() {
          super();
     }
     /**
      * test 构造子注解。
      */
     public test(Socket socket) throws  IOException {
          this.m_sk=socket;

     }
     /**
      * 启动应用程序。
      * @param args 命令行自变量数组
      */
     private static void init() {
          try {
               File f=new File("sgip.properties");
               InputStream is=new BufferedInputStream(new FileInputStream(f));
//               InputStream is = getClass().getResourceAsStream("/sgip.properties");
               Properties sgipProps = new Properties();
               sgipProps.load(is);
               smscHost = sgipProps.getProperty("smscHost");
               smscPort = Integer.parseInt(sgipProps.getProperty("smscPort"));
               loginName = sgipProps.getProperty("loginName");
               loginPassword = sgipProps.getProperty("loginPassword");
               System.out.println(smscHost);
//               maxRetryTimes = Integer.parseInt(sgipProps.getProperty("maxRetryTimes"));
//               threadThreshold = Integer.parseInt(sgipProps.getProperty("threadThreshold"));
//               reconnectWaitingTime = Integer.parseInt(sgipProps.getProperty("reconnectWaitingTime"));
//               threadWaitingTime = Integer.parseInt(sgipProps.getProperty("threadWaitingTime"));
//               checkThreadInterval = Integer.parseInt(sgipProps.getProperty("checkThreadInterval"));
//               countOfSeconds = Integer.parseInt(sgipProps.getProperty("countOfSeconds"));
//               connectionWaitingTime = Integer.parseInt(sgipProps.getProperty("connectionWaitingTime"));
          } catch (Exception e) {
               System.out.println("不能读取属性文件");
          }
     }
     public static void main(java.lang.String[] args) {
          try{
               System.out.println(uncode("60A8597D002C60A8768475286237540D662F003100330035003100390039003000300030003100305BC67801662F00390037003000380030002C8BF756DE586B786E8BA4FF0C542652198BA296054E0D6210529F30025BA2670DFF1A003000320031002D003300340032003400310037003400330020FF0C6B646761514D8D393002"));
//               Connection con =getConnection();
//               int i=0;
//               String sql="";
//               PreparedStatement stmt=null;

//               i=0; while(i<8     ) { sql="select TACMCHGDID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<125   ) { sql="select TACMCONTID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<324   ) { sql="select TACMCTTYID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<12756 ) { sql="select TACMURCTID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<246   ) { sql="select TADVCONTID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<180   ) { sql="select TADVLCONID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<60000) { sql="select TAWDUSERID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<381   ) { sql="select TBIZADDRID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<61    ) { sql="select TCHTCHATID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<61    ) { sql="select TCHTORDRID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<26618 ) { sql="select TCMMBLOGID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<41247 ) { sql="select TCMMFLOGID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<690   ) { sql="select TCMMRANGID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<332   ) { sql="select TCMMTRANID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<104   ) { sql="select TCRDCARDID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<453   ) { sql="select TCRDLISTID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<3341  ) { sql="select TCRDORDRID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<854   ) { sql="select TCRDORLSID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<19    ) { sql="select TCSSFAQSID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<356   ) { sql="select TCSSREQUID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<686   ) { sql="select TDAYWTHRID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<291   ) { sql="select TECLBINFID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<83    ) { sql="select TECLBSDIID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<81    ) { sql="select TECLBSRTID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<1279  ) { sql="select TFRMATCLID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<54    ) { sql="select TFRMEMTNID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<407   ) { sql="select TFRMFRUMID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<81    ) { sql="select TFRMORDRID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<1634  ) { sql="select TINFCONTID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<9     ) { sql="select TMRKGDSYID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<155   ) { sql="select TMRKGOODID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<9     ) { sql="select TMRKORDRID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<9     ) { sql="select TMRKORIMID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<226   ) { sql="select TOPMUSRSID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<6347  ) { sql="select TRUSUSRSID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<71    ) { sql="select TSDLSOFTID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<45    ) { sql="select TSDLSORTID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<127   ) { sql="select TSITECLSID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<1307  ) { sql="select TSMSADCTID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<438   ) { sql="select TSMSADGPID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<18    ) { sql="select TSMSADVEID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<209   ) { sql="select TSMSBLSTID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<3668  ) { sql="select TSMSCUSTID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<205   ) { sql="select TSMSFILTID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<807   ) { sql="select TSMSFVRTID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<1063  ) { sql="select TSMSIMGSID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<33    ) { sql="select TSMSINVTID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<1202  ) { sql="select TSMSLISTID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<18869 ) { sql="select TSMSLOGSID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<12    ) { sql="select TSMSMOKDID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<1     ) { sql="select TSMSMOTYID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<480   ) { sql="select TSMSRINGID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<2     ) { sql="select TSMSSRNGID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<9     ) { sql="select TSMSSUBJID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<7     ) { sql="select TSRVCLORID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<316   ) { sql="select TSRVOPTNID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<67    ) { sql="select TSRVQTNSID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<197   ) { sql="select TSRVSPROID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<6     ) { sql="select TSRVSPSPID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<561   ) { sql="select TSRVSPSVID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<136   ) { sql="select TSVRSENDID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               i=0; while(i<322   ) { sql="select TWEBSITEID.nextval from dual"; stmt=con.prepareStatement(sql);stmt.executeQuery();stmt.close();i++;}
//               con.close();

//               init();
//               java.util.StringTokenizer st = new java.util.StringTokenizer("", ",");
//               System.out.println(st.countTokens());
//               try{
//               Connection con =getConnection();
//               String select1="'%' or ''='%'";
//               String strSearch=" and (name like \'%"+select1+"%\')";
//               strSearch=strSearch+" and userid=43";
//               String sql="select count(*) as cnt from tsmsadct where 1=1  and (name like "+select1+")";
//               sql="select * from tsmsadct";
//               sql="update trususrs set loginname='xxun' where loginname='xxu'";
//               sql="insert into TSMS1021 (seqAddr,seqDate,sequence,messageLength,commandID,submitSeqAddr,submitSeqDate,submitSequence,reportType,userNumber,state,errorCode,reserve) values (-1221824284,521102752,105,64,5,300005,521101516,33,0,'8613308468736',0,0,'')";
//               System.out.println(sql);
//               PreparedStatement stmt=con.prepareStatement(sql);
//               int aa=stmt.executeUpdate();
//               System.out.println(aa);
//               stmt.setString(1,select1);
//               ResultSet rs=stmt.executeQuery();
//               while(i<4){
//                    rs.next();
//                    i++;
//                    System.out.println(i);
//               }
//               if(rs.next()){
//                    if(rs.getString("spNumber")!=null&&!rs.getString("spNumber").equals("")){
//                         System.out.println("0");
//                    }else{
//                         System.out.println("1");
//                    }
//                    if(rs.getInt("reportFlag")!=0){
//                         System.out.println("0");
//                    }else{
//                         System.out.println("1");
//                    }
//                    System.out.println(rs.getInt("reportFlag"));
//               }
//               stmt.close();
//               String aa="Amk1000";