Linux system Java connection MySQL database

The Java connection MySQL database method under Linux system is similar to that under Windows, the following steps are as follows:

Download JDBC (driver): mysql-connector-java-5.1.37.tar.gz

Unzip the downloaded packet: TAR-ZXVF mysql-connector-java-5.1.37.tar.gz

After decompression, the Mysql-connector-java-5.1.29-bin.jar is located in the mysql-connector-java-5.1.29 directory.

Configuration after decompression, the Mysql-connector-java-5.1.29-bin.jar is located in the mysql-connector-java-5.1.29 directory. JDBC:[[email protected] mysql-connector-java-5.1.37]# CP MYSQL-CONNECTOR-JAVA-5.1.37-BIN.JAR/USR /lib/jvm/java-1.7.0-openjdk.x86_64//jre/lib/ext/

Java Instance Code:

2. Import java.sql.*;

4. public class Jdbctest {

6. public static void Main (string[] args) {

8. Driver name

10. String Driver = "Com.mysql.jdbc.Driver";

12. The URL points to the database name you want to access Scutcs

14. String url = "Jdbc:mysql://127.0.0.1:3306/student";

16. User name when MySQL is configured

18. String user = "root";   

20. Password for MySQL configuration

22. String password = "";

24. try {

26. Load Driver

28. Class.forName (driver);

30. Connecting to a database

32. Connection conn = drivermanager.getconnection (Url,user,password);

34. if (!conn.isclosed ())

36. SYSTEM.OUT.PRINTLN ("Succeeded connecting to the database!");

38. statement used to execute SQL statements

40. Statement Statement = Conn.createstatement ();

42. The SQL statement to execute

44. String sql = "SELECT * FROM Std";

46. Result set

48. ResultSet rs = statement.executequery (SQL);

50. System.out.println ("-----------------");

52. System.out.println ("Execution results are as follows:");

54. System.out.println ("-----------------");

56. System.out.println ("School number" + "\ T" + "name");

58. System.out.println ("-----------------");

60. String name = NULL;

62. while (Rs.next ()) {

64. Select sname This column of data

66. Name = rs.getstring ("name");   

68. First, use the iso-8859-1 character set to decode name into a sequence of bytes and store the result in a new byte array.

70. The specified byte array is then decoded using the GB2312 character set

72. name = new String (name.getbytes ("iso-8859-1"), "UTF8");

74. Output results

76. System.out.println (rs.getstring ("id") + "\ T" + name);

78. }

80. Rs.close ();

82. Conn.close ();

84. } catch (ClassNotFoundException e) {

86. System.out.println ("Sorry,can ' t find the driver!");

88. E.printstacktrace ();

90. } catch (SQLException e) {

92. E.printstacktrace ();

94. } catch (Exception e) {

96. E.printstacktrace ();

98. }

100. }

102. }

Database creation:

[[email protected] ~]# MySQL

mysql> CREATE database student;

Query OK, 1 row Affected (0.00 sec)

Mysql> CREATE TABLE std (ID int (5) primary key NOT NULL, name varchar (a) not null);

Query OK, 0 rows affected (0.04 sec)

mysql> DESC STD;

+-------+-------------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+-------+-------------+------+-----+---------+-------+

| ID | Int (5) | NO | PRI |       NULL | |

| name | varchar (20) |     NO | |       NULL | |

+-------+-------------+------+-----+---------+-------+

2 rows in Set (0.00 sec)

mysql> INSERT INTO STD values (001, ' www '), (002, ' QQQ ');

Query OK, 2 rows Affected (0.00 sec)

Records:2 duplicates:0 warnings:0

mysql> Select *from std;

+----+------+

| ID | name |

+----+------+

| 1 | www |

| 2 | QQQ |

+----+------+

2 rows in Set (0.00 sec)

Test results:

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/74/DF/wKiom1YszKfAFUZsAABBVxX9-bk555.jpg "title=" Qq20151025203722.png "alt=" Wkiom1yszkfafuzsaabbvxx9-bk555.jpg "/>

This article is from the "canvas shoes can walk the cat step" blog, please be sure to keep this source http://9409270.blog.51cto.com/9399270/1706102

Linux system Java connection MySQL database