Home
Answers
Viewqa
JSP-Servlet
to display single row from database and next to display other question
QuestionAsk Questions?
usha
to display single row from database and next to display other question
1 Answer(s) 2 years and 11 months ago
Posted in : JSP-Servlet
1 Answer(s) 2 years and 11 months ago
Posted in : JSP-Servlet
Hi all,
I am using JSP with MYSQL backend.
In my project we have 100 questions in database
we have to display first question
on clicking the button it has to display the next question.
i tried it
first question is displayed, but i am facing a problem while retieving the next question in the jsp page.
its giving null.
I am new to jsp. can any one help me please
Thanks in advance,
Usha
I am using JSP with MYSQL backend.
In my project we have 100 questions in database
we have to display first question
on clicking the button it has to display the next question.
i tried it
first question is displayed, but i am facing a problem while retieving the next question in the jsp page.
its giving null.
I am new to jsp. can any one help me please
Thanks in advance,
Usha
View Answers
July 1, 2010 at 3:12 PM
Hi Friend,
Try the following code:
next.jsp:
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<HTML>
<BODY>
<% int current = 0;
Connection connection = null;
ResultSet rs = null;
%>
<FORM NAME="form1" ACTION="next.jsp" METHOD="get"><%
if (request.getParameter("hidden") != null) {
current = Integer.parseInt(request.getParameter("hidden"));
}
Statement statement = null;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test";,
"root", "root");
statement = connection.createStatement();
rs = statement.executeQuery("select * from question");
for (int i = 0; i < current; i++) {
rs.next();
}
if (!rs.next()) {
out.println("All questions are over");
} else {
%>
<TABLE>
<TR><TH><%=rs.getString(2)%></TH><TD><input type="text"></TD></TR>
</TR>
</TABLE>
<BR>
<INPUT TYPE="hidden" NAME="hidden" VALUE="<%=current + 1%>">
<INPUT TYPE="submit" VALUE="Next">
</FORM>
<%
}
}
catch (Exception ex) {
}
finally {
rs.close();
statement.close();
connection.close();
}
%>
</FONT>
</FORM>
</body>
</html>
Thanks
Try the following code:
next.jsp:
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<HTML>
<BODY>
<% int current = 0;
Connection connection = null;
ResultSet rs = null;
%>
<FORM NAME="form1" ACTION="next.jsp" METHOD="get"><%
if (request.getParameter("hidden") != null) {
current = Integer.parseInt(request.getParameter("hidden"));
}
Statement statement = null;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test";,
"root", "root");
statement = connection.createStatement();
rs = statement.executeQuery("select * from question");
for (int i = 0; i < current; i++) {
rs.next();
}
if (!rs.next()) {
out.println("All questions are over");
} else {
%>
<TABLE>
<TR><TH><%=rs.getString(2)%></TH><TD><input type="text"></TD></TR>
</TR>
</TABLE>
<BR>
<INPUT TYPE="hidden" NAME="hidden" VALUE="<%=current + 1%>">
<INPUT TYPE="submit" VALUE="Next">
</FORM>
<%
}
}
catch (Exception ex) {
}
finally {
rs.close();
statement.close();
connection.close();
}
%>
</FONT>
</FORM>
</body>
</html>
Thanks
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
