Key in all the studentinfo table information shown below.Ģ4. Let try another method to create previous studentinfo database. Execute the following statement and refresh.Ģ1. Expand the table in the Schemata window.Ģ0. Refresh by clicking the refresh button ( ). The following Figure shows the Options available.ġ9. An example of MySQL control flow function shown in the following Figure.ĩ. Query Browser also can be accessed from Start > Program Files > MySQL > MySQL Query Browser.ħ. MySQL is a single point administrator where we can manage the MySQL server, creating and manipulating databases and many more.ĥ. Let explore the menu items available for us. We will be greeted by the following MySQL Administrator main page.Ĥ. Key in your root password and click OK.ģ. Launch it through the Start > Program Files > MySQL > MySQL Administrator.Ģ. Firstly let get familiar with MySQL Administrator. However, keep in mind that in this tutorial we are not concerning the database design aspects and so on, the purpose is just to create a very simple database and a table, populating with some data, playing with them and to be familiar with MySQL GUI tool.ġ. We will use and get familiar with MySQL GUI tool mainly the Query Browser because it is more convenience to certain extent. We will create a database and a master table and then populate it with some data to see its functionalities. The output indicates that the MySQL driver is deployed to a location in the GlassFish server.MySQL: Create and Manipulate Database Using MySQL GUI Tools You can view progress in the IDE’s Output window (Ctrl-4 ⌘-4 on Mac).
In the IDE’s Projects window, choose Deploy from the right-click menu of the project node.
If you do not see the driver JAR file, perform the following step.ĭeploy your project to the server. Because you should have already deployed the IFPWAFCAD project to the server, you should see the mysql-connector-java-5.1.6-bin.jar file. On your computer, navigate to the GlassFish server installation directory and drill into the domains > domain1 > lib subfolder. As shown in the image above, the driver JAR file should be located within domain1, which is the default domain created upon installing the GlassFish server. Each instance runs applications in a unique domain, and the Domain Name field indicates the name of the domain your server is using. When you connect to the GlassFish server in the IDE, you are actually connecting to an instance of the application server.
Before you close the Servers manager, make a note of the path indicated in the Domains folder text field.
0 kommentar(er)
