All Ajax Methods Example

* Instead of  Ram.txt file use your own text file , Write any Data

<!DOCTYPE html>
<html>
<head>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
<script>
$(document).ready(function(){
//These states for Loading files/images only
    $(document).ajaxError(function(){
           //If fail is not loading , this method will work
            alert("Error occured");
        });
    $(document).ajaxStart(function(){
            //At the time of ajax starting
            alert("Started");
        });
    $(document).ajaxStop(function(){
           at the time of ajax ending
            alert("Stopped");
        });
    $(document).ajaxSend(function(){
           //After ajax request start , request will go to server
            alert("Sended");
        });
    $(document).ajaxComplete(function(){
            //If The Ajax Request is success/failure , always it will work
            alert("Ajax Completed");
        });
    $(document).ajaxSuccess(function(){
           //For success only
            alert("Ajax Success");
        });
        $("button").click(function(){
            $(".main").load("Ram.txt");
        });
        $("#pid1").click(function(){
            $("#pid1").load("Ram.txt");
        });
        $(".pid2").click(function(){
            $(".pid2").load("Ram.txt");
        });
});
</script>
</head>
<body>
<div class="main">
<button>Get External Data</button>
<p id="pid1">Paragraph 1</p>
<p class="pid2">Paragraph 2</p>
</div>
</body>
</html>

CREATE and INSERT Queries

=> Create Table
 create table employee(no integer,name varchar2(15));

=>Crete Table with Primary key
 create table employee(no int primary key,name varchar2(15));

=>Crete Table with different Data types

 create table student(a int,b integer,c long,d float,e numeric(7,2),f number(7,2),g dec(7,2),h decimal(7,2),i varchar2(15),j date);

* desc student

 Name                                      Null?    Type
 ----------------------------------------- --------

 A                                                  NUMBER(38)
 B                                                  NUMBER(38)
 C                                                  LONG
 D                                                  FLOAT(126)
 E                                                  NUMBER(7,2)
 F                                                  NUMBER(7,2)
 G                                                  NUMBER(7,2)
 H                                                  NUMBER(7,2)
 I                                                  VARCHAR2(15)
 J                                                  DATE

* insert row into student table

insert into student values(100000000000,20000000,300000000,111.5,15000.00,15000.00,15000.00,15000.00,'ram',TO_DATE('1988/10/28','yyyy/mm/dd'));

Login Application

Sample View

Login Page

 If Login Fail

If Login Success

 Development

1) index.html

 

<form action="/LoginApplication/login">
Name:<input type="text" name="user" value="Ram"/>
Password:<input type="password" name="pwd" value="Ram"/>
<input type="submit" value="Login">
</form>
 

 

2)success.html

 

Login Success<br>
<a href="./index.html">Login</a>

 

3)fail.html

Login Failure<br>
<a href="./index.html">Login</a>

 

4)LoginServlet.java

 

package com.ram;

import java.io.IOException;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class LoginServlet extends HttpServlet {
   
    RequestDispatcher rd = null;
    boolean status;
      
    protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
       
        String user = request.getParameter("user");
        String pwd = request.getParameter("pwd");
        UserDTO userDTO = new UserDTO();
        userDTO.setName(user);
        userDTO.setPwd(pwd);
       
        UserDAO userDAO = new UserDAO();
        status = userDAO.checkLogin(userDTO);
        if(status) {
            rd = request.getRequestDispatcher("success.html");
            rd.forward(request, response);
        } else {
            rd = request.getRequestDispatcher("fail.html");
            rd.forward(request, response);
        }
       
       
    }

}
 

 

5)UserDAO.java

 

package com.ram;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class UserDAO {
   
    Connection con = null;
    Statement stmt = null;
    ResultSet rs = null;
    boolean status;
    String name = null;
    String pwd = null;
   
    public boolean checkLogin(UserDTO userDTO) {
       
        name = userDTO.getName();
        pwd = userDTO.getPwd();
       
        try {
           
            DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
            con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","ram","ram");
            stmt=con.createStatement();
            rs=stmt.executeQuery("select * from users where NAME='"+name+"' and PWD='"+pwd+"'");
           
            if(rs.next()) {
                status = true;
            }
           
           
        } catch (SQLException e) {
            e.printStackTrace();
        }
       
        return status;
       
        }
    }

 

 

6)UserDTO.java

 

package com.ram;

public class UserDTO {
   
    String name;
    String pwd;
   
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getPwd() {
        return pwd;
    }
    public void setPwd(String pwd) {
        this.pwd = pwd;
    }
   
   

}
 

7)web.xml

<web-app>
  <display-name>LoginApplication</display-name>

  <welcome-file-list>
    <welcome-file>index.html</welcome-file>
  </welcome-file-list>

  <servlet>
    <servlet-name>login</servlet-name>
    <servlet-class>com.ram.LoginServlet</servlet-class>
  </servlet>

  <servlet-mapping>
    <servlet-name>login</servlet-name>
    <url-pattern>/login</url-pattern>
  </servlet-mapping>

</web-app>

  8)Use ojdbc14.jar

9)Deployment

JSON with json.simple Library

Maven Dependency:

<dependency>
    <groupId>com.googlecode.json-simple</groupId>
    <artifactId>json-simple</artifactId>
    <version>1.1</version>
  </dependency>

Student Pojo:

package com.ram.json.simple.pojo;

import java.util.ArrayList;
import java.util.List;

public class Student {
   
    public String name;
    public String age;
    public List<String> list = new ArrayList<String>();
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getAge() {
        return age;
    }
    public void setAge(String age) {
        this.age = age;
    }
    public List<String> getList() {
        return list;
    }
    public void setList(List<String> list) {
        this.list = list;
    }
   
   

}


Convert Java To JSON:

package com.ram.json.simple;

import java.io.FileWriter;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

import org.json.simple.JSONObject;

import com.ram.jackson.pojo.Student;

public class JavaToJson {

    @SuppressWarnings("unchecked")
    public static void main(String[] args) {

        Student student = new Student();
        student.setName("Ramakrishna");
        student.setAge("26");
        List<String> list = new ArrayList<String>();
        list.add("100");
        list.add("200");
        list.add("300");
        student.setList(list);
       
        JSONObject jsonObject = new JSONObject();

        jsonObject.put("Name", student.getName());
        jsonObject.put("Age", student.getAge());
        jsonObject.put("list", student.getList());
   
        try {
   
            FileWriter file = new FileWriter("/home/biton/ramakrishna/delete/json/student.json");
            file.write(jsonObject.toJSONString());
            file.flush();
            file.close();
   
        } catch (IOException e) {
            e.printStackTrace();
        }
   
        System.out.print(jsonObject);
   
      }
   
    }


Convert JSON To Java:

package com.ram.json.simple;

import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;
import java.util.List;

import org.json.simple.JSONObject;
import org.json.simple.parser.JSONParser;
import org.json.simple.parser.ParseException;


public class JsonToJava {

    @SuppressWarnings("unchecked")
    public static void main(String[] args) {
       
        JSONParser parser = new JSONParser();
       
        try {
   
            Object object = parser.parse(new FileReader("/home/biton/ramakrishna/delete/json/student.json"));
   
            JSONObject jsonObject = (JSONObject) object;
           
            System.out.println(jsonObject);
   
            String name = (String) jsonObject.get("Name");
            System.out.println(name);
   
            String age = (String) jsonObject.get("Age");
            System.out.println(age);
           
            List<String> list = (List<String>) jsonObject.get("list");
            System.out.println(list);
   
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        } catch (ParseException e) {
            e.printStackTrace();
        }
       
      }

}

JSON with gson Library

Maven Dependency:

<dependency>
    <groupId>com.google.code.gson</groupId>
    <artifactId>gson</artifactId>
    <version>1.7.1</version>
  </dependency>

Student Pojo:

package com.ram.gson.pojo;

import java.util.ArrayList;
import java.util.List;

public class Student {
   
    public String name;
    public String age;
    public List<String> list = new ArrayList<String>();
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getAge() {
        return age;
    }
    public void setAge(String age) {
        this.age = age;
    }
    public List<String> getList() {
        return list;
    }
    public void setList(List<String> list) {
        this.list = list;
    }   
}

Convert Java To JSON:

package com.ram.gson;

import java.io.FileWriter;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

import com.google.gson.Gson;
import com.ram.jackson.pojo.Student;

public class JavaToJson {

    public static void main(String[] args) {

        Student student = new Student();
        student.setName("Ramakrishna");
        student.setAge("26");
        List<String> list = new ArrayList<String>();
        list.add("100");
        list.add("200");
        list.add("300");
        student.setList(list);
       
        Gson gson = new Gson();
   
        String json = gson.toJson(student);
   
        try {

            FileWriter writer = new FileWriter("/home/ramakrishna/delete/json/student.json");
            writer.write(json);
            writer.close();
   
        } catch (IOException e) {
            e.printStackTrace();
        }
   
        System.out.println(json);
      }
   
    }


Convert JSON To Java:

package com.ram.gson;

import java.io.BufferedReader;
import java.io.FileReader;
import java.io.IOException;

import com.google.gson.Gson;
import com.ram.gson.pojo.Student;

public class JsonToJava {

    public static void main(String[] args) {
       
        Gson gson = new Gson();
       
        try {
   
            BufferedReader br = new BufferedReader(
                new FileReader("/home/ramakrishna/delete/json/student.json"));
   
            Student student = gson.fromJson(br, Student.class);
   
            System.out.println("Name:"+student.getName());
            System.out.println("Age:"+student.getAge());
            System.out.println("Values:"+student.getList());
   
        } catch (IOException e) {
            e.printStackTrace();
        }
       
      }

}

JSON with Jackson Library

Maven Dependency:

<!-- For Jackson -->
  <repositories>
    <repository>
        <id>codehaus</id>
        <url>http://repository.codehaus.org/org/codehaus</url>
    </repository>
  </repositories>

<dependency>
        <groupId>org.codehaus.jackson</groupId>
        <artifactId>jackson-mapper-asl</artifactId>
        <version>1.8.5</version>
</dependency>

Studen Pojo:

package com.ram.jackson.pojo;

import java.util.ArrayList;
import java.util.List;

public class Student {
   
    public String name;
    public String age;
    public List<String> list = new ArrayList<String>();
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getAge() {
        return age;
    }
    public void setAge(String age) {
        this.age = age;
    }
    public List<String> getList() {
        return list;
    }
    public void setList(List<String> list) {
        this.list = list;
    }
}
 

Convert Java To JSON:

package com.ram.jackson;

import java.io.File;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

import org.codehaus.jackson.JsonGenerationException;
import org.codehaus.jackson.map.JsonMappingException;
import org.codehaus.jackson.map.ObjectMapper;

import com.ram.jackson.pojo.Student;

public class JavaToJson {

    public static void main(String[] args) {

        Student student = new Student();
        student.setName("Ramakrishna");
        student.setAge("26");
        List<String> list = new ArrayList<String>();
        list.add("100");
        list.add("200");
        list.add("300");
        student.setList(list);
       
        ObjectMapper mapper = new ObjectMapper();
   
        try {
   
            mapper.writeValue(new File("/home/ramakrishna/delete/json/student.json"), student);
   
            System.out.println(mapper.writeValueAsString(student));
   
        } catch (JsonGenerationException e) {
   
            e.printStackTrace();
   
        } catch (JsonMappingException e) {
   
            e.printStackTrace();
   
        } catch (IOException e) {
   
            e.printStackTrace();
   
        }
   
      }
   
    }

Convert JSON To Java:

package com.ram.jackson;

import java.io.File;
import java.io.IOException;

import org.codehaus.jackson.JsonGenerationException;
import org.codehaus.jackson.map.JsonMappingException;
import org.codehaus.jackson.map.ObjectMapper;

import com.ram.jackson.pojo.Student;

public class JsonToJava {

    public static void main(String[] args) {
       
        ObjectMapper mapper = new ObjectMapper();
       
        try {
   
            Student student = mapper.readValue(new File("/home/ramakrishna/delete/json/student.json"), Student.class);
   
            System.out.println("Name:"+student.getName());
            System.out.println("Age:"+student.getAge());
            System.out.println("Values:"+student.getList());
           
   
        } catch (JsonGenerationException e) {
   
            e.printStackTrace();
   
        } catch (JsonMappingException e) {
   
            e.printStackTrace();
   
        } catch (IOException e) {
   
            e.printStackTrace();
   
        }
   
      }
}

JSON Introduction

JSON Introduction

JSON (JavaScript Object Notation) is a lightweight data-interchange format.

Format of JSON is  Key with Value pair 

It is easy for humans to read and write. It is easy for machines to parse and generate.

JSON format is used for serializing & transmitting structured data over network connection.

Web Services and API'S use JSON format to provide public data.

 JSON is language independent like XML

Java libraries to process JSON data, which are Jackson, Google Gson and JSON.simple