JSP网页引用JAVA里的方法就报错

ZeroOverture 2011-07-19 10:58:09
下面的代码 主方法 运行无错误
嗯 应该说 方法都没错误 我试了 但是就算一个最简单的方法 用JSP引用就报错

public static void main(String age[]) throws SQLException {
// MySQL配置时的用户名
String sql="SELECT * FROM Account where user='admin' and pass='admin' and admin=2";
try {
Class.forName(driver);
conn=DriverManager.getConnection(url,user,password);
pstmt=conn.prepareStatement(sql);
rs=pstmt.executeQuery();
} catch (ClassNotFoundException e) {
System.out.println("驱动类找不到");
e.printStackTrace();
} catch (SQLException e) {
System.out.println("获取数据库失败");
e.printStackTrace();
}

while(rs.next()){
if(rs.getString("admin").equals("1")){
System.out.print(1);}
else{
System.out.print(2);}
}

}



public static ResultSet getCollection(String select) throws SQLException{



// MySQL配置时的用户名
String sql=select;


try {
Class.forName(driver);
conn=DriverManager.getConnection(url,user,password);
pstmt=conn.prepareStatement(sql);
rs=pstmt.executeQuery();
} catch (ClassNotFoundException e) {
System.out.println("驱动类找不到");
e.printStackTrace();
} catch (SQLException e) {
System.out.println("获取数据库失败");
e.printStackTrace();
}

return rs;
}



下面是引用的报错的地方 不管是什么方法引用就报错 用的是eclipse 在MyEclipse 中运行无错误(公司要求必须要eclipse)


2011-7-19 22:53:50 org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet [jsp] in context with path [] threw exception [Unable to compile class for JSP:

An error occurred at line: 37 in the jsp file: /MyWeb/WebContent/Admin_dr/lodin.jsp
MySql cannot be resolved
34: String sfjyh = request.getParameter("sfjyh");
35: String sfjmm = request.getParameter("sfjmm");
36: boolean jg=false;
37: ResultSet rs=MySql.getCollection("SELECT * FROM Account where user='admin' and pass='admin' and admin=2");
38: while( rs.next())
39: {
40: if(rs.getString("admin").equals("2")){


Stacktrace:] with root cause
org.apache.jasper.JasperException: Unable to compile class for JSP:

An error occurred at line: 37 in the jsp file: /MyWeb/WebContent/Admin_dr/lodin.jsp
MySql cannot be resolved
34: String sfjyh = request.getParameter("sfjyh");
35: String sfjmm = request.getParameter("sfjmm");
36: boolean jg=false;
37: ResultSet rs=MySql.getCollection("SELECT * FROM Account where user='admin' and pass='admin' and admin=2");
38: while( rs.next())
39: {
40: if(rs.getString("admin").equals("2")){


Stacktrace:
at org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:97)
at org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
at org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:457)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:374)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:352)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:339)
at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:601)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:344)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:389)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:333)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:563)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:403)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:301)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:162)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
...全文
231 4 打赏 收藏 转发到动态 举报
写回复
用AI写文章
4 条回复
切换为时间正序
请发表友善的回复…
发表回复
zl3450341 2011-07-20
  • 打赏
  • 举报
回复
你的Mysql定义了吗?
ZeroOverture 2011-07-20
  • 打赏
  • 举报
回复
这个是JAP页面 刚才没发上去
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%@ page import="fff.Tttext" %>
<%
String ss=Tttext.ff();
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<%=ss %>
</body>
</html>
ZeroOverture 2011-07-20
  • 打赏
  • 举报
回复
这个是我新写的两个 你看下 错误
JAVA类

package fff;
public class Tttext {
public static String ff(){
return "ff";
}
}

JSP页面



2011-7-20 22:37:58 org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet [jsp] in context with path [] threw exception [Unable to compile class for JSP:

An error occurred at line: 11 in the generated java file
Only a type can be imported. fff.Tttext resolves to a package

An error occurred at line: 5 in the jsp file: /text/WebContent/index.jsp
Tttext cannot be resolved
2: pageEncoding="utf-8"%>
3: <%@ page import="fff.Tttext" %>
4: <%
5: String ss=Tttext.ff();
6: %>
7: <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
8: <html>


Stacktrace:] with root cause
org.apache.jasper.JasperException: Unable to compile class for JSP:

An error occurred at line: 11 in the generated java file
Only a type can be imported. fff.Tttext resolves to a package

An error occurred at line: 5 in the jsp file: /text/WebContent/index.jsp
Tttext cannot be resolved
2: pageEncoding="utf-8"%>
3: <%@ page import="fff.Tttext" %>
4: <%
5: String ss=Tttext.ff();
6: %>
7: <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
8: <html>


Stacktrace:
at org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:97)
at org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
at org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:457)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:374)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:352)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:339)
at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:601)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:344)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:389)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:333)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:563)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:403)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:301)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:162)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:140)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
ZeroOverture 2011-07-20
  • 打赏
  • 举报
回复
导入吗?导入了[Quote=引用 1 楼 zl3450341 的回复:]

你的Mysql定义了吗?
[/Quote]

58,452

社区成员

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

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