How to create a database with java

[rotaryfreak]

Hi everyone,

So ive basically searched the interwebs and tried some examples but i cant not seem to get this working. I would like to create a Java program in which i can save data into a database. The GUI part is not the problem, the problem is getting Java to communicate with MySQL. I have no idea how to establish a connection bewteen my Java program and MySQL.
I have downloaded and installed wampserver 2.0 and i am pretty much lost after this point. Does anyone know of any good reading material that can help me out with this? maybe provide a small example?

thanks a million!

[ketan10]

use jdbc odbc connection to connect to databases, may it be MySQL or MS Access or any other.
Example: here emp table contains name & sal

import java.sql*;
 
class JdbcDemo 
{
    public static void main(String[] args) 
    {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        Connection con = DriverManager.getConnection("jdbc:odbc:ooo", "" , "");
        Statement st = con.createStatement();
        Resultset rs = st.executeQuery("select * from emp");
        while(re.next())
        {
            System.out.println(rs.getString(1) + "\t" + rs.getInt(2));
        }
        con.close();
 
 
    }
}