?? log.java
字號:
/***************************************************
*
* 源文件名: Log.java
* 功 能： 夢想年華新聞系統 - 日志管理類
* 作者：夢想年華 [DreamTime]
* Email:fanwsp@126.com
* QQ:122142023
* CopyRight(c)2005-2006 by DreamTime
*
****************************************************
*/
package dreamtime.dreamnews; //指定類所在的包
import java.sql.*;
import dreamtime.dreamnews.Function;
import dreamtime.dreamnews.DBConnection;
public class Log
{
DBConnection DBConn = new DBConnection();
Function Fun = new Function();
public Log()
{
}
/*********************************************************
* 函數名：ReadLog
* 作 用：讀取日志列表
* 參 數：sPage,頁面地址; strPage,第幾頁
* 返回值：字符串
***********************************************************/
public String ReadLog(String sPage,String strPage)
{
try
{
Connection Conn = DBConn.getConn();
Statement stmt = Conn.createStatement(1004,1007);
String sql = "select * from Log order by LogID desc";
ResultSet rs = stmt.executeQuery(sql);
StringBuffer sb = new StringBuffer();
int i;
int intPage = 1;
int intPageSize = 10;
if (Fun.ReadConfig() && Fun.AdminLogListNum>0) intPageSize = Fun.AdminLogListNum;
sb.append("<br><br><table width=\"90%\" border=\"1\" align=\"center\" cellpadding=\"2\" cellspacing=\"0\">\r\n");
sb.append("<tr><td height=\"27\" colspan=\"7\" background=\"images/bg.gif\">");
sb.append("<div align=\"center\" class=\"title\"><strong>日志管理</strong></div></td>");
sb.append("</tr>\r\n");
sb.append("<tr>\r\n");
sb.append("<td height=\"25\" colspan=\"7\"><strong> <a href=\"Admin_Log.jsp?Action=DelAll\">");
sb.append("<font color=\"#ff6600\">[刪除所有日志]</font></a></strong></td>\r\n");
sb.append("</tr>\r\n");
sb.append("<tr>\r\n");
sb.append("<td height=\"25\" width=\"5%\"><div align=\"center\" class=\"chinese\"><b>ID</b></div></td>\r\n");
sb.append("<td width=\"12%\"><div align=\"center\" class=\"chinese\"><b>操作用戶</b></div></td>\r\n");
sb.append("<td width=\"23%\"><div align=\"center\" class=\"chinese\"><b>事件</b></div></td>\r\n");
sb.append("<td width=\"26%\"><div align=\"center\" class=\"chinese\"><b>時間</b></div></td>\r\n");
sb.append("<td width=\"14%\"><div align=\"center\" class=\"chinese\"><b>IP地址</b></div></td>\r\n");
sb.append("<td width=\"10%\"><div align=\"center\" class=\"chinese\"><b>結果</b></div></td>\r\n");
sb.append("<td width=\"10%\"><div align=\"center\" class=\"chinese\"><b>操作</b></div></td>\r\n");
sb.append("</tr>\r\n");
//如果表中沒有任何記錄，剛給出提示信息
if (!rs.next())
{
sb.append("<tr height=\"25\" bgcolor=\"#d6dff7\" class=\"info1\"><td colspan=\"8\">\r\n");
sb.append("<div align=\"center\"><b>暫時沒有任何日志!</b></div></td></tr>\r\n");
}
else
{
//取得待顯示頁碼
intPage = Fun.StrToInt(strPage);
sPage = Fun.CheckReplace(sPage);
if (intPage==0) intPage=1;
//將記錄指針定位到待顯示頁的第一條記錄上
rs.absolute((intPage-1) * intPageSize+1);
i = 0;
while(i < intPageSize && !rs.isAfterLast())
{
int LogID = rs.getInt(1);
String LogType = rs.getString(3);
String User = rs.getString(2);
String LogTime = rs.getString(4);
String IP = rs.getString(5);
String sResult = rs.getString(6);
String sBgColor = "#D6DFF7";
String sLogType = LogType;
if(sResult.equals("No"))
{
sResult = "<font color='#ff6600'><b>失敗</b></font>";
sBgColor = "#DBE6FE";
}
else sResult = "<font color='#000000'><b>成功</b></font>";
if(LogType.length()>10) sLogType = LogType.substring(0,10);
sb.append("<tr bgcolor=\"" + sBgColor + "\" height=\"22\">\r\n");
sb.append("<td height=\"25\" ><div align=\"center\" class=\"chinese\">" + LogID + "</div></td>\r\n");
sb.append("<td><div align=\"center\" class=\"chinese\">" + User + "</div></td>\r\n");
sb.append("<td><div align=\"left\" class=\"chinese\" Title=\"" + LogType + "\">" + sLogType + "</div></td>\r\n");
sb.append("<td><div align=\"center\" class=\"chinese\">" + LogTime + "</div></td>\r\n");
sb.append("<td><div align=\"center\" class=\"chinese\">" + IP + "</div></td>\r\n");
sb.append("<td><div align=\"center\" class=\"chinese\">" + sResult + "</div></td>\r\n");
sb.append("<td><div align=\"center\" class=\"chinese\">[<a href=\"Admin_Log.jsp?Action=Del&LogID=");
sb.append(LogID);
sb.append("\">刪除</a>]</div></td>\r\n");
sb.append("</tr>\r\n");
rs.next();
i++;
}
}
sb.append("</table>");
sb.append(Fun.Page(sPage,rs,intPage,intPageSize));
sb.append("<br><br>");
rs.close();
stmt.close();
Conn.close();
return sb.toString();
}catch(Exception e)
{
//e.printStackTrace();
//System.out.print(e.getMessage());
return "No";
}
}
/*********************************************************
* 函數名：DelLog
* 作 用：刪除日志
* 參 數：s0，日志ID，s1，操作用戶
* s2:IP，是否刪除所有日志
* 返回值：成功 true ，否則返回 false
***********************************************************/
public boolean DelLog(String s0,String s1,String s2,boolean b)
{
String NowTime = (new java.util.Date()).toLocaleString();
String [] sLog = new String[5];
sLog[0] = s1;
sLog[2] = NowTime;
sLog[3] = s2;
int LogID = Fun.StrToInt(s0);
if(!b && LogID==0)
return false;
else
{
try{
Connection Conn = DBConn.getConn();
Statement stmt = Conn.createStatement();
String sql = "delete from Log where LogID=" + LogID;
if(b) sql = "delete from Log";
stmt.executeUpdate(sql);
stmt.close();
Conn.close();
if(b)
{ sLog[1] = "刪除所有日志!";
sLog[4] = "Yes";
Fun.AddLog(sLog);
}
return true;
}catch(Exception e){
////e.printStackTrace();
//System.out.print(e.getMessage());
//return "添加用戶操作出錯，請重試！" + e.getMessage();
sLog[1] = "刪除所有日志失敗，程序異常!";
sLog[4] = "No";
Fun.AddLog(sLog);
return false;
}
}
}
//測試
public static void main(String[] args)
{
Log log = new Log();
String sa = log.ReadLog("Log.jsp","1");
//System.out.println(sa);
if(log.DelLog(null,"dream","172.16.166.50",true)) System.out.println("Yes");
}
}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -