Selenium : Writing Test Results in Excel - Part 1

Writing Test Results in Excel - Part 1

Pre-Req :

1. TestNG is required.
2. Download the Jar from here ExcelReportGenerator . Add this Jar into your project BuildPath.

Steps Below:

Step1 : Create a Package ‘ExcelResults’ under your Project.

Step2 : Create  the testcases which you’d like to automate using TestNg. (by using @Test,BeforeTest,…….) as Shown.

public class Test

{

static WebDriver driver;

@Test(priority = 1)

public static void validatingDollarTest1() {

System.out.println(“this is validating the DollarTest1”);

}

@Test(priority = 2)

public static void ValidatingDollarTest2() {

System.out.println(“this is validating the DollarTest2”);

}

@Test(priority = 3)

public static void validatingDollarTest3() {

System.out.println(“this is validating the DollarTest3”);

}

}

Step3 : Create a testng.xml file under your Project as Shown.

  <?xml version=”1.0″ encoding=”UTF-8″?>

<!DOCTYPE suite SYSTEM “http://testng.org/testng-1.0.dtd”&gt;

<suite name=”Random test suite” >

<test name=”EnterYourTestName”>

<classes>

<class name=”Test_98″/>

</classes>

</test>

</suite>

Now Run the testng.xml file.

Step 4 : Now Create a Class ‘ExcelGenerate’  and paste the following code.

import java.io.IOException;

import javax.xml.parsers.ParserConfigurationException;

import org.xml.sax.SAXException;

import com.raybiztech.commonexcelreport.ExcelReportGenerator;

public class ExcelGenerate

{

public static void main(String[]args) throws ParserConfigurationException, IOException, SAXException

{

ExcelReportGenerator exe= new ExcelReportGenerator();

exe.GenerateExcelReport(“YourTestName.xls”);

}

}

Step5 :Refresh the Package ‘ExcelResults’

Now you see the excelReport Generated. Its so simple huh !!!

*If you see the columns in the excel were disturbed please change the settings or Use the latest Version. I have made this using  ‘Libre’.

Java : Collections Sort

Collections Sort

To sort a given Array List in Ascending order :

1) Standard Sort : For String Type
2)Custom Sort : For Object Type


Standard Sort

public class sorting {
    public static void main(String[] args) {
       
        ArrayList<String> places=new ArrayList<String>();
       
        places.add("bangalore");
        places.add("delhi");
        places.add("Agra");
       
        System.out.println(places);
       
        Collections.sort(places);
        System.out.println(places); //Arrange in Ascending order
       
    }
}


Output:
bangalore,delhi,Agra
Agra,bangalore,delhi

Improved Sort

public class improved_sort {

    public static void main(String[] args) {
        new test2().start_now();
    }
}


//Getter Setter Class
class Student implements Comparable<Student>{
   
    private String name;

       public void set_name(String name){
        this.name=name;
    }
   
    public String get_name(){
        return name;
    }

    public int compareTo(Student o) {
        return name.compareTo(o.name);
    }   
}

class test2{
   
    public void start_now(){
      
        ArrayList<Student> students=new ArrayList<Student>();
        Student s1=new Student();
        Student s2=new Student();
        Student s3=new Student();
      
        s1.set_name("rahul");
        s2.set_name("pahul");
        s3.set_name("mahul");
      
        students.add(s1);
        students.add(s2);
        students.add(s3);
      
        for(Student s:students)
            System.out.print(s.get_name());
      
        Collections.sort(students);
      
        System.out.print("\n");
      
        for(Student s:students)
            System.out.print(s.get_name());
    }
   }

OutPut :

rahulpahulmahul
mahulpahulrahul

Custom Sort :

public class custom_sort {
    public static void main(String[] args) {
        testing Test=new testing();
        Test.start();
    }
}

//Getter , Setter Class to create Animal Object 
class Animal{
  
    private String Animal_type;
  
    public void set_Animaltype(String Animal_type){
        this.Animal_type=Animal_type;      
    }
  
    public String get_Animaltype(){
        return Animal_type;
    }  
}


class testing{
  
    public void start(){
        ArrayList<Animal> animals=new ArrayList<Animal>();
        Animal dog=new Animal();
        dog.set_Animaltype("dog");
      
        Animal cat=new Animal();
        cat.set_Animaltype("cat");
      
        Animal ant=new Animal();
        ant.set_Animaltype("ant");
              
        animals.add(dog);
        animals.add(cat);
        animals.add(ant);
      
        System.out.print("Before  Sorting = ");
        for (Animal str:animals)
            System.out.print(" "+str.get_Animaltype());
      
        custom_sort sort_logic=new custom_sort();      
        Collections.sort(animals, sort_logic); //
          
        System.out.print("\nAfter  Sorting = ");
        for (Animal str:animals)
            System.out.print(" "+str.get_Animaltype());
                  
    }
  
//inner class
    class custom_sort implements Comparator<Animal>{
        public int compare(Animal o1, Animal o2) {
            return o1.get_Animaltype().compareTo(o2.get_Animaltype());
        }    
    }
  
}


 OutPut
Before  Sorting =  dog cat ant
After  Sorting =  ant cat dog

Java :Reflection

Reflection

public class reflection_test
 {
    public static void main(String[] args)
 {
        ArrayList<Object> obj =new  ArrayList<Object>();
        obj.add("hi"); //passing String
        obj.add(123);    //Passing int
        reflection_class.Caller_method("method2",obj);
    }
}


class reflection_class
{
//    reflection_class rc_instance=new reflection_class();
//    Class rc_Class=rc_instance.getClass();
   
    public static void Caller_method (String method_name,ArrayList<Object> parameters)
{
//Method m=rc_Class.getMethod("method1", ArrayList.class );
            Method m=reflection_class.class.getMethod(method_name, ArrayList.class);
//getdeclaredmethod can also be used

            m.invoke(method_name, parameters);
            }       
   
    public static void method1(ArrayList<Object> parameters)
    {
        System.out.println("method1: "+parameters.get(0));
        System.out.println("method1: "+parameters.get(1));
    }
   
    public static  void method2(ArrayList<Object> parameters)
    {
        System.out.println("method2:"+parameters.get(0));
    }   
}

Java :HashTable Vs Dictionary Vs Hashmap

HashTable Vs Dictionary VsHashMap

Dictionary is an abstract class, superclass of Hashtable. You should not use Dictionary as it is obsolete. As for Hashtable, the advantage it had over other maps such as HashMap was thread safety, but with the introduction of ConcurrentHashMap since Java 1.5, there is no real reason to use it any longer.

 Dictionary is an abstract class in Java whereas Map is an interface. Since, Java does not support multiple inheritances, if a class extends Dictionary, it cannot extend any other class.Therefore, the Map interface was introduced.Dictionary class is obsolete and use of Map is preferred.

In summary: Don't use Dictionary or Hashtable, unless you really have to for compatibility reasons, use either HashMap if you don't need thread safety, or ConcurrentHashMap if your map is used in a concurrent environment.

 

Example:

 HashMap<String, String> hash_map = new HashMap<String, String>();

        hash_map.put("name1", "john");
        hash_map.put("name2", "marry");
        System.out.println(hash_map);

        System.out.println("name2= "+hash_map.get("marry"));
        System.out.println("Is HashMap empty? "+hash_map.isEmpty());
        hash_map.remove("name1");
      
        System.out.println(hash_map);
        System.out.println("Size of the HashMap: "+hash_map.size());

    

Output   
        {name1=john, name2=marry}
        name2= marry
        Is HashMap empty? false
        {name2=marry}
        Size of the HashMap: 1
        

 

 

Java :Lists Vs ArrayLists

Lists Vs ArrayLists

List<?> myList = new ArrayList<?>();

ArrayList<?> myList = new ArrayList<?>();

• List is an interface and ArrayList is an implementation of the List interface.
• There is no much of a difference except for the basic polymorphism concept that if you use Lists then you will only able to use methods of only Lists type but if you use ArrayList you should be able to use methods from ArrayList as well as from Lists and Overridden methods by ArrayLists if any.
•  List can change (to a LinkedList for example), without affecting the rest of the code. This will be a difficult task to do with an ArrayList, not only because you will need to change ArrayList to LinkedList everywhere, but also because you may have used ArrayList specific methods.

Java : String Vs StringBuffer vs StringBuilder

Java : String Vs StringBuffer vs StringBuilder 

 

So suppose you declare a String object:
String myString = “Hello”;

Next, you want to append “Guest” to the same String. What do you do?
myString = myString + ” Guest”;

Result : “Hello Guest”.

Although we made use of the same object(myString), internally a new object was created in the process. So, if you were to do some string operation involving an append or trim or some other method call to modify your string object, you would really be creating those many new objects of class String.

Example :

        String s = "Let’s test";
        s.concat("if this works then the string is IMMUTABLE");
        System.out.println(s);
      
        s = s.concat("if the String object is not IMMUTABLE");
        System.out.println(s);

To Make String Operations more Efficient ?

Ans : By using StringBuffer/StringBuilder

StringBuffer and StringBuilder have the same methods with one difference and that’s of synchronization. StringBuffer is synchronized ie., multiThreading is possible in StringBuffer  , hence slower compared to StringBuilder.

Example :
StringBuffer st=new StringBuffer("ahsas");
st.append("123");
st.append(123);

Browsers : Download Chrome and FireFox Versions

Download Chrome and FireFox Versions

http://ftp.mozilla.org/pub/mozilla.org/firefox/releases/

http://ftp.freenet.de/pub/filepilot/fpt/internet/browser/

Java : Excellent Interface Example

 Excellent Interface Example

//Using interface user need not have to think about child parent relation
//any class which implements an interface, can be assigned to that implementing interface instance variable

//Ex: Itree= Interface
//Apple and mango class implements Itree
//Once implemented , I can Use Interface variable to reference both apple and mango
//Also use Interface Array List for looping the same

//Note : Even when there is a new tree ,ex:Strawberry , I can just create a strawberry class implementing Itree and add it to Itree_ArrayList
//this way the code changes is very minimal and I dont need to touch other code.

interface Itree{

public void fruit();

}

class apple implements Itree{

public void fruit() { System.out.println("apple"); }

public void children(){System.out.println("apple a day keeps doctor away"); }

}

class mango implements Itree{

public void fruit() {System.out.println("mango"); }

}

public class tree {

public static void main(String[] args){

ArrayList<Itree> Itree_ArrayList=new ArrayList<Itree>(); // Itree_ArrayList = Interface Array List

Itree tree1=new apple();

Itree tree2=new mango();

Itree_ArrayList.add(tree1);

Itree_ArrayList.add(tree2);

for(Itree t_count:Itree_ArrayList)

t_count.fruit();

apple app=(apple)Itree_ArrayList.get(0);//user can access other methods by casting to apple varibale

app.children();

}

}

Output :
 apple
mango
apple a day keeps doctor away

----------------------------------------------------------------------------------------------------------------------------------

I think it works best for me to create Util library s.But only downside is Static variables are considered to be final.In this case use cannot create getter methods to  change the value of i

public class tree {

public static void main(String[] args){

Itree.static_method();

}

}

interface Itree{

static String i="";

public static void static_method(){ System.out.print("hi"); }

}

Output :
hi 

Java : Sorting ArrayList

Sorting ArrayList

Ref :how-to-sort-an-arraylist-in-java

import java.util.ArrayList;

import java.util.Collections;

 

public class SortingArrayList {

 

    public static void main(String args[]){

 

       ArrayList<String> al = new ArrayList<String> ();

 

            al.add("22");

            al.add("33");

            al.add("11");

            al.add("cc");

            al.add("bb");

            al.add("aa");

 

            System.out.println("Printing List before sorting......");

             for(String value: al){

                 System.out.println(value);

             }

 

             //Sorting...

             Collections.sort(al);

 

             System.out.println("Printing List after sorting......");

             for(String value: al){

                System.out.println(value);

             }

}

}

 

Output

Printing List before sorting……
22
33
11
cc
bb
aa
Printing List after sorting……
11
22
33
aa
bb
cc
 

Manual Testing : Best Software Testing Screen Recorders

Best Software Testing Screen Recorders.

http://www.softwaretestingclub.com/forum/topics/video-recording-tools

 

1. jing
2. Camstudio  
3. BBTestAssistant 
4. CapStudio
5. Snag It 

Android :Unable to instantiate activity ComponentInfo

Unable to instantiate activity ComponentInfo

You may be trying to find the view before onCreate() which is incorrect.

public class MainActivity extends Activity {

  ImageView mainImage = (ImageView) findViewById(R.id.imageViewMain); //incorrect

  @Override
  protected void onCreate(Bundle savedInstanceState){
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);
  }
  ...
}

Android : Creating a new Activity (new screen)

Creating a new Activity

Creating new activity and navigating onclick button (Explicit Activity)
    1. goto res/layout > rt ck > select "new xml file" and "new_layout"
    2. Add objects,make modifications to new layout xml file in graphical view
    3. Manifest file : add below code  inside "<application> </application>"
   
            <activity android:name=".new_Activity">
 
       
    4. Goto src/package > rt ck and select new>Class
    5. give name as "new_Activity" ,ck OK and add below code in "new_Activity"
   
   
        import android.app.Activity;
        public class  new_Activity extends Activity
        {
            @Override
            protected void onCreate(Bundle savedInstanceState) {
                    super.onCreate(savedInstanceState);
                    setContentView(R.layout.new_layout);
                }
        }

    6. Goto activity_main.xml ,create a button and in properties>view>On click-"method_name" and save
    7. Goto Mainactivity>add below method inside the class :
        public void method_name(View V)
        {
            Intent intent=new Intent(this,new_Activity.class);
            startActivity(intent);
        }

Android : Change SDK in Android Studio

Change SDK in Android Studio

To do this, on the menu choose File -> Project Structure. Select the Libraries option and click the green + to add your library.

Android :How to auto import the necessary classes in Android Studio with shortcut?

Android :How to auto import the necessary classes in Android Studio with shortcut?

Go to File -> Settings -> Editor -> Auto Import -> Java and make the below things:
Select Insert imports on paste value to All
Do tick mark on Add unambigious imports on the fly option and "Optimize imports on the fly*


 

Ranorex : String into object

String into object

To convert a string of xpath into object in Ranorex :

1) Include the library above the namespace -- using Ranorex.Core;

2)
            RxPath path="/dom[@domain='localhost']//div[#'silverlightControlHost']//button[@name~'.*supplinvcs.*']";
              Ranorex.Button button = Host.Local.FindSingle(path); 
            WinForms.MessageBox.Show(button.Text.ToString());



Ref:
http://www.ranorex.com/forum/add-regular-expression-when-using-a-variable-t2874.html

Android :Working with DB

Android :Working with DB

You will be needing 3 user defined class files.

1. File A which extends sqlitehelper (compulsory)
2. File B which contains all methods like - create table,Insert data,Select etc.,
3. File C , for Getter and Setter Class which is more for making your code more classy.

Let File A =sqllitehelperclass
Let File B = DBOperations
Let File C= Persons

sqllitehelperclass.java

public class sqllitehelperclass extends SQLiteOpenHelper

 {

    public sqllitehelperclass(Context context)
    {
        super(context, "test_db", null, 1);
    }
   
    @Override  // onCreate() is only run when the database file did not exist and was just created    

 public void onCreate(SQLiteDatabase db)
    {
        db.execSQL("CREATE TABLE Persons( PersonID INTEGER PRIMARY KEY AUTOINCREMENT,FirstName TEXT, Age INT)");
    }

    @Override  //    onUpgrade() is only called when the database file exists but the stored version number is lower than requested in //constructor.    

public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }

}

DBOperations.java

public class DBOperations {
  
    SQLiteOpenHelper sql_helper;
  
    DBOperations(Context context){  
        sql_helper=new sqllitehelperclass(context);
        //Downcasting SQLiteOpenHelper instance with the user defined class "SQLiteOpenHelperclass"
    }
  
    void create_table(){
        sql_helper.getWritableDatabase().execSQL("CREATE TABLE Persons( PersonID INTEGER PRIMARY KEY AUTOINCREMENT,FirstName TEXT, Age INT)");      
        Log.d("db","New db created");
        sql_helper.getWritableDatabase().close();
    }
  
    void delete_table(){
        sql_helper.getWritableDatabase().execSQL("DROP TABLE IF EXISTS Persons");  
        Log.i("db", "database deleted");
        sql_helper.getWritableDatabase().close();
    }

    void insert(){
   //     sql_helper.getWritableDatabase().rawQuery("INSERT INTO Persons (FirstName,Age) VALUES ('Deepak','100');", null);

sql_helper.getWritableDatabase().execSQL("INSERT INTO Persons (FirstName,Age) VALUES ('Deepak','100');");

        sql_helper.getWritableDatabase().close();
    }
  
    List<persons> db_getall_data()
    {  
        int record_count;
        List<persons> query_res=new ArrayList<persons>();

        String[] args={"5P"};
        Cursor resultSet=sql_helper.getReadableDatabase().rawQuery("SELECT * FROM Persons", args);
        Log.d("db", "No of Records present="+String.valueOf(resultSet.getCount()));
        record_count=resultSet.getCount();
        resultSet.moveToFirst();
       
        if(record_count>0){
            while (record_count!=0)
            {
                persons Persons=new persons();
                Persons.put_age(resultSet.getInt(resultSet.getColumnIndex("Age")));
                Persons.put_name(resultSet.getString(resultSet.getColumnIndex("FirstName")));
                query_res.add(Persons);  
                resultSet.moveToNext();
                record_count=record_count-1;
            }
        }      
        sql_helper.getReadableDatabase().close();
        return query_res;
    }
  
  
    public boolean isTableExists()
    {
        try{
            Cursor cursor = sql_helper.getReadableDatabase().rawQuery("select DISTINCT tbl_name from sqlite_master where tbl_name = '"+"Persons"+"'", null);
            Log.d("DB","rows="+cursor.getCount());
            cursor.close();
        }catch(Exception e){
            sql_helper.getReadableDatabase().close();
            Log.d("Db","Table does not exist ");
            return false;
        }
       
        sql_helper.getReadableDatabase().close();
       return true;
    }
  
  }

person.java

public class persons {
   
    int age;
    String name;
   
    int get_age(){
        return age;
    }
   
    String get_name(){
        return this.name;
       
    }
   
    void put_name(String name){
        this.name=name;
       
    }
   
    void put_age(int age){
        this.age=age;
    }
}
 

Android : To Animate a picture file

To Animate a picture file

1.Create a new folder "anim" inside res folder
2.Goto folder res\anim and rt ck , select "Android XML File"
3.Give a resource ="Tween Animation" and File name="rotator" , root element ="rotate"
4.Open rotator.xml , delete all its contents and copy paste the below code inside :
************************************************************************
<?xml version="1.0" encoding="utf-8"?>
<set xmlns:android="http://schemas.android.com/apk/res/android"
    android:fillAfter="true"
    android:interpolator="@android:anim/linear_interpolator" >

    <!-- Use startOffset to give delay between animations -->


    <!-- Move -->
    <translate
        android:duration="800"
        android:fillAfter="true"
        android:fromXDelta="0%p"
        android:startOffset="300"
        android:toXDelta="75%p" />
    <translate
        android:duration="800"
        android:fillAfter="true"
        android:fromYDelta="0%p"
        android:startOffset="1100"
        android:toYDelta="70%p" />
    <translate
        android:duration="800"
        android:fillAfter="true"
        android:fromXDelta="0%p"
        android:startOffset="1900"
        android:toXDelta="-75%p" />
    <translate
        android:duration="800"
        android:fillAfter="true"
        android:fromYDelta="0%p"
        android:startOffset="2700"
        android:toYDelta="-70%p" />

    <!-- Rotate 360 degrees -->
    <rotate
        android:duration="1000"
        android:fromDegrees="0"
        android:interpolator="@android:anim/cycle_interpolator"
        android:pivotX="50%"
        android:pivotY="50%"
        android:startOffset="3000"
        android:repeatCount="infinite"
        android:repeatMode="restart"
        android:toDegrees="360" />

</set>
***************************************************************************

5.Click next ...next and Finish
6.Copy paste method in your MainActivity

        public void rotateit(View v){
        final ImageView myImage = (ImageView)findViewById(R.id.imageView2);
                final Animation myRotation = AnimationUtils.loadAnimation(getApplicationContext(), R.anim.rotator);
                myImage.startAnimation(myRotation);
    }
7.Copy Paste any image inside your res/drawable-hdpi
8.Goto layout xml (ex: layout/activity_main.xml)
9.Select tab - Graphical Layout
10.Drag and Drop Image View  , Select the the image you pasted in "res/drawable-hdpi"
11. Select the image ,goto properties
12.Make On Click ="rotateit"
13.Save and Run



more animations in http://www.androidhive.info/2013/06/android-working-with-xml-animations/

Android: Gif animations part 2

Gif animations part 2

1.Addthis in your Manifest file inside activity "android:hardwareAccelerated="false"
Example :
        <activity
                    android:hardwareAccelerated="false"
                    android:name="foo.GifActivity"
                    android:label="The state of computer animation 2014">
        </activity>

2.Code for Main_Activity

        public class GifActivity extends Activity {
            @Override
            protected void onCreate(Bundle savedInstanceState) {
                super.onCreate(savedInstanceState);
                setContentView(new GifView(this));
            }
       
            static class GifView extends View {
                Movie movie;
       
                GifView(Context context)
                {
                    super(context);
                    movie = Movie.decodeStream(context.getResources().openRawResource(R.drawable.some_gif));
                }
                              
                // inHeriting onDraw of View Class
                @Override
                protected void onDraw(Canvas canvas) {  
                    if (movie != null) {
                        movie.setTime((int) SystemClock.uptimeMillis() % movie.duration());
                        canvas.scale((this.getWidth()/movie.width()), (this.getHeight()/movie.height()));// Size
                        movie.draw(canvas, 0, 0);//Location
                        invalidate();
                    }
                }
            }
        }
       
3.Paste the gif file in "res/hdpi or res/xhdpi"
4.Run the Code

Android:Creating Gif Animation in Android

Creating Gif Animation in Android

1. Create a new Android Project.
2. Add the below code in your Main_activity

//******************Main_activity*************************
public class Your_Class extends Activity {

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);

        Gif_loading_View view = new Gif_loading_View(this);
        setContentView(view);
    }

}

//Adding the webView
public class Gif_loading_View extends WebView{

    public Gif_loading_View(Context context) {

        super(context);    
        loadUrl("file:///android_asset/loading_position.html");

        }
}
//**************************************************************


3.Create a file "loading_position.html" and add the below code inside and svae it.

<html>
<body bgcolor="white">
    <table width="100%" height="100%">
        <tr>
            <td align="center" valign="center">               
                <br/>
                <br/>
                <br/>
                <font size="6">Please wait...</font>
                <br/>
                <br/>
                <img src="your_gif_filename.gif" />

            </td>
        </tr>
    </table>
</body>

4. Copy paste the html file inside "assets" folder in your project.
5. Copy paste any gif file from the internet and rename it as "your_gif_filename"
6. Paste it inside the same assets folder
7.Run the project

Vbs: Reflection in vbs or Converting String into Function Name

  Reflection in vbs or Converting String into Function Name

Output:
tc1
tc2

SQL :Important Queries

SQL Server : Important Queries

1.To display all tables in a database

SELECT * FROM information_schema.tables

2. To display table information

 sp_help table_name

TestComplete : UserForms

TestComplete : UserForms

Dim sPath,sBrowser,oDialog,form,mr

sub a
    Set form = UserForms.UserForm1
    Set oDialog = form.OpenDialog1        
     
      do
        mr=form.ShowModal     'Show GUI
        Select Case mr
            Case mrOK          'Ok button , In properties set the ModalResult as mrOK 
           
                   if( (form.cxRadioGroup1.ItemIndex=0 or form.cxRadioGroup1.ItemIndex=1) and sPath<>"" )then
                      if(form.cxRadioGroup1.ItemIndex=0) then
                        sBrowser="FireFox"
                        else
                        sBrowser="IE"
                      end if   
                      exit do
                   end if
                             
            Case mrCancel     'Cancel Button .'Ok button , In properties set the ModalResult as mrCancel      
                  exit sub
                     
             Case mrYes         'BrowserButton , In properties set the ModalResult as mrYes
                     oDialog.Execute           'Trigger TOpenBrowser
                     sPath=oDialog.FileName
                     form.Path.Text=sPath
      End Select
    Loop  While (1<2)
   
    msgbox("Browser="&sBrowser&vblf&"File Path="&sPath)
     
end sub

Android : Cannot resolve android (Android Studio error)

Cannot resolve android  (Android Studio error)

Make sure you have Andoid SDK in your system :

1- press ctrl+alt+shift+s
2-in the Modules bar click on your project name
3-change the compile sdk version to the newest one
4-click apply and ok then sync your project
5-done , i hope the best for you