hai to all,
please help me to retrieve record one by one by click the button.
please check my code.it is not work..
my code is:
<%@ page import="java.sql.*"%>
<SCRIPT LANGUAGE="JavaScript">
function move()
{
var cu = 0
cu = parseInt(document.form1.hidden.value) + 1
document.form1.hidden.value = cu
form1.submit()
}
</SCRIPT>
<FORM NAME="form1" ACTION="query.jsp" >
<%
int cu=1;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:tdsn");
if(request.getParameter("hidden") != null)
cu = Integer.parseInt(request.getParameter("hidden"));
String useri=request.getParameter("D1");
if(useri.equals("SiteType"))
{
String a=request.getParameter("T1");
PreparedStatement ps=con.prepareStatement("SELECT sitetype,buildinght,towerht from tower where sitetype=? and basic.sid=tower.sid");
ps.setString(1,a);
ResultSet rs=ps.executeQuery();
%>
<%
if(rs.next())
{
String r=rs.getString("sitetype");
String d=rs.getString("buildinght");
String f=rs.getString("towerht");
%>
<table>
<tr><%=r%></tr>
<tr><%=d%></tr>
<tr><%=f%></tr>
<input type="button" value="next" onclick="move();">
<input type="hidden" name="hidden" value="<%=cu%>">
<%
}}
%>