I am trying to set SQLQuery
and trying to get its result via bean but unable to fix it. Here is my code:
public static int countTotalNumberOfRecords(String countQuery) throws SQLException {
CountQueryDAO db = new CountQueryDAO();
PagingBeanProcessor bean = new PagingBeanProcessor();
bean.setCountQuery(countQuery);
bean = db.selectAll();
int totalRecords = bean.getTotalRecords();
return totalRecords;
}
This is how I am calling this method Paging.countTotalNumberOfRecords(countQuery);
and here is my DAO class code that always get query from this method as null
:
public PagingBeanProcessor selectAll() throws SQLException {
PagingBeanProcessor bean = new PagingBeanProcessor();
String countQuery = bean.getCountQuery();
System.out.println("country dao-->"+countQuery);
Here is what I am seeing on console:
country dao-->null
commons.utils.paging.CountQueryDAO
java.sql.SQLException: SQL statement to execute cannot be empty or null
Why I am getting null? why my countTotalNumberOfRecords
method is passing to DAO
as null? or why my PagingBeanProcessor
is not setting or getting parameters
Thanks in anticipation
You need to sign in to view this answers