import java.sql.*;

public class JDBCTest {

    public static void main(String[] args) {
	String sql="";
	try {
	    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	    String url = "jdbc:odbc:students";
	    Connection conn = DriverManager.getConnection(url, "", "");
	    Statement st = conn.createStatement();
	    sql = "select firstname, lastname from Student";
	    ResultSet rec = st.executeQuery(sql);

	    while (rec.next()) {
		System.out.println(rec.getString("firstname")+ " " +
				   rec.getString("lastname"));
	    }
	}
	catch (ClassNotFoundException e) {
	    System.out.println("Driver class not found");
	    System.out.println(e.getMessage());
	}
	catch (SQLException e1) {
	    System.out.println("Something wrong with your sql command: " +
			       sql);
	    System.out.println(e1.getMessage());
	}
    }
}