JSP网页引用JAVA里的方法就报错
下面的代码 主方法 运行无错误
嗯 应该说 方法都没错误 我试了 但是就算一个最简单的方法 用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)