package  example;

 import  java.io.IOException;
 import  java.sql.*;

 import  javax.servlet.ServletException;
 import  javax.servlet.http.HttpServletRequest;
 import  javax.servlet.http.HttpServletResponse;
 import  javax.sql.DataSource;
 import  javax.naming.InitialContext;
 import  javax.naming.NamingException;

 import  org.springframework.web.servlet.ModelAndView;
 import  org.springframework.web.servlet.mvc.Controller;
 import  org.apache.commons.logging.Log;
 import  org.apache.commons.logging.LogFactory;

 public   class  ExampleController  implements  Controller {

     private   final   static  Log LOG = LogFactory.getLog(ExampleController. class );

     private   static   final  DataSource getDataSource()
    {
        DataSource result =  null ;
        InitialContext ctx =  null ;
         try  {
            ctx =  new  InitialContext();
            result =
                    (DataSource)ctx.lookup("java:comp/env/jdbc/OracleDS");
        }  catch  (NamingException ne) {
            LOG.error(e);
        }  finally  {
             if (ctx !=  null ) {
                 try  {
                    ctx.close();
                }  catch  (NamingException ne) {}
            }
        }
         return  result;
    }

     public  ModelAndView handleRequest(
            HttpServletRequest request,
            HttpServletResponse response)
             throws  ServletException, IOException {
        DataSource ds = getDataSource();
         if (ds!= null )
        {
             try {
                Connection conn = ds.getConnection();
                Statement stmt = conn.createStatement();
                ResultSet rs = stmt.executeQuery("select sysdate from dual");
                Timestamp time =  null ;
                 while (rs.next())
                  time = rs.getTimestamp( 1 );
                request.setAttribute("CURRENT_DATETIME",time);
                rs.close();
                stmt.close();
                conn.close();
            }  catch  (SQLException e) {
                LOG.error(e);
            }
        }
         return   new  ModelAndView("/test.jsp");
    }
}

<%@ page contentType="text/html; charset=UTF-8" %>
<p>The server time is <%= request.getAttribute("CURRENT_DATETIME") %>.

<!DOCTYPE web-app  PUBLIC 
        "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
        "http://java.sun.com/dtd/web-app_2_3.dtd">
<web-app>

    <servlet>
        <servlet-name>example</servlet-name>
        <servlet- class >org.springframework.web.servlet.DispatcherServlet</servlet- class >
        <load-on-startup> 1 </load-on-startup>
    </servlet>

    <servlet-mapping>
        <servlet-name>example</servlet-name>
        <url-pattern>/example/*</url-pattern>
    </servlet-mapping>

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

    <resource-ref>
        <description>Oracle Datasource example</description>
        <res-ref-name>jdbc/OracleDS</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
    </resource-ref>

</web-app>