求助 考勤表单多条记录如何插入到数据库 并进行修改 删除 数据库表该如何设计

Question

我已经可以提出部门 和人员 并自动生成七种请假类型 
用户只需要点响应的单选按扭就可以 但是我下一步该怎么存呢

Answer 1

<!--考勤表单 start -->
<center>
<table class="Liste" border="0" cellspacing="1" cellpadding="0"
width="96%" align="center" name="ListTable">
<tr class="LHeader" align="center">
<td class=LHeader noWrap width="10%" align="center">&nbsp;员工</td>
<td class=LHeader noWrap width="10%"align="center">&nbsp;正常出勤</td>
<td class=LHeader noWrap width="10%"align="center">&nbsp;病假</td>
<td class=LHeader noWrap width="10%"align="center">&nbsp;产假</td>
<td class=LHeader noWrap width="10%"align="center">&nbsp;探亲</td>
<td class=LHeader noWrap width="10%"align="center">&nbsp;事假</td>
<td class=LHeader noWrap width="10%"align="center">&nbsp;矿工</td>
<td class=LHeader noWrap width="10%"align="center">&nbsp;早退</td>
<td class=LHeader noWrap width="10%"align="center">&nbsp;迟到</td>
<td class=LHeader noWrap width="10%"align="center">&nbsp;部门</td>
</tr>
<%if (listName != null && listName.size() != 0) {
int i = 0;
int num = 0;
for (Iterator iter = listName.iterator(); iter.hasNext();) {
KqglForm kqglForm = (KqglForm) iter.next();
          if (num % 2 == 0) {
    %>
 <tr align="center" class="LUngerade">
    <input type=hidden id="qjlx_<%=i%>" name="qjlx" value="<%=kqglForm.getUserid()%>_zccq_<%=kqglForm.getDeptid()%>">
    <td class="LUngerade" nowrap align="center"><%=kqglForm.getUsername()%>&nbsp;</td>
<td class="LUngerade" noWrap align="center">
<input type=radio name=<%=kqglForm.getUserid()%> value=<%=kqglForm.getUserid()%>_zccq_<%=kqglForm.getDeptid()%> checked  onclick="optClick('<%=kqglForm.getUserid()%>_zccq_<%=kqglForm.getDeptid()%>',<%=i%>)"></td>
    <td class="LUngerade" nowrap align="center"> 
<input type=radio name=<%=kqglForm.getUserid()%> value=<%=kqglForm.getUserid()%>_bj_<%=kqglForm.getDeptid()%>    onclick="optClick('<%=kqglForm.getUserid()%>_bj_<%=kqglForm.getDeptid()%>',<%=i%>)"></td>
<td class="LUngerade" noWrap align="center"> 
<input type=radio name=<%=kqglForm.getUserid()%> value=<%=kqglForm.getUserid()%>_cj_<%=kqglForm.getDeptid()%>     onclick="optClick('<%=kqglForm.getUserid()%>_cj_<%=kqglForm.getDeptid()%>',<%=i%>)"></td>
    <td class="LUngerade" nowrap align="center"> 
<input type=radio name=<%=kqglForm.getUserid()%> value=<%=kqglForm.getUserid()%>_tq_<%=kqglForm.getDeptid()%>     onclick="optClick('<%=kqglForm.getUserid()%>_tq_<%=kqglForm.getDeptid()%>',<%=i%>)"></td>
<td class="LUngerade" noWrap align="center"> 
<input type=radio name=<%=kqglForm.getUserid()%> value=<%=kqglForm.getUserid()%>_sj_<%=kqglForm.getDeptid()%>    onclick="optClick('<%=kqglForm.getUserid()%>_sj_<%=kqglForm.getDeptid()%>',<%=i%>)"></td>
    <td class="LUngerade" nowrap align="center"> 
<input type=radio name=<%=kqglForm.getUserid()%> value=<%=kqglForm.getUserid()%>_kg_<%=kqglForm.getDeptid()%>     onclick="optClick('<%=kqglForm.getUserid()%>_kg_<%=kqglForm.getDeptid()%>',<%=i%>)" ></td>
<td class="LUngerade" noWrap align="center"> 
<input type=radio name=<%=kqglForm.getUserid()%> value=<%=kqglForm.getUserid()%>_zt_<%=kqglForm.getDeptid()%>     onclick="optClick('<%=kqglForm.getUserid()%>_zt_<%=kqglForm.getDeptid()%>',<%=i%>)"></td>
    <td class="LUngerade" nowrap align="center"> 
<input type=radio name=<%=kqglForm.getUserid()%> value=<%=kqglForm.getUserid()%>_cd_<%=kqglForm.getDeptid()%>    onclick="optClick('<%=kqglForm.getUserid()%>_cd_<%=kqglForm.getDeptid()%>',<%=i%>)"></td>
<td class="LUngerade" noWrap align="center"><%=kqglForm.getDeptname()%>&nbsp;</td>     
</tr>
<%
} 
else {
%>
<tr align="center" class="LGerade">
   <input type=hidden id="qjlx_<%=i%>" name="qjlx>" value="<%=kqglForm.getUserid()%>_zccq_<%=kqglForm.getDeptid()%>">
    <td class="LUngerade" nowrap align="center"><%=kqglForm.getUsername()%>&nbsp;</td>
<td class="LUngerade" noWrap align="center">
<input type=radio name=<%=kqglForm.getUserid()%> value=<%=kqglForm.getUserid()%>_zccq_<%=kqglForm.getDeptid()%> checked  onclick="optClick('<%=kqglForm.getUserid()%>_zccq_<%=kqglForm.getDeptid()%>',<%=i%>)"></td>
    <td class="LUngerade" nowrap align="center"> 
<input type=radio name=<%=kqglForm.getUserid()%> value=<%=kqglForm.getUserid()%>_bj_<%=kqglForm.getDeptid()%>    onclick="optClick('<%=kqglForm.getUserid()%>_bj_<%=kqglForm.getDeptid()%>',<%=i%>)"></td>
<td class="LUngerade" noWrap align="center"> 
<input type=radio name=<%=kqglForm.getUserid()%> value=<%=kqglForm.getUserid()%>_cj_<%=kqglForm.getDeptid()%>     onclick="optClick('<%=kqglForm.getUserid()%>_cj_<%=kqglForm.getDeptid()%>',<%=i%>)"></td>
    <td class="LUngerade" nowrap align="center"> 
<input type=radio name=<%=kqglForm.getUserid()%> value=<%=kqglForm.getUserid()%>_tq_<%=kqglForm.getDeptid()%>     onclick="optClick('<%=kqglForm.getUserid()%>_tq_<%=kqglForm.getDeptid()%>',<%=i%>)"></td>
<td class="LUngerade" noWrap align="center"> 
<input type=radio name=<%=kqglForm.getUserid()%> value=<%=kqglForm.getUserid()%>_sj_<%=kqglForm.getDeptid()%>    onclick="optClick('<%=kqglForm.getUserid()%>_sj_<%=kqglForm.getDeptid()%>',<%=i%>)"></td>
    <td class="LUngerade" nowrap align="center"> 
<input type=radio name=<%=kqglForm.getUserid()%> value=<%=kqglForm.getUserid()%>_kg_<%=kqglForm.getDeptid()%>     onclick="optClick('<%=kqglForm.getUserid()%>_kg_<%=kqglForm.getDeptid()%>',<%=i%>)" ></td>
<td class="LUngerade" noWrap align="center"> 
<input type=radio name=<%=kqglForm.getUserid()%> value=<%=kqglForm.getUserid()%>_zt_<%=kqglForm.getDeptid()%>     onclick="optClick('<%=kqglForm.getUserid()%>_zt_<%=kqglForm.getDeptid()%>',<%=i%>)"></td>
    <td class="LUngerade" nowrap align="center"> 
<input type=radio name=<%=kqglForm.getUserid()%> value=<%=kqglForm.getUserid()%>_cd_<%=kqglForm.getDeptid()%>    onclick="optClick('<%=kqglForm.getUserid()%>_cd_<%=kqglForm.getDeptid()%>',<%=i%>)"></td>
<td class="LUngerade" noWrap align="center"><%=kqglForm.getDeptname()%>&nbsp;</td> </tr> <%
}
num++;
i = i + 1;
}
} %>
<tr>
<td>&nbsp;&nbsp;
</td>
</td>
 
 <tr>
<td width="30">&nbsp;</td>
<td width="*" colspan=7 align=center > <BUTTON onmouseover="this.className='button_on'"
onclick="formVerify();"
onmouseout="this.className='button';this.blur()" class="button">确
定</BUTTON>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  
<BUTTON onmouseover="this.className='button_on'"
onclick="doReset();"
onmouseout="this.className='button';this.blur()" class="button">重
置</BUTTON>
&nbsp;</td>
</tr>
</table>
</center>