Eclipse下加载mysql驱动

《Eclipse下加载mysql驱动》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、Eclipse3.7下加载com.mysql.jdbc.Driver驱动在eclipse3.7下建立网站工程3x2y做一个mysql数据库连接代码如下：packagedao.imp;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;publicclassDatabaseDAO{privateConnectionconn=n

2、ull;publicConnectiongetConnection()throwsClassNotFoundException,SQLException{Connectionconn=null;Class.forName("com.mysql.jdbc.Driver");Stringconnstr="jdbc:mysql://localhost:3306/3x2y?useUnicode=true&characterEncoding=gbk";Stringuser="root";Stringpassword="123456";conn=

3、DriverManager.getConnection(connstr,user,password);System.out.println("Connectioncreated!");returnconn;}publicvoidreleaseConnection()throwsSQLException{this.conn.close();this.conn=null;}publicResultSetgetResultSet(StringquerySQL)throwsSQLException,ClassNotFoundException

4、{if(conn==null){this.conn=getConnection();}Statementstm=conn.createStatement();ResultSetthisRST=stm.executeQuery(querySQL);returnthisRST;}publicvoidexecuteSQL(StringSQL)throwsSQLException,ClassNotFoundException{if(conn==null){this.conn=getConnection();}Statementstm=conn

5、.createStatement();stm.executeUpdate(SQL);this.conn.close();this.conn=null;}publicstaticvoidmain(String[]args){DatabaseDAOmydb=newDatabaseDAO();try{mydb.conn=mydb.getConnection();mydb.releaseConnection();}catch(SQLExceptionex){ex.printStackTrace();}catch(ClassNotFoundEx

6、ceptionex){ex.printStackTrace();}}}出现如下错误：java.lang.ClassNotFoundException:com.mysql.jdbc.Driveratjava.net.URLClassLoader$1.run(UnknownSource)atjava.net.URLClassLoader$1.run(UnknownSource)atjava.security.AccessController.doPrivileged(NativeMethod)atjava.net.URLClassLoad

7、er.findClass(UnknownSource)atjava.lang.ClassLoader.loadClass(UnknownSource)atsun.misc.Launcher$AppClassLoader.loadClass(UnknownSource)atjava.lang.ClassLoader.loadClass(UnknownSource)atjava.lang.Class.forName0(NativeMethod)atjava.lang.Class.forName(UnknownSource)atdao.im

8、p.DatabaseDAO.getConnection(DatabaseDAO.java:11)atdao.imp.DatabaseDAO.main(DatabaseDAO.java:42)即说明：eclipse下com