下面的代码 主方法 运行无错误
嗯 应该说 方法都没错误 我试了 但是就算一个最简单的方法 用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)
嗯 应该说 方法都没错误 我试了 但是就算一个最简单的方法 用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)
ResultSet rs=MySql.getCollection("SELECT * FROM Account where user='admin' and pass='admin' and admin=2");
错误信息提示了,mysql这个类找不到。你要把这个类在jsp开头引进来。或者写mysql的全限定名,像
java.util.Date这样写,加上你的包名。
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 packageAn 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 packageAn 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)
<%@ 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>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
这两个的charset统一 一下试试