Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public LinkedHashMap<Double, String> getMoneyTop() {
- try {
- String sql = "SELECT player, money FROM economy ORDER BY money DESC LIMIT 10";
- PreparedStatement stmt = connection.prepareStatement(sql);
- ResultSet results = stmt.executeQuery();
- Map<Double, String> playersInfo = new TreeMap<Double, String>(Collections.reverseOrder()); // player / money
- LinkedHashMap<Double, String> playersInfoSorted = new LinkedHashMap<>();
- while(results.next()) {
- playersInfo.put(results.getDouble("money"), results.getString("player"));
- }
- playersInfo.entrySet().stream().sorted(Map.Entry.comparingByKey(Comparator.reverseOrder()))
- .forEachOrdered(x -> playersInfoSorted.put(x.getKey(), x.getValue()));
- return playersInfoSorted;
- } catch (SQLException e) {
- Bukkit.getConsoleSender().sendMessage(serverTag + "§4[ERR:DB:3.2] §cFailed to DB_SELECT => @sqlSelect");
- e.printStackTrace();
- }
- return null;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement