Ubuntu下Eclipse部署MySQL JDBC驅(qū)動

1.MySQL JDBC驅(qū)動包下載地址：http://dev.mysql.com/downloads/connector/j/

   版本：mysql-connector-java-5.1.17.zip

2.下載后任意目錄解壓到/mysql-connector-java-5.1.17/mysql-connector-java-5.1.17-bin.jar；
-
 

    /mysql-connector-java-5.1.17/目錄下還有docs和src文件夾，src文件夾里有l(wèi)ib目錄；

3.前提：mysql和eclipse環(huán)境都安裝好，參照前面blog關(guān)于Ubuntu安裝j2ee環(huán)境和mysql的文章；

4.打開eclispe，進(jìn)入菜單windows->prefrences，進(jìn)入Java->Build Path->user libraries，選擇新建，命名為mysql，路徑為：/mysql-connector-java-5.1.17/mysql-connector-java-5.1.17-bin.jar；

5.創(chuàng)建java project，命名為mysqlcon，右鍵其，選擇Build Path->Add libraries，從列表中選擇user library，在next界面中選擇上面部署的mysql安裝包即可；

6.開發(fā)，mysqlcon工程下新建class，命名為my，包為cn，即cn.my的java文件：

Package cn;import java.sql.*;public class my{ public static void main(String args[]) { try { Class.forName("com.mysql.jdbc.Driver"); //加載MYSQL JDBC驅(qū)動程序 System.out.println("Success loading Mysql Driver!"); } catch (Exception e) { System.out.print("Error loading Mysql Driver!"); e.printStackTrace(); } try { Connection connect = DriverManager.getConnection( "jdbc:mysql://localhost:3306/dbname","root","password"); System.out.println("Success connect Mysql server!"); //select code Statement stmt = connect.createStatement(); ResultSet rs = stmt.executeQuery("select * from t_auth");//t_auth為表的名稱  while (rs.next()) { System.out.println(rs.getString("auth_path"));//auth_path是表t_auth的一個字段 } //insert into code PreparedStatement Statement=connect.prepareStatement("INSERT INTO t_auth VALUES(?,?)"); Statement.setString(1,"2"); Statement.setString(2,"系統(tǒng)管理"); Statement.executeUpdate(); } catch (Exception e) { System.out.print("get data error!"); e.printStackTrace(); } } }能正確顯示和插入即成功！

服務(wù)器租用/服務(wù)器托管中國五強！虛擬主機域名注冊頂級提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]