Database connectivity in java by lokesh

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class Main {
 public static void main(String args[]) {
   try {
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

     Connection con = DriverManager.getConnection("jdbc:odbc:dbname", "", "");

     Statement stmt = con.createStatement();

     ResultSet rs = stmt.executeQuery("SELECT name,class, roll "
         + "FROM table1 ");
     while (rs.next()) {
       String name = rs.getString("name");
       String class1 = rs.getString("class");
       int roll = rs.getInt("roll");

       System.out.println("Name " + name + " Class " + class1 + " Roll " + roll);
     }

     stmt.close();
     con.close();
   } catch (Exception e) {
     System.out.println(e);
   }
 }
}