配置Tomcat JNDI数据源

以下示例基于Spring：

1、在Mysql中建立Spring数据库，数据库中建立user表

2、在tomcat目录下conf\context.xml中的<Context>标签中加入

 

<Resource name="jndi"
        auth="Container"
        type="javax.sql.DataSource"
        password="mysql5"
        username="root"
        driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/spring"
        maxActive="5"
        maxIdle="2"
        maxWait="3000"
    />

3、修改项目的web.xml文件，加入

<resource-ref>
    <res-ref-name>jndi</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
</resource-ref>

4、在spring配置文件中配置Datasource

<bean id="dataSource"
        class="org.springframework.jndi.JndiObjectFactoryBean">
        <property name="jndiName" value="java:comp/env/jndi"/>
    </bean>

我们也可以采用下面的方式，但是要加入以下命名空间 ：
xmlns:jee="http://www.springframework.org/schema/jee"

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

<!-- Spring 2.0为获取J2EE资源提供了一个jee命名空间，通过jee命名空间，可以有效地简化J2EE资源的引用。 -->
    <jee:jndi-lookup id="dataSource" jndi-name="java:comp/env/jndi"/>

具体sample如下所示：

User.java

package cn.nevo.model;

import org.springframework.stereotype.Component;

/**
 * Entity
 * @author Administrator
 *
 */
@Component("user")
public class User {

    private String username;

    public String getUsername() {
        return username;
    }
    public void setUsername(String username) {
        this.username = username;
    }
}

UserDao.java

package cn.nevo.dao;

import cn.nevo.model.User;

public interface UserDao {
    public void save(User user);
}

UserDaoImpl.java

package cn.nevo.dao.impl;

import java.sql.Connection;
import java.sql.SQLException;

import javax.annotation.Resource;
import javax.sql.DataSource;

import org.springframework.stereotype.Component;

import cn.nevo.dao.UserDao;
import cn.nevo.model.User;

@Component("userDao")
public class UserDaoImpl implements UserDao {

    private DataSource dataSource;

    public DataSource getDataSource() {
        return dataSource;
    }

    //默认是by name注入
    @Resource
    public void setDataSource(DataSource dataSource) {
        this.dataSource = dataSource;
        System.out.println(dataSource);
    }

    public void save(User user) {
        Connection conn = null;
        try {
            conn = dataSource.getConnection();
            conn.createStatement().executeUpdate("insert into user values (null, '" +user.getUsername()+"')");

        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        System.out.println("user saved!");
    }
}

UserService.java

package cn.nevo.service;

import javax.annotation.Resource;

import org.springframework.stereotype.Component;

import cn.nevo.dao.UserDao;
import cn.nevo.model.User;

@Component("userService")
public class UserService {
    private UserDao userDao;

    public UserDao getUserDAO() {
        return userDao;
    }

    @Resource(name = "userDao")
    public void setUserDAO(UserDao userDao) {
        this.userDao = userDao;
    }

    public void add(User user) {
        userDao.save(user);
    }
}

LoginServlet.java

package cn.nevo.servlet;

import java.io.IOException;

import javax.annotation.Resource;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import cn.nevo.model.User;
import cn.nevo.service.UserService;

@SuppressWarnings("serial")
public class LoginServlet extends HttpServlet {

    private User user;

    public User getUser() {
        return user;
    }

    @Resource
    public void setUser(User user) {
        this.user = user;
    }

    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        user.setUsername(request.getParameter("username"));

        ApplicationContext ctx = new ClassPathXmlApplicationContext("bean.xml");
        UserService userService = (UserService)ctx.getBean("userService");
        userService.add(user);
    }

}

bean.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:context="http://www.springframework.org/schema/context"
    xmlns:aop="http://www.springframework.org/schema/aop"
    xmlns:jee="http://www.springframework.org/schema/jee"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
           http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
           http://www.springframework.org/schema/context
           http://www.springframework.org/schema/context/spring-context-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/jee
           http://www.springframework.org/schema/jee/spring-jee-2.5.xsd">

    <!--
        隐式注册 post-processors 包括了
        AutowiredAnnotationBeanPostProcessor，CommonAnnotationBeanPostProcessor，PersistenceAnnotationBeanPostProcessor，
        也包括了前面提到的 RequiredAnnotationBeanPostProcessor。处理我们配置的annotation
    -->
    <context:annotation-config />

    <!--
        要检测这些类并注册相应的bean，需要在XML中包含以下元素，其中'basePackage'是类的公共父包
        (或者可以用逗号分隔的列表来分别指定包含各个类的包)。
    -->
    <context:component-scan base-package="cn.nevo" />

    <!-- 从Tomcat配置的JNDI服务获取数据源-->
    <!--
    <bean id="dataSource"
        class="org.springframework.jndi.JndiObjectFactoryBean">
        <property name="jndiName" value="java:comp/env/jndi"/>
    </bean>
     -->

    <!-- Spring 2.0为获取J2EE资源提供了一个jee命名空间，通过jee命名空间，可以有效地简化J2EE资源的引用。 -->
    <jee:jndi-lookup id="dataSource" jndi-name="java:comp/env/jndi"/>
</beans>

index.jsp

<body>
    <form action="loginServlet" method="post">
         UserName:<input type="text" name="username">
        <input type="submit" value="Login">
    </form>
</body>

启动tomcat访问：