₦airaland Forum

Please any help?

Ur question is not clear enough. But if u re writing a java web app, there is mysql and jbdc. If its desktop, look into h2 db.

Make you question Clearer. I might be able to help.

You use a database driver to connect to the database.
Every database has a host, a name, a username and password.
Once you use that driver to connect, this is a psuedo example

dbConnection = dbConnect("host", "dbname", "dbuser", "dbpassword" ) ;

You will have your connection, then using that connection you can query the database.

queryResults = dbConnection.query("SELECT first_name, last_name FROM mytable" ) ;

rows = queryResults.fetchAll() ;

foreach (rows as r) {
print("Name " + r.first_name + " " + r.last_name + "\n" ) ;
}

then when you are done, you close the connection
dbConnnection.close() ;

This is how it works with pretty much every langauge, java, python, php, ruby, c

You must find what database driver you are going to use and study it very well.

Here is how to use Java and MySQL.
http://zetcode.com/db/mysqljava/

If you are using MSQL, PostgresSQL or Oracle, it will be a bit different, but not much.

Best of luck.

Tnx all, you guys have helped me so much.

Tnx a bunch @DonSegmond

If you plan to develop a Desktop application, i guess you should try and research about Databases that support Embedded Driver such as Java DB. For if you use Mysql your database can only be accessed through an internet server which i think might not be suitable for a standalone Desktop Application. So, it solely depends on the type of the application you want to develop. And if you need guideline to how you'll perform database manipulations, Google is your friend. If you are using Java, then search for ''Java JDBC tutorial''. This should get you On....

Happy Coding.