Forum:

save checked value in checkbox to database

Greenhorn

Posts: 6

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Pradheep Thiruvengadam

Greenhorn

Posts: 7

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

barbie amr

Greenhorn

Posts: 6

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Welsh Ding

Greenhorn

Posts: 14

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Welsh<br />SCJP 1.4

Nathan Pruett

Bartender

Posts: 4121

I like...

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

"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!

-Nate
Write once, run anywhere, because there's nowhere to hide! - /. A.C.

barbie amr

Greenhorn

Posts: 6

posted 20 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

What are you saying? I thought you said that Santa gave you that. And this tiny ad:

We need your help - Coderanch server fundraiser

https://coderanch.com/wiki/782867/Coderanch-server-fundraiser