网络操作系统:Windows2000server,JSP服务器:Tomcat5.0,数据库:SQLServer2k,JAVA虚拟机:JDK1.4步骤一:安装JDK1.4(目录:C:\JDK1.4)步骤二:安装SQLServer2k。(默认目录)步骤三:安装Tomcat5.0。该服务器和web服务器Apache捆绑在一起,省去了人工捆绑的麻烦。(目录:C:\tomcat)
步骤四:安装Microsoft SQL Server 2000 Driver for JDBC。(默认目录)
步骤五:系统环境变量设置:在Administrators的用户变量中:1.新建classpath变量,变量值:c:\jdk1.4\bin\tools.jar;c:\jdk1.4\lib\dt.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;2.新建path变量变量值:c:\jdk1.4\bin;c:\jdk1.4;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;3.新建set java_home变量变量值:c:\jdk1.44. 新建set tomcat_home变量变量值:c:\tomcat步骤六:复制C:\Microsoft SQL Server 2000 Driver for JDBC\lib下三个jar文件(msbase.jar,mssqlserver.jar,msutil.jar)到C:\tomcat\common\lib\下步骤七:重新启动系统,使环境变量的设置生效。启动Apachetomcat服务,在浏览器中打127.0.0.1,会看到tomcat的默认欢迎界面。
步骤四:安装Microsoft SQL Server 2000 Driver for JDBC。(默认目录)
步骤五:系统环境变量设置:在Administrators的用户变量中:1.新建classpath变量,变量值:c:\jdk1.4\bin\tools.jar;c:\jdk1.4\lib\dt.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;2.新建path变量变量值:c:\jdk1.4\bin;c:\jdk1.4;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;3.新建set java_home变量变量值:c:\jdk1.44. 新建set tomcat_home变量变量值:c:\tomcat步骤六:复制C:\Microsoft SQL Server 2000 Driver for JDBC\lib下三个jar文件(msbase.jar,mssqlserver.jar,msutil.jar)到C:\tomcat\common\lib\下步骤七:重新启动系统,使环境变量的设置生效。启动Apachetomcat服务,在浏览器中打127.0.0.1,会看到tomcat的默认欢迎界面。
<%@ page contentType="text/html;charset=gb2312"%> <%@ page import="java.sql.*"%> <html> <body> <% Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=haiguan"; String user="sa"; String password=""; Connection conn= DriverManager.getConnection(url,user,password); Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); String sql="select * from xt_user"; ResultSet rs=stmt.executeQuery(sql); while(rs.next()) {%> 您的第一个字段内容为:<%=rs.getString(1)%> 您的第二个字段内容为:<%=rs.getString(2)%> <% }%> <%out.print("数据库操作成功,恭喜你");%> <% rs.close(); stmt.close(); conn.close(); %> </body> </html>
javax.naming.NamingException: Cannot create resource instance
我使用Apache Tomcat/4.1.24-LE-jdk14,sql2000,也安装了:
Microsoft SQL Server 2000 Driver for JDBC,把3个文件都拷贝到了$TOMCAT_HOME\common\lib目录了。在server.xml中部署如下:
<!--测试使用数据库连接池-->
<Context path="/TestDBPool" docBase="E:/SITE/WebTest/DBPool/defaultroot" debug="0"
reloadable="true" crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger"
directory="logs" prefix="localhost_log." suffix=".txt" timestamp="true"/>
<Resource name="jdbc/DBPool"
auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/DBPool">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>removeAbandonedTimeout</name>
<value>60</value>
</parameter>
<parameter>
<name>logAbandoned</name>
<value>false</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>10</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
<parameter>
<name>username</name>
<value>sa</value>
</parameter>
<parameter>
<name>password</name>
<value>lhddn</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=pubs</value>
</parameter>
</ResourceParams>
</Context>
我在对应的web.xml中部署如下:
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/sqldbPool</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
这个问题困扰好长时间拉,请大家一定帮忙啊,毕业设计就等这个拉。