📄 updateuser.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 * from txl_view where 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 id="form1" action="saveuser.jsp?id=<%=id%>" method="post">
<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="deluser.jsp?id=<%=id%>"><img border="0" src="images/sc.bmp"/></a></div>
<BR>
<br>
<p>
<table width="100%" border="1">
<tr valign="top"><td width="100%" bgcolor="#2181FF" colspan="3"><div align="center"><b><font size="4" color="#FFFFFF" face="宋体">人 员 信 息</font></b><BR></div></td></tr>
<tr valign="top"><td width="16%" valign="middle"><div align="center"><font size="2" face="宋体">姓</font><font size="2" color="#FFFFFF" face="宋体">----</font><font size="2" face="宋体">名：</font></div></td>
<td width="84%" colspan="2"><font size="2" face="宋体"><input name="username" type="text" value="<%=rs.getString("NAME")%>"/></font><font size="2" color="#FFFFFF" face="宋体"></font></td></tr>
<tr valign="top"><td width="16%" valign="middle"><div align="center"><font size="2" face="宋体">人员编号：</font></div></td>
<td width="84%" colspan="2"><font size="2" face="宋体"><input name="CODE" type="text" value="<%=NullToBlank(rs.getString("CODE"))%>"/></font><font size="2" color="#FFFFFF" face="宋体"></font></td></tr>
<tr valign="top"><td width="16%" valign="middle"><div align="center"><font size="2" face="宋体">公司名称：</font></div></td>
<td width="84%" colspan="2"><font size="2" face="宋体"> <SELECT name="company">
<OPTION value="集团公司" selected>集团公司</OPTION>
</SELECT></font><font size="2" color="#FFFFFF" face="宋体"></font></td></tr>
<tr valign="top"><td width="16%" valign="middle"><div align="center"><font size="2" face="宋体">所属部门：</font></div></td>
<td width="42%" valign="middle"><font size="2" face="宋体"><input id="unit" name="UNIT" type="text" value="<%=rs.getString("UNIT_NAME")%>" readonly/><input type="hidden" id='unit_id' name='unit_id' value='<%=rs.getString("UNIT_ID")%>'/></font><font size="2" color="#FFFFFF" face="宋体"></font></td><td width="42%"><img src="/icons/ecblank.gif" border="0" height="1" width="1" alt=""><a href="#" onclick="choose('<%=unit%>');"><font size="2" face="宋体">选择</font></a></td></tr>
<tr valign="top"><td width="16%" valign="middle"><div align="center"><font size="2" face="宋体">所属处室：</font></div></td>
<td width="42%" valign="middle"><font size="2" face="宋体"></font><font size="2" color="#FFFFFF" face="宋体"><input id="dep" name="DEPART" type="text" value="<%=NullToBlank(rs.getString("DEPART_NAME"))%>" readonly/><input type="hidden" id='depart_id' name='depart_id' value='<%=rs.getString("DEPART_ID")%>'/></font></td><td width="42%"><img src="/icons/ecblank.gif" border="0" height="1" width="1" alt=""><a href="#" onclick="choose('<%=department%>');"><font size="2" face="宋体">选择</font></a></td></tr>
<tr valign="top"><td width="16%" valign="middle"><div align="center"><font size="2" face="宋体">职</font><font size="2" color="#FFFFFF" face="宋体">----</font><font size="2" face="宋体">务：</font></div></td>
<td width="84%" colspan="2"><font size="2" face="宋体"><input name="POST" type="text" value="<%=NullToBlank(rs.getString("POST"))%>"/></font><font size="2" color="#FFFFFF" face="宋体"></font></td></tr>
<tr valign="top"><td width="16%"><div align="center"><font size="2" face="宋体">房 间 号：</font></div></td>
<td width="84%" colspan="2"><font size="2" face="宋体"> </font><font size="2" face="宋体"><input name="ROOMID" type="text" value="<%=NullToBlank(rs.getString("ROOMID"))%>"/></font></td></tr>
<tr valign="top"><td width="16%" valign="middle"><div align="center"><font size="2" face="宋体">区</font><font size="2" color="#FFFFFF" face="宋体">----</font><font size="2" face="宋体">号：</font></div></td>
<td width="84%" colspan="2"><font size="2" face="宋体"><input name="CITYID" type="text" value="<%=NullToBlank(rs.getString("CITYID"))%>"/></font><font size="2" color="#FFFFFF" face="宋体"></font></td></tr>
<tr valign="top"><td width="16%" valign="middle"><div align="center"><font size="2" face="宋体">办公电话：</font></div></td>
<td width="84%" colspan="2"><font size="2" face="宋体"><input name="PHONE" type="text" value="<%=NullToBlank(rs.getString("PHONE"))%>"/></font><font size="2" color="#FFFFFF" face="宋体"></font></td></tr>
<tr valign="top"><td width="16%" valign="middle"><div align="center"><font size="2" face="宋体">分机号码：</font></div></td>
<td width="84%" colspan="2"><font size="2" face="宋体"><input name="EXTENSION" type="text" value="<%=NullToBlank(rs.getString("EXTENSION"))%>"/></font><font size="2" color="#FFFFFF" face="宋体"></font></td></tr>
<tr valign="top"><td width="16%" valign="middle"><div align="center"><font size="2" face="宋体">移动电话：</font></div></td>
<td width="84%" colspan="2"><font size="2" face="宋体"><input name="MOBILE" type="text" value="<%=NullToBlank(rs.getString("MOBILE"))%>"/></font><font size="2" color="#FFFFFF" face="宋体"></font></td></tr>
<tr valign="top"><td width="16%"><div align="center"><font size="2" face="宋体">TD测试号码：</font></div></td>
<td width="42%"><font size="2" face="宋体"><input name="tdno" type="text" value="<%=NullToBlank(rs.getString("TDNO"))%>"/></font></td>
<td width="42%"><img src="/icons/ecblank.gif" border="0" height="1" width="1" alt=""></td></tr>
<tr valign="top"><td width="16%" valign="middle"><div align="center"><font size="2" face="宋体">邮件地址：</font></div></td>
<td width="42%" valign="middle"><font size="2" face="宋体"><input name="email" type="text" value="<%=NullToBlank(rs.getString("EMAIL"))%>"/></font><font size="2" color="#FFFFFF" face="宋体"></font></td><td width="42%"><img src="/icons/ecblank.gif" border="0" height="1" width="1" alt=""></td></tr>
<tr valign="top"><td width="16%" valign="middle"><div align="center"><font size="2" face="宋体">传真电话：</font></div></td>
<td width="84%" colspan="2"><font size="2" face="宋体"></font><font size="2" color="#FFFFFF" face="宋体"><input name="fax" type="text" value="<%=NullToBlank(rs.getString("FAX"))%>"/></font></td></tr>
<tr valign="top"><td width="16%" valign="middle"><div align="center"><font size="2" face="宋体">邮政编码：</font></div></td>
<td width="84%" colspan="2"><font size="2" face="宋体"><input name="zip" type="text" value="<%=NullToBlank(rs.getString("ZIP"))%>"/></font><font size="2" color="#FFFFFF" face="宋体"></font></td></tr>
<tr valign="top"><td width="16%" valign="middle"><div align="center"><font size="2" face="宋体">通信地址：</font></div></td>
<td width="84%" colspan="2"><font size="2" face="宋体"><input name="address" type="text" value="<%=NullToBlank(rs.getString("ADDRESS"))%>"/></font><font size="2" color="#FFFFFF" face="宋体"></font></td></tr>
<tr valign="top"><td width="16%" valign="middle"><div align="center"><font size="2" face="宋体">备</font><font size="2" color="#FFFFFF" face="宋体">----</font><font size="2" face="宋体">注：</font></div></td>
<td width="84%" colspan="2">
<font size="2" color="#FFFFFF" face="宋体"><textarea rows = "5" cols = "50" name="remark" type="text" value=""><%=NullToBlank(rs.getString("REMARK"))%></textarea></font>
</td></tr>
</table>
</form>
</body>
</html>
<%
rs.close();
st.close();
con.close();
%> ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -