selenium课程第十二周

importjava.sql.*;importjava.util.HashMap;importjava.util.List;importcom.mysql.jdbc.Statement;publicclassConnectMySQL{publicstaticStringdriver="com.mysql.jdbc.Driver";privatestaticStringhost;privatestaticStringuser;privatestaticStringpwd;privatestaticConnectionconn=null;privatestaticStatementstmt=null;publicstaticvoidconnect(Stringhost,Stringuser,String{ConnectMySQL.close();ConnectMySQL.host=host;ConnectMySQL.user=user;ConnectMySQL.pwd=pwd;}sql){return}publicstaticsynchronizedvoid{tryif(stmt!={stmt.close();stmt=null;}if(conn!=null)conn=null;}}catch(SQLException{}}privatestaticvoid{try{conn=(Connection) +host+"?useUnicode=true&characterEncoding=UTF8",user, }catch(SQLException }privatestaticvoid{if(conn==null){}trystmt=(Statement)}catch(SQLExceptione)}}privatestaticResultSetresultSet(String{ResultSetrs=null;if(stmt==null){}tryrs=}catch(SQLException{}return}privatestaticList<HashMap<String,String>>result(String{ResultSetrs=ConnectMySQL.resultSet(sql);List<HashMap<String,String>>result=newArrayList<HashMap<String,tryResultSetMetaDatamd=rs.getMetaData();intcc=md.getColumnCount();while(rs.next())HashMap<String,String>columnMap=newfor(inti=1;i<=cc;}}}catch(SQLExceptione)}return}publicstaticvoidmain(String[]args)throws{ConnectMySQL .connect("/webdriver","root","");List<HashMap<String,String>>rs= .query("SELECT*from}}importjava.io.File;importjava.io.IOException;importjava.util.ArrayList;importjava.util.HashMap;importjava.util.List;importimportimportorg.apache.poi.ss.usermodel.DateUtil;importorg.apache.poi.ss.usermodel.Row;importorg.apache.poi.ss.usermodel.Sheet;importdataguru.test.selenium.*;publicclass{privateStringfilePath;privateStringsheetName;privateWorkbookworkBook;privateSheetsheet;privateList<String>columnHeaderList;privateList<List<String>>listData;privateList<Map<String,String>>mapData;privatebooleanflag;privateboolean*jar包：poi-3.8.jar,poi-ooxml.jar,excelexcel20032007+@paramfilePathexcel@paramsheetNameexcelsheetpublicExcelReader(StringfilePath,String{this.filePath=filePath;this.sheetName=sheetName;this.flag=false; *加载EXCEL文件内容，产生WorkBook对象，再产生Sheet对象 privatevoidload(){FileInputStreaminStream=null;Filefile=new{}tryinStream=newFileInputStream(newFile(filePath));workBook=WorkbookFactory.create(inStream);sheet=}catch(Exception{}}catch(IOException{}}}cellcellString@paramcellCell*privateStringgetCellValue(Cell{if(!fileExist)returnnull;StringcellValue="";DataFormatterformatter=newDataFormatter();if(cell!=null)switch{caseif{cellValue=}elsedoublevalue=cell.getNumericCellValue();intintValue=(int)value;cellValue=value-intValue==0?String.valueOf(intValue):}casecellValue=cell.getStringCellValue();casecellValue=String.valueOf(cell.getBooleanCellValue());casecellValue=String.valueOf(cell.getCellFormula());cellValue="";cellValue="";cellValue=cell.toString().trim();}}returncellValue.trim();值mapDatalist,listmap,mapkeyprivatevoid{if(!fileExist)listData=newArrayList<List<String>>();mapData=newArrayList<Map<String,String>>();columnHeaderList=newArrayList<String>();intnumOfRows=sheet.getLastRowNum()+1;for(inti=0;i<numOfRows;i++){Rowrow=Map<String,String>map=newHashMap<String,String>();List<String>list=newArrayList<String>();if(row!=null)for(intj=0;j<row.getLastCellNum();{Cellcell=row.getCell(j);if(i==0){}}}}if(i0){}}flag=}indexcell@paramrow1@paramcol1publicStringgetCellData(introw,intcol){if(!fileExist)returnnull;if(row<=0||col<=0){return}}if(listData.size()>=row&&listData.get(row-1).size()>=col){returnlistData.get(row-1).get(col-1);}else{returnnull;}}@paramrow1*publicStringgetCellData(introw,StringheaderName){if(!fileExist)returnnull; returnnull;}}1).containsKey(headerName)){returnmapData.get(row-}else{returnnull;}}publicList<Map<String,String>>returnmapData;}publicstaticvoidmain(String[]args)ExcelReadereh=newExcelReader( ogInfo(eh.getCellData(1,1));//Log.logInfo(eh.getCellData("sheet1",2,"test2"));for(inti=1;i<=eh.listData.size();i++){{Log.logInfo(eh.getCellData(i,}}for(int }}}packagecom.test.util;publicclassRandomUtil (count));privateStringgloblestring abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ";publicStringgetRandomString(intlength){StringBuffersb=new intlen=globlestring.length();for(inti=0;i<length;i++){ sb.append(globlestring.charAt(this.getRandom(len- returnsb.toString();}publicstaticvoidmain(String[]args) }}importjava.text.SimpleDateFormat;importjava.util.Calendar;importjava.util.Date;importjava.util.GregorianCalendar;publicclassTimeStringpublicStringvalueOfString(Stringstr,intlen){Stringstring="";for(inti=0;i<len-str.length();i++) string=string+ return(str.length()==len)?(str):(string+str);}publicStringgetTime(){returnString.valueOf(newDate().getTime());}publicStringgetSimpleDateFormat(){SimpleDateFormatsdf=newSimpleDateFormat("yyyy-MM-ddHH:mm:ss");returnsdf.format(newDate());}publicStringgetTimeString(){Calendarcalendar=new Stringyear= Stringmonth= Stringday H)),2);Stringhour= ), Stringminute Stringsecond= Stringmillisecond= returnyear+month+day+hour+minute+second+millisecond; *@param */publicstaticvoidmain(String[]{TimeStringtString=newTimeString();}}excelTestNGpackagecom.test.util;importjava.util.Map;importimportorg.openqa.selenium.WebDriver;importorg.testng.annotations.*;publicclass 2extendspublicstaticWebDriverdriver;publicvoidstartFirefox()SeleniumDriverselenium=newSeleniumDriver();driver=selenium.getDriver();}publicvoid}@Test(dataProvider="providerExcelMethod")publicvoidsetDatas(Map<String,String>map)WebElementelement=element= element=driver.findElement(B("fromDate"));}publicvoidselectType()//选择单程raidobutton WebElementelement=BooleanbselectBoolean=element.isSelected();System.out.println("单程单选框选中状态：bselectBoolean);}publicvoidsubmitSearch()WebElementelement }}packagecom.test.util;importjava.util.I importjava.util.List;importimportdataguru.test.selenium.Log;publicclass{privateMap<String,String>commonMap;ExcelReadererExcelReader;privatevoidinitialMap(String{if(erExcelReader==null){erExcelReader=newExcelReader("test-Data/"+this.getClass().getSimpleName()+".xlsx",}}private {if(commonMap==null)erExcelReader=newExcelReader("test-Data/" this.getClass().getSimpleName()+".xlsx","common");}}publicObject[][]providerExcelMethod(Method{this.initialMap(method.getName());List<Map<String,String>>mapData=erExcelReader.getSheetMapData();Object[][]objects=newObject[mapData.size()][];List<Map<String,String>>commonMapData= if(commonMapData.size()>1) Log.logWarn("commonMap1，请if(mapData!=null)for(inti=0;i<mapData.size();{Map<String,String>mergeMap=mapData.get(i);if(commonMapData!=null){for(intk=0;k<commonMapData.size();{mergeMap= }}if(ExcelGlobal.globalExcelMap!=null)for(intn=0;n<