// JSP Page //
<%
while(resultSet.next()) {
int ab = ((Number) resultSet.getInt(3)).intValue();
%>
<tr>
<td><%= resultSet.getString(2) %></td>
<td>
<label class="switch1">
<input type="checkbox" onclick="check(<%= resultSet.getInt(1) %>)" name="mc_deactive<%= resultSet.getInt(1) %>" id="mc_deactive<%= resultSet.getInt(1) %>" <%= ab==1?"checked":"" %> >
<span class="slider round" title="Disabled"></span>
</label>
<script type="text/javascript">
function check(id)
{
if(document.getElementById("mc_deactive"+id).checked==true)
{
<%
int b = 0;
int ii = ((Number) resultSet.getInt(1)).intValue();
actDct.active(ii);
%>
}
else
{
int ii = ((Number) resultSet.getInt(1)).intValue();
actDct.deactive(ii);
}
}
</script>
</td>
<td>
<form method="post" action="m_m_c_edit.jsp?id=<%= resultSet.getInt(1) %>">
<button type="submit" class="btn btn-primary btn-sm col-xs-3">
<i class="fa fa-pencil"></i> ⁠ Edit
</button>
</form>
</td>
// Java Class //
public void active(int id)
{
int set = 1;
int i = id;
System.out.println(id);
dBConnection.openConnection();
String update = "update meal_category_master SET is_active = '1' WHERE meal_category_id = "+i;
int a = 0;
a = dBConnection.crud(update);
}
public void deactive(int id)
{
int d = 0;
int i = id;
dBConnection.openConnection();
String update = "update meal_category_master SET is_active = '0' WHERE meal_category_id = "+i;
int a = 0;
a = dBConnection.crud(update);
dBConnection.closeConnection();
}
我有一个设计为开关的复选框。每当加载 jsp 页面时,我想选中复选框,如果数据库的"活动"列的值为 1,并取消选中值是否为 0。另一个我还希望在每次选中该复选框时都应在该特定行的数据库活动列中插入 1,在取消选中复选框时插入 0
。我写了一些代码,如下所示。它更新活动列的值,但不是单行,而是更新所有行的值
您可以添加 Ajax 调用 onChange evenet of 复选框。
复选框记下 ajax 调用以在 updateCheckboxStatus 函数中更新 DB 值。