Skip to content

Instantly share code, notes, and snippets.

@Muwbi
Created September 25, 2013 19:10
Show Gist options
  • Save Muwbi/6704499 to your computer and use it in GitHub Desktop.
Save Muwbi/6704499 to your computer and use it in GitHub Desktop.
public static void set(String playerName, int number) {
try {
PreparedStatement checkStatement = connection.prepareStatement("SELECT ? FROM ? WHERE ? = ?;");
checkStatement.setString(1, INT_COLUMN);
checkStatement.setString(2, MYSQL_TABLE);
checkStatement.setString(3, USER_COLUMN);
checkStatement.setString(4, playerName);
if (checkStatement.executeQuery().next()) {
PreparedStatement updateStatement = connection.prepareStatement("UPDATE ? SET ? = ? WHERE ? = ?;");
updateStatement.setString(1, MYSQL_TABLE);
updateStatement.setString(2, INT_COLUMN);
updateStatement.setInt(3, number);
updateStatement.setString(4, USER_COLUMN);
updateStatement.setString(5, playerName);
updateStatement.execute();
} else {
PreparedStatement createStatement = connection.prepareStatement("INSERT INTO ? (?, ?) VALUES (?, ?);");
createStatement.setString(1, MYSQL_TABLE);
createStatement.setString(2, USER_COLUMN);
createStatement.setString(3, INT_COLUMN);
createStatement.setString(4, playerName);
createStatement.setInt(5, number);
createStatement.execute();
}
} catch (SQLException ex) {
ex.printStackTrace();
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment