2017.08.27 16:19 Networking in Java 04

Using the Database getStringResult method, I was able to receive the values I sent using the executeUpdate method in the last post. 

For example,

"SELECT name FROM prefix_horse WHERE owner = \"%s\" AND id = %d"

This MariaDB command receives the data value from the database for the given owner username and uuid.

zHorse is really useful for breaking down database values.

Pooling this knowledge, I was able to add another value to the "horses", a gender value.

Storing them in the database however required a full database import, which I will be doing tommorrow.

  public String getHorseName(UUID ownerUUID, int horseID) {
        String query = String.format("SELECT name FROM prefix_horse WHERE owner = \"%s\" AND id = %d", ownerUUID, horseID);
        return db.getStringResult(query);
    }