English
Log.java
资源名称：mxnhnews.rar [点击查看]
上传用户：sdtxjx
上传日期：2022-07-09
资源大小：2937k
文件大小：7k
源码类别：
Jsp/Servlet
开发平台：
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">rn");
- 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>rn");
- sb.append("<tr>rn");
- sb.append("<td height="25" colspan="7"><strong> <a href="Admin_Log.jsp?Action=DelAll">");
- sb.append("<font color="#ff6600">[删除所有日志]</font></a></strong></td>rn");
- sb.append("</tr>rn");
- sb.append("<tr>rn");
- sb.append("<td height="25" width="5%"><div align="center" class="chinese"><b>ID</b></div></td>rn");
- sb.append("<td width="12%"><div align="center" class="chinese"><b>操作用户</b></div></td>rn");
- sb.append("<td width="23%"><div align="center" class="chinese"><b>事件</b></div></td>rn");
- sb.append("<td width="26%"><div align="center" class="chinese"><b>时间</b></div></td>rn");
- sb.append("<td width="14%"><div align="center" class="chinese"><b>IP地址</b></div></td>rn");
- sb.append("<td width="10%"><div align="center" class="chinese"><b>结果</b></div></td>rn");
- sb.append("<td width="10%"><div align="center" class="chinese"><b>操作</b></div></td>rn");
- sb.append("</tr>rn");
- //如果表中没有任何记录，刚给出提示信息
- if (!rs.next())
- {
- sb.append("<tr height="25" bgcolor="#d6dff7" class="info1"><td colspan="8">rn");
- sb.append("<div align="center"><b>暂时没有任何日志!</b></div></td></tr>rn");
- }
- 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">rn");
- sb.append("<td height="25" ><div align="center" class="chinese">" + LogID + "</div></td>rn");
- sb.append("<td><div align="center" class="chinese">" + User + "</div></td>rn");
- sb.append("<td><div align="left" class="chinese" Title="" + LogType + "">" + sLogType + "</div></td>rn");
- sb.append("<td><div align="center" class="chinese">" + LogTime + "</div></td>rn");
- sb.append("<td><div align="center" class="chinese">" + IP + "</div></td>rn");
- sb.append("<td><div align="center" class="chinese">" + sResult + "</div></td>rn");
- sb.append("<td><div align="center" class="chinese">[<a href="Admin_Log.jsp?Action=Del&LogID=");
- sb.append(LogID);
- sb.append("">删除</a>]</div></td>rn");
- sb.append("</tr>rn");
- 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");
- }
- }
