Member Avatar for sunithamcsit

<%
int currentRow = 0;

int startingRow = ParamUtils.getIntParameter(request, "startingRow", 0);
int row_to_display = 200 ;
String errcode = null ;
try{
FPSProdMap[] oProdMap= dbFpsProdMap.getProdMap(sLang,1,200);
if (oProdMap != null) {
for (int i = 0; i < oProdMap.length; i++) {
currentRow++;
out.println("<TR><TD class='xRight' width='5%'>"+currentRow+"</TD>");
-------


}
}

here is my code contain in a jsp.
here records are displayed upto 200 only.
and one thing that more than 200 records are successfully added to the database
but Iam getting record display upto 200 only.
now can any one suggest that in a way
that i have to make my jsp to display
any number of records that I add. i.e dynamically.

  • 4 Contributors
  • 7 Replies
  • 134 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by masijade
Member Avatar for vinod_javas

int row_to_display = 200 ;
FPSProdMap[] oProdMap= dbFpsProdMap.getProdMap(sLang,1,200);


change that value 200 to your number of records like if it is 1000 means change it in to 1000

Member Avatar for vinod_javas

hi sunitha its no need to make new thread like this you could have added this code in your previous thread itself.... so you can get continuity for your problem solving.

Member Avatar for sunithamcsit

I want to display records dynamically, means without limit

Member Avatar for vinod_javas

for that you have to get the rowcount value for that particular table and then keep that value in that place of int row_to_display =

i dont know the exact method for getting row count value..

just search in google for getting Rowcount value... i think it may be getRowCount()

Member Avatar for Thendral

hai sunitha,

Just write a query like the following.

select count(*) as total from test;

while(rs.next())
{
int tot=rs.getInt("total");
}


now substitute this value(tot) in that place(instead of 200).

Member Avatar for sunithamcsit

thank you very much,
I tried like this and I got it.

thank q

Member Avatar for masijade

Of course, be forewarned, that unless you have locked the table you're using (and if you don't know how then just forget I mentioned that as I am not going to explain it), then between the time that you get the total with that query, and then actually pull the records from the database, the number of records could have changed (i.e. records added and/or deleted).

You would be much better off rewriting the dbFpsProdMap.getProdMap(sLang,1,200); method to internally produce an ArrayList, that can be grown dynamically and simply returning an array created from that ArrayList. (I'm assuming that sLang is the resultSet, if not pass it the resultSet and let it populate itself.) Then it will probably look like either dbFpsProdMap.getProdMap(sLang); (If sLang is a resultSet) or dbFpsProdMap.getProdMap(sLang, rs); (If it is not.)

The method can then, simply cycle through the resultSet adding FPSProdMap Objects to the ArrayList as it goes, and then, as mentioned, return an array created from this ArrayList.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.