当前位置: 首页 > news >正文

接口自动化测试框架设计

文章目录

    • 接口测试的定义
    • 接口测试的意义
    • 接口测试的测试用例设计
    • 接口测试的测试用例设计方法
    • postman
      • 主要功能
      • 请求体分类
      • JSON数据类型
      • postman内置参数
      • postman变量
        • 全局变量
        • 环境变量
      • postman断言
      • JSON提取器
      • 正则表达式提取器
      • Cookie提取器
      • postman加密
      • 接口签名
    • 接口自动化测试基础
      • get
      • post-form
      • post-json
    • 接口自动化测试框架基础
      • 实现步骤
      • 使用步骤
      • 整体框架示意
      • 代码实现
        • com.edu.core
          • ApiListener.java
          • BaseTest.java
          • HttpDriver .java
          • MailUtil.java
        • com.edu.dataprovider
          • ExcelDataProvider.java
          • MysqlDataProvider.java
          • NSDataProvider.java
          • TxtDataProvider.java
        • com.edu.utils
          • Checker.java
          • Common.java
          • DbHelper.java
          • Log.java
          • ReadPro.java
          • ResultSetHandler.java
          • ResultVerifier.java
        • com.edu.test
          • LoginTest.java
        • src-log4j2.xml

接口测试的定义

测试系统间接口的一种测试,测试的对象主要是接口,主要是测试外部系统与所测试系统之间以及内部系统之间的交互点。

接口测试的意义

  • 前后端分离,通过测试保证服务端的正确性
  • 基于安全考虑,前端验证很容易跳过。
  • BUG更容易定位
  • 自动化测试落地性价比更高,比UI更稳定
  • 测试提前,降低研发成本,提高效率
  • 更容易实现持续集成

接口测试的测试用例设计

  • 功能
    • 功能是否正常
    • 功能是否按照接口文档实现
  • 逻辑业务
    • 是否依赖业务
  • 异常处理
    • 参数异常【关键字参数、参数为空、多或少参数、错误参数】
    • 数据异常【关键字数据、数据为空、长度不一致、错误数据】
  • 安全
    • Cookie
    • 传输数据是否加密
    • 身份权限验证
    • 密码规则是否符合需求
    • 唯一识别码

接口测试的测试用例设计方法

  • 等价类分析
  • 边界值分析法
  • 决策表
  • 场景法
    在这里插入图片描述

postman

主要功能

  • 模拟各种http requests
  • Collection功能
  • 人性化的Response整理
  • 内置测试脚本管理
  • 设定变量与环境

请求体分类

在这里插入图片描述

JSON数据类型

  • 数值【整数、浮点数】例:”price”:123.78
  • null空值【”“表示空字符串不是空值】 例:”name”:null
  • 逻辑值【true\false】 例:”student”:true
  • 对象【花括号】例:”address”:{“line”: 123 yuhua road”,“city”:”shijiazhuang”}
  • 数组【方括号】例:“employees”: [{ “firstName”:“Bill” , “lastName”:“Gates” }, {“firstName”:“George” , “lastName”:“Bush” }]

postman内置参数

https://learning.postman.com/docs/writing-scripts/script-references/variables-list/

  • 时间戳:{{KaTeX parse error: Expected 'EOF', got '}' at position 10: timestamp}̲} {"tag":{"name…timestamp}}"}}
  • 随机生成整数0~1000:{{KaTeX parse error: Expected 'EOF', got '}' at position 10: randomInt}̲} {"tag":{"id":…randomInt}}"} }
  • 生成随机的GUID的字符串:{{KaTeX parse error: Expected 'EOF', got '}' at position 5: guid}̲} { "tag" : { …guid}}" } }

postman变量

全局变量

全局变量可供所有请求使用
pm.globals.set(“token1”, jsonData.access_token);

环境变量

//提取token的值
var jsonData=JSON.parse(responseBody)
console.log(jsonData.access_token)
pm.environment.set(“token1”, jsonData.access_token);

postman断言

在这里插入图片描述
在这里插入图片描述

JSON提取器

在这里插入图片描述

正则表达式提取器

在这里插入图片描述

Cookie提取器

在这里插入图片描述

postman加密

常见加密方式三种方式:

  • 加密算法(MD5、RSA、DES、AES、SHA)
  • 自定义加密算法
  • 接口签名
    在这里插入图片描述

接口签名

  • 1什么是接口签名?
  • 使用用户名,密码,时间戳和所有的排过序之后的参数,拼接组合起来成为一个串,再把该串加密得到的字符串,这就是一个签名。该签名字符串是唯一的有权访问第三方接口的鉴权码。
  • 2为什么需要做接口签名?
  • 防篡防伪装攻击。
  • 改攻击。
  • 防重放攻击。
  • 防数据泄露 。
  • 3生成signature(签名)规则
  • 对所有请求参数按key的ASCII码做升序排列
  • 把请求参数拼接组合成串
  • 把AccessKey和SecretKey码加入上面拼接好的字符串
  • 用时间戳连接到字符串的尾部
  • 再把这个字符串进行MD5加密,加密后再转化成大写
    在这里插入图片描述
    在这里插入图片描述

接口自动化测试基础

get

  • 创建HttpClient对象
  • CloseableHttpClient client =HttpClient.createDefault();
  • 创建get请求对象
  • HttpGet get=new HttpGet(url);
  • 执行请求获取响应
  • CloseHttpResponse response=client.execute(get)
  • 获得响应体
  • HttpEntity response_entity=response.getEntity();
  • 获取响应体内容
  • String response_str=EntityUtils.toString(response_entity,"utf-8");
  • 释放资源
  • EntityUtils.consume(entity);
  • 关闭连接
  • response.close();client.close();

post-form

  • 创建HttpClient对象
  • CloseableHttpClient client =HttpClient.createDefault();
  • 创建post请求
  • HttpPost post=new HttpPost(url);
  • 设置请求头
  • post.setHeader(Content-Type","application/x-www-form-url")
  • 构建请求体
  • List<NameValuePair> user=new ArrayList<>() user.add(new BasicNameValuePair("username","vip") user.add(new BasicNameValuePair("password","secret") ;
    HttpEntity user=new StringEntity(“username=vip&password=secret”)
  • 设置请求实体
  • post.setEntity(new UrlEncodedFormEntity(user));
    post.setEntity(user)
  • 执行请求获取响应
  • CloseHttpResponse response=client.execute(post)
  • 获得响应体
  • HttpEntity response_entity=response.getEntity();
  • 获取响应体内容
  • String response_str=EntityUtils.toString(response_entity,"utf-8");

post-json

  • 使用fastjson构建请求体
  • JSONObject user=new JSONObject() user.put(" "," ");
  • 设置请求实体
  • post.setEntity

接口自动化测试框架基础

实现步骤

1.域名存放在属性文件中
2.常用get,post,方法进行封装,针对不同的参数,实现重载。
doGet(String url)
doGet(String url,Map<String,Object> para)
doGetByCookie(String url,CookieStore cookie)
doPost(String url,String para)
doPostByForm(String url, List data )针对Content-type是Form
doPost(String url,JSONObject para) 针对Content-type是JSON
doPostByCookie(String url,JSONObject para,CookieStore cookie)
3.断言的封装 Checker
4.数据驱动(把1000个商品遍历,做submit的操作;10个用户的登录,下单)
5.数据库的访问(JDBC)
6.监听器的使用
ApiListener extends TestListenerAdapter
重写 onFinish()方法
7.发送邮件 JAVAMail

使用步骤

1.创建空项目 Qg
2.创建libs,把需要的jar拷贝进来
3.拷贝conf目录
4.拷贝log4j2.xml文件
5.每个接口创建一个测试类
6.对接口的操作封装为方法
7.如果需要数据库的验证,测试类需要继承
BaseTest

整体框架示意

在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述

代码实现

com.edu.core
ApiListener.java
package com.edu.core;import java.io.UnsupportedEncodingException;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Map.Entry;import org.testng.ITestContext;
import org.testng.ITestNGMethod;
import org.testng.ITestResult;
import org.testng.TestListenerAdapter;import com.edu.utils.Log;
import com.edu.utils.ReadPro;public class ApiListener extends TestListenerAdapter {private String writeResultToMail() {ITestNGMethod method[] = this.getAllTestMethods();List failedList = this.getFailedTests();List passedList = this.getPassedTests();List failedList1 = new ArrayList();List passedList1 = new ArrayList();for (int j = 0; j < failedList.size(); j++) {ITestResult tr = (ITestResult) failedList.get(j);if (tr.getMethod().getDescription() != null) {tr.setAttribute("name", tr.getMethod().getDescription());} else {tr.setAttribute("name", "");}failedList1.add(tr);}for (int j = 0; j < passedList.size(); j++) {ITestResult tr = (ITestResult) passedList.get(j);if (tr.getMethod().getDescription() != null) {tr.setAttribute("name", tr.getMethod().getDescription());} else {tr.setAttribute("name", "");}passedList1.add(tr);}Map context = new HashMap();context.put("date", new Date());context.put("failedList", failedList.size());context.put("passedList", passedList1.size());context.put("casesize", passedList.size() + failedList.size());context.put("failcasesize", failedList.size());try {String content = mapToString(context);return content;} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}return null;}public static String mapToString(Map<String, Object> para) {StringBuilder sBuilder = new StringBuilder();int size = para.size();for (Entry<String, Object> entry : para.entrySet()) {sBuilder.append(entry.getKey() + "=" + entry.getValue() + "\n");}return sBuilder.toString();}@Overridepublic void onFinish(ITestContext testContext) {super.onFinish(testContext);System.out.println(getAllTestMethods().length);String emailContent = this.writeResultToMail();System.out.println(emailContent);String emailTitle = ReadPro.getPropValue("mail_title") + "----" + this.getTime();String toMail = ReadPro.getPropValue("to_mail");try {
//			System.out.println(emailContent);
//			MailUtil.sendEmail(toMail, emailTitle, emailContent);} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}}public String getTime() {java.util.Calendar c = java.util.Calendar.getInstance();java.text.SimpleDateFormat f = new java.text.SimpleDateFormat("yyyy-MM-dd  hh:mm:ss");return f.format(c.getTime());}//	@Override
//	public void onTestSuccess(ITestResult tr) {
//		Log.info(tr.getInstance() + "-" + tr.getName() + "运行成功");
//	}
//
//	@Override
//	public void onTestFailure(ITestResult tr) {
//
//		Log.error(tr.getInstance() + "-" + tr.getName() + "运行失败");
//	}}
BaseTest.java
package com.edu.core;import org.testng.annotations.AfterClass;
import org.testng.annotations.AfterMethod;
import org.testng.annotations.AfterSuite;
import org.testng.annotations.BeforeClass;
import org.testng.annotations.BeforeMethod;
import org.testng.annotations.BeforeSuite;import com.edu.utils.DbHelper;public class BaseTest {public DbHelper db ;@BeforeClasspublic void setUp()	throws Exception {db=DbHelper.getInstance();System.out.println("初始化数据库");}@AfterClasspublic void tearDown() throws Exception {db.close();}}
HttpDriver .java
package com.edu.core;import java.io.IOException;
import java.io.UnsupportedEncodingException;
import java.net.URLEncoder;
import java.util.List;
import java.util.Map;
import java.util.Map.Entry;import org.apache.hc.client5.http.classic.methods.HttpGet;
import org.apache.hc.client5.http.classic.methods.HttpPost;
import org.apache.hc.client5.http.config.RequestConfig;
import org.apache.hc.client5.http.cookie.CookieStore;
import org.apache.hc.client5.http.cookie.StandardCookieSpec;
import org.apache.hc.client5.http.entity.UrlEncodedFormEntity;
import org.apache.hc.client5.http.impl.classic.CloseableHttpClient;
import org.apache.hc.client5.http.impl.classic.CloseableHttpResponse;
import org.apache.hc.client5.http.impl.classic.HttpClients;
import org.apache.hc.core5.http.HttpEntity;
import org.apache.hc.core5.http.NameValuePair;
import org.apache.hc.core5.http.ParseException;
import org.apache.hc.core5.http.io.entity.EntityUtils;
import org.apache.hc.core5.http.io.entity.StringEntity;import com.alibaba.fastjson2.JSONObject;
import com.edu.utils.Common;
import com.edu.utils.ReadPro;public class HttpDriver {static CloseableHttpClient httpClient = null;static CloseableHttpResponse respone = null;public static String doGet(String url) throws Exception {httpClient = HttpClients.createDefault();HttpGet get = new HttpGet(ReadPro.getPropValue("base_url") + url);respone = httpClient.execute(get);HttpEntity entity = respone.getEntity();String content = EntityUtils.toString(entity, "utf-8");EntityUtils.consume(entity);respone.close();httpClient.close();return content;}public static String doGet(String url, JSONObject data) throws Exception {String para = URLEncoder.encode(data.toString(), "UTF-8");httpClient = HttpClients.createDefault();HttpGet get = new HttpGet(url + "?" + para);respone = httpClient.execute(get);HttpEntity entity = respone.getEntity();String content = EntityUtils.toString(entity, "utf-8");EntityUtils.consume(entity);respone.close();httpClient.close();return content;}public static String doGetForEncoder(String url, String para) throws Exception {httpClient = HttpClients.createDefault();String content=URLEncoder.encode(para,"utf-8");HttpGet get = new HttpGet(ReadPro.getPropValue("base_url") + url + content);respone = httpClient.execute(get);HttpEntity entity = respone.getEntity();String result = EntityUtils.toString(entity, "utf-8");EntityUtils.consume(entity);respone.close();httpClient.close();return result;}public static String doGet(String url, Map<String, String> para) throws IOException, ParseException {String content = null;httpClient = HttpClients.createDefault();HttpGet get = new HttpGet(ReadPro.getPropValue("base_url") + url + "?" +Common.mapToString(para));respone = httpClient.execute(get);HttpEntity entity = respone.getEntity();content = EntityUtils.toString(entity, "utf-8");EntityUtils.consume(entity);respone.close();httpClient.close();return content;}public static String doPost(String url, JSONObject para) {httpClient = HttpClients.createDefault();HttpPost post = new HttpPost(ReadPro.getPropValue("base_url") + url);post.addHeader("Content-Type", "application/json");HttpEntity data;String content = null;try {data = new StringEntity(para.toString());post.setEntity(data);respone = httpClient.execute(post);HttpEntity entity = respone.getEntity();content = EntityUtils.toString(entity, "utf-8");EntityUtils.consume(entity);respone.close();httpClient.close();} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}return content;}public static String doGet(String url, CookieStore cookie) throws Exception {CloseableHttpClient client=HttpClients.custom().setDefaultCookieStore(cookie).build();HttpGet get = new HttpGet(ReadPro.getPropValue("base_url") + url);CloseableHttpResponse response = client.execute(get);HttpEntity result_entity = response.getEntity();String result = EntityUtils.toString(result_entity, "utf-8");EntityUtils.consume(result_entity);response.close();client.close();return result;}public static String doPostByForm(String url, List<NameValuePair> data ) throws Exception {httpClient = HttpClients.createDefault();HttpPost post = new HttpPost(ReadPro.getPropValue("base_url") + url);post.addHeader("Content-Type", "application/x-www-form-urlencoded");post.setEntity(new UrlEncodedFormEntity(data));respone = httpClient.execute(post);HttpEntity entity = respone.getEntity();String content = EntityUtils.toString(entity, "utf-8");respone.close();httpClient.close();return content;}public static String doPost(String url, JSONObject para, CookieStore cookie) throws Exception {httpClient=HttpClients.custom().setDefaultCookieStore(cookie).build();HttpPost post = new HttpPost(ReadPro.getPropValue("base_url")+url);post.addHeader("Content-Type", "application/json");HttpEntity data = new StringEntity(para.toString());post.setEntity(data);CloseableHttpResponse respone = httpClient.execute(post);HttpEntity entity = respone.getEntity();String content = EntityUtils.toString(entity, "utf-8");EntityUtils.consume(entity);respone.close();httpClient.close();return content;}}
MailUtil.java
package com.edu.core;import java.io.UnsupportedEncodingException;
import java.util.Date;
import java.util.Properties;import java.util.Properties;import javax.mail.Authenticator;
import javax.mail.Message;
import javax.mail.MessagingException;
import javax.mail.NoSuchProviderException;
import javax.mail.PasswordAuthentication;
import javax.mail.Session;
import javax.mail.Transport;
import javax.mail.internet.AddressException;
import javax.mail.internet.InternetAddress;
import javax.mail.internet.MimeMessage;public class MailUtil {static int port = 25;static String server = "smtp.126.com";static String from = "李焕贞";static String user = "testlihuanzhen@126.com";static String password = "123456abcd";//授权码public static void sendEmail(String email, String subject, String body) throws UnsupportedEncodingException {try {Properties props = new Properties();props.put("mail.smtp.host", server);props.put("mail.smtp.port", String.valueOf(port));props.put("mail.smtp.auth", "true");Transport transport = null;Session session = Session.getDefaultInstance(props,null);transport = session.getTransport("smtp");transport.connect(server, user, password);MimeMessage msg = new MimeMessage(session);msg.setSentDate(new Date());InternetAddress fromAddress = new InternetAddress(user,from,"UTF-8");msg.setFrom(fromAddress);String emailList[]=email.split(",");InternetAddress[] toAddress = new InternetAddress[emailList.length];for(int i=0;i<emailList.length;i++){toAddress[i]=new InternetAddress(emailList[i]);}msg.addRecipients(Message.RecipientType.TO, toAddress);msg.setSubject(subject, "UTF-8");   msg.setContent(body, "text/html;charset=utf-8");msg.saveChanges();transport.sendMessage(msg, msg.getAllRecipients());} catch (NoSuchProviderException e) {e.printStackTrace();} catch (MessagingException e) {e.printStackTrace();}}public static void main(String args[]) throws UnsupportedEncodingException{MailUtil.sendEmail("testlihuanzhen@126.com", "星期二", "测试");}}
com.edu.dataprovider
ExcelDataProvider.java
package com.edu.dataprovider;import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.testng.annotations.DataProvider;
import org.testng.annotations.Test;
/** Excel数据驱动类*/public class ExcelDataProvider {public Object[][] getTestDataByExcel(String fileName, String sheetName)throws IOException {File file = new File(fileName);FileInputStream inputstream = new FileInputStream(file);Workbook wbook = null;String fileExtensionName = fileName.substring(fileName.indexOf("."));if (fileExtensionName.equals(".xlsx")) {wbook = new XSSFWorkbook(inputstream);} else if (fileExtensionName.equals(".xls")) {wbook = new HSSFWorkbook(inputstream);}Sheet sheet = wbook.getSheet(sheetName);// 通过sheetName生成Sheet对象int rowCount = sheet.getLastRowNum() - sheet.getFirstRowNum();// 获取当前sheet行数,行号和列号都是从0开始List<Object[]> records = new ArrayList<Object[]>();// 使用双循环获取excel文件的所有数据(第一行除外)for (int i = 1; i < rowCount + 1; i++) {Row row = sheet.getRow(i);String fields[] = new String[row.getLastCellNum()];for (int j = 0; j < row.getLastCellNum(); j++) {// 获取单元格数据fields[j] = row.getCell(j).getStringCellValue();}records.add(fields);}Object[][] results = new Object[records.size()][];for (int i = 0; i < records.size(); i++) {results[i] = records.get(i);}return results;}}
MysqlDataProvider.java
package com.edu.dataprovider;import java.io.IOException;
import java.sql.*;import java.util.ArrayList;
import java.util.List;import org.testng.annotations.DataProvider;
import org.testng.annotations.Test;public class MysqlDataProvider {public  Object[][] getTestDataByMysql(String sql) {String url = "jdbc:mysql://10.7.90.21:3306/market_db";List<Object[]> records = new ArrayList<Object[]>();try {Class.forName("com.mysql.jdbc.Driver");Connection conn = DriverManager.getConnection(url, "root", "123456");if (!conn.isClosed()) {System.out.println("连接数据库成功");}// Statement里面带有很多方法,比如executeUpdate可以实现插入,更新和删除等Statement stmt = conn.createStatement();ResultSet rs = stmt.executeQuery(sql);//得到数据集的结构ResultSetMetaData rsMetaData = rs.getMetaData();int cols = rsMetaData.getColumnCount();System.out.println(cols);while (rs.next()) {String fields[] = new String[cols];int col=0;for (int i = 0; i < cols; i++) {fields[col] = rs.getString(i+1);//读取当前行指定的列col++;}records.add(fields);}rs.close();conn.close();} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}Object[][] results = new Object[records.size()][];for (int i = 0; i < records.size(); i++) {results[i] = records.get(i);}return results;}}
NSDataProvider.java
package com.edu.dataprovider;import java.io.IOException;import org.testng.annotations.DataProvider;
import org.testng.annotations.Test;public class NSDataProvider {@DataProvider(name="goodId")public Object[][] getId() throws IOException{return new ExcelDataProvider().getTestDataByExcel("data/mall.xlsx", "Sheet1");}@Test(dataProvider ="goodId" )public void test1(String id) {System.out.println(id);}@DataProvider(name="zl_shop")public  Object[][] getTxtData() throws IOException{return new  TxtDataProvider().getTxtUser("data/user.txt");}@DataProvider(name="user")public  Object[][] getMovieData() throws IOException{return new  ExcelDataProvider().getTestDataByExcel("data/user.xlsx","Sheet1");}@Test(dataProvider="txt")public void getData(String a,String b) {System.out.println(a+" "+b);}@DataProvider(name="excel")public Object[][] getExcelDada() throws IOException{return new ExcelDataProvider().getTestDataByExcel("data/user.xlsx","Sheet1");}@DataProvider(name="mysql")public Object[][] getMysqlDada() throws IOException{return new MysqlDataProvider().getTestDataByMysql("SELECT pid,name from t_product");}@Test(dataProvider="mysql")public void testDB(String a,String b) {System.out.println(a+" "+b);}}
TxtDataProvider.java
package com.edu.dataprovider;import java.io.BufferedReader;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStreamReader;
import java.util.ArrayList;
import java.util.List;import org.testng.annotations.DataProvider;
import org.testng.annotations.Test;public class TxtDataProvider {public Object[][] getTxtUser(String fileName) throws IOException {List<String> dataList = new ArrayList<String>();File file = new File(fileName);FileInputStream fis = new FileInputStream(file);InputStreamReader isr= new InputStreamReader(fis);BufferedReader reader = new BufferedReader(isr);int cols=reader.readLine().split("\t").length;String readData;while((readData=reader.readLine())!=null) {dataList.add(readData);}Object [][] result = new Object[dataList.size()][cols];String [] arrays;for(int i=0;i<dataList.size();i++) {arrays=dataList.get(i).split("\t");for(int j=0;j<cols;j++)result[i][j]=arrays[j];}return result;}}
com.edu.utils
Checker.java
package com.edu.utils;import static org.testng.Assert.assertEquals;import java.util.List;import com.alibaba.fastjson2.JSONObject;public class Checker {String exceptionMessage = "";String message = "";String actualValue = "";String expectValue = "";JSONObject json = null;public Checker(String result) {this.json = JSONObject.parseObject(result);}public void assertArray(String patten,String key,String content){actualValue=this.json.getJSONArray(patten).getJSONObject(0).getString(key);assertEquals(actualValue, content);}public void verifyTextPresent(String patten) throws Exception {boolean value = json.containsKey(patten);if (value) {Log.info("the Text: '" + patten + "' is Present!");} else {Log.fatal("the Text: '" + patten + "' is not Present!");throw new Exception("the Text: '" + patten + "' is not Present!");}}public void verifyXpath(String locator, String patten) throws Exception {actualValue = this.json.getString(locator);verify(patten, actualValue);}public void verify(String pattern, String actualValue) throws Exception {this.actualValue = actualValue;this.setExceptionMessage(actualValue, pattern);this.setMessage(pattern, actualValue);String errormsg = getExceptionMessage();String msg = getMessage();if (ResultVerifier.verifyStringsByEqualAndExist(pattern, actualValue)) {Log.info(msg);} else {Log.fatal(errormsg);Log.info(json.toString());throw new Exception(errormsg);}}public void assertXpath(String locator, String object) throws Exception {// TODO Auto-generated method stubactualValue = this.json.getString(locator);assertEquals(actualValue,object);}public void setExceptionMessage(String actualValue, String expectValue) {this.exceptionMessage = "expectedValue doesn't match actualValue,actual Value is :" + actualValue+ "; expected Value is :" + expectValue;}public void setMessage(String expectValue, String actualValue) {this.message = "expectedValue :" + expectValue + "  match actualValue:" + actualValue;}public String getExceptionMessage() {return exceptionMessage;}public String getMessage() {return message;}
}
Common.java
package com.edu.utils;import java.io.IOException;
import java.util.Map;
import java.util.Map.Entry;import org.apache.hc.client5.http.classic.methods.HttpPost;
import org.apache.hc.client5.http.config.RequestConfig;
import org.apache.hc.client5.http.cookie.BasicCookieStore;
import org.apache.hc.client5.http.cookie.CookieStore;
import org.apache.hc.client5.http.cookie.StandardCookieSpec;
import org.apache.hc.client5.http.impl.classic.CloseableHttpClient;
import org.apache.hc.client5.http.impl.classic.CloseableHttpResponse;
import org.apache.hc.client5.http.impl.classic.HttpClients;
import org.apache.hc.core5.http.HttpEntity;
import org.apache.hc.core5.http.io.entity.EntityUtils;
import org.apache.hc.core5.http.io.entity.StringEntity;import com.alibaba.fastjson2.JSONObject;public class Common {// 把map类型转换为String,并用&加以拼接public static String mapToString(Map<String, String> para) {StringBuilder sBuilder = new StringBuilder();String content = null;int size = para.size();for (Entry<String, String> entry : para.entrySet()) {sBuilder.append(entry.getKey() + "=" + entry.getValue());size--;if (size >= 1) {sBuilder.append("&");}}return sBuilder.toString();}public static CookieStore getCookie(String u_name,String password) throws Exception, IOException {JSONObject user=new JSONObject();user.put("phoneArea", "86");user.put("phoneNumber", u_name);user.put("password", password);CookieStore cookie = new BasicCookieStore();CloseableHttpClient client = HttpClients.custom().setDefaultCookieStore(cookie).build();String loginurl=ReadPro.getPropValue("base_url")+"/common/fgadmin/login";HttpPost post =new HttpPost(loginurl);//设置请求体HttpEntity userEntity=new StringEntity(user.toString());post.setHeader("Content-Type","application/json");post.setEntity(userEntity);CloseableHttpResponse response=client.execute(post);HttpEntity responseEntity=response.getEntity();String result=EntityUtils.toString(responseEntity,"UTF-8");System.out.println(result);EntityUtils.consume(responseEntity);response.close();client.close();return cookie;}}
DbHelper.java
package com.edu.utils;import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
//import java.sql.DriverManager;
//import java.sql.PreparedStatement;
//import java.sql.ResultSet;
//import java.sql.SQLException;
//import java.sql.Statement;
import java.util.HashMap;
import java.util.List;
import java.util.Map;import org.apache.logging.log4j.LogManager;
import org.apache.logging.log4j.Logger;public class DbHelper {static Logger log = LogManager.getLogger(DbHelper.class.getName());public java.sql.Connection conn = null; //connection objectpublic ResultSet rs = null; //resultset objectpublic Statement stmt = null; //statement objectpublic PreparedStatement pstmt = null; //preparedstatement objectprivate String drivers = null; //connection parameter:driversprivate String url = null; //connection parameter:urlprivate String user = null; //connection parameter:userprivate String password = null; //connection parameter:passwordprivate String configFile;public DbHelper() {}public DbHelper(String configFile) {this.configFile = configFile;init();}public static DbHelper getInstance() {DbHelper instance = new DbHelper("conf/conf.properties");instance.init();return instance;}private void init() {drivers = ReadPro.getPropValue("persistence.datasource.driverClassName");url = ReadPro.getPropValue("persistence.datasource.url");user = ReadPro.getPropValue("persistence.datasource.username");password = ReadPro.getPropValue("persistence.datasource.password");try {log.info(drivers+"---"+url);Class.forName(drivers);conn = DriverManager.getConnection(url, user, password);stmt = conn.createStatement();} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}public List query(String sql) throws Exception{List list = null;rs = stmt.executeQuery(sql);if (null != rs) {list = ResultSetHandler.toMapList(rs);}return list;}public boolean execute(String sql) throws Exception{boolean flag=false;flag = stmt.execute(sql);return flag;}public Map queryToMap(String sql) throws Exception{Map map = null;rs = stmt.executeQuery(sql);if (null != rs) {map = ResultSetHandler.toMap(rs);}return map;}public List queryToList(String sql) throws Exception {List list = null;rs = stmt.executeQuery(sql);if (null != rs) {list = ResultSetHandler.toStringArrayList(rs);}return list;}public String queryToString(String sql) { String str = null;try {rs = stmt.executeQuery(sql);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}if (null != rs) {try {str = ResultSetHandler.toString(rs);} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}}return str;}public void close() {if (null != rs) {try {rs.close();} catch (SQLException ex) {rs = null;}}if (null != stmt) {try {stmt.close();} catch (SQLException ex) {stmt = null;}}if (null != pstmt) {try {pstmt.close();} catch (SQLException ex) {pstmt = null;}}if (conn != null) {try {conn.close();} catch (SQLException e) {// TODO Auto-generated catch blockconn = null;}}}public static void main(String args[]) {DbHelper db = DbHelper.getInstance();try {List list = db.query("select * from malluser");for (int i = 0; i < list.size(); i++) {HashMap map = (HashMap) list.get(i);System.out.println(map.toString());}} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}}}
Log.java
package com.edu.utils;import org.apache.logging.log4j.LogManager;
import org.apache.logging.log4j.Logger;public class Log {static Logger logger = LogManager.getLogger(Log.class);public static void fatal(String msg) {logger.fatal(msg);}public static void error(String msg) {logger.error(msg);}public static void warn(String msg) {logger.warn(msg);}public static void info(String msg) {logger.info(msg);}public static void debug(String msg) {logger.debug(msg);}
}
ReadPro.java
package com.edu.utils;import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.util.Properties;public class ReadPro {public static final String filePath="conf/conf.properties";public static String getPropValue(String key) {Properties prop = new Properties();FileInputStream fis;try {fis = new FileInputStream(filePath);prop.load(fis);fis.close();} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}return prop.getProperty(key);}
}
ResultSetHandler.java
package com.edu.utils;import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;import org.apache.logging.log4j.LogManager;
import org.apache.logging.log4j.Logger;public class ResultSetHandler {static Logger log = LogManager.getLogger(ResultSetHandler.class.getName());public static List<Map<String, String>> toMapList(ResultSet rs){List<Map<String, String>> lst = new ArrayList<Map<String, String>>();ResultSetMetaData md;try{md = rs.getMetaData();String[] fieldNames = new String[md.getColumnCount()];for(int i=1;i<=fieldNames.length;i++){fieldNames[i-1] = md.getColumnLabel(i).toLowerCase();}while(rs.next()){Map<String, String> map = new HashMap<String, String>();for (int i = 1; i <= fieldNames.length; i++) {if(8==md.getColumnType(i)){map.put(fieldNames[i-1],String.valueOf(rs.getDouble(i)));}else{map.put(fieldNames[i-1],rs.getString(i));}}lst.add(map);}}catch (Exception e){log.error(e.getMessage(),e);//throw(new BaseException(Errors.ERRORS_COMMON,new String[]{Errors.DBOPERATION_FORMATRESULT},e.getMessage(),e));}return lst;}//private static Logger log = Logger.getLogger(ResultSetHandler.class);public static Map<String, String> toMap(ResultSet rs){Map<String, String> map = new HashMap<String, String>();ResultSetMetaData md;try{md = rs.getMetaData();String[] fieldNames = new String[md.getColumnCount()];for(int i=1;i<=fieldNames.length;i++){fieldNames[i-1] = md.getColumnLabel(i).toLowerCase();}if(rs.next()){for (int i = 1; i <= fieldNames.length; i++) {if(8==md.getColumnType(i)){map.put(fieldNames[i-1],String.valueOf(rs.getDouble(i)));}else{map.put(fieldNames[i-1],rs.getString(i));}}}}catch (Exception e){log.error(e.getMessage(),e);//throw(new BaseException(Errors.ERRORS_COMMON,new String[]{Errors.DBOPERATION_FORMATRESULT},e.getMessage(),e));}return map;}public static List toStringArrayList(ResultSet rs) throws Exception{List<String[]> lst = new ArrayList<String[]>();ResultSetMetaData md = rs.getMetaData();int fieldCount = md.getColumnCount();while(rs.next()){String[] arr = new String[fieldCount];for (int i = 1; i <= fieldCount; i++) {arr[i-1] = rs.getString(i);}lst.add(arr);}return lst;}public static String toString(ResultSet rs) throws Exception{String str = "";ResultSetMetaData md = rs.getMetaData();int fieldCount = md.getColumnCount();if(rs.next()&&fieldCount>=1){           if(8==md.getColumnType(1)){str = String.valueOf(rs.getDouble(1));}else{str = rs.getString(1);}}return str;}public static List<Object[]> toObjectArrayList(ResultSet rs){List<Object[]> lst = new ArrayList<Object[]>();ResultSetMetaData md;try{md = rs.getMetaData();int fieldCount = md.getColumnCount();while(rs.next()){Object[] arr = new Object[fieldCount];for (int i = 1; i <= fieldCount; i++) {arr[i-1] = rs.getObject(i);}lst.add(arr);}        }catch (SQLException e){//log.error(e.getMessage(),e);//throw(new BaseException(Errors.ERRORS_COMMON,new String[]{Errors.DBOPERATION_FORMATRESULT},e.getMessage(),e));}return lst;}public List<String> getFieldList(ResultSet rs) {ResultSetMetaData md;List<String> list = null;try{md = rs.getMetaData();list = new ArrayList<String>();for(int i=1;i<=md.getColumnCount();i++){list.add(md.getColumnLabel(i).toLowerCase());}}catch (SQLException e){log.error(e.getMessage(),e);}return list;}
}
ResultVerifier.java
package com.edu.utils;public class ResultVerifier {public static boolean verifyStringsByEqual(final String expectedValue, final String actualValue) {return expectedValue != null && expectedValue.equals(actualValue);}public static boolean verifyStringsByEqualAndExist(final String expectedValue, final String actualValue) {boolean flag=false;if(expectedValue != null && expectedValue.equals(actualValue)){flag=true;return flag;}if(expectedValue != null && actualValue.contains(expectedValue)){flag=true;return flag;}return flag;}public static void main(String args[]){System.out.print(ResultVerifier.verifyStringsByEqualAndExist("hello", "hello world"));}
}
com.edu.test
LoginTest.java
package com.edu.test;import org.testng.annotations.Test;import com.alibaba.fastjson2.JSONObject;
import com.edu.core.ApiListener;
import com.edu.core.HttpDriver;
import com.edu.dataprovider.NSDataProvider;
import com.edu.utils.Checker;public class LoginTest {String login_url = "/common/fgadmin/login";Checker check = null;public void login(Object phoneArea, Object phoneNumber, Object password) {JSONObject user = new JSONObject();user.put("phoneArea", phoneArea);user.put("phoneNumber", phoneNumber);user.put("password", password);String result = HttpDriver.doPost(login_url, user);System.out.println(result);check = new Checker(result);}@Testpublic void testLoginSuccess() throws Exception {login("86", "2000", "123456");check.verifyTextPresent("message");check.verifyXpath("code", "200");}}
src-log4j2.xml
<?xml version="1.0" encoding="UTF-8"?>
<Configuration status="warn"><Appenders><Console name="Console" target="SYSTEM_ERR"><PatternLayout pattern="[%-5p] %d %c - %m%n" /></Console><File name="File" fileName="dist/my.log"><PatternLayout pattern="[%-5p] %d %c - %m%n" /></File></Appenders><Loggers><Root level="WARN"><AppenderRef ref="File" /><AppenderRef ref="Console" /></Root></Loggers>
</Configuration>

相关文章:

接口自动化测试框架设计

文章目录 接口测试的定义接口测试的意义接口测试的测试用例设计接口测试的测试用例设计方法postman主要功能请求体分类JSON数据类型postman内置参数postman变量全局变量环境变量 postman断言JSON提取器正则表达式提取器Cookie提取器postman加密接口签名 接口自动化测试基础getp…...

详解ISIS动态路由协议

华子目录 前言应用场景历史起源ISIS路由计算过程ISIS的地址结构ISIS路由器分类ISIS邻居关系的建立P2PMA ISIS中的DIS与OSPF中DR的对比链路状态信息的交互ISIS的最短路径优先算法&#xff08;SPF&#xff09;ISIS区域划分ISIS区域间路由访问原理ISIS与OSPF的不同ISIS与OSPF的术语…...

Linux操作系统----gdb调试工具(配实操图)

绪论​ “不用滞留采花保存&#xff0c;只管往前走去&#xff0c;一路上百花自会盛开。 ——泰戈尔”。本章是Linux工具篇的最后一章。gdb调试工具是我们日常工作中需要掌握的一项重要技能我们需要基本的掌握release和debug的区别以及gdb的调试方法的指令。下一章我们将进入真正…...

去除GIT某个时间之前的提交日志

背景 有时git提交了太多有些较早之前的提交日志&#xff0c;不想在git log看到&#xff0c;想把他删除掉。 方法 大概思路是通过 git clone --depth 来克隆到指定提交的代码&#xff0c;此时再早之前的日志是没有的 然后提交到新仓库 #!/bin/bash ori_git"gityour.gi…...

4 python快速上手

计算机常识知识 1.Python代码运行方式2.进制2.1 进制转换 3. 计算机中的单位4.编码4.1 ascii编码4.2 gb-2312编码4.3 unicode4.4 utf-8编码4.5 Python相关的编码 总结 各位小伙伴想要博客相关资料的话关注公众号&#xff1a;chuanyeTry即可领取相关资料&#xff01; 1.Python代…...

单元测试-spring-boot-starter-test+junit5

前言&#xff1a; 开发过程中经常需要写单元测试&#xff0c;记录一下单元测试spring-boot-starter-testjunit5的使用 引入内容&#xff1a; 引用jar包 <!-- SpringBoot测试类依赖 --> <dependency><groupId>org.springframework.boot</groupId><…...

CentOS 7上安装Anaconda 详细教程

目录 1. 下载Anaconda安装脚本2. 校验数据完整性&#xff08;可选&#xff09;3. 运行安装脚本4. 遵循安装指南5. 选择安装位置6. 初始化Anaconda7. 激活安装8. 测试安装9. 更新Anaconda10. 使用Anaconda 1. 下载Anaconda安装脚本 首先需要从Anaconda的官方网站下载最新的Anac…...

2023年全球软件架构师峰会(ArchSummit深圳站):核心内容与学习收获(附大会核心PPT下载)

本次峰会是一次重要的技术盛会&#xff0c;旨在为全球软件架构师提供一个交流和学习的平台。本次峰会聚焦于软件架构的最新趋势、最佳实践和技术创新&#xff0c;吸引了来自世界各地的软件架构师、技术专家和企业领袖。 在峰会中&#xff0c;与会者可以了解到数字化、AIGC、To…...

RT-Thread Studio学习(十六)定时器计数

RT-Thread Studio学习&#xff08;十六&#xff09;定时器计数 一、简介二、新建RT-Thread项目并使用外部时钟三、启用PWM输入捕获功能四、测试 一、简介 本文将基于STM32F407VET芯片介绍如何在RT-Thread Studio开发环境下使用定时器对输入脉冲进行计数。 硬件及开发环境如下…...

【linux进程间通信(一)】匿名管道和命名管道

&#x1f493;博主CSDN主页:杭电码农-NEO&#x1f493;   ⏩专栏分类:Linux从入门到精通⏪   &#x1f69a;代码仓库:NEO的学习日记&#x1f69a;   &#x1f339;关注我&#x1faf5;带你学更多操作系统知识   &#x1f51d;&#x1f51d; 进程间通信 1. 前言2. 进程间…...

第11章 jQuery

学习目标 了解什么是jQuery,能够说出jQuery的特点 掌握jQuery的下载和引入,能够下载jQuery并且能够使用两种方式引入jQuery 掌握jQuery的简单使用,能够使用jQuery实现简单的页面效果 熟悉什么是jQuery对象,能够说出jQuery对象与DOM对象的区别 掌握利用选择器获取元素的方法…...

leetcode:1736. 替换隐藏数字得到的最晚时间(python3解法)

难度&#xff1a;简单 给你一个字符串 time &#xff0c;格式为 hh:mm&#xff08;小时&#xff1a;分钟&#xff09;&#xff0c;其中某几位数字被隐藏&#xff08;用 ? 表示&#xff09;。 有效的时间为 00:00 到 23:59 之间的所有时间&#xff0c;包括 00:00 和 23:59 。 …...

MySQL存储函数与存储过程习题

创建表并插入数据&#xff1a; 字段名 数据类型 主键 外键 非空 唯一 自增 id INT 是 否 是 是 否 name VARCHAR(50) 否 否 是 否 否 glass VARCHAR(50) 否 否 是 否 否 ​ ​ sch 表内容 id name glass 1 xiaommg glass 1 2 xiaojun glass 2 1、创建一个可以统计表格内记录…...

基于 Hologres+Flink 的曹操出行实时数仓建设

本文整理自曹操出行实时计算负责人林震基于 HologresFlink 的曹操出行实时数仓建设的分享&#xff0c;内容主要分为以下六部分&#xff1a; 曹操出行业务背景介绍曹操出行业务痛点分析HologresFlink 构建企业级实时数仓曹操出行实时数仓实践曹操出行业务成果分析未来展望 一、曹…...

【Docker】实战多阶段构建 Laravel 镜像

作者主页&#xff1a; 正函数的个人主页 文章收录专栏&#xff1a; Docker 欢迎大家点赞 &#x1f44d; 收藏 ⭐ 加关注哦&#xff01; 本节适用于 PHP 开发者阅读。Laravel 基于 8.x 版本&#xff0c;各个版本的文件结构可能会有差异&#xff0c;请根据实际自行修改。 准备 新…...

【MATLAB源码-第118期】基于matlab的蜘蛛猴优化算法(SMO)无人机三维路径规划,输出做短路径图和适应度曲线。

操作环境&#xff1a; MATLAB 2022a 1、算法描述 蜘蛛猴优化算法&#xff08;Spider Monkey Optimization, SMO&#xff09;是一种灵感来源于蜘蛛猴觅食行为的群体智能优化算法。蜘蛛猴是一种生活在南美洲热带雨林中的灵长类动物&#xff0c;它们在寻找食物时展现出的社会行…...

【计算机组成与体系结构Ⅱ】Tomasulo 算法模拟和分析(实验)

实验5&#xff1a;Tomasulo 算法模拟和分析 一、实验目的 1&#xff1a;加深对指令级并行性及开发的理解。 2&#xff1a;加深对 Tomasulo 算法的理解。 3&#xff1a;掌握 Tomasulo 算法在指令流出、执行、写结果各阶段对浮点操作指令以及 load 和 store 指令进行了什么处…...

Nginx 简介

1、概念介绍 Nginx ("engine x") 是一个轻量级、高性能的 WEB 服务器软件和反向代理服务器。 Nginx 是由 Igor Sysoev 为俄罗斯访问量第二的 Rambler.ru 站点开发的&#xff0c;第一个公开版本 0.1.0 发布于 2004 年 10 月 4 日。其将源代码以类 BSD 许可证的形式发…...

C++入门学习(一)写一个helloworld

1、头文件 #include <iostream> using namespace std; 任何程序都需要这两句的&#xff0c;写上就好。 2、主文件 int main() {cout<<"Hello World!"<<endl;return 0; } 由于是int型数据&#xff0c;所以要返回一个值&#xff0c;即return0。…...

ChatGPT 股市知识问答

我 2024-01-17 14:16:38 股市交易的关键指标有哪些&#xff1f; ChatGPT 2024-01-17 14:16:38 股市交易中常用的关键指标有很多&#xff0c;以下是一些常见的指标&#xff1a; 股价指标&#xff1a;股价是衡量股票价格变化的重要指标&#xff0c;包括每股收益&#xff08;EPS…...

shell脚本--常见案例

1、自动备份文件或目录 2、批量重命名文件 3、查找并删除指定名称的文件&#xff1a; 4、批量删除文件 5、查找并替换文件内容 6、批量创建文件 7、创建文件夹并移动文件 8、在文件夹中查找文件...

线程与协程

1. 线程与协程 1.1. “函数调用级别”的切换、上下文切换 1. 函数调用级别的切换 “函数调用级别的切换”是指&#xff1a;像函数调用/返回一样轻量地完成任务切换。 举例说明&#xff1a; 当你在程序中写一个函数调用&#xff1a; funcA() 然后 funcA 执行完后返回&…...

【Veristand】Veristand环境安装教程-Linux RT / Windows

首先声明&#xff0c;此教程是针对Simulink编译模型并导入Veristand中编写的&#xff0c;同时需要注意的是老用户编译可能用的是Veristand Model Framework&#xff0c;那个是历史版本&#xff0c;且NI不会再维护&#xff0c;新版本编译支持为VeriStand Model Generation Suppo…...

flow_controllers

关键点&#xff1a; 流控制器类型&#xff1a; 同步&#xff08;Sync&#xff09;&#xff1a;发布操作会阻塞&#xff0c;直到数据被确认发送。异步&#xff08;Async&#xff09;&#xff1a;发布操作非阻塞&#xff0c;数据发送由后台线程处理。纯同步&#xff08;PureSync…...

Java中HashMap底层原理深度解析:从数据结构到红黑树优化

一、HashMap概述与核心特性 HashMap作为Java集合框架中最常用的数据结构之一&#xff0c;是基于哈希表的Map接口非同步实现。它允许使用null键和null值&#xff08;但只能有一个null键&#xff09;&#xff0c;并且不保证映射顺序的恒久不变。与Hashtable相比&#xff0c;Hash…...

【记录坑点问题】IDEA运行:maven-resources-production:XX: OOM: Java heap space

问题&#xff1a;IDEA出现maven-resources-production:operation-service: java.lang.OutOfMemoryError: Java heap space 解决方案&#xff1a;将编译的堆内存增加一点 位置&#xff1a;设置setting-》构建菜单build-》编译器Complier...

Java中栈的多种实现类详解

Java中栈的多种实现类详解&#xff1a;Stack、LinkedList与ArrayDeque全方位对比 前言一、Stack类——Java最早的栈实现1.1 Stack类简介1.2 常用方法1.3 优缺点分析 二、LinkedList类——灵活的双端链表2.1 LinkedList类简介2.2 常用方法2.3 优缺点分析 三、ArrayDeque类——高…...

深入浅出JavaScript中的ArrayBuffer:二进制数据的“瑞士军刀”

深入浅出JavaScript中的ArrayBuffer&#xff1a;二进制数据的“瑞士军刀” 在JavaScript中&#xff0c;我们经常需要处理文本、数组、对象等数据类型。但当我们需要处理文件上传、图像处理、网络通信等场景时&#xff0c;单纯依赖字符串或数组就显得力不从心了。这时&#xff…...

IP选择注意事项

IP选择注意事项 MTP、FTP、EFUSE、EMEMORY选择时&#xff0c;需要考虑以下参数&#xff0c;然后确定后选择IP。 容量工作电压范围温度范围擦除、烧写速度/耗时读取所有bit的时间待机功耗擦写、烧写功耗面积所需要的mask layer...

从数据报表到决策大脑:AI重构电商决策链条

在传统电商运营中&#xff0c;决策链条往往止步于“数据报表层”&#xff1a;BI工具整合历史数据&#xff0c;生成滞后一周甚至更久的销售分析&#xff0c;运营团队凭经验预判需求。当爆款突然断货、促销库存积压时&#xff0c;企业才惊觉标准化BI的决策时差正成为增长瓶颈。 一…...