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/



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();
		}
	}


执行结果:



完整源码