org.apache.jasper.JasperException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.请各位高手帮忙谢谢!急

装一下sqlserver sp3补丁就行了

解决方案 »

  1.   

    原文件是:
    <%@ page contentType="text/html; charset=GBK" %>
    <%--引入数据库操作类包--%>
    <%@ page import = "java.sql.*"%>
    <html>
    <head>
    <title>SQLServer数据表创建示例</title>
    </head>
    <body>
    <center>
    <h3>SQLServer数据表创建示例</h3>
    <%
      //定义SQLServer的数据库连接驱动类
      String sqlServerDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
      Connection conn;
      Class.forName(sqlServerDriver);
      conn = DriverManager.getConnection
          ("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test" +
           ";User=sa;Password=");
      //创建SQL语句执行类
      Statement stmt = conn.createStatement();
      //数据表创建代码
      String sql = "create table goodscategory(" +
                   "id int primary key," +
                   "categoryName nvarchar(100)," +
                   "categoryDescription nvarchar(200))";
      try{
        stmt.execute(sql);
        out.println("<p>成功创建数据表goodscategory.</p>");
      }catch(Exception ex){
        ex.printStackTrace();
      }
      //数据表创建代码
      sql = "create table goods(" +
                   "serialId nvarchar(20) primary key," +
                   "categoryId int," +
                   "goodName nvarchar(100)," +
                   "manufacturer nvarchar(50)," +
                   "issueDate datetime," +
                   "stock int," +
                   "isDue int)";
      try{
        stmt.execute(sql);
        out.println("<p>成功创建数据表goods.</p>");
      }catch(Exception ex){
        ex.printStackTrace();
      }
    %>
    </center>
    </body>
    </html>