jsp连接数据库的问题！奋斗了一天一夜！真不知道哪里出问题了！各位高手帮个忙！

2010-04-11 08:49:53 154 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

车辆TBOX科普第64次 TBOX系统集成测试与文档编写汽车电子开发中，TBOX作为核心网关面临独特挑战：需处理多网络接口、满足严苛安全标准并确保10年以上可靠性。项目文档是开发流程的核心资产，必须与编码同步更新，构建从需求到测试的完整闭环。系统集成测试需分层进行，结合硬件在环测试和自动化工具，并严格管理缺陷。文档与测试深度协同，通过追溯矩阵确保每个需求都被覆盖验证。最终交付不仅是软件包，更是一套包含完整验证报告的信任体系。这种严谨的工程纪律，是将代码转化为车规级可靠产品的关键保障。阅读详情

<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>

<%@page import="java.sql.*" %>

<html>

<head>



</head>

<body >

<%Class.forName("com.mysql.jdbc.Driver");

String ur="jdbc:mysql://localhost:3006/studentsdb?user=root&password=4300795&useUnicode=true&characterEncoding=GB2312";

Connection conn=DriverManager.getConnection(ur);

Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

String sql="select* from test";

ResultSet rs=stmt.executeQuery(sql);

while(rs.next()){

 %>第一个内容：<%=rs.getString(1) %>

 第二个：<%=rs.getString(2) %>

 <%} %>

 <%out.print("数据库操作成功"); %>

 <%

 rs.close();

 stmt.close();

 conn.close();

  %>

</body>

</html>

提示的错误：
2010-4-11 8:37:55 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servletjsp的Servlet.service()发生意外(exception)
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.security.AccessControlException: access denied (java.net.SocketPermission 127.0.0.1:3006 connect,resolve)

STACKTRACE:

java.net.SocketException: java.security.AccessControlException: access denied (java.net.SocketPermission 127.0.0.1:3006 connect,resolve)
at com.mysql.jdbc.StandardSocketFactory.unwrapExceptionToProperClassAndThrowIt(StandardSocketFactory.java:291)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:182)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:267)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2739)
at com.mysql.jdbc.Connection.<init>(Connection.java:1553)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:207)
at org.apache.jsp.landing_jsp._jspService(landing_jsp.java:53)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at sun.reflect.GeneratedMethodAccessor43.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:243)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:275)
at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:161)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:245)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:50)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:156)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:152)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:619)

** END NESTED EXCEPTION **

Last packet sent to the server was 0 ms ago.
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2814)
at com.mysql.jdbc.Connection.<init>(Connection.java:1553)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:207)
at org.apache.jsp.landing_jsp._jspService(landing_jsp.java:53)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at sun.reflect.GeneratedMethodAccessor43.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:243)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:275)
at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:161)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:245)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:50)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:156)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:152)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:619)

我的mysql 是5.1.41的用的驱动是：5.1.12的应该可以吧？驱动已经加到了tomcat、common的lib下面了！

...全文

AVEVA PDMS 二次开发之PML实战：从宏到自定义窗体的效率提升本文详细介绍了AVEVA PDMS二次开发中PML语言的应用，从基础宏编写到高级窗体开发，全面提升工程设计效率。通过实战案例展示如何利用PML实现批量操作、流程自动化和交互优化，帮助工程师快速掌握这一强大工具。阅读详情

liuyangfiy

Web 开发 81,108 成员 341,721 内容

+ 关注 + 加入社区

切换为时间正序

meander 2010-04-11

打赏
举报

[Quote=引用 1 楼 silence_smile 的回复:]

access denied (java.net.SocketPermission 127.0.0.1:3006 connect,resolve)
很清楚了，mysql的端口是3306，改成3306就行了
[/Quote]

感觉是驱动的问题

liuyangfiy 2010-04-11

打赏
举报

[Quote=引用 7 楼 zlp5201 的回复:]
你那个Classfor()啊关闭啊什么的异常没有捕获啊
<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@page import="java.sql.*" %>
<%

ResultSet rs=null;
Statement stmt=null;
Connection conn=nu……
[/Quote]
谢谢我试试看看！

liuyangfiy 2010-04-11

打赏
举报

我个人觉得也应该是驱动的问题，但是我没找到配套的！我用的是MySQL6.0 好像没找到相应的驱动！

angun123 2010-04-11

打赏
举报

同意7楼，估计是没有对异常进行捕捉.

铁匠梁 2010-04-11

打赏
举报

修改后重启一下tomcat，把work\Catalina目录删掉，再测试

那时花开 2010-04-11

打赏
举报

你那个Classfor()啊关闭啊什么的异常没有捕获啊
<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@page import="java.sql.*" %>
<%

ResultSet rs=null;
Statement stmt=null;
Connection conn=null;
try{

Class.forName("com.mysql.jdbc.Driver");
String ur="jdbc:mysql://localhost:3306/ch01?user=root&password=19890921";
conn=DriverManager.getConnection(ur);
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select* from user_info";
rs=stmt.executeQuery(sql);
%>
<html>
<head>
<title>现在的代码</title>
</head>
<body >
<%
while(rs.next()){
%>
<tr><td>第一个内容：<%=rs.getString(1)%></td>
<td>第二个：<%=rs.getString(2)%></td>
</tr>
<%
}
out.print("数据库操作成功");

}catch(Exception e){}
finally{

rs.close();
stmt.close();
conn.close();

}
%>
</body>
</html>
不好意思把你的代码改成乱七八糟的

悠悠虾 2010-04-11

打赏
举报

感觉是你的jdbc驱动没有安装合适，建议你重新安装一下，祝你好运！

zq5337 2010-04-11

打赏
举报

qudong/>???

xiaoguosoftware 2010-04-11

打赏
举报

估计是驱动的问题。

liuyangfiy 2010-04-11

打赏
举报

现在的代码是：
<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@page import="java.sql.*" %>
<html>
<head>

</head>
<body >
<%
Class.forName("com.mysql.jdbc.Driver");
String ur="jdbc:mysql://localhost:3306/studentsdb?user=root&password=4300795&useUnicode=true&characterEncoding=GB2312";
Connection conn=DriverManager.getConnection(ur);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select* from test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){%>
第一个内容：<%=rs.getString(1) %>
第二个：<%=rs.getString(2) %>
<%} %>
<%out.print("数据库操作成功"); %>
<%
rs.close();
stmt.close();
conn.close();
%>
</body>
</html>

liuyangfiy 2010-04-11

打赏
举报

哦先前改过来了也不行！

Silence_Smile 2010-04-11

打赏
举报

access denied (java.net.SocketPermission 127.0.0.1:3006 connect,resolve)
很清楚了，mysql的端口是3306，改成3306就行了

qingzhe2008 2010-04-11

打赏
举报

问题解决了就好。把问题原因和解决方法整理出来，好为后人所用。

leearnold 2010-04-11

打赏
举报

mysql访问权限问题?

liuyangfiy 2010-04-11

打赏
举报

各位谢谢了！！我终于找到解决方法了！！！虽然答案不是你们给出的但是谢谢还是要表达的呵呵！

jsp连接数据库的问题！ 奋斗了一天一夜！真不知道哪里出问题了！各位高手帮个忙！

相关推荐

jsp连接数据库的问题！奋斗了一天一夜！真不知道哪里出问题了！各位高手帮个忙！