Web Page and Database Design Problem
Ok, so I'm trying to develop an app, but am having a few problems and need some advice/help.
I have a webpage made up of jsp pages. These pages will contain forms that will either list info from the databse, or allow users to enter data to submit to the DB.
So I will have Servelts that will process the form information.
I also have written DAO interfaces for different tables. For example I have a config table which olds keys and there values.
This information will only ever be displayed so I have an interface which getAll() and get(String key).
I want to avoid putting code like below going into the DAO
ctx = new InitialContext();
javax.sql.DataSource ds
= (javax.sql.DataSource) ctx.lookup (dataSource);
conn = ds.getConnection();
PreparedStatement stmt = conn.prepareStatement(query);
ResultSet records = stmt.executeQuery();
I'd prefer to make calls from my DAO getAll() method to another class which would create the connection, and query the db, and return the ResultSet, so that I can store/manipulate it anyway I wish, before passing the results back to the servlet.
Problem is the records seem to come back null!
