<table width="90%" class="rpttable">
<thead>
<p> <td align="right">
<caption align=top><width="70">客戶:<%=infoRs.getString("CUSTOMER_ID"%></caption>

</thead>
<tr> <th></th><th>客戶批號:</th> <th> 數量:</th> <th>生產類型:</th><th> 創建時間:</th><th>作業員:</th></TR>

<TR>
<td><input type=checkbox name=w ></td>
<td> <%=infoRs.getString("CUST_WAFERLOT_ID"%></td>
<td> <%=infoRs.getString("QUANTITY"%></td>
<td> <%=infoRs.getString("PRODUCT_ID"%></td>
<td> <%=infoRs.getString("C_DATETIME"%></td>
<td> <%=infoRs.getString("USERNAME"%></td>
</tr>
<tbody>

<% out.println(infoRs.size());
while (infoRs.next()){
out.println("<tr>";
out.println("<td><input type=checkbox name=w ></td>";
out.println("<td>"+infoRs.getString("CUST_WAFERLOT_ID"+"</td>";
out.println("<td>"+infoRs.getString("QUANTITY"+"</td>";
out.println("<td>"+infoRs.getString("PRODUCT_ID"+"</td>";
out.println("<td>"+infoRs.getString("C_DATETIME"+"</td>";
out.println("<td>"+infoRs.getString("USERNAME"+"</td>";

out.println("</tr>";
}
infoRs.close();%>
</tbody>

</table>
<%
}else{
out.println("No Data be Found.";
}
infoRs.close();
}else{
out.println("&nbsp;";
}
%>

<table>
<%

if(checkbox!=null)
{
CachedRowSetImpl infoRs = DateQueryNew.delete(request.getParameter("customer_id".trim());
}


%>
<br>
<input type="delete" name="delete" value="刪除">
</br>

用Request.Form方法得到的CheckBox的ID号这一字符串，形式为"12,18,20,30"

sql = "DELETE FROM Table1 WHERE ID IN (" & Reqeust.Form("ID") & ")"