jdbc 连接sql2000数据库 设置方式

安装完“SQLFORJDBCSP1.exe"C:/Program   Files/Microsoft   SQL   Server   2000   Driver   for   JDBC/lib有“msbase.jar”“mssqlserver.jar”“msutil.jar”   三个文件我把他们都拷贝到“C:/Program   Files/Apache   Software   Foundation/Tomcat   5.5/common/lib”下面去了。也把   他们分别加到CLASSPATH里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  
 重新启动Tomcat！  
 写个sql   测试的sql_test.jsp   文件   内容如下<%@   page   contentType="text/html;charset=GB2312"   %><%@   page   import="java.sql.*"   %>  
    <%   Connection   con;  
          Statement   sql;    
          ResultSet   rs;  
          try  
          {  
              Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");  
          }  
          catch(ClassNotFoundException   e)  
          {  
              out.print("类找不到！");  
          }  
          try    
          {      
                    con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=testDatabse","sa","sa");  
                    sql=con.createStatement();  
                    rs=sql.executeQuery("SELECT   *   FROM   userTable");  
                    out.print("");  
                    out.print("用户数据");        
                    out.print("");  
                          out.print(""+"用户ID号");  
                          out.print(""+"用户名");  
                          out.print(""+"用户真实姓名");  
                          out.print(""+"年龄");  
                          out.print(""+"性别");  
                          out.print(""+"联系地址");  
                          out.print(""+"联系电话");  
                          out.print(""+"添加时间");  
                    out.print("");  
                while(rs.next())  
                {   out.print("");  
                            out.print(""+rs.getLong(1)+"");  
                            out.print(""+rs.getString(2)+"");    
                            out.print(""+rs.getString(4)+"");  
                            out.print(""+rs.getInt("user_age")+"");    
                            out.print(""+rs.getString("user_sex")+"");  
                            out.print(""+rs.getString("user_address")+"");  
                            out.print(""+rs.getString("user_telephone")+"");  
                            out.print(""+rs.getString("add_time")+"");  
                  out.print("")   ;    
                  }  
                  out.print("");  
                  con.close();  
            }  
        catch(SQLException   e1)    
        {  
              out.print("SQL异常！");  
        }  
    %>  
 保存完放在  C:/Program   Files/Apache   Software   Foundation/Tomcat   5.5/webapps/ROOT这里   然后  打开ie   输入http://localhost:8080/sql_test.jsp