javabean里的sql无法运行,请指教!!!

Question

<%@ page language="java" import="java.sql.*" %>
没有把自己的包，包含进来！！
<%@ page language="java" import="java.sql.*；Mysqltest.*" %>
应该就行了！你试试！！

Answer 1

haoming0(龙啸冰河):
不行啊,还报错呢
org.apache.jasper.JasperException: Unable to compile class for JSPNote: sun.tools.javac.Main has been deprecated.D:\Program Files\Apache Tomcat 4.0\work\Standalone\localhost\_\website\javabeantest$jsp.java:3: Class or interface declaration expected.
import java.sql.*;Mysqltest.*;
                  ^D:\Program Files\Apache Tomcat 4.0\work\Standalone\localhost\_\website\javabeantest$jsp.java:10: Superclass org.apache.jsp.HttpJspBase of class org.apache.jsp.javabeantest$jsp not found.
public class javabeantest$jsp extends HttpJspBase {
                                      ^
2 errors, 1 warning

Answer 2

skyboy0720(敏，等你回来拿礼物！) :
java.lang.NullPointerException
at org.apache.jsp.javabeantest$jsp._jspService(javabeantest$jsp.java:94)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:201)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1027)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125)
at java.lang.Thread.run(Thread.java:536)就报这个错误

Answer 3

很明显是没有找你到你写的类,看看你是不是放到WEB-INF/classes/里面的

Answer 4

DBconn():org.gjt.mm.mysql.Driver
aq.executeQuery:No suitable drivertomcat出现了这样的错误,是不是应为我得mysql驱动没有放在jdk里只放在了tomcat里造成的?

Answer 5

你的类要放在WEB-INF/classes/Mysqltest/里才行！

Answer 6

准确的说,编译的类应放在WEB-INF/classes/Mysqltest内,
而mysql驱动只需放在Tomcat的common\lib目录内

Answer 7

如果是jar文件放WEB-INF/lib目录里

Answer 8

我的类就是放在WEB-INF/classes/Mysqltest下的

Answer 9

应该jsp文件布署的问题吧
我以前也遇到过
后来找了个例子,把自己的文件拷过去(把原来的文件覆盖掉),结果可以了,呵呵....
不妨试一下