help me to install sql database to communicate with my swing gui.

[adiotrox]

Hi,
I want to make a simple java app using swing,
functions(phone book):
1.enter your name.
2.enter your phone number.
3.save it.
4.show all names.

i can develop the gui using swing but now i want a database in my computer where all of the above details such as a person's name with his/her phone number can get saved in the database and by clicking the "show all names" button all the names stored in the database must be displayed in a gui window.

what i can do:
Develop the gui by swing.

what i want to know:
1.whether to install sql server or database since i want to use my same computer for datbase and front end no internet stuff.
2.how to get the free sql and install it on my computer.
3.how to make the connection between my swing gui and database.

please help i am newbie.

[Tolls]

If it's a single app using the database, that is one user, then pick a db that can be embedded, like JavaDB/Derby or HSQL.
That way it's all in one.
Derby (JavaDB) comes with the JDK (though not the JRE, so you'll have to distribute the relevant jar files with your app), so might be the quickest to try and use?

[adiotrox]

Did i forgot to mention that i have no single idea about this database stuff, i read little bit about sql so that is the only thing in my mind and if i am developing this single app whose database is also installed in the same system then is SQL RDBMS is sufficient or Sql server is also required??

[Tolls]

Derby is a database.
It is one that can be setup to work inside your application, which can be a lot easier.
So no, you do not need another database.

If you are new to this then you really need to find a tutorial on it.
The Oracle JDBC one is possibly a good idea.

[adiotrox]

i have installed microsoft sql server management 2005 express but don't know how to give a server name or register it and start it?? can you please help

[Tolls]

Not really.
I don't use SQL Server very often.

It also strikes me as a rather excessive choice of db for this kind of app.

[adiotrox]

can you please send me the exact link of downloading derby database and help me to configure it.

[DarrylBurke]

Derby aka JavaDB is bundled with the JDK. You don't have to download anything.

db

[Tolls]

And Google will tell you all you need to know.
It's good practice to be able to track these things down.