Through the myeclipse operation of the database, execute SQL statements so that we do not have to switch multiple tools, direct work, 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 your 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 driver jar package. Driver classname: Select the corresponding driver class name Testdriver: You can simulate the test, whether you can connect to save password: Save the password and 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.

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

Through the myeclipse operation of the database, execute SQL statements so that we do not have to switch multiple tools, direct work, convenient and quick