文章目录一、接口测试数据准备1.1 通过系统页面构造(不推荐)1.2 通过接口构造1.3 通过数据库构造【推荐】二、接口测试数据清理一、接口测试数据准备构造测试数据方式通过系统页面构造通过接口构造通过数据库构造1.1 通过系统页面构造(不推荐)优点可视化页面操作缺点操作步骤较多不适合频繁改造数据。示例参考发布借款标流程在测试接口时还没有页面也没有联调没法进行构造1.2 通过接口构造优点速度快缺点︰接口耦合度高接口之间依赖性强一个失败后面全部失败建议适合依赖3个以内接口就能构造完成。1.3 通过数据库构造【推荐】优点灵活度大执行速度最快。缺点需要熟悉库、表、字段建议︰编写SQL语句时使用复制生成的SQL语句修改主要字段值。--构造借款业务数据SQL语句示例没写全--清空操作deletefromczbk_member.mb_memberwhereid869;deletefromczbk_member.mb_member_infowhereid987;deletefromczbk_finance.fn_loan_amountwhereid987;deletefromp2p_mock.p2p_accountwhereid911;--借款deletefromczbk_finance.fn_loanwhereid642;deletefromczbk_finance.fn_loan_infowhereid832;deletefromczbk_finance.fn_loan_amount_logwhereid869;INSERTINTOczbk_member.mb_member(id,name,trust_account,password,email,phone,paypassword,count,register_ip,register_time,register_date,lastlogin_ip,lastlogin_time,lastlogin_date,register_type,role,group,group_status,is_realname,is_email,is_phone,is_video,is_id5,is_vip,credit_point,is_auto,pwd_attach,status,lock_time,vip_category_ind,vip_start_time,vip_end_time,vip_category_id,amount,phonestr)VALUES(869,13099775533,6021234507160403,eab70f4a46c640b3dfc35040bf37c803,NULL,13099775533,NOLL,1,1972826569,1588835827,2020-85-07,1972826569,1588835827,2020-05-07,1, 1,1,2,1,-1,1,-1,-1,-1,0,-1,1m4U82PqPx,1,NULL,NULL,NULL,NULL,NULL,0.00,NULL);二、接口测试数据清理# 一、确定查询语句--1、 mb_member_info(信息表)表中查询指定手机号数据select*frommb_memberasmbinnerjoinmb_member_infoasinfooninfo.member_idmb.idwheremb.phonein(13600001111,13600001112,13600001113,13600001114);--2、mb_member_login_log(登录日志)表查询指定手机号数据select*frommb_memberasmbinnerjoinmb_member_login_logasloginonlogin.member_idmb.idwheremb.phonein(13600001111,13600001112,13600001113,13600001114);--3、mb_member(会员主表)表查询指定手机号数据select*frommb_memberwherephonein(13600001111,13600001112,13600001113,13600001114);--4、mb_member_register_log(注册日志)表查询指定手机号数据select*frommb_member_register_logwherephonein(13600001111,13600001112,13600001113,13600001114);# 二、确定删除语句--1、 mb_member_info(信息表)表中查询指定手机号数据deleteinfo.*frommb_memberasmbinnerjoinmb_member_infoasinfooninfo.member_idmb.idwheremb.phonein(13600001111,13600001112,13600001113,13600001114);--2、mb_member_login_log(登录日志)表查询指定手机号数据deletelogin.*frommb_memberasmbinnerjoinmb_member_login_logasloginonlogin.member_idmb.idwheremb.phonein(13600001111,13600001112,13600001113,13600001114);--3、mb_member(会员主表)表查询指定手机号数据deletefrommb_memberwherephonein(13600001111,13600001112,13600001113,13600001114);--4、mb_member_register_log(注册日志)表查询指定手机号数据deletefrommb_member_register_logwherephonein(13600001111,13600001112,13600001113,13600001114);