Java – Storing SQL statements in an external file [closed]

by

Just create a simple Java Properties file with key-value pairs like this one:

users.select.all = select * from user

Declare a private field of type Properties in your DAO class and inject it using Spring configuration which will read the values from the file.

UPDATE: if you want to support SQL statements in multiple lines use this notation:

users.select.all.0 = select *
users.select.all.1 = from   user

More Related Contents:

  1. Hours and seconds are lost when storing a date in the database [closed]
  2. How to get the insert ID in JDBC?
  3. Insert & fetch java.time.LocalDate objects to/from an SQL database such as H2
  4. java.util.Date vs java.sql.Date
  5. Using setDate in PreparedStatement
  6. Efficient way to do batch INSERTS with JDBC
  7. How do I get the size of a java.sql.ResultSet?
  8. How can I get the SQL of a PreparedStatement?
  9. What is the best approach using JDBC for parameterizing an IN clause? [duplicate]
  10. Variable column names using prepared statements
  11. MySQL and JDBC with rewriteBatchedStatements=true
  12. right syntax to use near ‘?’
  13. Running a .sql script using MySQL with JDBC
  14. JDBC Pagination
  15. Getting output from dbms_output.get_lines using JDBC
  16. org.postgresql.util.PSQLException: FATAL: sorry, too many clients already
  17. handling DATETIME values 0000-00-00 00:00:00 in JDBC
  18. java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/dbname [duplicate]
  19. Java – Can’t use ResultSet after connection close
  20. Timezones in SQL DATE vs java.sql.Date
  21. Queries returning multiple result sets
  22. SQL prepared statement how to select via multiple possible menu selections?
  23. Class.forName(JDBC_DRIVER) no longer needed?
  24. dll missing in JDBC
  25. How do I use PostgreSQL JSON(B) operators containing a question mark “?” via JDBC
  26. How to use prepared statement for select query in Java?
  27. MS SQL Exception: Incorrect syntax near ‘@P0’
  28. MyBatis executing multiple sql statements in one go, is that possible?
  29. Database independence through JDBC in java
  30. Searching between dates in SQL with JDBC?

Leave a Comment