📄 choose.jsp
字号:
<%@page language="java" contentType="text/html; charset=GBK"%>
<%@ page import="java.sql.*,java.util.*,java.io.*" %>
<%@ include file="conn.jsp"%>
<html>
<head>
<title>人员信息修改</title>
</head>
<script language="javascript">
function checkData(tmp){
var sels = document.getElementById("selOpts");
for(var i=0;i<sels.options.length;i++)
{
if(sels.options[i].selected==true){
if(tmp == 'unit'){
window.opener.form1.unit.value = sels.options[i].text;
window.opener.form1.unit_id.value = sels.options[i].value;
}else if(tmp == 'dep'){
window.opener.form1.dep.value = sels.options[i].text;
window.opener.form1.depart_id.value = sels.options[i].value;
}
}
}
window.close();
}
</script>
<%
String type = request.getParameter("type");
String unit_id = request.getParameter("unit_id");
String title = "";
if(type!=null && type.equals("unit")){
title = "部门";
}else if(type!=null && type.equals("dep")){
title="处室";
}else {
title = "未知项目";
}
String sql = "";
ResultSet rs = null;
try{
if(type!=null && type.equals("unit")){//选择部门
sql = " select t.org_id,t.org_name from txl_org t where t.org_level=2";
}else if(type!=null && type.equals("dep")){//选择处室
sql = " select t.org_id,t.org_name from txl_org t where t.org_level=3";
if(unit_id!=null){
sql += " and t.upper_org_id = "+unit_id;
}
}else{
sql = "";
}
rs = st.executeQuery(sql);
%>
<body text="#000000" bgcolor="#E1E1E1">
<form action="#" name="form1" method="post" onsubmit="return checkData('<%=type%>');">
<table border="0" cellspacing="0" cellpadding="0" align="center" width="100%" bgcolor="#E1E1E1">
<tr>
<td align="center" colspan="2">
<b>请选择<%=title%></b>
</td>
</tr>
<tr>
<td align="center" colspan="2">
</td>
</tr>
<tr>
<td align="right">
<%=title%>名称：
</td>
<td>
<select id="selOpts" name="selOpts">
<option value="">--请选择<%=title%>--</option>
<%
while(rs.next()){
%>
<option value="<%=rs.getString(1)%>"><%=rs.getString(2)%></option>
<%
}
%>
</select>
</td>
</tr>
<tr>
<td align="center" colspan="2">
</td>
</tr>
<tr>
<td align="center" colspan="2">
<input type="submit" value="确定" onclick="javascipt:window.close();">
<input type="reset" value="取消" onclick="javascipt:window.close();">
</td>
</tr>
</table>
</form>
</body>
<%
}catch(Exception ex){
System.out.println(ex.getMessage());
}finally{
rs.close();
st.close();
con.close();
}
%>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -