import java.util.Set;import org.openqa.selenium.Alert;import org.openqa.selenium.By;import org.openqa.selenium.NoAlertPresentException;import org.openqa.selenium.WebDriver;import org.openqa.selenium.WebDriverException;import org.openqa.selenium.ie.InternetExplorerDriver; public class AlertOperate {    static WebDriver dr = new InternetExplorerDriver();     public static void main(String args[]) throws InterruptedException{        dr.get("www.baidu.com");         dr.findElement(By.id("lb")).click();         try {            Thread.sleep(2000);        } catch (InterruptedException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }         tanchukuang();    }      //处理潜在的1个alert（javascript弹出框）    public boolean dealPotentialAlert(WebDriver driver,boolean option) {        boolean flag = false;        try {            Alert alert = driver.switchTo().alert();            if (null == alert)                throw new NoAlertPresentException();            try {                if (option) {                    alert.accept();                    System.out.println("Accept the alert: " + alert.getText());                } else {                    alert.dismiss();                    System.out.println("Dismiss the alert: " + alert.getText());                }                flag = true;            } catch (WebDriverException ex) {                if (ex.getMessage().startsWith("Could not find"))                    System.out.println("There is no alert appear!");                else                    throw ex;            }        } catch (NoAlertPresentException e) {            System.out.println("There is no alert appear!");        }        return flag;    }     //处理非JS弹窗    public static boolean testNewWindow(){        //当前窗口句柄         String currentHandle = dr.getWindowHandle();        //得到所有窗口的句柄         Set<String> handles = dr.getWindowHandles();         handles.remove(currentHandle);         if (handles.size() > 0) {             try{                 dr.switchTo().window(handles.iterator().next());                 //dr.switchTo().window(dr.getWindowHandles().iterator().next());                 return true;             }catch(Exception e){                 System.out.println(e.getMessage());                 return false;             }         }         System.out.println("Did not find window");         return false;    }     //一般弹出窗口    public static void tanchukuang() throws InterruptedException{        //得到所有窗口        Set<String> allWindowsId = dr.getWindowHandles();        //通过查找页面内容得到新的窗口        for(String windowId : allWindowsId){            dr.switchTo().window(windowId);            Thread.sleep(1000);            dr.findElement(By.id("TANGRAM__PSP_10__userName")).sendKeys("test");             //第一个按钮是确定按钮            //dr.findElement(By.xpath("//button[@type=‘button‘]")).click();            //System.out.println(dr.switchTo().window(windowId).getTitle());            break;        }    } }

public class Chanage {    //int to String    public static String IntToString(int i){        String s = Integer.toString(i);        return s;    }     //String to int    public static int StringToInt(String s){        int i = Integer.parseInt(s);        return i;    }}

import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement; import com.mysql.jdbc.Connection; class ConnMySQL {    Connection conn;    Statement stmt;    ResultSet rs1;    int rs2;     public void connection() throws Exception{        String db = "meeting";        String driver = "com.mysql.jdbc.Driver";        String url = "jdbc:mysql://172.16.3.9:3306/"+db;        String uname = "admin";        String pwd = "itserver";         //加载驱动        Class.forName(driver);        //连接数据库        conn = (Connection) DriverManager.getConnection(url, uname, pwd);         if(!conn.isClosed()){            //System.out.println("连接成功!");        }    }      //执行查询操作返回ResultSet类型    public void  executeSql0(String sql) throws SQLException{         //创建语句对象，用来执行sql语句        stmt = conn.createStatement();        //执行sql        rs1 = stmt.executeQuery(sql);         while(rs1.next()){            String name = rs1.getString("meetingId");            String subject = rs1.getString("e164");            String regionName = rs1.getString("state");            System.out.println(name+" "+subject+" "+regionName);        }        rs1.close();    }     //执行查询操作返回ResultSet类型    public void  executeSql1(String sql) throws SQLException{         //创建语句对象，用来执行sql语句        stmt = conn.createStatement();        //执行sql        rs1 = stmt.executeQuery(sql);         while(rs1.next()){            String id = rs1.getString("id");            String subject = rs1.getString("subject");            String startTime = rs1.getString("startTime");            String endTime = rs1.getString("endTime");            String organiger = rs1.getString("organiger");            String status = rs1.getString("status");            System.out.println(id+" "+subject+" "+startTime+" "+endTime+" "+organiger+" "+status);        }        rs1.close();        conn.close();    }      //执行增删改操作返回int类型    public void executeSql2(String sql) throws SQLException{        stmt = conn.createStatement();        rs2 = stmt.executeUpdate(sql);         stmt.close();        conn.close();    }}

// 生成Excel的类 import  java.io.File; import  jxl.Workbook;import  jxl.write.Label;import  jxl.write.WritableSheet;import  jxl.write.WritableWorkbook; public class CreateExcel{    public static void main(String args[]){        //Create_Excel c_e = new Create_Excel();        //c_e.createexcel();        //System.out.printf("success!!");   }} class Create_Excel{    public void createexcel(){        try{            //  打开文件             WritableWorkbook book = Workbook.createWorkbook(new File("test.xls"));            //  生成名为“第一页”的工作表，参数0表示这是第一页             WritableSheet sheet = book.createSheet("第一页",0);            //  在Label对象的构造子中指名单元格位置是第一列第一行(0,0)            //  以及单元格内容为test             Label label1 = new  Label(0,0,"test");            Label label2 = new  Label(1,1,"test");             //  将定义好的单元格添加到工作表中             sheet.addCell(label1);            sheet.addCell(label2);            /*             * 生成一个保存数字的单元格 必须使用Number的完整包路径，否则有语法歧义 单元格位置是第二列，第一行，值为555            */            jxl.write.Number number = new jxl.write.Number(1,0,555);           sheet.addCell(number);             //  写入数据并关闭文件            book.write();           book.close();        }catch(Exception e){           System.out.println(e);       }    }}

// 读取Excel的类 import  java.io.File; import  jxl.Cell;import  jxl.Sheet;import  jxl.Workbook; /* * 参数1:第几个工作表 * 参数2:第几列 * 参数3:第几行 * 参数都从0开始 * 返回值:当前单元格的数据 */public class ReadExcel{    static String result;    static Workbook book;    static Sheet sheet;    public static void main(String args[]){        //readExcel(0,1,0);        excelNum(0);    }    public static String readExcel(int no,int row,int line){        try{            book = Workbook.getWorkbook(new File("test.xls"));            //  获得第一个工作表对象             sheet = book.getSheet(no);            //  得到第一列第一行的单元格             Cell cell1 = sheet.getCell(row,line);            result = cell1.getContents();            System.out.println(result);            book.close();         }catch(Exception e){            System.out.println(e);         }        return result;    }     //返回行数    public static int excelNum(int no){        int col = 0;        int row = 0;        try{            book = Workbook.getWorkbook(new File("test.xls"));            sheet = book.getSheet(no);            //得到行数和列数            col = sheet.getColumns();    //列数            row = sheet.getRows();        //行数            System.out.println(col+" 列");            System.out.println(row+" 行");            book.close();        }catch(Exception e){            System.out.println(e);        }        return row;    }}

import  java.io.File;import  jxl.Workbook;import  jxl.write.Label;import  jxl.write.WritableSheet;import  jxl.write.WritableWorkbook; public class UpdateExcel{    public static void main(String args[]){        try{            //  Excel获得文件             Workbook wb = Workbook.getWorkbook(new File("test.xls"));            //  打开一个文件的副本，并且指定数据写回到原文件             WritableWorkbook book = Workbook.createWorkbook(new File("test.xls"),wb);            //  添加一个工作表             WritableSheet sheet = book.createSheet("第二页",1);            sheet.addCell(new Label(0,0,"第二页的测试数据"));            book.write();            book.close();        }catch(Exception e){            System.out.println(e);        }    } }

import java.util.concurrent.TimeUnit; import org.openqa.selenium.By;import org.openqa.selenium.NoSuchElementException;import org.openqa.selenium.WebDriver;import org.openqa.selenium.WebElement;import org.openqa.selenium.ie.InternetExplorerDriver; /* * 判断一个元素是否存在 */public class ElementIsExsit {    //查找一个元素是否存在    public boolean isElementExsit(WebDriver driver, By locator) {        boolean flag = false;        try {            WebElement element=driver.findElement(locator);            //flag = true;            flag=null!=element;            System.out.println("元素: " + locator.toString()+ " 存在!");        }catch(NoSuchElementException e) {            System.out.println("元素: " + locator.toString()+ " 不存在!");            flag = false;        }        return flag;    }     //如何使用上面的方法    public void test(){        WebDriver driver = new InternetExplorerDriver();         //显性等待        driver.manage().timeouts().implicitlyWait(5, TimeUnit.SECONDS);         By locator = By.id("id");        isElementExsit(driver,locator);    }}

import java.io.File;import java.io.FileOutputStream;import java.io.IOException;import java.io.InputStream;import java.io.UnsupportedEncodingException;import java.net.URI;import java.net.URISyntaxException;import java.util.ArrayList;import java.util.Date;import java.util.List; import org.apache.http.HttpEntity;import org.apache.http.HttpResponse;import org.apache.http.NameValuePair;import org.apache.http.client.ClientProtocolException;import org.apache.http.client.HttpClient;import org.apache.http.client.entity.UrlEncodedFormEntity;import org.apache.http.client.methods.HttpGet;import org.apache.http.impl.client.DefaultHttpClient;import org.apache.http.message.BasicNameValuePair;import org.apache.http.util.EntityUtils; import com.sun.org.apache.xerces.internal.impl.xpath.regex.ParseException; public class Movision_verifyImage {private static HttpClient hc = new DefaultHttpClient();      public static void main(String args[]) throws ClientProtocolException, IOException, ParseException, URISyntaxException{         //获取图片验证码页面随机参数（当前时间）        long date = new Date().getTime();        System.out.println(date);         List<NameValuePair> params = new ArrayList<NameValuePair>();        params.add(new BasicNameValuePair("random",Long.toString(date)));        get("http://172.16.3.6/admin/portalVerifyImage",params);     }     /*     * 带参数的GET请求     *      */    public static void get(String url,List<NameValuePair> params) throws ParseException, UnsupportedEncodingException, IOException, URISyntaxException{        //get请求        HttpGet httpget = new HttpGet(url);        //设置参数        String str = EntityUtils.toString(new UrlEncodedFormEntity(params));        httpget.setURI(new URI(httpget.getURI().toString()+"?"+str));         //发送请求        HttpResponse re = hc.execute(httpget);         //获取相应实体        HttpEntity entity = re.getEntity();         if (entity != null && entity.isStreaming()) {            File storeFile = new File("F:\\test.jpg");            FileOutputStream fos = new FileOutputStream(storeFile);             // 将取得的文件文件流写入目标文件            InputStream is = entity.getContent();            byte[] b = new byte[1024];            int j = 0;             while ((j = is.read(b)) != -1) {               fos.write(b, 0, j);            }            fos.flush();            fos.close();         } else {            System.out.println("[" + url + "] 未找到.");            return;         }         //关闭连接        hc.getConnectionManager().shutdown();    }}

import java.io.BufferedReader;import java.io.FileWriter;import java.io.InputStream;import java.io.InputStreamReader; import ch.ethz.ssh2.Connection;import ch.ethz.ssh2.Session;import ch.ethz.ssh2.StreamGobbler;  /* * 远程调用linux下的vmstat命令,并将结果完整写入文件中 */public class SSHTest {    /**     * @param args     * @throws IOException     */    /*     * 主机地址、端口、用户名、密码     */    static String hostName = "172.16.3.9";    static int port = 2222;    static String userName = "root";    static String pwd = "kedats";      public static void main(String[] args) throws Exception {        // TODO Auto-generated method stub        System.out.println("开始连接主机");        Connection conn = new Connection(hostName, port);        conn.connect();        boolean isdenglu = conn.authenticateWithPassword(userName, pwd);        if (isdenglu) {            System.out.println("ssh2登陆成功");        } else {            System.out.println("登陆失败");        }         //System.out.println("当前目录：");         Session ses = conn.openSession();        ses.execCommand("vmstat 2");        InputStream stdout = new StreamGobbler(ses.getStdout());        BufferedReader br = new BufferedReader(new InputStreamReader(stdout));         FileWriter fw = new FileWriter("F:\\vmstat.txt");         while (true)              {                  String line = br.readLine();                  if (line == null)                      break;            System.out.println(line);             fw.write(line+"\r\n",0,line.length()+2);            fw.flush(); //            OutputStreamWriter osw = new OutputStreamWriter(new FileOutputStream("data2.txt"));//            osw.write(line,0,line.length());//            osw.flush();//            PrintWriter pw = new PrintWriter(new OutputStreamWriter(new FileOutputStream("hello3.txt")),true);//            pw.println(line);         }         System.out.println("运行结果："+ses.getExitStatus());         //关闭文件        fw.close();         ses.close();        conn.close();    } }

import java.io.File;import java.io.FileWriter;import java.io.IOException;import java.util.Calendar;import java.util.Date;import java.util.GregorianCalendar; public class ToLog {     static GregorianCalendar time = new GregorianCalendar();//    int year = time.get(Calendar.YEAR);                    //得到日期的年份//    int day = time.get(Calendar.DAY_OF_MONTH);            //得到日期的天//    int month = time.get(Calendar.MONTH)+1;                //得到日期的月份//    int weekDay = time.get(Calendar.DAY_OF_WEEK);        //得到日期为星期几//    int weekOfYear = time.get(Calendar.WEEK_OF_YEAR);    //得到日期为年的第几周//    int weekOfMonth = time.get(Calendar.WEEK_OF_MONTH);    //得到日期为月的第几周     private static final String getToday = time.get(Calendar.YEAR)+"-"+(time.get(Calendar.MONTH)+1)+"-"+time.get(Calendar.DAY_OF_MONTH)+"-";     private static final String filePath = "C:\\Documents and Settings\\Administrator\\workspace\\Movision_script\\logs\\"+getToday+"log.html";     //写入文件    public void toLog(String message){        StackTraceElement stack[] = (new Throwable()).getStackTrace();        StackTraceElement s = stack[1];         String headerMessage = s.getClassName()+"."+s.getMethodName()+"()"+"★LineNum:"+s.getLineNumber()+"<br />★Message:&nbsp;&nbsp;&nbsp;&nbsp;";         headerMessage = addDateTimeHeader(headerMessage);        message = headerMessage + message + "<br />========================================================================================================================<br /><br />";         FileWriter fw = null;        File file = null;         try{            file = new File(filePath);            fw = new FileWriter(file,true);            fw.write(message);        }catch(IOException ie){            ie.printStackTrace();        }finally{            try{                fw.close();            }catch(IOException ie){                ie.printStackTrace();            }        }    }     @SuppressWarnings("deprecation")    public String addDateTimeHeader(String headerMessage) {        String dateTimeHeader = new Date().toLocaleString()+"★";        return dateTimeHeader += headerMessage;    }  //    public static void main(String args[]){//        ToLog log = new ToLog();//        String message = "这只是测试";//        log.toLog(message);//    }}