This is a complete web application of spring jdbc module of spring framework
First we write presentation logic
index.html
1 2 3 4 5 6 | <html> <frameset cols="30%,*" > <frame src="list.html"> <frame name="f2"> </frameset> </html> |
list.html
1 2 3 4 5 6 7 8 9 | <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 |
newaccount.html
1 2 3 4 5 6 7 8 9 10 11 | <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> |
delete.html
1 2 3 4 5 6 7 8 9 10 | <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> |
transaction.html
1 2 3 4 5 6 7 8 9 10 | <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> |
web.xml
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 | <?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> |
applicationContext.xml
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 | <?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> |
Templet.java
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 | 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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 | 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; } } |
insertsevlet.java
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 | 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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | 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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 | 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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 | 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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 | 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); } } |