?? worknote.jsp
字號:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="com.zh.conpool.Condata"%>
<% request.setCharacterEncoding("gb2312"); %>
<%@ page import="com.bwm.string.Str"%>
<%
String sess=(String)session.getAttribute("username");
if(sess==null||sess.equals("")){
response.sendRedirect("../main.jsp");
}else{
swing.Rous rou=new swing.Rous();
boolean maybe=rou.toInt(sess,"row113");
if(!maybe){
response.sendRedirect("../../notrous.jsp");
}
}
%><html>
<head>
<title>Untitled</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../../css/style1.css" rel="stylesheet">
</head>
<script language="javascript">
function chg2(company){
var company=document.frm.company.value;
var branch=document.frm.branch.value;
var url='worknote.jsp?company='+company+'&branch='+branch;
location.href=url;
}
</script>
<script language="javascript">
<!--
function checkser(){
if(frm.names.value==''){
alert("請選擇用戶名稱");
return false;
}
return true;
}
-->
</script>
<body>
<br>
<img src="../../images/face/replace.gif" width="16" height="16">工作進度查詢
<hr size=1>
<table width="100%" border=1 cellpadding=0 cellspacing=0 bordercolor="#FFFFFF" bordercolorlight="#FFFFFF" bordercolordark="#EEF2F9" bgcolor="#ffffff" align="center">
<form action="serworded.jsp" method="post" name="frm" target="bottomFrame">
<tr bgcolor="#F9F9FB">
<%
Str str1=new Str();
String company=str1.toChinese(request.getParameter("company"));
String branch=str1.toChinese(request.getParameter("branch"));
%>
<td height="24" colspan="2" align="center">公司名稱</td>
<td height="24"><select name="company" size="1" class="wenbenkuang" onChange="return chg2(this.value);">
<option selected>—請選擇—</option>
<%
Condata con=new Condata();
Connection conn=con.getConnection();
String sql="select * from tb_company";
ResultSet rs=con.executeQuery(sql);
int temp=0;
while(rs.next()){
int companyid=rs.getInt(1);
String str=rs.getString(2);
if(company.equals(str)){
out.println("<option value="+str+" selected>"+str+"</option>");
temp=companyid;
}else{
out.println("<option value="+str+">"+str+"</option>");
}
}
try{
conn.close();
conn=null;
}catch(Exception e){
}
try{
con.close();
con=null;
}catch(Exception e){
}
%>
</select></td>
</tr>
<tr bgcolor="#F9F9FB">
<td height="24" colspan="2" align="center">部門名稱</td>
<td height="24"><SELECT name="branch" size="1" class="wenbenkuang" onChange="return chg2(this.value);">
<option selected>—請選擇—</option>
<%
Condata con1=new Condata();
Connection conn1=con1.getConnection();
String sq="select * from tb_branch where BranchId='"+temp+"'";
ResultSet rss=con1.executeQuery(sq);
int branchid=0;
while(rss.next()){
int id=rss.getInt(1);
String tem=rss.getString(3);
if(branch.equals(tem)){
out.println("<option value="+tem+" selected>"+tem+"</option>");
branchid=id;
}else{
out.println("<option value="+tem+">"+tem+"</option>");
}
}
try{
conn1.close();
conn1=null;
}catch(Exception e){
}
try{
con1.close();
con1=null;
}catch(Exception e){
}
%>
</SELECT></td>
</tr>
<tr bgcolor="#F9F9FB">
<td height="24" colspan="2" align="center">人員名稱</td>
<td > <select name="names" class="wenbenkuang">
<option selected>—請選擇—</option>
<%
Condata con12=new Condata();
Connection conn12=con12.getConnection();
String sql1="select * from tb_person where BranchId='"+branchid+"'and Popdeom='"+1+"'";
ResultSet rst=con12.executeQuery(sql1);
while(rst.next()){
String tt=rst.getString(3);
out.println("<option value="+tt+">"+tt+"</option>");
}
try{
conn12.close();
conn12=null;
}catch(Exception e){
}
try{
con12.close();
con12=null;
}catch(Exception e){
}
%>
</select></td>
</tr>
<tr bgcolor="#F9F9FB">
<td height="24" colspan="2" align="center">工作內容</td>
<td height="24"><input name="content" type="text" class="txt_grey" size="32">
*（模糊查詢）</td>
</tr>
<tr align="center" bgcolor="#Eff2fb">
<td height="24" colspan="3"><input name="Submit" type="submit" class="btn_grey" value="開始查詢" onClick="return checkser()"></td>
</tr>
</form>
</table>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -