import java.sql.*;
import java.net.*;
import java.util.*;

public class DBTest2{  
    public static void main(String args[]){
     try { 
       Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
       String  dataSource = "jdbc:odbc:TheDataSourceName";
       Connection con = DriverManager.getConnection(dataSource, null, null);
       Statement stmt = con.createStatement();
       
       try {  stmt.executeUpdate("drop table employee");}
	   catch (SQLException e){/*do nothing if table does note exist*/ }

       stmt.executeUpdate("CREATE table employee " +
         "(first varchar(15), last varchar(20), age integer, address varchar(30), " +  
         " city varchar(20), state varchar(20))");
       
       stmt.executeUpdate("INSERT into employee " + 
         "(first, last, age, address, city, state) " +
         "values ('Luke', 'Duke', 45, '2130 Boars Nest', 'Hazard Co', 'Georgia')");
       
       stmt.executeUpdate("INSERT into employee " + 
         "(first, last, age, address, city, state) " +
         "values ('Arthur', 'Fonzerella', 47, 'Above Mr. C', 'Milwaukee', 'Wisconsin')");
       
       stmt.executeUpdate("INSERT into employee " + 
         "(first, last, age, address, city, state) " +
         "values ('Lucille', 'Ball', 62, '555 Main Street', 'Los Angeles', 'California')");
       
       ResultSet rs = stmt.executeQuery(" Select first, last, address from employee where age > 46 ");
	   ResultSetMetaData rsmd = rs.getMetaData();
	   while(rs.next()){
		for(int i =1; i <= rsmd.getColumnCount();i++){
			   System.out.println(rsmd.getColumnName(i) + " " +  rs.getString(i));
		}
	   }
     }catch(Exception e){System.out.println(e.toString());}
    }
}