Xpath
import com.thoughtworks.selenium.DefaultSelenium;
public class Xpath {
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
DefaultSelenium selenium = new DefaultSelenium("localhost", 6666,
"*iehta", "http://");
selenium.start();
selenium.open("http://mail.in.com");
selenium.windowMaximize();
selenium.type("xpath=/html/body/div[1]/div[2]/div/table/tbody/tr[2]/td[3]/form/div/div[1]/p[3]/input[@id='f_id']","username");
selenium.type("xpath=/html/body/div[1]/div[2]/div/table/tbody/tr[2]/td[3]/form/div/div[1]/p[5]/input[@id='f_pwd']","password");
}
}
2. Validation:
import com.thoughtworks.selenium.DefaultSelenium;
public class Validation {
public static DefaultSelenium selenium=new DefaultSelenium("localhost",6666,"*iehta","http://");
public static String Bodytext()
{
selenium.start();
selenium.open("http://google.com");
selenium.windowMaximize();
  
if(selenium.isTextPresent("Nag"))
{
System.out.println("Already checked");
}
else{
selenium.select("", "label=one");
//selenium.type("q", "selenium");
selenium.check("chkbox");
  
//System.out.println("Alert is not available");
}
  
selenium.click("btnG");
return "pass";
}
public static void main(String[] args) {
// TODO Auto-generated method stub
Bodytext();
}
}
3. Test DB
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class testdb {
public static Connection connection;
public static Statement statement;
public static ResultSet resultSet;
public static void main(String[] args) {
// TODO Auto-generated method stub
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
connection = DriverManager.getConnection(
"jdbc:sqlserver://servername;instance=SQLEXPRESS;databaseName=ccdata;","Username", "Password");
statement = connection.createStatement();
resultSet = statement.executeQuery("select * from emp");
while (resultSet.next()) {
System.out.println("EMPLOYEE NAME:" + resultSet.getString("emp name"));
System.out.println("EMPLOYEE ID:" + resultSet.getString("emp ID"));
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
   
   
  
  
  
  
  
  
  
  
         
   
  
  
                 
        
  
  
                               
  
  
  
  
  
  
 
  
  
  
  
  
  
  
  
  
 
  
import com.thoughtworks.selenium.DefaultSelenium;
public class Xpath {
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
DefaultSelenium selenium = new DefaultSelenium("localhost", 6666,
"*iehta", "http://");
selenium.start();
selenium.open("http://mail.in.com");
selenium.windowMaximize();
selenium.type("xpath=/html/body/div[1]/div[2]/div/table/tbody/tr[2]/td[3]/form/div/div[1]/p[3]/input[@id='f_id']","username");
selenium.type("xpath=/html/body/div[1]/div[2]/div/table/tbody/tr[2]/td[3]/form/div/div[1]/p[5]/input[@id='f_pwd']","password");
}
}
2. Validation:
import com.thoughtworks.selenium.DefaultSelenium;
public class Validation {
public static DefaultSelenium selenium=new DefaultSelenium("localhost",6666,"*iehta","http://");
public static String Bodytext()
{
selenium.start();
selenium.open("http://google.com");
selenium.windowMaximize();
if(selenium.isTextPresent("Nag"))
{
System.out.println("Already checked");
}
else{
selenium.select("", "label=one");
//selenium.type("q", "selenium");
selenium.check("chkbox");
//System.out.println("Alert is not available");
}
selenium.click("btnG");
return "pass";
}
public static void main(String[] args) {
// TODO Auto-generated method stub
Bodytext();
}
}
3. Test DB
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class testdb {
public static Connection connection;
public static Statement statement;
public static ResultSet resultSet;
public static void main(String[] args) {
// TODO Auto-generated method stub
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
connection = DriverManager.getConnection(
"jdbc:sqlserver://servername;instance=SQLEXPRESS;databaseName=ccdata;","Username", "Password");
statement = connection.createStatement();
resultSet = statement.executeQuery("select * from emp");
while (resultSet.next()) {
System.out.println("EMPLOYEE NAME:" + resultSet.getString("emp name"));
System.out.println("EMPLOYEE ID:" + resultSet.getString("emp ID"));
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
4.  TEST
import com.thoughtworks.selenium.DefaultSelenium;
public class Test {
 public static DefaultSelenium selenium = new DefaultSelenium("localhost",
   6666, "*iehta", "http://");
 public static String fun1() throws Exception
 {
  try{
   selenium.start();
   selenium.open("//google.co.in");
   Thread.sleep(30000);
   selenium.type("q", "selenium");
   selenium.click("btnG");
  }catch(Exception e)
  {
  }
  return "pass";
 }
 public static void main(String[] args) throws Exception
 {
  // TODO Auto-generated method stub
  fun1();
 }
}
5. Sync:
import com.thoughtworks.selenium.DefaultSelenium;
public class Sync {
 /**
  * @param args
  */
 public static String google() throws Exception
 {
  DefaultSelenium selenium=new DefaultSelenium("localhost",6666,"*iehta","http://");
  selenium.start();
  selenium.open("http://mail.in.com");
  selenium.windowMaximize();
  selenium.type("f_id", "seleniumforum_Nageswar");
  selenium.type("f_pwd", "selenium");
//  selenium.setTimeout("100000");
  selenium.click("//input[@value='' and @type='submit']");
  //Thread.sleep(10000);
  selenium.waitForPageToLoad("130000");
  selenium.click("link=Sign out");
  selenium.waitForPageToLoad("130000");
  selenium.chooseCancelOnNextConfirmation();
  selenium.chooseOkOnNextConfirmation();
  return "pass";
 }
 public static void main(String[] args) throws Exception{
  // TODO Auto-generated method stub
  google();
 }
}
6. Reusability
import java.io.FileInputStream;
import jxl.Sheet;
import jxl.Workbook;
import com.thoughtworks.selenium.DefaultSelenium;
public class ReusableScript {
 public static DefaultSelenium selenium = new DefaultSelenium("localhost",
   6666, "*iehta", "http://");
 public static String gmail() throws Exception {
  selenium.start();
  selenium.open("http://www.gmail.com");
  selenium.windowMaximize();
  Thread.sleep(2000);
  selenium.click("link=Create an account »");
  selenium.waitForPageToLoad("30000");
  return "pass";
 }
 public static String Register() throws Exception {
  FileInputStream fi = new FileInputStream(
    "D:\\Framework\\TestData\\Register.xls");
  Workbook w = Workbook.getWorkbook(fi);
  Sheet s = w.getSheet(0);
  for (int i = 1; i < s.getRows(); i++) {
   if (!s.getCell(3, i).getContents().equals("")) {
    if (s.getCell(2, i).getContents().contains("Text")) {
     if (selenium
       .isElementPresent(s.getCell(0, i).getContents())) {
      selenium.type(s.getCell(0, i).getContents(), s.getCell(
        3, i).getContents());
     }
    } else if (s.getCell(2, i).getContents().contains("Combo")) {
     if (selenium
       .isElementPresent(s.getCell(0, i).getContents())) {
      selenium.select(s.getCell(0, i).getContents(), "label="
        + s.getCell(3, i).getContents());
     }
    } else if (s.getCell(2, i).getContents().contains("chkbox")) {
     if (selenium
       .isElementPresent(s.getCell(0, i).getContents())) {
      selenium.click(s.getCell(0, i).getContents());
     }
    } else if (s.getCell(2, i).getContents().contains("Radio")) {
     if (selenium
       .isElementPresent(s.getCell(0, i).getContents())) {
      selenium.click(s.getCell(0, i).getContents());
     }
    }
    else if (s.getCell(2, i).getContents().contains("Button")) {
     if (selenium
       .isElementPresent(s.getCell(0, i).getContents())) {
      selenium.click(s.getCell(0, i).getContents());
     }
     }
   }
  }
  return "pass";
 }
 public static void main(String[] args) throws Exception {
  // TODO Auto-generated method stub
  gmail();
  Register();
 }
}
7. Keys Events
import java.awt.event.KeyEvent;
public class KeyEvents extends DriverScript{
 public static void main(String[] args) {
  // TODO Auto-generated method stub
  selenium.start();
  selenium.open("http://www.google.com");
  selenium.windowMaximize();
  selenium.setCursorPosition("q", "1");
     selenium.keyDownNative(Integer.toString(KeyEvent.VK_SHIFT));
     selenium.keyPressNative(String.valueOf(KeyEvent.VK_D));
     selenium.keyUpNative(Integer.toString(KeyEvent.VK_SHIFT));
     //selenium.keyDownNative(Integer.toString(KeyEvent.VK_SHIFT));
     selenium.keyPressNative(Integer.toString(KeyEvent.VK_SEMICOLON));
     selenium.keyUpNative(Integer.toString(KeyEvent.VK_SHIFT));
     selenium.keyPressNative(Integer.toString(KeyEvent.VK_SLASH)); 
     selenium.keyPressNative(String.valueOf(KeyEvent.VK_S));
     selenium.keyPressNative(String.valueOf(KeyEvent.VK_E));
     selenium.keyPressNative(String.valueOf(KeyEvent.VK_L));
     selenium.keyPressNative(String.valueOf(KeyEvent.VK_E));
     selenium.keyPressNative(String.valueOf(KeyEvent.VK_N));
 }
}
8. Get Data
import com.thoughtworks.selenium.DefaultSelenium;
public class GetData {
 public static DefaultSelenium selenium=new DefaultSelenium("localhost",6666,"*iehta","http://");
 public static String Bodytext()
 {  
  selenium.start();
  selenium.open("http://google.com");
  selenium.windowMaximize();
  selenium.type("q", "abc");
  String str=selenium.getBodyText();
  //String str=selenium.getHtmlSource();
  String link[]=selenium.getAllWindowNames();
  System.out.println("The links are"+link.length);
  System.out.println("The links are"+link[0]);
  selenium.captureScreenshot("D:\\Selenium\\page.jpg");
  return "pass";
 }
 public static String Dynamic()
 { 
  selenium.click("add1");
  String windname[]=selenium.getAllWindowNames();
  String windid[]=selenium.getAllWindowIds();
  String windtitle[]=selenium.getAllWindowTitles();
  selenium.getValue("");
  System.out.println("The window names are"+windname.length);
  selenium.selectWindow(windname[1]);
  selenium.click("ok");
  return "pass";
 }
 public static void main(String[] args) {
  // TODO Auto-generated method stub
  Bodytext();
 }
}
9. EXCEL Login
import java.io.FileInputStream;
import java.io.FileOutputStream;
import com.thoughtworks.selenium.DefaultSelenium;
import jxl.Sheet;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class Export_Login {
public static String status = "pass";
 public static String export() throws Exception {
  FileInputStream file = new FileInputStream(
    "D:\\Framework\\TestData\\login_Data.xls");
  Workbook w = Workbook.getWorkbook(file);
  Sheet s = w.getSheet(0);
  FileOutputStream fo = new FileOutputStream(
    "D:\\Framework\\Results\\Loginout.xls");
  WritableWorkbook wwb = Workbook.createWorkbook(fo);
  WritableSheet ws = wwb.createSheet("login", 0);
  String a[][] = new String[s.getRows()][s.getColumns()];
  DefaultSelenium selenium = new DefaultSelenium("localhost", 6666,
    "*iehta", "http://");
  selenium.start();
  selenium.open("http://mail.in.com");
  selenium.windowMaximize();
  for (int i = 0; i < s.getRows(); i++) {
   selenium.type("f_id", s.getCell(0, i).getContents());
   selenium.type("f_pwd", s.getCell(1, i).getContents());
   selenium.click("//input[@value='' and @type='submit']");
   Thread.sleep(10000);
   if (selenium.isElementPresent("link=Sign out")) {
    selenium.click("link=Sign out");
    Thread.sleep(6000);
    status = "Pass";
    System.out.println("if loop" + status);
   } else {
    status = "Fail";
    System.out.println("else loop" + status);
   }
   for (int j = 0; j < s.getColumns(); j++) {
    a[i][j] = s.getCell(j, i).getContents();
    Label l = new Label(j, i, a[i][j]);
    Label Res = new Label(2, 0, "Result");
    Label rs = new Label(2, i, status);
    ws.addCell(l);
    ws.addCell(Res);
    ws.addCell(rs);
    System.out.println("The contents are" + a[i][j]);
   }
   selenium.open("http://mail.in.com");
  }
  wwb.write();
  wwb.close();
  return "pass";
 }
 public static void main(String[] args) throws Exception {
  // TODO Auto-generated method stub
  export();
 }
}
10.EXCEL
import java.io.FileOutputStream;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class Export_Excel {
 public static String export() throws Exception
 {
  FileOutputStream fo=new FileOutputStream("D:\\Framework\\Results\\Result_export.xls");
  WritableWorkbook wwb=Workbook.createWorkbook(fo);
  WritableSheet ws=wwb.createSheet("Res", 0);
  Label  l=new Label(1,0,"Nagesh");
  Label l1=new Label(0,0,"Rao");
  Label l2=new Label(2,3,"Duplicate");
  Label l3=new Label(0,0,"Minq");
  ws.addCell(l);
  ws.addCell(l1);
  ws.addCell(l2);
  wwb.write();
  wwb.close();
  return "pass";
 }
 public static void main(String[] args) throws Exception {
  // TODO Auto-generated method stub
  export() ;
 }
}
11. Execute Test Case
public class Execute_Testcases {
   public static void  main(String[] args) throws Exception
     {
        DriverScript.Set_Execution_sheet("D:\\Framework\\Environment\\url.xls");
        DriverScript.Execute("D:\\Framework\\MainScript\\testcases.xls");
     }
}
12. EXcel
import java.io.FileInputStream;
import jxl.Sheet;
import jxl.Workbook;
import com.thoughtworks.selenium.DefaultSelenium;
public class Excel extends DriverScript{
 public static String login_Excel() throws Exception
 {
  //DefaultSelenium selenium=new DefaultSelenium("localhost",6666,"*iehta","http://");
  FileInputStream file=new FileInputStream("D:\\Framework\\TestData\\login_Data.xls");
  Workbook w=Workbook.getWorkbook(file);
  Sheet s=w.getSheet(0);
  FileInputStream fi=new FileInputStream("D:\\Framework\\ObjectRepository\\login_OR.xls");
  Workbook w1=Workbook.getWorkbook(fi);
  Sheet s1=w1.getSheet(0);
  //Sheet s=w.getSheet("Sheet1");
  /*selenium.start();
  selenium.open("http://mail.in.com");
  selenium.windowMaximize();
  */
 // for (int i = 1; i < s.getRows(); i++) {
   selenium.type(s1.getCell(0, 1).getContents(), s.getCell(0, 1).getContents());
   selenium.type(s1.getCell(1, 1).getContents(), s.getCell(1, 1).getContents());
   //System.out.println("the value of i"+i);
  //}
//  selenium.setTimeout("100000");
  selenium.click(s1.getCell(2, 1).getContents());
  return "pass";
 }
 public static String close()
 {
  selenium.close();
  return "pass";
 }
 public static void main(String[] args) throws Exception {
  // TODO Auto-generated method stub
  //login_Excel();
 }
}
13. Driver Script
import java.io.FileInputStream;
import java.lang.reflect.Method;
import com.thoughtworks.selenium.DefaultSelenium;
import jxl.Sheet;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class DriverScript{
        static String className = null;
        public static String urlpath=null;
        public static int rs=1;
        public static String result=null;
        public static DefaultSelenium selenium=new DefaultSelenium("localhost",6666,"*iehta","http://");
        public static boolean Set_Execution_sheet(String strPath) throws Exception
        {    
            String urlpath=strPath;    
             FileInputStream file= new FileInputStream(urlpath);
            Workbook wb=Workbook.getWorkbook(file);
            Sheet sh=wb.getSheet(0);
            selenium.start();
            selenium.open(sh.getCell(1, 1).getContents());
            selenium.windowMaximize();
            return true;
         }
       public static boolean Execute(String str) throws Exception
        {
        FileInputStream file=new FileInputStream(str);
        Workbook wb=Workbook.getWorkbook(file);
        Sheet s=wb.getSheet(0);
         for(int iRownum=1;iRownum<=s.getRows();iRownum++)
         {  
            String ScreenShotPath="D:\\Framework\\Results\\"+"screenshot"+rs +".jpg";
             try
            {
             if(!(s.getCell(5, iRownum).getContents()).contentEquals(""))
            {
                 className=s.getCell(5, iRownum).getContents();
            }
             else{
                 for(int i=iRownum;i>1;i--)
                 {
                     if(!(s.getCell(5, i).getContents()).contentEquals(""))
                     {
                         className=s.getCell(5, i).getContents();
                         break;
                     }
                 }
             }
            String functioncall = s.getCell(6, iRownum).getContents();
            int inumofparameters=0;
            Object ret = null;
            String methodName = functioncall.substring(0,functioncall.indexOf("("));
            String strparameters = functioncall.substring(functioncall.indexOf("(")+1,functioncall.indexOf(")"));
            String strparameterslist[]=strparameters.split(",");
            inumofparameters= strparameterslist.length;
            selenium.captureScreenshot(ScreenShotPath);
            if(strparameters.length()==0){
            inumofparameters=0;
                                          }                    
            Class  c = Class.forName(className);
             if(inumofparameters!=0){
                  Class cParameters[]=new Class[inumofparameters];
               for(int temp=0;temp<inumofparameters;temp++)
                 {
                 cParameters[temp]= String.class;
                 }
                 Method m = c.getMethod(methodName,cParameters );
                 Object ob = c.newInstance();
                 Object arglist[] = new Object[inumofparameters];
                for(int iparameternum=0;iparameternum<inumofparameters;iparameternum++)
                {
                arglist[iparameternum] = new String(strparameterslist[iparameternum]);
                }
                ret = m.invoke(ob,arglist);             
                }else
                 { 
                       Method m = c.getMethod(methodName,null);
                      Object ob = c.newInstance();
                       ret = m.invoke(ob,null); 
                      System.out.println("return value:"+ ret);
                 }
             rs++;
                }catch(Exception e){
                     selenium.captureScreenshot(ScreenShotPath);
                     e.printStackTrace();
                 }                     
            }             
         return true;
     }
  }
14. DOM
public class DOM extends DriverScript{
public static String click(String str)
{
 String index=selenium.getEval("var x=selenium.browserbot.getCurrentWindow().document.getElementsByTagName(\"a\");for(var i=0;i<x.length;i++){if(x[i].innerHTML.trim()=='"+str+"')i*1;}");
    selenium.getEval("var x=selenium.browserbot.getCurrentWindow().document.getElementsByTagName(\"a\");x["+ index + "].click();");
    return "pass";
}
 public static void main(String[] args) {
  // TODO Auto-generated method stub
  selenium.start();
  selenium.open("http://www.google.com");
  selenium.windowMaximize();
  click("Hindi");
 }
}
15. Current Time
import java.util.*;
public class CurrentTime{
  public static void main(String[] args){
    Calendar calendar = new GregorianCalendar();
    String am_pm;
    int hour = calendar.get(Calendar.HOUR);
    int minute = calendar.get(Calendar.MINUTE);
    int second = calendar.get(Calendar.SECOND);
    if(calendar.get(Calendar.AM_PM) == 0)
      am_pm = "AM";
    else
      am_pm = "PM";
    System.out.println("Current Time : " + hour + ":" 
+ minute + ":" + second + " " + am_pm);
  }
} 
16. Create Excel
import java.io.FileOutputStream;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class Create_Excel {
 public static String dateNow=null;
 public static void time()
 {
    Calendar currentDate = Calendar.getInstance();
    SimpleDateFormat formatter= 
    new SimpleDateFormat("yyyyMMMdd_HHmmss");
     dateNow = formatter.format(currentDate.getTime());
    System.out.println("Now the date is :=>  " + dateNow);
 }
 public static String excel() throws Exception
 {
  time();
FileOutputStream fo=new FileOutputStream("E:\\Framework\\Results\\loginRes_"+dateNow+".xls");
WritableWorkbook wwb=Workbook.createWorkbook(fo);
WritableSheet ws=wwb.createSheet("LoginResults", 0);
Label l=new Label(0,0,"Username");
Label l1=new Label(1,0,"Password");
Label l2=new Label(2,0,"Results");
ws.addCell(l);
ws.addCell(l1);
ws.addCell(l2);
wwb.write();
wwb.close();
  return "Pass";
 }
 public static void main(String[] args) throws Exception {
  // TODO Auto-generated method stub
  excel();
 }
}
17. Create Excel 1
import java.io.FileOutputStream;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class Create_Excel1 {
 public static String dateNow=null;
 public static void time()
 {
    Calendar currentDate = Calendar.getInstance();
    SimpleDateFormat formatter= 
    new SimpleDateFormat("yyyyMMMdd_HHmmss");
     dateNow = formatter.format(currentDate.getTime());
    System.out.println("Now the date is :=>  " + dateNow);
 }
public static String excel() throws Exception
{
 time();
FileOutputStream fo=new FileOutputStream("E:\\Framework\\Results\\loginres"+dateNow+".xls");
 WritableWorkbook wwb=Workbook.createWorkbook(fo);
 WritableSheet ws=wwb.createSheet("LoginResults", 0);
 Label lab=new Label(0,0,"Username");
 Label pw=new Label(1,0,"Password");
 Label rs=new Label(2,0,"Result");
 ws.addCell(lab);
 ws.addCell(pw);
 ws.addCell(rs);
 wwb.write();
 wwb.close();
 return "Pass";
}
 public static void main(String[] args) throws Exception {
  // TODO Auto-generated method stub
  excel();
 }
}
18. Data Base Script
public class DataBaseTest {
/**
* @param args
* @throws SQLException 
*/
public static void main(String[] args) throws SQLException {
// TODO Auto-generated method stub
Connection connection = null;
ResultSet objResultSet=null;
PreparedStatement objPreStmnt=null;
try {
DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver());
String url="jdbc:microsoft:sqlserver://psdbs01\\psdbs01A:1717;DatabaseName=ARROW_0_4_5_0";
connection=DriverManager.getConnection(url,"arrow_sqa","arrow_sqa");
System.out.println(">>>>>>>>>Connected>>>>>>>>");
String strQuery = "select case_id,workitemid,userid from workbasket where case_id=? and workitemid=? and userid=?"; 
//Assigning the Query 
objPreStmnt = connection.prepareStatement(strQuery);
objPreStmnt.setInt(1,2026086); 
objPreStmnt.setInt(2,2000093);
objPreStmnt.setInt(3,2000297);
objResultSet = objPreStmnt.executeQuery(); //Executing the Query
while (objResultSet.next()) { 
System.out.println(" case_id:"+objResultSet.getString("case_id"));
System.out.println(" workitemid:"+objResultSet.getString("workitemid"));
System.out.println(" userid:"+objResultSet.getString("userid"));
} 
} catch (Exception e) {
e.printStackTrace();
}finally{
objResultSet.close();
objPreStmnt.close();
connection.close();
}
}
}
19. Driver Script
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.lang.reflect.Method;
import com.thoughtworks.selenium.DefaultSelenium;
import jxl.Sheet;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class DriverScript {
      static String className = null;
      public static int rs = 1;
public static DefaultSelenium selenium = new DefaultSelenium("localhost",1212,"*firefox", "http://");
     public static boolean Set_Execution_sheet(String strPath) throws Exception {
            FileInputStream file = new FileInputStream(strPath);
            Workbook wb = Workbook.getWorkbook(file);
            Sheet sh = wb.getSheet(0);
            selenium.start();
            selenium.open(sh.getCell(1, 1).getContents());
            selenium.windowMaximize();
            return true;
      }
      public static boolean Execute(String str) throws Exception {
       //To take the data from Testcases.xls
            FileInputStream file = new FileInputStream(str);
            Workbook wb = Workbook.getWorkbook(file);
            Sheet s = wb.getSheet(0);
          //To create the out put Result file
            FileOutputStream fo=new FileOutputStream("E:\\Framework\\Results\\loginResults.xls");
            WritableWorkbook wwb=Workbook.createWorkbook(fo);
            WritableSheet ws=wwb.createSheet("LoginResults", 0);
            //Add a label 'Result'
            Label res=new Label(8,0,"Results");
            ws.addCell(res);
            //To take each row data
            for (int i = 1; i <= s.getRows(); i++) {
        try {
         if(s.getCell(7, i).getContents().equalsIgnoreCase("Yes"))
         {
          //Taking the class name from 5,i
                if (!(s.getCell(5, i).getContents()).contentEquals("")) {
                  className = s.getCell(5, i).getContents();
                 }
              //Taking the method name from 6,i
                String functioncall = s.getCell(6, i).getContents();        
                               // object declaration
                               Object ret = "Fail";
                               //Reading the method name which is available in functioncall string
                               String methodName = functioncall.substring(0, functioncall.indexOf("("));
                               //Converting the classname
                               Class c = Class.forName(className);
                               //Taking the method name from the class
                                Method m = c.getMethod(methodName, null);
                                //Creating the instance
                                Object ob = c.newInstance();
                                //Executing the method 
                               ret = m.invoke(ob, null);
                                System.out.println("return value:" + ret.toString());
                                //Capturing screen shot
                                selenium.captureScreenshot("E:\\Framework\\Results\\Result" + rs + ".jpg");
                               rs++;
                             for (int j = 0; j < s.getColumns(); j++) {
                        System.out.println(s.getCell(j, i).getContents());
                        Label data=new Label(j,i,s.getCell(j, i).getContents());
                        ws.addCell(data);
                       }
         }
                          } catch (Exception e) {
                        selenium.captureScreenshot("E:\\Framework\\Results\\Result"+ rs + ".jpg");
                  }
            }
       wwb.write();
       wwb.close();
            return true;
      }
}
20. Export Input Data
import java.io.FileInputStream;
import java.io.FileOutputStream;
import jxl.Sheet;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class ExportInputdata_Step2 {
 public static String export() throws Exception
 {
FileInputStream fi=new FileInputStream("E:\\Framework\\Testdata\\logindata.xls");
  Workbook w=Workbook.getWorkbook(fi);
  Sheet s=w.getSheet(0);
FileOutputStream fo=new FileOutputStream("E:\\Framework\\Results\\loginResults.xls");
  WritableWorkbook wwb=Workbook.createWorkbook(fo);
  WritableSheet ws=wwb.createSheet("LoginResults", 0);
  for (int i = 0; i < s.getRows(); i++) {
   for (int j = 0; j < s.getColumns(); j++) {
    System.out.println(s.getCell(j, i).getContents());
    Label data=new Label(j,i,s.getCell(j, i).getContents());
    ws.addCell(data);
   }
  }
  Label res=new Label(2,0,"Results");
  ws.addCell(res);
  wwb.write();
  wwb.close();
  return "Pass";
 }
 public static void main(String[] args) throws Exception {
  // TODO Auto-generated method stub
  export();
 }
}
21. google Link1
import com.thoughtworks.selenium.DefaultSelenium;
public class Google_link1 {
 public static DefaultSelenium selenium;
 public static String str=null;
 public static void wait(String str) throws Exception
 {
  for (int i = 0; i < 30; i++) {
   if(selenium.isElementPresent(str))
   {
    Thread.sleep(1000);
    selenium.isVisible(str);
    break;
   }
  }
 }
 public static String openURL()
 {
  selenium=new DefaultSelenium("localhost",1213,str,"http://");
  selenium.start();
  selenium.setTimeout("1000000");
  selenium.open("http://www.google.co.in/");
  selenium.windowMaximize();
  return "Pass";
 }
 public static String hindi() throws Exception
 {
  try{
   selenium.click("link=Hindi");
   wait("link=English");
   selenium.click("link=English");
   Thread.sleep(6000); 
  }catch(Exception e){e.printStackTrace();}
  return "Pass";
 }
 public static String bengali() throws Exception
 {
  selenium.click("link=Bengali");
  Thread.sleep(6000);
  selenium.click("link=English");
  Thread.sleep(6000);
  return "Pass";
 }
 public static String telugu() throws Exception
 {
  selenium.click("link=Telugu");
  Thread.sleep(6000);
  selenium.click("link=English");
  Thread.sleep(6000);
  return "Pass";
 }
 public static void main(String[] args) throws Exception {
  // TODO Auto-generated method stub
  str="*firefox";
  for (int i = 0; i < 2; i++) {
   openURL();
   hindi();
   bengali();
   telugu();
  } 
  }
}
22. Google Link2
import com.thoughtworks.selenium.DefaultSelenium;
public class Google_link2 {
 private static DefaultSelenium selenium=new DefaultSelenium("localhost",1212,"*firefox","http://");
 public static String openURL()
 {
  selenium.start();
  selenium.open("http://www.google.co.in/");
  selenium.windowMaximize();
  return "Pass";
 }
 public static String Click_link(String str) throws Exception
 {
  selenium.click("link="+str);
  Thread.sleep(6000);
  selenium.click("link=English");
  Thread.sleep(6000);
  return "Pass";
 }
 public static void main(String[] args) throws Exception {
  // TODO Auto-generated method stub
  openURL();
  Click_link("Hindi");
  Click_link("Bengali");
  Click_link("Telugu");
 }
}
23. Google Search 
import com.thoughtworks.selenium.DefaultSelenium;
public class GooglesSearch extends DriverScript{
 public static String gs()
 {
  //DefaultSelenium selenium=new DefaultSelenium("localhost",1212,"*firefox","http://");
  //selenium.start();
  //selenium.open("http://google.co.in");
  //selenium.windowMaximize();
  selenium.type("gbqfq", "Nagesh");
  selenium.click("gbqfb");
  return "Pass";
 }
}
24. JUNIT
import com.thoughtworks.selenium.*;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;
public class Junit extends SeleneseTestCase {
 @Before
 public void setUp() throws Exception {
  selenium = new DefaultSelenium("localhost", 1212, "*chrome", "http://www.mail.in.com/");
  selenium.start();
 }
 @Test
 public void testUntitled() throws Exception {
  selenium.open("/");
  selenium.windowMaximize();
  selenium.click("css=input.registernowjgfjvku");
  selenium.waitForPageToLoad("30000");
  selenium.type("id=fname", "nagesh");
  selenium.select("id=day", "label=13");
  selenium.select("id=month", "label=Mar");
  selenium.select("id=year", "label=2000");
  selenium.type("id=username", "nagesh_2000");
 }
 @After
 public void tearDown() throws Exception {
  selenium.stop();
 }
}
25. Login_OR_TD
import java.io.FileInputStream;
import jxl.Sheet;
import jxl.Workbook;
import com.thoughtworks.selenium.DefaultSelenium;
public class Login_OR_TD {
public static DefaultSelenium selenium=new DefaultSelenium("localhost",1212,"*firefox","http://");
 public static String openURL()
 {
  selenium.start();
  selenium.open("http://www.mail.in.com/");
  selenium.windowMaximize();
  return "Pass";
 }
 public static String login() throws Exception
 {
FileInputStream fi=new FileInputStream("E:\\Framework\\Testdata\\logindata.xls");
  Workbook w=Workbook.getWorkbook(fi);
  Sheet s=w.getSheet(0);
FileInputStream fi1=new FileInputStream("E:\\Framework\\Object Repository\\loginOR.xls");
        Workbook w1=Workbook.getWorkbook(fi1);
        Sheet s1=w1.getSheet("Sheet1");
  selenium.type(s1.getCell(0, 1).getContents(), s.getCell(0, 1).getContents());
  selenium.type(s1.getCell(1, 1).getContents(), s.getCell(1, 1).getContents());
  selenium.click(s1.getCell(2, 1).getContents());
  selenium.waitForPageToLoad("30000");
  return "Pass";
 }
 public static String logout()
 {
  selenium.click("link=");
  return "Pass";
 }
 public static void main(String[] args) throws Exception {
  // TODO Auto-generated method stub
  openURL();
  login();
  logout();
 }
}
26. Login Results 
import java.io.FileInputStream;
import java.io.FileOutputStream;
import com.thoughtworks.selenium.DefaultSelenium;
import jxl.Sheet;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class Login_Results_Step3 {
 public static DefaultSelenium selenium=new DefaultSelenium("localhost",1212,"*firefox","http://");
 public static String login() throws Exception
 {
  //To take data from Input file
FileInputStream fi=new FileInputStream("E:\\Framework\\Testdata\\logindata.xls");
  Workbook w=Workbook.getWorkbook(fi);
  Sheet s=w.getSheet(0);
  //To create the out put Result file
FileOutputStream fo=new FileOutputStream("E:\\Framework\\Results\\loginResults.xls");
  WritableWorkbook wwb=Workbook.createWorkbook(fo);
  WritableSheet ws=wwb.createSheet("LoginResults", 0);
  //String declaration
  String str=null;
  //Launching the application
  selenium.start();
  selenium.open("http://www.mail.in.com/");
  selenium.windowMaximize();
  for (int i = 1; i < s.getRows(); i++) {
   //To login into the application by taking data from xls 
   selenium.type("f_id", s.getCell(0, i).getContents());
   selenium.type("f_pwd", s.getCell(1, i).getContents());
   selenium.click("css=input.signin");
   selenium.waitForPageToLoad("30000");
   //Validating the Sign out link
   if(selenium.isElementPresent("link=Sign out"))
   {
   selenium.click("link=Sign out");
   Thread.sleep(3000);
   str="Pass";
   }else{
    str="Fail";
    System.out.println("Sign out is not available");
   }
   // To get the home page
   selenium.open("http://www.mail.in.com/");
   //Export the result into Result file
   Label result=new Label(2,i,str);
   ws.addCell(result);
   // To export input data into Result file
   for (int j = 0; j < s.getColumns(); j++) {
    System.out.println(s.getCell(j, i).getContents());
    Label data=new Label(j,i,s.getCell(j, i).getContents());
    ws.addCell(data);
   }
  }
  // Adding labels in the Result file
  Label un=new Label(0,0,"Username");
  Label pw=new Label(1,0,"Password");
  Label res=new Label(2,0,"Results");
  ws.addCell(un);
  ws.addCell(pw);
  ws.addCell(res);
  wwb.write();
  wwb.close();
  return "Pass";
 }
 public static void main(String[] args) throws Exception {
  // TODO Auto-generated method stub
  login();
 }
}
27. Login ReTesting
import java.io.FileInputStream;
import jxl.Sheet;
import jxl.Workbook;
import com.thoughtworks.selenium.DefaultSelenium;
public class Login_Retesting {
public static DefaultSelenium selenium=new DefaultSelenium("localhost",1212,"*firefox","http://");
 public static String openURL()
 {
  selenium.start();
  selenium.open("http://www.mail.in.com/");
  selenium.windowMaximize();
  return "Pass";
 }
 public static String login() throws Exception
 {
FileInputStream fi=new FileInputStream("E:\\Framework\\Testdata\\logindata.xls");
  Workbook w=Workbook.getWorkbook(fi);
  Sheet s=w.getSheet(0);
FileInputStream fi1=new FileInputStream("E:\\Framework\\Object Repository\\loginOR.xls");
        Workbook w1=Workbook.getWorkbook(fi1);
        Sheet s1=w1.getSheet("Sheet1");
        for (int i = 1; i < s.getRows(); i++) {
         selenium.type(s1.getCell(0, 1).getContents(), s.getCell(0, i).getContents());
         Thread.sleep(1000);
      selenium.type(s1.getCell(1, 1).getContents(), s.getCell(1, i).getContents()); 
  }
  //selenium.click(s1.getCell(2, 1).getContents());
  //selenium.waitForPageToLoad("30000");
  return "Pass";
 }
 public static String logout()
 {
  selenium.click("link=");
  return "Pass";
 }
 public static void main(String[] args) throws Exception {
  // TODO Auto-generated method stub
  openURL();
  login();
  //logout();
 }
}
28. Mail Login
public class Mail_Login extends DriverScript{
//public static DefaultSelenium selenium=new DefaultSelenium("localhost",1212,"*firefox","http://");
 public static String openURL()
 {
  /*selenium.start();
  selenium.open("http://www.mail.in.com/");
  selenium.windowMaximize();*/
  return "Pass";
 }
 public static String login()
 {
  selenium.type("f_id", "mar1selenium");
  selenium.type("f_pwd", "selenium");
  selenium.click("css=input.signin");
  selenium.waitForPageToLoad("30000");
  return "Pass";
 }
 public static String logout()
 {
  if(selenium.isElementPresent("link=Sign out"))
  {
  selenium.click("link=Sign out");
  System.out.println("Pass");
  }else{
   System.out.println("Fail");
  }
  return "Pass";
 }
 public static void main(String[] args) throws Exception {
  // TODO Auto-generated method stub
 }
}
29. Mail Reg
public class Mail_Reg extends Mail_Login{
 public static String reg() throws Exception
 {
  selenium.click("css=input.registernow");
  selenium.waitForPageToLoad("30000");
  selenium.type("fname", "Nagesh");
  selenium.select("day", "5");
  selenium.select("month", "Apr");
  selenium.select("id=year", "label=2001");
  selenium.type("id=username", "nagesh2001");
  selenium.type("id=password", "nagesh123");
  selenium.type("id=repassword", "nagesh123");
  selenium.type("id=altemail", "nag@gmail.com");
  selenium.click("id=imageField");
  Thread.sleep(2000);
  selenium.click("id=imageField");
  selenium.select("mcountry", "India");
  return "Pass";
 }
 public static void main(String[] args) throws Exception {
  // TODO Auto-generated method stub
  openURL();
  reg();
 }
}
30. Spice Jet popup
import com.thoughtworks.selenium.DefaultSelenium;
public class Spicejet_Popup {
 public static DefaultSelenium selenium=new DefaultSelenium("localhost",1234,"*firefox","http://");
 public static void main(String[] args) throws Exception {
  // TODO Auto-generated method stub
  selenium.start();
  selenium.open("http://spicejet.com");
  selenium.windowMaximize();
  selenium.click("id=oneWayRadio");
  selenium.select("id=from1Select", "label=Hyderabad");
  selenium.select("id=to1Select", "label=Vizag");
  selenium.click("css=#to1Select > option[value=\"VTZ\"]");
  selenium.click("id=departDate1text");
  selenium.click("link=5");
  selenium.click("id=submitBtn");
  selenium.getConfirmation();
  Thread.sleep(10000);
  selenium.click("id=m1f1r1");
  selenium.click("id=converterButton");
  selenium.waitForPopUp("converter", "30000");
  selenium.selectWindow("name=converter");
  selenium.type("id=amountText", "100");
  selenium.select("name=convert_from", "label=US Dollar (USD)");
  selenium.select("name=convert_to", "label=Indian Rupee (INR)");
  Thread.sleep(2000);
  selenium.click("id=closeButton");
  Thread.sleep(2000);
  //selenium.waitForPageToLoad("30000");
  selenium.selectWindow("null");
  selenium.click("id=nextDayButton1");
  selenium.waitForPageToLoad("30000");
 }
}
31. Step 2
import java.io.FileInputStream;
import java.io.FileOutputStream;
import jxl.Sheet;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class Step2 {
public static String export() throws Exception
{
 FileInputStream fi=new FileInputStream("E:\\Framework\\Testdata\\logindata.xls");
 Workbook w=Workbook.getWorkbook(fi);
 Sheet s=w.getSheet(0);
 FileOutputStream fo=new FileOutputStream("E:\\Framework\\Results\\loginresults.xls");
 WritableWorkbook wwb=Workbook.createWorkbook(fo);
 WritableSheet ws=wwb.createSheet("LoginResults", 0);
 for (int i = 0; i < s.getRows(); i++) {
  for (int j = 0; j < s.getColumns(); j++) {
   System.out.println(s.getCell(j, i).getContents());
   Label lab=new Label(j,i,s.getCell(j, i).getContents());
   ws.addCell(lab);
  }
 }
 Label rs=new Label(2,0,"Results");
 ws.addCell(rs);
 wwb.write();
 wwb.close();
 return "Pass";
}
 public static void main(String[] args) throws Exception {
  // TODO Auto-generated method stub
  export();
 }
}
32. Time
import java.util.Calendar;
import java.text.SimpleDateFormat;
public class Time {
  public static void  main(String arg[]) {
  Calendar currentDate = Calendar.getInstance();
  SimpleDateFormat formatter= 
  new SimpleDateFormat("yyyy/MMM/dd HH:mm:ss");
  String dateNow = formatter.format(currentDate.getTime());
  System.out.println("Now the date is :=>  " + dateNow);
  }
}
 
No comments:
Post a Comment