Running Deeper

All Posts (126)

Notice

Running Deeper C/C++/Java

Algorithms & Development/Java Development

TreasureSharky

Sending MySQL updates and more using MySQL MariaDB commands as Strings

Using the update function, I send commands using MySQL strings. The following source snippet is an update function for the databases from zHorse (byZedd7), and I have successfully sent a few lines of data to the MySQL database! Next, I will be trying to get values from a MySQL database.

I also will be experimenting with SQLite and FTP/SFTP coding.

String horseUpdate = String.format("UPDATE prefix_horse SET id = %s WHERE uuid = \"%s\"", DEFAULT_DEAD_HORSE_ID, horseUUID);
            String horseDeathUpdate = String.format("INSERT INTO prefix_horse_death VALUES (\"%s\", \"%s\")", horseDeathRecord.getUUID(), DATE_FORMAT.format(horseDeathRecord.getDate()));
            success &= updateHorseIDMapping(ownerUUID, horseID);
            success &= db.executeUpdate(horseUpdate);
            success &= db.executeUpdate(horseDeathUpdate);
        } else {
            success &= removeHorse(horseUUID, ownerUUID, horseID);
        }
        return success;
    }

    public boolean registerHorseInventory(HorseInventoryRecord horseInventoryRecord) {
        String update = String.format("INSERT INTO prefix_horse_inventory VALUES (\"%s\", \"%s\")",
                horseInventoryRecord.getUUID(),
                horseInventoryRecord.getSerial()
        );
        return db.executeUpdate(update);
    }

저작자표시

Sending MySQL updates and more using MySQL MariaDB commands as Strings

I also will be experimenting with SQLite and FTP/SFTP coding.

String horseUpdate = String.format("UPDATE prefix_horse SET id = %s WHERE uuid = \"%s\"", DEFAULT_DEAD_HORSE_ID, horseUUID);
            String horseDeathUpdate = String.format("INSERT INTO prefix_horse_death VALUES (\"%s\", \"%s\")", horseDeathRecord.getUUID(), DATE_FORMAT.format(horseDeathRecord.getDate()));
            success &= updateHorseIDMapping(ownerUUID, horseID);
            success &= db.executeUpdate(horseUpdate);
            success &= db.executeUpdate(horseDeathUpdate);
        } else {
            success &= removeHorse(horseUUID, ownerUUID, horseID);
        }
        return success;
    }

    public boolean registerHorseInventory(HorseInventoryRecord horseInventoryRecord) {
        String update = String.format("INSERT INTO prefix_horse_inventory VALUES (\"%s\", \"%s\")",
                horseInventoryRecord.getUUID(),
                horseInventoryRecord.getSerial()
        );
        return db.executeUpdate(update);
    }

저작자표시

'; document.write(x.substring(x.length-900,x.length;

Comments

Running Deeper C++/C/Java

Running Deeper C/C++/Java

티스토리툴바

Running Deeper C/C++/Java

strDate='2017 08.26 16:34 Networking in Java 03'; strDate2='2017 08.26 16:34 Networking in Java 03'.substr(16,9000); if(strDate.charAt(0)=='2')document.write(strDate2); else document.write('2017 08.26 16:34 Networking in Java 03');

strDate='2017 08.26 16:34 Networking in Java 03'; strDate2='2017 08.26 16:34 Networking in Java 03'.substr(16,9000); if(strDate.charAt(0)=='2')document.write(strDate2); else document.write('2017 08.26 16:34 Networking in Java 03');

티스토리툴바