Linux Java連接MySQL數據庫

Linux（Ubuntu平台）Java通過JDBC連接MySQL數據庫，與Windows平台類似，步驟如下：

下載 jdbc： mysql-connector-java-5.1.18.tar.gz

解壓 jdbc： tar -zxvf mysql-connector-java-5.1.18.tar.gz

配置 jdbc：cp mysql-connector-java-5.1.18-bin.jar /usr/local/jdk1.6.0_22/jre/lib/ext/

完整源碼 下載地址：

免費下載地址在 http://linux.linuxidc.com/

用戶名與密碼都是www.linuxidc.com

具體下載目錄在 /pub/2011/10/12/Linux Java連接MySQL數據庫/

Java示例：

private static String sql="select top, id, name, country, dtime from gametop800 where id=\"com.rovio.angrybirds\"";

1. public mysqlConnect(){
2. String dbDriver = "com.mysql.jdbc.Driver";
3. String url = "jdbc:mysql://localhost/top800";
4. String username = "root";
5. String password = "";
7. Statement mStatement = null;
8. ResultSet mResultSet = null;
9. Connection mConnection = null;
11. String sql = "select top, id, name, country, dtime from gametop800 where top<=20";
13. try{
14. Class.forName(dbDriver).newInstance();
15. mConnection = DriverManager.getConnection(url, username, password);
16. mStatement = mConnection.createStatement();
17. mResultSet = mStatement.executeQuery(sql);
19. try{
20. while(mResultSet.next()){
21. System.out.print(mResultSet.getInt(1) + "\t");
22. System.out.print(mResultSet.getString(2) + "\t");
23. System.out.print(mResultSet.getString(3) + "\t");
24. System.out.println(mResultSet.getString(4));
25. }
26. }catch (Exception e){
27. System.out.println("數據庫讀取錯誤！ \n" + e.getMessage());
28. }
29. }catch (SQLException e){
30. System.out.println("連接數據庫錯誤: \n" + url + "\n" + e.getMessage());
31. }catch (Exception e){
32. e.printStackTrace();
33. }finally{
34. // mStatement.close();
35. // mConnection.close();
36. }
37. }

執行結果：