Direct operation of database through MyEclipse tool, execute SQL statement, convenient and quick

Original: Direct operation of database through MyEclipse tool, execute SQL statement, convenient and quick

By MyEclipse operation database, execute SQL statement so that we do not have to switch multiple tools, directly work, convenient and quick. The effect is as follows:

Step 1: Through the myeclipse in the window-"show view-" other call. DB Browser.

Step 2:

Step 3: Enter DB and select DB Brower.

Step 4: Click the space Right.

Step 5: Select the appropriate database type.

Step 6:

Driver Name: Fill in the name you need

Connection Name:jdbc:mysql://localhost:3306/db_exam fill in its own IP and port number, the default is 3306 and the database name, format by default.

User Nmae: Database name

Password: Database Password

Driver JARs: Add the Drive jar package.

Driver classname: Select the corresponding driver class name

Testdriver: Can simulate the test, whether can Unicom

Save Password: saving password

then click Finish.

Step 8: Click on the name of the database connection you built, double-click it or right-click the connection.

Step 9: Select the database you want to manipulate.

Step 10 fill in the SQL statement, select, click on the red triangle to execute.

Step 11: You can watch the effect of the database.

Daliu_it
Source: http://www.cnblogs.com/liuhongfeng/p/4175456.html
This article is copyrighted by the author and the blog Park, Welcome to reprint, but without the consent of the author must retain this paragraph, and in the article page obvious location to the original link. Thank you for your cooperation.

Direct operation of database through MyEclipse tool, execute SQL statement, convenient and quick