Eclipse Visual Operations Database

Eclipse Visualize Operations MySQL :

1 , open the data Source Explorer window.

Eclipse > Window > Show View > Other > Data Management Select the data Source Explorer and click OK to open it on the current page.

650) this.width=650; "title=" clip_image001 "style=" border-left-0px; border-right-width:0px; Background-image:none; border-bottom-width:0px; padding-top:0px; padding-left:0px; margin:0px; padding-right:0px; border-top-width:0px "border=" 0 "alt=" clip_image001 "src=" http://s3.51cto.com/wyfs02/M01/6B/CE/ Wkiol1u3b6bxdxadaaa_rlme1oe813.jpg "width=" 244 "height="/>

2 , configure the database connection.

Click the database connection in the Data Source Explorer window and click New to open the window.

650) this.width=650; "title=" clip_image002 "style=" border-left-0px; border-right-width:0px; Background-image:none; border-bottom-width:0px; padding-top:0px; padding-left:0px; padding-right:0px; border-top-width:0px "border=" 0 "alt=" clip_image002 "src=" http://s3.51cto.com/wyfs02/M02/6B/CE/ Wkiol1u3b6arwkwpaabw-l20vzk856.jpg "width=" 212 "height=" 244 "/>

Select your own database, click Next, enter the following interface (the first time you will encounter, configure the drive after the eclipse automatically skipped)

650) this.width=650; "title=" clip_image003 "style=" border-left-0px; border-right-width:0px; Background-image:none; border-bottom-width:0px; padding-top:0px; padding-left:0px; margin:0px; padding-right:0px; border-top-width:0px "border=" 0 "alt=" clip_image003 "src=" http://s3.51cto.com/wyfs02/M00/6B/CE/ Wkiol1u3b6bb5xxeaabkmj70y48165.jpg "width=" 207 "height=" 244 "/>

Click the button labeled Red box to enter the selection drive interface

650) this.width=650; "title=" clip_image005 "style=" border-left-0px; border-right-width:0px; Background-image:none; border-bottom-width:0px; padding-top:0px; padding-left:0px; margin:0px; padding-right:0px; border-top-width:0px "border=" 0 "alt=" clip_image005 "src=" http://s3.51cto.com/wyfs02/M00/6B/D2/ Wkiom1u3bknznqedaabmizt774k766.jpg "width=" 244 "height=" 202 "/>

In the Name/type tab, select your database driver version, (you will have to install the Eclipse plugin, not repeat here). (By the way, you can change the following driver name, for you to set a bunch of MySQL drive name conflicts). Then select the Jar List tab,

650) this.width=650; "title=" clip_image007 "style=" border-left-0px; border-right-width:0px; Background-image:none; border-bottom-width:0px; padding-top:0px; padding-left:0px; margin:0px; padding-right:0px; border-top-width:0px "border=" 0 "alt=" clip_image007 "src=" http://s3.51cto.com/wyfs02/M01/6B/D2/ Wkiom1u3bkqsogr3aabim386b6o065.jpg "width=" 244 "height=" 202 "/>

You can directly clear all, delete the original content (only a jar package name, in fact, the path does not exist), and then click the Add Jar/zip button, add the driver package (here the required driver JAR package, is actually your Java project to connect MySQL driver package). Add the jar package, click the Properties tab,

650) this.width=650; "title=" clip_image009 "style=" border-left-0px; border-right-width:0px; Background-image:none; border-bottom-width:0px; padding-top:0px; padding-left:0px; margin:0px; padding-right:0px; border-top-width:0px "border=" 0 "alt=" clip_image009 "src=" http://s3.51cto.com/wyfs02/M01/6B/CE/ Wkiol1u3b6fs5v1haabroe0mano291.jpg "width=" 244 "height=" 202 "/>

Configure the database properties, including connection properties, database names, and passwords (the user ID is actually your database username), click OK.

650) this.width=650; "title=" clip_image010 "style=" border-left-0px; border-right-width:0px; Background-image:none; border-bottom-width:0px; padding-top:0px; padding-left:0px; margin:0px; padding-right:0px; border-top-width:0px "border=" 0 "alt=" clip_image010 "src=" http://s3.51cto.com/wyfs02/M00/6B/CE/ Wkiol1u3b6fa-ewtaabtjqbzqry592.jpg "width=" 207 "height=" 244 "/>

Click the Finish button to complete the configuration.

Now click on the database Connection folder in the Data Source Explorer window to turn this

650) this.width=650; "title=" clip_image011 "style=" border-left-0px; border-right-width:0px; Background-image:none; border-bottom-width:0px; padding-top:0px; padding-left:0px; margin:0px; padding-right:0px; border-top-width:0px "border=" 0 "alt=" clip_image011 "src=" http://s3.51cto.com/wyfs02/M01/6B/D2/ Wkiom1u3bkvylulsaabu76dbreu754.jpg "width=" 244 "height="/>

650) this.width=650; "title=" clip_image012 "style=" border-left-0px; border-right-width:0px; Background-image:none; border-bottom-width:0px; padding-top:0px; padding-left:0px; margin:0px; padding-right:0px; border-top-width:0px "border=" 0 "alt=" clip_image012 "src=" http://s3.51cto.com/wyfs02/M01/6B/D2/ Wkiom1u3bkuh8avsaabgsexngge756.jpg "width=" "height=" 244 "/>

Click Open to see the database you have configured. Right-click on the data table above to select Data > Edit to see your data in the table. (Load ... Used to import data from a file, extract ... Used to export a data sheet to a file. ）

3 , the operation of the database

650) this.width=650; "title=" clip_image013 "style=" border-left-0px; border-right-width:0px; Background-image:none; border-bottom-width:0px; padding-top:0px; padding-left:0px; margin:0px; padding-right:0px; border-top-width:0px "border=" 0 "alt=" clip_image013 "src=" http://s3.51cto.com/wyfs02/M02/6B/D2/ Wkiom1u3bkuzmsbbaabh818wxkm328.jpg "width=" 233 "height=" 244 "/>

Click Open SQL Scrapbook,

650) this.width=650; "title=" clip_image015 "style=" border-left-0px; border-right-width:0px; Background-image:none; border-bottom-width:0px; padding-top:0px; padding-left:0px; margin:0px; padding-right:0px; border-top-width:0px "border=" 0 "alt=" clip_image015 "src=" http://s3.51cto.com/wyfs02/M00/6B/D2/ Wkiom1u3bkuxl74xaaadqix6o1g053.jpg "width=" 244 "height=" 108 "/>

Write the SQL statement in Scrapbook, save the file as a SQL suffix (saved in a directory where the project is easy to find).

In the project directory, locate the file, right-click,

650) this.width=650; "title=" clip_image016 "style=" border-left-0px; border-right-width:0px; Background-image:none; border-bottom-width:0px; padding-top:0px; padding-left:0px; padding-right:0px; border-top-width:0px "border=" 0 "alt=" clip_image016 "src=" http://s3.51cto.com/wyfs02/M01/6B/D2/ Wkiom1u3bkuaiyu-aabzg4e4znw338.jpg "width=" 244 "height=" 177 "/>

Execute SQL Files, the SQL statements in scrapbook are executed.

Eclipse Visual Operations Database