Linux Java连接MySQL数据库

阳光岛主

发布于 2019-02-19 17:24:53

5.6K0

发布于 2019-02-19 17:24:53

文章被收录于专栏：米扑专栏米扑专栏

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

执行结果：