游西湖作文:org/aspectj/lang/Signature

来源:百度文库 编辑:杭州交通信息网 时间:2024/05/05 23:01:03
mysql连接jsp,Eclipse报错,
测试代码为
mysql-connector-java-3.1.12-bin-g.jar 放在tomcat\common\lib下
mysql-connector-java-3.1.12-bin.jar 放在java\jdk1.5\lib\下
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%
Connection con = null;
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
out.println("load success");
out.println("<br>");
}
catch(Exception e){
out.println("load fail");
}
%>
<%
try{
String dbUrl = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=gb2312";
String dbUser = "root";
String dbPwd = "1234";
con = DriverManager.getConnection(dbUrl,dbUser,dbPwd);
con.close();
System.out.println("link success");
}catch(Exception ee){
out.println("link fail");
}
%>

以下代码执行能成功
import java.sql.*;
public class ConTest {

private Connection con = null;
public ConTest(){
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
System.out.println("装载成功");

}catch(Exception e){
System.out.println("装载失败");
}
try{
String dbUrl = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=gb2312";
String dbUser = "root";
String dbPwd = "1234";
con = DriverManager.getConnection(dbUrl,dbUser,dbPwd);
con.close();
System.out.println("连接成功");
}catch(Exception ee){
System.out.println("连接失败");
}
}

public static void main(String[] args) {

ConTest test = new ConTest();
}

}

在catch(Exception e){
里不要打印什么什么失败,把具体的exception错误打出来