try {
            String url = "jdbc:mysql://localhost:3306/login";
            // establish connection to database
            Class.forName("com.mysql.jdbc.Driver");
            Connection con = DriverManager.getConnection(url, "root", "LizardTree91");

            // query database
            PreparedStatement pt = con.prepareStatement("SELECT * FROM login.users");

            // process query results
            ResultSet rs = pt.executeQuery();

            while(rs.next()){

                String user = rs.getString("username");
                users.add(user);
                System.out.println(user);

            }

            rs.close();
            con.close();

        }//end try
        catch (SQLException ex) {
            ex.printStackTrace();
        } //end catch
        catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }