以下是JSP连接数据库的代码.提示找不到com.mysql.jdbc.Driver 而我在一个测试的Servlet文件中却可以连接上.
请大家帮忙看看.谢谢.!
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*,javax.sql.*,javax.naming.*" %><%
String url = "jdbc:mysql://127.0.0.1:3306/mysql?characterEncoding=utf-8";
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection(url,"root","12345678");
Statement stmt = conn.createStatement();
out.println("OK");
%>
请大家帮忙看看.谢谢.!
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*,javax.sql.*,javax.naming.*" %><%
String url = "jdbc:mysql://127.0.0.1:3306/mysql?characterEncoding=utf-8";
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection(url,"root","12345678");
Statement stmt = conn.createStatement();
out.println("OK");
%>
import java.sql.Connection;
import java.sql.DriverManager; public class Conn {
public static Connection getConn() {
Connection conn = null;
String driver = "com.mysql.jdbc.Driver";
String sourse = "jdbc:mysql://127.0.0.1:3306/mysql?characterEncoding=utf-8";
try {
Class.forName(driver);
conn = DriverManager.getConnection(sourse, "root", "12345678");
} catch (Exception e) {
System.out.println(e.toString());
}
return conn;
} public static void main(String[] args) {
System.out.println("Hello!" + Conn.getConn());
}
}
返回的值是Hello!com.mysql.jdbc.Connection@e24e2a.
说明连接成功了.但在JSP中一直提示找不到驱动.不知道为什么.