<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*"%>
<html>
<body><%
Connection con=null;
Statement sql=null;
ResultSet rs=null;
StringBuffer nameList= new StringBuffer();try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e){
out.print(e);
}try{
con.DriverManager.getConnection("jdbc:odbc:vote","",""); sql=con.createStatement();
rs=sql.executeQuery("select * from city");
nameList.append("<FORM action=startvote.jsp method=post>");
nameList.append("<Table Border>");
nameList.append("<Table Border>");
nameList.append("<tr>");
nameList.append("<th width=100>"+"城市");
nameList.append("<th width=50>"+"投票选择");
nameList.append("</tr>"); while(rs.next()){ nameList.append("<TR>");
String name=rs.getString(1);
nameList.append("<TD>"+name+"</TD>");
String s="<Input type=radio name=name value="+name+">";
nameList.append("<TD>"+s+"</TD>");
nameList.append("</TR>");
} nameList.append("</Table>");
nameList.append("<Input type=submit value=提交>");
nameList.append("</FORM>");
cn.close();
out.print(nameList);
con.close(); */}catch(SQLException e1){}
%>
</BODY>
</HTML>
多次检查 Sys DSN 的设置没有问题, 我机器上安装的是office 2007 版本Error message as bellow :org.apache.jasper.JasperException: Unable to compile class for JSP: An error occurred at line: 23 in the jsp file: /vote.jsp
con.DriverManager cannot be resolved or is not a field
20:
21: try{
22:
23: con.DriverManager.getConnection("jdbc:odbc:vote","","");
24:
25: sql=con.createStatement();
26:
An error occurred at line: 50 in the jsp file: /vote.jsp
cn cannot be resolved
47: nameList.append("</Table>");
48: nameList.append("<Input type=submit value=Ìá½»>");
49: nameList.append("</FORM>");
50: cn.close();
51: out.print(nameList);
52: con.close(); */
53:
An error occurred at line: 52 in the jsp file: /vote.jsp
Syntax error on tokens, delete these tokens
49: nameList.append("</FORM>");
50: cn.close();
51: out.print(nameList);
52: con.close(); */
53:
54: }catch(SQLException e1){
55:
Stacktrace:
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:92)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:439)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:356)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:334)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:321)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:592)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
求解
解决方案 »
- java 系统后台session超时怎么退出iframe框架,求高手
- jsp购物车问题
- 怎样在javascript中调用hibernate?脑袋都快炸了,救命啊!~~~
- 下载文件名中有2个及以上的点时,IE自动添加方括号?
- 如何在JSP页面中显示多张存储在ORACLE数据库中(以二进制形式,BLob字段)的图片?
- 问个struts2的菜鸟级问题
- 关于ResultSet 关闭的问题!
- 如何在JSP页面实时画图,并显示在<td></td>里面, 不要生成图片文件,实在不行生成图片文件也行,谢谢!
- jsp怎么和sql 2000连接呀
- 个人微信是否可以发送文字链接???
- spring配置文件行头红叉叉,Referenced file contains errors
- jsp中用ckeditor替换原有编辑器的问题
========
con.close();
out.print(nameList);
con.close();
======最终测试出现一样的错误
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e){
out.print(e);
}try{
con.DriverManager.getConnection("jdbc:odbc:vote","",""); sql=con.createStatement(); String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=E:/db1.mdb";
// DBQ=是数据库的路径 DriverManager.getConnection(url);//一个差数
把数据库写到Dao里面
jsp页面只做显示
用MVC
=====
但是我只是想练习一下如何通过 odbc源来访问MS access数据库 把数据库写到Dao里面
jsp页面只做显示
用MVC
======
日会在做项目时会注意的,谢谢还请告之,是什么原因导出现以上的错误信息, 该如何修正。 谢谢