故障:JSP连不上MYSQL数据库!!
配置:
JDK5.0.11 + tomcat6.0 + mysql5.0 分别测试安装成功,运行.然后下载驱动mm.mysql,(这个解释一下,没有用最新那个什么驱动是因为我做的毕业设计上是用这个驱动).然后解压出一个文件org\gjt\mm\mysql,放到这个路径C:\Tomcat 6.0\webapps\ROOT\WEB-INF\classes\org\gjt\mm\mysql测试代码:
<%@ page contentType="text/html;charset=gb22" %>
<%@ page import="java.sql.*" %>
<html>
<body>
<%
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url="jdbc:mysql://localhost/bookstore?user=depthman&"+"password=depthman&useUnicode=true;characterEncoding=8859_1"
//depthman是mysql的用户名,密码也是depthman,我不知道这一句写的对不对!?
bookstore是已经存在的数据库.
Connection conn=DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
String sql="select * from bookstore;";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){%>
第一个字段内容为:<% =rs.getString(1) %>
第二个字段内容为:<% =rs.getString(2) %>
<%}%>
<% out.print("数据库操作成功,恭喜你!!!"); %>
rs.close();
stmt.close();
conn.close();
%></body>
</html>错误:
org.apache.jasper.JasperException: Unable to compile class for JSP: An error occurred at line: 7 in the jsp file: /test.jsp
Syntax error, insert ";" to complete LocalVariableDeclarationStatement
4: <body>
5: <%
6: Class.forName("org.gjt.mm.mysql.Driver").newInstance();
7: String url="jdbc:mysql://localhost/bookstore?user=depthman&"+"password=depthman&useUnicode=true;characterEncoding=8859_1"
8: Connection conn=DriverManager.getConnection(url);
9: Statement stmt=conn.createStatement();
10: String sql="select * from bookstore;";
An error occurred at line: 13 in the jsp file: /test.jsp
Syntax error on token "=", @ expected
10: String sql="select * from bookstore;";
11: ResultSet rs=stmt.executeQuery(sql);
12: while(rs.next()){%>
13: 第一个字段内容为:<% =rs.getString(1) %>
14: 第二个字段内容为:<% =rs.getString(2) %>
15: <%}%>
16: <% out.print("数据库操作成功,恭喜你!!!"); %>
An error occurred at line: 13 in the jsp file: /test.jsp
Syntax error on token(s), misplaced construct(s)
10: String sql="select * from bookstore;";
11: ResultSet rs=stmt.executeQuery(sql);
12: while(rs.next()){%>
13: 第一个字段内容为:<% =rs.getString(1) %>
14: 第二个字段内容为:<% =rs.getString(2) %>
15: <%}%>
16: <% out.print("数据库操作成功,恭喜你!!!"); %>
An error occurred at line: 14 in the jsp file: /test.jsp
Syntax error on token "=", @ expected
11: ResultSet rs=stmt.executeQuery(sql);
12: while(rs.next()){%>
13: 第一个字段内容为:<% =rs.getString(1) %>
14: 第二个字段内容为:<% =rs.getString(2) %>
15: <%}%>
16: <% out.print("数据库操作成功,恭喜你!!!"); %>
17: rs.close();
An error occurred at line: 14 in the jsp file: /test.jsp
Syntax error on token(s), misplaced construct(s)
11: ResultSet rs=stmt.executeQuery(sql);
12: while(rs.next()){%>
13: 第一个字段内容为:<% =rs.getString(1) %>
14: 第二个字段内容为:<% =rs.getString(2) %>
15: <%}%>
16: <% out.print("数据库操作成功,恭喜你!!!"); %>
17: rs.close();
Stacktrace:
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:85)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:415)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:308)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:286)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:273)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:566)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:308)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)谢谢你能看完,请给点意见,小生感激不尽!
配置:
JDK5.0.11 + tomcat6.0 + mysql5.0 分别测试安装成功,运行.然后下载驱动mm.mysql,(这个解释一下,没有用最新那个什么驱动是因为我做的毕业设计上是用这个驱动).然后解压出一个文件org\gjt\mm\mysql,放到这个路径C:\Tomcat 6.0\webapps\ROOT\WEB-INF\classes\org\gjt\mm\mysql测试代码:
<%@ page contentType="text/html;charset=gb22" %>
<%@ page import="java.sql.*" %>
<html>
<body>
<%
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url="jdbc:mysql://localhost/bookstore?user=depthman&"+"password=depthman&useUnicode=true;characterEncoding=8859_1"
//depthman是mysql的用户名,密码也是depthman,我不知道这一句写的对不对!?
bookstore是已经存在的数据库.
Connection conn=DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
String sql="select * from bookstore;";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){%>
第一个字段内容为:<% =rs.getString(1) %>
第二个字段内容为:<% =rs.getString(2) %>
<%}%>
<% out.print("数据库操作成功,恭喜你!!!"); %>
rs.close();
stmt.close();
conn.close();
%></body>
</html>错误:
org.apache.jasper.JasperException: Unable to compile class for JSP: An error occurred at line: 7 in the jsp file: /test.jsp
Syntax error, insert ";" to complete LocalVariableDeclarationStatement
4: <body>
5: <%
6: Class.forName("org.gjt.mm.mysql.Driver").newInstance();
7: String url="jdbc:mysql://localhost/bookstore?user=depthman&"+"password=depthman&useUnicode=true;characterEncoding=8859_1"
8: Connection conn=DriverManager.getConnection(url);
9: Statement stmt=conn.createStatement();
10: String sql="select * from bookstore;";
An error occurred at line: 13 in the jsp file: /test.jsp
Syntax error on token "=", @ expected
10: String sql="select * from bookstore;";
11: ResultSet rs=stmt.executeQuery(sql);
12: while(rs.next()){%>
13: 第一个字段内容为:<% =rs.getString(1) %>
14: 第二个字段内容为:<% =rs.getString(2) %>
15: <%}%>
16: <% out.print("数据库操作成功,恭喜你!!!"); %>
An error occurred at line: 13 in the jsp file: /test.jsp
Syntax error on token(s), misplaced construct(s)
10: String sql="select * from bookstore;";
11: ResultSet rs=stmt.executeQuery(sql);
12: while(rs.next()){%>
13: 第一个字段内容为:<% =rs.getString(1) %>
14: 第二个字段内容为:<% =rs.getString(2) %>
15: <%}%>
16: <% out.print("数据库操作成功,恭喜你!!!"); %>
An error occurred at line: 14 in the jsp file: /test.jsp
Syntax error on token "=", @ expected
11: ResultSet rs=stmt.executeQuery(sql);
12: while(rs.next()){%>
13: 第一个字段内容为:<% =rs.getString(1) %>
14: 第二个字段内容为:<% =rs.getString(2) %>
15: <%}%>
16: <% out.print("数据库操作成功,恭喜你!!!"); %>
17: rs.close();
An error occurred at line: 14 in the jsp file: /test.jsp
Syntax error on token(s), misplaced construct(s)
11: ResultSet rs=stmt.executeQuery(sql);
12: while(rs.next()){%>
13: 第一个字段内容为:<% =rs.getString(1) %>
14: 第二个字段内容为:<% =rs.getString(2) %>
15: <%}%>
16: <% out.print("数据库操作成功,恭喜你!!!"); %>
17: rs.close();
Stacktrace:
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:85)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:415)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:308)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:286)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:273)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:566)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:308)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)谢谢你能看完,请给点意见,小生感激不尽!
解决方案 »
- 新手求指教,希望各位大侠闲暇帮看看。
- struts错误,高手帮帮忙啊
- 为什么我的Web App Libraries文件夹没有import选项?
- 有谁配置过Yale的CAS吗?求教
- 大家一般把数据库的连接写在哪儿?
- 在struts的validator时错误信息提示的方式,急啊!!!
- jbuilder
- 散分的帖也要删除吗?大家说说看?
- 用JAVABEAN控制管道和队列
- 客户端调用Servlet的具体过程为何?Servlet对每一个请求是否初始化
- 为什么使用enctype="multipart/form-data"后会占用大量的页面文件呢?
- spring+struts搞手入内,有关spring的AOP拦截struts的动态Action的问题
我已经改好了,可是又出现这样的问题,是不是驱动没有配好?
org.apache.jasper.JasperException: An exception occurred processing JSP page /test.jsp at line 85: <%
6: Class.forName("org.gjt.mm.mysql.Driver").newInstance();
7: String url="jdbc:mysql://localhost/shopping?user=depthman&"+"password=depthman&useUnicode=true;characterEncoding=8859_1";
8: Connection conn=DriverManager.getConnection(url);
9: Statement stmt=conn.createStatement();
10: String sql="select * from addressbook;";
11: ResultSet rs=stmt.executeQuery(sql);
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:515)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:408)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause javax.servlet.ServletException: java.sql.SQLException: Invalid authorization specification: Access denied for user 'depthman'@'localhost' (using password: YES)
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:855)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:784)
org.apache.jsp.test_jsp._jspService(test_jsp.java:91)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:384)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause java.sql.SQLException: Invalid authorization specification: Access denied for user 'depthman'@'localhost' (using password: YES)
org.gjt.mm.mysql.MysqlIO.init(Unknown Source)
org.gjt.mm.mysql.Connection.connectionInit(Unknown Source)
org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Unknown Source)
org.gjt.mm.mysql.Driver.connect(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
org.apache.jsp.test_jsp._jspService(test_jsp.java:61)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:384)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
运行后出现org.apache.jasper.JasperException: javax.servlet.ServletException: java.sql.SQLException: Invalid authorization specification: Access denied for user 'depthman'@'localhost' (using password: YES)
是不是depthman这个用户名字出错?
我的mysql安装时候添的用户名和密码名.
请问是怎么会事情?
错误显示的是你的帐户没有获得授权访问阿.或者删除帐户后重新建.
我怎么给分给你?