DaniWeb Forum Index > Web Development > JSP

how to get to next record on click of a button

Please support our JSP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Mar 2007

Posts: 29

Reputation: bhuvan83 is an unknown quantity at this point

Solved Threads: 0

bhuvan83

Offline

Light Poster

how to get to next record on click of a button

Mar 13th, 2007

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->

 Help with Code Tags 
 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" class="t" 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" class="t" 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.

Bhuvan Aggarwal
There is no word impossible.
its i m possible

•

Join Date: Dec 2004

Posts: 4,247

Reputation: peter_budo has much to be proud of

Solved Threads: 492

peter_budo peter_budo is offline

Offline

Code tags enforcer

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

Mar 14th, 2007

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

Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group

•

Join Date: Mar 2007

Posts: 29

Reputation: bhuvan83 is an unknown quantity at this point

Solved Threads: 0

bhuvan83

Offline

Light Poster

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

Mar 14th, 2007

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.

Bhuvan Aggarwal
There is no word impossible.
its i m possible

•

Join Date: Dec 2004

Posts: 4,247

Reputation: peter_budo has much to be proud of

Solved Threads: 492

peter_budo peter_budo is offline

Offline

Code tags enforcer

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

Mar 15th, 2007

nice explanation on wikipedia

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

 Help with Code Tags 
 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");