📄 gz_del.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
.style2 {color: #0000FF}
-->
</style>
<SCRIPT LANGUAGE="JavaScript">
<!-- Begin
var checkflag = "false";
function check(field) {
if (checkflag == "false") {
for (i = 0; i < field.length; i++) {
field[i].checked = true;}
checkflag = "true";
return "取消全选"; }
else {
for (i = 0; i < field.length; i++) {
field[i].checked = false; }
checkflag = "false";
return "再全选"; }
}
// End -->
</script>
</head>
<body>
<p>
<jsp:useBean id="conn" scope="page" class="beans3.conn"/>
<%
String page_type=(String)session.getAttribute("page_type");
String page_name=(String)session.getAttribute("page_name");
if(page_type==null){page_type="";}
if(session.isNew()){response.sendRedirect("../index.jsp");}
else
{ if(!(page_type.equals("super")) && !page_type.equals("sgz"))
{response.sendRedirect("../index.jsp");}
}
%>
<div align="center">
<p>现有临时人员列表</p>
<%
ResultSet rs=null;
int all=0;
String condition="SELECT * FROM BZGZ where GZ="+"0";
rs=conn.executeQuery(condition);
%>
<% while(rs.next())
{all++;}
rs=null;
%>
<%
condition="SELECT * FROM BZGZ where GZ="+"0";
rs=conn.executeQuery(condition);
%>
<form name="del" method="post" action="gz_del_result.jsp">
<table width="600" border="1" cellspacing="0" cellpadding="0">
<tr bgcolor="#CC99FF">
<th scope="col"><input type="checkbox" name="checkbox" value="全选"onClick="this.value=check(document.all.del)">全选</th>
<th scope="col">编号</th>
<th scope="col">部门</th>
<th scope="col">姓名</th>
<th scope="col">日工资</th>
<th scope="col">工天</th>
<th scope="col">进厂年月</th>
</tr>
<%
while(rs.next())
{all++;
String num=Integer.toString(all);%>
<tr>
<td><div align="center"><input type="checkbox" name="todel" id="del" value=<%=rs.getString("BH")%>></div></td>
<td><div align="center"><%=rs.getString("BH")%></div></td>
<td><div align="center"><%=rs.getString("BM")%></div></td>
<td><div align="center"><%=rs.getString("XM")%></div></td>
<td><div align="center"><%=rs.getString("RGZ")%></div></td>
<td><div align="center"><%=rs.getString("GT")%></div></td>
<td><div align="center"><%=rs.getString("JCNY")%></div></td>
</tr>
<%}%>
<%if(all==0){out.print("<tr bgcolor=#CCCCFF><td height=30 colspan=7><div align=center>当前无记录</div></td></tr> ");}%>
</table><p></p><input type="submit" name="Submit" value="删除"></form>
<p></p>
<p><span class="style2"><a href="../index/gz_index.jsp">返回主页</a></span></p>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -