救命！！！！连接mysql的问题！！！

把work目录下的test_jsp.java拷出来看看?

解决方案 »

  1.   

    to oicu:
    我的test_jsp.java如下：
    package org.apache.jsp;import javax.servlet.*;
    import javax.servlet.http.*;
    import javax.servlet.jsp.*;
    import org.apache.jasper.runtime.*;
    import java.sql.*;public class test_jsp extends HttpJspBase {
      private static java.util.Vector _jspx_includes;  public java.util.List getIncludes() {
        return _jspx_includes;
      }  public void _jspService(HttpServletRequest request, HttpServletResponse response)
            throws java.io.IOException, ServletException {    JspFactory _jspxFactory = null;
        javax.servlet.jsp.PageContext pageContext = null;
        HttpSession session = null;
        ServletContext application = null;
        ServletConfig config = null;
        JspWriter out = null;
        Object page = this;
        JspWriter _jspx_out = null;
        try {
          _jspxFactory = JspFactory.getDefaultFactory();
          response.setContentType("text/html;charset=gb2312");
          pageContext = _jspxFactory.getPageContext(this, request, response,
           null, true, 8192, true);
          application = pageContext.getServletContext();
          config = pageContext.getServletConfig();
          session = pageContext.getSession();
          out = pageContext.getOut();
          _jspx_out = out;      out.write("   \r\n");
          out.write(" \r\n");
          out.write("<html>   \r\n");
          out.write("<body>   \r\n");
    Class.forName("org.gjt.mm.mysql.Driver").newInstance();   
    String url="jdbc:mysql://localhost/test?user=root&password=cai&useUnicode=true&characterEncoding=8859_1";
    Connection conn= DriverManager.getConnection(url);   
    Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);   
    String sql="select * from note";   
    ResultSet rs=stmt.executeQuery(sql);   
    while(rs.next()) {
          out.write("   \r\n您的第一个字段内容为：");
          out.print(rs.getString(1));
          out.write("   \r\n");
    }
          out.write("   \r\n");
    out.print("数据库操作成功，恭喜你");
          out.write("   \r\n");
    rs.close();   
    stmt.close();   
    conn.close();         out.write("   \r\n");
          out.write("</body>   \r\n");
          out.write("</html> \r\n");
        } catch (Throwable t) {
          out = _jspx_out;
          if (out != null && out.getBufferSize() != 0)
            out.clearBuffer();
          if (pageContext != null) pageContext.handlePageException(t);
        } finally {
          if (_jspxFactory != null) _jspxFactory.releasePageContext(pageContext);
        }
      }
    }
      

  2.   

    我发现有没有mm.mysql.jdbc-1.2c这个文件夹都是这样的错误 ：（
      

  3.   

    我换了个驱动mm.mysql-2.0.4-bin.jar也是同样的问题。倒