So I have one page with a list of dynamically populated items like this
1 [checkbox]
2 [checkbox]
...
...
n [checkbox]
Submit button
So the second page(B.jsp) needs to say " You selected 1,2,3" (apart from stuffing them into a database)
Here's a snippet of code from A.jsp
Expand|Select|Wrap|Line Numbers
- ========================================================
- <% String url = "jdbc:mysql://...";
- String user= "";
- String pass= "";
- String temp = "_";
- try{
- Class.forName ("com.mysql.jdbc.Driver").newInstance ();
- Connection conn = DriverManager.getConnection(url, user, pass);
- Statement stmt = conn.createStatement();
- ResultSet rs = stmt.executeQuery("SELECT * FROM <tablename>");
- while(rs.next()){ %>
- <table><tr>
- <td><b><%= rs.getString("ID") %></b></td>
- <td><%= rs.getString("DESCRIPTION") %></td>
- <td> <input name="Select" type="checkbox" value="<%=rs.getString("ID")%> checked"></td>
- </tr></table>
- <% String selection = rs.getString("ID");
- temp = temp + selection + "_";
- }
- rs.close();
- conn.close();
- }catch(Exception e)
- {out.println(e.toString());
- }
- %>
- </p>
- <p> </p>
- <form name="form1" method="post" action="B.jsp">
- <label>
- <input type="submit" name="Select" >
- </label>
- </form>
- </BODY>
- ========================================================
If the user selects items 1, 2, 3, I need to pass _1_2_3
I'm not familiar with checkboxes and unable to capture only those that the user selects. In the example above, I'm trying to capture only those IDs from the checkboxes the user selects under temp. Right now, every single ID is appended to temp and it looks like _1_2_3_...._n.
Can you pls. take a look at the code?
Thank you for your time!
D.