<%@page contentType="text/html" pageEncoding="gb2312" import="java.sql.*" %>
<html>
<%
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con=DriverManager.getConnection("jdbc:mysql://localhost/first","test","123456");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from about");
while(rs.next())
{
System.out.println(rs.getString(1));
}
%>
</html>
报错:
HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Exception in JSP: /first.jsp:41: <%@page contentType="text/html" pageEncoding="gb2312" import="java.sql.*" %>
2: <html>
3: <%
4: Class.forName("com.mysql.jdbc.Driver").newInstance();
5: Connection con=DriverManager.getConnection("jdbc:mysql://localhost/first","test","123456");
6: Statement stmt=con.createStatement();
7: ResultSet rs=stmt.executeQuery("select * from about");我用try catch显示空白:
<%@page pageEncoding="gb2312" import="java.sql.*" %>
<%
try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con=DriverManager.getConnection("jdbc:mysql://localhost/first","test","123456");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from about");
while(rs.next())
{
System.out.println(rs.getString(1));
}
}
catch(Exception e)
{
System.out.print(e.toString());
}
%>
怎么弄,谢谢
<html>
<%
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con=DriverManager.getConnection("jdbc:mysql://localhost/first","test","123456");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from about");
while(rs.next())
{
System.out.println(rs.getString(1));
}
%>
</html>
报错:
HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Exception in JSP: /first.jsp:41: <%@page contentType="text/html" pageEncoding="gb2312" import="java.sql.*" %>
2: <html>
3: <%
4: Class.forName("com.mysql.jdbc.Driver").newInstance();
5: Connection con=DriverManager.getConnection("jdbc:mysql://localhost/first","test","123456");
6: Statement stmt=con.createStatement();
7: ResultSet rs=stmt.executeQuery("select * from about");我用try catch显示空白:
<%@page pageEncoding="gb2312" import="java.sql.*" %>
<%
try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con=DriverManager.getConnection("jdbc:mysql://localhost/first","test","123456");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from about");
while(rs.next())
{
System.out.println(rs.getString(1));
}
}
catch(Exception e)
{
System.out.print(e.toString());
}
%>
怎么弄,谢谢
解决方案 »
- java通过jacob调用word(求解)
- 如何在提交表单的时候判断文本框是否存在重复值?
- 解析 Ext 用户保存的数据
- 为什么我的JSP总是连不上MYSQL 请高手帮帮忙好吗?
- jsp中如何向SQL Server数据库中存储和读取word文件?
- 这个问题离奇~~~~就是关于设置errorPage的
- javaserver faces 如何在win下架构开发平台??? 有相关书籍下载嘛?
- 土问几个菜鸟问题^_^
- 用程序监视数据库,自动发出更新指令
- 关于jbuilder调试jsp??
- 请问resin和tomcat服务器那个好,各有什么优点,怎么配置??
- 本人刚学struts有个小问题请教各位大虾。
里面有数据,用mysql客户端可以使用。
我的各个程序版本是:
jdk-6u3-windows-i586-p.exe
mysql-4.1.22-win32.zip
apache-tomcat-5.5.25.exe
mysql-connector-java-3.1.14.zip
DriverManager.getConnection("jdbc:mysql://localhost:3306/first","test","123456");
是不是没有写端口号哦.
端口
连接字符串错误。你说Mysql中的表示About,连接字符串中的First改为“About”
jdbc:mysql://localhost/about
注意大小写!!good Luck
catalina_base=C:\Program Files\Apache Software Foundation\Tomcat 5.5catalina_home=C:\Program Files\Apache Software Foundation\Tomcat 5.5classpath=.;C:\Program Files\Java\jdk1.6.0_03\lib;C:\Program Files\Java\jdk1.6.0_03\lib\tools.jar;C:\Program Files\Java\jdk1.6.0_03\lib\dt.jar;C:\Program Files\Apache Software Foundation\Tomcat 5.5\common\lib\servlet-api.jar;C:\Program Files\Java\jdk1.6.0_03\lib\mysql-connector-java-3.1.14-bin-g.jar;C:\Program Files\Java\jdbc\mysql-connector-java-3.1.14-bin.jarjava_home=C:\Program Files\Java\jdk1.6.0_03path=.;C:\Program Files\Java\jdk1.6.0_03\bin;C:\Program Files\Java\jdk1.6.0_03\jre\bin;然后我这回连的时候是用com.mysql.jdbc.Driver这种方式的
书上是用org.gjt.mm.mysql.Driver,还将一个mm.mysql-2.0.4-bin.jar放到WEB-INF\lib里面,可以我没有这个文件夹啊!谢谢大家了,赶紧帮我解决了
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: com.mysql.jdbc.Driver
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:460)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:355)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)怎么办?
希望高手+我的QQ:328459914
很急这个问题,我的脑汁乳汁都快挤干了
谢谢大家了
我也出现过这问题