Using a prepared statement and variable bind Order By in Java with JDBC driver

by

Placeholders ? can only be used for parameter values but not with column and sort order directions. So the standard way to do this as is pointed e.g. here is to use String#format() or something similar to append your column name and order value to your query.

Another option is to use Spring Data JPA where you can give to your method as an argument an instance of type Sort which can contain all needed info for database to sort.

More Related Contents:

  1. Sorting an ArrayList of objects using a custom sorting order
  2. How to sort a List/ArrayList?
  3. Why is there no SortedList in Java?
  4. Sorting a collection of objects [duplicate]
  5. How to execute IN() SQL queries with Spring’s JDBCTemplate effectively?
  6. How to sort an ArrayList in Java [duplicate]
  7. Sort Java Collection
  8. Sort a Map by values
  9. Collections.sort with multiple fields
  10. Sorted collection in Java
  11. How can I sort a List alphabetically?
  12. How to sort an arraylist of objects by a property?
  13. How to sort an ArrayList using multiple sorting criteria?
  14. Android-java- How to sort a list of objects by a certain value within the object
  15. Why does Collections.sort use Mergesort but Arrays.sort does not?
  16. Java List Sorting: Is there a way to keep a list permantly sorted automatically like TreeMap?
  17. Is it faster to add to a collection then sort it, or add to a sorted collection?
  18. Sort a List of objects by multiple fields [duplicate]
  19. How to sort a Collection?
  20. How do I make 2 comparable methods in only one class?
  21. NamedParameterJdbcTemplate vs JdbcTemplate
  22. How to use Collections.sort() in Java?
  23. how to copy data from file to PostgreSQL using JDBC?
  24. Sort List of Strings with Localization
  25. Automatically sorted by values map in Java
  26. Why Collections.sort uses merge sort instead of quicksort?
  27. How to connect SQLite with Java?
  28. “Loading class com.mysql.jdbc.Driver … is deprecated” message
  29. Storing different types of elements in a List in Java
  30. Mergesort in java

Leave a Comment