jdbc连接sqlserver2000问题

huiyannan 2004-01-15 04:13:44

程序为：<%@ 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;DataBase=train";

Connection con=DriverManager.getConnection(url,"sa","system");
if(con==null)
{
System.out.println("get Conn Error");
}
Statement stmt=con.createStatement();

String sql="select * from bzb0";

ResultSet rs=stmt.executeQuery(sql);

while(rs.next()){%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%}%>
<%
rs.close();
stmt.close();
con.close();
%>

</body>

</html>

执行后报错为：

Error: 500
Location: /jdbc/index.jsp
Internal Servlet Error:

org.apache.jasper.JasperException: Unable to compile class for JSPNote: sun.tools.javac.Main has been deprecated.
F:\tomcat\work\localhost_8080\_0002fjdbc_0002findex_0002ejspindex_jsp_4.java:75: Ambiguous class: java.beans.Statement and java.sql.Statement
Statement stmt=con.createStatement();
^
1 error, 1 warning

at org.apache.jasper.compiler.Compiler.compile(Compiler.java:254)
at org.apache.jasper.servlet.JspServlet.doLoadJSP(JspServlet.java:462)
at org.apache.jasper.servlet.JasperLoader12.loadJSP(JasperLoader12.java:146)
at org.apache.jasper.servlet.JspServlet.loadJSP(JspServlet.java:433)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.loadIfNecessary(JspServlet.java:152)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:164)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:318)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
at org.apache.tomcat.core.Handler.service(Handler.java:286)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:210)
at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
at java.lang.Thread.run(Thread.java:536)

...全文

48 4 打赏收藏转发到动态举报

写回复

用AI写文章

4 条回复

切换为时间正序

请发表友善的回复…

发表回复

wjfxiao 2004-01-15

打赏
举报

Ambiguous class: java.beans.Statement and java.sql.Statement
Statement stmt=con.createStatement();

因为这里有两个包里含有Statement类
jvm编译程序不知道到底要调用哪一个
所以要求你指明
就是要加上包名
如：java.sql.Statement

huiyannan 2004-01-15