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

|Hello everyone,

|Welcome to the tutorial on ''' 'Connecting to a MySQL Database' '''

|In this tutorial, we will look at  

|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'''

 

 

|and ''' MySQL database''' server  

 

 

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

 

 

|To know more, watch ''' PHPandMySQL''' spoken tutorials on the link shown.  

 

|This tutorial demonstrates how to setup a connection to a ''' MySQL database''' from the ''' Netbeans IDE.'''

 

 

|Once connected, we will work with '''MySQL''' in the ''' IDE's Database ''' Explorer.  

 

 

|Let us switch to the ''' IDE''' now.  

 

| ''' Netbeans IDE''' comes bundled with support for the ''' MySQL RDBMS.'''  

 

 

|Right-click the ''' Databases''' node in the '''Services''' window.  

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

|Confirm that the server host name and the port are correct.  

 

|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'''

|Enter the '''Administrator''' password.  

|Click the ''' Admin Properties''' tab at the top of the dialog box.  

 

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

 

 

 

|On my system, the location to the tool is ''' /usr/bin/mysqladmin'''

 

 

 

|In the '''Path to start command: ''' field  

 

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

 

 

 

|On my system it is ''' /usr/bin/mysqld_safe'''

 

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

 

 

| Here, I will type ''' -u space root space  start'''

|In the '''Path to stop command: '''

 

 

|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.  

|On my system this is ''' /usr/bin/mysqladmin'''

|If the command is '''mysqladmin,''' in the '''Arguments''' field, type '''-u space root space stop.'''  

|Click '''OK. '''

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

 

|When expanded, the '''MySQL''' server node displays all the available '''MySQL databases.'''  

 

 

|A common way of interacting with '''databases''' is through an '''SQL Editor. '''

 

|You can access this by right-clicking on the connection node.  

 

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

 

|In the '''Services''' window, right-click the '''MySQL''' server node and choose '''Create Database'''.  

 

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

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

 

 

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

 

|The drop-down list allows you to assign these permissions to a specified user.  

 

|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.  

 

 

|But for now, we will leave the checkbox unselected.  

|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.  

 

 

 

|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.'''

 

|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