Summary of operations on connecting Eclipse To My SQL database, eclipsesql
How to connect Eclipse To My SQL database
(Test by yourself and start to learn how to connect to the database by connecting to Eclipse (my Eclipse version is 4.5.2, And the jar package version of The Jdbc driver is 5.1.7, I have a lot of experience on the Internet, but I have found many errors on the Internet. I hope this blog will help you)
1: First you need to download the Jdbc drive (mysql-connector-java-5.1.7-bin.jar) This file (Baidu cloud disk http://pan.baidu.com/s/1hs9dxs4,password c22r)
It is also difficult to download the file above, so I would like to share it for your convenience.
2: After downloading the preceding Jdbc drive, you can start to operate it. First, open Eclipse and create a Project. My Project name is demo. Then, right-click src, find new, find Floder, and
Right-click src under the project and paste the downloaded Jdbc drive to the lib under the demo project. Then, click the jar package you just pasted, find the build path and continue to find the add to build path. The result is shown in. After the add is complete, you can use Eclipse to connect to My SQL database.
The code for connecting to the database is as follows (note Connection connect = DriverManage. getConnection ("jdbc: mysql: // localhost: 3306/test", "root", "password "))
The "password" in the above sentence is your database's own password. You need to modify it yourself. The above "jdbc: mysql: // localhost: the test in 3306/test is a table created by myself using mysql, which is created by myself and requires extra attention. (The create my SQL statement will be found elsewhere in this blog, please note)
Package com. ningmengxueyuan;
Import java. SQL .*;
Public class MysqlJdbc {
Public static void main (String args []) {
Try {
Class. forName ("com. mysql. jdbc. Driver"); // load the mysql jdbc Driver
// Class. forName ("org. gjt. mm. mysql. Driver ");
System. out. println ("Success loading Mysql Driver! ");
} Catch (Exception e ){
System. out. print ("Error loading Mysql Driver! ");
E. printStackTrace ();
}
Try {
Connection connect = DriverManager. getConnection (
"Jdbc: mysql: // localhost: 3306/test1", "root", "123456 ");
// The Connection URL is jdbc: mysql // server address/database name, followed by the login user name and password
System. out. println ("Success connect Mysql server! ");
Statement stmt = connect. createStatement ();
ResultSet rs = stmt.exe cuteQuery ("select * from user ");
// User: name of your table
While (rs. next ()){
System. out. println (rs. getString ("name "));
}
} Catch (Exception e ){
System. out. print ("get data error! ");
E. printStackTrace ();
}
}
}