This tip shows the way to make JDBC connection to the database. For this first go to the ODBC DataSources in Control Panel and make a DSN using named Dumy (you can give any name) and maps this to your database.

Now include following code block to make a connection and create Statement. A statement object is used to sends your SQL statement to the DBMS.

try {
            Connection con = DriverManager.getConnection("jdbc:odbc:dumy"; "sa", "");
            Statement stmt = con.createStatement();
  catch( Exception e ) {