Nirav Raval's Blog For J2EE Developer

2015-07-12T11:04:00.000-07:00

Configure Apache 2.4 Web Server with Tomcat 8.0 as a Balancer to run the Java Web Application

Hello Friends,

Today I am gonna show you the Apache Web Server version 2.4 to act as mediator to handle the application load by dividing it into more than one Application Servers.

Here I am using Tomcat 8 as an Application Server to run a Java Based Web application.

I have configure this in Windows 8 64 bit Operating System.

I assume that you have done the tomcat server configuration to set context outside webapps folder of it.

For that write your context name and path in server.xml file of tomcat server as below.

This must be written under <Host> tag.

To do this, follow below steps.

Download Apache 2.x from apache site.
Download Apache Tomcat 8 also.
Install Apache web server on your system.
Make two copy of tomcat and set context of web application as shown above.
Both tomcat must set on different port.
I have set one Tomcat on 8080 and second on 8081 in <Connector> port in Server.xml file.
Now open httpd file of Apache web server from conf folder and add below configuration in it.

ServerName www.nirav.com:80

<VirtualHost *:80>
    ServerName www.nirav.com
    ServerAlias nirav.com


<Proxy balancer://mycluster>
       BalancerMember http://localhost:8080/ route=tomcat1
       BalancerMember http://localhost:8081/ route=tomcat2
       ProxySet lbmethod=byrequests
    </Proxy>
    ProxyPass / balancer://mycluster/
</VirtualHost>

_____________________________________________________________

In above configuration, I have used byrequest method for load balancing.
This means the load of requests is balanced based on each request i.e. First request served by tomcat 1, then second will be served by tomcat 2, then third will be served by tomcat 1 and so on.

To activate this you need to un-comment below module in httpd file:
LoadModule lbmethod_byrequests_module modules/mod_lbmethod_byrequests.so

Some others modules also need to be un-comment as shown below.

LoadModule proxy_module modules/mod_proxy.so
LoadModule proxy_ajp_module modules/mod_proxy_ajp.so
LoadModule proxy_balancer_module modules/mod_proxy_balancer.so
LoadModule proxy_connect_module modules/mod_proxy_connect.so
LoadModule proxy_express_module modules/mod_proxy_express.so
LoadModule proxy_fcgi_module modules/mod_proxy_fcgi.so
LoadModule proxy_ftp_module modules/mod_proxy_ftp.so
LoadModule proxy_html_module modules/mod_proxy_html.so
LoadModule proxy_http_module modules/mod_proxy_http.so
LoadModule proxy_scgi_module modules/mod_proxy_scgi.so

After adding above configuration in httpd file of Apache server, just restart apache server. Then start both tomcats.

If any error shown on restart Apache server then read its log file and act accordingly.The error comes if the configuration is not properly done. Or any required module directive is not added.

I have given almost all modules to make un-comment.

I have set domain name as www.nirav.com in my host file (C:\Windows\System32\Drivers\etc\host) to make run in local machine. You can use what you want.

Now this done. You can run your application with activated load balancer by Apache web server.

Just need to write www.nirav.com/SampleWeb in web browser and the request will be handled by two tomcats one by one on each request.

I hope this will helpful to understand the basic configuration for enable balancer in Apache web server.

Here, I have not covered any theory part, you can google it separately.

Thank you..!

JQury Grouping Table Data

2014-12-24T10:13:00.000-08:00

Hello Friends,
Today, lets make some fun with jQuery demo of grouping HTML table data.

Problem:
I have one table with many columns but one column having same data.
And other columns with data related one single column.
For e.g.
List of States. In which list of Cities or Locations.
I need to group all data State wise.

Below is our Table. We need to Group this table data based on State column.

Now, We will use jQuery for group above data based on State Column. And below will be the output.

HTML Table Code before Group:
<body>

<h3>JQury Grouping Table Data</h3>
    <table id="myTable" border="1" cellpadding="3" cellspacing="0">
        <tr>
            <th>Sr No</th>
            <th>State</th>
            <th>Location</th>
            <th>Famous Area</th>
        </tr>
        <tr>
            <td>1</td>
            <td>Gujarat</td>
            <td>Ahmedabad</td>
            <td>AAA</td>
        </tr>
        <tr>
            <td>2</td>
            <td>Gujarat</td>
            <td>Baroda</td>
            <td>BBB</td>
        </tr>
        <tr>
            <td>3</td>
            <td>Gujarat</td>
            <td>Surat</td>
            <td>CCC</td>
        </tr>
        <tr>
            <td>4</td>
            <td>Gujarat</td>
            <td>Rajkot</td>
            <td>DDD</td>
        </tr>
        <tr>
            <td>5</td>
            <td>Maharastra</td>
            <td>Mumbai</td>
            <td>EEE</td>
        </tr>
        <tr>
            <td>6</td>
            <td>Maharastra</td>
            <td>Nagpur</td>
            <td>FFF</td>
        </tr>
        <tr>
            <td>7</td>
            <td>Maharastra</td>
            <td>Khandala</td>
            <td>GGG</td>
        </tr>
        <tr>
            <td>8</td>
            <td>Madhya Pradesh</td>
            <td>Bhopal</td>
            <td>HHH</td>
        </tr>
        <tr>
            <td>9</td>
            <td>Madhya Pradesh</td>
            <td>Rajgarh</td>
            <td>III</td>
        </tr>
        <tr>
            <td>10</td>
            <td>Madhya Pradesh</td>
            <td>Sehore</td>
            <td>JJJ</td>
        </tr>
        <tr>
            <td>11</td>
            <td>Madhya Pradesh</td>
            <td>Bhind</td>
            <td>KKK</td>
        </tr>
        <tr>
            <td>12</td>
            <td>Madhya Pradesh</td>
            <td>Big</td>
            <td>120</td>
        </tr>
    </table>

Now we will write one jQuery function and apply for above table to group it based on State name.

<script>
    $(document).ready(function() {
        $(function() {
            function groupTable($rows, startIndex, total) {
                if (total === 0) {
                    return;
                }
                var i, currentIndex = startIndex, count = 1, lst = [];
                var tds = $rows.find('td:eq(' + currentIndex + ')');
                var ctrl = $(tds[0]);
                lst.push($rows[0]);
                for (i = 1; i <= tds.length; i++) {
                    if (ctrl.text() == $(tds[i]).text()) {
                        count++;
                        $(tds[i]).addClass('deleted');
                        lst.push($rows[i]);
                    } else {
                        if (count > 1) {
                            ctrl.attr('rowspan', count);
                            groupTable($(lst), startIndex + 1, total - 1)
                        }
                        count = 1;
                        lst = [];
                        ctrl = $(tds[i]);
                        lst.push($rows[i]);
                    }
                }
            }
            groupTable($('#myTable tr:has(td)'), 1, 1);
            $('#myTable .deleted').remove();
        });
    });
</script>

Note: I have used below jQuery-2.1.3.min.js file.
<script src="http://code.jquery.com/jquery-2.1.3.min.js"></script>
______________________________________________________________________

Hope you find this helpful....!

2013-08-01T10:49:00.001-07:00

Spring MVC - Hibernate Demo Application

Hello Friends,

Nice to see you again.
In Previous Sessions we have seen Spring MVC with Annotation Demo. And learn how they work.
Today, we will see the example of Spring MVC with Hibernate basic tutorial.

This demo I have created using Netbeans IDE 7.1.2.
Netbeans provide Spring Project with Hibernate, So no need to find out every Jars as it provides by Netbeans itself.

Ok Here we will create one Student Register Application demo which we previosuly develope without database.

Now we will extend that with adding Hibernate support to persist our data in MySQL Server.

Below is our final output.

Student Registration Demo

For create this application, I have create one Database Table "Student" in MySQL Server as below.

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

CREATE TABLE `student` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `firstname` varchar(30) DEFAULT NULL,
  `lastname` varchar(30) DEFAULT NULL,
  `telephone` varchar(15) DEFAULT NULL,
  `email` varchar(30) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1

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

Project Structure

Source Code:

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

(1) Web.xml

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

<?xml version="1.0" encoding="UTF-8"?>

<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns="http://java.sun.com/xml/ns/javaee"

xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"

xsi:schemaLocation="http://java.sun.com/xml/ns/javaee

http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"

id="WebApp_ID" version="2.5">

<display-name>Spring3-Hibernate</display-name>

<welcome-file-list>

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

</welcome-file-list>

<servlet-name>spring</servlet-name>

<servlet-class>

org.springframework.web.servlet.DispatcherServlet

</servlet-class>

<load-on-startup>1</load-on-startup>

</servlet>

<servlet-mapping>

<servlet-name>spring</servlet-name>

<url-pattern>/</url-pattern>

</servlet-mapping>

</web-app>

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

(2) spring-servlet.xml

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

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns:aop="http://www.springframework.org/schema/aop"

xmlns:context="http://www.springframework.org/schema/context"

xmlns:jee="http://www.springframework.org/schema/jee"

xmlns:lang="http://www.springframework.org/schema/lang"

xmlns:p="http://www.springframework.org/schema/p"

xmlns:tx="http://www.springframework.org/schema/tx"

xmlns:util="http://www.springframework.org/schema/util"

xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd

http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd

http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd

http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee.xsd

http://www.springframework.org/schema/lang http://www.springframework.org/schema/lang/spring-lang.xsd

http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd

http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util.xsd">

<context:annotation-config />

<context:component-scan base-package="com.j2eedeveloper" />

<bean id="jspViewResolver"

class="org.springframework.web.servlet.view.InternalResourceViewResolver">

<property name="viewClass"

value="org.springframework.web.servlet.view.JstlView" />

</bean>

<bean id="messageSource"

class="org.springframework.context.support.ReloadableResourceBundleMessageSource">

</bean>

<bean id="propertyConfigurer"

class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"

p:location="/WEB-INF/jdbc.properties" />

<bean id="dataSource"

class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"

p:driverClassName="${jdbc.driverClassName}"

p:url="${jdbc.databaseurl}" p:username="${jdbc.username}"

p:password="root" />

<bean id="sessionFactory"

class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">

<value>classpath:hibernate.cfg.xml</value>

</property>

<value>org.hibernate.cfg.AnnotationConfiguration</value>

</property>

<props>

<prop key="hibernate.dialect">${jdbc.dialect}</prop>

</props>

</property>

</bean>

<tx:annotation-driven />

<bean id="transactionManager"

class="org.springframework.orm.hibernate3.HibernateTransactionManager">

</bean>

</beans>

---------------------------------------------------------------------------------------------------------------------------
(3) jdbc.properties
---------------------------------------------------------------------------------------------------------------------------

jdbc.driverClassName= com.mysql.jdbc.Driver

jdbc.dialect=org.hibernate.dialect.MySQLDialect

jdbc.databaseurl=jdbc:mysql://localhost:3306/test

jdbc.username=root

jdbc.password=root

---------------------------------------------------------------------------------------------------------------------------
(4) hibernate.cfg.xml
---------------------------------------------------------------------------------------------------------------------------

<?xml version='1.0' encoding='utf-8'?>

<!DOCTYPE hibernate-configuration PUBLIC

"-//Hibernate/Hibernate Configuration DTD//EN"

"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

<session-factory>

</session-factory>

</hibernate-configuration>

---------------------------------------------------------------------------------------------------------------------------
(5) messages_en.properties
---------------------------------------------------------------------------------------------------------------------------
label.firstname=First Name
label.lastname=Last Name
label.email=Email
label.telephone=Telephone
label.addStudent=Add Student
label.title=Student Manager

label.footer=© niravj2eedeveloper.blogspot.com

---------------------------------------------------------------------------------------------------------------------------
(6) StudentController.java
---------------------------------------------------------------------------------------------------------------------------
package com.j2eedeveloper.controller;

import com.j2eedeveloper.service.StudentService;
import com.j2eedevloper.model.Student;
import java.util.Map;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;

@Controller
public class StudentController {

@Autowired
private StudentService studentService;

@RequestMapping("/index")
public String listContacts(Map<String, Object> map) {

map.put("student", new Student());
map.put("studentList", studentService.listStudent());

return "student";
}

@RequestMapping(value = "/add", method = RequestMethod.POST)
public String addContact(@ModelAttribute("student") Student student) {

studentService.addStudent(student);

return "redirect:/index";
}

@RequestMapping("/delete/{studentId}")
public String deleteContact(@PathVariable("studentId") Integer studentId) {

studentService.removeStudent(studentId);

return "redirect:/index";
}

}

---------------------------------------------------------------------------------------------------------------------------
(7) StudentDAO.java
---------------------------------------------------------------------------------------------------------------------------
package com.j2eedeveloper.dao;

import com.j2eedevloper.model.Student;
import java.util.List;

public interface StudentDAO {

public void addStudent(Student student);

public List<Student> listStudent();

public void removeStudent(Integer id);

}

---------------------------------------------------------------------------------------------------------------------------
(8) StudenttDAOImpl.java
---------------------------------------------------------------------------------------------------------------------------
package com.j2eedeveloper.dao;

import com.j2eedevloper.model.Student;
import java.util.List;
import org.hibernate.SessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;

@Repository
public class StudenttDAOImpl implements StudentDAO {

@Autowired
private SessionFactory sessionFactory;

public void addStudent(Student student) {
sessionFactory.getCurrentSession().save(student);
}

public List<Student> listStudent() {

return sessionFactory.getCurrentSession().createQuery("from Student").list();
}

public void removeStudent(Integer id) {
Student student = (Student) sessionFactory.getCurrentSession().load(
Student.class, id);
if (null != student) {
sessionFactory.getCurrentSession().delete(student);
}

}

}

---------------------------------------------------------------------------------------------------------------------------
(9) StudentService.java
---------------------------------------------------------------------------------------------------------------------------
package com.j2eedeveloper.service;

import com.j2eedevloper.model.Student;
import java.util.List;

public interface StudentService {

public void addStudent(Student student);

public List<Student> listStudent();

public void removeStudent(Integer id);

}

---------------------------------------------------------------------------------------------------------------------------
(10) StudentServiceImpl.java
---------------------------------------------------------------------------------------------------------------------------
package com.j2eedeveloper.service;

import com.j2eedeveloper.dao.StudentDAO;
import com.j2eedevloper.model.Student;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

@Service
public class StudentServiceImpl implements StudentService {

@Autowired
private StudentDAO studentDAO;

@Transactional
public void addStudent(Student student) {
studentDAO.addStudent(student);
}

@Transactional
public List<Student> listStudent() {

return studentDAO.listStudent();
}

@Transactional
public void removeStudent(Integer id) {
studentDAO.removeStudent(id);
}

}

---------------------------------------------------------------------------------------------------------------------------
(11) Student.java
---------------------------------------------------------------------------------------------------------------------------

package com.j2eedevloper.model;

import javax.persistence.*;

@Entity

@Table(name = "Student")

public class Student {

@Id

@Column(name = "ID")

@GeneratedValue

private Integer id;

@Column(name = "FIRSTNAME")

private String firstname;

@Column(name = "LASTNAME")

private String lastname;

@Column(name = "EMAIL")

private String email;

@Column(name = "TELEPHONE")

private String telephone;

public String getEmail() {

return email;

}

public String getTelephone() {

return telephone;

}

public void setEmail(String email) {

this.email = email;

}

public void setTelephone(String telephone) {

this.telephone = telephone;

}

public String getFirstname() {

return firstname;

}

public String getLastname() {

return lastname;

}

public void setFirstname(String firstname) {

this.firstname = firstname;

}

public void setLastname(String lastname) {

this.lastname = lastname;

}

public Integer getId() {

return id;

}

public void setId(Integer id) {

this.id = id;

}

---------------------------------------------------------------------------------------------------------------------------
(12) student.jsp
---------------------------------------------------------------------------------------------------------------------------

<%@taglib uri="http://www.springframework.org/tags" prefix="spring"%>
<%@taglib uri="http://www.springframework.org/tags/form" prefix="form"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<html>
<head>
<title>Spring 3 MVC Hibernate - Student Manager</title>
<style type="text/css">
body {
font-family: sans-serif;
}
.data, .data td {
border-collapse: collapse;
width: 100%;
border: 1px solid #aaa;
margin: 2px;
padding: 2px;
}
.data th {
font-weight: bold;
background-color: #5C82FF;
color: white;
}
</style>
</head>
<body>

<h2><spring:message code="label.title"/></h2>

<form:form method="post" action="add.html" commandName="student">

<table>
<tr>
<td><form:label path="firstname"><spring:message code="label.firstname"/></form:label></td>
<td><form:input path="firstname" /></td>
</tr>
<tr>
<td><form:label path="lastname"><spring:message code="label.lastname"/></form:label></td>
<td><form:input path="lastname" /></td>
</tr>
<tr>
<td><form:label path="email"><spring:message code="label.email"/></form:label></td>
<td><form:input path="email" /></td>
</tr>
<tr>
<td><form:label path="telephone"><spring:message code="label.telephone"/></form:label></td>
<td><form:input path="telephone" /></td>
</tr>
<tr>
<td colspan="2">
<input type="submit" value="<spring:message code="label.addStudent"/>"/>
</td>
</tr>
</table>
</form:form>

<h3>Students</h3>
<c:if test="${!empty studentList}">
<table class="data">
<tr>
<th style="width: 40%">Name</th>
<th style="width: 30%">Email</th>
<th style="width: 20%">Telephone</th>
<th> </th>
</tr>
<c:forEach items="${studentList}" var="student">
<tr>
<td style="width: 40%">${student.lastname} ${student.firstname} </td>
<td style="width: 30%">${student.email}</td>
<td style="width: 20%">${student.telephone}</td>
<td><a href="delete/${student.id}">delete</a></td>
</tr>
</c:forEach>
</table>
</c:if>

<br/>
<hr/>
<h3><spring:message code="label.footer"/></h3>
<hr/>
</body>

</html>

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

Now run URL http://localhost:8080/SpringHibernate/index in your browser.

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

Hope you find this helpful....!

Spring MVC with Annotation

2013-07-19T10:14:00.000-07:00

Hello Friends,

Nice to see you again.
In Previous Sessions we have seen Hibernate Basic Demo. And learn how they work.
Today, we will see the example of Spring MVC with annotation basic tutorial.

This demo I have created using Netbeans IDE 7.1.2.
Netbeans provide Spring Project, So no need to find out every Jars as it provides by Netbeans itself.

Ok Here we will create one Student Register Application demo.
Where first page will have URL redirect for New Student Registration Page.
When Registration done then view registration page will call.

Ok below is the screen dump showing my project structure.

And below is the Libraries added by Netbeans for Spring Project. You choose which you want to use.

Output:

Run http://localhost:8080/StudentSpringDemo/addStudent

1st Scrren:

2nd Screen:

3rd Screen:

Source Code:

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

(1) Web.xml

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

<?xml version="1.0" encoding="UTF-8"?>

<web-app version="3.0" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd">

<display-name>Spring MVC Form Handling With Nirav Raval</display-name>

<servlet-name>J2eeDeveloper</servlet-name>

<servlet-class>

org.springframework.web.servlet.DispatcherServlet

</servlet-class>

<load-on-startup>1</load-on-startup>

</servlet>

<servlet-mapping>

<servlet-name>J2eeDeveloper</servlet-name>

<url-pattern>/</url-pattern>

</servlet-mapping>

</web-app>

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

(2) J2eeDeveloper-servlet.xml

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

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

xmlns:context="http://www.springframework.org/schema/context"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="

http://www.springframework.org/schema/beans

http://www.springframework.org/schema/beans/spring-beans-3.0.xsd

http://www.springframework.org/schema/context

http://www.springframework.org/schema/context/spring-context-3.0.xsd">

<context:component-scan base-package="com.j2eedeveloper" />

</bean>

</beans>

---------------------------------------------------------------------------
(3) StudentController.java
---------------------------------------------------------------------------
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package com.j2eedeveloper;

import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.servlet.ModelAndView;
/**
*
* @author Nirav
*/
@Controller
public class StudentController {

@RequestMapping(value="/index", method= RequestMethod.GET)
public ModelAndView Startup(){
return new ModelAndView("index");

}

@RequestMapping(value="/student", method= RequestMethod.GET)
public ModelAndView Student(){
return new ModelAndView("Student", "command", new Student());
}

@RequestMapping(value="/addStudent", method = RequestMethod.POST)
public String addStudent(@ModelAttribute("SpringWeb")Student student, ModelMap model){
model.addAttribute("id", student.getId());
model.addAttribute("rollno", student.getRollno());
model.addAttribute("age", student.getAge());
model.addAttribute("name", student.getName());

return "result";
}
}

---------------------------------------------------------------------------
(4) index.jsp
---------------------------------------------------------------------------

<%--
    Document   : index
    Created on : July 19, 2013, 9:38:17 PM
    Author     : Nirav
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Spring MVC DemoWith Nirav</title>
    </head>
    <body>
        <h1>Spring MVC DemoWith Nirav</h1>
        <a href="/StudentSpringDemo/student/">Add Student</a>
    </body>
</html>

---------------------------------------------------------------------------
(5) Student.jsp
---------------------------------------------------------------------------

<%--
    Document   : Student
    Created on : Jun 10, 2013, 9:49:55 PM
    Author     : Nirav
--%>

<%@taglib uri="http://www.springframework.org/tags/form" prefix="form"%>
<html>
<head>
    <title>Spring MVC Form Handling With Nirav Raval</title>
</head>
<body>

<h2>Student Information</h2>
<form:form method="POST" action="/StudentSpringDemo/addStudent">
   <table>
    <tr>
        <td><form:label path="name">Name</form:label></td>
        <td><form:input path="name" /></td>
    </tr>
    <tr>
        <td><form:label path="age">Age</form:label></td>
        <td><form:input path="age" /></td>
    </tr>
    <tr>
        <td><form:label path="rollno">Roll No</form:label></td>
        <td><form:input path="rollno" /></td>
    </tr>
    <tr>
        <td><form:label path="id">id</form:label></td>
        <td><form:input path="id" /></td>
    </tr>
    <tr>
        <td colspan="2">
            <input type="submit" value="Submit"/>
        </td>
    </tr>
</table>
</form:form>
</body>
</html>

---------------------------------------------------------------------------
(6) result.jsp
---------------------------------------------------------------------------

<%--
    Document   : result
    Created on : Jun 19, 2013, 9:51:52 PM
    Author     : Nirav
--%>

<%@taglib uri="http://www.springframework.org/tags/form" prefix="form"%>
<html>
<head>
    <title>Spring MVC Form Handling With Nirav Raval</title>
</head>
<body>

<h2>Submitted Student Information</h2>
   <table>
    <tr>
        <td>Name</td>
        <td>${name}</td>
    </tr>
    <tr>
        <td>Age</td>
        <td>${age}</td>
    </tr>
    <tr>
        <td>Roll No</td>
        <td>${rollno}</td>
    </tr>
    <tr>
        <td>ID</td>
        <td>${id}</td>
    </tr>
</table>
</body>
</html>

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

Now run URL http://localhost:8080/StudentSpringDemo/addStudent in your browser.

Hope you find this helpful....!

2012-07-10T00:01:00.000-07:00

Basic Hibernate Tutorial

Hello Friends,

Nice to see you again.
In Previous Sessions we have seen Java Spring Basic Demo. And learn how they work.
Today, we will see the example of Hibernate basic tutorial in Java Swing..

So be ready to learn this simple exmaple of Basic Hibernate Tutorail in Swing Based Application..
After apply this code in action, you will be capable of using Hibernate in your Swing Applications.

What is Hibernate..?
Hibernate is a Java Based Powerful tool to implement databse access and operation in Java based Project (either window based or web based).
It gives capacity to access any database with simple Java Object.
Hibernate uses basic Java Object concept and access columns of Database table as an Object.

Hibernate works on POJO (Plain Old Java Object) concept.

Required JAR files to enable Hibernate functionality as shown below:
Add these jar files in your eclipse project under lib folder.

To use hibernate in your project follow below steps.

1) First create hibernate.cfg.xml file. As shown below.
This is the hibernate configeration file which includes database connection details.
For ex, databse driver registration, name of databse to be connect etc.

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



<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
<session-factory>
      <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
      <property name="hibernate.connection.url">jdbc:mysql://localhost/hibernatedatabase</property>
      <property name="hibernate.connection.username">root</property>
      <property name="hibernate.connection.password">root</property>
      <property name="hibernate.connection.pool_size">10</property>
      <property name="show_sql">true</property>
      <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
      <property name="hibernate.hbm2ddl.auto">update</property>
      <!-- Mapping files -->
      <mapping resource="contact.hbm.xml"/>
</session-factory>
</hibernate-configuration>

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

2) Then create database mapping file for ex. xyz.hbm.xml file As shown below "contact.hbm.xml".

This file is used to map the database Table column to the Java Object.

This gives power to developer to work with database table as it is a Java Object.

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


<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC 
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
  <class name="com.mapping.data.Contact" table="CONTACT">
    <id name="id" type="long" column="ID" >
    <generator class="assigned"/>
   </id>

   <property name="firstName">
   <column name="FIRSTNAME" />
   </property>
   <property name="lastName">
  <column name="LASTNAME"/>
   </property>
   <property name="email">
  <column name="EMAIL"/>
   </property>
   </class>

 </hibernate-mapping>

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

3) Then create a getter - setter Java Class which will set and get values for insert in or retrive from Database Table.

Create "Contact.java" class as shown below.
----------------------------------------------------------------------------------------------------------------------------------



package com.mapping.data;
/**
 * @author Nirav Raval
 *
 * http://www.niravjavadeveloper.blogspot.com
 * Java Class to map to the database Contact Table
 */

public class Contact {
 private String firstName;
 private String lastName;
 private String email;
 private long id;

 /**
  * @return Email
  */
 public String getEmail() {
  return email;
 }

 /**
  * @return First Name
  */
 public String getFirstName() {
  return firstName;
 }

 /** 
  * @return Last name
  */
 public String getLastName() {
  return lastName;
 }

 /**
  * @param string Sets the Email
  */
 public void setEmail(String string) {
  email = string;
  System.out.println("SetEmail = "+email);
 }

 /**
  * @param string Sets the First Name
  */
 public void setFirstName(String string) {
  firstName = string;
 }

 /**
  * @param string sets the Last Name
  */
 public void setLastName(String string) {
  lastName = string;
 }

 /**
  * @return ID Returns ID
  */
 public long getId() {
  return id;
 }

 /**
  * @param l Sets the ID
  */
 public void setId(long l) {
  id = l;
 }

}

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

4) Finally create main Java class which will use the above files to access database tables.

This main class have one hibenate Session which will use the hibernate config file to do the remaining works.

Create class "GUI.java" as shown below.
------------------------------------------------------------------------------------------------------------



package com.gui.adddata;

import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.awt.Insets;
import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.Vector;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextField;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

import com.mapping.data.Contact;

/**
 * 
 * @author Nirav Raval
 * Main class use to insert data in MySQL Table Contact.
 *
 */
public class GUI extends JFrame{

 private static Dimension lbSize=new Dimension(100, 30);
 private static Dimension jtSize=new Dimension(150, 25);
 
 private static long tid = 0;
 private static String fname = null;
 private static String lname = null;
 private static String email = null;
 
 static Session session = null;
 private static Vector<Long> value=new Vector<Long>();
 
 public GUI()
 {
  setTitle("Enter Data");
  JPanel panel=new JPanel();
  panel.setLayout(new GridBagLayout());
  GridBagConstraints cn=new GridBagConstraints();
  cn.insets=new Insets(5,5,5,5);
  
  cn.gridx=0;
  cn.gridy=0;
  JLabel lbID=new JLabel("ID");
  lbID.setPreferredSize(lbSize);
  panel.add(lbID,cn);
  
  cn.gridx=1;
  cn.gridy=0;
  final JTextField jtID=new JTextField();
  jtID.setPreferredSize(jtSize);
  panel.add(jtID,cn);
  
  cn.gridx=0;
  cn.gridy=1;
  JLabel lbName=new JLabel("First Name");
  lbName.setPreferredSize(lbSize);
  panel.add(lbName,cn);
  
  cn.gridx=1;
  cn.gridy=1;
  final JTextField jtName=new JTextField();
  jtName.setPreferredSize(jtSize);
  panel.add(jtName,cn);
  
  cn.gridx=0;
  cn.gridy=2;
  JLabel lbLastName=new JLabel("Last Name");
  lbLastName.setPreferredSize(lbSize);
  panel.add(lbLastName,cn);
  
  cn.gridx=1;
  cn.gridy=2;
  final JTextField jtLastName=new JTextField();
  jtLastName.setPreferredSize(jtSize);
  panel.add(jtLastName,cn);
  
  cn.gridx=0;
  cn.gridy=3;
  JLabel lbEmail=new JLabel("Email");
  lbEmail.setPreferredSize(lbSize);
  panel.add(lbEmail,cn);
  
  cn.gridx=1;
  cn.gridy=3;
  final JTextField jtEmail=new JTextField();
  jtEmail.setPreferredSize(jtSize);
  panel.add(jtEmail,cn);
  
  cn.gridwidth=2;
  cn.gridx=0;
  cn.gridy=4;
  JButton jbInsert=new JButton("Insert");
  panel.add(jbInsert,cn);
  
  getContentPane().add(panel,BorderLayout.NORTH);
  
  
  pack();
  
  Dimension screen = Toolkit.getDefaultToolkit().getScreenSize();
  // Center horizontally.
  int X = (screen.width / 2) - (this.getWidth()/ 2); 
  // Center vertically.
  int Y = (screen.height / 2) - (this.getHeight() / 2); 
  
  //Set Frame in Center of the screen
  this.setBounds(X,Y , this.getWidth(),this.getHeight());
  
  setVisible(true);
  setResizable(false);
  setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
  
  // Button ActionEvent
  
  jbInsert.addActionListener(new ActionListener() {
   
   @Override
   public void actionPerformed(ActionEvent arg0) {
    // TODO Auto-generated method stub
    tid = Integer.valueOf(jtID.getText());
    fname = jtName.getText();
    lname = jtLastName.getText();
    email = jtEmail.getText();
    int flag=0;
    
    //this class is used to check the id field in Contact table
    //of MySQL database.
    GetId gid=new GetId();
    
    value=gid.fetchId();
    
    for(int i=0;i<value.size();i++)
    {
     if(value.elementAt(i)==tid)
     {
      JOptionPane.showMessageDialog(null, 
        "Id Already Exist","Error",
        JOptionPane.ERROR_MESSAGE);
      flag=1;
     }
    }
    
    if(flag==0)
    {
     setData();
    }
    jtID.setText(null);
    jtName.setText(null);
    jtLastName.setText(null);
    jtEmail.setText(null);
    jtID.grabFocus();
   }
  });
 
  
 }
 
 /**
  * This method is used to insert data in MySQL Table
  * with the help of Hibernate Session.
  */
 private static void setData()
 {
  try{
   // This step will read hibernate.cfg.xml and 
   //      prepare hibernate for use
   SessionFactory sessionFactory = new 
   Configuration().configure().buildSessionFactory();
   session =sessionFactory.openSession();
   Transaction tx = session.beginTransaction();
   
    //Create new instance of Contact and set values in 
    // it by reading them from form object
     System.out.println("Inserting Record");
    Contact contact = new Contact();
    contact.setId(tid);
    contact.setFirstName(fname);
    contact.setLastName(lname);
    contact.setEmail(email);
    
    session.save(contact);
    tx.commit();
    JOptionPane.showMessageDialog(null,
      "Data inserted successfully!", 
      "Done",JOptionPane.INFORMATION_MESSAGE);
    
  }catch(Exception e){
  
   JOptionPane.showMessageDialog(null,e.getMessage(), 
     "Error",JOptionPane.ERROR_MESSAGE);
  }finally{
   // Actual contact insertion will happen at this step
   session.flush();
   session.close();

  }
 }
 
 
 
 public static void main(String s[])
 {
  new GUI();
 }
}

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

5) Now we have to create class "GetId.java" as shown below.

This class is used to check the ID in database.

So duplicate value can be avoided.

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




package com.gui.adddata;

import java.util.Iterator;
import java.util.Vector;

import org.hibernate.Query;
import org.hibernate.SessionFactory;

import org.hibernate.cfg.Configuration;
import org.hibernate.classic.Session;


public class GetId {
 private static Session session=null;
 
 public Vector<Long> fetchId()
 {
  Vector<Long> vID=new Vector<Long>();
  try{
   
   // This step will read hibernate.cfg.xml and 
   // prepare hibernate for use
   SessionFactory sessionFactory = new 
    Configuration().configure().buildSessionFactory();
   session =sessionFactory.openSession();
    
   // This step will read hibernate.cfg.xml and 
   // prepare hibernate for use
   String SQL_QUERY ="Select contact.id from Contact contact";
    Query query = session.createQuery(SQL_QUERY);
    
    for(Iterator<Long> it=query.iterate();it.hasNext();){
     vID.add(it.next());
    }
    
  }catch(Exception e){
   System.out.println(e.getMessage());
  }finally{
   session.flush();
   session.close();
  }
  
  return vID;
 }
 
}

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

OK. Now you have to run GUI.java class to check the result..

Just see the project folder how it looks like in eclipse as shown below.

Note: Before Run the class make sure you create one database called "hibernatedatabase"
in MySQl Database as shown below.

After run the class first you get following window to accept values from user.

After entering values as shown above, click Insert data will be added in database table and following message will be generated.

Now you can check in MySQL that the record is added as shown below.

So I hope this code is helpful in understanding the working of Hibernate in JAVA.

Feel free to ask me if you have any dought regarding this.
You can also give me suggessions to improve this tutorial.

Leave comments if you like this post...!

Thank you.
Nirav Raval

Spring Hello World

2011-06-27T08:54:00.000-07:00

Spring Hello World

Hello Friends,

Nice to see you again.

In Previous Session we have seen What is Spring.?. And learn theory aspect.

Today, we will see the example of Hello World with Spring Framework of Java.

So be ready to learn this simple example of Spring Framework Tutorail in JAVA Application..

After apply this code in action, you will be capable of using Spring in your Java Applications.

First Download the required JAR to run Spring Framework in Eclipse as shown Below.

To use Spring in your project follow below steps.

1) First create HelloWorld.java class file As shown below.

The HelloWorld class has a message property and its value is set using the

setMessage() method. This is called setter injection. Instead of directly hard

coding the message, we inject it through an external configuration file.

The design pattern used here is called Dependency Injection design pattern

The HelloWorld class also has a display() method to display the message.

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

package com.test;
/**
 *
 * @author Nirav Raval
 * this class is used to set Property Values.
 * and will display it to user.
 *
 */
public class HelloWorld {

 private String message;
 private String name;
 
 public void setMessage(String message) {

  this.message = message;
 }

 public void display()
 {
  System.out.println(message);
  System.out.println(name);
 } 
    public void setName(String name) {
  this.name = name;
 }
}

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

2) The next step is to add an entry for this in the bean configuration file.
The bean configuration file is used to configure the beans in the
Spring IoC container.

To create a new bean configuration file right click the src folder and select
New -> Spring Bean Configuration File.. Save as beans.xml file.

And write below lines in it.

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

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://www.springframework.org/schema/beans

http://www.springframework.org/schema/beans/spring-beans.xsd">

</bean>

</beans>

Here, If you want to display a differnt message, the only change you need
to is to change the value of the message in the bean configuration
file. This is one of the main benefits of using the Dependency Injection
design pattern, this makes the code loosely coupled.

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

3) Now Finally, To dispaly the message, create the following
HelloWorldApplication.java class.

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

package com.test;

/**
 * 
 * @author Nirav Raval
 * 
 */
import org.springframework.context.
      ApplicationContext;
import org.springframework.context.
       support.ClassPathXmlApplicationContext;

public class HelloWorldApplication {

 public static void main(String[] args) {
  
  ApplicationContext context = 
   new ClassPathXmlApplicationContext("beans.xml");
  
  HelloWorld helloWorld = 
   (HelloWorld) context.getBean("helloWorld");
  
  helloWorld.display();
   
  }
}

After done above steps our directory structure of project in Eclipse PAckage Explorer is as below.

Ok this is done. Now run HelloWorldApplication.java to see output in console.

The output will be like as shown below.

What we are doing here is,
First we instantiate the Spring IoC container with the bean configuration file beans.xml.
We use the getBean() method to retrive the helloWorld bean from the application context
and call the display() method to display the message in the console.
---------------------------------------------------------------------------------------------------------------

So I hope this code is helpful in understanding the working of Spring
Framework in JAVA.

Feel free to ask me if you have any dought regarding this.
You can also give me suggessions to improve this tutorial.

Leave comments if you like this post...!

Thank you.
Nirav Raval

What is Spring

2011-06-22T09:23:00.000-07:00

What is Spring.?

Hello Friends,

Nice to see you again.

In Previous Sessions we have seen Spring Setup in Eclipse IDE..

Now this is the basic core explanation of Spring Framework of JAVA.

So be ready to learn this simple exmaple of Spring Framework..

What is Spring..?

By definition the Spring Framework is “An open-source layered Java/J2EE application framework having a light-weight container implementing Inversion-of-Control and Aspect Oriented Programming.”

The key points here are “layered application framework” and “Inversion of Control and Aspect Oriented Programming.”

These key points can be divided into two broad categories:

1) Patterns

2) Components of the Framework

The former refers to the design patterns supported by Spring Framework

And the latter refers to the components that build up the Framework.

Spring has two patterns at its core. They are:

1) Inversion-of-Control

2) Aspect Oriented Programming

The former is also called IoC and

The latter is known as AOP. Here are the details.

Inversion-of-Control :

It is called IoC for short. IoC “is a concept, and an associated set of programming techniques, in which the control flow is inverted compared to the traditional interaction model expressed in imperative style by a series of procedure calls.”

In other words, the framework calls the procedures created by the programmer, rather than programmer calling the procedures or methods of the framework. IoC is also known as the “Hollywood Principle.” The Hollywood Principle says “Don’t call me, I will call you.”

IoC is used to ‘inject’ dependencies at runtime. When one uses this pattern, the dependencies of a particular object are not satisfied at compile time. Instead, the framework provides the required dependencies to the object at runtime. Thus, this pattern releases the programmer from the chore of providing all the dependencies at compile time.

Aspect Oriented Programming:

AOP for short, is by definition “An approach to programming that attempts the separation of concerns, specifically cross-cutting concerns, as an advance in modularization.”

Here, the key point is separation of concerns. Concern is another term for a module of an application, where module refers to a functionality of the application.

Separation of concerns means that the applications are divided into modules that do not overlap in terms of functionality. However, some functionalities or modules/concerns always overlap other modules/concerns. Logging is an example of such a concern.

AOP provides techniques to encapsulate cross cutting or overlapping concerns. In other words, by using AOP a developer can encapsulate cross cutting concerns.

Spring provides both IoC as well as AOP. They are built into the core of the Spring Framework. The next aspect of the Spring Framework worth noting is its support for layered architecture. It provides this support through its various components. Some of them are:

MVC Component

IOC container

DAO support

These three cater to the Presentation, Business, and Persistence layers. Here is a brief overview:

MVC Component:
The flexibility of the Spring Framework is that one can use any MVC framework with it. However, it also provides its own framework, called Spring MVC. Spring MVC implements MVC-Model 2 for JSP. It does this by providing controller Servlet and JSP taglib for you to view.

IoC Container:
The business logic layer can be developed without coupling it with any other layers by using IoC provided by the Spring Framework. The IoC container is the core component of the framework. IoC lets the developer implement the business logic as Plain Old Java Objects (POJO) and wire them up so that they can be injected or called at runtime. This approach lets you avoid specifying the business objects as dependencies at compile time.

DAO Support:
Any of the technologies, including JDBC, Hibernate, and iBatis, can be used with the Spring Framework to access persisted data. The Spring Framework provides this functionality through its DAO support component. A developer can plug in almost any of the persistence framework by using the DAO component.

That completes the bird’s eye view of the Spring Framework. Next, let us have a look at the steps involved in using the Spring Framework, specifically the IoC capability of the Spring Framework.

check here for Detailed Overview Of Spring:
http://www.opensourcelive.com/Denver/springbasics.pdf

So I hope this explanation is helpful in understanding the Spring Framework in JAVA.

Feel free to ask me if you have any dought regarding this.

You can also give me suggessions to improve this tutorial.

Leave comments if you like this post...!

Thank you.

Nirav Raval

Spring Setup in Eclipse IDE

2011-06-20T06:53:00.001-07:00

Spring Setup in Eclipse IDE

Hello Friends,

Today, we will see the plugin setup of Spring Framework in Eclipse IDE.

Here I am using Eclipse 3.4.1 for demonstration.

You can use any version for this, ther is not much changes in different

version of Eclipse.

The name of plugin for Spring is Spring IDE.

1) To install Spring IDE, Go to Help -> Software Updates.

Note: If you are using Eclipse Helios then it will
Help -> Install New Software...

2) Then, Click the "Add Site" button and enter
"http://springide.org/updatesite"
in the Add Site popup.

3) Select all the Spring IDE features and click Install.

Once the installation is complete you are done.

4) Now let's see how to create new Spring Project using the Spring IDE.

go to File -> New -> Project.

Then Select Spring Project From List

So I hope this explanation is helpful in setting the Spring IDE in Eclipse.

Feel free to ask me if you have any dought regarding this.

You can also give me suggessions to improve this tutorial.

Leave comments if you like this post...!

Thank you.

Nirav Raval