Suppose we have 1000 rows in the database i need to retrive 200 rows per page, then which approach is better either struts based or non struts based it is an interview question

Interview Candidate
Jul 21st, 2006
4
1999

Showing Answers 1 - 4 of 4 Answers

kishor

Jul 22nd, 2006

In case if you are using MySql database just you need to keep a hidden variable of page no and put the limit clouse in Sql query.
see as like this
PerPageRecord = 200
RecordStartfrom = (PageNo * PerPageRecord);
SqlString = "select * from table_name limit " + RecordStartfrom + " , " + PerPageRecord;
Take it
Kishor

bharaniprasanth
Profile Answers by bharaniprasanth Questions by bharaniprasanth

Mar 11th, 2008

Using struts is always a better option...because struts is robust and completely decouples the logic(data access) part with view..Alternatively we can use POJO's for handling the tasks...I think the interviewer is refering to a design pattern you would probably use