数据库连接池,在tomcat中配置数据源:
1:配置contex.xml文件
<Context>
<WatchedResource>WEB-INF/web.xml</WatchedResource>
<Resource name="jdbc/news" auth="Container"
type="javax.sql.DataSource" maxActive="100"
maxIdle="30" maxWait="10000" username="jbit" password="bdqn" <!--username,password数据账号密码-->
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@10.0.0.34:1521:SJBITDB "
/>
<!--<Environment name="tjndi" value="hello JNDI" type="java.lang.String" />-->
</Context>
2:配置web.xml文件(<web-app>根目录下添加)
<resource-ref>
<description>news DataSource</description >
<res-ref-name>jdbc/news</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
3:添加相应jdbc驱动
4:编写java代码,使用JNDI返回数据源对象
import java.sql.Connection;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
public class Test {
public static void main(String[] args) {
try{
Context context = new InitialContext();
DataSource source = (DataSource)context.lookup("java:comp/env/jdbc/news");
Connection con = source.getConnection();
}catch(Exception e){
e.printStackTrace();
}
}
}