1,写入值(30、31),更新到数据表的多条记录。
sqlStr=贝?选择column_id dcq_shop_column2, shop_id=" + db_Shop_id +”
def dbSettings=[]
def db_sub_column_id=" "
sqlResult=sql.eachRow (sqlStr)
{
dbSettings & lt; & lt;it.toRowResult (),
}
,
(i=0; i { db_sub_column_id=db_sub_column_id.toString () + dbSettings[我].column_id.toString () 如果(我& lt;dbSettings.size-1) { db_sub_column_id=db_sub_column_id + ", " } } 断言subColumnId==db_sub_column_id 2,初始化数据 进口groovy.sql。Sql //导入groovyx.net.http.ContentType log.info(“- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -测试步骤开始- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -”) /*,,,,,, *,,,,,,1、获取数据库连接参数,连接数据库 */ def tpProperties=testRunner.testCase.getProject () def tsProperties=testRunner.testCase.getTestSuite () def tcProperties=testRunner.getTestCase () def service_ip=tpProperties。getPropertyValue (YDGJ_IP) def refreshPath=tpProperties。getPropertyValue (refreshPath) def db_url=tpProperties。getPropertyValue (DB_Connection_URL) def db_user=tpProperties。getPropertyValue (DB_loginname) def db_pwd=tpProperties。getPropertyValue (DB_Password) def db_driver=tpProperties。getPropertyValue (DB_Driver_Class) def sql=Sql.newInstance (db_url、db_user db_pwd, db_driver) ,,,log.info(“- - - - - - 1,获取数据库连接参数,连接数据库完成”) ,,, /*,,,,,, *,,,,,,2、初始化数据库表 */ //开始初始化数据 def sqlStr=敖衧p_easydata_genAll () log.info(“自动生成业务数据:“+,sqlStr) sql.execute (sqlStr) log.info(“- - - - - - 2,初始化表基础数据完成”) /*,,,,,, *,,,,,,3、设置补充用例所需表数据 */ , /* def sqlStr=跋妊≡?” log.info (sqlStr) sql.execute (sqlStr); */ log.info(“- - - - - - 3,设置补充用例所需表数据完成,(请根据业务设置!)”) /*,,,,,, *,,,,,,4、设置或从数据表获取用例参数值 */ //设置数据,必填 def curTime=System.currentTimeMillis () //log.info (“curTime:”+ curTime) def shopName=皊hopName”+ curTime log.info (shopName) tcProperties.setPropertyValue (“shopName”, shopName), tcProperties。setPropertyValue(“标识”、“2916011”), tcProperties。setPropertyValue(“店主”、“店主姓名呀”), tcProperties。setPropertyValue (“provinceId”、“360000”), 3,通过设置变量,获取变量完成值传递 def tpProperties=testRunner.testCase.getProject () def tsProperties=testRunner.testCase.getTestSuite () def tcProperties=testRunner.getTestCase () def shopName=tcProperties。getPropertyValue (shopName) def userId=tcProperties。getPropertyValue (userId) =tcProperties def店主。getPropertyValue(“店主”) def provinceId=tcProperties。getPropertyValue (provinceId) 三、字符串用分裂处理成数组 log.info (“skillsCertificateNos:”+ skillsCertificateNos) string [] strAry=skillsCertificateNos.split (", "); log.info (“strAry.size ():”+ strAry.size ()) (i=0; i< strAry.size();我+ +) { sqlStr=皊elect count(*)从1 dcq_p_w_upload问,file_no=" " + strAry[我]+ " ' " log.info (sqlStr) sqlResult=sql.firstRow (sqlStr) log.info (“skillsCertificateNos,,,,,,,, sqlResult.cnt:”+ sqlResult.cnt) 断言sqlResult.cnt==1}