myeclipse mysql连接数据库找不到驱动怎么办

在 Editorplus 中运行通过的连接数据库文件(环境变量中也加入了连接数据库的包)。在Myeclipse 中配置连接数据库的时候测试也通过了。但是把以上说的文件在Myeclipse 7.0中运行时 提示:java.lang.ClassNotFoundException: com.mysql.jdbc.Driver。我想应该是我Myeclipse 配置的问题。请各位大侠赐教!! 另附数据库连接文件:
import java.sql.*;
import java.util.*;
import java.text.*;

public class ConnectDataBase
{
private String driverName = "com.mysql.jdbc.Driver";
private String dbURL = "jdbc:mysql://localhost:3306/test";
private String userName = "root";
private String userPwd = "";
private Connection dbConn ;
private ResultSet rs=null;

public ConnectDataBase()
{
try
{
Class.forName(driverName);
System.out.println("驱动加载成功!");
}
catch (Exception ex)
{
System.out.println(ex);
}
}

public ResultSet executeQuery(String sql)
{
try
{
dbConn =DriverManager.getConnection(dbURL,userName,userPwd);
Statement stmt = dbConn.createStatement();
stmt = dbConn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println("aq.executeQuery:" + ex.getMessage());
}
return rs;

}

public void executeUpdate(String strSQL)
{
try
{
dbConn =DriverManager.getConnection(dbURL, userName, userPwd);
Statement stmt = dbConn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
stmt.executeUpdate(strSQL);
}
catch(SQLException ex)
{
System.err.println("连接数据库失败了,异常为:" +ex.getMessage());
}
}

public String gettime()//返回登录时间
{
String date ="" ;
try
{
date=new SimpleDateFormat("yyyy-MM-dd hh:mm").format(Calendar.getInstance().getTime());
}
catch (Exception ex)
{
System.err.println("异常为:" +ex.getMessage());
}
return date ;
}

public static void main(String []args)
{
ConnectDataBase cdb=new ConnectDataBase();
/* String sql="select * from userinfo where userName='xuefeng'";
ResultSet rs=cdb.executeQuery(sql);
try
{
if(rs.next())
{
System.out.println(rs.getDatetime("userRegisterTime"));
}
}
catch (Exception e)
{
System.out.println(e);
}*/
}

}

看样子工程是没有导入jdbc连接mysql驱动 的jar包
没导入的话,eclipse 中可以右击工程名->build path->add external achives
温馨提示:答案为网友推荐,仅供参考
第1个回答  2010-06-19
我觉得还是你jar文件没加进去
你在项目上右键|build path| add external ...试试