Difference between revisions of "Netbeans/C3/Connecting-to-a-MySQL-Database/English-timed"

|* Configuring '''MySQL''' server properties  

|* Starting the '''MySQL''' server  

|* Creating and connecting to the '''database'''

|* Creating '''database''' tables, under which we will explore two methods:  

|# using the '''sql editor'''  

|# using the '''create table''' dialogue and finally,  

|* Running an '''SQL''' script.  

|For this demonstration, I am using the '''Linux Operating System Ubuntu v12.04'''  

|and ''' Netbeans IDE v7.1.1'''.

|You also need the ''' Java Development Kit (JDK) v6'''

|To learn this tutorial, basic understanding of '''database''' management is necessary.  

|To know more, watch ''' PHP and MySQL''' spoken tutorials on the link shown.  

|Choose ''' Register MySQL Server''' to open the '''MySQL server properties''' dialogue-box.  

|Notice that the '''IDE''' enters '''localhost''' as the default '''server host name'''.  

|3306 is the default '''server port''' number.  

|Enter the '''Administrator Username''' if not displayed.

|On my system, the '''Administrator Username''' is '''root'''.

|type or browse to the location of your ''' MySQL Administration''' application.  

|type or browse to the location of the ''' MySQL''' start command.  

|Type any arguments for the start command in the '''Arguments''' field.  

|type or browse to the location of the '''MySQL''' stop command.  

|  This is usually the path to ''mysqladmin''' in the '''bin''' folder of the '''MySQL''' installation directory.  

|The '''MySQL''' server node in the '''Service''' window indicates whether the '''MySQL database''' server is connected.  

| Let us now create a new database instance using the '''SQL Editor'''.

|In the '''Create Database''' dialogue, type the name of the new '''database.'''

|I will name this '''mynewdatabase.'''

|You can also grant full access to a given user.  

|By default, only the admin user has the permissions to perform certain commands.  

|It is a good practice to grant users most permissions, except to drop tables

|and allow users to modify only those '''databases''' that are created by their application.  

|Let us now create tables, populate them with data, and modify the data maintained in tables.  

| '''mynewdatabase''' is currently empty.  

|Let us explore the first method to input data in the tables.  

|In the '''Database''' explorer, expand the '''mynewdatabase''' connection node.  

|A blank canvas opens in the ''' SQL Editor''' in the main window.  

|Let us type a simple query in this ''' SQL''' editor.  

|This is a table definition for the ''' Counselor''' table we are about to create.  

|To execute this query, either right-click the '''Run SQL''' icon in the task bar at the top.  

|Or right-click within the '''SQL Editor''' and choose '''Run Statement.'''

|The '''IDE''' generates the '''Counselor''' table in the '''database. '''

|You can see this message in the '''Output''' window,

|which says that the command was executed successfully,

|To verify these changes, right-click the '''Tables''' node in the '''Database''' Explorer.  

 

|This updates the current status of the specified '''database. '''

 

|If you expand the table node, you can see the columns that you created.  

 

|i.e. Using the Create Table Dialog  

 

|The '''Create Table dialogue''' opens.  

 

|Click on '''Add Column '''

 

|This is to specify the primary key for your table.  

 

|Note that when you select the '''Key''' check box, the '''Index''' and '''Unique''' check boxes are automatically selected;  

 

|Also the '''Null''' check box is deselected.  

 

|Click OK.  

|We have now created a table named '''Subject''' that will hold data for '''Name, Description,''' and '''Counselor ID'''

 

|By running '''SQL''' queries on a '''database''', we can add, modify and delete data maintained in '''database''' structures.  

 

|Let us add a new record to the '''Counselor''' table.  

 

|A new SQL Editor opens in the main window.  

 

| To execute this query, right-click within the source editor, and choose '''Run Statement'''

 

|Let us now verify if the new record has been added to the table.  

 

|Right-click the '''Counselor''' table, and choose '''View Data. '''

 

|The results of this statement are displayed in a table view below the workspace.  

 

|i.e. '''Counselor''' and '''Subject'''

 

|Click '''Yes''' in the '''Confirm Object Deletion''' dialogue box.  

 

|Repeat the same for the '''Subject''' table  

 

|From the '''File ''' menu, choose '''Open File.'''

 

|The script automatically opens in the '''SQL''' editor.  

 

|Check this from the connection drop-down in the toolbar at the top of the editor.  

 

|And the script is executed against the selected '''database. '''

 

|This updates the '''database ''' component to the current status of the specified '''database. '''

 

|And below the workspace, you can see the data contained in the new tables.  

 

|In this tutorial you learnt to,

 

|set up a connection to the '''database ''' server from the '''IDE '''

 

|run '''SQL''' queries  

 

|As an assignment,  

 

|Populate these tables with necessary data to maintain your personal book library  

 

|And run these SQL statements to view data  

 

|I have created a similar '''database''' which maintains details of my personal movie library.  

 

|The Spoken Tutorial project team conduct workshops using Spoken Tutorials.  

 

|For more details please write to contact@spoken-tutorial.org

 

|Spoken Tutorial Project is a part of the Talk to a Teacher Project

 

| It is Supported by the National Mission on education through ICT, MHRD, Government  of India

 

|More information on this mission is available at link provided here

 

|This tutorial has been  contributed by IT for Change  

 

|Thank you