With lampp, I will have to first start the server in linux.So I open the Terminal change access to root by typing the command
-sudo -s -H
after I start lampp with this command
For windows users,all you have to do is install xampp as a service.Open the xampp control panel and start apache and mysql.
After doing this.
-Open your browser and type http://localhost in navigation bar and press enter.
You should see and interface like this.
From here go to the tools menu and select phpMyAdmin.
This will take you to the Mysql database management system interface in xampp/lampp which looks like this
Now lets go through these steps.
-- Enter the database name Student_Information and click on create to start creating a database
*A prompt will appear alerting that database creation was successful
--Start creating your table by typing your table name in field,enter 3 in the columns field and click on GO.--Enter details in various fields as seen in image and click on save
Thus, a name,index_number and course fields all of datatype VARCHAR.If by any means you don't understand what a VARCHAR is refer to the mysql manual.
After creating the table you will get an interface like this:
Great you have been able to create a table but it's left with one important thing thus our table does not have a primary key. From simple database concepts we get to know that a primary key should be unique.So we make the index number field our primary key since a every student has a unique index number.
Okay we do this by clicking the key image on the index number column.
We are now clear on creating our database and table.So our next step is to connect to our database from
netbeans and manipulation using JPA.