jsp连接oracle时,在tomcat环境下怎么配置数据库,以及class 文件如何存放

dgyujingjun 2003-08-22 10:58:05
jsp连接oracle时,在tomcat环境下怎么配置数据库,以及class 文件如何存放


我编写了一个jsp文件,用来读取数据库并显示出来,其中调用javabean(Bean名叫DataBase.java),javabean 中
用来连接oracle以及查询、操作数据表中的数据

如何存放DataBase.class文件,以及是否要配置数据库
...全文
89 5 打赏 收藏 转发到动态 举报
写回复
用AI写文章
5 条回复
切换为时间正序
请发表友善的回复…
发表回复
shekarry 2003-08-26
  • 打赏
  • 举报
回复
你的class 文件要放到一个包里才可以,如建立一个test包,把test包放到WEB-INF\classes下,jsp 如下:


<jsp:useBean id="mydb" scope="session" class="test.DataBase" />

<body>
<%

ResultSet rs = null;
String sql="select * from zxktgl";

rs=mydb.ExcuteQuery(sql);
rs.next();
out.print(rs.getString(2));
%>




dgyujingjun 2003-08-26
  • 打赏
  • 举报
回复
type Exception report

message Internal Server Error

description The server encountered an internal error (Internal Server Error) that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 10 in the jsp file: /first.jsp

Generated servlet error:
D:\JBuilder6\jakarta-tomcat-4.0.1\work\localhost\_\first$jsp.java:65: Class org.apache.jsp.DataBase not found.
DataBase mydb = null;
^


An error occurred at line: 10 in the jsp file: /first.jsp

Generated servlet error:
D:\JBuilder6\jakarta-tomcat-4.0.1\work\localhost\_\first$jsp.java:68: Class org.apache.jsp.DataBase not found.
mydb= (DataBase)
^


An error occurred at line: 10 in the jsp file: /first.jsp

Generated servlet error:
D:\JBuilder6\jakarta-tomcat-4.0.1\work\localhost\_\first$jsp.java:73: Class org.apache.jsp.DataBase not found.
mydb = (DataBase) java.beans.Beans.instantiate(this.getClass().getClassLoader(), "DataBase");
^
3 errors

at org.apache.jasper.compiler.Compiler.compile(Compiler.java:284)
at org.apache.jasper.servlet.JspServlet.loadJSP(JspServlet.java:546)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.loadIfNecessary(JspServlet.java:177)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:189)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:382)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:474)
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:201)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:518)
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:2344)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
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:462)
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:163)
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:1011)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1106)
at java.lang.Thread.run(Thread.java:484)

dgyujingjun 2003-08-23
  • 打赏
  • 举报
回复
我的jsp代码是:

<jsp:useBean id="mydb" scope="session" class="DataBase" />

<body>
<%

ResultSet rs = null;
String sql="select * from zxktgl";

rs=mydb.ExcuteQuery(sql);
rs.next();
out.print(rs.getString(2));
%>


错误提示

org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 10 in the jsp file: /first.jsp

Generated servlet error:
D:\JBuilder6\jakarta-tomcat-4.0.1\work\localhost\_\first$jsp.java:65: Class org.apache.jsp.DataBase not found.
DataBase mydb = null;
^


An error occurred at line: 10 in the jsp file: /first.jsp

Generated servlet error:
D:\JBuilder6\jakarta-tomcat-4.0.1\work\localhost\_\first$jsp.java:68: Class org.apache.jsp.DataBase not found.
mydb= (DataBase)
^


An error occurred at line: 10 in the jsp file: /first.jsp

Generated servlet error:
D:\JBuilder6\jakarta-tomcat-4.0.1\work\localhost\_\first$jsp.java:73: Class org.apache.jsp.DataBase not found.
mydb = (DataBase) java.beans.Beans.instantiate(this.getClass().getClassLoader(), "DataBase");
^
3 errors



gzh_seagull 2003-08-23
  • 打赏
  • 举报
回复
把oracle的jdbc库放在tomcat目录下common/lib
class文件放在项目目录下WEB-INF/classes下面
dgyujingjun 2003-08-22
  • 打赏
  • 举报
回复
有没有高手啊

24,922

社区成员

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

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