Forum:

Struts

Page navigation using struts2

Greenhorn

Posts: 7

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi,

I have a requirement where i need to fetch a group of datas from database and display them in the form of table in jsp.

I have to display them in such a way that I need to display first ten of them in a page and I have to give page nos like 1,2,3... under the page.

Suppose if user clicks on 1 first ten datas will be displayed. If user clicks 2 next ten datas will be displayed and so on.

These page numbers must be invoked dynamically.

(Just like in our google search results page)

I'm able to achieve in displaying first ten datas. How to display the remaining???

My code snippet is:

My java function is

public String completeviewdetails()
{
                        System.out.println("Inside completeviewdetails");
			Connection currentCon = null;
			Statement stmt = null;
			ResultSet rs = null;
			String driver = "com.mysql.jdbc.Driver";
			String searchQuery = "select * from platform";
			String plid;
			String plname;

try 
			{
				Class.forName(driver).newInstance();
				currentCon = DriverManager.getConnection("jdbc:mysql://192.168.27.111:3306/test");
				System.out.println("Connection with Database established");
				stmt = currentCon.createStatement();
				rs = stmt.executeQuery(searchQuery);
				System.out.println("searchQuery is executed : " + searchQuery);
				data.clear();

while (rs.next()) 
				{
					plid = rs.getString(1);
					System.out.println("The plid returned from database is : "+plid);
					plname = rs.getString(2);
					System.out.println("The plname returned from database is : "+plname);
					data.add(new tabledata(plid,plname));
					System.out.println("The data inside data arraylist is : "+data);
				}
			}
			catch (Exception ex) 
			{
				System.out.println("Exception has occurred! " + ex);
			}
return "success";
}

My JSP code is:

Can anyone help me???

Thanks in advance...

debraj mallick

Ranch Hand

Posts: 188

I like...

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

hope this would help you
http://www.servletsuite.com/tips/grid1.htm
www.displaytag.org

Vasanth Rajasekaran

Greenhorn

Posts: 7

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Thanks debraj mallick for your suggestion.. But I don have taglib122.tld ... Where do i get that???

Vasanth Rajasekaran

Greenhorn

Posts: 7

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi debraj mallick,

I got the two tld files you mentioned... Now where I have to put these tlds in my project so that i can use them in my code.

I am using Eclipse europa and I am developing my project as a Dynamic-web project...

Please help me.

thanks

debraj mallick

Ranch Hand

Posts: 188

I like...

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

you can download it from
http://displaytag.sourceforge.net/11/download.html
or
http://www.findjar.com/index.x?query=taglib

debraj mallick

Ranch Hand

Posts: 188

I like...

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

how to use
http://displaytag.sourceforge.net/11/install.html
tutorial:
http://displaytag.sourceforge.net/11/tut_basic.html
or google to get the tutorials

permaculture is a more symbiotic relationship with nature so I can be even lazier. Read tiny ad:

Smokeless wood heat with a rocket mass heater

https://woodheat.net