网站中痕迹保留的实现

我们知道，系统管理员想要知道每个用户做了什么，那么我们需要将每个用户的操作保留，我们把这样一种操作，叫做痕迹保留。那么怎么实现呢，我们就需要用到一张表，专门保留痕迹。

<wbr></wbr>

那么这张表有哪些字段？我来设计一个简单的，供大家参考：

<wbr></wbr>

id<wbr> 操作类型<wbr><wbr><wbr> 操作信息ID <wbr><wbr><wbr><wbr> 删除数量 <wbr><wbr>操作时间<wbr><wbr><wbr> 用户id<wbr><wbr><wbr> ip地址</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>

1<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>登陆<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>NULL<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>NULL<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>12-11<wbr> 100<wbr><wbr><wbr><wbr><wbr> 127.0.0.1</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>

2<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>添加商品<wbr><wbr><wbr><wbr>1000商品idNULL<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>12-11<wbr> 100<wbr><wbr><wbr><wbr><wbr><wbr>127.0.0.1</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>

3<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>删除商品<wbr><wbr><wbr><wbr> NULL<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>50<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>12-11<wbr> 100<wbr><wbr><wbr><wbr><wbr><wbr>127.0.0.1</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>

4<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>退出<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> NULL<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>NULL<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>12-11<wbr> 100<wbr><wbr><wbr><wbr><wbr><wbr>127.0.0.1</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>

<wbr></wbr>

我们什么时候需要存储这些信息呢？这就要设置所谓的“监控点”。以asp.net为例，其实就是比如点击“登陆”按钮的时候，将登陆这个痕迹保留进去。那么这个登陆按钮就是一个监控点。

<wbr></wbr>

我们需要知道的是：

操作类型为添加和修改的时候就可以存储ID，但是要是操作类型为删除的存储ID也没有用了<wbr>。</wbr>

可能要存储其他的信息<wbr> 这个就取决与你的数据库设计了。</wbr>