public User convertRowToUser(ResultSet myRs) throws SQLException {

int id = myRs.getInt("id");
String lastName = myRs.getString("last_name");
String firstName = myRs.getString("first_name");
String email = myRs.getString("email");

User tempUser = new User(id, lastName, firstName, email);

return tempUser;

public List<User> getUsers() throws Exception {
List<User> list = new ArrayList<User>();

Statement myStmt = null;
ResultSet myRs = null;

try {
    Connection myConn = null;
    myStmt = myConn.createStatement();
    myRs = myStmt.executeQuery("select * from users");

    while (myRs.next()) {
        User tempUser = convertRowToUser(myRs);
        list.add(tempUser);
    }

    return list;
}
finally {
    close(myStmt, myRs);
}

public static void main(String[] args) {
EventQueue.invokeLater(new Runnable() {
    public void run() {
        try {
            Connection myConn = DriverManager.getConnection("jdbc:mysql://localhost:3306/database?autoReconnect=true&useSSL=false","user","password");
            List<User> users = null;
            for (User temp : users) {
                System.out.println(temp);
            }


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

    }
});