您所在位置：主题：麻烦各位高手帮我看看是什么问题jsp+SQLSserver2000
明月天山
[专家分：0] 发布于 2006-03-23 12:39:00
我的系统环境是:win2003+SQLServer2000+jre+j2dk+jswdk+jdbc+jdbc sp3
如下代码连接数据库:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriverr").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MyWebDB";
String user="z";
String password="";
Connection conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
String sql="select f1,f2 from tb1";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
%>
您的第一个字段内容为：<%=rs.getString(1)%>
您的第二个字段内容为：<%=rs.getString(2)%>
<%
}
%>
<%out.print("数据库操作成功，恭喜你");%>
<%
rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
Web服务器如下错误提示:
Unhandled error!you might want to consider having an error page to report such errors more gracefully
com.sun.jsp.JspException:Compilation failed:Note:sun.tools.javac.Main has been deprecated.
work\%3A80%2F\db_jsp_1.java:78:Ambiguous class:java.beans.Statement and java.sql.Statement
Statement stmt=conn.createStatement();
^
1 error,1 warning
at com.sun.jsp.compiler.Main.compile(Main.java:347)
at com.sun.jsp.runtime.JspLoader.loadJSP(JspLoader.java:135)
at com.sun.jsp.runtime.JspServlet$jspServletWrapper.loadIfNecessary(jspServlet.java:77)
at com.sun.jsp.runtime.jspServlet$jspServletWrapper.service(JspServlet.java:87)
at com.sun.jsp.runtime.JspServlet.serviceJspFile(JspServlet.java:218)
at com.sun.jsp.runtime.JspServlet.service(jspServlet.java:294)
at com.sun.jsp.servlet.http.HttpServlet.service(HttpServlet.java:840)
at com.sun.jsp.web.core.ServletWrapper.handlerequest(ServletWrapper.java:155)
at com.sun.jsp.web.core.Context.handleRequest(context.java:414)
at com.sun.jsp.web.server.ConnectionHandler.run(connectionHandler.java:139)
HANDLER THREAD PROBLEM:java.net.SockerException:Socket is closed
java.net.SocketException:Socket is closed
at java.net.Socked.getInputStream(Socket.java:698)
at com.sun.web.serer.connectionHandler.run(connectionHandler.java:161)
拜托各位高手帮我看看是什么问题，多谢了
如下代码连接数据库:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriverr").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MyWebDB";
String user="z";
String password="";
Connection conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
String sql="select f1,f2 from tb1";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
%>
您的第一个字段内容为：<%=rs.getString(1)%>
您的第二个字段内容为：<%=rs.getString(2)%>
<%
}
%>
<%out.print("数据库操作成功，恭喜你");%>
<%
rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
Web服务器如下错误提示:
Unhandled error!you might want to consider having an error page to report such errors more gracefully
com.sun.jsp.JspException:Compilation failed:Note:sun.tools.javac.Main has been deprecated.
work\%3A80%2F\db_jsp_1.java:78:Ambiguous class:java.beans.Statement and java.sql.Statement
Statement stmt=conn.createStatement();
^
1 error,1 warning
at com.sun.jsp.compiler.Main.compile(Main.java:347)
at com.sun.jsp.runtime.JspLoader.loadJSP(JspLoader.java:135)
at com.sun.jsp.runtime.JspServlet$jspServletWrapper.loadIfNecessary(jspServlet.java:77)
at com.sun.jsp.runtime.jspServlet$jspServletWrapper.service(JspServlet.java:87)
at com.sun.jsp.runtime.JspServlet.serviceJspFile(JspServlet.java:218)
at com.sun.jsp.runtime.JspServlet.service(jspServlet.java:294)
at com.sun.jsp.servlet.http.HttpServlet.service(HttpServlet.java:840)
at com.sun.jsp.web.core.ServletWrapper.handlerequest(ServletWrapper.java:155)
at com.sun.jsp.web.core.Context.handleRequest(context.java:414)
at com.sun.jsp.web.server.ConnectionHandler.run(connectionHandler.java:139)
HANDLER THREAD PROBLEM:java.net.SockerException:Socket is closed
java.net.SocketException:Socket is closed
at java.net.Socked.getInputStream(Socket.java:698)
at com.sun.web.serer.connectionHandler.run(connectionHandler.java:161)
拜托各位高手帮我看看是什么问题，多谢了