具体是什么原因呢？netbeans mysql

sswlym

org.apache.jasper.JasperException: Exception in JSP: /jsp/mysql.jsp:8 5: <% 6: Class.forName("com.mysql.jdbc.Driver".newInstance(); 7: String url ="jdbc:mysql://localhost:3306/test?user=root&password=miracle&useUnicode=true&characterEncoding=GB2312" ; 8: Connection conn= DriverManager.getConnection(url); 9: Statement stmt=conn.createStatement(); 10: String query="select name from test order by id"; 11: ResultSet rs=stmt.executeQuery(query); 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)         org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:36 root cause javax.servlet.ServletException: Unknown character set: 'gb2312'         org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:85         org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)         org.apache.jsp.jsp.mysql_jsp._jspService(mysql_jsp.java:6         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)         org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:36 root cause com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown character set: 'gb2312'         sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)         sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)         sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)         java.lang.reflect.Constructor.newInstance(Constructor.java:513)         com.mysql.jdbc.Util.handleNewInstance(Util.java:406)         com.mysql.jdbc.Util.getInstance(Util.java:381)         com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1031)         com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)         com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)         com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:330         com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)         com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)         com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2537)         com.mysql.jdbc.ConnectionImpl.configureClientCharacterSet(ConnectionImpl.java:173         com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3422)         com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2046)         com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729)         com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)         sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)         sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)         sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)         java.lang.reflect.Constructor.newInstance(Constructor.java:513)         com.mysql.jdbc.Util.handleNewInstance(Util.java:406)         com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)         com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:283)         java.sql.DriverManager.getConnection(DriverManager.java:582)         java.sql.DriverManager.getConnection(DriverManager.java:207)         org.apache.jsp.jsp.mysql_jsp._jspService(mysql_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)         org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:36

我把mysql的jdbc驱动放到netbeans绑定的apache tomcat的common lib目录下了。
弄了很长时间了，就是不出头绪，给解决下吧。谢谢大家

sswlym

我的mysql是5.0.22   是不是mysql-conncter-jdbc驱动也要和版本对应呢? 可是在mysql.com是就那几个驱动。

mysql都能正常工作