接口自动化测试一：maybatis+mysql实现用例管理

设计表结构并且创建数据库

创建原则：按本次需求，每个接口一个表用来存放这个接口的case，优点是清晰易懂，易于维护

  • 创建user表，用于测试
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `age` int(11) NULL DEFAULT NULL,
  `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `permission` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `isDelete` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, 'zhangsan', '123456', 20, '0', '0', '0');
INSERT INTO `user` VALUES (2, 'lisi', '123456', 25, '1', '1', '0');
INSERT INTO `user` VALUES (3, 'wangwu', '123456', 30, '0', '1', '0');
INSERT INTO `user` VALUES (4, 'zhaoliu', '123456', 40, '1', '1', '0');
INSERT INTO `user` VALUES (5, 'zhang1', '123', 20, '0', '0', '0');
INSERT INTO `user` VALUES (6, 'zhao2', 'wqer', 30, '1', '1', '0');
INSERT INTO `user` VALUES (7, 'li3', 'sdffa', 50, '1', '0', '0');
INSERT INTO `user` VALUES (8, 'wu5', 'qazedx', 40, '1', '0', '0');

SET FOREIGN_KEY_CHECKS = 1;
  • 创建loginCase表，存储login接口测试用例
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for loginCase
-- ----------------------------
DROP TABLE IF EXISTS `loginCase`;
CREATE TABLE `loginCase`  (
  `id` int(11) NOT NULL,
  `userName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `expected` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of loginCase
-- ----------------------------
INSERT INTO `loginCase` VALUES (1, 'zhangsan', '123456', 'true');
INSERT INTO `loginCase` VALUES (2, 'zhangsanerror', '123', 'false');

SET FOREIGN_KEY_CHECKS = 1;
  • 创建getUserInfoCase表，存储getUserInfo接口测试用例
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for getUserInfoCase
-- ----------------------------
DROP TABLE IF EXISTS `getUserInfoCase`;
CREATE TABLE `getUserInfoCase`  (
  `id` int(11) NOT NULL,
  `userId` int(11) NULL DEFAULT NULL,
  `expected` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of getUserInfoCase
-- ----------------------------
INSERT INTO `getUserInfoCase` VALUES (1, 1, 'getUserInfo');

SET FOREIGN_KEY_CHECKS = 1;
  • 创建addUserCase表，存储addUser接口测试用例
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for addUserCase
-- ----------------------------
DROP TABLE IF EXISTS `addUserCase`;
CREATE TABLE `addUserCase`  (
  `id` int(11) NOT NULL,
  `userName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `age` int(11) NULL DEFAULT NULL,
  `permission` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `isDelete` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `expected` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of addUserCase
-- ----------------------------
INSERT INTO `addUserCase` VALUES (1, 'zhao9', 'zhaozhao', '0', 35, '1', '0', 'true');

SET FOREIGN_KEY_CHECKS = 1;
  • 创建getUserListCase表，存储getUserList接口测试用例
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for getUserListCase
-- ----------------------------
DROP TABLE IF EXISTS `getUserListCase`;
CREATE TABLE `getUserListCase`  (
  `id` int(11) NOT NULL,
  `userName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `age` int(11) NULL DEFAULT NULL,
  `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `expected` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of getUserListCase
-- ----------------------------
INSERT INTO `getUserListCase` VALUES (1, NULL, NULL, '0', 'getUserList');

SET FOREIGN_KEY_CHECKS = 1;
  • 创建updateUserInfoCase表，存储updateUserInfo接口测试用例
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for updateUserInfoCase
-- ----------------------------
DROP TABLE IF EXISTS `updateUserInfoCase`;
CREATE TABLE `updateUserInfoCase`  (
  `id` int(11) NOT NULL,
  `userId` int(11) NULL DEFAULT NULL,
  `userName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `age` int(11) NULL DEFAULT NULL,
  `permission` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `isDelete` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `expected` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of updateUserInfoCase
-- ----------------------------
INSERT INTO `updateUserInfoCase` VALUES (1, 2, 'hahahaha', NULL, NULL, NULL, NULL, 'getUpdateUserInfo');
INSERT INTO `updateUserInfoCase` VALUES (2, 8, NULL, NULL, NULL, NULL, '1', 'getUpdateUserInfo');

SET FOREIGN_KEY_CHECKS = 1;

配置环境（配置pom.xml）

  • 导入httpclient，模拟发送请求
  • 导入json,因为大部分请求数据为json格式，需要支持
  • 导入mybatis，与mysql做结合读取数据
  • 导入mysql,链接数据库
  • 导入lomback,帮忙生产简单的数据方法
  • 导入testng，用来执行测试用例
  • 导入extentreports，生成测试报告
<?xml version="1.0" encoding="UTF-8"?>

    4.0.0

    org.example
    Chapter12
    1.0-SNAPSHOT

    
        11
        11
    
    
        
            org.apache.httpcomponents
            httpclient
            4.5.13
        

        
            org.json
            json
            20170516
        

        
            org.mybatis
            mybatis
            3.4.4
        

        
            mysql
            mysql-connector-java
            8.0.28
        

        
            org.projectlombok
            lombok
            1.18.22
        

        
            com.vimalselvam
            testng-extentsreport
            1.3.1
        

        
            com.relevantcodes
            extentreports
            2.41.1
        

        
            org.testng
            testng
            7.1.0
        

        
            com.aventstack
            extentreports
            3.0.6

创建配置文件、层级结构

创建配置文件

创建databaseConfig.xml,配置数据库信息

<?xml version="1.0" encoding="UTF-8" ?>

创建testng.xml，用来编写执行测试用例

<?xml version="1.0" encoding="UTF-8" ?>

创建application.properties，用来存放一些共用数据，例如服务器路径、接口路径

test.url=http://localhost:8888
#登录接口
login.uri=/v1/login
#更新用户信息接口
updateUserInfo.uri=/v1/updateUserInfo
#获取用户列表接口
getUserList.uri=/v1/getUserList
#获取用户信息接口
getUserInfo.uri=/v1/getUserInfo
#添加用户接口
addUser.uri=/v1/addUser

在resources文件下创建mapper文件，在其下面创建SQLMapper.xml，用来存储SQL语句

创建层级结构

  • case层：创建com.course.cases，用于存放case
  • 配置层：创建com.course.config，用于存放配置文件
  • model层：创建com.course.model，用于存放与数据库表的映射文件，便于操作数据库
  • 工具层：创建com.course.utils，用于存放写出来的工具,减少整体代码量

应用代码编写

model层代码

创建所有表的class文件与数据库表对应，并重写toString方法，这样容易获取json格式数据

package com.course.model;

import lombok.Data;

@Data
public class User {
    private int id;
    private String userName;
    private String password;
    private int age;
    private String sex;
    private String permission;
    private String isDelete;
    //复写toString方法，这样容易获得json数据
    public String toString(){
        return (
                "{id:"+id+","+
                "userName:"+userName+","+
                "password:"+password+","+
                "age:"+age+","+
                "sex:"+sex+","+
                "permission:"+permission+","+
                "isDelete:"+isDelete+"}"
                );
    }
}

package com.course.model;

import lombok.Data;

@Data
public class AddUserCase {
    private String userName;
    private String password;
    private int age;
    private String sex;
    private String permission;
    private String isDelete;
    private String expected;

}

package com.course.model;

import lombok.Data;

@Data
public class GetUserInfoCase {
    private int userId;
    private String expected;
}


package com.course.model;

import lombok.Data;

@Data
public class GetUserListCase {
    private String userName;
    private int age;
    private String sex;
    private String expected;
}

package com.course.model;

import lombok.Data;

@Data
public class LoginCase {
    private int id;
    private String userName;
    private String password;
    private String expected;
}

package com.course.model;

import lombok.Data;

@Data
public class UpdateUserInfoCase {
    private int id;
    private String userId;
    private String userName;
    private String password;
    private int age;
    private String sex;
    private String permission;
    private String isDelete;
    private String expected;
}

写一个枚举类，用来枚举接口

package com.course.model;

public enum IntegerfaceName {
    GETUSERLIST,LOGIN,UPDATEUSERINFO,GETUSERINFO,ADDUSER
}

配置层代码

添加监听及报告输出类

package com.course.config;

import com.aventstack.extentreports.ExtentReports;
import com.aventstack.extentreports.ExtentTest;
import com.aventstack.extentreports.ResourceCDN;
import com.aventstack.extentreports.Status;
import com.aventstack.extentreports.model.TestAttribute;
import com.aventstack.extentreports.reporter.ExtentHtmlReporter;
import com.aventstack.extentreports.reporter.configuration.ChartLocation;
import com.aventstack.extentreports.reporter.configuration.Theme;
import org.testng.*;
import org.testng.xml.XmlSuite;

import java.io.File;
import java.util.*;

public class ExtenTestNGIReporterListener implements IReporter {
    //生成的路径以及文件名
    private static final String OUTPUT_FOLDER = "test-output/";
    private static final String FILE_NAME = "index.html";

    private ExtentReports extent;

    @Override
    public void generateReport(List xmlSuites, List suites, String outputDirectory) {
        init();
        boolean createSuiteNode = false;
        if(suites.size()>1){
            createSuiteNode=true;
        }
        for (ISuite suite : suites) {
            Map result = suite.getResults();
            //如果suite里面没有任何用例，直接跳过，不在报告里生成
            if(result.size()==0){
                continue;
            }
            //统计suite下的成功、失败、跳过的总用例数
            int suiteFailSize=0;
            int suitePassSize=0;
            int suiteSkipSize=0;
            ExtentTest suiteTest=null;
            //存在多个suite的情况下，在报告中将同一个一个suite的测试结果归为一类，创建一级节点。
            if(createSuiteNode){
                suiteTest = extent.createTest(suite.getName()).assignCategory(suite.getName());
            }
            boolean createSuiteResultNode = false;
            if(result.size()>1){
                createSuiteResultNode=true;
            }
            for (ISuiteResult r : result.values()) {
                ExtentTest resultNode;
                ITestContext context = r.getTestContext();
                if(createSuiteResultNode){
                    //没有创建suite的情况下，将在SuiteResult的创建为一级节点，否则创建为suite的一个子节点。
                    if( null == suiteTest){
                        resultNode = extent.createTest(r.getTestContext().getName());
                    }else{
                        resultNode = suiteTest.createNode(r.getTestContext().getName());
                    }
                }else{
                    resultNode = suiteTest;
                }
                if(resultNode != null){
                    resultNode.getModel().setName(suite.getName()+" : "+r.getTestContext().getName());
                    if(resultNode.getModel().hasCategory()){
                        resultNode.assignCategory(r.getTestContext().getName());
                    }else{
                        resultNode.assignCategory(suite.getName(),r.getTestContext().getName());
                    }
                    resultNode.getModel().setStartTime(r.getTestContext().getStartDate());
                    resultNode.getModel().setEndTime(r.getTestContext().getEndDate());
                    //统计SuiteResult下的数据
                    int passSize = r.getTestContext().getPassedTests().size();
                    int failSize = r.getTestContext().getFailedTests().size();
                    int skipSize = r.getTestContext().getSkippedTests().size();
                    suitePassSize += passSize;
                    suiteFailSize += failSize;
                    suiteSkipSize += skipSize;
                    if(failSize>0){
                        resultNode.getModel().setStatus(Status.FAIL);
                    }
                    resultNode.getModel().setDescription(String.format("Pass: %s ; Fail: %s ; Skip: %s ;",passSize,failSize,skipSize));
                }
                buildTestNodes(resultNode,context.getFailedTests(), Status.FAIL);
                buildTestNodes(resultNode,context.getSkippedTests(), Status.SKIP);
                buildTestNodes(resultNode,context.getPassedTests(), Status.PASS);
            }
            if(suiteTest!= null){
                suiteTest.getModel().setDescription(String.format("Pass: %s ; Fail: %s ; Skip: %s ;",suitePassSize,suiteFailSize,suiteSkipSize));
                if(suiteFailSize>0){
                    suiteTest.getModel().setStatus(Status.FAIL);
                }
            }

        }
//        for (String s : Reporter.getOutput()) {
//            extent.setTestRunnerOutput(s);
//        }

        extent.flush();
    }

    private void init() {
        //文件夹不存在的话进行创建
        File reportDir= new File(OUTPUT_FOLDER);
        if(!reportDir.exists()&& !reportDir .isDirectory()){
            reportDir.mkdir();
        }
        ExtentHtmlReporter htmlReporter = new ExtentHtmlReporter(OUTPUT_FOLDER + FILE_NAME);
        // 设置静态文件的DNS
        //怎么样解决cdn.rawgit.com访问不了的情况
        htmlReporter.config().setResourceCDN(ResourceCDN.EXTENTREPORTS);

        htmlReporter.config().setDocumentTitle("api自动化测试报告");
        htmlReporter.config().setReportName("api自动化测试报告");
        htmlReporter.config().setChartVisibilityOnOpen(true);
        htmlReporter.config().setTestViewChartLocation(ChartLocation.TOP);
        htmlReporter.config().setTheme(Theme.STANDARD);
        htmlReporter.config().setCSS(".node.level-1  ul{ display:none;} .node.level-1.active ul{display:block;}");
        extent = new ExtentReports();
        extent.attachReporter(htmlReporter);
        extent.setReportUsesManualConfiguration(true);
    }

    private void buildTestNodes(ExtentTest extenttest, IResultMap tests, Status status) {
        //存在父节点时，获取父节点的标签
        String[] categories=new String[0];
        if(extenttest != null ){
            List categoryList = extenttest.getModel().getCategoryContext().getAll();
            categories = new String[categoryList.size()];
            for(int index=0;index 0) {
            //调整用例排序，按时间排序
            Set treeSet = new TreeSet(new Comparator() {
                @Override
                public int compare(ITestResult o1, ITestResult o2) {
                    return o1.getStartMillis()0){
                    if(name.length()>50){
                        name= name.substring(0,49)+"...";
                    }
                }else{
                    name = result.getMethod().getMethodName();
                }
                if(extenttest==null){
                    test = extent.createTest(name);
                }else{
                    //作为子节点进行创建时，设置同父节点的标签一致，便于报告检索。
                    test = extenttest.createNode(name).assignCategory(categories);
                }
                //test.getModel().setDescription(description.toString());
                //test = extent.createTest(result.getMethod().getMethodName());
                for (String group : result.getMethod().getGroups())
                    test.assignCategory(group);

                List outputList = Reporter.getOutput(result);
                for(String output:outputList){
                    //将用例的log输出报告中
                    test.debug(output);
                }
                if (result.getThrowable() != null) {
                    test.log(status, result.getThrowable());
                }
                else {
                    test.log(status, "Test " + status.toString().toLowerCase() + "ed");
                }

                test.getModel().setStartTime(getTime(result.getStartMillis()));
                test.getModel().setEndTime(getTime(result.getEndMillis()));
            }
        }
    }

    private Date getTime(long millis) {
        Calendar calendar = Calendar.getInstance();
        calendar.setTimeInMillis(millis);
        return calendar.getTime();
    }
}

创建测试配置类，配置一些变量，对应枚举类数据,以方便后续测试使用

package com.course.config;


import org.apache.http.client.CookieStore;
import org.apache.http.impl.client.CloseableHttpClient;

public class TestConfig {
    public static String loginUrl;
    public static String updateUserInfoUrl;
    public static String getUserListUrl;
    public static String getUserInfoUrl;
    public static String addUserUrl;
    public static CloseableHttpClient closeableHttpClient;
    public static CookieStore cookieStore;
}

工具层代码

编写工具类configFile类，使用ResourceBundle读取application配置文件，拼接url,且使用interfacename的枚举类作为参数，这样传参时不容易出错

package com.course.utils;

import com.course.model.IntegerfaceName;

import java.util.Locale;
import java.util.ResourceBundle;

public class ConfigFile {
    private static ResourceBundle bundle = ResourceBundle.getBundle("application", Locale.CHINA);

    public static String getUrl(IntegerfaceName name){
        String address = bundle.getString("test.url");
        String uri = "";
        if(name==IntegerfaceName.GETUSERLIST){
            uri = bundle.getString("getUserList.uri");
        }
        if(name==IntegerfaceName.LOGIN){
            uri = bundle.getString("login.uri");
        }
        if(name==IntegerfaceName.ADDUSER){
            uri = bundle.getString("addUser.uri");
        }
        if(name==IntegerfaceName.GETUSERINFO){
            uri = bundle.getString("getUserInfo.uri");
        }
        if(name==IntegerfaceName.UPDATEUSERINFO){
            uri = bundle.getString("updateUserInfo.uri");
        }

        String testUrl = address+uri;

        return testUrl;

    }
}

执行sql的类

package com.course.utils;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import java.io.IOException;
import java.io.Reader;

public class DatabaseUtil {
    public static SqlSession getSqlSession() throws IOException {
        //获取配置资源文件
        Reader reader = Resources.getResourceAsReader("databaseConfig.xml");
        //转换格式
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);

        //创建连接
        SqlSession sqlSession = factory.openSession();

        return sqlSession;
    }
}

case代码层

创建longin的测试代码

编写前置代码

beforeTest，使用配置类TestConfig中的变量，给工具类Config传参，传参值为model层中的枚举类integerfaceName数据。获取需要的数据及基本对象。

    @BeforeTest(groups = "loginTrue",description = "测试准备工作，获取httpclient对象等")
    public void beforeTest(){
        TestConfig.getUserInfoUrl = ConfigFile.getUrl(IntegerfaceName.GETUSERINFO);
        TestConfig.getUserListUrl = ConfigFile.getUrl(IntegerfaceName.GETUSERLIST);
        TestConfig.loginUrl = ConfigFile.getUrl(IntegerfaceName.LOGIN);
        TestConfig.addUserUrl = ConfigFile.getUrl(IntegerfaceName.ADDUSER);
        TestConfig.updateUserInfoUrl = ConfigFile.getUrl(IntegerfaceName.UPDATEUSERINFO);
        TestConfig.closeableHttpClient= new CloseableHttpClient() {
            @Override
            protected CloseableHttpResponse doExecute(HttpHost target, HttpRequest request, HttpContext context) throws IOException, ClientProtocolException {
                return null;
            }

            @Override
            public void close() throws IOException {

            }

            @Override
            public HttpParams getParams() {
                return null;
            }

            @Override
            public ClientConnectionManager getConnectionManager() {
                return null;
            }
        };

编写loginTest

给予loginTrue分组，以便后续需要登录的接口当做前置case

    @Test(groups = "loginTrue",description = "用户登录成功测试")
    public void loginTrue() throws IOException {
        SqlSession sqlSession = DatabaseUtil.getSqlSession();
        //使用前边model中创建好的类接受对应的case数据，读取SQLMapper.xml配置文件中的SQL语句
        LoginCase loginCase = sqlSession.selectOne("loginCase",1);
        System.out.println(loginCase.toString());
        System.out.println(TestConfig.loginUrl);
    }
    @Test(groups = "loginFalse",description = "用户登录失败测试")
    public void loginFalse() throws IOException {
        SqlSession sqlSession = DatabaseUtil.getSqlSession();
        LoginCase loginCase = sqlSession.selectOne("loginCase",2);
        System.out.println(loginCase.toString());
        System.out.println(TestConfig.loginUrl);
    }

编写AddUserTest

package com.course.cases;

import com.course.config.TestConfig;
import com.course.model.AddUserCase;
import com.course.utils.DatabaseUtil;
import org.apache.ibatis.session.SqlSession;
import org.testng.annotations.Test;

import java.io.IOException;

public class AddUserTest {
    @Test(dependsOnGroups = "loginTrue",description = "添加用户接口测试")
    public void addUser() throws IOException {
        SqlSession sqlSession = DatabaseUtil.getSqlSession();
        AddUserCase addUserCase = sqlSession.selectOne("addUserCase",1);
        System.out.println(addUserCase.toString());
        System.out.println(TestConfig.addUserUrl);
    }
}

编写GetUserListTest

package com.course.cases;

import com.course.config.TestConfig;
import com.course.model.GetUserListCase;
import com.course.utils.DatabaseUtil;
import org.apache.ibatis.session.SqlSession;
import org.testng.annotations.Test;

import java.io.IOException;

public class GetUserListTest {
    @Test(dependsOnGroups = "loginTrue",description = "获取性别为男的用户信息")
    public void getUsrList() throws IOException {
        SqlSession sqlSession = DatabaseUtil.getSqlSession();
        GetUserListCase getUserListCase = sqlSession.selectOne("getUserListCase",1);
        System.out.println(getUserListCase.toString());
        System.out.println(TestConfig.getUserListUrl);

    }
}

编写GetUserInfoTest

package com.course.cases;

import com.course.config.TestConfig;
import com.course.model.GetUserInfoCase;
import com.course.utils.DatabaseUtil;
import org.apache.ibatis.session.SqlSession;
import org.testng.annotations.Test;

import java.io.IOException;

public class GetUserInfoTest {

    @Test(dependsOnGroups = "loginTrue",description = "获取用户ID为1的用户信息")
    public void getUserInfo() throws IOException {
        SqlSession sqlSession = DatabaseUtil.getSqlSession();
        GetUserInfoCase getUserInfoCase = sqlSession.selectOne("getUserInfoCase",1);
        System.out.println(getUserInfoCase.toString());
        System.out.println(TestConfig.getUserInfoUrl);
    }
}

编写UpdateUserInfoTest

package com.course.cases;

import com.course.config.TestConfig;
import com.course.model.UpdateUserInfoCase;
import com.course.utils.DatabaseUtil;
import org.apache.ibatis.session.SqlSession;
import org.testng.annotations.Test;

import java.io.IOException;

public class UpdateUserInfoTest {
    @Test(dependsOnGroups = "loginTrue",description = "更新用户信息")
    public void updateUserInfo() throws IOException {
        SqlSession sqlSession = DatabaseUtil.getSqlSession();
        UpdateUserInfoCase updateUserInfoCase = sqlSession.selectOne("updateUserInfoCase",1);
        System.out.println(updateUserInfoCase.toString());
        System.out.println(TestConfig.updateUserInfoUrl);
    }

    @Test(dependsOnGroups = "loginTrue",description = "删除用户信息")
    public void deleteUser() throws IOException {
        SqlSession sqlSession = DatabaseUtil.getSqlSession();
        UpdateUserInfoCase updateUserInfoCase = sqlSession.selectOne("updateUserInfoCase",2);
        System.out.println(updateUserInfoCase.toString());
        System.out.println(TestConfig.updateUserInfoUrl);
    }
}

按编写的test补充sql语句到SQLMapper.xml文件

<?xml version="1.0" encoding="UTF-8" ?>

按编写的test补充testng.xml文件,使其按需求执行测试，并产出测试报告

<?xml version="1.0" encoding="UTF-8" ?>
接口测试

相关

分层封装的接口测试框架

接口测试第四步 --》 封装excel

1.使用Fiddler进行接口测试

接口测试总结

怎么进行mock接口测试

接口测试

软件测试___接口测试面试题____接口超时场景设置和接口超时处理

Requests接口测试(三)

0312 java接口测试三棱军刺rest-assured

python+request+unittest 接口测试练习

90%的测试工程师是这样使用Postman做接口测试的……

API接口测试

标签