jsp 如何连接SQLSERVER?

Question

你用jdbc－odbc看看
 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   String url="jdbc:odbc:yae";    Connection conn= DriverManager.getConnection(url,"gsmis","gsmis");
   Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);

Answer 1

odbc可以通过，但我不想用ODBC来连接。是不是还要什么其他操作？我已经把Microsoft SQL Server 2000 Driver for JDBC驱动也 都拷贝到webapps\ROOT\WEB-INF\lib里了

Answer 2

配成连接池，代码如下：
config.xml  <Service name="Catalina">
    <Connector port="8080" maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
               enableLookups="false" redirectPort="8443" acceptCount="100"
               debug="0" connectionTimeout="20000" 
               disableUploadTimeout="true" />
    <!-- Define a Coyote/JK2 AJP 1.3 Connector on port 8009 -->
    <Connector port="8009" 
               enableLookups="false" redirectPort="8443" debug="0"
               protocol="AJP/1.3" />
    <!-- Define the top level container in our container hierarchy -->
    <Engine name="Catalina" defaultHost="localhost" debug="0">
      <!-- Global logger unless overridden at lower levels -->
      <Logger className="org.apache.catalina.logger.FileLogger" prefix="catalina_log." suffix=".txt" timestamp="true"/>
      <Realm className="org.apache.catalina.realm.UserDatabaseRealm" debug="0" resourceName="UserDatabase"/>
      <Host name="localhost" debug="0" appBase="webapps"  unpackWARs="true" autoDeploy="true" xmlValidation="false" xmlNamespaceAware="false"><!--Modify by hzh,Begin data pool set for ORACLE8i-->
  <Context path="" docBase="d:\hynw" reloadable="true" debug="0" privileged="true">
      <Logger className="org.apache.catalina.logger.FileLogger" prefix="localhost_admin_log." suffix=".txt" timestamp="true"/>
<!--Modify by hzh,Begin data pool set for MS SQLServer--> <Resource name="jdbc/ConnectMsSql" auth="Container" type="javax.sql.DataSource"/> 
<ResourceParams name="jdbc/ConnectMsSql">
 <parameter>
   <name>driverClassName</name>
   <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
 </parameter>
 <parameter>
   <name>url</name>
   <value>jdbc:microsoft:sqlserver://10.50.159.44:1433;DatabaseName=HYOA</value>
 </parameter>
 <parameter>
   <name>username</name>
   <value>oa</value>
 </parameter>
 <parameter>
   <name>password</name>
   <value>oapassword</value>
 </parameter>
 <parameter>
   <name>maxActive</name>
   <value>20</value>
 </parameter>
 <parameter>
   <name>maxIdle</name>
   <value>10</value>
 </parameter>
 <parameter>
   <name>maxWait</name>
   <value>1000</value>
 </parameter>
</ResourceParams>       </Context>
<Logger className="org.apache.catalina.logger.FileLogger" directory="logs"  prefix="localhost_log." suffix=".txt" timestamp="true"/>
</Host>
</Engine>
</Service>application\web-info\web.xml<?xml version="1.0" encoding="ISO-8859-1"?><!DOCTYPE web-app
    PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
    "http://java.sun.com/dtd/web-app_2_3.dtd"><web-app>
  <display-name>Welcome to Tomcat</display-name>
  <description>
     Welcome to Tomcat
  </description>    <welcome-file-list>
        <welcome-file>index.html</welcome-file>
        <welcome-file>index.htm</welcome-file>
        <welcome-file>index.jsp</welcome-file>
    </welcome-file-list>
<!-- JSPC servlet mappings start -->    <servlet>
        <servlet-name>org.apache.jsp.index_jsp</servlet-name>
        <servlet-class>org.apache.jsp.index_jsp</servlet-class>
    </servlet>    <servlet-mapping>
        <servlet-name>org.apache.jsp.index_jsp</servlet-name>
        <url-pattern>/index.htm</url-pattern>
        <url-pattern>/index.jsp</url-pattern>
<url-pattern>/index.html</url-pattern>
<url-pattern>/index</url-pattern>
    </servlet-mapping><!-- JSPC servlet mappings end -->
 <resource-ref>  
           <description>DB  Connection</description>  
           <res-ref-name>jdbc/OracleDB</res-ref-name>  
           <res-type>javax.sql.DataSource</res-type>  
           <res-auth>Container</res-auth>  
   </resource-ref> 
</web-app>

Answer 3

把msbase.jar，mssqlserver.jar，msutil.jar放入你的应用程序的WEB-INF\lib目录下。