<bean id="propertyConfigurer"
   class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"
   p:location="/WEB-INF/jdbc.properties" />

<bean id="dataSource"
   class="org.springframework.jdbc.datasource.DriverManagerDataSource"
   p:driverClassName="${jdbc.driverClassName}"
   p:url="${jdbc.url}"
   p:username="${jdbc.username}"
   p:password="${jdbc.password}" />

package ru.spring;

import java.sql.Statement;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.sql.DataSource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.AbstractController;

public class MyPageController extends AbstractController {
  
  public MyPageController() {
  }
  
  private DataSource dataSource;

  public void setDataSource(DataSource dataSource) {
      this.dataSource = dataSource;
  }  
  
  protected ModelAndView handleRequestInternal(
          HttpServletRequest request,
          HttpServletResponse response) throws Exception {
    
    ModelAndView model = new ModelAndView("mypage");
    
    // `pages2` = `page`, `title`, `content`
    String sql = "SELECT `title` FROM `pages2` WHERE `page` = 'about'";
    
    Connection conn = null;
    Statement st = null;
    
    String page = "";
    
    try {
        conn = dataSource.getConnection();
        st = conn.createStatement();

        ResultSet res = st.executeQuery(sql);
        while(res.next()) {
          page = res.getString("title");
        }
    } catch (SQLException e) {
        throw new RuntimeException(e);
    } 
        
    model.addObject("db_title", page);

    return model;
  }
  
}

    ApplicationContext ctx = new ClassPathXmlApplicationContext("ru/spring/applicationContext.xml");
    Object obj = ctx.getBean("dataSource");
    DriverManagerDataSource dss = (DriverManagerDataSource) obj;
    ...
    conn = dss.getConnection("login","password");

ApplicationContext ctx = new ClassPathXmlApplicationContext("/WEB-INF/applicationContext.xml");

<Context>

  <Resource name="jdbc/db" 
	    auth="Container" 
	    type="javax.sql.DataSource"
	    maxActive="100" 
	    maxIdle="30" 
	    maxWait="10000"
	    username="login" 
	    password="password" 
	    driverClassName="com.mysql.jdbc.Driver"
	    url="jdbc:mysql://localhost:3306/mydb"/>
			
</Context>

    
<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
        <property name="jndiName" value="java:comp/env/jdbc/DataSourceName"/>
        <property name="lookupOnStartup" value="true"/>
        <property name="cache" value="true"/>
        <property name="proxyInterface" value="javax.sql.DataSource"/>
    </bean>

<?xml version="1.0" encoding="UTF-8"?>
<Context antiJARLocking="true" path="">
  <Resource name="jdbc/mydb" 
            auth="Container" 
            type="javax.sql.DataSource"
            maxActive="50" 
            maxIdle="30" 
            maxWait="10000"
            username="login"
            password="password" 
            driverClassName="com.mysql.jdbc.Driver"
            url="jdbc:mysql://localhost:3306/mydatabase"/>  
</Context>

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

package ru.spring;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.sql.DataSource;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.AbstractController;

public class PageController extends AbstractController {
  
  private DataSource ds;
  
  public PageController() { 
        
    try {
      Context ctx = new InitialContext();
      ds = (DataSource)ctx.lookup("java:comp/env/jdbc/mydb");
    } catch (NamingException e) {
      e.printStackTrace();
    }        
    
  }  
  
  protected ModelAndView handleRequestInternal(
          HttpServletRequest request,
          HttpServletResponse response) throws Exception {
    
    ModelAndView model = new ModelAndView("page");
    
    // `pages2` = `page`, `title`, `content`
    String sql = "SELECT `title` FROM `pages2` WHERE `page` = 'about'";

    String page = "";
    
    try {
      
      Connection conn = ds.getConnection();
      Statement st = conn.createStatement();

      ResultSet res = st.executeQuery(sql);
      while(res.next()) {
        page = res.getString("title");
      }
      
    } catch (SQLException e) {
        throw new RuntimeException(e);
    }
    
    model.addObject("db_title", page);
    
    return model;
  }
}

DataSource ds = (DataSource) new InitialContext().lookup("java:comp/env/jdbc/mydb");
JdbcTemplate jdbc = new JdbcTemplate(ds);

ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
DataSource ds = (DataSource) context.getBean("dataSource");