📄 delduty1.jsp

📁 “JSP数据库项目案例导航”一书从第一章到第十一章各章实例的源程序文件以及数据库文件。注意： 1. 本书中的案例提供的数据库环境不同
💻 JSP
字号:
<%
/**********************************************************
Copyright (C),2003-10-12, Beijing  USTB.
All rights reserved.
Filename: sample.jsp
Author:    
Version 1.0
Date:2003-10-12
Description://详细说明此程序文件完成的基本功能，与其他模块的或函数的接口、输出值、取值范围、含义及参数间的控制、顺序、独立或依赖等关系
Other://其它内容说明
Function List://主要方法列表
1.  ...
History://修改历史纪录表,包括修改日期、修改者、修改内容简述
1.  Date:
    Author:
    Modification:
2.  ...
***********************************************************/
%>
<%@page language="java" contentType="text/html;charset=GBK"%>
<%@page import="java.util.*,java.text.*,oa.main.DealString,javax.swing.tree.DefaultMutableTreeNode,java.util.Hashtable"%>

<html>

<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<title>删除个人职务</title>
<link href="../css/person.css" type=text/css rel=stylesheet>
<script language="javascript" src="../scripts/department.js"></script>
</head>
<%
oa.bean.PersonDutyBean myBean = null;
try{
	myBean = new oa.bean.PersonDutyBean();

	if(myBean.getConn()==null)
	{
		%>		
		数据库无法响应,请<a href="javascript:window.history.back(-1);">返回</a>重试
		<%out.close();
	}
DealString ds = new DealString();
//组织机构编号
String strOrgNO = ds.toString((String)request.getParameter("txt_orgno"));
//取得当前人员编号
String strPersonNo = ds.toString((String)request.getParameter("txt_personno"));

%>

<body bgcolor= "#F6FEE8">
<form name="form1" method=post>
<style type=text/css>
.HAND
{CURSOR:hand}

</style>
<TABLE WIDTH="98%" BORDER=0 CELLSPACING=0 CELLPADDING=0 ALIGN=center style="table-layout:fixed;word-break:break-all">
<tr><td>
	<input type="submit" name="subbtn" value="确定" class=fashion onmouseover="msover();" onmouseout="msout();" onclick="return onsure();"> 
	<input type="button" name="btcancel" value="取消" class=fashion onmouseover="msover();" onmouseout="msout();" onclick="self.close()"> 
</td></tr></table>
<hr size="4" noshade color="orange"></hr>

<TABLE WIDTH="98%" BORDER=0 CELLSPACING=1 CELLPADDING=0 ALIGN=center bgcolor="#ffffff">
  <col width="55%"><col width="45%">
  <TR CLASS=p9 valign=middle>
    <TD ALIGN=center BGCOLOR=#70A6FF nowrap height=20>
      <FONT COLOR=#993300 >&nbsp;请选择所要删除的职务</FONT>
    </TD>
  </TR>
</TABLE>
	<TABLE WIDTH="98%" BORDER=0 CELLSPACING=0 CELLPADDING=0 ALIGN=center bgcolor="#ffffff">
<%
Vector vt = myBean.getData(strPersonNo);

for(int i=0;i<vt.size();i++)
{
	Hashtable ht = (Hashtable)vt.get(i);
	String bmbh = (String)ht.get("BMBH");
	String zwbh = (String)ht.get("ZWBH");

	myBean.setDutyOrgNo(bmbh);
	String zwmc = myBean.getDutyName(zwbh);
	String bmMC = myBean.getOrgName(bmbh);
%>
		<tr>
			<td height=18 width="35%">&nbsp;</td>
			<td height=18 align="left">&nbsp;
		  	<input type="checkbox" id="chkbox" name="chkbox" value="<%=bmbh%>-<%=zwbh%>"style="color: #66FF66;border-style: double; border-color: #6699FF" ><%=bmMC%>:<%=zwmc%>
			</td>
			<td height=18 >&nbsp;</td>
		</tr>

<%
}
	//String []chkval = request.getParameterValues("chkbox");
%>
	</table>
<TABLE WIDTH="98%" BORDER=0 CELLSPACING=0 CELLPADDING=0 ALIGN=center bgcolor="#ffffff">
  <TR CLASS=p9 valign=middle>
    <TD ALIGN=center BGCOLOR=#70A6FF nowrap height=20 ></TD>
  </TR>
</TABLE>


</form>
</body>
</html>
<script>
	function onsure()//选择部门
	{
<%
	String []chkval = request.getParameterValues("chkbox");
%>
		if(!confirm("确定要删除此职务吗？"))
		{return false;}
<%
		String []nums = null;
		String bmno = "";
		String zwno = "";

		if(chkval!=null){
			for(int j=0;j<chkval.length;j++)
			{
				nums = chkval[j].split("-");
				bmno = nums[0];
				zwno = nums[1];
				
				myBean.delRec(strPersonNo,bmno,zwno);	
			}
		}
%>
		window.close();
		parent.opener.form1.submit();
		return true;
	}

</script>

<%}finally{
	if(myBean!=null)myBean.closeConn();
}
%>
⌨️ 快捷键说明

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