Linux(Ubuntu平台)Java通过JDBC连接MySQL数据库,与Windows平台类似,步骤如下:
下载 jdbc: mysql-connector-java-5.1.18.tar.gz:http://www.mysql.com/downloads/connector/j/5.1.html
解压 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/
Java示例:
private static String sql="select top, id, name, country, dtime from gametop800 where id=\"com.rovio.angrybirds\"";
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();
}
}