你TOMCAT好像和JDK没有关联起来
解决方案 »
- 与pentaho系统的整合问题,急...
- java 取磁盘信息??
- 调查下:大家Myeclipse/Eclipse用的是那一个版本?
- hibernate取到的list每一项都是null
- 求助啊 无法读出xml文件
- J2EE中的Servlet和Jsp是开源的吗?
- 瞧瞧看看! 会的帮帮忙!
- 请各位帮助我关于一个 No Context configured to process this request 的问题
- jsp动态生成wml页
- 字段是BigDecimal,用EJB QL 如何比较大小,定义finder方法
- tomcat数据源如何配置oracle数据库
- 查询结果在jsp中显示问题(利用Struts结构做的)??????在线等待!!!!!!!!!!!!!!!!!!
=======================================================
Connection sqlConn;=>java.sql.Connection sqlConn;
Statement sqlStmt;=>java.sql.Statement sqlStmt;
ResultSet sqlRst;=>java.sql.ResultSet sqlRst;
sqlConn=DriverManager.getConnection;=>
sqlConn=java.sql.DriverManager.getConnection
则会提示:
An error occurred at line: 2 in the jsp file: /mysql.jsp
Generated servlet error:
The method createStatment(int, int) is undefined for the type Connection
=======================================================================
苦恼
试试声明全局变量
<%!
Connection sqlConn;
Statement sqlStmt;
ResultSet sqlRst;
%>
===================================================================
org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 2 in the jsp file: /mysql.jsp
Generated servlet error:
The method createStatment(int, int) is undefined for the type Connection
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:328)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:389)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:288)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:267)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:255)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:556)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:296)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
连try都没有啊,兄弟,错误不少
=======================================================
刚开始学JAVA,只是测试以下JSP,异常处理还没用
String sqlQuery="SELECT * FROM testdata";
sqlRst=sqlStmt.executeQuery(sqlQuery);
改成:
String sqlQuery="SELECT * FROM testdata";
PreparedStatement sqlStmt=sqlConn.prepareStatement(sqlQuery, ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
sqlRst=sqlStmt.executeQuery();
试下,没试过,我比较喜欢用PreparedStatement
JDBC驱动也装了,NND,就是不成
俺玩C++也没遇到这么别扭的问题
<%@ page contentType="text/html;gb2312" import="java.sql.*" language="java"%>注意有些地方的空格。