把驱动的jar放到tomcat_dir/common/lib里然后在tomcat_dir\conf\Catalina\localhost里放入一个配置文件,比如你的web应用叫exam,则放入一个exam.xml文件,内容如下
<?xml version="1.0" encoding="UTF-8"?>
<Context path="/exam" reloadable="true"> <Resource name="jdbc/exam" auth="Container"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@localhost:1521:demo"
username="dbuser" password="dbpass"
maxActive="10" maxIdle="5" maxWait="2"/></Context>
<?xml version="1.0" encoding="UTF-8"?>
<Context path="/exam" reloadable="true"> <Resource name="jdbc/exam" auth="Container"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@localhost:1521:demo"
username="dbuser" password="dbpass"
maxActive="10" maxIdle="5" maxWait="2"/></Context>
要是配置好了以后,代码该如何写呢??小弟是新手,请赐教!!
javax.naming.Context context = new javax.naming.InitialContext();
javax.sql.DataSource dataSource = (javax.sql.DataSource)context.lookup("java:comp/env/jdbc/exam");
java.sql.Connection conn = dataSource.getConnection();
} catch (Exception e) {
e.printStackTrace();
}
%>
哪个驱动jar啊?可以说明白点吗?
mssqlserver.jar
msutil.jar