ajay madhav

Greenhorn
+ Follow
since May 12, 2008
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by ajay madhav

Hi All,
i am new in jsp. I want to give paginaiton using jsp in my application. I am able to show the records in browser. I want to display 5 records per page. I want to display them in google style like:
<<1 2 3 >>next

I am attatching my code herewith:

<%@ page import="java.sql.*" %>
<% String driverClass="com.mysql.jdbc.Driver";
String url="jdbc:mysql://localhost:3306/Test";
String userName="root";
String password="";
String user="";
String pword="";
Class.forName(driverClass);
Connection con=DriverManager.getConnection(url,userName,password);
out.println("Connection is established");
//String query="select * from userDetails ";
int count = 5;
String query="select * from userdetails limit "+count+" ";
Statement stm=con.createStatement();
ResultSet rs=stm.executeQuery(query);
out.println("Resultset created");%>


<table border=1 align=center width="100%">
<tr><th>username</th><th>password</th></tr>
<%
while(rs.next()){

user=rs.getString(1);
pword=rs.getString(2);
%>
<tr><td><%=user%></td><td><%=pword%></td></tr><%}%>
</table>


I am also giving my table structure:
tablename is 'userdetails'
fields are 'username, password, address'

It's very urgent for me.I will be very thankful for this help

Thanks in advance
Ajay Madhav
15 years ago
JSP