小弟最近在帮公司解决一个问题,就是对于每个上网的用户每时每刻操作的记录进行分类插入不同的数据库表中;不知道从何下手了。小迷茫一番!请各位大虾帮忙解决一下。记录如下:
2010-04-16 09:20:48 Local7.Debug 10.255.255.2 ><PA>qvod.udp 1271412890-1271413169 10.255.255.7:1406-61.167.57.143:46526 182 0
2010-04-16 09:21:17 Local7.Debug 10.255.255.2 <PNB0>1271413197 10.255.255.122 GET http://img2.126.net/ntesrich/2010/0416/index/sanxing-11.js
2010-04-16 09:21:17 Local7.Debug 10.255.255.2 <PNB0>1271413197 10.255.255.122 GET http://img2.126.net/ntesrich/2010/0416/index/960-400-9.swf
2010-04-16 09:21:17 Local7.Debug 10.255.255.2 <PNB0>1271413197 10.255.255.122 GET http://img2.126.net/ntesrich/2010/0416/index/20-120-9.swf
2010-04-16 09:21:17 Local7.Debug 10.255.255.2 <PNB0>1271413197 10.255.255.122 GET http://img2.126.net/ntesrich/2010/0416/index/20-120-9.swf
2010-04-16 09:21:17 Local7.Debug 10.255.255.2 <PNB0>dnsquery 1271413197 163.wrating.com 10.255.255.122 202.102.224.68
2010-04-16 09:21:17 Local7.Debug 10.255.255.2 <PNB0>1271413197 10.255.255.122 GET http://163.wrating.com/a1.js
2010-04-16 09:21:18 Local7.Debug 10.255.255.2 <PNB0>dnsquery 1271413198 analytics.163.com 10.255.255.122 202.102.224.68
2010-04-16 09:21:18 Local7.Debug 10.255.255.2 <PNB0>1271413198 10.255.255.122 GET http://163.wrating.com/a.gif?a=128043474d9&t=&i=fae1b356.120292abbf6.0.649bdc4a9e2c8&b=http%3A//www.163.com/&c=860010-0503010000&s=1280x800x32&l=zh-cn&z=8&j=1&f=10.0&ut=11&n
2010-04-16 09:21:18 Local7.Debug 10.255.255.2 <PNB0>1271413198 10.255.255.122 GET http://analytics.163.com/ntes.js
2010-04-16 09:21:18 Local7.Debug 10.255.255.2 <PNB0>dnsquery 1271413198 adc.163.com 10.255.255.122 202.102.224.68
2010-04-16 09:21:18 Local7.Debug 10.255.255.2 <PNB0>1271413198 10.255.255.122 GET http://adc.163.com/ntesc?s=www
2010-04-16 09:21:18 Local7.Debug 10.255.255.2 <PNB0>dnsquery 1271413198 www.youdao.com 10.255.255.122 202.102.224.68
2010-04-16 09:21:18 Local7.Debug 10.255.255.2 <PNB0>1271413198 10.255.255.122 GET http://www.youdao.com/suggest/suggest.s?query=&o=aa&count=1&keyfrom=www.163.com.suggest&time=Fri%20Apr%2016%2009:21:06%20UTC+0800%202010
2010-04-16 09:21:18 Local7.Debug 10.255.255.2 <PNB0>dnsquery 1271413198 richmedia.minisite.163.com 10.255.255.122 202.102.224.68
2010-04-16 09:21:18 Local7.Debug 10.255.255.2 <PNB0>1271413198 10.255.255.122 GET http://richmedia.minisite.163.com/crossdomain.xml
2010-04-16 09:21:18 Local7.Debug 10.255.255.2 <PNB0>1271413199 10.255.255.122 POST http://richmedia.minisite.163.com/click.php?adid=588&lid=0&playtype=1
2010-04-16 09:21:20 Local7.Debug 10.255.255.2 <PNB0>1271413200 10.255.255.122 GET http://active.baofeng.com/active2?pid=2&id=364&uid={6DB6FBC7-DEEE-43C9-A56B-98F414A6E361}&t=7&v=3.09.11.23&idate=2008_12_25
2010-04-16 09:21:20 Local7.Debug 10.255.255.2 ><PA>http.tcp 1271413200-1271413200 10.255.255.122:1944-60.28.15.180:80 191 105
   按照><PA>和<PNBO>建成两个表,从txt文档里将记录读取让后分类插入两个表中。