Ad:

JSP Discussion Thread
Marked Solved
Views: 7881

Mar 13th, 2007

how to get to next record on click of a button

Expand Post »

hi every1
i m new to website development.
just learning it.
i have made a code in which i access my database(MS Access).
i m able to print the first record of the database on the page.
but i m not able to go to next record which i want to show on click of a button.
i dont want to use while(rs.next) as i dont want to show all the records at once.
the code i m writing is->

JSP Syntax (Toggle Plain Text)
<%@ page import="java.sql.*" %>
<htmL>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String dataSourceName="mydsn";
String dbURL="jdbc:odbc:" + dataSourceName;
Connection con= DriverManager.getConnection(dbURL,"","");
Statement s=con.createStatement();
s.execute("select * from web");
ResultSet rs;
rs=s.getResultSet() ;
rs.next();
%>
<body>
<script>
function getDetails()
{
rs.next()
}
</script>
<form method="post">
Website:<input type="text" value="<%=rs.getString(1) %>"><br>
<a rel="nofollow" href="http://www.daniweb.com/techtalkforums/<input" target="_blank">Url:<input</a> type="text" value="<%=rs.getString(2) %>"><br>
Category: <input type="text" value="<%=rs.getString(3) %>"><br>
Description: <input type="text" value="<%=rs.getString(4) %>"><br>
Search Engine-><br>
Yahoo: <input type="text" value="<%=rs.getString(5) %>"><br>
Google: <input type="text" value="<%=rs.getString(6) %>"><br>
Altavista: <input type="text" value="<%=rs.getString(7) %>"><br>
<input type="button" value="Next" onClick="getDetails()">
</form>
</body>
</html>
<%@ page import="java.sql.*" %>
<htmL>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String dataSourceName="mydsn";
String dbURL="jdbc:odbc:" + dataSourceName;
Connection con= DriverManager.getConnection(dbURL,"","");
Statement s=con.createStatement();
s.execute("select * from web");
ResultSet rs;
rs=s.getResultSet() ;
rs.next();
%>
<body>
<script>
function getDetails()
{
rs.next()
}
</script>
<form method="post">
Website:<input type="text" value="<%=rs.getString(1) %>"><br>
<a rel="nofollow" href="http://www.daniweb.com/techtalkforums/<input" target="_blank">Url:<input</a> type="text" value="<%=rs.getString(2) %>"><br>
Category: <input type="text" value="<%=rs.getString(3) %>"><br>
Description: <input type="text" value="<%=rs.getString(4) %>"><br>
Search Engine-><br>
Yahoo: <input type="text" value="<%=rs.getString(5) %>"><br>
Google: <input type="text" value="<%=rs.getString(6) %>"><br>
Altavista: <input type="text" value="<%=rs.getString(7) %>"><br>
<input type="button" value="Next" onClick="getDetails()">
</form>
</body>
</html>

Last edited by bhuvan83; Mar 13th, 2007 at 7:53 am.

Similar Threads

how to get to next record on click of a button. in JavaScript / DHTML / AJAX
I want next record to Display in VB.NET
I want next record to Display in VB.NET
how to move to the next record in MySQLdb? in Python
how do i get the current time when i click a button? in ASP

bhuvan83

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

29 posts
since Mar 2007

Permalink

Mar 14th, 2007

Re: how to get to next record on click of a button

Why don't you store whole databse into bean and then on button press request next set

peter_budo

Moderator

Featured Poster

Reputation Points: 2786

Solved Threads: 875

Code tags enforcer

Offline

6,659 posts
since Dec 2004

Permalink

Mar 14th, 2007

Re: how to get to next record on click of a button

bro thanks for ur reply.
but i dont know how to use beans.
can u show me a small code????

Last edited by bhuvan83; Mar 14th, 2007 at 6:14 am.

bhuvan83

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

29 posts
since Mar 2007

Permalink

Mar 15th, 2007

Re: how to get to next record on click of a button

nice explanation on wikipedia

bellow is how do I get data from my db about events in calendar

JSP Syntax (Toggle Plain Text)
CalendarData[] eArr = new CalendarData[exists];
try
{				
	int i=0;
	strQuery = "select event_type, ev_date, ev_time, ev_description from calendar_events where userName='" + strUser + "' and cal_id='" + calId + "'";
	rs = stmt.executeQuery( strQuery);
	while( rs.next())
	{
		eArr[i] = new CalendarData();
		eArr[i].setEventType(rs.getString("event_type") );
		eArr[i].setEventDate(rs.getString("ev_date") );
		eArr[i].setEventTime(rs.getInt("ev_time") );
		eArr[i].setEventDescription(rs.getString("ev_description") );
		i++;					
	} // end while loop
	session.setAttribute("eventArray", eArr);
	CalendarData[] test = (CalendarData[]) session.getAttribute("eventArray");
CalendarData[] eArr = new CalendarData[exists];
try
{				
	int i=0;
	strQuery = "select event_type, ev_date, ev_time, ev_description from calendar_events where userName='" + strUser + "' and cal_id='" + calId + "'";
	rs = stmt.executeQuery( strQuery);
	while( rs.next())
	{
		eArr[i] = new CalendarData();
		eArr[i].setEventType(rs.getString("event_type") );
		eArr[i].setEventDate(rs.getString("ev_date") );
		eArr[i].setEventTime(rs.getInt("ev_time") );
		eArr[i].setEventDescription(rs.getString("ev_description") );
		i++;					
	} // end while loop
	session.setAttribute("eventArray", eArr);
	CalendarData[] test = (CalendarData[]) session.getAttribute("eventArray");

Also do not connect to DB from JSP use servlets

peter_budo

Moderator

Featured Poster

Reputation Points: 2786

Solved Threads: 875

Code tags enforcer

Offline

6,659 posts
since Dec 2004

Permalink

Mar 16th, 2007

Re: how to get to next record on click of a button

thanks got the soln

bhuvan83

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

29 posts
since Mar 2007

Permalink

Sep 19th, 2011

Re: how to get to next record on click of a button

Nice Nice! I used the Solution given by one of the members using the DAO Pattern! I agree with @peter_budo that having code in JSP does not solve problems quickly but rather call the methods from servlets or from separate java files. Great Thread! I also got a solution for one of my problems!

Thankz Once Again :-)

sagar_danceking

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

56 posts
since Jul 2011

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in JSP Forum Timeline: How to hide url in jsp ?

Next Thread in JSP Forum Timeline: Redirect to a page with parameters

DaniWeb Message

Cancel Changes

User Name
Password