how to set a value of dynamic number of drop down lists on a jsp page and access it value on another jsp page
actually i have to create dynamic number of drop down lists(depending upon number of books in that category) on jsp page pe v r creating these dynamic number of drop down lists having name rating1 ,rating2......number of buks in that category(and each drop down list has value from 0-4)
n on nxt page v r accessing value using request.getparameter
but on next page ven i try to print value of rating1.rating2.....
it is coming null
pls suggest any soln
thanks in advance:)
n i m also pasting both of my jsp files
one setting values of drop down lists and other one accessing it
in this jsp i m accessing values of rating1,rating2....
which are names given to drop down lists
i hav make the line bold in which i m setting the values
<%--
Document : book_title
Created on : Aug 20, 2012, 6:24:04 AM
Author : Pradeep
--%>
<%@page import= "java.sql.*"%>
<%
int count=0,count1=0,i=1,m;
String isbn,s_no;
String op;
String subject = (String) session.getAttribute("subject");
String userid = (String) session.getAttribute("userid");
String updateString1;
String category=request.getParameter("count1");
session.setAttribute("category", category);
//String buffer="<br/><b>BOOK_TITLE</b><select name='book_title'><option value='-1'>Select</option>";
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/recommender","root","purnima");
ResultSet rs2,rs3;
PreparedStatement pstmt = null;
int updateQuery=0;
Statement stmt = con.createStatement();
//Statement stmt1 = con.createStatement();
Statement stmt2 = con.createStatement();
//Statement stmt3 = con.createStatement();
System.out.println("Select book_title from book_info where subject='"+subject+"' AND CATEGORY='"+category+"'");
rs2 = stmt.executeQuery("Select S_NO,ISBN,book_title from book_info where subject='"+subject+"' AND CATEGORY='"+category+"'");
%>
<br/><b>
<% out.print(" BOOKS TO BE RATED ARE:: \n"); %>
</b><br/><br/>
<table>
<tr><td>
<% while(rs2.next())
{
count1++;
}
//session.setAttribute("count1", count1);
rs3 = stmt2.executeQuery("Select S_NO,ISBN,book_title from book_info where subject='"+subject+"' AND CATEGORY='"+category+"'");
while(rs3.next()){
// buffer=buffer+"<option value='"+rs.getString("BOOK_TITLE")+"'>"+rs.getString("BOOK_TITLE")+"</option>";
// s_no=rs3.getString("S_NO");
// isbn=rs3.getString("ISBN");
out.print(" "+rs3.getString("BOOK_TITLE")+" ");
**op ="rating"+i; %>
<select name=op>**
<% System.out.println("op is "+op); i++;
%>
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option></select>
</td></tr><br/></table>
<% } %>
<center>
<form name="" ACTION="recommendation.jsp" METHOD=POST>
<input type="submit" value="SUBMIT">
</form>
</center>
<%
//buffer=buffer+"</select>";
//response.getWriter().println(buffer);
}
catch(Exception e){
System.out.println(e);
}
%>
in this fragment of jsp page i m accessing values of rating1,rating2....
which are names given to drop down lists
i have made the line bold in which i am accessing the values
else
{
for(i=0;i<count1;i++)
{
**app=i+1;
name=opname+app;
val=request.getParameter(name);**
if(!val.equals("0"))
{
for(j=0;j<count2;j++)
{
if(book_isbn[i].equals(isbn[j]))//if user has changed the rating
{
flag=1;
//st.executeUpdate("UPDATE TABLE USER_LIKING SET RATING = val WHERE USERID=userid and ISBN=isbn[j]");
break;
}
}
if(flag==0)//is user had never given rating for this particular book
{
String query = "INSERT INTO USER_LIKING(USER_ID,ISBN,RATING) VALUES(?,?,?)";
pstmt = con.prepareStatement(query);
pstmt.setString(1, userid);
pstmt.setString(2, book_isbn[i][0]);
pstmt.setString(3, val);
updateQuery = pstmt.executeUpdate();
if(updateQuery!=0)
System.out.println("The record has been successfully added to our database");
}
}
}
}
}
catch(Exception e){
System.out.println(e);
}
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<h1>Hello World!</h1>
</body>
</html>
print("code sample");
View Answers
Related Tutorials/Questions & Answers:
Advertisements
How to pass the value from controller to jsp page ?How to pass the
value from controller to
jsp page ? HI
I need to pass the
value from controller to
jsp.
I use the way like this
Controller
request.setAttribute("msg", "Successfully Login");
In
jsp
${msg}
and then i
session value not get in many jsp page.session
value not get in many
jsp page. I am using servlet to
set...,response);
and get session
value on
jsp page by follwing:-
(adsbygoogle...)session.getAttribute("user");
this is work but when this code is use in other
jsp page its give
how to set time in jsp page how to
set time in
jsp page I need code for
set the time in
jsp code .iam using struts frame work back end oracle 10g ide is eclipse 6.0
how to delete the access database value in jsphow to delete the
access database
value in jsp i loaded my database data into the dropdown list box...now i want to delete the
value..plz send the source code to delete the
value in dropdown list box and also from database
how to delete the access database value in jsphow to delete the
access database
value in jsp i loaded my database data into the dropdown list box...now i want to delete the
value..plz send the source code to delete the
value in dropdown list box and also from database
How To Include Two Jsp page in another jsp page?How To Include Two
Jsp page in
another jsp page? I use following code to Include Two
Jsp Page Header and footer
<%@include file="header.jsp... in
page
How can i Display at correct position?
Please visit
Get form value in same page - JSP-ServletGet form
value in same page Hello friends,
Can we get a form field
value in the same to be processed in java coding... friend,
For solving the problem visit to :
http://roseindia.net/
jsp/user
How to save value in JSP 324 2012-12-12
save
i want to save dis
value jsp to action ...
how can i get all
value ..and store..
how can its values goes...
How to save
value in JSP Employee Name Time-IN Time-OUT
Create dynamic page through JSP Create
dynamic page through
JSP...
how to create
dynamic page. This code shows one by one record of student from... Tomcat-6.0.16/webapps/user/ and run this
jsp page with
following url in address bar
Drop down and radio button value on edit actionDrop down and radio button
value on edit action HI,
I have a title field and a payment type field
for title i have used
drop down with values... for text boxes..bt select default
value for dropdown and radio button...
How do
jsp drop down without refresh - JSP-Servletjsp drop down without refresh Sir
I have tried two depenedent
jsp dropdown in
jsp page,But the probleam is when i select first
drop down its...
jsp same probleam also arise. Please tell me
how to use the
drop down without
JSP Value to JavaScript that accepts the
value from the
jsp page.
Understand with ExampleADS_TO_REPLACE_1... have create a function addition() which takes the
value from the
jsp
page. When...
JSP Value to JavaScript
use struts 1.0 to view sql table value on JSP pageuse struts 1.0 to view sql table
value on
JSP page Here i am using struts 1.0 to view my sql table values on
jsp page. But the problem is when i append the
value in bean then i find the last row of table is shown repetedly. Any
use struts 1.0 to view sql table value on JSP pageuse struts 1.0 to view sql table
value on
JSP page Here i am using struts 1.0 to view my sql table values on
jsp page. But the problem is when i append the
value in bean then i find the last row of table is shown repetedly. Any
How to give the value - JSP-ServletHow to give the
value How to give the
value in following query..
"select * from studentinformation where studentid = '?'";
How to give the
value into question mark?... Hi Friend,
Try the following code
Passing Parameters to Another JSP PagePassing Parameters to
Another JSP Page
By using the include action we can pass the parameters
to
another jsp page... introduce a new request parameter when calling a
jsp page.
This param tag can
calling one jap page from another jsp pagecalling one jap
page from
another jsp page i created a button in one
jsp page i need to call
another jsp page as an action to that button. so
how can i call.. plz any one explain. its urgent
JSP Dependent Drop Down MenuJSP Dependent
Drop Down Menu Hey Guy/Gals!
I need someone help to guide me in creating a
drop down menu, where the first menu affects the second... guessing I will need to use
JSP + AJAX to make this
dynamic. Can anyone please
problem of static in jsp page by multiple user access from my
jsp page , ths
page can
access by more
number of users .every user...problem of static in
jsp page by multiple user access hi ,
i am... by submitting n
number of users.
i want to this singleton class should be act
dynamic drop down listdynamic drop down list I want to create 2
drop down list, where it takes
value from database and the two list are dependent..means if I select... on the
value chosen from the previous. want code in javascript and
jsp,
Can you help
jsp drop down-- select Optionjsp drop down-- select Option
how to get
drop down populated...) in database and try the following code:ADS_TO_REPLACE_1
<%@
page import="java.sql.... a country:</b> </td>
<select name="sel"><option
value