📄 stattest.jsp
字号:
<%@ 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">时间</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">内容</td>
<td align="center" width="60%" scope="col">详细详细</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="日总结";
if(rstest1==1)
play="周总结 ";
if(rstest1==2)
play="月总结";
%>
<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">无 记 录 </td>
</tr>
<%
}
}catch(Exception e){}
try{
conn.close();
conn=null;
}catch(Exception e){
}
try{
con.close();
con=null;
}catch(Exception e){
}
%>
</table>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -