java and mysql general question

hi everyone!i use jdk 1.4 SE and mysql 5. all i need is the appropriate driver in order to be able to create database applications with java language?is there sth else i need to know?thanks!
[225 byte] By [pdimitris_gra] at [2007-11-26 19:10:27]
# 1

You must know the URL to connect to the database, a userid and a password.

Also you should know a little SQL. JDBC just provides a means of accessing the mysql database it does not help you with selects, inserts updates etc. YOu have to phrase those SQL statements yourself and hand them to your JDBC-statements, that will then send them to the database.

g_magossa at 2007-7-9 21:06:26 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2
This article should get you going: [url http://www.developer.com/java/data/article.php/3417381]Using JDBC with MySQL, Getting Started[/url]
abillconsla at 2007-7-9 21:06:26 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 3

You need:

1. A JDBC driver for MYSQL (Which is easily available)

2. A MYSQL Database with data

3. An userid and password of this Database

4. Port number the database server is listening on

5. The url (combination of all above) that you will have to write so that your java application starts talking to the DB.

Make sure

1. The JDBC Driver for this database is in the classpath.

2. The database is started and running.

Hope this helps.

Regards

ayusman_dikshita at 2007-7-9 21:06:26 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...