huajiazhou
发贴: 14
积分: 0
|
于 2005-04-05 12:01
原程序如下: <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <title>连接数据库的例子</title> </head> <body> 以下是从MS SQLserver数据库中读出的数据:<hr> <table border="1"> <tr><td>id</td><td>书名</td><td>出版社</td><td>价格</td></tr> <%! String trans(String chi) { String result=null; byte temp[]; try { temp=chi.getBytes("iso-8859-1"); result=new String(temp); } catch(UnsupportedEncodingException e) { System.out.println(e.toString()); } return result; } %> <% Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=jspdev"; String USER="sa"; String PWD="5696285"; Connection con= DriverManager.getConnection(url,USER,PWD); Statement stmt=con.createStatement(); String inq="select * from book"; ResultSet rst=stmt.executeQuery(inq); while(rst.next()) { out.println("<tr>"); out.println("<td>"+trans(rst.getString("bookId"))+"</td>"); out.println("<td>"+trans(rst.getString("bookName"))+"</td>"); out.println("<td>"+trans(rst.getString("publisher"))+"</td>"); out.println("<td>"+rst.getFloat("price")+"</td>"); out.println("<tr>"); } rst.close(); stmt.close(); con.close(); %> </table> </body> </html> 以下是错误提示: type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket. org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758) org.apache.jsp.testMssql2_jsp._jspService(testMssql2_jsp.java:118) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) javax.servlet.http.HttpServlet.service(HttpServlet.java:810) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:298) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
请大家帮我看看这到底是什么问题!数据库的用户名跟密码绝对没错!JDBCFORSQLSERVER驱动放到了LIB文件夹里面了!数据库里面有我连接的这个数据库!多谢
huajiazhou edited on 2005-04-05 16:46
|