import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.ListIterator;

public class jdbcconn {

    public static void main(String args[]){
        Accounts Accn = null;
        ArrayList<Accounts> account = new ArrayList<Accounts>();
        try{

        Class.forName("com.mysql.jdbc.Driver");
        Connection con=DriverManager.getConnection(  "jdbc:mysql://localhost:3306/bankdba","root","password");
        //here sonoo is database name, root is username and password
        Statement stmt=con.createStatement();
        ResultSet rs=stmt.executeQuery("select * from account");

        while(rs.next()) {
        Accn= new Accounts();
        Accn.setID(rs.getInt(2));
        Accn.setAccNo(rs.getInt(1));
        Accn.setContact(rs.getString(4));
        Accn.setEmail(rs.getString(3));
        System.out.println(rs.getInt(1)+"  "+rs.getString(2)+"  "+rs.getString(3)+" "+rs.getString(4));
        account.add(Accn);

        }
         con.close();
        }
        catch(Exception e){
            System.out.println(e);
            }
        System.out.println("///---------------------------------///");

        printAccnNo(account , Accn);

            }



      public static void printAccnNo(ArrayList<Accounts> account, Accounts accn{
          ListIterator<Accounts> itr = account.listIterator();
        while(itr.hasNext()) {
            System.out.println(accn.toString());
            itr.next();
        }

      }
    }

import java.util.Iterator;

public class Accounts {
private int AccNo;
private int ID;
private String email;
private String contact;


public int getAccNo() {
    return AccNo;
}
public void setAccNo(int accNo) {
    this.AccNo = accNo;
}
public int getID() {
    return ID;
}
public void setID(int iD) {
    this.ID = iD;
}
public String getEmail() {
    return email;
}
public void setEmail(String email) {
    this.email = email;
}
public String getContact() {
    return contact;
}
public void setContact(String contact) {
    this.contact = contact;
}
@Override
public String toString() {
    return "Value AccnNo: " + getAccNo() + "  contact:   " + getContact()+"  email :  " +getEmail() + "  ID :  "+getID();
}

}