📄 rs_del_grjl.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;
}
body {
background-image: url(../img/BK060.GIF);
}
-->
</style>
<%
String page_type=(String)session.getAttribute("page_type");
String page_name=(String)session.getAttribute("page_name");
if(page_type==null){page_type="";}
boolean page_ok=false;
if(session.isNew()){response.sendRedirect("../index.jsp");}
else
{ if(!page_type.equals("srs"))
{response.sendRedirect("../index.jsp");}
else
{ page_ok=true;
}
}
%>
<SCRIPT LANGUAGE="JavaScript">
<!-- Begin
function check_bh()
{ var true_false=true;
if(document.intobh.bh.value=="")
{ alert("请填写'所要修改家庭成员信息的职工编号！'");
true_false=false;
}
return true_false;
}
function del_check()
{ if(confirm("删除后数据将无法恢复，您真的确定删除吗？")==true)
{ return true;}
else
{ return false;}
}
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>
<title>删除个人简历</title></head>
<body>
<%if(page_ok==true){%>
<jsp:useBean id="conn" scope="page" class="beans.conn"/>
<jsp:include page="../index/grjl_entry_menu.jsp"></jsp:include>
<%@ page import="java.util.Calendar"%>
<%@ page import="java.text.*"%>
<% String meb=response.encodeURL("rs_del_grjl.jsp");%>
<div align="center"><span class="style11">删除个人简历页面</span>
<% ResultSet rs_all=null;
String bh=request.getParameter("bh");
int all_all=0;
if(bh==null){bh="";}
else
{ String condition_bh="select * from zgxx where bh='"+bh+"'";
conn.setcondition(condition_bh);
ResultSet rs_zgxx=conn.getrs();
rs_zgxx.last();
int all_zgxx=rs_zgxx.getRow();
condition_bh="select * from txzgxx where bh='"+bh+"'";
conn.setcondition(condition_bh);
ResultSet rs_txzgxx=conn.getrs();
rs_txzgxx.last();
int all_txzgxx=rs_txzgxx.getRow();
all_all=all_zgxx+all_txzgxx;
if(all_all>1)
{if(bh.equals("")){out.print("<center>您还没有输入编号,请输入！</center>");}else{out.print("<center>出现职工编号重复错误！请予管理员联系！</center>");}}
else
{ if(all_all==0){out.print("<center>没有编号为"+bh+"的职工,请重新填写</center>");}
if(all_all==1)
{ if(all_zgxx==1){rs_all=rs_zgxx;}
if(all_txzgxx==1){rs_all=rs_txzgxx;}
}
}
}
if(bh.equals("")||all_all!=1)
{
%>
<form action="<%=meb%>" method="post" name="intobh" id="intobh" onSubmit="return check_bh()">
<div align="center">请填写所要删除'个人简历'的'职工'的编号
<input name="bh" type="text" id="bh" style=" BACKGROUND-COLOR: rgb(255,255,255); BORDER-BOTTOM: rgb(80,139,220) 1px solid; BORDER-LEFT: rgb(80,139,220) 1px solid; BORDER-RIGHT: rgb(80,139,220) 1px solid; BORDER-TOP: rgb(80,139,220) 1px solid" size="15" maxlength="15">
<input type="submit" name="Submit3" value="确定">
</div></form>
<% }
else
{ String all_old_s=request.getParameter("all");
if(all_old_s==null){all_old_s="0";}
int all_old=Integer.parseInt(all_old_s);
for(int k=1;k<=all_old;k++)
{ String checkbox=request.getParameter(Integer.toString(k));
if(checkbox!=null)
{ String gzdw=request.getParameter("gzdw"+Integer.toString(k));
String zmr=request.getParameter("zmr"+Integer.toString(k));
String qzny=request.getParameter("qzny"+Integer.toString(k));
String del_grjl="DELETE FROM grjl where BH='"+bh+"' and QZNY='"+qzny+"' and GZDW='"+gzdw+"'";
conn.setcondition(del_grjl);
del_grjl=conn.toChinese();
conn.setcondition(del_grjl);
String del_ok_no=conn.update();
}
}
String condition="SELECT * FROM grjl where bh='"+bh+"'";
conn.setcondition(condition);
ResultSet rs=conn.getrs();
rs.last();
int all=rs.getRow();
rs.beforeFirst();
%>
<form name="del" method="post" action="<%=meb%>?all=<%=all%>" onSubmit="return del_check()">
<table border="1" cellspacing="0" cellpadding="0">
<tr bgcolor="#FF99CC">
<th nowrap scope="col"><div align="left">
<input type="checkbox" name="checkbox" value="全选"onClick="this.value=check(document.all.del)">
全选</div></th>
<th nowrap scope="col"><div align="left">编号</div></th>
<th nowrap scope="col">姓名</th>
<th nowrap scope="col"><div align="left">起止年月</div></th>
<th nowrap scope="col"><div align="left">曾工作单位</div></th>
<th nowrap scope="col"><div align="left">证明人</div></th>
</tr>
<%
all=0;
while(rs.next())
{all++;
String num=Integer.toString(all);%>
<tr>
<td nowrap>
<div align="center">
<input type="checkbox" name=<%=num%> id="del" value=<%=rs.getString("BH")%>>
</div></td>
<td nowrap><div align="left"><%=rs.getString("BH")%>
<input name="bh" type="hidden" id="bh" value="<%=rs.getString("BH")%>">
</div></td>
<td nowrap><%=rs_all.getString("XM")%></td>
<td nowrap><div align="left"><%=rs.getString("QZNY")%>
<input name="qzny<%=num%>" type="hidden" id="jsgx" value="<%=rs.getString("QZNY")%>">
</div></td>
<td nowrap><div align="left"><%=rs.getString("GZDW")%>
<input name="gzdw<%=num%>" type="hidden" id="gzdw" value="<%=rs.getString("GZDW")%>">
</div></td>
<td nowrap><div align="left"><%=rs.getString("ZMR")%>
</div></td>
</tr>
<%}%>
<%if(all==0){out.print("<tr bgcolor=#CCCCFF><td height=30 colspan=13><div align=center>无"+bh+"号"+rs_all.getString("XM")+"的个人简历记录</div></td></tr> ");}%>
<tr>
<td colspan="4">
<div align="center">
<input type="submit" name="Submit" value="删除">
</div>
<div align="center"></div> <div align="center"></div> <div align="center"></div> <div align="center"></div> <div align="center"></div> <div align="center"></div></td>
<td colspan=2><div align="center">
<input type="reset" name="Submit2" value="重置">
</div></td>
</tr>
</table>
</form>
<% }%>
</div>
<%}%>
<jsp:include page="../checkout.jsp"></jsp:include>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -