联通在信业务SP反向退订

1、需求说明

搞了一段时间联通在信业务，由于某些原因，需要对一批号码进行批量退订

2、知识点说明

1、http请求，由于请求接口返回只是类似Error$000000或者OK，采用的是org.apache.commons.httpclient.HttpClient
2、3DES加密
3、BASE64加码解码

3、代码

直接上代码吧，不说废话，主要是TripleDES.java和QuxiaoBY.java两个类
不愿意看的，直接下demo吧demo下载
3.1、TripleDES.java

import java.security.Security;

import javax.crypto.Cipher;
import javax.crypto.SecretKey;
import javax.crypto.spec.SecretKeySpec;

import sun.misc.BASE64Decoder;
import sun.misc.BASE64Encoder;

public class TripleDES {
    private static final Cipher cipher = initCipher();
    private static final BASE64Encoder base64 = new BASE64Encoder();

    private static final Cipher initCipher() {
        try {
            // 添加新安全算法:PKCS7
            Security.addProvider(new org.bouncycastle.jce.provider.BouncyCastleProvider());
            String algorithm = "DESede/ECB/PKCS7Padding";
            SecretKey desKey = new SecretKeySpec(
                    (new BASE64Decoder())
                            .decodeBuffer(Common.DES_KEY_STRING),
                    algorithm);
            Cipher tcipher = Cipher.getInstance(algorithm);
            tcipher.init(Cipher.ENCRYPT_MODE, desKey);
            return tcipher;
        } catch (Exception e) {
            e.printStackTrace();
        }
        return null;
    }

    public static String encrypt1(String src) {
        return base64.encode(encrypt(src.getBytes()));
    }

    public static byte[] encrypt(byte[] src) {
        try {
            return cipher.doFinal(src);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return null;
    }


    public static void main(String[] args) throws Exception {
        System.out.println("1-->"+encrypt1("12345"));

    }

}

3.2、QuxiaoBY.java

import java.io.IOException;
import java.io.UnsupportedEncodingException;
import java.net.URLEncoder;
import java.sql.SQLException;
import java.text.ParseException;
import java.util.HashMap;
import java.util.List;

import org.apache.commons.httpclient.DefaultHttpMethodRetryHandler;
import org.apache.commons.httpclient.HttpClient;
import org.apache.commons.httpclient.HttpException;
import org.apache.commons.httpclient.HttpStatus;
import org.apache.commons.httpclient.methods.GetMethod;
import org.apache.commons.httpclient.params.HttpMethodParams;

public class QuxiaoBY {
    public static void selectbyhaoma() throws SQLException, IOException {

        List byhmList = DbUtil.selectAll("select phone,accesstime from t_byhaoma");
        //System.out.println("list:" + byhmList.get(0));

        for (int i = 0; i < byhmList.size(); i++) {
            HashMap<String, Object> hm = (HashMap<String, Object>) byhmList
                    .get(i);
            System.out.println(String.valueOf(i)+"-->>"+hm.get("phone") + "-->>"
                    + requesturl(hm));
        }
    }

    public static String desString(HashMap<String, Object> hashMap) throws UnsupportedEncodingException {
        String orignalString =Common.SPNUMBER_STRING + "$" + hashMap.get("phone")
                + "$" + Common.SERVICE_TAG_STRING + "$" + hashMap.get("accesstime");
        String EncodeStr = URLEncoder.encode(TripleDES
                .encrypt1((orignalString)),"UTF-8");
        //System.out.println(orignalString+"<<<<>>>"+EncodeStr);
        return EncodeStr;
    }

    public static String requesturl(HashMap<String, Object> hashMap) throws UnsupportedEncodingException {

        String strurl = Common.TUIDING_URL + "SpNumber="+Common.SPNUMBER_STRING+"&AccessTime="+((String)hashMap.get("accesstime")).replace(" ", "%20")+"&EncodeStr="+desString(hashMap);
        String resultString = "null";
        HttpClient httpClient = new HttpClient();
        // 创建GET方法的实例
        GetMethod getMethod = new GetMethod(strurl);
        // 使用系统提供的默认的恢复策略
        getMethod.getParams().setParameter(HttpMethodParams.RETRY_HANDLER,
                new DefaultHttpMethodRetryHandler());
        try {
            // 执行getMethod
            int statusCode = httpClient.executeMethod(getMethod);
            if (statusCode != HttpStatus.SC_OK) {
                System.err.println("Method failed: "
                        + getMethod.getStatusLine());
            }
            // 读取内容
            byte[] responseBody = getMethod.getResponseBody();
            // 处理内容
            resultString =  new String(responseBody);
        } catch (HttpException e) {
            // 发生致命的异常，可能是协议不对或者返回的内容有问题
            System.out.println("Please check your provided http address!");
            e.printStackTrace();
        } catch (IOException e) {
            // 发生网络异常
            e.printStackTrace();
        } finally {
            // 释放连接
            getMethod.releaseConnection();
        }
        return resultString;
    }

    public static void main(String[] args) throws IOException, SQLException,
            ParseException {

        selectbyhaoma();
        System.out.println("end");
    }
}

3.3、DbUtil.java

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Collections;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * @author zyq
 * @created 2016-12-18
 */
public class DbUtil {

    public static List selectAll(String sql) throws SQLException {
        Connection conn = null;
        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            Class.forName(Common.DRIVER);
            conn = DriverManager.getConnection(Common.URL, Common.USERNAME,
                    Common.PASSWORD);
            ps = conn.prepareStatement(sql);
            rs = ps.executeQuery();

            if (rs == null)   
                   return Collections.EMPTY_LIST;   
               ResultSetMetaData md = (ResultSetMetaData) rs.getMetaData(); //得到结果集(rs)的结构信息，比如字段数、字段名等   
               int columnCount = md.getColumnCount(); //返回此 ResultSet 对象中的列数   
               List list = new ArrayList();   
               Map rowData = new HashMap();   
               while (rs.next()) {   
                rowData = new HashMap(columnCount);   
                for (int i = 1; i <= columnCount; i++) {   
                        rowData.put(md.getColumnName(i), rs.getObject(i));   
                }   
                list.add(rowData);   
               }   
               return list;   
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            if (rs != null) {
                rs.close();
            }
            if (ps != null) {
                ps.close();
            }
            if (conn != null) {
                conn.close();
            }
        }
        return null;
    }

}

3.4、Common.java

/**
 * @author zyq
 * @created 2016-12-18
 */
public class Common {

    // connect the database
    public static final String DRIVER = "com.mysql.jdbc.Driver";
    public static final String DB_NAME = "test";
    public static final String USERNAME = "root";
    public static final String PASSWORD = "12345";
    public static final String IP = "127.0.0.1";
    public static final String PORT = "3306";
    public static final String URL = "jdbc:mysql://" + IP + ":" + PORT + "/" + DB_NAME+"?characterEncoding=utf-8";

    public static final String TUIDING_URL = "http://www.tuiding.com?";//请求地址
    public static final String SPNUMBER_STRING ="10650000";//spnumber
    public static final String SERVICE_TAG_STRING = "xxxx";//指令
    public static final String DES_KEY_STRING = "xxxx";//密钥
}