📄 log.jsp
字号:
<link rel=stylesheet href="style.css" type="text/css">
<body bgcolor="#DEDEDE">
<%@ page language="java" import="java.util.*" %>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="doit" scope="page" class="dbcon.doit" />
<jsp:useBean id="DB" scope="page" class="dbcon.mydb" />
<jsp:include page=cksession.jsp />
<center>
<font face="times new roman"><big><strong>System Logs</strong></big></font></center>
<form method="POST" action="log.jsp">
<input type="text" size="4" name="year" value="2001">Year
<select name="month" size="1">
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
</select>Month
<select name="day" size="1">
<option value="00"></option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>Day
<input TYPE="submit" VALUE="Check" NAME="B1"><input TYPE="reset" VALUE="Cancel" NAME="B2">
</form>
</center>
<%
int intPageSize=10; //Records one page
int intRowCount=0; //Total records
int intPageCount=0; //Total pages
int intPage=0; //Current page
String strSql="",strUser="";
String strTask="";
String strAll="",strYear="",strMonth="",strDay="",strDate="";
strUser=(String)session.getValue("user");
if(strUser.equals("admin")){
if(request.getParameter("year")!=null){
strYear=(String)request.getParameter("year");
strMonth=(String)request.getParameter("month");
strDay=(String)request.getParameter("day");
if(strDay.equals("00")){
strDate=strYear+"-"+strMonth;
}else{
strDate=strYear+"-"+strMonth+"-"+strDay;
}
strSql="SELECT * FROM ONLINE WHERE STR_LOGINTIME LIKE '%"+strDate+"%' ORDER BY INT_ID";
%>
<table border="1" cellpadding="1" cellspacing="0" width="100%">
<tr bgcolor="#cc3333">
<td align="center" nowrap ><font color="#ffffff" face="times new roman" ><strong>ID</strong></font></td>
<td align="center" nowrap><font color="#ffffff" face="times new roman"><strong>USERIP</strong></font></td>
<td align="center" nowrap><font color="#ffffff" face="times new roman"><strong>USERNAME</strong></font></td>
<td align="center" nowrap><font color="#ffffff" face="times new roman"><strong>LOGINTIME</strong></font></td>
<td align="center" nowrap><font color="#ffffff" face="times new roman"><strong>QUITTIME</strong></font></td>
<td align="center" nowrap><font color="#ffffff" face="times new roman"><strong>SYSTEM</strong></font></td>
<td align="center" nowrap><font color="#ffffff" face="times new roman"><strong>REMOTEHOST</strong></font></td>
<td align="center" nowrap><font color="#ffffff" face="times new roman"><strong>ONLINE</strong></font></td>
</tr>
<script type="text/javascript" language="JavaScript">
function log(logid,a1,a2,a3,a4,a5,a6,a7)
{ ss="<tr><td>"+logid+"</td><td>"+a1+"</td><td>"+a2+"</td><td>"+a3+"</td><td>";
ss=ss+a4+"</td><td>"+a5+"</td><td>"+a6+"</td><td>"+a7+"</td></tr>";
document.write(ss);
}
<%
ResultSet sqlRst=DB.executeQuery(strSql);
String s1,s2,s3,s4,s5,s6,s7,id,ss;
while(sqlRst.next()){
id=sqlRst.getString("INT_ID");
s1=sqlRst.getString("STR_IP");
s2=sqlRst.getString("STR_USER");
s3=sqlRst.getString("STR_LOGINTIME");
s4=sqlRst.getString("STR_QUITTIME");
s5=sqlRst.getString("STR_BROWSERTYPE");
s6=sqlRst.getString("STR_REMOTEUSER");
s7=sqlRst.getString("INT_ONLINE");
strAll="log('"+id+"','"+s1+"','"+s2+"','"+s3+"','"+s4+"','"+s5+"','"+s6+"','"+s7+"');"+"\n";
out.print(strAll);
}
sqlRst.close();
%>
</SCRIPT>
</table>
<%
}
}else{
out.print("You have no right to run this page!!!");
}
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -