8.0w+
社区成员
JSP连接mysql出现的异常
我的代码如下：
<%@ page contentType="text/html; charset=gb2312" language="java" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<html>
<body>
<div align="center"><strong>数据库连接</strong></div>
<br>
<table width="800" border="1" align="center">
<tr>
<td align="center">用户名称</td>
<td align="center">用户密码</td>
<td align="center">用户权限</td>
</tr>
<%
try{
String driverName="com.mysql.jdbc.Driver";
String userName="root";
String userPassword="root";
String dbName="test";
String tableName="user";
String url="jdbc:mysql://localhost:3306/"+dbName+"?user="+userName+"&password="+userPassword;
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con=DriverManager.getConnection(url);
String sql="select * from"+tableName;
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
%>
<tr>
<td align="center"><%=rs.getString("username")%></td>
<td align="center"><%=rs.getString("userpwd")%></td>
<td align="center"><%=rs.getString("userxian")%></td>
</tr>
<%
}
rs.close();
stmt.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
%>
</tabel>
</body>
</html>
我将代码放在E:\Program Files\Tomcat 6.0\webapps\test中，出现的异常为：
HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: Unable to compile class for JSP:
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)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.10 logs.
我试着在MyEclipse里运行，同样出现异常，每次启动tomcat的时候没事，但是访问的时候就报错了：
Source not found for JkMain.pause() line: 679
还望高手指点。。。
<%@ page contentType="text/html; charset=gb2312" language="java" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<html>
<body>
<div align="center"><strong>数据库连接</strong></div>
<br>
<table width="800" border="1" align="center">
<tr>
<td align="center">用户名称</td>
<td align="center">用户密码</td>
<td align="center">用户权限</td>
</tr>
<%
try{
String driverName="com.mysql.jdbc.Driver";
String userName="root";
String userPassword="root";
String dbName="test";
String tableName="user";
String url="jdbc:mysql://localhost:3306/"+dbName+"?user="+userName+"&password="+userPassword;
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con=DriverManager.getConnection(url);
String sql="select * from"+tableName;
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
%>
<tr>
<td align="center"><%=rs.getString("username")%></td>
<td align="center"><%=rs.getString("userpwd")%></td>
<td align="center"><%=rs.getString("userxian")%></td>
</tr>
<%
}
rs.close();
stmt.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
%>
</tabel>
</body>
</html>
我将代码放在E:\Program Files\Tomcat 6.0\webapps\test中，出现的异常为：
HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: Unable to compile class for JSP:
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)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.10 logs.
我试着在MyEclipse里运行，同样出现异常，每次启动tomcat的时候没事，但是访问的时候就报错了：
Source not found for JkMain.pause() line: 679
还望高手指点。。。
...全文
当前发帖距今超过3年，不再开放新的回复
发表回复
potatomoon 2010-10-09
MyEclipse控制台信息:
2010-10-9 11:44:14 org.apache.catalina.core.AprLifecycleListener init
信息: The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Users\moon\AppData\Local\Genuitec\Common\binary\com.sun.java.jdk.win32.x86_1.6.0.013\bin;E:\Program Files\Tomcat 6.0\bin
2010-10-9 11:44:14 org.apache.coyote.http11.Http11Protocol init
严重: Error initializing endpoint
java.net.SocketException: Unrecognized Windows Sockets error: 0: JVM_Bind
at java.net.PlainSocketImpl.socketBind(Native Method)
at java.net.PlainSocketImpl.bind(PlainSocketImpl.java:359)
at java.net.ServerSocket.bind(ServerSocket.java:319)
at java.net.ServerSocket.<init>(ServerSocket.java:185)
at java.net.ServerSocket.<init>(ServerSocket.java:141)
at org.apache.tomcat.util.net.DefaultServerSocketFactory.createSocket(DefaultServerSocketFactory.java:50)
at org.apache.tomcat.util.net.JIoEndpoint.init(JIoEndpoint.java:494)
at org.apache.coyote.http11.Http11Protocol.init(Http11Protocol.java:175)
at org.apache.catalina.connector.Connector.initialize(Connector.java:1059)
at org.apache.catalina.core.StandardService.initialize(StandardService.java:578)
at org.apache.catalina.core.StandardServer.initialize(StandardServer.java:792)
at org.apache.catalina.startup.Catalina.load(Catalina.java:504)
at org.apache.catalina.startup.Catalina.load(Catalina.java:524)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:260)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:412)
2010-10-9 11:44:14 org.apache.catalina.startup.Catalina load
严重: Catalina.start
LifecycleException: Protocol handler initialization failed: java.net.SocketException: Unrecognized Windows Sockets error: 0: JVM_Bind
at org.apache.catalina.connector.Connector.initialize(Connector.java:1061)
at org.apache.catalina.core.StandardService.initialize(StandardService.java:578)
at org.apache.catalina.core.StandardServer.initialize(StandardServer.java:792)
at org.apache.catalina.startup.Catalina.load(Catalina.java:504)
at org.apache.catalina.startup.Catalina.load(Catalina.java:524)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:260)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:412)
2010-10-9 11:44:14 org.apache.catalina.startup.Catalina load
信息: Initialization processed in 751 ms
2010-10-9 11:44:14 org.apache.catalina.core.StandardService start
信息: Starting service Catalina
2010-10-9 11:44:14 org.apache.catalina.core.StandardEngine start
信息: Starting Servlet Engine: Apache Tomcat/6.0.10
2010-10-9 11:44:15 org.apache.catalina.core.ApplicationContext log
信息: ContextListener: contextInitialized()
2010-10-9 11:44:15 org.apache.catalina.core.ApplicationContext log
信息: SessionListener: contextInitialized()
2010-10-9 11:44:15 org.apache.coyote.http11.Http11Protocol start
严重: Error starting endpoint
java.net.SocketException: Unrecognized Windows Sockets error: 0: JVM_Bind
at java.net.PlainSocketImpl.socketBind(Native Method)
at java.net.PlainSocketImpl.bind(PlainSocketImpl.java:359)
at java.net.ServerSocket.bind(ServerSocket.java:319)
at java.net.ServerSocket.<init>(ServerSocket.java:185)
at java.net.ServerSocket.<init>(ServerSocket.java:141)
at org.apache.tomcat.util.net.DefaultServerSocketFactory.createSocket(DefaultServerSocketFactory.java:50)
at org.apache.tomcat.util.net.JIoEndpoint.init(JIoEndpoint.java:494)
at org.apache.tomcat.util.net.JIoEndpoint.start(JIoEndpoint.java:513)
at org.apache.coyote.http11.Http11Protocol.start(Http11Protocol.java:202)
at org.apache.catalina.connector.Connector.start(Connector.java:1132)
at org.apache.catalina.core.StandardService.start(StandardService.java:457)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
2010-10-9 11:44:15 org.apache.catalina.startup.Catalina start
严重: Catalina.start:
LifecycleException: service.getName(): "Catalina"; Protocol handler start failed: java.net.SocketException: Unrecognized Windows Sockets error: 0: JVM_Bind
at org.apache.catalina.connector.Connector.start(Connector.java:1139)
at org.apache.catalina.core.StandardService.start(StandardService.java:457)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
2010-10-9 11:44:15 org.apache.catalina.startup.Catalina start
信息: Server startup in 995 ms
2010-10-9 11:44:15 org.apache.catalina.core.StandardServer await
严重: StandardServer.await: create[8005]:
java.net.BindException: Address already in use: JVM_Bind
at java.net.PlainSocketImpl.socketBind(Native Method)
at java.net.PlainSocketImpl.bind(PlainSocketImpl.java:359)
at java.net.ServerSocket.bind(ServerSocket.java:319)
at java.net.ServerSocket.<init>(ServerSocket.java:185)
at org.apache.catalina.core.StandardServer.await(StandardServer.java:373)
at org.apache.catalina.startup.Catalina.await(Catalina.java:616)
at org.apache.catalina.startup.Catalina.start(Catalina.java:576)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
2010-10-9 11:44:14 org.apache.catalina.core.AprLifecycleListener init
信息: The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Users\moon\AppData\Local\Genuitec\Common\binary\com.sun.java.jdk.win32.x86_1.6.0.013\bin;E:\Program Files\Tomcat 6.0\bin
2010-10-9 11:44:14 org.apache.coyote.http11.Http11Protocol init
严重: Error initializing endpoint
java.net.SocketException: Unrecognized Windows Sockets error: 0: JVM_Bind
at java.net.PlainSocketImpl.socketBind(Native Method)
at java.net.PlainSocketImpl.bind(PlainSocketImpl.java:359)
at java.net.ServerSocket.bind(ServerSocket.java:319)
at java.net.ServerSocket.<init>(ServerSocket.java:185)
at java.net.ServerSocket.<init>(ServerSocket.java:141)
at org.apache.tomcat.util.net.DefaultServerSocketFactory.createSocket(DefaultServerSocketFactory.java:50)
at org.apache.tomcat.util.net.JIoEndpoint.init(JIoEndpoint.java:494)
at org.apache.coyote.http11.Http11Protocol.init(Http11Protocol.java:175)
at org.apache.catalina.connector.Connector.initialize(Connector.java:1059)
at org.apache.catalina.core.StandardService.initialize(StandardService.java:578)
at org.apache.catalina.core.StandardServer.initialize(StandardServer.java:792)
at org.apache.catalina.startup.Catalina.load(Catalina.java:504)
at org.apache.catalina.startup.Catalina.load(Catalina.java:524)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:260)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:412)
2010-10-9 11:44:14 org.apache.catalina.startup.Catalina load
严重: Catalina.start
LifecycleException: Protocol handler initialization failed: java.net.SocketException: Unrecognized Windows Sockets error: 0: JVM_Bind
at org.apache.catalina.connector.Connector.initialize(Connector.java:1061)
at org.apache.catalina.core.StandardService.initialize(StandardService.java:578)
at org.apache.catalina.core.StandardServer.initialize(StandardServer.java:792)
at org.apache.catalina.startup.Catalina.load(Catalina.java:504)
at org.apache.catalina.startup.Catalina.load(Catalina.java:524)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:260)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:412)
2010-10-9 11:44:14 org.apache.catalina.startup.Catalina load
信息: Initialization processed in 751 ms
2010-10-9 11:44:14 org.apache.catalina.core.StandardService start
信息: Starting service Catalina
2010-10-9 11:44:14 org.apache.catalina.core.StandardEngine start
信息: Starting Servlet Engine: Apache Tomcat/6.0.10
2010-10-9 11:44:15 org.apache.catalina.core.ApplicationContext log
信息: ContextListener: contextInitialized()
2010-10-9 11:44:15 org.apache.catalina.core.ApplicationContext log
信息: SessionListener: contextInitialized()
2010-10-9 11:44:15 org.apache.coyote.http11.Http11Protocol start
严重: Error starting endpoint
java.net.SocketException: Unrecognized Windows Sockets error: 0: JVM_Bind
at java.net.PlainSocketImpl.socketBind(Native Method)
at java.net.PlainSocketImpl.bind(PlainSocketImpl.java:359)
at java.net.ServerSocket.bind(ServerSocket.java:319)
at java.net.ServerSocket.<init>(ServerSocket.java:185)
at java.net.ServerSocket.<init>(ServerSocket.java:141)
at org.apache.tomcat.util.net.DefaultServerSocketFactory.createSocket(DefaultServerSocketFactory.java:50)
at org.apache.tomcat.util.net.JIoEndpoint.init(JIoEndpoint.java:494)
at org.apache.tomcat.util.net.JIoEndpoint.start(JIoEndpoint.java:513)
at org.apache.coyote.http11.Http11Protocol.start(Http11Protocol.java:202)
at org.apache.catalina.connector.Connector.start(Connector.java:1132)
at org.apache.catalina.core.StandardService.start(StandardService.java:457)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
2010-10-9 11:44:15 org.apache.catalina.startup.Catalina start
严重: Catalina.start:
LifecycleException: service.getName(): "Catalina"; Protocol handler start failed: java.net.SocketException: Unrecognized Windows Sockets error: 0: JVM_Bind
at org.apache.catalina.connector.Connector.start(Connector.java:1139)
at org.apache.catalina.core.StandardService.start(StandardService.java:457)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
2010-10-9 11:44:15 org.apache.catalina.startup.Catalina start
信息: Server startup in 995 ms
2010-10-9 11:44:15 org.apache.catalina.core.StandardServer await
严重: StandardServer.await: create[8005]:
java.net.BindException: Address already in use: JVM_Bind
at java.net.PlainSocketImpl.socketBind(Native Method)
at java.net.PlainSocketImpl.bind(PlainSocketImpl.java:359)
at java.net.ServerSocket.bind(ServerSocket.java:319)
at java.net.ServerSocket.<init>(ServerSocket.java:185)
at org.apache.catalina.core.StandardServer.await(StandardServer.java:373)
at org.apache.catalina.startup.Catalina.await(Catalina.java:616)
at org.apache.catalina.startup.Catalina.start(Catalina.java:576)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
licip 2010-10-09
他这个可能是数据库动太变动的吧。[Quote=引用 7 楼 gouxiongyaya 的回复:]
汗，看了半天才看出来你这错了
String url="jdbc:mysql://localhost:3306/"+dbName+"?user="+userName+"&password="+userPassword;
mysql里应该是这么用的吧
String url="jdbc:mysql://localhost:3306/test";
Connection con=Driver……
[/Quote]
汗，看了半天才看出来你这错了
String url="jdbc:mysql://localhost:3306/"+dbName+"?user="+userName+"&password="+userPassword;
mysql里应该是这么用的吧
String url="jdbc:mysql://localhost:3306/test";
Connection con=Driver……
[/Quote]
a619225471 2010-10-09
[Quote=引用 8 楼 jiajunqiang 的回复:]
这句话中form后面少个空格
String sql = "select * from " + tableName;
以后贴异常的时候贴全了，别人也好给你看啊，如果页面看不到就上eclipse的控制台看，或者tomcat的logs/catalina.out里面找
[/Quote]
up
这句话中form后面少个空格
String sql = "select * from " + tableName;
以后贴异常的时候贴全了，别人也好给你看啊，如果页面看不到就上eclipse的控制台看，或者tomcat的logs/catalina.out里面找
[/Quote]
up
jiajunqiang 2010-10-09
这句话中form后面少个空格
String sql = "select * from " + tableName;
以后贴异常的时候贴全了，别人也好给你看啊，如果页面看不到就上eclipse的控制台看，或者tomcat的logs/catalina.out里面找
String sql = "select * from " + tableName;
以后贴异常的时候贴全了，别人也好给你看啊，如果页面看不到就上eclipse的控制台看，或者tomcat的logs/catalina.out里面找
gouxiongyaya 2010-10-09
汗，看了半天才看出来你这错了
String url="jdbc:mysql://localhost:3306/"+dbName+"?user="+userName+"&password="+userPassword;
mysql里应该是这么用的吧
String url="jdbc:mysql://localhost:3306/test";
Connection con=DriverManager.getConnection(url,"root","root");
楼主再试试。。。
String url="jdbc:mysql://localhost:3306/"+dbName+"?user="+userName+"&password="+userPassword;
mysql里应该是这么用的吧
String url="jdbc:mysql://localhost:3306/test";
Connection con=DriverManager.getConnection(url,"root","root");
楼主再试试。。。
whut_lcy 2010-10-09
....................
potatomoon 2010-10-09
在MyEclipse里又出现另一个异常：
Source not found for JspServletWrapper.handleJspException(Exception) line: 483
直接访问http://localhost:8080/test/mysql.jsp时异常没有变
Source not found for JspServletWrapper.handleJspException(Exception) line: 483
直接访问http://localhost:8080/test/mysql.jsp时异常没有变
ddzhouqian 2010-10-09
[Quote=引用 2 楼 valen_jia 的回复:]
String sql="select * from "+tableName;
from后面弄个空格
[/Quote]
up
String sql="select * from "+tableName;
from后面弄个空格
[/Quote]
up
weipj007 2010-10-09
500错误应该是代码有问题。
valen_jia 2010-10-09
String sql="select * from "+tableName;
from后面弄个空格
from后面弄个空格
zyanxia6749girl 2010-10-09
将异常贴进google，页面显示和数据库连接代码最好分开写。
potatomoon 2010-10-09
引用 9 楼 a619225471 的回复:
引用 8 楼 jiajunqiang 的回复:
这句话中form后面少个空格
String sql = "select * from " + tableName;
以后贴异常的时候贴全了，别人也好给你看啊，如果页面看不到就上eclipse的控制台看，或者tomcat的logs/catalina.out里面找
up
up up
下次一定注意，，我把tomcat重装了，成功了！谢谢大家。。。。
引用 8 楼 jiajunqiang 的回复:
这句话中form后面少个空格
String sql = "select * from " + tableName;
以后贴异常的时候贴全了，别人也好给你看啊，如果页面看不到就上eclipse的控制台看，或者tomcat的logs/catalina.out里面找
up
up up
下次一定注意，，我把tomcat重装了，成功了！谢谢大家。。。。
JAVASUNING741 2010-10-09
[Quote=引用 9 楼 a619225471 的回复:]
引用 8 楼 jiajunqiang 的回复:
这句话中form后面少个空格
String sql = "select * from " + tableName;
以后贴异常的时候贴全了，别人也好给你看啊，如果页面看不到就上eclipse的控制台看，或者tomcat的logs/catalina.out里面找
up
[/Quote]
up up
引用 8 楼 jiajunqiang 的回复:
这句话中form后面少个空格
String sql = "select * from " + tableName;
以后贴异常的时候贴全了，别人也好给你看啊，如果页面看不到就上eclipse的控制台看，或者tomcat的logs/catalina.out里面找
up
[/Quote]
up up
ddzhouqian 2010-10-09
JVM_Bind
难道又是端口被占用的问题？
难道又是端口被占用的问题？
【求助】jsp连接Mysql数据库出现错误 【求助】jsp连接Mysql数据库出现错误 我已经配置好正确版本的数据库驱动，并且独立编写jsp测试数据库连接成功。但是当我用jsp做登录界面的时候，一直在Connection con = DriverManager.getConnection这句上报错。...
jsp 连接MySQL数据库错误一 javax.servlet.ServletException: javax.servlet.jsp.JspTagException: In <driver>, invalid driver class name: “java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver” 解决： Ja...
JSP连接mysql数据库实现用户登录 连接数据库基本操作就是这样，我用的是mysql，其他数据库同理。 <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> <% String path = request.getContextPath(); String basePath = ...
jsp连接mysql详解 1.开发环境：eclipse，jdk,mysql,tomcat 2.第一步下载 JDBC的包 百度云分享：https://pan.baidu.com/s/1Im2VgsSzSenZuL_0Y0p9gw 密码：druv （我的jdk版本比较高，所以能支持最新版本的jar，如果提示你jre版本过...
jsp连接数据库查询时出现空指针异常解决方法 在tomcat下的lib目录中导入mysql的驱动包,然后就好了 看看弄好了的效果图 最好的解决方法应该是通过Maven控制依赖包不过我maven玩的不是很溜，目前初学Jsp只能先就这样解决吧，还行，问题不大 希望以后使用不要...
通过JSP网页连接Mysql数据库 本文介绍通过JSP网页连接...用图形化管理工具Navicat Premium 连接MySQL数据库，在数据库“ming”下建立一张名为“teacher”的数据表。 2. 设置Tomcat 1)将JDBC驱动mysql-connector-java-5.1.43-bin.jar文件拷贝...
JSP——使用Eclipse编写JSP文件，连接Mysql数据库（代码与纠错） 环境前提： Windows10、eclipse、jdk8.0、Tomcat8.0.15、MySql8.0(此先后顺序，同样的也是从零开始的配置顺序...第一步：下载mysql的JDBC连接驱动程序（就是一个外部库文件） 下载链接：https://www.mysql.com/p...
最新Intellij Idea2020.01使用jsp实现连接mysql 通过简单的一个实例来实现jsp连接mysql 需要使用到idea mysql Tomcat等 1.创建javaWeb工程 2.在web下的WEB-INF下创建目录命名为bin 3.把mysql .jar文件放在bin目录下 这个东西另一篇文章里有清楚介绍下载存放...
javaweb项目连接mysql数据库出现【/index.jsp】时发现异常解决方法 javaweb项目连接mysql数据库出现【/index.jsp】时发现异常解决方法 强烈推荐一个资源站可以去了解一下:www.miaozan.art javaweb项目连接mysql数据库出现【/index.jsp】时发现异常解决方法，也被称作时区错误。 ...
在jsp中使用JDBC连接mysql数据库出现错误 在jsp中连接mysql数据库时产生的java.lang.ClassNotFoundException: com.mysql.jdbc.Driver问题 这个问题又浪费了我一晚上的时间，不过值得了，终于还是让我连上了mysql数据库。并通过tomcat服务器查询到了数据库...
记一次jsp连接mysql的错误排查(intelliJ IDEA有效) 本人load了一个jsp project，里面用的mysql驱动连接数据库。 但是连接数据库的时候,找不到数据库，debug，程序在ClassforName处抛出异常 我断定是ClassforName除了错误，此时我写了一个java程序来判断是否可以...
通过JSP网页连接MySQL数据库（java web 程序连接mysql数据库） -:连接MySQL: “jdbc:mysql://localhost:3306/databasename” 4>执行SQL语句接口Statement对象，该对象的常用方法: -:void close() 关闭释放资源 -:ResultSet executeQuery(String sql)：执行某条查询语句...
idea关于连接mysql数据库异常解决的方法 光是这样配置是不行的，就会出现如下的错误。 这时数据库是没有显示数据的，右下角也有报错信息。 说到这里你就会知道你的数据库在idea这里配置有问题了。那么你试试以下的两种方法，可以很好的解决这个问题 ...
JSP连接Mysql的数据库连接池配置相关 推荐开发环境： JDK+ Tomcat+Mysql+Myeclipse（按照安装顺序排列）。...先要下载好数据库连接驱动：mysql-connector-java-5.1.22-bin 放在tomcat的lib文件夹下，并在然后根据以下两种方法加以配置：
jsp页面连接不上MySQL数据库的问题 jsp页面连接不上MySQL数据库 java.lang.ClassNotFoundException: com.mysql.jdbc.Driver at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1284) at org.apache....
通过JSP网页连接并读取MySQL数据库中的表 通过JSP网页连接MYSQL数据库。 在MYSQL数据库中建立一张表。 在连接好后的JSP网页中显示出MYSQL数据库中的表。 前言 在前面，我们已经学习了如何建立、发布和访问JSP网页，在这篇文章中，我们来学习...
jsp连接mysql数据库时出现错误 当我们在用jsp连接mysql数据库时，出现如下错误时：SEVERE: Servlet.service() for servlet jsp threw exceptionorg.apache.jasper.JasperException: Unable to compile class for JSP: An error occurred at line: ...
