日期:2014-05-17  浏览次数:20770 次

项目搭建问题
我之前按照视频学习了BBS项目,数据库连接都正常。可是今天想做一个商城,把项目考到myeclipse下后,部署服务器,也把sql存到的mysql可是打开网页却提示java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:798)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3700)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1203)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2568)
at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:620)
at java.sql.DriverManager.getConnection(DriverManager.java:222)
at com.bjsxt.shopping.util.DB.getConn(DB.java:9)
at com.bjsxt.shopping.category.CategoryService.getCategories(
可我访问BBS却可以。不知道那里设置错了。数据库在IDE的DB连接可以。就是浏览器大不了,报错。我数据库密码在mysql的命令提示窗口也能进入。不知道那里出了错误?怎么搭建?谢谢各位说的详细点。
IE报的错:
description The server encountered an internal error () that prevented it from fulfilling this request.

exception 

org.apache.jasper.JasperException: java.lang.NullPointerException
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:541)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:435)
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)
com.bjsxt.shopping.util.filter.IPFilter.doFilter(IPFilter.java:31)


root cause 

java.lang.NullPointerException
com.bjsxt.shopping.category.CategoryService.getCategories(CategoryService.java:102)
org.apache.jsp.Index_jsp._jspService(Index_jsp.java:95)
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:393)
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)
com.bjsxt.shopping.util.filter.IPFilter.doFilter(IPFilter.java:31)


note The full stack trace of the root cause is available in the Apache Tomcat/6.0.14 logs.

视频演示的时候是带着做完BBS直接把做好的Shopping项目引入。我跟他操作一样,不应该出错啊。。。。谢谢各位了。

------解决方案--------------------
是在连接的本地的mysql数据库么?
数据库用户名root的密码不对吧?
我的异常网推荐解决方案:The server encountered an internal error () that prevented it from fulfilling this request.,http://www.aiyiweb.com/java-web/317.html