📄 departdetail.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="gbk"%>
<%@ page import="java.sql.*,java.util.*,java.io.*" %>
<%@ include file="conn.jsp"%>
<%@ include file="util.jsp"%>
<%
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>
</head>
<body text="#000000" bgcolor="#FFFFFF">
<form action="">
<div style="background-color:#E0F2FF"><a href="#" onClick="javascript:window.close();"><img border="0" src="images/gb.bmp"/></a><a href="updatedepart.jsp?id=<%=id%>"><img border="0" src="images/bj.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"><font size="2" face="宋体">集团公司</font></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"><font size="2" face="宋体"><%=NullToBlank(rs.getString("unit_name"))%> </font><font size="2" color="#FFFFFF" face="宋体"></font></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"><font size="2" face="宋体"><%=NullToBlank(rs.getString("depart_name"))%> </font><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"><font size="2" face="宋体"><%=NullToBlank(rs.getString("code"))%> </font><font size="2" color="#FFFFFF" face="宋体"></font></td>
</tr>
</table>
</form>
</body>
</html>
<%
rs.close();
st.close();
con.close();
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -