| 发表于：2007-07-08 09:52:39 楼主 |
我用如下的jsp文件连接sqlserver数据库,
<%@ 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=db_board ";
//pubs为你的数据库的
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 tb_user ";
resultset rs=stmt.ＥＸＥＣutequery（sql);
while（rs.next（)) {%>
您的第一个字段内容为： <%=rs.getstring（1)%>
您的第二个字段内容为： <%=rs.getstring（2)%>
<%}%>
<%out.print（ "数据库操作成功，恭喜你 ");%>
<%rs.close（);
stmt.close（);
conn.close（);
%>
</body>
</html>
不知为什么出现如下的错误,是不是我的sqlserver数据库有问题啊?已打了sp4补丁,tomcat\lib下也有jdbc驱动,用的是1433端口,
在dos下:
ping （服务器ip地址ip)
连接正常...
或
ping （服务器名)
连接正常...
telnet ＜服务器ip地址＞ 1433
正在连接到localhost...不能打开到主机的连接， 在端口 1433: 连接失败
请问大家一下这可能是什么问题啊!
下面是jsp读取sqlserver数据库出现的错误:
type exception report
message
description the server encountered an internal error （) that prevented it from fulfilling this request.
exception
org.apache.jasper.jasperexception: javax.servlet.servletexception: java.sql.sqlexception: [microsoft][sqlserver 2000 driver for jdbc]error establishing socket.
org.apache.jasper.servlet.jspservletwrapper.handlejspexception（jspservletwrapper.java:541)
org.apache.jasper.servlet.jspservletwrapper.service（jspservletwrapper.java:417)
org.apache.jasper.servlet.jspservlet.servicejspfile（jspservlet.java:320)
org.apache.jasper.servlet.jspservlet.service（jspservlet.java:266)
javax.servlet.http.httpservlet.service（httpservlet.java:803)
root cause
javax.servlet.servletexception: java.sql.sqlexception: [microsoft][sqlserver 2000 driver for jdbc]error establishing socket.
org.apache.jasper.runtime.pagecontextimpl.dohandlepageexception（pagecontextimpl.java:850)
org.apache.jasper.runtime.pagecontextimpl.handlepageexception（pagecontextimpl.java:779)
org.apache.jsp.testsqlserver_jsp._jspservice（testsqlserver_jsp.java:98)
org.apache.jasper.runtime.httpjspbase.service（httpjspbase.java:70)
javax.servlet.http.httpservlet.service（httpservlet.java:803)
org.apache.jasper.servlet.jspservletwrapper.service（jspservletwrapper.java:393)
org.apache.jasper.servlet.jspservlet.servicejspfile（jspservlet.java:320)
org.apache.jasper.servlet.jspservlet.service（jspservlet.java:266)
javax.servlet.http.httpservlet.service（httpservlet.java:803)
root cause
java.sql.sqlexception: [microsoft][sqlserver 2000 driver for jdbc]error establishing socket.
com.microsoft.jdbc.base.baseexceptions.createexception（unknown source)
com.microsoft.jdbc.base.baseexceptions.getexception（unknown source)
com.microsoft.jdbc.base.baseexceptions.getexception（unknown source)
com.microsoft.jdbc.sqlserver.tds.tdsconnection. <init> （unknown source)
com.microsoft.jdbc.sqlserver.sqlserverimplconnection.open（unknown source)
com.microsoft.jdbc.base.baseconnection.getnewimplconnection（unknown source)
com.microsoft.jdbc.base.baseconnection.open（unknown source)
com.microsoft.jdbc.base.basedriver.connect（unknown source)
java.sql.drivermanager.getconnection（drivermanager.java:525)
java.sql.drivermanager.getconnection（drivermanager.java:171)
org.apache.jsp.testsqlserver_jsp._jspservice（testsqlserver_jsp.java:64)
org.apache.jasper.runtime.httpjspbase.service（httpjspbase.java:70)
javax.servlet.http.httpservlet.service（httpservlet.java:803)
org.apache.jasper.servlet.jspservletwrapper.service（jspservletwrapper.java:393)
org.apache.jasper.servlet.jspservlet.servicejspfile（jspservlet.java:320)
org.apache.jasper.servlet.jspservlet.service（jspservlet.java:266)
javax.servlet.http.httpservlet.service（httpservlet.java:803)
note the full stack trace of the root cause is available in the apache tomcat/6.0.13 logs.
--------------------------------------------------------------------------------
|
|
|
|
|
