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/

完整源码 下载地址:

具体下载目录在 /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 = "";  
  6.   
  7.         Statement mStatement = null;  
  8.         ResultSet mResultSet = null;  
  9.         Connection mConnection = null;  
  10.           
  11.         String sql = "select top, id, name, country, dtime from gametop800 where top<=20";  
  12.           
  13.         try{  
  14.             Class.forName(dbDriver).newInstance();  
  15.             mConnection = DriverManager.getConnection(url, username, password);  
  16.             mStatement = mConnection.createStatement();  
  17.             mResultSet = mStatement.executeQuery(sql);  
  18.               
  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.     }  
public mysqlConnect(){ String dbDriver = "com.mysql.jdbc.Driver"; String url = "jdbc:mysql://localhost/top800"; String username = "root"; String password = ""; Statement mStatement = null; ResultSet mResultSet = null; Connection mConnection = null; String sql = "select top, id, name, country, dtime from gametop800 where top<=20"; try{ Class.forName(dbDriver).newInstance(); mConnection = DriverManager.getConnection(url, username, password); mStatement = mConnection.createStatement(); mResultSet = mStatement.executeQuery(sql); try{ while(mResultSet.next()){ System.out.print(mResultSet.getInt(1) + "\t"); System.out.print(mResultSet.getString(2) + "\t"); System.out.print(mResultSet.getString(3) + "\t"); System.out.println(mResultSet.getString(4)); } }catch (Exception e){ System.out.println("数据库读取错误! \n" + e.getMessage()); } }catch (SQLException e){ System.out.println("连接数据库错误: \n" + url + "\n" + e.getMessage()); }catch (Exception e){ e.printStackTrace(); }finally{// mStatement.close();// mConnection.close(); } }

执行结果:

Linux Java连接MySQL数据库

 

相关推荐