String array
I declared an arraystatus[] to keep my radio button values. But it seem like those codes does not work. Please help me!
<form action="controller.jsp" method="post">
<TABLE BORDER="1" width ="250" cellspacing="0" cellpadding ="2" align ="center">
<TR><TH colspan="2">Living Room</TH></tr>
<tr><TH align="center">Device</TH> <TH align="center">Status</tH></tr>
<%
String query ="SELECT * FROM device where locationID='"+0+"' order by device_name";
dbselect.rs = dbselect.executeQuery(query);
int i=0;
while ( (dbselect.rs).next() ){
String device = dbselect.rs.getString("device_name");
String status = dbselect.rs.getString("status");
String check1 ="";
String check2 ="";
if(status.equalsIgnoreCase("ON")){
check1="checked";
}
if(status.equalsIgnoreCase("OFF")){
check2="checked";
}
%>
<tr><TD><%= device %>
<input type="hidden" name="device<%= i%>" value="<%=device%>">
</TD>
<TD align="center">
<input type="hidden" name="status<%= i%>" value="<%= status%>">
<input type="radio" name="button<%= i%>" value="ON" ><%=check1%> >0n
<input type="radio" name="button<%=i%>" value="OFF" ><%=check2%> >Off
</TD>
</TR>
<%
i++
}// end while loop
%>
</table>
<center>
<input type="submit" name="ChangeStatus" value="Save Change">
<input type="Reset" name="Reset" value="Don't Save">
</center>
</form>
</div>
<% String change= request.getParameter("ChangeStatus");
String [] status=new String[i];
if (change!=null)
{
out.println("Save change has click\n");
for (int n=0; n<i; n++){
status[n] = request.getParameter("button<%= n%>");
String queryUp ="UPDATE device order by device_name SET status = '"+status[n]+"' WHERE locationID='"+0+"' ";
dbselect.rs = dbselect.executeQuery(queryUp);
}// end for
}// end if 1
%>
