web.xml中:
在<web-app>中加入以下内容
<resource-ref>
<description>java_min</description>
<res-ref-name>datasourceName</res-ref-name> 数据源名称,与tomcat中中的server.xml中的数据源名字保持相同
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
server.xml中:
在<host>中加入以下内容
<Context
docBase="编译后的工程的绝对路径"
path="/projectName"
reloadable="true">
<Resource name="datasourceName" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/ssprds">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>net.sourceforge.jtds.jdbc.Driver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:jtds:sqlserver://misdev10:1433/test_db;tds=8.0;lastupdatecount=true</value>
</parameter>
<parameter>
<name>username</name>
<value>root</value>
</parameter>
<parameter>
<name>password</name>
<value>123456</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>50000</value>
</parameter>
</ResourceParams>
</Context>
java代码中:
Context ctx = new InitialContext();
Context envContext = (Context) ctx.lookup("java:comp/env"); 固定写法
DataSource ds = (DataSource) envContext.lookup(datasourceName); 数据源名称,与web.xml中的相同
conn = ds.getConnection(userName, password);
==============================================
JNDI配置步骤:
==========================公司实例======================
1.配置服务器(tomcat)的conf/context.xml文件
<?xml version='1.0' encoding='GBK'?>
<Context crossContext="true" debug="5" docBase="E:\Workspaces\mytest\测试\Web" path="/test" reloadable="true">
<Resource name="jdbc/cdmcsbussrv_ds"
auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/cdmcsbussrv_ds">
<parameter>
<name>maxActive</name>
<value>5</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>1</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>100</value>
</parameter>
<parameter>
<name>username</name>
<value>scott</value>
</parameter>
<parameter>
<name>password</name>
<value>tiger</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@195.2.199.5:1521:cqcgsorcl</value>
<!--<value>jdbc:oracle:thin:@www.cdmcs.com:1521:cqcgsorcl</value>-->
</parameter>
</ResourceParams>
<Resource name="jdbc/cgsapp_ds"
auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/cgsapp_ds">
<parameter>
<name>maxActive</name>
<value>5</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>1</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>100</value>
</parameter>
<parameter>
<name>username</name>
<value>scott</value>
</parameter>
<parameter>
<name>password</name>
<value>tiger</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@195.2.199.5:1521:cqcgsorcl</value>
<!--<value>jdbc:oracle:thin:@www.cdmcs.com:1521:cqcgsorcl</value>-->
</parameter>
</ResourceParams>
</Context>
<?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">
<welcome-file-list>
<welcome-file>
index.html
</welcome-file>
<welcome-file>
index.jsp
</welcome-file>
</welcome-file-list>
<listener>
<description>Online user count</description>
<listener-class>mweb.FwlSessionLis</listener-class>
</listener>
<servlet>
<servlet-name>login</servlet-name>
<servlet-class>servlet.UserLoginServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>login</servlet-name>
<url-pattern>/login</url-pattern>
</servlet-mapping>
<!-- 数据库连接 -->
<resource-ref>
<res-ref-name>jdbc/cdmcsbussrv_ds</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
<res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>
<resource-ref>
<res-ref-name>jdbc/cgsapp_ds</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
<res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>
<error-page>
<error-code>401</error-code>
<location>/error.jsp</location>
</error-page>
<error-page>
<error-code>403</error-code>
<location>/error.jsp</location>
</error-page>
<error-page>
<error-code>404</error-code>
<location>/error.jsp</location>
</error-page>
<error-page>
<error-code>500</error-code>
<location>/error.jsp</location>
</error-page>
</web-app>
private static String dbsource = "jdbc/cgsapp_ds";
private static DataSource ds = null;
private static Object mtx = new Object();
private static Logger logger = Logger.getLogger( DBUtil.class);
public static Connection getConn() throws SQLException{
Connection conn;
try {
if (ds == null) {
synchronized( mtx ){
InitialContext ctx = new InitialContext();
logger.info("取数据源:"+dbsource);
ds = (DataSource) ctx.lookup("java:comp/env/"+dbsource);
}
}
logger.info("取连接:"+dbsource);
conn = ds.getConnection();
return conn;
} catch (NamingException e) {
// TODO Auto-generated catch block
e.printStackTrace();
throw new SQLException("取数据源("+dbsource+")失败 !");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
throw new SQLException("获取数据库连接失败!");
}
}