红联Linux门户
Linux帮助

Linux Java连接MySQL数据库

发布时间:2014-12-09 10:14:32来源:linux网站作者:sunboy_2050

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

}

极速赛车杀号公式 广西快3计划 智慧彩票投注 百尊娱乐彩票计划群 凤凰娱乐彩票计划群 山东11选5开奖 河北11选5走势图 菠萝彩票计划群 青海快3 幸运28彩票计划群