package cn.iszt.test.suit;
import static org.testng.Assert.assertEquals;
import java.io.InputStream;
import java.util.Properties;
import java.util.concurrent.TimeUnit;
import java.io.File;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import org.openqa.selenium.*;
import org.openqa.selenium.chrome.ChromeDriver;
import cn.iszt.test.model.ResultModel;
public abstract class load {
protected ChromeDriver driver;
private static String baseUrl;
private static String driverUrl;
private static String reportUrl;
protected static String X;
public void getUp(ResultModel result) throws Exception {
// 获取地址及帐号信息 +登录
Properties prop = new Properties();
InputStream in = Object.class.getResourceAsStream("/config.properties");
prop.load(in);
baseUrl = prop.getProperty("WebUrl1").trim();
driverUrl = prop.getProperty("driverUrl").trim();
System.setProperty("webdriver.chrome.driver", driverUrl);
driver = new ChromeDriver();
driver.manage().timeouts().implicitlyWait(30, TimeUnit.SECONDS);
driver.get(baseUrl);
driver.findElement(By.id("username")).clear();
driver.findElement(By.id("username")).sendKeys(result.getuserName());
driver.findElement(By.id("password")).clear();
driver.findElement(By.id("password")).sendKeys(result.getuserPwd());
driver.findElement(By.id("verifyCode")).clear();
driver.findElement(By.id("verifyCode")).sendKeys("****");
driver.findElement(By.id("btn-submit")).click();
assertEquals(driver.getTitle(), "运营管理平台");
driver.manage().timeouts().implicitlyWait(30, TimeUnit.SECONDS);
}
public static String getDriverUrl() {
return driverUrl;
}
public static void setDriverUrl(String driverUrl) {
load.driverUrl = driverUrl;
}
public void close(ResultModel result) throws Exception {
System.out.println("111"+result.getsheetname());
System.out.println("AAA"+result.getSuitname());
System.out.println("BBB"+result.getResultC());
System.out.println("CCC"+result.getStarttime());
System.out.println("DDD"+result.getEndtime());
Properties prop = new Properties();
InputStream in = Object.class.getResourceAsStream("/config.properties");
prop.load(in);
reportUrl = prop.getProperty("reportUrl").trim();
System.out.println("getname"+result.getSuitname());
Workbook wb = Workbook.getWorkbook(new File(reportUrl));
WritableWorkbook book = Workbook
.createWorkbook(new File(reportUrl), wb);
WritableSheet sheet = book.getSheet(result.getsheetname());
sheet.addCell(new Label(3, result.getX(), result.getSuitname()));
sheet.addCell(new Label(4, result.getX(), result.getResultC()));
sheet.addCell(new Label(5, result.getX(), result.getStarttime()));
sheet.addCell(new Label(6, result.getX(), result.getEndtime()));
book.write();
book.close();
driver.quit();
}
}
import static org.testng.Assert.assertEquals;
import java.io.InputStream;
import java.util.Properties;
import java.util.concurrent.TimeUnit;
import java.io.File;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import org.openqa.selenium.*;
import org.openqa.selenium.chrome.ChromeDriver;
import cn.iszt.test.model.ResultModel;
public abstract class load {
protected ChromeDriver driver;
private static String baseUrl;
private static String driverUrl;
private static String reportUrl;
protected static String X;
public void getUp(ResultModel result) throws Exception {
// 获取地址及帐号信息 +登录
Properties prop = new Properties();
InputStream in = Object.class.getResourceAsStream("/config.properties");
prop.load(in);
baseUrl = prop.getProperty("WebUrl1").trim();
driverUrl = prop.getProperty("driverUrl").trim();
System.setProperty("webdriver.chrome.driver", driverUrl);
driver = new ChromeDriver();
driver.manage().timeouts().implicitlyWait(30, TimeUnit.SECONDS);
driver.get(baseUrl);
driver.findElement(By.id("username")).clear();
driver.findElement(By.id("username")).sendKeys(result.getuserName());
driver.findElement(By.id("password")).clear();
driver.findElement(By.id("password")).sendKeys(result.getuserPwd());
driver.findElement(By.id("verifyCode")).clear();
driver.findElement(By.id("verifyCode")).sendKeys("****");
driver.findElement(By.id("btn-submit")).click();
assertEquals(driver.getTitle(), "运营管理平台");
driver.manage().timeouts().implicitlyWait(30, TimeUnit.SECONDS);
}
public static String getDriverUrl() {
return driverUrl;
}
public static void setDriverUrl(String driverUrl) {
load.driverUrl = driverUrl;
}
public void close(ResultModel result) throws Exception {
System.out.println("111"+result.getsheetname());
System.out.println("AAA"+result.getSuitname());
System.out.println("BBB"+result.getResultC());
System.out.println("CCC"+result.getStarttime());
System.out.println("DDD"+result.getEndtime());
Properties prop = new Properties();
InputStream in = Object.class.getResourceAsStream("/config.properties");
prop.load(in);
reportUrl = prop.getProperty("reportUrl").trim();
System.out.println("getname"+result.getSuitname());
Workbook wb = Workbook.getWorkbook(new File(reportUrl));
WritableWorkbook book = Workbook
.createWorkbook(new File(reportUrl), wb);
WritableSheet sheet = book.getSheet(result.getsheetname());
sheet.addCell(new Label(3, result.getX(), result.getSuitname()));
sheet.addCell(new Label(4, result.getX(), result.getResultC()));
sheet.addCell(new Label(5, result.getX(), result.getStarttime()));
sheet.addCell(new Label(6, result.getX(), result.getEndtime()));
book.write();
book.close();
driver.quit();
}
}