一.环境变量：
path: c:/j2sdk1.4.2/bin;
java_home: c:/j2sdk1.4.2
注:仅此两个.
二.sql server 驱动
copy
microsoft sql server 2000 driver for jdbc/lib/目录下三个.jar :
msbase.jar
mssqlserver.jar
msutil.jar
to
tomcat5/common/lib
三.虚拟目录与连接池
假设要在d:/jsgtest建自己的虚拟目录
/myjsp
假设要建连接池jndi 名为aaa
假设连接数据库为pubs
则在
tomcat5/conf/catalina/localhost
目录下新建文件:
myjsp.xml
内容如下:
<?xml version='1.0' encoding='utf-8'?>
<context crosscontext="true" displayname="myjsp" docbase="d:/jsgtest" path="/myjsp" reloadable="true">
<resource name="aaa" type="javax.sql.datasource"/>
<resourceparams name="aaa">
<parameter>
<name>url</name>
<value>jdbc:microsoft:sqlserver://localhost:1433;databasename=pubs</value>
</parameter>
<parameter>
<name>password</name>
<value>kingapex</value>
</parameter>
<parameter>
<name>maxactive</name>
<value>4</value>
</parameter>
<parameter>
<name>maxwait</name>
<value>5000</value>
</parameter>
<parameter>
<name>driverclassname</name>
<value>com.microsoft.jdbc.sqlserver.sqlserverdriver</value>
</parameter>
<parameter>
<name>username</name>
<value>sa</value>
</parameter>
<parameter>
<name>maxidle</name>
<value>2</value>
</parameter>
</resourceparams>
</context>
测试:
在d:/jsgtest目录下建文件:test.jsp:
<%@ page contenttype="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.sql.*"%>
<%@ page import="javax.naming.*"%>
<%
connection conn = null;
context initctx = new initialcontext();
if (initctx == null)
throw new exception("不能获取context!");
context ctx = (context) initctx.lookup("java:comp/env");
//获取连接池对象
object obj = (object) ctx.lookup("aaa");
//类型转换
javax.sql.datasource ds = (javax.sql.datasource) obj;
conn = ds.getconnection();
statement stmt = conn.createstatement();
string strsql = "select * from [titles]";
resultset rs = stmt.executequery(strsql);
while(rs.next()){
out.println(rs.getstring(1));
}
rs.close();
stmt.close();
conn.close();
out.println("连接池测试成功");
%>
测试路径:
http://localhost:8080/myjsp/test.jsp
闽公网安备 35060202000074号