spring 配置数据源

spring框架配置数据源：

一.JNDI方法配置数据源

1、将数据库jar包放入tomcat的Lib文件夹

2、配置tomcat文件夹下context.xml文件

<Resource name="mydataSource " auth="Container" type="javax.sql.DataSource" username="JSJT" password="JSJT" driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@192.168.1.150:1521:JSJT"/>

1、web.xml配置

<resource-ref>    <description>my DB Connection</description>    <res-ref-name>mydataSource </res-ref-name>   must be same as server.xml    <res-type>javax.sql.DataSource</res-type>    <res-auth>Container</res-auth></resource-ref>

2、applicationContext.xml下配置

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