Connect to the MySQL database using LinuxJava

Linux (Ubuntu platform) Java through JDBC to connect to MySQL database, similar to Windows platform, steps are as follows: Download jdbc: mysql-connector-java-5.1.18.tar.gz unzip jdbc: tar-zxvfmysql-connector-java-5.1.18.tar.gz configuration jdbc: cpmysql-connector-java-5

Linux (Ubuntu platform)JavaConnect to the MySQL database through JDBC, which is similar to that on the Windows platform. The procedure is as follows:

DownloadJdbc: mysql-connector-java-5.1.18.tar.gz

ExtractJdbc: tar-ZxvfMysql-connector-java-5.1.18.tar.gz

ConfigurationJdbc:CpMysql-connector-java-5.1.18-bin.jar/usr/local/jdk1.6.0 _ 22/jre/lib/ext/

Complete source code:

Free onHttp://linux.linuxidc.com/

Both the user name and password areWww.linuxidc.com

The specific download directory is in/Pub/2011/10/12/Linux Java connection to MySQL database/

Java example:

Private static String SQL = "select top, id, name, country, dtime from gametop800 where id = \" com. rovio. angrybirds \"";

1. PublicMysqlConnect (){
2. String dbDriver ="Com. mysql. jdbc. Driver";
3. String url ="Jdbc: mysql: // localhost/top800";
4. String username ="Root";
5. String password ="";
7. Statement mStatement =Null;
8. ResultSet mResultSet =Null;
9. Connection mConnection =Null;
11. String SQL ="Select top, id, name, country, dtime from gametop800 where top <= 20";
13. Try{
14. Class. forName (dbDriver). newInstance ();
15. MConnection = DriverManager. getConnection (url, username, password );
16. MStatement = mConnection. createStatement ();
17. MResultSet = mStatement.exe cuteQuery (SQL );
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 ("Database read error! \ N"+ E. getMessage ());
28. }
29. }Catch(SQLException e ){
30. System. out. println ("Database connection error: \ 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. getConne Ction (url, username, password); mStatement = mConnection. createStatement (); mResultSet = mStatement.exe cuteQuery (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 ("database read error! \ N "+ e. getMessage () ;}} catch (SQLException e) {System. out. println ("database connection error: \ n" + url + "\ n" + e. getMessage ();} catch (Exception e) {e. printStackTrace ();} finally {// mStatement. close (); // mConnection. close ();}}

Execution result: