save checked value in checkbox to database

Hi
I have problem in saving checkbox values to the database. I have a JSP form which has some 18 checkboxes in it. The form is like providing permissions to particular usergroup. Some group are allowed to use some permissions but say an administrator has chance to work on all modules. Once the check boxes are checked, value 1 should get saved in database either through JSP code or servlets code. We are actually using servlet for database connectivity like adding new record to databse, saving the record etc. How do i trap whether the check boxes are checked or not ? After trapping, how do pass the value 0 or 1 to database based on whether checked or unchecked.
SO now how i go about it ? i.e., saving the checked check box value in databse.
ANd also, when i select a particular group, i need to display all the checkboxes + checked checkboxes for which that group is given permissions
Here is a sample of code which i have written:

<%@ page language="java" import="java.sql.*,java.util.*,java.net.*,java.text.*,VAS_Conn,ConnectionPool" session="true"  isThreadSafe="true" contentType="text/html" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<script language = "JavaScript" src="commonjs.js"></script>
<script language=javascript src="Edit.js">
</script>
<script language="javascript">
function display(field)
{
   for (var i=0; i < field.length; i++)
   if (field[i].checked)
   alert('Check '+i+' with value of '+field[i].value);
     
}
</script>
<title>User Group Creation</title>
</head>

<body bgcolor = #ff9664  background = "file:///d:/VAS%20Project/background16%20copy.gif" >
<H1 align=center><FONT face=Tahoma><U 
style="VISIBILITY: visible">User Group Creation </U>  
</FONT>  </H1>

<form name="UGCreation" id="UGCreation">
<%!String param = "";%>
<%
      Connection con=null;
  Statement st=null;
  ResultSet rs=null;
  ConnectionPool Pool=null;
  try
  {
  Pool=(ConnectionPool) getServletContext().getAttribute("CON_POOL");
  if (Pool==null)
  {
  Pool=new ConnectionPool();
  getServletContext().setAttribute("CON_POOL", Pool);
  }
  System.out.println("before update");
  }
 catch(Exception e)
 {
 System.out.println(e);
 }
 %>
 
 <br>
 <Center>                             
 <FONT face=Tahoma size=2> Group Name   :</Font>
 <INPUT ID = GrpName name=GrpName  size = 10 value="" style="LEFT: 100px" tabIndex=1> </FONT> 
 <br><br>
 
 <TABLE border=2 style="HEIGHT: 293px; WIDTH: 411px" width=750 align = "center" id=TABLE1>
 
 <TR>
 <TH width></TH>
 <TH width>ADD</TH>
 <TH width>EDIT</TH>
 <TH width>DELETE</TH> 
 </TR>
 
 <TR>
 <TH width=200>User Master</TH>
 <TD width = 75 align=center><input type="checkbox" name="list" value="1"</TD>
 <TD width=75 align=center><input type="checkbox" name="list" value="2"</TD>
 <TD width=75 align=center><input type="checkbox" name="list" value="3"</TD>
 </TR>
 
 <TR>
 <TH width=200>User Group Master</TH>
 <TD width = 75 align=center><input type="checkbox" name="list" value="4"</TD>
 <TD width = 75 align=center><input type="checkbox" name="list" value="5"</TD>
 <TD width = 75 align=center><input type="checkbox" name="list" value="6"</TD>
 </TR>
 
 <TR>
 <TH width=200>Outlet Master</TH>
 <TD width = 75 align=center><input type="checkbox" name="list" value="7"</TD>
 <TD width = 75 align=center><input type="checkbox" name="list" value="8"</TD>
 <TD width = 75 align=center><input type="checkbox" name="list" value="9"</TD>
 </TR>
 
 <TR>
 <TH width=200>Transaction type Master</TH>
 <TD width = 75 align=center><input type="checkbox" name="list" value="10"</TD>
 <TD width = 75 align=center><input type="checkbox" name="list" value="11"</TD>
 <TD width = 75 align=center><input type="checkbox" name="list" value="12"</TD>
 </TR>
 
 <TR>
 <TH width=200>Outlet Master</TH>
 <TD width = 75 align=center><input type="checkbox" name="list" value="13"</TD>
 <TD width = 75 align=center><input type="checkbox" name="list" value="14"</TD>
 <TD width = 75 align=center><input type="checkbox" name="list" value="15"</TD>
 </TR>
 
 <TR>
 <TH width=150>Transactions</TH>
 <TD width = 75 align=center><input type="checkbox" name="list" value="16"</TD>
 <TD width = 75 align=center><input type="checkbox" name="list" value="17"</TD>
 <TD width = 75 align=center><input type="checkbox" name="list" value="18"</TD>
 </TR>
 </table>
 <BR>
 <BR>
  
    
  </FORM></body></HTML>

Do help me in this issue as early as possible. Eagerly waiting fr reply
thanks in advance
regards
kavitha

try out this,
request.getParametervalues("your checkbox name")
this will give you a string array of check box values that are selected. in your case 1,2,3, .... then do the processing based on the selected values.
Pradheep

Thanks for ur reply,
I need to tell u one more thing, i am new to both JSP and servlets. so i need to know where i should put the code u told i.e., in JSP page or in servlet or in script. I tried the same code in JSP with <% tags but it didnt work. So do tell me as to where i should put the code
thanks

in UserGrpCreationServlet.java
you can get all checkboxs' value as a array like this:
String[] checkbox = request.getParametervalues("list");

"Kavi" -

Welcome to the JavaRanch! We don't have many rules around the 'Ranch, but we do require your display name to follow the JavaRanch Naming Policy.
You can change it here.

Thanks! and welcome to the JavaRanch!

Hi Welsh,
I am able to trap the checked items in the servlet. Thanks a lot. Now how do i save these into the database. As i have already said i have 5 rows and each row has 3 columns with 1 check box in each column. Suppose the user clicks 1st row 2nd col, 2nd row 3rd adn 4th column, 5th row 1st, 2nd & 3rd columns. In the database also the rows stands for rows and 3 columns stands fr columns (fields). Can anyone advice me as to how to achieve at this. I want to store in the database as 1 fr check boxes clicked and in all other cases as 0.
In the database i want a format like this
------------------------------------------------
GrpName Moduleid aR eR dR
------------------------------------------------
S1 M1 1 0 0
S1 M2 0 1 1
S1 M3 1 1 1
S2 M1 0 0 1
S2 M2 1 0 1
S2 M3 1 0 1
..............
wherein ar, er, dr stands for colums as check boxes. When it is checked, 1 is stored otherwise 0. How od i write insert query fr that?
sorry