spring Archives

BeanFactory and Bean Definitions

June 30, 2023June 30, 2023 by manish

The BeanFactory and ApplicationContext is the actual container which instantiates, configures, and manages a number of beans. A BeanFactory comes by the interface org.springframework.beans.factory.BeanFactory, for which there are multiple implementations ApplicationContext comes in spring j2ee modules i.e spring 2.5 Activating spring beanFactory container is not but creating object for class that implements “org.springframework.beans.factory.BeanFactory” interface. ApplicationContexts … Read more

Inversion of Control/Dependency Injection

June 30, 2023June 30, 2023 by manish

The basic principle is that beans define their dependencies (i.e. the other objects they work with) only through constructor arguments, arguments to a factory method, or properties which are set on the object instance after it has been constructed or returned from a factory method Dependency Injection are of two types 1 Constructor based dependency … Read more

Spring configuration first example

June 30, 2023June 30, 2023 by manish

Resource of spring core module Applications are used 1 Spring interface. 2 Spring bean class. 3 Spring- configuration file. 4 Client Applications All the spring releted jar files put in lib folder directory structure is same as normal java/j2ee applications. Demo.xml

<!--?xml version="1.0" encoding="UTF-8"?--> 
 
<beans>
      <bean id="demo" class="s1.DemoInterImpl">
	<property name="message">
		<value>hello</value>
	</property>
      </bean>
</beans>

<beans>

<value>hello</value>

</property>

</bean>

</beans>

This example is setter base dependency injection this xml file is spring configuration … Read more

Spring Bean Example

June 30, 2023June 30, 2023 by manish

This application is the example of been collaboration that means one bean injecting the information of other beans Book.java

package s2;

public class Book
{
    private  int bid;
	private String bname;
	private double price;
	public Book(){}
	public Book(int bid,String bname,double price)
	{
		this.bid=bid;
		this.bname=bname;
		this.price=price;
	}
	public String toString()
	{
		return bid+"  "+bname+"  "+price;
	}
	public void setBid(int n){  bid=n; }
	public int getBid(){ return bid; }
	public void setBname(String s){ bname=s; }
	public String getBname(){ return bname; }
	public void setPrice(double d){ price=d; }
	public double getPrice(){ return price; }
}

package s2;

public class Book

{

private int bid;

private String bname;

private double price;

public Book(){}

public Book(int bid,String bname,double price)

{

this.bid=bid;

this.bname=bname;

this.price=price;

}

public String toString()

{

return bid+" "+bname+" "+price;

}

public void setBid(int n){ bid=n; }

public int getBid(){ return bid; }

public void setBname(String s){ bname=s; }

public String getBname(){ return bname; }

public void setPrice(double d){ price=d; }

public double getPrice(){ return price; }

}

This is normal pojo class BookInter.java

package s2;

import java.util.*;
public interface  BookInter  
{
        public Book getBook(int id);
        public List getBooks();
}
This is normal interface which contain only abstract methods
	3	BookInterImpl.java
package s2;

import java.util.*;
public class BookInterImpl  implements  BookInter
{
           private List  books=new ArrayList();
           public BookInterImpl()
           {
	books.add(new Book(1001,"java",560));
	books.add(new Book(1002,"oracle",450));
	books.add(new Book(1003,"j2ee",700));
	books.add(new Book(1004,"j2me",1560));
            }
           public Book getBook(int id)
           {
	      Iterator i1=books.iterator();
	       while(i1.hasNext())
	       {
		Book b=(Book)i1.next();
		if(b.getBid() == id)
		      return b;
	        }
	       return null;
	         
            }
             public List  getBooks()
             {
	return books;
              }
           
}

package s2;

import java.util.*;

public interface BookInter

{

public Book getBook(int id);

public List getBooks();

}

This is normal interface which contain only abstract methods

3 BookInterImpl.java

package s2;

import java.util.*;

public class BookInterImpl implements BookInter

{

private List books=new ArrayList();

public BookInterImpl()

{

books.add(new Book(1001,"java",560));

books.add(new Book(1002,"oracle",450));

books.add(new Book(1003,"j2ee",700));

books.add(new Book(1004,"j2me",1560));

}

public Book getBook(int id)

{

Iterator i1=books.iterator();

while(i1.hasNext())

{

Book b=(Book)i1.next();

if(b.getBid() == id)

return b;

}

return null;

}

public List getBooks()

{

return books;

}

this is implementation details class file CommandLineView.java

package s2;

import java.util.*;
public class  CommandLineView
{
	BookInter  binter;
	public void setBinter(BookInter  b1)
	{
		binter=b1;
	}
           
             public void printBook(int id)
             {	           System.out.println("PARTICULAR BOOK INFORMATION :"+id);
	           System.out.println(binter.getBook(id));
             }
            public void printAllBooks()
            {
		System.out.println("ALL BOOKS INFORMATION..");
		List  books=binter.getBooks();
		Iterator  i1=books.iterator();
		while(i1.hasNext())
		{
			Book b=(Book)i1.next();
			System.out.println(b);
		}		
              }
}

package s2;

import java.util.*;

public class CommandLineView

{

BookInter binter;

public void setBinter(BookInter b1)

{

binter=b1;

}

public void printBook(int id)

{ System.out.println("PARTICULAR BOOK INFORMATION :"+id);

System.out.println(binter.getBook(id));

}

public void printAllBooks()

{

System.out.println("ALL BOOKS INFORMATION..");

List books=binter.getBooks();

Iterator i1=books.iterator();

while(i1.hasNext())

{

Book b=(Book)i1.next();

System.out.println(b);

}

this class displaying the out put. book.xml

<!--?xml version="1.0" encoding="UTF-8"?--> 
 
<beans>
     <bean id="b1" class="s2.BookInterImpl">
     </bean>
     <bean id="c1" class="s2.CommandLineView">
	<property name="binter">
		<ref bean="b1">
	</ref></property>
      </bean>
</beans>
This xml file is spring configuration file store all beans
	5	ClientApp.java
package s2;

import org.springframework.core.io.*;
import org.springframework.beans.factory.*;
import org.springframework.beans.factory.xml.*;
public class ClientApp
{
       public static void main(String args[])
       {
	  Resource  res=new ClassPathResource("s2/Book.xml");
	  BeanFactory factory=new XmlBeanFactory(res);
	   CommandLineView  clv=(CommandLineView)factory.getBean("c1");
	  clv.printBook(1002);
	  clv.printAllBooks();
       }
}

<beans>

</bean>

</ref></property>

</bean>

</beans>

This xml file is spring configuration file store all beans

5 ClientApp.java

package s2;

import org.springframework.core.io.*;

import org.springframework.beans.factory.*;

import org.springframework.beans.factory.xml.*;

public class ClientApp

{

public static void main(String args[])

{

Resource res=new ClassPathResource("s2/Book.xml");

BeanFactory factory=new XmlBeanFactory(res);

CommandLineView clv=(CommandLineView)factory.getBean("c1");

clv.printBook(1002);

clv.printAllBooks();

}

This is client application of all application Output

PARTICULAR BOOK INFORMATION :1002
1002  oracle  450.0
ALL BOOKS INFORMATION..
1001  java  560.0
1002  oracle  450.0
1003  j2ee  700.0
1004  j2me  1560.0

PARTICULAR BOOK INFORMATION :1002

1002 oracle 450.0

ALL BOOKS INFORMATION..

1001 java 560.0

1002 oracle 450.0

1003 j2ee 700.0

1004 j2me 1560.0

Spring Transaction Management

June 30, 2023June 30, 2023 by manish

Provides a consistent abstraction for transaction management. This abstraction is one of the most important of Spring’s abstractions wethout transaction data definition language operation is not perform, and delivers the following benefits: 1 Provides a consistent programming model across different ORM Database Layer and JDO. 2 Provides a simpler, easier to use, API for programmatic … Read more

Spring DAO

June 30, 2023June 30, 2023 by manish

This module provide the abstraction layer of spring related application Dao Support classes are : JdbcDaoSupport – Super class for JDBC data access objects. Requires a DataSource to be set, providing a JdbcTemplate based on it to sub classes. HibernateDaoSupport – Super class for Hibernate data access objects. Requires a SessionFactory to be set,providing a … Read more

Spring MVC Basics

June 30, 2023June 30, 2023 by manish

Spring mvc module provide the complete mvc architecture pattern implementation by only spring framework presentation layer implemented through jsp. Front controller is written in servlet and business logic is provided through special controller. In spring 2.5 provides spring mvc and spring web module are combined there is no need separate jar files. In this module … Read more

Spring Aspect Oriented Programming

February 2, 2023February 2, 2023 by manish

AOP is a Aspect Oriented Programming not a object oriented programming this is a methodology to provide other middle ware services such as security transaction management etc. Spring AOP is implemented in pure Java. There is no need for a special compilation process. Spring AOP does not need to control the class loader hierarchy, and … Read more

Features of Spring framework

February 2, 2023February 2, 2023 by manish

Feature of Spring framework is as follow 1. Spring support pojo class and poji interface programming. 2. Spring generate common logic application dynamically and improve application development and productivity 3. Spring can we used all types of logic and all types of application. 4. Spring can we used as independent software or can we used … Read more

Spring web application

May 13, 2023January 11, 2023 by manish

This is a complete web application of spring jdbc module of spring framework First we write presentation logic index.html

<html>
<frameset  cols="30%,*" >
        <frame  src="list.html">
       <frame  name="f2">
</frameset>
</html>

<html>

</frameset>

</html>

list.html

<html>
<body bgcolor="#ffffcc text=olive alink=olive vlink=olive link=olive">
<h3><center><br><br><br><br>

<a href="newaccount.html" target="f2" rel="noopener noreferrer"> new account</a> <br><br>
<a href="delete.html" target="f2" rel="noopener noreferrer">delete account</a><br><br>
<a href="transaction.html" target="f2" rel="noopener noreferrer">transactions</a><br><br>
</body>
</html> this html file display all types of funcanility like this

<html>

<a href="newaccount.html" target="f2" rel="noopener noreferrer"> new account</a> <br><br>

<a href="delete.html" target="f2" rel="noopener noreferrer">delete account</a><br><br>

<a href="transaction.html" target="f2" rel="noopener noreferrer">transactions</a><br><br>

</body>

</html> this html file display all types of funcanility like this

newaccount.html

<html>
<body bgcolor="#ffffcc" text="olive">
<h1><center>new a/c information</h1><hr><br><br>
<form action="/bankapp/insertaction">
    enter a/c number :<input type="text" name="t1"><br><br>
    enter a/c holdername :<input type="text" name="t2"><br><br>
    enter a/c balance :<input type="text" name="t3"><br><br>  
	<input type=submit value="insert" >
</form>
</body>
</html>

<html>

<h1><center>new a/c information</h1><hr><br><br>

enter a/c number :<input type="text" name="t1"><br><br>

enter a/c holdername :<input type="text" name="t2"><br><br>

enter a/c balance :<input type="text" name="t3"><br><br>

</form>

</body>

</html>

delete.html

<html>
<body bgcolor=#ffffcc text=olive>
<h1><center>delete a/c information</h1><hr><br><br>
<form action="/bankapp/deleteaction">
    enter a/c number :<input type="text" name="id"><br><br>
  
	<input type=submit value="delete" >
</form>
</body>
</html>

<html>

<h1><center>delete a/c information</h1><hr><br><br>

enter a/c number :<input type="text" name="id"><br><br>

</form>

</body>

</html>

transaction.html

<html>
<body bgcolor="#ffffcc" text="olive">
<h1><center>request a/c information</h1><hr><br><br>
<form action="/bankapp/showaction">
    enter a/c number :<input type="text" name="id"><br><br>
  
	<input type="submit" value="get info" >
</form>
</body>
</html>

<html>

<h1><center>request a/c information</h1><hr><br><br>

enter a/c number :<input type="text" name="id"><br><br>

</form>

</body>

</html>

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
   
    <session-config>
        <session-timeout>
            30
        </session-timeout>
    </session-config>
    <welcome-file-list>
        <welcome-file>redirect.jsp</welcome-file>
        </welcome-file-list>


         <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>/WEB-INF/applicationContext.xml</param-value>
    </context-param>
     <servlet>
        <servlet-name>dispatcher</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <load-on-startup>2</load-on-startup>
    </servlet>
    <servlet-mapping>
        <servlet-name>dispatcher</servlet-name>
        <url-pattern>*.htm</url-pattern>
    </servlet-mapping>
<servlet>
        <servlet-name>select</servlet-name>
        <servlet-class>selectservlet</servlet-class>
    </servlet>

    <servlet-mapping>
        <servlet-name>select</servlet-name>
        <url-pattern>/selectaction</url-pattern>
    </servlet-mapping>
 <servlet>
        <servlet-name>insert</servlet-name>
        <servlet-class>insertservlet</servlet-class>
    </servlet>

    <servlet-mapping>
        <servlet-name>insert</servlet-name>
        <url-pattern>/insertaction</url-pattern>
    </servlet-mapping>
 <servlet>
        <servlet-name>delete</servlet-name>
        <servlet-class>deleteservlet</servlet-class>
    </servlet>

    <servlet-mapping>
        <servlet-name>delete</servlet-name>
        <url-pattern>/deleteaction</url-pattern>
    </servlet-mapping>
 <servlet>
        <servlet-name>show</servlet-name>
        <servlet-class>showservlet</servlet-class>
    </servlet>

    <servlet-mapping>
        <servlet-name>show</servlet-name>
        <url-pattern>/showaction</url-pattern>
    </servlet-mapping>
<servlet>
        <servlet-name>update</servlet-name>
        <servlet-class>updateservlet</servlet-class>
    </servlet>

    <servlet-mapping>
        <servlet-name>update</servlet-name>
        <url-pattern>/updateaction</url-pattern>
    </servlet-mapping>

    </web-app>

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

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

<session-config>

<session-timeout>

</session-timeout>

</session-config>

<welcome-file-list>

<welcome-file>redirect.jsp</welcome-file>

</welcome-file-list>

<context-param>

<param-name>contextConfigLocation</param-name>

<param-value>/WEB-INF/applicationContext.xml</param-value>

</context-param>

<servlet-name>dispatcher</servlet-name>

<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>

<load-on-startup>2</load-on-startup>

</servlet>

<servlet-mapping>

<servlet-name>dispatcher</servlet-name>

<url-pattern>*.htm</url-pattern>

</servlet-mapping>

<servlet-name>select</servlet-name>

<servlet-class>selectservlet</servlet-class>

</servlet>

<servlet-mapping>

<servlet-name>select</servlet-name>

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

</servlet-mapping>

<servlet-name>insert</servlet-name>

<servlet-class>insertservlet</servlet-class>

</servlet>

<servlet-mapping>

<servlet-name>insert</servlet-name>

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

</servlet-mapping>

<servlet-name>delete</servlet-name>

<servlet-class>deleteservlet</servlet-class>

</servlet>

<servlet-mapping>

<servlet-name>delete</servlet-name>

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

</servlet-mapping>

<servlet-name>show</servlet-name>

<servlet-class>showservlet</servlet-class>

</servlet>

<servlet-mapping>

<servlet-name>show</servlet-name>

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

</servlet-mapping>

<servlet-name>update</servlet-name>

<servlet-class>updateservlet</servlet-class>

</servlet>

<servlet-mapping>

<servlet-name>update</servlet-name>

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

</servlet-mapping>

</web-app>

applicationContext.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:p="http://www.springframework.org/schema/p"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
       http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
       http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd">
    
    <bean id="propertyConfigurer"
          class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"
          p:location="/WEB-INF/jdbc.properties" />
    
    <bean id="ds" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
     <property  name="driverClassName" ><value>com.mysql.jdbc.Driver</value></property>
	<property  name="url" ><value>jdbc:mysql://localhost:3306/ebhor</value></property>
	<property  name="username" ><value>root</value></property>
	<property  name="password" ><value>root</value></property>
     </bean>
    <bean id="s1"  class="dsimpl">
	<property name="dsource">
		<ref  bean="ds" />
	</property>
    </bean>
    
    <!-- ADD PERSISTENCE SUPPORT HERE (jpa, hibernate, etc) -->
    
</beans>

<?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:p="http://www.springframework.org/schema/p"

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

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

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

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

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

<bean id="propertyConfigurer"

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

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

<property name="driverClassName" ><value>com.mysql.jdbc.Driver</value></property>

<property name="url" ><value>jdbc:mysql://localhost:3306/ebhor</value></property>

</bean>

</property>

</bean>

</beans>

Templet.java

import javax.sql.*;
import org.springframework.core.io.*;
import org.springframework.beans.factory.*;
import org.springframework.beans.factory.xml.*;
import org.springframework.jdbc.core.*;
public class  Template
{
      public static JdbcTemplate  getTemplate()
      {

	try{
	Resource  res=new ClassPathResource("applicationContext.xml");
	BeanFactory  factory=new XmlBeanFactory(res);
	dsinter  i1=(dsinter)factory.getBean("s1");
	DataSource ds=i1.getSource();
	return new JdbcTemplate(ds);
	}catch(Exception e){ System.out.println(e); }	
	return null;
         }
}

import javax.sql.*;

import org.springframework.core.io.*;

import org.springframework.beans.factory.*;

import org.springframework.beans.factory.xml.*;

import org.springframework.jdbc.core.*;

public class Template

{

public static JdbcTemplate getTemplate()

{

try{

Resource res=new ClassPathResource("applicationContext.xml");

BeanFactory factory=new XmlBeanFactory(res);

dsinter i1=(dsinter)factory.getBean("s1");

DataSource ds=i1.getSource();

return new JdbcTemplate(ds);

}catch(Exception e){ System.out.println(e); }

return null;

}

dsinter.java

import javax.sql.*;
public interface  dsinter
{
	public DataSource getSource();
}

<strong>dsimpl.java</strong>
<pre brush="java">
import javax.sql.*;
public class  dsimpl implements dsinter
{	private  DataSource  dsource;
	public void setDsource(DataSource ds)
	{
		dsource=ds;
	}
	public DataSource getSource()
	{
		return dsource;
	}
}

import javax.sql.*;

public interface dsinter

{

public DataSource getSource();

}

<strong>dsimpl.java</strong>

import javax.sql.*;

public class dsimpl implements dsinter

{ private DataSource dsource;

public void setDsource(DataSource ds)

{

dsource=ds;

}

public DataSource getSource()

{

return dsource;

}

insertsevlet.java

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import org.springframework.jdbc.core.*;
public class  insertservlet  extends HttpServlet
{
       public void service(HttpServletRequest request,HttpServletResponse response)
	throws ServletException,IOException
       {
	    PrintWriter out=response.getWriter();
	   int acno=Integer.parseInt(request.getParameter("t1"));
	   String acname=request.getParameter("t2");
	   double balance=Double.parseDouble(request.getParameter("t3"));
	try{
	JdbcTemplate   jt=Template.getTemplate();
	jt.execute("insert into bank values("+acno+",'"+acname+"',"+balance+")");	
	}catch(Exception e)
	{
		System.out.println(e);
	}
	RequestDispatcher rd=request.getRequestDispatcher("newaccount.html");
	rd.forward(request,response);
        }
}

import javax.servlet.*;

import javax.servlet.http.*;

import java.io.*;

import org.springframework.jdbc.core.*;

public class insertservlet extends HttpServlet

{

public void service(HttpServletRequest request,HttpServletResponse response)

throws ServletException,IOException

{

PrintWriter out=response.getWriter();

int acno=Integer.parseInt(request.getParameter("t1"));

String acname=request.getParameter("t2");

double balance=Double.parseDouble(request.getParameter("t3"));

try{

JdbcTemplate jt=Template.getTemplate();

jt.execute("insert into bank values("+acno+",'"+acname+"',"+balance+")");

}catch(Exception e)

{

System.out.println(e);

}

RequestDispatcher rd=request.getRequestDispatcher("newaccount.html");

rd.forward(request,response);

}

deleteservlet.java

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import org.springframework.jdbc.core.*;
public class  deleteservlet  extends HttpServlet
{
       public void service(HttpServletRequest request,HttpServletResponse response)
	throws ServletException,IOException
       {
	    PrintWriter out=response.getWriter();
	   int id=Integer.parseInt(request.getParameter("id"));
	
	try{
	JdbcTemplate   jt=Template.getTemplate();
	jt.execute("delete bank where acno="+id);	
	}catch(Exception e)
	{
		System.out.println(e);
	}
	RequestDispatcher rd=request.getRequestDispatcher("delete.html");
	rd.forward(request,response);
        }
}

import javax.servlet.*;

import javax.servlet.http.*;

import java.io.*;

import org.springframework.jdbc.core.*;

public class deleteservlet extends HttpServlet

{

public void service(HttpServletRequest request,HttpServletResponse response)

throws ServletException,IOException

{

PrintWriter out=response.getWriter();

int id=Integer.parseInt(request.getParameter("id"));

try{

JdbcTemplate jt=Template.getTemplate();

jt.execute("delete bank where acno="+id);

}catch(Exception e)

{

System.out.println(e);

}

RequestDispatcher rd=request.getRequestDispatcher("delete.html");

rd.forward(request,response);

}

selectservlet.java

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import javax.sql.*;
import org.springframework.core.io.*;
import org.springframework.beans.factory.*;
import org.springframework.beans.factory.xml.*;
import org.springframework.jdbc.core.*;
import org.springframework.jdbc.support.rowset.*;
public class  selectservlet  extends HttpServlet
{
       public void service(HttpServletRequest request,HttpServletResponse response)
	throws ServletException,IOException
       {
	    PrintWriter out=response.getWriter();

	try{
          JdbcTemplate   jt=Template.getTemplate();
	SqlRowSet  rs=jt.queryForRowSet("select * from bank");
	out.println("<html><body bgcolor=#ffffcc text=olive>");
	out.println("<h1><center>all accounts information</h1><hr><br><h3>");
	out.println("<table align=center width=80% border=2>");
	out.println("<tr><th>a/c number<th>a/c holder name <th>open balance</tr>");
	while(rs.next())
	{
		out.println("<tr><td>"+rs.getString(1)+"<td>"+rs.getString(2)+" <td>"+rs.getString(3)+"</tr>");
	}
	
	out.println("</table></body></html>");	

	}catch(Exception e)
	{
		System.out.println(e);
	}
        }
}

import javax.servlet.*;

import javax.servlet.http.*;

import java.io.*;

import javax.sql.*;

import org.springframework.core.io.*;

import org.springframework.beans.factory.*;

import org.springframework.beans.factory.xml.*;

import org.springframework.jdbc.core.*;

import org.springframework.jdbc.support.rowset.*;

public class selectservlet extends HttpServlet

{

public void service(HttpServletRequest request,HttpServletResponse response)

throws ServletException,IOException

{

PrintWriter out=response.getWriter();

try{

JdbcTemplate jt=Template.getTemplate();

SqlRowSet rs=jt.queryForRowSet("select * from bank");

out.println("<html><body bgcolor=#ffffcc text=olive>");

out.println("<h1><center>all accounts information</h1><hr><br><h3>");

out.println("<table align=center width=80% border=2>");

out.println("<tr><th>a/c number<th>a/c holder name <th>open balance</tr>");

while(rs.next())

{

out.println("<tr><td>"+rs.getString(1)+"<td>"+rs.getString(2)+" <td>"+rs.getString(3)+"</tr>");

}

out.println("</table></body></html>");

}catch(Exception e)

{

System.out.println(e);

}

showservlet.java

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import org.springframework.jdbc.core.*;
import org.springframework.jdbc.support.rowset.*;
public class  showservlet  extends HttpServlet
{
       public void service(HttpServletRequest request,HttpServletResponse response)
	throws ServletException,IOException
       {
	    PrintWriter out=response.getWriter();
	   int id=Integer.parseInt(request.getParameter("id"));
	try{

	JdbcTemplate   jt=Template.getTemplate();
	SqlRowSet  rs=jt.queryForRowSet("select * from bank where acno="+id);
	out.println("<html><body bgcolor=#ffffcc text=olive>");
	out.println("<h1><center>a/c information</h1><hr><br><h3>");
	if(rs.next())
	{
		out.println("<form action='/bankapp/updateaction'>");
		out.println("a/c number :<input type=text name=t1 value='"+rs.getString(1)+"' readonly><br><br>");
		out.println("a/c number :<input type=text name=t2 value='"+rs.getString(2)+"' readonly><br><br>");
		out.println("a/c number :<input type=text name=t3 value='"+rs.getString(3)+"' ><br><br>");
		out.println("<input type=submit value=update>");
		out.println("</form>");
	}
	


	}catch(Exception e)
	{
		System.out.println(e);
	}
        }
}

import javax.servlet.*;

import javax.servlet.http.*;

import java.io.*;

import org.springframework.jdbc.core.*;

import org.springframework.jdbc.support.rowset.*;

public class showservlet extends HttpServlet

{

public void service(HttpServletRequest request,HttpServletResponse response)

throws ServletException,IOException

{

PrintWriter out=response.getWriter();

int id=Integer.parseInt(request.getParameter("id"));

try{

JdbcTemplate jt=Template.getTemplate();

SqlRowSet rs=jt.queryForRowSet("select * from bank where acno="+id);

out.println("<html><body bgcolor=#ffffcc text=olive>");

out.println("<h1><center>a/c information</h1><hr><br><h3>");

if(rs.next())

{

out.println("<form action='/bankapp/updateaction'>");

out.println("a/c number :<input type=text name=t1 value='"+rs.getString(1)+"' readonly><br><br>");

out.println("a/c number :<input type=text name=t2 value='"+rs.getString(2)+"' readonly><br><br>");

out.println("a/c number :<input type=text name=t3 value='"+rs.getString(3)+"' ><br><br>");

out.println("<input type=submit value=update>");

out.println("</form>");

}

}catch(Exception e)

{

System.out.println(e);

}

updateservlet.java

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import org.springframework.jdbc.core.*;
public class  updateservlet  extends HttpServlet
{
       public void service(HttpServletRequest request,HttpServletResponse response)
	throws ServletException,IOException
       {
	    PrintWriter out=response.getWriter();
	   int acno=Integer.parseInt(request.getParameter("t1"));
	   String acname=request.getParameter("t2");
	   double balance=Double.parseDouble(request.getParameter("t3"));
	try{
	JdbcTemplate   jt=Template.getTemplate();
	jt.update("update bank set balance=? where acno=?",new Object[]{new Double(balance),new Integer(acno)});	
	}catch(Exception e)
	{
		System.out.println(e);
	}
	RequestDispatcher rd=request.getRequestDispatcher("transaction.html");
	rd.forward(request,response);
        }
}

import javax.servlet.*;

import javax.servlet.http.*;

import java.io.*;

import org.springframework.jdbc.core.*;

public class updateservlet extends HttpServlet

{

public void service(HttpServletRequest request,HttpServletResponse response)

throws ServletException,IOException

{

PrintWriter out=response.getWriter();

int acno=Integer.parseInt(request.getParameter("t1"));

String acname=request.getParameter("t2");

double balance=Double.parseDouble(request.getParameter("t3"));

try{

JdbcTemplate jt=Template.getTemplate();

jt.update("update bank set balance=? where acno=?",new Object[]{new Double(balance),new Integer(acno)});

}catch(Exception e)

{

System.out.println(e);

}

RequestDispatcher rd=request.getRequestDispatcher("transaction.html");

rd.forward(request,response);

}