[ERP system design] [data module] 3. Use the Eclipse plug-in DB viewer to operate MySQL databases.

 

Use the Eclipse plug-in DB viewer for MySQL database operations

1.Install plug-ins:

From http://www.ne.jp/asahi/zigen/home/plugin/dbviewer/about_en.htmlDownload a version. It is a JAR file and is installed using the link method.To start Eclipse.

2.Download MySQL JDBC Driver:

Http://mysql.com/products/connector/

Decompress the package and copy the entire directory to the D: \ SOFT \ java \ Graduation \ JDBC \ mysql-connector-java-5.1.18 directory.

3.Open the Eclipse View, select DB Tree View in DBViewer Plugin other, and click OK.

4.Click the Add button for the cylinder to Add the database, enter the database name, and then select JDBC Driver to Add the file mysql-connector-java-5.1.18-bin.jar. Click Next.

5.Fill in the basic information of the database:

Click Test connection.

The connection is successful. Import the database in subsequent steps

Click Finish.

6Click mysql to bring up a menu and then click connect

Click stu

7Double-click the table you want to operate. A visualized operation box is displayed.

8Then you can operate and view the database. Good job.