jsp 连接mysql

xjl2005

以是是我连接mysql的简要代码：
<%@ page contentType="text/html;charset=GB2312"%>
<%@ page language="java" import="java.sql.*"%>
<%
java.sql.Connection sqlConn;
java.sql.Statement sqlStmt;
java.sql.ResultSet sqlRst;
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
sqlConn = java.sql.DriverManager.getConnection("jdbc:mysql://localhost/test","root","123456");

%>
以下是出错信息：
type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: Exception in JSP: /mysql_test.jsp:8

5: java.sql.Statement sqlStmt;
6: java.sql.ResultSet sqlRst;
7: Class.forName("org.gjt.mm.mysql.Driver").newInstance();
8: sqlConn = java.sql.DriverManager.getConnection("jdbc:mysql://localhost/test","root","123456");
9:
10: %>
11:


Stacktrace:
        org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:504)
        org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
        org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
        org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


root cause

javax.servlet.ServletException: null,  message from server: "Host 'localhost.localdomain' is not allowed to connect to this MySQL server"
        org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
        org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
        org.apache.jsp.mysql_005ftest_jsp._jspService(mysql_005ftest_jsp.java:60)
        org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
        org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
        org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


root cause

java.sql.SQLException: null,  message from server: "Host 'localhost.localdomain' is not allowed to connect to this MySQL server"
        com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
        com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:997)
        com.mysql.jdbc.Connection.createNewIO(Connection.java:2644)
        com.mysql.jdbc.Connection.<init>(Connection.java:1531)
        com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
        java.sql.DriverManager.getConnection(DriverManager.java:525)
        java.sql.DriverManager.getConnection(DriverManager.java:171)
        org.apache.jsp.mysql_005ftest_jsp._jspService(mysql_005ftest_jsp.java:50)
        org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
        org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
        org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


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

wd_afei

Host 'localhost.localdomain' is not allowed to connect to this MySQL server

mysql不允许你得host链接，配mysql去。

xjl2005

谢谢，搞定了

hgkrt

现在怎么都是通过JSP来直接操作SQL嘛??

偶作的开发都是JAVA来作, JSP只作显示..无其他功能...

jj.chen

楼上的说的对！

jsp负责显示，servlet负责控制，楼主有兴趣可以去看看struts等mvc框架

hgkrt

struts作web真是方便...

配合hibernate, 就更爽了..

当然还有其他好多frame的...

xjl2005

谢谢大家的支持啊

hgkrt

另外JSTL用在JSP里面, 也是非常爽的...