want to ask how to update data for runtime selected multiple checkboxes

HI I have one problem I have fetched value from oracle database into grid and created runtime textboxes in the grid for the column geocoordsN,GeocoordsE I have checkboxes for each record when I will select more than one checkboxex and entered the values in the textbox then it should get update in the database.I have succesfully updated when I am clickinga single checkbox but I want to update for more than One checkbox here is my code.

<%@ page language="java" import="java.sql.*;" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<script language="javascript">
var rowNumber;
function check23(abc)
{
/*     alert(document.getElementById("textbox1").value);
    document.getElementById("textbox1").value= abc;
    alert(document.getElementById("textbox1").value);
    document.getElementById("textbox2").value=document.getElementById("textbox1").value; */
}

function getSelected(row)
{
    rowNumber = row;
    alert(rowNumber);

}
function getVal()
{
    alert(rowNumber);
    document.getElementById("coords1").value = document.getElementById("coordsN"+rowNumber).value;
    document.getElementById("coords2").value = document.getElementById("coordsE"+rowNumber).value;
    alert( document.getElementById("coords1").value);
    alert( document.getElementById("coords2").value);
}

function selectCheckBox()
{
    alert('hi');

  var e= f1.elements.length;

 alert(e);
  var cnt=0;

var j=0;



var name=new Array();
var values=new Array();
alert("array declared");
  for(cnt=0;cnt<e;cnt++)
  {
    if(f1.elements[cnt].name=="test"){
     alert(f1.elements[cnt].value);
//alert("enter");  
if(f1.elements[cnt].checked==true){
    values[j]=f1.elements[cnt].value;
    alert('getting....:'+cnt+': e: '+e);
    alert("gggg="+values[j]);
    j++;


  }

    }


  }

}


</script>
</head>
<body text="Red" bgcolor="#CC99FF">
<h1>SARDA FARMS DISTRIBUTION</h1>
<HR></HR>
<H2>ROUTE ASSIGNMENTS TO NON-ROUTES CUSTOMERS</H2>
<H3>LIST OF CUSTOMERS-ADDRESS TO BE CONFIRMED</H3>

<input type='hidden' name ='hh' value="<%=request.getParameter("textbox1") %>" >






</body>
</html>
<%  Connection conn=null;
Statement ps=null;

String stdate1,enddate1;

try
{


 String r="";
 String option1;
 String driver = "oracle.jdbc.driver.OracleDriver";
 String url = "jdbc:oracle:thin:@10.0.0.7:1521:CRM";
 String username = "SFCRM";
 String password = "SFCRM";

  Class.forName(driver);
  conn = DriverManager.getConnection(url, username, password);
  String qry="select Profile_Id,Profile_Name,Address_Line1,Address_Line2,Landmark,Geo_Coords_N,Geo_Coords_E from CRM_PROFILE";
  ps = conn.createStatement();
 ResultSet  rs=ps.executeQuery(qry);
 out.println("<html><body>");
 out.println("<form action='transfer.jsp' id='f1'  method='post' >");
 out.println("<table Id=dataTable border=1  bordercolor=#8080cc bordercolorlight=#8080c0 bordercolordark=#400080 bgcolor='#CCFFFF'>");
 out.println("<tr><th>select</th><th>Profile_Id</th><th>Profile_Name</th><th>Address_Line1</th><th>Addres_Line2</th><th>Landmark</th><th>Geo_Coords_N</th><th>Geo_Coords_E</th><tr>");
 System.out.println("enter");
 int i=1;
 while(rs.next())
  { 
  r=rs.getString(1);
  String pname=rs.getString(2);
  String add1=rs.getString(3);
  String add2=rs.getString(4);
  String land=rs.getString(5);

               //out.println("<tr><td>"+"<input type='checkbox' id='r1' value="+r+" name='test'>"+"</td><td>"+r+"</td><td>"+pname+"</td><td>"+add1+"</td><td>"+add2+"</td><td>"+land+"</td>");
               //out.println("<tr><td>"+"<input type='checkbox' id='r1' value="+r+" name='test' onclick='check23(this.value);'>"+"</td><td>"+r+"</td><td>"+pname+"</td><td>"+add1+"</td><td>"+add2+"</td><td>"+land+"</td>");
               //out.println("<tr><td>"+"<input type='checkbox' id='r1' value="+r+" name='test' onclick='getSelected("+i+")'>"+"</td><td>"+r+"</td><td>"+pname+"</td><td>"+add1+"</td><td>"+add2+"</td><td>"+land+"</td>");
  out.println("<tr><td>"+"<input type='checkbox' id='r1' value="+r+" name='test' onclick='getSelected("+i+");selectCheckBox();'>"+"</td><td>"+r+"</td><td>"+pname+"</td><td>"+add1+"</td><td>"+add2+"</td><td>"+land+"</td>");

               /* out.println("<td><input type = 'text' name='coords1' id='coords1'></td>"); */
               /* out.println("<td><input type = 'text' name='coords2' id='coords2"+i+"'></td>"); */

 out.println("<td><input type = 'text' name='coordsN' id='coordsN"+i+"'></td>");
 out.println("<td><input type = 'text' name='coordsE' id='coordsE"+i+"'></td>");

 out.println("<td><input type = 'hidden' name='coords1' id='coords1'></td>");
 out.println("<td><input type = 'hidden' name='coords2' id='coords2'></td>");
               //out.println("<td><input type = 'checkbox' name='check' id='check"+j+"' onclick='checknum("+j+")'></td>");

 out.println("</tr>");
 i++;

 }
 out.println("<tr><td><input type='submit' id=b1 value='submit' onclick='getVal();selectCheckBox();'></input></td></tr>");
          // out.println("<input type='text' id='textbox1' name ='textbox1'/>");

 out.println("</table>");
 out.println("</form>");
}
catch (Exception e) {
out.println("error");
}
           %>

View Answers

January 25, 2013 at 7:20 PM

hi, friend you can add an input hidden field that should return the row numbers as follows :

out.println("<td><input type = 'hidden' name='row' id='row' value="+i+"></td>");

try this snippet code in transfer.jsp page this may helpful for you.

<%@ page language="java" import="java.sql.*;"
contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
</head>
<body>

</body>
</html>
<%
Connection conn=null;
PreparedStatement ps=null;
String coords1[] = request.getParameterValues("coordsN");
String coords2[] = request.getParameterValues("coordsE");
String rw[] = request.getParameterValues("row");
int row=0;
int i=0;
try
{
//String r ="";
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/record";
String username = "root";
String password = "root";

Class.forName(driver);
conn = DriverManager.getConnection(url, username, password);
String qry="update crm_profile set Geo_Coords_N=?,Geo_Coords_E=? where Profile_Id=?";
String query = "select Profile_Id from crm_profile";
ps= conn.prepareStatement(query);
ResultSet rs = ps.executeQuery();
while(rs.next())
{
String id = (String)(rs.getString("Profile_Id"));
int pid = Integer.parseInt(id);
System.out.println(pid);
for(int r=0; r<rw.length; r++)
{
row = Integer.parseInt(rw[r]);
if(row == pid)
{
ps = conn.prepareStatement(qry);
ps.setString(1,coords1[r]);
ps.setString(2,coords2[r]);
ps.setInt(3,row);
i = ps.executeUpdate();
}
}
}

if(i>0)
{
out.println("value updated successfully");
}
}
catch (Exception e) {
e.printStackTrace();
}
%>