import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import javaapplication1.Person;

public class ABC {
    public static void main(String[] args) throws SQLException {
        ArrayList<Person> personlist = new ArrayList<Person>();
        //List<Person> personlist = new List<Person>();
        try {


            Class.forName("oracle.jdbc.driver.OracleDriver");
            Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","gsjsc","gsjschanna");
            Statement st=con.createStatement();

            ResultSet srs = st.executeQuery("SELECT * FROM person2");
            while (srs.next()) {
                Person person = new Person();
                person.setName(srs.getString("name"));
                person.setJobtitle(srs.getString("jobtitle"));
               // person.setFrequentflyer(srs.getInt("frequentflyer"));
                personlist.add(person);
            }

            System.out.println(personlist.size());
            for (int a=0;a<personlist.size();a++)
            {
            System.out.println(personlist.get(a).getName());
            System.out.println(personlist.get(a).getJobtitle());
            // System.out.println(personlist.get(2).getName());
            // System.out.println(personlist.get(3).getName());
            }
            //System.out.println(personlist.get(4));

        //System.out.println(namelist.);
        } catch (Exception e) {
            System.err.println("Got an exception! ");
            System.err.println(e.getMessage());
        }
    }
}

private Address[] getEmailsList(ArrayList< String > emails) {
 Address[] emaiAddresses = new Address[emails.size()];

  for (int i =0;i < emails.size();i++) {
   try {
    emaiAddresses[i] = new InternetAddress(emails.get(i));
   }
   catch (AddressException e) {

    e.printStackTrace();
   }
  }
  return emaiAddresses;
 }

 // This method prompts user for email group to which he
 // wants to send message
 public List< String > getEmails() {
  ArrayList< String > emails = new ArrayList< String >();

  int counter = 1;
  String address = "";
  Scanner scanner = new Scanner(System.in);

  // looping inifinitely times as long as user enters
  // emails one by one
  // the while loop breaks when user types done and
  // press enter.
  while(true) {

   System.out.println("Enter E-Mail : " + counter);
   address = scanner.next();

   if(address.equalsIgnoreCase("Done")){
    break;
    }
   else {
    emails.add(address);
    counter++;
   }
  }

  return emails;
 }
}