📄 rs_del_shgx.jsp

📁 JSP页面和oracle9i数据库的源代码
💻 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/0989.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/shgx_entry_menu.jsp"></jsp:include>
<%@ page import="java.util.Calendar"%>
<%@ page import="java.text.*"%>
<%	String meb=response.encodeURL("rs_del_shgx.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)
		{out.print("<center>出现职工编号重复错误！请予管理员联系！</center>");}
		else
		{	if(all_all==0){if(bh.equals("")){out.print("<center>您还没有输入编号,请输入！</center>");}else{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 gxxm=request.getParameter("gxxm"+Integer.toString(k));
				String ybrgx=request.getParameter("ybrgx"+Integer.toString(k));
				String zzmm=request.getParameter("zzmm"+Integer.toString(k));
				String gzdw=request.getParameter("gzdw"+Integer.toString(k));
				String zwgz=request.getParameter("zwgz"+Integer.toString(k));
				String bz=request.getParameter("bz"+Integer.toString(k));
				String del_shgx="DELETE FROM shgx where BH='"+bh+"' and GXXM='"+gxxm+"' and YBRGX='"+ybrgx+"' and ZZMM='"+zzmm+"' and GZDW='"+gzdw+"' and ZWGZ='"+zwgz+"'and BZ='"+bz+"'";
				conn.setcondition(del_shgx);
				del_shgx=conn.toChinese();
				conn.setcondition(del_shgx);
				String del_ok_no=conn.update();
			}
		}
		String condition="SELECT * FROM shgx 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>
			 <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("GXXM")%>
			   <input name="gxxm<%=num%>" type="hidden" id="cyxm" value="<%=rs.getString("GXXM")%>">
			 </div></td>
			 <td nowrap><div align="left"><%=rs.getString("YBRGX")%>
			   <input name="ybrgx<%=num%>" type="hidden" id="jsgx" value="<%=rs.getString("YBRGX")%>">
			 </div></td>
			 <td nowrap><div align="left"><%=rs.getString("ZZMM")%>
			   <input name="zzmm<%=num%>" type="hidden" id="zzmm" value="<%=rs.getString("ZZMM")%>">
			 </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("ZWGZ")%>
			   <input name="zwgz<%=num%>" type="hidden" id="zwgz" value="<%=rs.getString("ZWGZ")%>">
			 </div></td>
			 <td nowrap><textarea name="bz_show" cols="10" rows="1" wrap="VIRTUAL" id="bz_show"><%=rs.getString("BZ")%></textarea>
			   <input name="bz<%=num%>" type="hidden" id="bz<%=num%>" value="<%=rs.getString("BZ")%>">			   <div align="left">
			 </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="5">
               <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=4><div align="center">
               <input type="reset" name="Submit2" value="重置">
             </div></td>
           </tr>
         </table>
		</form>
<%	}%>
</div>
<%}%>
<jsp:include page="../checkout.jsp"></jsp:include>
</body>
</html>
💿 文件大小 6504 K
👤 上传用户 liu2000dz
📂 所属分类 Oracle数据库
🏷️ 相关标签

#oracle9i #JSP #页 #数据库
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -