public class MyDBAccess {

    public static void main(String [] args)throws Exception {
        Class.forName("com.mysql.jdbc.Driver");

        String url = "jdbc:mysql://localhost:3306/books";
        Connection con = DriverManager.getConnection(url, "root", "MECC2011");

        Statement stmt = con.createStatement();
        ResultSet result = stmt.executeQuery("select * from Titles");
        //System.out.println(result.getMetaData());
        ResultSetMetaData metaData = result.getMetaData();
        int numberOfColumns = metaData.getColumnCount();
        for(int i =1; i<=numberOfColumns; i++){
            System.out.printf("%-40s\t",metaData.getColumnName(i));
        }
        System.out.println();
        while(result.next()){
            for(int i=1; i<=numberOfColumns; i++){
               System.out.printf("%-40s\t",result.getObject(i));
            }
            System.out.println();
        }

    }
}