public void addPerson(String[] info) {
        try {

            int id = 0;
            boolean acctOK = false;
            String tempAcct = "nothing";
            String personN = "not";
            String fName = info[0];
            String lName = info[1];
            String pNumber = info[2];
            String pNumber2 = info[8];
            String address = info[3];
            String email = info[4];
            String phone = info[5];
            String title = info[6];
            String passW = info[7];

            String creds = String.format("insert into credentials(password,email)"
                    + " values('%s','%s')", passW, email);
            st[0].executeUpdate(creds);

            String retrieveDB = "select * from credentials";
            res = st[1].executeQuery(retrieveDB);
            while (res.next()) {
                id = res.getInt("id");
                String strEm = res.getString("email");

                if (strEm.equals(email)) {
                    String total = String.format("insert into account_owner(name,person_number,credentials_id,address,phone_number,title)"
                            + " values('%s %s','%s %s',%s,'%s','%s','%s') ",
                            fName, lName, pNumber, pNumber2, id, address, phone, title);
                    st[2].executeUpdate(total);
                    String sss = "select person_number from account_owner where credentials_id ='" + id + "';";
                    res = st[33].executeQuery(sss);
                    while (res.next()) {
                        personN = res.getString("person_number");
                    }
                }
            }

            String accountInput = "fail";
            String accountCheck = String.format("%d", generateAccountNumber());
            retrieveDB = String.format("select * from account where account_number = '" + accountCheck + "';");
            res = st[3].executeQuery(retrieveDB);
            if (res.next()) {
                tempAcct = res.getString("account_number");
                if (tempAcct.equals(accountCheck)) {
                    accountCheck = String.format("%d", generateAccountNumber());
                }
            } else {
                accountInput = accountCheck;
            }

            String addAccountInfo = String.format("insert into account(balance,account_number,account_owner_person_number)"
                    + " values('%s','%s','%s')", generateBalance(), accountInput, personN);

            st[4].executeUpdate(addAccountInfo);

            String ddd = "select * from account where account_owner_person_number ='" + personN + "';";
            res = st[38].executeQuery(ddd);
            if (res.next()) {
                String dodo = "select balance, account_number from account where account_owner_person_number ='" + personN + "';";
                res = st[32].executeQuery(dodo);
                while (res.next()) {

                    float balan = res.getFloat("balance");
                    String accountNo = res.getString("account_number");

                    System.out.println(accountNo);

                    //String perNum = String.valueOf(pNumber);
                    /*String addHistory = "insert into account_history"
                            + "(account_number_history,account_balance,account_owner_person_number) "
                            + "values ('" + accountNo + "'," + balan + ",'" + personN + "')";
                    st[33].executeUpdate(addHistory); */

                    

                    String dooo = "select name from account_owner where person_number = '" + personN + "';";
                    res = st[34].executeQuery(dooo);
                    System.out.println(personN);
                    while (res.next()) {
                        String name = res.getString("name");
                        System.out.println(name);
                        /*String addName = "insert into account_history (account_name) values ('" + name + "');";
                        System.out.println(addName);
                        st[38].executeUpdate(addName);*/
                    }


                }
            }

        } catch (Exception e) {
            System.out.println(e);
        }

    }