站内搜索: 请输入搜索关键词

当前页面: 开发资料首页 → JSP 专题 → 有关jdbc的问题！

有关jdbc的问题！

摘要: 有关jdbc的问题！


下面是我用jdbc调用数据库的代码，但是用tomcat浏览的时候，出现的是“sql异常”的显示，后来Class.forName("")和DriverManager.getConnectio（“”）;改为jdbc－odbc链接，一切正常，不知道何故，是不是我的jdbc调用方法不对啊，希望高手指点（高分送，不够还可以加），下面是代码：
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>

<body>
<% Connection con;
Statement sql;
ResultSet rs;
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}
catch(ClassNotFoundException e)
{
out.print("类找不到！");
}
try
{ con=DriverManager.getConnectio＝("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=testDatabse","sa","82994730");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM userTable");
out.print("<table Border>");
out.print("<tr><td colspan=8 align=center>用户数据</td></tr>");
out.print("<tr>");
out.print("<td width=100 >"+"用户ID号");
out.print("<td width=50 >"+"用户名");
out.print("<td width=100>"+"用户真实姓名");
out.print("<td width=50>"+"年龄");
out.print("<td width=50>"+"性别");
out.print("<td width=100>"+"联系地址");
out.print("<td width=100>"+"联系电话");
out.print("<td width=100>"+"添加时间");
out.print("</tr>");
while(rs.next())
{ out.print("<tr>");
out.print("<td >"+rs.getLong(1)+"</td>");
out.print("<td >"+rs.getString(2)+"</td>");
out.print("<td >"+rs.getString(4)+"</td>");
out.print("<td >"+rs.getInt("user_age")+"</td>");
out.print("<td >"+rs.getString("user_sex")+"</td>");
out.print("<td >"+rs.getString("user_address")+"</td>");
out.print("<td >"+rs.getString("user_telephone")+"</td>");
out.print("<td >"+rs.getString("add_time")+"</td>");
out.print("</tr>") ;
}
out.print("</table>");
con.close();
}
catch(SQLException e1)
{
out.print("SQL异常！");
}
%>
</body>


con=DriverManager.getConnection 这里你字母写错了
Connection con = null;
Statement sql = null;
ResultSet rs = null;
这些都要初始化…………

是什么异常啊？

con=DriverManager.getConnectio＝("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=testDatabse","sa","82994730");

这里
con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=testDatabse","sa","82994730");

不可以解决啊？
问题是一样的！是不是其他的问题啊？
我吧第二个try和catch屏蔽了
出现了异常错误:
A Servlet Exception Has Occurred
Exception Report:
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:441)
at org.apache.jsp.selectusertable_jsp._jspService(selectusertable_jsp.java:114)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:200)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:357)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:431)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:191)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:255)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:879)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:225)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:879)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:446)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:879)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:162)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:879)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:827)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:904)
at java.lang.Thread.run(Thread.java:534)

Root Cause:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at org.apache.jsp.selectusertable_jsp._jspService(selectusertable_jsp.java:71)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:200)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:357)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:431)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:191)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:255)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:879)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:225)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:879)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:446)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:879)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:162)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:879)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:827)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:904)
at java.lang.Thread.run(Thread.java:534)



把sql server打上sp3补丁

是不是lib中没有mssqlserver.jar、msutil.jar和msbase.jar

把sql server打上sp3补丁

o sp3补丁，哪里打啊？
试试谢谢了！

微软官方站上就有补丁


↑返回目录
前一篇: 正则问题,谢谢!
后一篇: 有关jdbc的问题？