I have the Java object with a method "getUser" which will do a query, for example "select * from user when table.name= $param1"
The method have the parameter "Map<String, String> params" , for example "params.add("param1", "Den")"
I want to store the query in other file, for example GetUser.sql
When running the program I change the query.
How do this?
I won't found a framework
You could use java property file store your query. During program execution, you could load the query from property file and fill the parameters and execute the final query to the database.
query.getuser = select * from user when table.name= $param1
From code load the property file and get your query string:
Properties property = //load property file
String getUserQuery= propertie.getProperty("query.getuser");
Alternatively, you could use JPA/Hibernate named query where you can keep your query into another external mapping file. See, http://docs.jboss.org/hibernate/orm/4.1/devguide/en-US/html/ch13.html
You can try FileAlterationMonitor from Apache commons-vfs:
FileSystemManager fsManager = VFS.getManager();
FileObject file = fsManager.resolveFile("/path-to-file");
DefaultFileMonitor fm = new DefaultFileMonitor(new FileChangeListener());
fm.addFile(file);
fm.start();
public class FileChangeListener implements FileListener {
@Override
public void fileCreated(FileChangeEvent event) throws Exception {
//do nothing
}
@Override
public void fileDeleted(FileChangeEvent event) throws Exception {
//do nothing
}
@Override
public void fileChanged(FileChangeEvent event) throws Exception {
//Reload query from file
}
}
For query reloading you can use Shamim Ahmmed's answer.
