processing-MySQL learning2-append()

import de.bezier.data.sql.*;

MySQL mysql;
User[] userArray=new User[0];

void setup()
{
  size(100,100);
  
  String database="mydatas";
  String user="hui1570";
  String pass="04263028";
  
  mysql=new MySQL(this,"localhost",database,user,pass);
  
  if(mysql.connect())
  {
    String p1="us%";
    //remember:we should add ' to %s when we are querying
    String sqlString="SELECT * FROM user where username like '%s' and id < %d order by id limit %d";
    mysql.query(sqlString,p1,10,3);
  }
  while(mysql.next())
  {
    User add=new User(mysql.getInt(1),mysql.getString(2),mysql.getString(3));
    //append(new) is used to add a new entry to the list.
    userArray=(User[])append(userArray,add);
    //Wrong: cannot convert from Object to User[]: userArray=append(userArray,add);
    //Wrong: cannot invoke append(User) on the array User[]: userArray=userArray.append(add);
  }
  
  for(int i=0;i<userArray.length;i++)
  {
    println(userArray[i].id+"  "+userArray[i].username+"  "+userArray[i].password);
  }
  
}



//create a class

class User
{
  int id;
  String username;
  String password;
  User(int i,String u,String p)
  {
    id=i;
    username=u;
    password=p;
  }
}