Tomcat 6.0+Oracle 10g数据源连接测试的过程是本文我们主要要介绍的内容,接下来就让我们一起来了解一下这部分内容吧,希望能够对您有所帮助。连接测试的步骤如下:
1. <Resource name="jdbc/chong800" //数据源名称 auth="Container"
2. type="javax.sql.DataSource" maxActive="100"
3.maxIdle="10" maxWait="10000"
4.username="scott" //数据库用户名 password="tiger" //数据库密码
5. driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@localhost:1521:chong800"
6. />
1. <%@ page language="java" contentType="text/html; charset=GB18030" pageEncoding="GB18030"%>
2. < %@page import="java.sql.*" %> < %@page import="javax.sql.*" %>
3.< %@page import="javax.naming.*" %> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" " http://www.w3.org/TR/html4/loose.dtd ">
4. <html> <head>
5.<meta http-equiv="Content-Type" content="text/html; charset=GB18030"> <title>数据源测试</title>
6. </head> <body>
7.<% Connection conn = null;
8. Context context = new InitialContext(); //java:comp/env/只有tomcat时候才用
9. DataSource dts = (DataSource)context.lookup("java:comp/env/jdbc/chong800"); conn = dts.getConnection();
10. %> 当conn为null时候说明没有找到数据源
11. <%=conn %> <%conn.close(); %>
12. </body> </html>
1. <Resource name="jdbc/chong800" //数据源名称 auth="Container"
2. type="javax.sql.DataSource" maxActive="100"
3.maxIdle="10" maxWait="10000"
4.username="scott" //数据库用户名 password="tiger" //数据库密码
5. driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@localhost:1521:chong800"
6. />
1. <%@ page language="java" contentType="text/html; charset=GB18030" pageEncoding="GB18030"%>
2. < %@page import="java.sql.*" %> < %@page import="javax.sql.*" %>
3.< %@page import="javax.naming.*" %> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" " http://www.w3.org/TR/html4/loose.dtd ">
4. <html> <head>
5.<meta http-equiv="Content-Type" content="text/html; charset=GB18030"> <title>数据源测试</title>
6. </head> <body>
7.<% Connection conn = null;
8. Context context = new InitialContext(); //java:comp/env/只有tomcat时候才用
9. DataSource dts = (DataSource)context.lookup("java:comp/env/jdbc/chong800"); conn = dts.getConnection();
10. %> 当conn为null时候说明没有找到数据源
11. <%=conn %> <%conn.close(); %>
12. </body> </html>
本文转自 wws5201985 51CTO博客,原文链接:http://blog.51cto.com/wws5201985/737015,如需转载请自行联系原作者