checkDatabase
2018/3/23 16:06:46
命令含義:校驗(yàn)數(shù)據(jù)庫。
命令參數(shù):六個參數(shù),第一個參數(shù)輸入數(shù)據(jù)庫類型,第二個參數(shù)輸入數(shù)據(jù)庫地址,第三個參數(shù)輸入數(shù)據(jù)庫訪問用戶名,第四個參數(shù)輸入數(shù)據(jù)庫訪問密碼,第五個參數(shù)輸入數(shù)據(jù)庫查詢語句,第六個參數(shù)輸入校驗(yàn)期望值。
命令產(chǎn)生:手工添加。
命令返回:校驗(yàn)成功返回true,否則返回false
命令舉例:
例1,校驗(yàn)單個字符串返回值
pr.checkDatabase("SQL Server", "192.168.1.50:12345/mydb", "spasvo", "123", "SELECT name FROM students WHERE id=45", "Zhang san");
例2,校驗(yàn)數(shù)組形式的返回值
String [] strExpect = {"Zhang san", "男", "18"};
pr.checkDatabase("SQL Server", "192.168.1.50:12345/mydb", "spasvo", "123", "SELECT name, sex, age FROM students WHERE id=45", strExpect);
例3,校驗(yàn)二維表形式的返回值
String [][] strExpect = {{"Zhang san", "男", "18"}, {"Li si", "男", "20"}};
pr.checkDatabase("SQL Server", "192.168.1.50:12345/mydb", "spasvo", "123", "SELECT name, sex, age FROM students WHERE id > 45 AND id < 50", strExpect);
相關(guān)命令:getDatabase(See 1.4.10)


sales@spasvo.com