接口自动化测试一：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"?>
<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>org.example</groupId>
<artifactId>Chapter12</artifactId>
<version>1.0-SNAPSHOT</version>
<properties>
<maven.compiler.source>11</maven.compiler.source>
<maven.compiler.target>11</maven.compiler.target>
</properties>
<dependencies>
<dependency>
<groupId>org.apache.httpcomponents</groupId>
<artifactId>httpclient</artifactId>
<version>4.5.13</version>
</dependency>
<dependency>
<groupId>org.json</groupId>
<artifactId>json</artifactId>
<version>20170516</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.4</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.28</version>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.22</version>
</dependency>
<dependency>
<groupId>com.vimalselvam</groupId>
<artifactId>testng-extentsreport</artifactId>
<version>1.3.1</version>
</dependency>
<dependency>
<groupId>com.relevantcodes</groupId>
<artifactId>extentreports</artifactId>
<version>2.41.1</version>
</dependency>
<dependency>
<groupId>org.testng</groupId>
<artifactId>testng</artifactId>
<version>7.1.0</version>
</dependency>
<dependency>
<groupId>com.aventstack</groupId>
<artifactId>extentreports</artifactId>
<version>3.0.6</version>
</dependency>
</dependencies>
</project>
创建配置文件、层级结构
创建配置文件
创建databaseConfig.xml,配置数据库信息
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.cj.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://123.123.123.123:3306/course"/>
<property name="username" value="user"/>
<property name="password" value="password"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="mapper/SQLMapper.xml"/>
</mappers>
</configuration>
创建testng.xml，用来编写执行测试用例
<?xml version="1.0" encoding="UTF-8" ?>
<suite name="用户管理测试">
<test>
</test>
</suite>
创建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<XmlSuite> xmlSuites, List<ISuite> suites, String outputDirectory) {
init();
boolean createSuiteNode = false;
if(suites.size()>1){
createSuiteNode=true;
}
for (ISuite suite : suites) {
Map<String, ISuiteResult> 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<TestAttribute> categoryList = extenttest.getModel().getCategoryContext().getAll();
categories = new String[categoryList.size()];
for(int index=0;index<categoryList.size();index++){
categories[index] = categoryList.get(index).getName();
}
}
ExtentTest test;
if (tests.size() > 0) {
//调整用例排序，按时间排序
Set<ITestResult> treeSet = new TreeSet<ITestResult>(new Comparator<ITestResult>() {
@Override
public int compare(ITestResult o1, ITestResult o2) {
return o1.getStartMillis()<o2.getStartMillis()?-1:1;
}
});
treeSet.addAll(tests.getAllResults());
for (ITestResult result : treeSet) {
Object[] parameters = result.getParameters();
String name="";
//如果有参数，则使用参数的toString组合代替报告中的name
for(Object param:parameters){
name+=param.toString();
}
if(name.length()>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<String> 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" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.course.model">
<!--获取登录接口case-->
<select id="loginCase" parameterType="Integer" resultType="com.course.model.LoginCase">
select * from loginCase where id=#{id}
</select>
<!--添加用户接口case-->
<select id="addUserCase" parameterType="Integer" resultType="com.course.model.AddUserCase">
select * from addUserCase where id=#{id}
</select>
<!--获取用户信息接口case-->
<select id="getUserInfoCase" parameterType="Integer" resultType="com.course.model.GetUserInfoCase">
select * from getUserInfoCase where id=#{id}
</select>
<!--获取用户列表接口case-->
<select id="getUserListCase" parameterType="Integer" resultType="com.course.model.GetUserListCase">
select * from getUserListCase where id=#{id}
</select>
<!--获取更新删除用户信息接口case-->
<select id="updateUserInfoCase" parameterType="Integer" resultType="com.course.model.UpdateUserInfoCase">
select * from updateUserInfoCase where id=#{id}
</select>
</mapper>
按编写的test补充testng.xml文件,使其按需求执行测试，并产出测试报告
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE suite SYSTEM "https://testng.org/testng-1.0.dtd" >
<suite name="用户管理测试">
<test name="用户管理测试">
<classes>
<class name="com.course.cases.LoginTest">
<methods>
<include name="loginTrue"/>
<include name="loginFalse"/>
</methods>
</class>
<class name="com.course.cases.AddUserTest">
<methods>
<include name="addUser"/>
</methods>
</class>
<class name="com.course.cases.GetUserInfoTest">
<methods>
<include name="getUserInfo"/>
</methods>
</class>
<class name="com.course.cases.GetUserListTest">
<methods>
<include name="getUserList"/>
</methods>
</class>
<class name="com.course.cases.UpdateUserInfoTest">
<methods>
<include name="updateUserInfo"/>
<include name="deleteUser"/>
</methods>
</class>
</classes>
</test>
<listeners>
<listener class-name="com.course.config.ExtenTestNGIReporterListener"/>
</listeners>
</suite>
浙公网安备 33010602011771号