📄 del_shgx.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}
.style3 {
font-size: medium;
font-weight: bold;
}
-->
</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>
<%@ include file="/commond/conn.jsp"%>
<div align="center">
<p class="style3">社会关系列表</p>
<%
int all=0;
sql=con.createStatement();
String condition="SELECT * FROM shgx";
rs=sql.executeQuery(condition);
%>
<% while(rs.next())
{all++;}
rs=null;
%>
<%
sql=con.createStatement();
condition="SELECT * FROM shgx";
rs=sql.executeQuery(condition);
%>
<form name="del" method="post" action="../shgx/shgx_del_result.jsp?all=<%=all%>">
<table width="600" border="1" cellspacing="0" cellpadding="0">
<tr bgcolor="#FF0000">
<th nowrap scope="col"><div align="center">
<input type="checkbox" name="checkbox" value="全选"onClick="this.value=check(document.all.del)">
全选</div></th>
<th nowrap scope="col">编号</th>
<th nowrap scope="col">部门</th>
<th nowrap scope="col">姓名</th>
<th nowrap scope="col">关系姓名</th>
<th nowrap scope="col">本人关系</th>
<th nowrap scope="col">政治面貌</th>
<th nowrap scope="col">工作单位</th>
<th nowrap scope="col">职务工种</th>
<th nowrap scope="col">备注</th>
</tr>
<%
while(rs.next())
{all++;
String num=Integer.toString(all);%>
<tr>
<td><div align="center"><input type="checkbox" name=<%=num%> id="del" value=<%=rs.getString("BH")%>></div></td>
<td nowrap><div align="center"><%=rs.getString("BH")%></div></td>
<td nowrap><div align="center"><%=rs.getString("BM")%></div></td>
<td nowrap><div align="center"><%=rs.getString("XM")%></div></td>
<td nowrap><div align="center"><%=rs.getString("GXXM")%></div></td>
<td nowrap><div align="center"><%=rs.getString("YBRGX")%></div></td>
<td nowrap><div align="center"><%=rs.getString("ZZMM")%></div></td>
<td nowrap><div align="center"><%=rs.getString("GZDW")%></div></td>
<td nowrap><div align="center"><%=rs.getString("ZWGZ")%></div></td>
<td nowrap><div align="center"><%=rs.getString("BZ")%></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><span class="style2"><a href="../index/shgx_entry_menu.jsp">返回</a></span></p>
</div>
<jsp:include page="../checkout.jsp"></jsp:include>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -