Member Avatar for Raghu.Pattem

pls help me...

  • 3 Contributors
  • 2 Replies
  • 69 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by Lalit Chattar
Member Avatar for peter_budo

No you did not provide proper description.

Maybe, once you provide proper description

Member Avatar for Lalit Chattar

pls help me...

hi i am also new in web development. but i hava concept for this.

i give a code with attechment which show 5 resullt at time and on click next display next 5.

<jsp:useBean id="db2" class="sqlBean.DbBean"></jsp:useBean>
<%@page import="java.io.*" %>
<%@page import="java.sql.*" %>
<html>
<head></head>
<body>
<%
	int first =0,last=5,rec=5,loop=0,count=0;;
	if(request.getParameter("first")!=null)
	{
		first=Integer.parseInt(request.getParameter("first"));
	}
	if(request.getParameter("rec")!=null)
	{
		rec=Integer.parseInt(request.getParameter("rec"));
	}
	if(request.getParameter("last")!=null)
	{
		last=Integer.parseInt(request.getParameter("last"));
	}
	String sql ="select name from MIT.CONSTITUENCY";
	db2.connect();
	ResultSet rs = db2.execSQL(sql); %>
	<a href="hello.jsp?first=<%=first-last %>&rec=<%=rec-last %>">Prev</a>
	<%

	while(rs.next())
	{
		last+=1;
		count++;
		if(first<rec && rec<last){loop++;
		out.println(rs.getString("name"));
		first++;
		}
	}	rec+=5;out.println(loop);
	if(first%5!=0)
	{
		int i = 5-loop;
		first+=i;
		
	}
	
		%>
			<a href="hello.jsp?first=<%=first %>&rec=<%=rec %>">Next</a>
		</body>
</html>
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.