我的源程序是:<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost/jsptest?user=***&password=***&useUnicode=true&characterEncoding=GBK" ;
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
String query="select * from t";
ResultSet rs=stmt.executeQuery(query);
while(rs.next())
{
String s=rs.getString("field_name");//字段不是字符型的话就不能用getString,根据字段类使用getBoolean等等
int i=rs.getInt("v");
out.println(s+" "+i+"<br>");
}
%>
</body>
</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: 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/jsptest?user=***&password=***&useUnicode=true&characterEncoding=GBK" ;
8: Connection conn= DriverManager.getConnection(url);
9: Statement stmt=conn.createStatement();
10: String query="select * from t";
11: ResultSet rs=stmt.executeQuery(query);
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:505)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:398)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause javax.servlet.ServletException: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.ConnectException
MESSAGE: Connection refused: connectSTACKTRACE:java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)..........
我刚学jsp和mysql麻烦高手帮忙看一下,是怎么回事
解决方案 »
- 如何把mysql 转换成 access 数据库 或 sql server 数据库
- 我在mysql的某个中表中会不断插入连续的数据,但是由于出错的发生,导致一些数据没有插进去,现在想用一个sql语句来查查到底有哪些数据没插进去
- jsp mysql 条件查询 传值问题
- 简单问题,web服务器和mysql服务器分开,web服务器还需要安装mysql客户端吗?
- 请教3个表级联查询的问题
- MySql安装后什么图标都没有,如何启动它?
- bnwxf谢谢你,你过来看看呀
- 关于mysql见表的问题,请指教。
- 求高人解决个问题,php+mysql的,对你们应该很简单那
- 数据库问题。。小白求指点。。
- 高手进来:关于MySQL的C语言插入多条记录
- MySql LEFT JOIN 问题
sql写的不好也会出这样的问题。