?? stattest.jsp
字號(hào):
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="com.bwm.string.Str"%>
<%@ page import="com.zh.conpool.Condata"%>
<%@ page import="java.sql.*"%>
<HTML>
<HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../../css/style1.css" rel="stylesheet">
</HEAD>
<p>
</p>
<p>
<%
Str str=new Str();
String personss="";
String branchss=str.toChinese(request.getParameter("branch"));
String person=str.toChinese(request.getParameter("name"));
String begin=str.toChinese(request.getParameter("times"));
String end=request.getParameter("times1");
String sqlstat="";
String work=str.toChinese(request.getParameter("work"));
if(person==""){
personss="全部人員";
if(work==""){
sqlstat="select * from jobwork where Branch='"+branchss+"'and DateTime >='"+begin+"' and DateTime<='"+end+"'";
}else{
sqlstat="select * from jobwork where Branch='"+branchss+"'and DateTime >='"+begin+"' and DateTime<='"+end+"' and (Name in(select Name from tb_person where Popdeom='"+work+"'))";
}
}else{
personss=person;
sqlstat="select * from jobwork where Branch='"+branchss+"' and Name='"+person+"' and DateTime >='"+begin+"' and DateTime<='"+end+"'";
}
%>
<span class="style25"> 姓名</span>:<%=personss%>
..<span class="style25">部門</span>:<%=branchss%>
..<span class="style25">時(shí)間</span>:<%=begin%>--<%=end%>
</p>
<HR>
<table width="95%" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="10%" scope="col" align="center">日志類型</td>
<td width="10%" scope="col" align="center">姓名</td>
<td width="20%" scope="col" align="center">內(nèi)容</td>
<td align="center" width="60%" scope="col">詳細(xì)詳細(xì)</td>
</tr>
<%
Condata con=new Condata();
Connection conn=con.getConnection();
try{
ResultSet rs=con.executeQuery(sqlstat);
int temp=0;
while(rs.next()){
temp++;
String id=rs.getString(1);
String rstest=rs.getString(2);
int rstest1=rs.getInt(10);
String play="";
if(rstest1==0)
play="日總結(jié)";
if(rstest1==1)
play="周總結(jié) ";
if(rstest1==2)
play="月總結(jié)";
%>
<tr>
<td align="center" scope="col"><%=play%></td>
<td align="center" scope="col"><%=rstest%></td>
<td align="center" scope="col"><%=rs.getString(6)%></td>
<td align="center" scope="col"><%=rs.getString(7)%></td>
</tr>
<%
}
if(temp<=0){
%>
<tr>
<td colspan="4" align="center" scope="col">無(wú) 記 錄 </td>
</tr>
<%
}
}catch(Exception e){}
try{
conn.close();
conn=null;
}catch(Exception e){
}
try{
con.close();
con=null;
}catch(Exception e){
}
%>
</table>
</BODY>
</HTML>
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -