how to fetch the value of the checkbox in jsp?

Hi everyone,

Can anybody help me out how to get the value of the checkbox value in a variable using getparameter or anything else in jsp..
The scenario is like this,I have list of data that is displayed in tabular form(row n column wise)and those data are retrived from the database only..In one column,i have check boxes corresponding to each row.So when i select check boxes(more than one),then that corresponding row values should be retrived and to be displayed in anothor page or frame.But i dont know how to retrive those values in jsp..

The code for those tabular data is like this:

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
    
    <%@ page session="true" %>
<%@ page import = "java.util.Date,java.text.SimpleDateFormat,java.text.ParseException"%>
<%@ page import="java.io.*,java.net.*,java.util.*,java.sql.*" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>indexing page</title>
<style type="text/css">

</style></head>
 
<body>
<div align="center"><u><strong>INDEXER PAGE</strong></u></div>
<form id="form1" name="form1" method="post" action="">
  <p>      INDEXING LIST</p>
 
<%
  Connection conn=null;
try{

Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/trackingsystem","root","root");
}
catch(SQLException e)
{
System.out.println("SQLException: " + e.getMessage());
while((e = e.getNextException()) != null)
System.out.println(e.getMessage());
}
catch(ClassNotFoundException e)
{
System.out.println("ClassNotFoundException: " + e.getMessage());
}
      ResultSet rs=null;
  Statement stmt = conn.createStatement();
          // sql query to retrieve values from the secified table.
          String QueryString = "SELECT * from indexinfo";
          rs = stmt.executeQuery(QueryString);
%>
<table cellpadding="15" border="3" style="background-color: #ffffcc;">
 
<tr>
      <td><b>SELECT</b></td>
      <td width="145"><b>SCANED DATE(YYYY-MM-DD)</b></td>
      <td width="140"><b>DUE DATE</td>
      <td width="167"><b>INDEX DATE</td>
      <td width="198"><b>BATCH</td>
      <td width="228"><b>TOTAL NO OF PAGES</td>
    </tr>
    
    <%
    while (rs.next()) {
    %>
     
    <tr>
      <td><input type="checkbox" name="checkbox" id="checkbox" /></td>
        <td><%=rs.getDate("scandate")%></td>
        <td><%=rs.getDate("duedate")%></td>
        <td><%=rs.getDate("indexdate")%></td>
        <td><%=rs.getString("batch")%></td>
        <td><%=rs.getInt("totalpages")%></td>
    </tr>
    
    <%
    }   
    
   
    rs.close();
    stmt.close();
    conn.close();

%>
  </table>
 
 
 
 
  <p>                                  
    <input type="submit" name="button" id="button" value="SUBMIT" />
  </p>
  <p> </p>
  <p> </p>
  <p> </p>
  <p> </p>
  <p> </p>
</form>
</body>
</html>

Thanks in advance,
Sanat

[ November 14, 2008: Message edited by: sanat meher ]

[ November 14, 2008: Message edited by: sanat meher ]
[ November 14, 2008: Message edited by: Bear Bibeault ]

give all the check boxes the same name and assign each one with a different value, say the rows primary key.

Use request.getParameterNames() in the servlet and you will get an array which will have only the checked values

sorry use request.getParameterValues() insteda of request.getParameterNames

Its not a good programming practice to have all that database code in a JSP, you should be using a bean.

Are you not familiar with EL?