⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 updatedepart.jsp

📁 此程序为纯jsp实现通讯录功能
💻 JSP
字号:
🔍 
<%@ page language="java" import="java.util.*"%>
<%@ page  import="java.sql.*,java.util.*,java.io.*" %>
<%@ include file="conn.jsp"%>
<%@ include file="util.jsp"%>
  <%	
		final String unit = "unit";
		final String department = "dep";
		String id=(String)request.getParameter("id");	
		if(id==null){
			id="";
		}
				String sql="select t1.org_no code,t1.org_id depart_id, t1.org_name depart_name, t2.org_id unit_id, t2.org_name unit_name from txl_org t1, txl_org t2 where t1.upper_org_id = t2.org_id and t1.org_level = '3' and t1.org_id ="+id;
		java.sql.ResultSet rs = st.executeQuery(sql);
		rs.next();
	
  %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<style>
body {
	margin-top: 0px;
	margin-bottom: 0px;	
}
</style>
<script type="text/javascript">
	function choose(tmp){
		if(tmp == 'unit'){
			window.open('choose.jsp?type='+tmp, 'choose', 'height=150,width=350,scrollbars=no');
		}else{
			var unit_id = document.getElementById("unit_id").value;
			window.open('choose.jsp?type='+tmp+'&unit_id='+unit_id, 'choose', 'height=150,width=350,scrollbars=no');
		}
	}
</script>
</head>
<body text="#000000" bgcolor="#FFFFFF">

<form action="savedepart.jsp?id=<%=id%>" method="post" name="form1">  
<div style="background-color:#E0F2FF"><a href="#" onClick="javascript:window.close();">
<img  border="0" src="images/gb.bmp"/></a><a href="#" onClick="submit();"><img  border="0" src="images/bctc.bmp"/></a>
<a href="deldepart.jsp?id=<%=id%>" onClick="del();">
<img  border="0" src="images/sc.bmp"/></a></div>
 <BR>
<BR>

<div align="center"><br>
</div>
<table width="100%" border="1">
<tr valign="top"><td width="100%" bgcolor="#82C0FF" colspan="2" valign="middle"><div align="center"><b><font size="4" color="#FFFFFF" face="宋体">处 室 信 息</font></b><BR></div></td></tr>

<tr valign="top"><td width="27%" bgcolor="#F7F7F7" valign="middle"><div align="center"><font size="2" face="宋体">单位名称：</font></div></td><td width="73%" bgcolor="#FFFFFF" valign="middle"><SELECT selected>-请选择公司-
  <OPTION value="集团公司">集团公司
</SELECT></td>
</tr>

<tr valign="top"><td width="27%" bgcolor="#F7F7F7" valign="middle"><div align="center"><font size="2" face="宋体">部门名称：</font></div></td><td width="73%" bgcolor="#FFFFFF" valign="middle"><INPUT type="text" id="unit" name="unit" value="<%=NullToBlank(rs.getString("unit_name"))%>"><input type="hidden" id="unit_id" name="unit_id" value="<%=NullToBlank(rs.getString("unit_id"))%>">
    <a href="#" onclick="choose('<%=unit%>');"><font size="2"  face="宋体">选择</font></a></td>
</tr>

<tr valign="top"><td width="27%" bgcolor="#F7F7F7" valign="middle"><div align="center"><b><font size="2" face="宋体">处室名称：</font></b></div></td><td width="73%" bgcolor="#FFFFFF" valign="middle"><strong>
  <INPUT type="text" name="depart" value="<%=NullToBlank(rs.getString("depart_name"))%>">
</strong><b><font size="2" color="#FFFFFF" face="宋体"></font></b></td>
</tr>

<tr valign="top"><td width="27%" bgcolor="#F7F7F7" valign="middle"><div align="center"><font size="2" face="宋体">处室编号：</font></div></td><td width="73%" bgcolor="#FFFFFF" valign="middle"><INPUT type="text" name="code" value="<%=NullToBlank(rs.getString("code"))%>"></td>
</tr>
</table>

</form>
</body>
</html>
<%
			
rs.close();
st.close();
con.close();
%>

⌨️ 快捷键说明

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