JAVA BY RAMAKRISHNA

Wednesday, 5 August 2015

JQuery Device Detector [Mobile Device]

JQuery Device Detector [Mobile Device / IPad / IPhone / Other]

<html>
<head>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
<script>
$(document).ready(function() {
fun();
});
</script>

<script>
function fun() {

var device = navigator.userAgent;
var checker = {
microsoft: device.match(/IEMobile/),
ipad: device.match(/(iPad)/),
iphone: device.match(/(iPhone)/),
blackberry: device.match(/BlackBerry/),
android: device.match(/Android/)
};
if (checker.microsoft){
alert("Microsoft");
}
else if(checker.ipad) {
alert("ipaD");
}
else if (checker.iphone){
alert("iphone...");
}
else if (checker.blackberry){
alert("BlackBerry");
}
else if(checker.android) {
alert("Android");
}
else {
alert("Unknown Device/Desktop .... ");
}
};
</script>
</head>
<body>

</body>
</html>

Tuesday, 4 August 2015

JQuery Back button [Go to previous page]

For Go to previous page use following method

parent.history.back();

[OR]

document.referrer;

A.html

<html>
<body>
From Page A
<a href="C.html">Next</a>
</body>
</html>

B.html

<html>
<body>
From Page B
<a href="C.html">Next</a>
</body>
</html>

C.html

<html>
<head>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
<script>

$(document).ready(function(){
$("#back").click(function() {
parent.history.back();
});
});

/* $(document).ready(function(){
$("#back").click(function() {
var previousPage = document.referrer;
window.location.href = previousPage;
});

}); */

</script>
</head>
<body>
From Page C ...
<button id="back">Back</button>
</body>
</html>

Sunday, 7 June 2015

Difference between keyup,keydown and keypress events

* keydown , keypress both the events are same , this events will rise/fire whenever we click the key button

* keyup event will rise whenever we click and release key button

* keyup and keydown both are case insensitive
It means a , A , other languages also that button will return always same value

* Control buttons like Home,Delete,PageUp,PageDown,Backspace,Space,Tab,CapsLock,Shift,Ctr,Alt,Arrow button will work only for keydown and keyup event , these buttons will not work with keypress event

* keypress event will return the keyboard values based on the language you selected and it depends on case sensitive.

Key Down Event

<html>
<head>
<script src="jquery.js"></script>
<script>
$(document).ready(function() {
$("#keydownId").keydown(function(e) {
functionOne(e);
});
});
</script>
<script>
function functionOne(key) {
alert(key.which);
}
</script>
</head>
<body>
<div>
KeyDown Event <input type="text" id="keydownId"/>
</div>
</body>
</html>

Key Up Event

<html>
<head>
<script src="jquery.js"></script>
<script>
$(document).ready(function() {
$("#keyupId").keyup(function(e) {
functionOne(e);
});
$("#getVal").click(function(e) {
var val = $("#keyupId").val();
alert(val);
});
});
</script>
<script>
function functionOne(key) {
alert(key.which);
}
</script>
</head>
<body>
<div>
KeyUp Event <input type="text" id="keyupId"/>
Click to Get Value <button id="getVal">Get Val</button>
</div>
</body>
</html>

Key Press Event

<html>
<head>
<script src="jquery.js"></script>
<script>
$(document).ready(function() {
$("#keypressId").keypress(function(e) {
functionOne(e);
});
});
</script>
<script>
function functionOne(key) {
alert(key.which);
}
</script>
</head>
<body>
<div>
KeyPress Event <input type="text" id="keypressId"/>
</div>
</body>
</html>

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>

Sunday, 8 February 2015

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

Thursday, 11 September 2014

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();
        }

    }

}