【JSP开源代码栏目提醒】:网学会员JSP开源代码为您提供All_Query.jsp参考,解决您在All_Query.jsp学习中工作中的难题,参考学习。
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<% request.setCharacterEncoding("gb2312"); %>
<%@ page import="com.bwm.string.Str"%>
<%@ page import="com.zh.conpool.Condata"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/
html; charset=gb2312">
<title>
修改全部信息</title>
<link href="../css/style1.css" rel="stylesheet">
</head>
<script language="javascript">
function chr(company){
var company=frm.company.value;
var url='All_Query.jsp?company='+company;
location.href=url;
}
</script>
<body>
<form action="All_Query_Show.jsp" method="post" name="frm" target="bottomFrame">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="2%" height="20"> </td>
<td width="98%"><img src="../images/list_label.gif" width="11" height="13">员工查询</td>
</tr>
<tr>
<td colspan="2"><hr color="#0099FF"></td>
</tr>
</table>
<%
Condata con=new Condata();
Connection conn=con.getConnection();
Str str=new Str();
String pany=str.toChinese(request.getParameter("company"));
String
sql="select * from tb_company";
ResultSet rs=con.executeQuery(sql);
String id="";
String temp="";
String company="";
%>
<table width="100%" height="71" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bordercolordark="#FFFFFF" bordercolorlight="#F1EDFE">
<tr bgcolor="#F9F9FB">
<td width="15%" height="24" align="center" valign="middle">
公司</td>
<td width="15%" height="24"><select name="company" size="1" onChange="return chr(this.value)">
<option></option>
<%
while(rs.next()){
id=rs.getString(1);
company=rs.getString(2);
if(pany.equals(company)){
out.println("<option value="+company+" selected>"+company+"</option>");
temp=id;
}else{
out.println("<option value="+company+">"+company+"</option>");
}
}
%>
</select></td>
<td width="16%" height="24" align="center">
部门</td>
<td width="20%" height="24"><select name="branch" size="1" class="wenbenkuang1">
<option></option>
<%
String sq="select * from tb_branch where BranchID='"+temp+"'";
Result
Set rss=con.
executeQuery(sq);
while(rss.next()){
String branch=rss.getString(3);
out.println("<option>"+branch+"</option>");
}
try{
conn.close();
conn=null;
}catch(Exception e){
}
try{
con.close();
con=null;
}catch(Exception e){
}
%>
</select>
</td>
<td width="15%" height="24" align="center">性别</td>
<td width="19%" height="24">
<select name="sex" class="wenbenkuang1">
<option></option>
<option>男</option>
<option>女</option>
</select></td>
</tr>
<tr bgcolor="#F9F9FB">
<td height="24" align="center" valign="middle"></td>
<td height="24"><input name="names" type="text" class="txt_grey" size="20"></td>
<td height="24" align="center">
学历</td>
<td height="24"><input name="dimpola" type="text" class="txt_grey" size="25" maxlength="20"></td>
<td height="24" align="center">
职务</td>
<td height="24"><input name="duty" type="text" class="txt_grey" size="20"></td>
</tr>
<tr bgcolor="#EEF2F9">
<td height="24" colspan="6" align="center" valign="middle">
<input name="Submit" type="submit" class="btn_grey" value="
查询">
<input name="Submit2" type="reset" class="btn_grey" value="重置"></td>
</tr>
</table>
</form>
</body>
</html>