DBBrowser usage _ MySQL

Use of DBBrowser 1.DB Browser

You can display and operate the database content in MyEclipse to facilitate the management of the background database content, without frequently switching between MyEclipse and database.

2. how to add DB Browser

DB Browser. you can choose MyEclipse> Preferences> MyEclipse> Database Explorer> Database Driver to connect to the Database Brower. You can also open it through show view.

3. how to use DB Browser

(1) right-click MyEclipse Derby and select new, as shown below:

Driver template: Select the database you use

Driver name: you can obtain the name by yourself.

Connection URL: Where <> is mandatory. The former is generally loaclhost, and the latter is the port number.

User name: database User name

Password: enter the Password of your database.

(2) Click add JARs.

Select the jar file used by the database you are connected

For example:

(3) Finish

(4) create a file with the suffix ". SQL" in your project.

Open CE. SQL, select the corresponding project, database, write SQL statements, select SQL statements, and click the green button for execution. for the Results, see SQL Results.