Advertisement
Guest User

Untitled

a guest
Oct 25th, 2021
30
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.84 KB | None | 0 0
  1. public static AccountLink getAccountLinkByPlayer(@NotNull UUID playerUUID) {
  2. final String selectQuery =
  3. "SELECT * " +
  4. "FROM linked_users " +
  5. "WHERE player_uuid = ?";
  6.  
  7. try (Connection con = DriverManager.getConnection("jdbc:mysql://" + host + ":" + port + "/" + database, username, password)) {
  8. PreparedStatement preparedStatement = con.prepareStatement(selectQuery);
  9.  
  10. preparedStatement.setString(1, playerUUID.toString());
  11.  
  12. final ResultSet resultSet = preparedStatement.executeQuery();
  13. resultSet.next();
  14.  
  15. if (!(resultSet.getString("discord_id") == null) || !(resultSet.getString("link_date") == null)) {
  16. return new AccountLink(playerUUID.toString(), resultSet.getString("discord_id"), resultSet.getString("link_date"));
  17. }
  18. } catch (SQLException e) {
  19. e.printStackTrace();
  20. }
  21.  
  22. return null;
  23. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement