path, value
post, 1
post, 2
post, 3
post, 4

tar -xvf /Users/xxx/Downloads/rarosx-5.8.b1.tar

# 切换到/usr/local/bin目录下
# 注意不能是/usr/bin目录，Mac上没有修改权限

# 软连接的命令是ln -s 想要链接的可执行文件 创建的命令
sudo ln -s /Users/xxx/Downloads/rar/rar rar

# 上述/Users/xxx/Downloads/rar/rar就是你rarlab解压后里面的rar可执行文件所在位置，rar是你为这个连接创建的命令

rar e /Users/xxx/Downloads/AndroidTool.rar 

# 执行结果
RAR 5.80 beta 1   Copyright (c) 1993-2019 Alexander Roshal   11 Sep 2019
Trial version             Type 'rar -?' for help


Extracting from /Users/xxx/Downloads/AndroidTool.rar

Extracting  psb.jpg                                                   OK 
Extracting  AXmlResourceParser.jar                                    OK 
Extracting  dd-plist-1.16.jar                                         OK 
Extracting  AndroidTool.exe                                           OK 
Extracting  favicon.ico                                               OK 
Extracting  使用说明.txt                                                  OK 
All OK

- TestNG 5.14.3: Bad formatted pom.xml. 
- TestNG 5.14.4 and 5.14.5: TestNG is using a missing dependency (org.testng:guice:2.0). Excluding it, may break some features.

<dependencies>
[...]
    <dependency>
        <groupId>org.testng</groupId>
        <artifactId>testng</artifactId>
        <version>6.9.8</version>
        <scope>test</scope>
    </dependency>
[...]
</dependencies>

<dependencies>
[...]
    <dependency>
        <groupId>org.testng</groupId>
        <artifactId>testng</artifactId>
        <version>5.11</version>
        <scope>test</scope>
        <classifier>jdk15</classifier>
    </dependency>
[...]
</dependencies>

<plugins>
[...]
    <plugin>
        <groupId>org.apache.maven.plugins</groupId>
        <artifactId>maven-surefire-plugin</artifactId>
        <version>3.0.0-M3</version>
        <configuration>
            <suiteXmlFiles>
                <suiteXmlFile>testng.xml</suiteXmlFile>
            </suiteXmlFiles>
        </configuration>
    </plugin>
[...]
</plugins>

<plugins>
[...]
    <plugin>
        <groupId>org.apache.maven.plugins</groupId>
        <artifactId>maven-surefire-plugin</artifactId>
        <version>3.0.0-M3</version>
        <configuration>
            <systemPropertyVariables>
                <phoneNumber>11111111111</phoneNumber>
                <password>123456</password>
            </systemPropertyVariables>
        </configuration>
    </plugin>
[...]
</plugins>

<plugins>
[...]
    <plugin>
        <groupId>org.apache.maven.plugins</groupId>
        <artifactId>maven-surefire-plugin</artifactId>
        <version>3.0.0-M3</version>
        <configuration>
            <groups>functest,perftest</groups>
        </configuration>
    </plugin>
[...]
</plugins>

</plugins>
[...]
    <plugin>
        <groupId>org.apache.maven.plugins</groupId>
        <artifactId>maven-surefire-plugin</artifactId>
        <version>3.0.0-M3</version>
        <configuration>
            <parallel>methods</parallel>
            <threadCount>10</threadCount>
        </configuration>
    </plugin>
[...]
</plugins>

</plugins>
[...]
    <plugin>
        <groupId>org.apache.maven.plugins</groupId>
        <artifactId>maven-surefire-plugin</artifactId>
        <version>3.0.0-M3</version>
        <configuration>
            <suiteXmlFiles>
                <file>src/test/resources/testng1.xml</file>
                <file>src/test/resources/testng2.xml</file>
            </suiteXmlFiles>
            <properties>
                <property>
                    <name>suitethreadpoolsize</name>
                    <value>2</value>
                </property>
            </properties>
        </configuration>
    </plugin>
[...]
</plugins>

</plugins>
[...]
    <plugin>
        <groupId>org.apache.maven.plugins</groupId>
        <artifactId>maven-surefire-plugin</artifactId>
        <version>3.0.0-M3</version>
        <configuration>
            [...]
            <properties>
                <property>
                    <name>surefire.testng.verbose</name>
                    <value>10</value>
                </property>
            </properties>
            [...]
        </configuration>
    </plugin>
[...]
</plugins>

/Library/Frameworks/Python.framework/Versions/3.7/bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/Users/lulian/downloads/apache-maven-3.6.1/bin:/Applications/Wireshark.app/Contents/MacOS:/Library/Java/JavaVirtualMachines/jdk1.8.0_181.jdk/Contents/Home/bin:/Users/lulian/downloads/apache-maven-3.6.1/bin:/Users/lulian/Library/Android/sdk/tools:/Users/lulian/Library/Android/sdk/platform-tools

/etc/profile /etc/paths ~/.bash_profile ~/.bash_login ~/.profile ~/.bashrc

# 每个PATH之间都是使用冒号隔开的
export PATH=$PATH:<PATH 1>:<PATH 2>:<PATH 3>:------:<PATH N>
# 或者 
export PATH=${PATH}:<PATH 1>
export PATH=${PATH}:<PATH 2>

# export xxx可以理解为暴露一个名为xxx的变量，这里是PATH
# 当你想引用PATH变量时，就写成${PATH}

# 第一种将路径合并在一起，不方便删除，建议使用第二种，换行挨个设置

# 暴露一个名为TEST_PATH的变量，变量的值是某个路径
exoprt TEST_PATH=/Users/yeshou
# 将这个路径添加到PATH中，就是在现有的PATH后面加个冒号和TEST_PATH
export PATH=${PATH}:${TEST_PATH}
# 当然你也可以写成一行，但是两行看起来会比较清晰
export PATH=${PATH}:/Users/test

# 暴露ANDROID_HOME变量指向你下载的安卓sdk文件夹路径
export ANDROID_HOME=/Users/lulian/Library/Android/sdk
# 告诉path到tools和platform-tools目录下去找可执行文件
export PATH=${PATH}:${ANDROID_HOME}/tools
export PATH=${PATH}:${ANDROID_HOME}/platform-tools

luliandeMBP-2:~ lulian$ echo $ANDROID_HOME
/Users/lulian/Library/Android/sdk

package com.test.listener;

import org.testng.ITestContext;
import org.testng.ITestListener;
import org.testng.ITestResult;

public class MyListener implements ITestListener{

    @Override
    public void onTestStart(ITestResult result) {
        System.out.println("ITestListener_onTestStart:");
    }

    @Override
    public void onTestSuccess(ITestResult result) { 
        System.out.println("ITestListener_onTestSuccess:");
    }

    @Override
    public void onTestFailure(ITestResult result) { 
        System.out.println("ITestListener_onTestFailure:"); 
    }

    @Override
    public void onTestSkipped(ITestResult result) {
        System.out.println("ITestListener_onTestSkipped:");
    }

    @Override
    public void onTestFailedButWithinSuccessPercentage(ITestResult result) { }

    @Override
    public void onStart(ITestContext context) {
        System.out.println("ITestListener_onStart:");   
    }

    @Override
    public void onFinish(ITestContext context) {
        System.out.println("ITestListener_onFinish:");
    }
}

[RemoteTestNG] detected TestNG version 6.8.9
IExecutionListener_onExecutionStart
ISuiteListener_onStart
IConfigurationListener2_beforeConfiguration
IInvokedMethodListener2_beforeInvocation
测试类的@BeforeSuite
IInvokedMethodListener2_afterInvocation
IConfigurationListener2_onConfigurationSuccess
ITestListener_onStart:
IConfigurationListener2_beforeConfiguration
IInvokedMethodListener2_beforeInvocation
基类的@BeforeTest
IInvokedMethodListener2_afterInvocation
IConfigurationListener2_onConfigurationSuccess
IConfigurationListener2_beforeConfiguration
IInvokedMethodListener2_beforeInvocation
测试类的@BeforeClass
IInvokedMethodListener2_afterInvocation
IConfigurationListener2_onConfigurationSuccess
IConfigurationListener2_beforeConfiguration
IInvokedMethodListener2_beforeInvocation
测试类的@BeforeTest
IInvokedMethodListener2_afterInvocation
IConfigurationListener2_onConfigurationSuccess
测试类的@DataProvider
ITestListener_onTestStart:
IInvokedMethodListener2_beforeInvocation
测试类的@Test
IInvokedMethodListener2_afterInvocation
ITestListener_onTestSuccess:
ITestListener_onTestStart:
IInvokedMethodListener2_beforeInvocation
测试类的@Test
IInvokedMethodListener2_afterInvocation
ITestListener_onTestSuccess:
IConfigurationListener2_beforeConfiguration
IInvokedMethodListener2_beforeInvocation
测试类的@AfterClass
IInvokedMethodListener2_afterInvocation
IConfigurationListener2_onConfigurationSuccess
IConfigurationListener2_beforeConfiguration
IInvokedMethodListener2_beforeInvocation
测试类的@AfterTest
IInvokedMethodListener2_afterInvocation
IConfigurationListener2_onConfigurationSuccess
IConfigurationListener2_beforeConfiguration
IInvokedMethodListener2_beforeInvocation
基类的@AfterTest
IInvokedMethodListener2_afterInvocation
IConfigurationListener2_onConfigurationSuccess
ITestListener_onFinish:
IConfigurationListener2_beforeConfiguration
IInvokedMethodListener2_beforeInvocation
测试类的@AfterSuite
IInvokedMethodListener2_afterInvocation
IConfigurationListener2_onConfigurationSuccess
ISuiteListener_onFinish

===============================================
TestAllSheets
Total tests run: 2, Failures: 0, Skips: 0
===============================================

IExecutionListener_onExecutionFinish

@Listeners(MyListener.class)
public class listenerTest {
    @Test
    public void templistener1(){
        System.out.println("i'm listenerTest1");
    }
}

<!DOCTYPE suite SYSTEM "http://testng.org/testng-1.0.dtd" >

<suite name="TestAllSheets">
    <listeners>
        <listener class-name="com.test.listener.MyListener"></listener>
        <listener class-name="com.test.listener.MyForthListener"></listener>
        <listener class-name="com.test.listener.MyFifthListener"></listener>
        <listener class-name="com.test.listener.MySecondListener"></listener>
        <listener class-name="com.test.listener.MyThirdListener"></listener>
    </listeners>
    <test name="TestAllSheets" preserve-order="true">
        <classes>
            <class name="com.test.mutipulapi.TestAllSheets"></class>
        </classes>
    </test>
</suite>

package org.testng;

/**
* This class describes the result of a test.
*
* @author Cedric Beust, May 2, 2004
* @since May 2, 2004
* @version $Revision: 721 $, $Date: 2009-05-23 09:55:46 -0700 (Sat, 23 May 2009) $
*
*/
public interface ITestResult extends IAttributes, Comparable<ITestResult> {

    //
    // Test status
    //
    public static final int SUCCESS = 1;
    public static final int FAILURE = 2;
    public static final int SKIP = 3;
    public static final int SUCCESS_PERCENTAGE_FAILURE = 4;
    public static final int STARTED= 16;

    /**
    * @return The status of this result, using one of the constants
    * above.
    */
    public int getStatus();
    public void setStatus(int status);

    /**
    * @return The test method this result represents.
    */
    public ITestNGMethod getMethod();

    /**
    * @return The parameters this method was invoked with.
    */
    public Object[] getParameters();
    public void setParameters(Object[] parameters);

    /**
    * @return The test class used this object is a result for.
    */
    public IClass getTestClass();

    /**
    * @return The throwable that was thrown while running the
    * method, or null if no exception was thrown.
    */
    public Throwable getThrowable();
    public void setThrowable(Throwable throwable);

    /**
    * @return the start date for this test, in milliseconds.
    */
    public long getStartMillis();

    /**
    * @return the end date for this test, in milliseconds.
    */
    public long getEndMillis();
    public void setEndMillis(long millis);

    /**
    * @return The name of this TestResult, typically identical to the name
    * of the method.
    */
    public String getName();

    /**
    * @return true if if this test run is a SUCCESS
    */
    public boolean isSuccess();

    /**
    * @return The host where this suite was run, or null if it was run locally.  The
    * returned string has the form:  host:port
    */
    public String getHost();

    /**
    * The instance on which this method was run.
    */
    public Object getInstance();

    /**
    * If this result's related instance implements ITest, returns its test name, otherwise returns null.
    */
    public String getTestName();

    public String getInstanceName();

    /**
    * @return the {@link ITestContext} for this test result.
    */
    public ITestContext getTestContext();
}

@Override
public void onTestSuccess(ITestResult result) {
    System.out.println("ITestListener_onTestSuccess:");
    System.out.println("result status:" + result.getStatus());
    System.out.println("result host:" + result.getHost());
    System.out.println("result instance name:" + result.getInstanceName());
    System.out.println("result name:" + result.getName());
    System.out.println("result start millis:" + result.getStartMillis());
    System.out.println("result end millis:" + result.getEndMillis());
    System.out.println("result name:" + result.getName());
    System.out.println("result test name:" + result.getTestName());
    System.out.println("result is success:" + result.isSuccess());

    ITestNGMethod method = result.getMethod();
    System.out.println("result method description:" + method.getDescription());

    Object[] parameters = result.getParameters();
    System.out.println("result parameters:" + parameters.getClass().getSimpleName());
}

ITestListener_onTestSuccess:
result status:1
result host:null
result instance name:com.test.mutipulapi.TestAllSheets
result name:testDifferentSheets
result start millis:1566893197588
result end millis:1566893201413
result name:testDifferentSheets
result test name:null
result is success:true
result method description:null
result parameters:Object[]

package org.testng;

import com.google.inject.Injector;
import com.google.inject.Module;

import org.testng.xml.XmlTest;

import java.util.Collection;
import java.util.Date;
import java.util.List;


/**
* This class defines a test context which contains all the information
* for a given test run.  An instance of this context is passed to the
* test listeners so they can query information about their
* environment.
*
* @author Cedric Beust, Aug 6, 2004
* @author <a href='mailto:the_mindstorm@evolva.ro'>Alexandru Popescu</a>
*/
public interface ITestContext extends IAttributes {

    /**
    * The name of this test.
    */
    public String getName();

    /**
    * When this test started running.
    */
    public Date getStartDate();

    /**
    * When this test stopped running.
    */
    public Date getEndDate();

    /**
    * @return A list of all the tests that run successfully.
    */
    public IResultMap getPassedTests();

    /**
    * @return A list of all the tests that were skipped
    */
    public IResultMap  getSkippedTests();

    /**
    * @return A list of all the tests that failed but are being ignored because
    * annotated with a successPercentage.
    */
    public IResultMap  getFailedButWithinSuccessPercentageTests();

    /**
    * @return A map of all the tests that passed, indexed by
    * their ITextMethor.
    *
    * @see org.testng.ITestNGMethod
    */
    public IResultMap getFailedTests();

    /**
    * @return All the groups that are included for this test run.
    */
    public String[] getIncludedGroups();

    /**
    * @return All the groups that are excluded for this test run.
    */
    public String[] getExcludedGroups();

    /**
    * @return Where the reports will be generated.
    */
    public String getOutputDirectory();

    /**
    * @return The Suite object that was passed to the runner
    * at start-up.
    */
    public ISuite getSuite();

    /**
    * @return All the test methods that were run.
    */
    public ITestNGMethod[] getAllTestMethods();

    /**
    * @return The host where this test was run, or null if it was run locally.  The
    * returned string has the form:  host:port
    */
    public String getHost();

    /**
    * @return All the methods that were not included in this test run.
    */
    public Collection<ITestNGMethod> getExcludedMethods();

    /**
    * Retrieves information about the successful configuration method invocations.
    */
    public IResultMap getPassedConfigurations();

    /**
    * Retrieves information about the skipped configuration method invocations.
    */
    public IResultMap getSkippedConfigurations();

    /**
    * Retrieves information about the failed configuration method invocations.
    */
    public IResultMap getFailedConfigurations();

    /**
    * @return the current XmlTest.
    */
    public XmlTest getCurrentXmlTest();

    public List<Module> getGuiceModules(Class<? extends Module> cls);
    public void addGuiceModule(Class<? extends Module> cls, Module module);

    public Injector getInjector(List<Module> moduleInstances);
    public void addInjector(List<Module> moduleInstances, Injector injector);
}

@Override
public void onFinish(ITestContext context) {
    System.out.println("ITestListener_onFinish:");
    System.out.println("context name:" + context.getName());
    System.out.println("context suite name:" + context.getSuite().getName());
    System.out.println("context start date:" + context.getStartDate().toString());
    System.out.println("context end date:" + context.getEndDate().toString());
}

context name:TestAllSheets
context suite name:TestAllSheets
context start date:Tue Aug 27 16:10:16 CST 2019
context end date:Tue Aug 27 16:10:31 CST 2019

package org.testng;

/**
* An interface representing a method that has been invoked by TestNG.
*
* This interface is internal.
*/
public interface IInvokedMethod {

    /**
    * @return true if this method is a test method
    */
    public abstract boolean isTestMethod();

    /**
    * @return true if this method is a configuration method (@BeforeXXX or @AfterXXX)
    */
    public abstract boolean isConfigurationMethod();

    /**
    * @return the test method
    */
    public abstract ITestNGMethod getTestMethod();

    public ITestResult getTestResult();

    /**
    * @return the date when this method was run
    */
    public abstract long getDate();

}

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>

<groupId>apitest2</groupId>
<artifactId>apitest2</artifactId>
<version>0.0.1-SNAPSHOT</version>
<packaging>jar</packaging>

<name>apitest2</name>
<url>http://maven.apache.org</url>

<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
</properties>

<dependencies>
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>3.8.1</version>
        <scope>test</scope>
    </dependency>
    
    <!-- https://mvnrepository.com/artifact/org.apache.httpcomponents/httpclient -->
    <dependency>
        <groupId>org.apache.httpcomponents</groupId>
        <artifactId>httpclient</artifactId>
        <version>4.5.2</version>
    </dependency> 
    
    <!-- https://mvnrepository.com/artifact/org.apache.httpcomponents/httpcore -->
    <dependency>
        <groupId>org.apache.httpcomponents</groupId>
        <artifactId>httpcore</artifactId>
        <version>4.4.4</version>
    </dependency>
    
    <!-- https://mvnrepository.com/artifact/org.testng/testng -->
    <dependency>
        <groupId>org.testng</groupId>
        <artifactId>testng</artifactId>
        <version>6.8.8</version>
        <scope>test</scope>
    </dependency>

    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>fastjson</artifactId>
        <version>1.2.58</version>
    </dependency>
    
    <!-- https://mvnrepository.com/artifact/com.jayway.jsonpath/json-path -->
    <dependency>
        <groupId>com.jayway.jsonpath</groupId>
        <artifactId>json-path</artifactId>
        <version>2.4.0</version>
    </dependency>
    
    <!-- https://mvnrepository.com/artifact/net.sourceforge.jexcelapi/jxl -->
    <dependency>
        <groupId>net.sourceforge.jexcelapi</groupId>
        <artifactId>jxl</artifactId>
        <version>2.6.12</version>
    </dependency>

</dependencies>
</project>

public class TestApi {
    protected Properties prop;
    protected String excelPath;
    protected String host; 
    protected String url;
    protected JSONObject responseBody;
    protected int responseCode;
    protected String accessToken = "";
    protected String refreshToken = "";
    protected Map<String, String> tokenHeader;

    @BeforeTest
    public void setAccessToken() throws Exception{
        //先去读一下token文件看有没有
        readTokenFile();
        if(TextUtils.isEmpty(accessToken)) {
            //如果文件里没有内容，就获取2个token写进去
            GetToken.registerToken(host);
        }else {
            //文件里面有内容，要去用旧的token获取新的
            GetToken.refreshToken(host, accessToken, refreshToken);
            //换完了以后再更新一下TestApi这里的
            readTokenFile();
            tokenHeader = new HashMap<String, String>();
            tokenHeader.put("x-jike-access-token", accessToken);
            tokenHeader.put("x-jike-refresh-token", refreshToken);  
        }
    }

    public void readTokenFile() {
        try (FileReader reader = new FileReader(System.getProperty("user.dir") + "/src/main/resource/x-jike-access-token.txt"); 
        BufferedReader br = new BufferedReader(reader)) {
            //建议这里就读2行，分别赋值
            accessToken = br.readLine();
            if (!TextUtils.isEmpty(accessToken)) {
                refreshToken = br.readLine();
            }
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    //构造函数
    public TestApi() {
        try {
            //数据流的形式读取配置文件
            prop = new Properties();
            FileInputStream fis = new FileInputStream(System.getProperty("user.dir") + "/src/main/resource/config.properties");
            prop.load(fis);
        } catch (Exception e) {
            e.printStackTrace();
        }

    host = prop.getProperty("Host");
    excelPath = prop.getProperty("testData");   
    }
}

public class TraverseCases extends TestApi{
    Object[][] excelData;
    TestData testData;
    HttpRequest request;    
    int codeExpected;
    List<NameValuePair> bodyParams;
    List<TestData> testDatas;
    List<NameValuePair> checkPoints;

    @BeforeClass()
    public void setUp() throws Exception {
        //读取excel
        excelData = ExcelProcess.processExcel(excelPath);
        //实例化请求类
        request = new  HttpRequest();
    }

    @DataProvider(name="testData")
    private Iterator<Object[]> testDataProvider() throws IOException {
        List<Object[]> result= new ArrayList<Object[]>();
        List<TestData> alldata = new ArrayList<TestData>();
        TestData td = null;
        for(int i = 1; i < excelData.length; i++) {
            //防止Excel里面有空行
            if(excelData[i][0] == null) {
                continue;
            }
            //实例化测试数据
            td = new TestData(i, excelData);
            if(td.isEnabled()) {
                alldata.add(td);
            }
        }
        Iterator it = alldata.iterator();
        while(it.hasNext()){
            result.add(new Object[] { it.next() });
        }
        return  result.iterator();
    }

    @Test(dataProvider = "testData")
    public void testDifferentCases(TestData testData) throws IOException {
        //传入的参数就是每一条测试数据
        if (testData != null) {
            LogUtil.info("Testcase description:" + testData.getTestDescription());
            bodyParams = testData.getKeys();
            url = host + testData.getAddress();
            LogUtil.info("Request url:" + url);
            String body = "";
            if(!bodyParams.isEmpty()){
                body = TurnListToString.turnBodyToString(bodyParams);
            }
            //这里去要区分get还是post
            //有个需要说明的，在表格里面如果是get方法，那么key和value代表params，如果是post，那它们就代表body里面的东西
            String requestMethod = testData.getRequestMethod();
            if(requestMethod.equals("post"))  {
                request.sendPostRequest(url, body, tokenHeader);
LogUtil.info("Request body:" + body);
            }else if(requestMethod.equals("get")) {
                request.sendGetRequest(url, bodyParams, tokenHeader);
                LogUtil.info("Request params:" + body);
            }
            //verify
            responseCode = request.getResponseCode();
            LogUtil.info("ResponseCode:" + responseCode);
            codeExpected = testData.getCodeExpected();
            assertEquals(responseCode, codeExpected);
            String checkPoint = "";
            checkPoints = testData.getCheckPoints();

            for (NameValuePair pair : checkPoints) {
                checkPoint = pair.getName();
                //如果检查点为空就不检查了
                if(!TextUtils.isEmpty(checkPoint)) {
                    String checkValue = pair.getValue();
                    String result = request.getStringFromResponseJSON(checkPoint, checkValue.length());
                    LogUtil.info("CheckPoint:" + checkPoint);
                    LogUtil.info("CheckValue:" + checkValue);
                    LogUtil.info("ValueResult:" + result);
                    assertEquals(result, checkValue);
                }
            }
        }
    }
}

public class HttpRequest {
    String content = null;
    URL requestUrl;
    HttpsURLConnection connection;
    int responseCode;
    JSONObject responseBody;
    PrintWriter out = null;

    public void sendGetRequest(String url,  List<NameValuePair> params, Map<String, String> header) throws IOException {
        //处理请求的参数，参数就是在url后面加上？key1=value1&key2=value2
        url = url + TurnListToString.turnKeysToString(params);
        requestUrl = new URL(url);
        connection = (HttpsURLConnection) requestUrl.openConnection();
        // 默认是 GET方式
        //设置本次连接是否自动重定向
        connection.setInstanceFollowRedirects(true);
        //用自己写的工具类，去设置请求header
        RequestHeader.setRequestHeader(connection);
        //再添加额外的header
        RequestHeader.addExtraHeader(connection, header);

        // 连接，从postUrl.openConnection()至此的配置必须要在connect之前完成
        connection.connect();
        InputStream inputStream = getInputStream();

        if (null == inputStream) {
            inputStream = connection.getInputStream();
        }
        readResponseContent(inputStream);
        connection.disconnect();
    }

    public void sendPostRequest(String url, String body, Map<String, String> header) throws IOException  {
        requestUrl = new URL(url);
        connection = (HttpsURLConnection) requestUrl.openConnection(); 
        // 设置是否向connection输出，因为这个是post请求，参数要放在http正文内，因此需要设为true
        connection.setDoOutput(true);
        // Read from the connection. Default is true.
        connection.setDoInput(true);
        // 默认是 GET方式
        connection.setRequestMethod("POST");      
        // Post 请求不能使用缓存
        connection.setUseCaches(false);  
        //设置本次连接是否自动重定向 
        connection.setInstanceFollowRedirects(true);      

        //用自己写的工具类，去设置请求header
        RequestHeader.setRequestHeader(connection);
        //再添加额外的header
        RequestHeader.addExtraHeader(connection, header);

        out = new PrintWriter(connection.getOutputStream());   
        out.print(body);
        out.flush();

        // 连接，从postUrl.openConnection()至此的配置必须要在connect之前完成，
        // 要注意的是connection.getOutputStream会隐含的进行connect。
        connection.connect();
        InputStream inputStream = getInputStream();

        //如果返回的状态码不是200，需要从ErrorStream里读返回数据
        if (null == inputStream) {
            try {
                inputStream = connection.getInputStream();
            } catch (IOException e) {
                inputStream = connection.getErrorStream();
            }
        }
        readResponseContent(inputStream);
        connection.disconnect();
    }

    public void readResponseContent(InputStream inputStream) throws IOException {
        StringBuilder builder = new StringBuilder();
        String line = null;
        BufferedReader reader = new BufferedReader(new InputStreamReader(inputStream, "utf-8"));
        while ((line = reader.readLine()) != null) {
            builder.append(line).append("\n");
        }
        content = builder.toString();
        responseBody = (JSONObject) JSON.parse(content);
    }

    public InputStream getInputStream() throws IOException {
        InputStream inputStream = null;
        if (!TextUtils.isEmpty(connection.getContentEncoding())) {
            String encode = connection.getContentEncoding().toLowerCase();
            if (!TextUtils.isEmpty(encode) && encode.indexOf("gzip") >= 0) {
                inputStream = new GZIPInputStream(connection.getInputStream());
            }
        }
        return inputStream;
    }

    public JSONObject getResponseBody() {
        return responseBody;
    }

    //传入valueLength是为了防止第一层没有找到key的时候，可以方便从字符串中找到value的值
    public String getStringFromResponseJSON(String key, int valueLength) {
        String value = responseBody.getString(key);
        //如果第一层没有找到key，那么就把responseBody转成String，看看是否包含key，这个方法有点笨，暂时没想到更好的
        if (TextUtils.isEmpty(value)) {
            if (content.contains(key)) {
                int beginIndex = content.indexOf(key) + key.length() + 2;
                int endIndex = 0;
                Character valueBeginLetter = content.charAt(beginIndex) ;
                //如果包含可以，就取出value，一般json字符串的格式是"key":"value"
                //如果value是布尔型或者整型就没有引号
                if (valueBeginLetter.toString().equals("\"")) {
                    //如果是引号的话从下一个位置开始找
                    beginIndex ++;
                    endIndex = beginIndex + valueLength;
                }
                value = content.substring(beginIndex, endIndex);
            }
        }
        return value;
    }

    public int getResponseCode() throws IOException {
        responseCode = connection.getResponseCode();
        return responseCode;
    }

    public String getHeaderString(String headerKey) {
        String headerValue = connection.getHeaderField(headerKey);
        return headerValue;
    }

    public String getStringFromResponseJSON(String key) {
        return responseBody.getString(key);
    }
}

/**
* TestData类储存的是一条具体的测试用例，构造函数中处理了从Excel表格中读出来的数据
* @author lulian
* address 请求地址
* checkpoint 检查点
* checkValue 检查值
* body 请求body或者params，GET请求时用作params，POST时用作BODY，但在testdata类里面都是List<NameValuePair>类型储存的
* codeExpected 期待的状态码
* testDescription 用例描述，用来写在报告里面的
* requestMethod 请求的方法
* enabled 表示用例是否要被执行
*/
public class TestData {
    private String address;
    private List<NameValuePair> body;
    private List<NameValuePair> checkPoints;
    private int codeExpected;
    private String testDescription;
    private String requestMethod;
    private boolean enabled;

    public TestData(int caseLine, Object[][] excelData) {
        //根据列的名字找到列的序号，然后再获取对应的值
        address = excelData[caseLine][ColNumber.getColNumber("Address", excelData)].toString().trim();
        String codeContentFromExcel = excelData[caseLine][ColNumber.getColNumber("code", excelData)].toString().trim();
        codeExpected = Integer.parseInt(codeContentFromExcel);
        testDescription = excelData[caseLine][ColNumber.getColNumber("description", excelData)].toString().trim();
        requestMethod = excelData[caseLine][ColNumber.getColNumber("requestMethod", excelData)].toString().trim();
        enabled = excelData[caseLine][ColNumber.getColNumber("enabled", excelData)].toString().toString().trim().equals("1") ? true : false;
        //用NameValuePair存储所有请求参数
        body = new ArrayList<NameValuePair>();
        for (int j = ColNumber.getColNumber("Key1", excelData); j < excelData[caseLine].length - 1; j = j + 2){
            excelData[caseLine].length);
            //因为每种请求的参数个数不确定，在这里进行非空判断
            if(excelData[caseLine][j].equals("")){
                break;
            }
            NameValuePair pair = new BasicNameValuePair(excelData[caseLine][j].toString(),excelData[caseLine][j+1].toString());
            body.add(pair);   
        }
        checkPoints = new ArrayList<NameValuePair>();
        //checkPoint的数量从CheckPoint1开始一直到Key1之前2个
        for (int j = ColNumber.getColNumber("CheckPoint1", excelData); j < ColNumber.getColNumber("Key1", excelData); j = j + 2) {
            if(excelData[caseLine][j].equals("")){
                break;
            }
            NameValuePair pair = new BasicNameValuePair(excelData[caseLine][j].toString(), excelData[caseLine][j+1].toString());
            checkPoints.add(pair);
        }
    }

    public String getAddress() {
        return address;
    }

    public List<NameValuePair> getCheckPoints() {
        return checkPoints;
    }

    public List<NameValuePair> getKeys() {
        return body;
    }

    public int getCodeExpected() {
        return codeExpected;
    }

    public String getTestDescription() {
        return testDescription; 
    }

    public String getRequestMethod() {
        return requestMethod;
    }

    public boolean isEnabled() {
        return enabled;
    }
}

public class ExcelProcess {
    public static Object[][] processExcel(String filePath) throws IOException, JXLException{
    //数据流读入excel
    File file = new File(System.getProperty("user.dir") + filePath);
    Workbook wb = Workbook.getWorkbook(file);
    //读取特定表单，计算行数、列数
    Sheet sheet = wb.getSheet("case");
    int numberOfRow = sheet.getRows();
    int numberOfCell = sheet.getColumns();
    //将表单数据存入dtt对象
    Object[][] data = new Object[numberOfRow][numberOfCell];
    for (int i = 0; i < numberOfRow; i++) {
        if (sheet.getCell(0, i).getContents().isEmpty() || sheet.getCell(0, i).getContents().equals("")) {
            continue;
        }
        for (int j = 0; j < numberOfCell; j++) {
            if(sheet.getCell(j, i) == null || sheet.getCell(j, i).equals("")) {
                continue;
            }
            Cell cell = sheet.getCell(j, i);
            data[i][j] = cell.getContents();
        }
    }
    return data;
    }
}

<!DOCTYPE suite SYSTEM "http://testng.org/testng-1.0.dtd" >

<suite name="First suite" verbose="1" >
    <test name="TestName" >
        ……
    </test>
</suite>

//比如有这样的一些测试方法，各自标注了属于什么分组
public class TestClass1 {
    @Test(groups = {"group1", "group2"})
        public void testMethod1() {
    }

    @Test(groups = {"group1"} )
        public void testMethod2() {
    }

    @Test(groups = {"group2"})
        public void testMethod3() {
    }
}

//当然也可以在整个类之前加注group name，例如下面表示整个类中的方法都是属于checkin-test组的，其中method1又属于func-test组

@Test(groups = {"group3"})
public class TestClass2 {
    @Test(groups = {"group4"})
    public void testmethod4() { ... }
    public void testmethod5() { ... }
}

<!-- testng.xml中定义如下 -->
<groups>
    <run>
        <include name = "group1" />
        <exclude name = "group2" />
    </run>
</groups>

<suite name="First suite" verbose="1" >
    <test name="TestName" >

        <!-- 选择一个包 -->
        <packages>
            <package name = "packageName" />
        </packages>

        <!-- 选择一个类 -->
        <classes>
            <class name = "className" />
        </classes>

        <!-- 选择一个方法 -->
        <classes>
            <class name = "className" />
                <methods>
                    <include name = "methodName" />
                    <exclude name = "methodName" />
                </methods>
            </class>
        </classes>
        </test>
</suite>

@Test(expectedExceptions = {FileNotFoundException.class})
public void whatToThrow() throws FileNotFoundException {
    File f = null;
    if (f == null) {
        throw new FileNotFoundException();
    }
}

[RemoteTestNG] detected TestNG version 6.14.3
PASSED: whatToThrow

===============================================
Default test
Tests run: 1, Failures: 0, Skips: 0
===============================================


===============================================
Default suite
Total tests run: 1, Failures: 0, Skips: 0
===============================================

@Test(enabled = false)
public void test(){
    ……
}

@Test(timeOut = 3000)
public void timeoutTest() {
    while(true) {

    }
}

FAILED: timeoutTest
org.testng.internal.thread.ThreadTimeoutException: Method com.test.api.ExceptionTest.timeoutTest() didn't finish within the time-out 3000 at 
……
……

===============================================
Default test
Tests run: 1, Failures: 1, Skips: 0

===============================================


===============================================
Default suite
Total tests run: 1, Failures: 1, Skips: 0

===============================================

//method2只有在method1执行成功以后才会被执行，否则就会忽略
@Test
public void method1() {
    System.out.println("This is method 1");
}

@Test(dependsOnMethods = { "method1" })
public void method2() {
    System.out.println("This is method 2");
}

<suite>
    <test name="testPara">
        <parameter name="para1" value="value1"/>
        <parameter name="para2" value="value2"/>

    <classes>
        <class name="com.test.api.ExceptionTest"/>
    </classes>
    </test>
</suite>

@Test
@Parameters({"para1", "para2"})
public void testPara(String para1, String para2) {
    System.out.println(para1);
    System.out.println(para2);
}

public class Test {
    @DataProvider(name = "provider")
    public Object[][] provideData(){
        return new Object[][] {{1, 1}, {1, 2}, {1, 3}};
    }

    @Test(dataProvider = "provider")
    public void printData(int i, int j) {
        System.out.println("i:" + i + "\t" + "j:" + j);
    }
}

[RemoteTestNG] detected TestNG version 6.14.3
i:1    j:1
i:1    j:2
i:1    j:3
PASSED: printData(1, 1)
PASSED: printData(1, 2)
PASSED: printData(1, 3)

===============================================
Default test
Tests run: 3, Failures: 0, Skips: 0
===============================================


===============================================
Default suite
Total tests run: 3, Failures: 0, Skips: 0
===============================================

public class Test {
    @DataProvider(name = "provider1")    
    public Object[][] provideData1(){
        Map<String, String> map = new HashMap<String, String>();
        map.put("key1", "value1");
        map.put("key2", "value2");
        map.put("key3", "value2");
        return new Object[][] {{map}};
        }

    @Test(dataProvider = "provider1")
    public void printData1(Map<String, String> map) {
        for(Map.Entry<String, String> entry : map.entrySet()){
            System.out.println(entry.getKey() + "\t" + entry.getValue());
        }
    }
}

[RemoteTestNG] detected TestNG version 6.14.3
key1    value1
key2    value2
key3    value2
PASSED: printData1({key1=value1, key2=value2, key3=value2})

===============================================
Default test
Tests run: 1, Failures: 0, Skips: 0
===============================================


===============================================
Default suite
Total tests run: 1, Failures: 0, Skips: 0
===============================================

public class Test {
    @DataProvider(name = "provider2") 
    public Object[][] provideData2(Method method){
        Object[][] obj = null;
        if (method.getName() == "test1") {
            obj = new Object[][] {{"case1", "valu1"}};
        }else if (method.getName() == "test2") {
            obj = new Object[][] {{"case2", "valu2"}};
            }
        return obj;
    }

    @Test(dataProvider = "provider2")
    public void test1(String name, String value) {
        System.out.println(name + "\t" + value);
    }

    @Test(dataProvider = "provider2")
    public void test2(String name, String value) {
        System.out.println(name + "\t" + value);
    }
}

[RemoteTestNG] detected TestNG version 6.14.3
case1    valu1
case2    valu2
PASSED: test1("case1", "valu1")
PASSED: test2("case2", "valu2")

===============================================
Default test
Tests run: 2, Failures: 0, Skips: 0
===============================================


===============================================
Default suite
Total tests run: 2, Failures: 0, Skips: 0
===============================================

public class TraverseCases extends TestApi{
    //假设属性都已经定义好了（这里省略不写了）

    @BeforeClass()
    public void setUp() throws Exception {
        //假设应该做的初始化工作都在这里做了（这里省略不写了）
    }

    @DataProvider(name="testData")
    private Iterator<Object[]> testDataProvider() throws IOException {
        List<Object[]> result= new ArrayList<Object[]>();
        List<TestData> alldata = new ArrayList<TestData>();
        TestData td = null;
        for(int i = 1; i < excelData.length; i++) {
            td = new TestData(i, excelData);
            alldata.add(td);
        }
        Iterator it = alldata.iterator();
        while(it.hasNext()){
        result.add(new Object[] { it.next() });
        }
        return  result.iterator();
        }

    @Test(dataProvider = "testData")
    public void testDifferentCases(TestData testData) throws IOException {
        //这里每一次传进来的都是迭代器取的下一个测试数据
        if (testData != null) {
        //这里你就可以对测试数据进行操作了（这里省略不写了）
        }
    }
}

PASSED: testDifferentCases(com.test.utils.TestData@6150c3ec)
PASSED: testDifferentCases(com.test.utils.TestData@139982de)
PASSED: testDifferentCases(com.test.utils.TestData@3eb738bb)
PASSED: testDifferentCases(com.test.utils.TestData@74e52ef6)
PASSED: testDifferentCases(com.test.utils.TestData@bcec361)
PASSED: testDifferentCases(com.test.utils.TestData@3d285d7e)
PASSED: testDifferentCases(com.test.utils.TestData@2aceadd4)
PASSED: testDifferentCases(com.test.utils.TestData@7817fd62)
PASSED: testDifferentCases(com.test.utils.TestData@77f1baf5)

===============================================
Default test
Tests run: 9, Failures: 0, Skips: 0
===============================================


===============================================
Default suite
Total tests run: 9, Failures: 0, Skips: 0
===============================================

public class LogUtil {
    public static void info(String msg) {
    Reporter.log(msg.toString());
    }
}

//1、传入sheet的名字
Sheet sheet = wb.getSheet("sheet1");

//2、传入sheet的序号，从0开始
Sheet sheet = wb.getSheet(0);

//获取sheet的行数和列数
int numberOfRow = sheet.getRows();
int numberOfCol = sheet.getColumns();

//获取某一列的CellView
CellView cv = sheet.getColumnView(0);

//CellView是用来设置或者获取Cell某些属性的，比如format和size
String backgroudColor = cv.getFormat().getBackgroundColour().getDescription();
int size = cv.getSize();

//获取sheet的名字
String sheetName = sheet.getName();

//获取sheet中图片的数量
int picNum = sheet.getNumberOfImages();

//获取某一行的CellView
CellView cv = sheet.getRowView(0);

//获取sheet的设置
SheetSettings ss = sheet.getSettings();

//SheetSettings是用来设置或者获取sheet某些属性的
//返回水平冻结的行序号，没有就是0
int frozenRowNum = ss.getHorizontalFreeze();

//1、根据cell内容
Cell cell1 = sheet.findCell("test");

//2、根据所给的内容、查找范围和查找的顺序（正着找还是倒着找）
Cell cell2 = sheet.findCell("test", 0, 0, 10, 1, true);

//3、根据所给的pattern、查找范围和查找的顺序
Cell cell3 = sheet.findCell(Pattern.compile("Key.*"), 0, 0, 12, 1, false);

//4、根据行、列序号
Cell cell4 = sheet.getCell(column, row);

//5、根据单元格的位置
Cell cell5 = sheet.getCell("B2");

//6、根据列号/行号，获得一列/行的单元格，得到一个Cell[]
Cell[] cells = sheet.getColumn(0);
Cell[] cells = sheet.getRow(0);

//获取cell的特性
CellFeatures cf = cell.getCellFeatures();

//CellFeatures is container for any additional cell features
String cellComment = cf.getComment();
String dataValidation = cf.getDataValidationList();

//获取cell的format
CellFormat cf = cell.getCellFormat();

//format里可以获取背景色、字体等
String backgroundColor = cf.getBackgroundColour().getDescription();
String font = cf.getFont().getName();

//获取行号和列号
int colNumber = cell.getColumn();
int rowNumber = cell.getRow();

//获取单元格的内容
String contents = cell.getContents();

//获取CellType
CellType ct = cell1.getType();
String type = ct.toString();

//1、根据File文件创建
WritableWorkbook wwb = Workbook.createWorkbook(file);

//2、根据File的名字，和Workbook生成一份复制的对象
WritableWorkbook wwb = Workbook.createWorkbook(file, wb);

//3、根据File和WorkbookSettings
WritableWorkbook wwb = Workbook.createWorkbook(file, ws);

//4、根据File、Workbook和WorkbookSettings
WritableWorkbook wwb = Workbook.createWorkbook(file, wb, ws);

//5、根据OutputStream
WritableWorkbook wwb = Workbook.createWorkbook(os);

//还有三种是OutputStream + Workbook、OutputStream + WorkbookSettings、OutputStream + Workbook + WorkbookSettings，不再一一举例

//复制sheet，三个参数分别代表：要拷贝的sheet的序号/名字、新sheet的名字、新sheet的序号
wwb.copySheet(1, "test", 1);
wwb.copySheet("test", "test1", 1);

//创建sheet，传入名字和序号
wwb.createSheet(name, index);

//获取表中的sheet数量
int sheetNumber = wwb.getNumberOfSheets();

//获取表中所有sheet的名字
String[] namesOfAllSheets = wwb.getSheetNames();

//根据位置，获取特定的WritableCell
WritableCell wc = wwb.getWritableCell("Sheet1!A4");

//从另一个sheet复制一个新sheet，三个参数是：新sheet的名字、新sheet的序号、copy的sheet
WritableSheet ws = wwb.importSheet(name, index, s);

//移动一个sheet的位置，返回移动后的sheet
WritableSheet ws = wwb.moveSheet(int fromIndex, int toIndex);

//移除一个sheet
wwb.removeSheet(int index);

//设置一个新的输出文件
wwb.setOutputFile(java.io.File fileName);

//写
wwb.write();

//关
wwb.close();

//根据序号或名字来创建，或者直接获取所有的sheet，得到一个sheet数组
WritableSheet ws = wwb.getSheet(index);
WritableSheet ws = wwb.getSheet(name);
WritableSheet[] ws = wwb.getSheets();

//向sheet中添加一个WritableCell
ws.addCell(cell);

//向sheet中添加一个WritableImage
ws.addImage(image)；

//获得WritableImage
WritableImage wi = ws.getImage(i);

//获取图片数量
int picNumber = ws.getNumberOfImages();

//插入一列/行
ws.insertColumn(col);
ws.insertRow(row);

//移除一列/行
ws.removeColumn(col);
ws.removeRow(row);

//移除图片
ws.removeImage(wi);

//设置列/行的格式，需要传入CellView
ws.setColumnView(col, view);
ws.setRowView(col, view);

//设置列宽、行高
ws.setColumnView(col, width);
ws.setRowView(col, height);

//设置sheet的名字
ws.setName(name);

//根据位置或者行、列序号
WritableCell wc1 = ws.getWritableCell(loc);
WritableCell wc2 = ws.getWritableCell(column, row);

//深度copy一个WritableCell，得到一个新WritableCell，但是这个新cell还未被加入sheet中，col，row代表要拷贝到的位置
WritableCell wcNew = wc.copyTo(col, row);
ws.addCell(wcNew);

//设置cell的特性
WritableCellFeatures wcf = new WritableCellFeatures();
wcf.setComment("评论");
wc.setCellFeatures(wcf);