初学调用数据库的问题?

jspguoyy 2001-06-14 10:34:00
<%@ page language="java" import="java.sql.*,java.util.*"%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>
<head>
<title>Untitled</title>
</head>

<body>

<%!String url;
String count;
int i=0;
%>
<%
/*int name[];
for (int i=0;i<9;i++){
name[i]=i;
}*/
out.print ("打印当前行的值。");
url = "jdbc:odbc:yingzha";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(url,"guoyy","guoyy");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from t_yzxx");
while (rs.next())
count = rs.getString(1)
i++;

%>

</body>
</html>

Location: /guoyy2.jsp
Internal Servlet Error:

org.apache.jasper.JasperException: Unable to compile class for JSPE:\jakarta-tomcat\work\localhost_8080\_0002fguoyy_00032_0002ejspguoyy2_jsp_7.java:81: ?????
count = rs.getString(1)
^
E:\jakarta-tomcat\work\localhost_8080\_0002fguoyy_00032_0002ejspguoyy2_jsp_7.java:81: ????????
count = rs.getString(1)
^
E:\jakarta-tomcat\work\localhost_8080\_0002fguoyy_00032_0002ejspguoyy2_jsp_7.java:82: ?????
i++;
^
3 ???

at org.apache.jasper.compiler.Compiler.compile(Compiler.java:247)
at org.apache.jasper.runtime.JspServlet.loadJSP(JspServlet.java:413)
at org.apache.jasper.runtime.JspServlet$JspServletWrapper.loadIfNecessary(JspServlet.java:149)
at org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java:161)
at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:261)
at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:369)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:559)
at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:160)
at org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338)
at java.lang.Thread.run(Thread.java:484)

...全文
67 2 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
  • 打赏
  • 举报
回复
while (rs.next()) {
count = rs.getString(1) ;
i++;
}
beyondii 2001-06-14
  • 打赏
  • 举报
回复
呵呵,同意楼上的!佩服

81,122

社区成员

发帖
与我相关
我的任务
社区描述
Java Web 开发
社区管理员
  • Web 开发社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧