suit案例

package cn.iszt.test.suit;


import java.io.InputStream;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.Properties;
import java.util.Set;


import org.openqa.selenium.By;
import org.openqa.selenium.JavascriptExecutor;
import org.openqa.selenium.WebElement;
import org.openqa.selenium.chrome.ChromeDriver;
import org.openqa.selenium.support.ui.Select;


import cn.iszt.test.services.*;
import cn.iszt.test.model.*;


public class CouponAdd extends JDBCMySQL {





private static String resultA;
private static String resultB;
private  String resultC;
public ResultModel testReport(ChromeDriver driver, String starttime) throws Exception {
//重置测试数据
Properties prop = new Properties();
InputStream in = Object.class.getResourceAsStream("/mysql.properties");
prop.load(in);
String DBURL =    prop.getProperty("jdbc.url3").trim();
String USERNAME = prop.getProperty("jdbc.username").trim();
String PASSWORD = prop.getProperty("jdbc.password").trim();
InputStream in1 = Object.class.getResourceAsStream("/data.properties");
prop.load(in1);
String sql =    prop.getProperty("sql12").trim();
sql = new String(sql.getBytes("ISO8859-1"), "UTF-8");


SqlModel sqlmodel = new SqlModel();
sqlmodel.setDBURL(DBURL);
sqlmodel.setUSERNAME(USERNAME);
sqlmodel.setPASSWORD(PASSWORD);
sqlmodel.setsql(sql);
          this.sqlcon(sqlmodel);


DateFormat date = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
starttime = date.format(new Date());
// 测试步骤1：点击菜单 
driver.findElement(By.id("srl_300")).click();
Thread.sleep(1000);
   //测试步骤2：点击菜单 
driver.findElementById("srl_89").click();
Thread.sleep(1000);
//测试步骤3：
driver.findElementById("srl_90").click();

driver.switchTo().frame(0).findElement(By.id("couponName_q")).clear();

JavascriptExecutor js = (JavascriptExecutor) driver;
js.executeScript("addCouponClick()");

       Thread.sleep(1000);
       
           driver.findElement(By.id("couponName")).clear();
           driver.findElement(By.id("couponName")).sendKeys("自动化新增优惠券");
           
           driver.findElement(By.id("couponType")).click();
           driver.findElement(By.id("couponDesc")).clear();
           driver.findElement(By.id("couponDesc")).sendKeys("自动化");
           
           driver.findElement(By.id("issueNum")).clear();
           driver.findElement(By.id("issueNum")).sendKeys("10");
           
           driver.findElement(By.id("issueAmt")).clear();
           driver.findElement(By.id("issueAmt")).sendKeys("5");
           
           driver.findElement(By.xpath("//tr[6]/td[2]/span/input")).clear();  
           driver.findElement(By.xpath("//tr[6]/td[2]/span/input")).sendKeys("2016-05-01");
           
           driver.findElement(By.xpath("//tr[6]/td[2]/span[2]/input")).clear();
           driver.findElement(By.xpath("//tr[6]/td[2]/span[2]/input")).sendKeys("2020-05-18");
           Thread.sleep(1000);
        
       WebElement Action1 = driver.findElement(By.xpath("//div[9]/div[3]/a/span"));
       ((JavascriptExecutor)driver).executeScript("arguments[0].click();", Action1);
       Thread.sleep(1000);

       
       resultA = driver.findElement(By.xpath("//div[12]/div[2]")).getText();
       resultB = "新增成功";


       WebElement Action2 = driver.findElement(By.xpath("//div[12]/div[2]/div[4]/a"));
       ((JavascriptExecutor)driver).executeScript("arguments[0].click();", Action2);
       
       if(resultA.contains(resultB)){
        resultC = "pass";
       
       }else{
        resultC = "false";
       }
       

DateFormat date1 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");


String endtime = date1.format(new Date());
String suitname = "CouponAddTest";
String sheetname = "鹏淘";
int X = 21;
ResultModel result = new ResultModel();
 


result.setEndtime(endtime);
result.setStarttime(starttime);
result.setResultC(resultC);
result.setSuitname(suitname);
result.setsheetname(sheetname);
result.setX(X);
return result;

}
}