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: Unable to compile class for JSP: An error occurred at line: 10 in the jsp file: /corrision/conn/conn.jsp
com.mysql.jdbc.Driver cannot be resolved to a type
7: Statement stmt;
8: ResultSet rs;
9: Class.forName("com.mysql.jdbc.Driver");
10: DriverManager.registerDriver(new com.mysql.jdbc.Driver());
11: String dbUrl="jdbc:mysql://localhost:3306/OA?useUnicode=true&characterEncoding=GBK";
12: String dbUser="root";
13: String dbPwd="123456";
Stacktrace:
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:92)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:423)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:316)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:294)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:281)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:566)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:317)
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)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.16 logs.
--------------------------------------------------------------------------------Apache Tomcat/6.0.16
这是conn.jsp
<%@ page contentType="text/html;charset=GBK" %>
<link rel="stylesheet" href="../conn/laba.css" type="text/css">
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%Connection con;
Statement stmt;
ResultSet rs;
Class.forName("com.mysql.jdbc.Driver");
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
String dbUrl="jdbc:mysql://localhost:3306/OA?useUnicode=true&characterEncoding=GBK";
String dbUser="root";
String dbPwd="123456";
con=java.sql.DriverManager.getConnection(dbUrl,dbUser,dbPwd);
stmt=con.createStatement();
%>各位高手帮忙看一下,愁死我了,弄了一个星期了,还是没弄明白
com.mysql.jdbc.Driver cannot be resolved to a type
7: Statement stmt;
8: ResultSet rs;
9: Class.forName("com.mysql.jdbc.Driver");
10: DriverManager.registerDriver(new com.mysql.jdbc.Driver());
11: String dbUrl="jdbc:mysql://localhost:3306/OA?useUnicode=true&characterEncoding=GBK";
12: String dbUser="root";
13: String dbPwd="123456";
Stacktrace:
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:92)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:423)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:316)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:294)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:281)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:566)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:317)
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)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.16 logs.
--------------------------------------------------------------------------------Apache Tomcat/6.0.16
这是conn.jsp
<%@ page contentType="text/html;charset=GBK" %>
<link rel="stylesheet" href="../conn/laba.css" type="text/css">
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%Connection con;
Statement stmt;
ResultSet rs;
Class.forName("com.mysql.jdbc.Driver");
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
String dbUrl="jdbc:mysql://localhost:3306/OA?useUnicode=true&characterEncoding=GBK";
String dbUser="root";
String dbPwd="123456";
con=java.sql.DriverManager.getConnection(dbUrl,dbUser,dbPwd);
stmt=con.createStatement();
%>各位高手帮忙看一下,愁死我了,弄了一个星期了,还是没弄明白
必须先向java程序注册Oracle JDBC驱动程序,然后才能打开数据库连接。
有两种注册Oracle JDBC驱动程序的办法。
1、使用java.lang.Class的forName()方法
例子:Class.forName("oracle.jdbc.OracleDriver");
2、使用JDBC DriverManager类的registerDriver()方法。
例子:DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
如果使用Oracle8i JDBC驱动程序,那么需要导入oracle.jdbc.driver.OracleDriver类,然后注册这个类的实例。
例子:
import oracle.jdbc.driver.OracleDriver;
DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
注意:从JDBC2.0开始,使用JDBC驱动程序的更标准办法是通过数据源。
//////////////////////////////////////////////////////////////////////////////////////////////////////////////
大哥啊,你把驱动注册了两次啊,干啥呢。看看上面的,你就明白了。而且我猜:你创建connection的那句语句可能也有问题
<link rel="stylesheet" href="../conn/laba.css" type="text/css">
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%Connection con;
Statement stmt;
ResultSet rs;
Class.forName("com.mysql.jdbc.Driver");
con=java.sql.DriverManager.getConnection(dbUrl,dbUser,dbPwd);
String dbUrl="jdbc:mysql://localhost:3306/OA?useUnicode=true&characterEncoding=GBK";
String dbUser="root";
String dbPwd="123456";
stmt=con.createStatement();
%>
再加上驱动应该没有问题了
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: /corrision/Check.jsp(3,0) File "/corrision/../conn/conn.jsp" not found
org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:40)
org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:407)
org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:88)
org.apache.jasper.compiler.Parser.processIncludeDirective(Parser.java:334)
org.apache.jasper.compiler.Parser.parseIncludeDirective(Parser.java:367)
org.apache.jasper.compiler.Parser.parseDirective(Parser.java:475)
org.apache.jasper.compiler.Parser.parseElements(Parser.java:1433)
org.apache.jasper.compiler.Parser.parse(Parser.java:133)
org.apache.jasper.compiler.ParserController.doParse(ParserController.java:216)
org.apache.jasper.compiler.ParserController.parse(ParserController.java:103)
org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:153)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:314)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:294)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:281)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:566)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:317)
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)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.16 logs.
--------------------------------------------------------------------------------Apache Tomcat/6.0.16