自己写的粗糙的Excel数据驱动Http接口测试框架（一）

1、excel用例：

2、用例执行：

@Test
public void BindBank() throws Exception {
    String fileName = "src/main/java/com/datatrees/testcase/BindBank.xlsx";
    handleOk &= initData(userName,enmobile);
    Runner.execute(fileName, mobile);
    System.out.println("##############－》 测试结束");
}

3、Runner封装类

package com.datatrees.framwork;

import com.datatrees.httpHelp.HttpUtils2;
import com.datatrees.httpHelp.TokenUtils;
import com.datatrees.httpHelp.common;

import java.text.SimpleDateFormat;
import java.util.*;

/**
 * Created by lyh on 17/3/24.
 */
public class Runner {

    //无需登录
    // 执行一条用例，写入一次excel
    public static void execute(String filepath) throws Exception { //--target/classes目录下的文件路径
        List<TestCase> testCases = ExcelUtil.read(filepath);
        int row = 0;
        String respost="";
        //遍历测试用例
        for (TestCase testCase : testCases) {
            row++;
            //URL
            String url = common.pdl_uri + testCase.getPath();
            //参数maps
            List<String> params = new ArrayList();
            Map paramMaps = new HashMap();
            params.add(testCase.getFirstParam());
            params.add(testCase.getSecondParam());
            params.add(testCase.getThirdParam());
            params.add(testCase.getForthParam());
            params.add(testCase.getFifthParam());
            params.add(testCase.getParam_6());
            params.add(testCase.getParam_7());
            for (String param : params) {
                String[] apiParam;
                if (param.contains("-")) {
                    //参数属性和值
                    apiParam = param.split("-");
                    paramMaps.put(apiParam[0], apiParam[1]);
                    System.out.println(paramMaps);
                }
                if (!paramMaps.isEmpty()) {
                    //调用http接口发送请求
                    respost = HttpUtils2.sendHttpPost(url, paramMaps, "utf-8");

                    System.out.print(respost);
                } else {
                    //调用http接口发送请求
                    respost = HttpUtils2.sendHttpPost(url, "utf-8");
                    System.out.print(respost);
                }

            }
            SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");//设置日期格式
            String executTime = df.format(new Date());
            //写入实际值到excel和判断
            CompareRes.compare2(filepath, testCase, respost,executTime,row);
        }
    }


    //需要登录token执行一条用例，写入一次excel
    public static void execute(String filepath,String mobile) throws Exception { //--target/classes目录下的文件路径
        List<TestCase> testCases = ExcelUtil.read(filepath);
        int row = 0;
        TokenUtils tokencode=new TokenUtils();
        UserTokenCode userTokenCode = tokencode.getTokenCode(mobile);


        //遍历测试用例
        for (TestCase testCase : testCases) {
            row++;
            //URL
            String url = common.pdl_uri + testCase.getPath();
            String respost="";
            //参数maps
            List<String> params = new ArrayList();

            Map paramMaps = new HashMap();
            params.add(testCase.getFirstParam());
            params.add(testCase.getSecondParam());
            params.add(testCase.getThirdParam());
            params.add(testCase.getForthParam());
            params.add(testCase.getFifthParam());
            params.add(testCase.getParam_6());
            params.add(testCase.getParam_7());

            for (String param : params) {
                String[] apiParam;
                if (param.contains("-")) {
                    //参数属性和值
                    apiParam = param.split("-");
                    paramMaps.put(apiParam[0], apiParam[1]);

                    System.out.println(paramMaps);
                }
            }
            paramMaps.put("userId", userTokenCode.getUserId());
            paramMaps.put("token", userTokenCode.getTokenCode());
            if (!paramMaps.isEmpty()) {
                    //调用http接口发送请求
                respost = HttpUtils2.sendHttpPost(url, paramMaps, "utf-8");
                System.out.print(respost);
            } else {
                //调用http接口发送请求
                respost = HttpUtils2.sendHttpPost(url, "utf-8");
                System.out.print(respost);
            }
            SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");//设置日期格式
            String executTime = df.format(new Date());
            //写入实际值到excel和判断
            CompareRes.compare2(filepath, testCase, respost,executTime, row);
            }

        }
    //执行完全部测试用例后，将测试结果一次写入excel
    public static void execute2(String filepath) throws Exception { //--target/classes目录下的文件路径
        List<TestCase> testCases = ExcelUtil.read(filepath);
        int row = 0;

        //遍历测试用例
        for (TestCase testCase : testCases) {
            row++;
            //URL
            String url = common.pdl_uri + testCase.getPath();
            String respost;
            //参数maps
            List<String> params = new ArrayList();
            Map paramMaps = new HashMap();
            params.add(testCase.getFirstParam());
            params.add(testCase.getSecondParam());
            params.add(testCase.getThirdParam());
            params.add(testCase.getForthParam());
            params.add(testCase.getFifthParam());
            params.add(testCase.getParam_6());
            params.add(testCase.getParam_7());


            for (String param : params) {
                String[] apiParam;
                if (param.contains("-")) {
                    //参数属性和值
                    apiParam = param.split("-");
                    paramMaps.put(apiParam[0], apiParam[1]);
//
                    System.out.println(paramMaps);
                }
                if (!paramMaps.isEmpty()) {
                    //调用http接口发送请求
                    respost = HttpUtils2.sendHttpPost(url, paramMaps, "utf-8");
                    System.out.print(respost);
                } else {
                    //调用http接口发送请求
                    respost = HttpUtils2.sendHttpPost(url, "utf-8");
                    System.out.print(respost);
                }
                SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");//设置日期格式
                String executTime = df.format(new Date());
                //实际值填入testcase对象
                testCase.setActResu(respost);
                testCase.setExecuteTime(executTime);
                //将测试结果和报错信息填入testcase
                CompareRes.compare(testCase);

                //将testCase中的实际值，测试结果和报错信息填入excel
            }
            //写入实际值到excel和判断
            row = 0;
            CompareRes.WriteResult(filepath, testCases, row);
        }
    }
}
4、结果比较类

package com.datatrees.framwork;

import com.alibaba.fastjson.JSONObject;
import org.apache.log4j.Logger;

import java.util.*;

/**
 * Created by lyh on 17/3/23.
 */
public class CompareRes {
    private static Logger logger = Logger.getLogger(com.datatrees.framwork.TestCase.class);

    //每执行一个用例，将测试结果相关数据填入一次excel
    public static void compare2(String filePath, TestCase testCase, String actResu,String executeTime, int row) {
        int actResuNo = 12;//测试结果在第13例
        int ExecuteTimeNo = 13;//对比结果在第14列
        int TestResNo = 14;//对比结果在第15列
        int CommentNo = 15;//报错信息在16列
        JSONObject actRes_jsonObject;
        ExcelUtil.writeCell(filePath, row, ExecuteTimeNo, executeTime);
        ExcelUtil.writeCell(filePath, row, actResuNo, actResu);
        testCase.setActResu(actResu);
        String actRes = testCase.getActResu();
        String expRes = testCase.getExpResu();
        Map<String, String> actdata_map = new HashMap<String, String>();
        Map<String, String> expdata_map = new HashMap<String, String>();
        if (actRes.startsWith("{")) {
            actRes_jsonObject = JSONObject.parseObject(actRes);
            JSONObject expRes_jsonObject = JSONObject.parseObject(expRes);
            String actErrorMsg = actRes_jsonObject.getString("errorMsg");
            String actCode = actRes_jsonObject.getString("code");
            String expErrorMsg = expRes_jsonObject.getString("errorMsg");
            String expCode = expRes_jsonObject.getString("code");
            String act_data = actRes_jsonObject.getString("data");
            String exp_data = expRes_jsonObject.getString("data");
//            if (act_data != null && act_data.startsWith("{")) {
//                actdata_map = JsonsUtil.convertJsonStrToMap(act_data.trim());
//            }
//            if (exp_data != null && act_data.startsWith("{")) {
//                expdata_map = JsonsUtil.convertJsonStrToMap(exp_data.trim());
//            }
            if (exp_data != null&&act_data!=null) {
                if (actErrorMsg.trim().equals(expErrorMsg.trim()) && actCode.trim().equals(expCode.trim()) && ((act_data.trim().equals(exp_data.trim())) || (actdata_map.size() == expdata_map.size()))) {
                    ExcelUtil.writeCell(filePath, row, TestResNo, "Passed");
                } else if (actErrorMsg.trim().equals(expErrorMsg) == false) {
                    ExcelUtil.writeCell(filePath, row, TestResNo, "Failed");
                    ExcelUtil.writeCell(filePath, row, CommentNo, "expErrorMsg不相同");
                } else if (actCode.trim().equals(expCode) == false) {
                    ExcelUtil.writeCell(filePath, row, TestResNo, "Failed");
                    ExcelUtil.writeCell(filePath, row, CommentNo, "expCode不相同");
                } else if (act_data.trim().equals(exp_data) == false) {
                    ExcelUtil.writeCell(filePath, row, TestResNo, "Failed");
                    ExcelUtil.writeCell(filePath, row, CommentNo, "data不相同");
                }
            } else if (exp_data==null&&act_data==null){
                if (actErrorMsg.trim().equals(expErrorMsg) && actCode.trim().equals(expCode)) {
                    ExcelUtil.writeCell(filePath, row, TestResNo, "Passed");
                } else if (actErrorMsg.trim().equals(expErrorMsg) == false) {
                    ExcelUtil.writeCell(filePath, row, TestResNo, "Failed");
                    ExcelUtil.writeCell(filePath, row, CommentNo, "expErrorMsg不相同");
                } else if (actCode.trim().equals(expCode) == false) {
                    ExcelUtil.writeCell(filePath, row, TestResNo, "Failed");
                    ExcelUtil.writeCell(filePath, row, CommentNo, "expCode不相同");
                }
            }else {
                ExcelUtil.writeCell(filePath, row, TestResNo, "Failed");
                ExcelUtil.writeCell(filePath, row, CommentNo, "返回结果错误1");
            }
        } else {
            ExcelUtil.writeCell(filePath, row, TestResNo, "Failed");
            ExcelUtil.writeCell(filePath, row, CommentNo, "返回结果错误");
        }
    }

    //将用例都执行完，再将结果一次全部填入excel
    public static void WriteResult(String filePath, List<TestCase> testCases, int row) {
        int actResuNo = 12;//测试结果在第13例
        int executeNo = 13;//对比结果在第14列
        int TestResNo = 14;//对比结果在第15列
        int CommentNo = 15;//报错信息在16列
        for (TestCase testcase : testCases) {
            row++;
            ExcelUtil.writeCell(filePath, row, actResuNo, testcase.getActResu());
            ExcelUtil.writeCell(filePath, row, executeNo, testcase.getExecuteTime());
            ExcelUtil.writeCell(filePath, row, TestResNo, testcase.getTestResult());
            ExcelUtil.writeCell(filePath, row, CommentNo, testcase.getComment());
        }
    }

    //实际值与预期值对比，并写入testcase对象
    public static void compare(TestCase testCase) {

        String actRes = testCase.getActResu();
        String expRes = testCase.getExpResu();
        JSONObject actRes_jsonObject;
        if (actRes.startsWith("{")) {
            actRes_jsonObject = JSONObject.parseObject(actRes);
            JSONObject expRes_jsonObject = JSONObject.parseObject(expRes);
            String actErrorMsg = actRes_jsonObject.getString("errorMsg");
            String actCode = actRes_jsonObject.getString("code");
            String act_data = actRes_jsonObject.getString("data");
            String expErrorMsg = expRes_jsonObject.getString("errorMsg");
            String expCode = expRes_jsonObject.getString("code");
            String exp_data = expRes_jsonObject.getString("data");

            if (actErrorMsg.trim().equals(expErrorMsg) && actCode.trim().equals(expCode) && act_data.trim().equals(exp_data)) {
                testCase.setTestResult("Passed");
            } else if (actErrorMsg.trim().equals(expErrorMsg) == false) {
                testCase.setTestResult("Failed");
                testCase.setComment("expErrorMsg不相同");
            } else if (actCode.trim().equals(expCode) == false) {
                testCase.setTestResult("Failed");
                testCase.setComment("expCode不相同");
            } else if (act_data.trim().equals(exp_data) == false) {
                testCase.setTestResult("Failed");
                testCase.setComment("data不相同");
            }
        } else {
            testCase.setTestResult("Failed");
            testCase.setComment("实际值与预期值不同");
        }
    }


    //断言优化
    public static void execute3(String filePath, TestCase testCase, String actResu, int row) {
        int actResuNo = 12;//测试结果在第13例
        int TestResNo = 13;//对比结果在第14列
        int CommentNo = 14;//报错信息在15列
        ExcelUtil.writeCell(filePath, row, actResuNo, actResu);
        testCase.setActResu(actResu);
        String actRes = testCase.getActResu();
        String expRes = testCase.getExpResu();
        String caseName = testCase.getSubID();
        AssertResult.AssertFunction(caseName, expRes, actRes, filePath, row);
    }

}

5、excelUtil类：

package com.datatrees.framwork;

import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.List;

/**
 * Created by lyh on 17/3/23.
 */
public class ExcelUtil {
    //读取Excel中数据
    public static List<TestCase> read(String fileName) throws Exception {
        XSSFWorkbook wb = new XSSFWorkbook();
        XSSFSheet s = wb.createSheet();
        XSSFRow row = s.createRow(0);
        XSSFCell cell = row.createCell((int) 0, 0);
        //－－－－－－－－－－－－从xls读出数据
//        fileName = ClassLoader.getSystemResource("").toString().replace("file:", "").replace("target/classes/", "").trim() + fileName;

        wb = new XSSFWorkbook(new FileInputStream(fileName));

        s = wb.getSheetAt(0);

        //获得EXCEL行数
        int rowNums = s.getLastRowNum();
        //获得Excell列数
        //int columnNum=r.getPhysicalNumberOfCells();

        List<TestCase> testCases = new ArrayList<TestCase>();
        for (int i = 1; i <= rowNums; i++) {
            XSSFRow r = s.getRow(i);
//            cell = r.getCell(0);
            TestCase testCase = new TestCase();

            testCase.setID(getCellValue(r.getCell(0)));
            testCase.setSubID(r.getCell(1).getStringCellValue());
            testCase.setCaseDes(r.getCell(2).getStringCellValue());
            testCase.setPath(r.getCell(3).getStringCellValue());

            testCase.setFirstParam(r.getCell(4).getStringCellValue());
            testCase.setSecondParam(r.getCell(5).getStringCellValue());
            testCase.setThirdParam(r.getCell(6).getStringCellValue());
            testCase.setForthParam(r.getCell(7).getStringCellValue());
            testCase.setFifthParam(r.getCell(8).getStringCellValue());
            testCase.setParam_6(r.getCell(9).getStringCellValue());
            testCase.setParam_7(r.getCell(10).getStringCellValue());

            testCase.setExpResu(r.getCell(11).getStringCellValue());
            testCase.setActResu(r.getCell(12).getStringCellValue());
            testCase.setExecuteTime(r.getCell(13).getStringCellValue());
            testCase.setTestResult(r.getCell(14).getStringCellValue());
            testCase.setComment(r.getCell(15).getStringCellValue());
//        System.out.println(cell.getRichStringCellValue());
                testCases.add(testCase);

        }
        return testCases;

    }

    /**
     * 写入Excel，在任意坐标处写入数据。
     * String value：你要输入的内容
     * int x ：行坐标，Excel从 0 算起
     * int y   ：列坐标，Excel从 0 算起
     */
    public static void writeCell(String filePath, int x, int y, String value) {
        try {
            // 创建Excel的工作书册 Workbook,对应到一个excel文档
            XSSFWorkbook wb = new XSSFWorkbook(new FileInputStream(filePath));
            XSSFSheet sheet = wb.getSheetAt(0);
            XSSFRow row = sheet.getRow(x);
            XSSFCell cell = row.getCell((short) y);
            cell.setCellValue(value);
            FileOutputStream os;
            os = new FileOutputStream(filePath);
            wb.write(os);
            os.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    /**
     * 取表格值
     *
     * @param xssfCell XSSFCell类型对象，表示单元格。
     * @return：返回单元格数值
     */

    public static String getCellValue(XSSFCell xssfCell) {
        if (xssfCell.getCellType() == xssfCell.CELL_TYPE_BOOLEAN) {
            return String.valueOf(xssfCell.getBooleanCellValue());
        } else if (xssfCell.getCellType() == xssfCell.CELL_TYPE_NUMERIC) {
            return new BigDecimal(xssfCell.getNumericCellValue()).toPlainString();
//            return String.valueOf(xssfCell.getNumericCellValue());
        } else {
            return String.valueOf(xssfCell.getStringCellValue());
        }

    }
}
6、用例类：

package com.datatrees.framwork;

/**
 * Created by lyh on 17/3/23.
 */
public class TestCase {
    String ID;//编号
    String SubID;//姓名
    String CaseDes;//年龄
    String Path;//路径
    String FirstParam;//第一个参数
    String SecondParam;//第二个参数
    String ThirdParam;//第三个参数
    String ForthParam;//第四个参数
    String FifthParam;//第五个参数
    String Param_6;//第6个参数
    String Param_7;//第7个参数

    String expResu;//期望结果
    String actResu;//实际结果
    String executeTime;//执行时间
    String TestResult;//是否通过
    String Comment;//描述


    public TestCase() {
    }

    public String getExecuteTime() {
        return executeTime;
    }

    public void setExecuteTime(String executeTime) {
        this.executeTime = executeTime;
    }
    public String getParam_7() {
        return Param_7;
    }

    public void setParam_7(String param_7) {
        Param_7 = param_7;
    }
    public String getParam_6() {
        return Param_6;
    }

    public void setParam_6(String param_6) {
        Param_6 = param_6;
    }

    public String getID() {
        return ID;
    }

    public void setID(String ID) {
        this.ID = ID;
    }
    public String getSubID() {
        return SubID;
    }

    public void setSubID(String subID) {
        SubID = subID;
    }

    public String getCaseDes() {
        return CaseDes;
    }

    public void setCaseDes(String caseDes) {
        CaseDes = caseDes;
    }

    public String getPath() {
        return Path;
    }

    public void setPath(String path) {
        Path = path;
    }

    public String getFirstParam() {
        return FirstParam;
    }

    public void setFirstParam(String firstParam) {
        FirstParam = firstParam;
    }

    public String getSecondParam() {
        return SecondParam;
    }

    public void setSecondParam(String secondParam) {
        SecondParam = secondParam;
    }

    public String getThirdParam() {
        return ThirdParam;
    }

    public void setThirdParam(String thirdParam) {
        ThirdParam = thirdParam;
    }

    public String getForthParam() {
        return ForthParam;
    }

    public void setForthParam(String forthParam) {
        ForthParam = forthParam;
    }

    public String getFifthParam() {
        return FifthParam;
    }

    public void setFifthParam(String fifthParam) {
        FifthParam = fifthParam;
    }

    public String getExpResu() {
        return expResu;
    }

    public void setExpResu(String expResu) {
        this.expResu = expResu;
    }

    public String getActResu() {
        return actResu;
    }

    public void setActResu(String actResu) {
        this.actResu = actResu;
    }

    public String getTestResult() {
        return TestResult;
    }

    public void setTestResult(String testResult) {
        TestResult = testResult;
    }

    public String getComment() {
        return Comment;
    }

    public void setComment(String comment) {
        Comment = comment;
    }
}

7、http工具类：

package com.datatrees.httpHelp;

import com.alibaba.fastjson.JSONObject;
import org.apache.http.HttpEntity;
import org.apache.http.HttpResponse;
import org.apache.http.NameValuePair;
import org.apache.http.client.ClientProtocolException;
import org.apache.http.client.entity.UrlEncodedFormEntity;
import org.apache.http.client.methods.CloseableHttpResponse;
import org.apache.http.client.methods.HttpGet;
import org.apache.http.client.methods.HttpPost;
import org.apache.http.entity.StringEntity;
import org.apache.http.impl.client.CloseableHttpClient;
import org.apache.http.impl.client.HttpClients;
import org.apache.http.message.BasicNameValuePair;
import org.apache.http.util.EntityUtils;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import java.io.IOException;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import java.util.Map;

/**
 * Created by lyh on 17/3/16.
 */
public class HttpUtils2 {
    private static Logger logger = LoggerFactory.getLogger(HttpUtils2.class);
    private static CloseableHttpClient httpClient = HttpClients.createDefault();


    public String sendHttpGet(String url) {
        HttpGet httpGet = new HttpGet(url);
        String result = "fail";
        try {
            CloseableHttpResponse response = httpClient.execute(httpGet);
            if (response.getStatusLine().getStatusCode() == 200) {
                result = EntityUtils.toString(response.getEntity());
                logger.debug(result);
            }
        } catch (ClientProtocolException e) {
            logger.error(e.toString());
        } catch (IOException e) {
            logger.error(e.toString());
        }
        return result;
    }

    public static String sendHttpPost(String url, JSONObject json, String charset) {
        HttpPost httppost = new HttpPost(url);
        httppost.setHeader("Content-type", "application/json");
        httppost.setHeader("Accept", "application/json;charset=UTF-8");
        String result = "fail";
        try {
            StringEntity entity = new StringEntity(json.toString(), charset);
            entity.setContentEncoding("UTF-8");
            httppost.setEntity(entity);
            HttpResponse response = httpClient.execute(httppost);
            System.out.println(response.getStatusLine().getStatusCode());
            if (response.getStatusLine().getStatusCode() == 200) {
                //读返回数据
                result = EntityUtils.toString(response.getEntity());
            }
        } catch (ClientProtocolException e) {
            e.printStackTrace();
        } catch (IOException e) {
            logger.error(e.toString());
        }
        return result;
    }

    public static String sendHttpPost(String url, Map<String, String> map, String charset) {
        logger.info(url);
        System.out.print("url:"+url);
        HttpPost httpPost = new HttpPost(url);

        String result = null;

        try {
            //设置参数
            List<NameValuePair> list = new ArrayList<NameValuePair>();
            Iterator iterator = map.entrySet().iterator();
            while (iterator.hasNext()) {
                Map.Entry<String, String> elem = (Map.Entry<String, String>) iterator.next();
                list.add(new BasicNameValuePair(elem.getKey(), elem.getValue()));
            }
            if (list.size() > 0) {
                UrlEncodedFormEntity entity = new UrlEncodedFormEntity(list, charset);
                httpPost.setEntity(entity);
            }
            HttpResponse response = httpClient.execute(httpPost);
            if (response != null) {
                HttpEntity resEntity = response.getEntity();
                if (resEntity != null) {
                    result = EntityUtils.toString(resEntity, charset);
                }
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        return result;
    }

    public static String sendHttpPost2(String url, Map<String, String> map, String charset) {
        HttpPost httpPost = new HttpPost(url);
        String result = null;

        try {
            //设置参数
            List<NameValuePair> list = new ArrayList<NameValuePair>();
            Iterator iterator = map.entrySet().iterator();
            while (iterator.hasNext()) {
                Map.Entry<String, String> elem = (Map.Entry<String, String>) iterator.next();
                list.add(new BasicNameValuePair(elem.getKey(), elem.getValue()));
            }
            if (list.size() > 0) {
                UrlEncodedFormEntity entity = new UrlEncodedFormEntity(list, charset);
                httpPost.setEntity(entity);
            }
            HttpResponse response = httpClient.execute(httpPost);
            if (response != null) {
                HttpEntity resEntity = response.getEntity();
                if (resEntity != null) {
                    result = EntityUtils.toString(resEntity, charset);
                }
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        return result;
    }

    public static String sendHttpPost(String url, List<NameValuePair> list, String charset) {
        HttpPost httpPost = new HttpPost(url);
        String result = null;
        try {
            if (list.size() > 0) {
                UrlEncodedFormEntity entity = new UrlEncodedFormEntity(list, charset);
                httpPost.setEntity(entity);
            }
            HttpResponse response = httpClient.execute(httpPost);
            if (response != null) {
                HttpEntity resEntity = response.getEntity();
                if (resEntity != null) {
                    result = EntityUtils.toString(resEntity, charset);
                }
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        return result;
    }
    public static String sendHttpPost(String url, String charset) {
        HttpPost httpPost = new HttpPost(url);
        String result = null;
        try {
            HttpResponse response = httpClient.execute(httpPost);
            if (response != null) {
                HttpEntity resEntity = response.getEntity();
                if (resEntity != null) {
                    result = EntityUtils.toString(resEntity, charset);
                }
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        return result;
    }
    public static String sendHttpPost(String url) {
        HttpPost httpPost = new HttpPost(url);
        String result = null;
        try {
            HttpResponse response = httpClient.execute(httpPost);
            if (response != null) {
                HttpEntity resEntity = response.getEntity();
                if (resEntity != null) {
                    result = EntityUtils.toString(resEntity, "utf-8");
                }
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        return result;
    }
}