ip数据库脚本（ip.sql）

DROP TABLE IF EXISTS `zxzx`; CREATE TABLE `zxzx` ( `id` int(11) NOT NULL auto_increment, `ip` varchar(100) default NULL, `ip2` varchar(100) default NULL, `adress` varchar(100) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=gbk; INSERT INTO zxzx VALUES(1,'0.0.0.0','0.255.255.255','IANA CZ88.NET'); INSERT INTO zxzx VALUES(2,'1.0.0.0','1.51.255.255','IANA CZ88.NET'); INSERT INTO zxzx VALUES(3,'1.52.0.0','1.52.255.255','美国 CZ88.NET'); INSERT INTO zxzx VALUES(4,'1.53.0.0','1.153.255.255','IANA CZ88.NET'); INSERT INTO zxzx VALUES(5,'1.154.0.0','1.154.255.255','美国 CZ88.NET'); INSERT INTO zxzx VALUES(6,'1.155.0.0','1.255.255.255','IANA CZ88.NET'); INSERT INTO zxzx VALUES(7,'2.0.0.0','2.255.255.255','IANA CZ88.NET'); INSERT INTO zxzx VALUES(8,'3.0.0.0','3.255.255.255','美国 新泽西通用电气公司'); INSERT INTO zxzx VALUES(9,'4.0.0.0','4.9.255.255','美国 CZ88.NET'); INSERT INTO zxzx VALUES(10,'4.10.0.0','4.10.255.255','美国 新泽西州立大学'); INSERT INTO zxzx VALUES(11,'4.11.0.0','4.11.255.255','美国 夏威夷'); INSERT INTO zxzx VALUES(12,'4.12.0.0','4.19.77.255','美国 CZ88.NET'); INSERT INTO zxzx VALUES(13,'4.19.78.0','4.19.78.255','美国 西南政法大学'); INSERT INTO zxzx VALUES(14,'4.19.79.0','4.19.79.63','美国 Armed Forces Radio/Television'); INSERT INTO zxzx VALUES(15,'4.19.79.64','4.21.176.255','美国 CZ88.NET'); INSERT INTO zxzx VALUES(16,'4.21.177.0','4.21.177.255','美国 西南政法大学'); INSERT INTO zxzx VALUES(17,'4.21.178.0','4.36.124.127','美国 CZ88.NET'); INSERT INTO zxzx VALUES(18,'4.36.124.128','4.36.124.255','美国 Technical Resource Connections Inc'); INSERT INTO zxzx VALUES(19,'4.36.125.0','4.36.127.255','美国 坦帕大学'); INSERT INTO zxzx VALUES(20,'4.36.128.0','4.37.215.255','美国 CZ88.NET'); INSERT INTO zxzx VALUES(21,'4.37.216.0','4.37.219.255','美国 德克萨斯女子大学'); INSERT INTO zxzx VALUES(22,'4.37.220.0','4.41.60.255','美国 CZ88.NET'); INSERT INTO zxzx VALUES(23,'4.41.61.0','4.41.61.255','美国 EARTHLINK公司'); INSERT INTO zxzx VALUES(24,'4.41.62.0','4.43.68.255','美国 CZ88.NET'); INSERT INTO zxzx VALUES(25,'4.43.69.0','4.43.69.95','美国 罗斯门特学院'); INSERT INTO zxzx VALUES(26,'4.43.69.96','4.208.48.255','美国 Genuity用户'); INSERT INTO zxzx VALUES(27,'4.208.49.0','4.208.49.255','美国 加洲'); INSERT INTO zxzx VALUES(28,'4.208.50.0','4.237.255.255','美国 Genuity用户'); INSERT INTO zxzx VALUES(29,'4.238.0.0','4.239.255.255','美国 宾夕法尼亚州'); INSERT INTO zxzx VALUES(30,'4.240.0.0','4.255.255.255','美国 Genuity用户'); INSERT INTO zxzx VALUES(31,'5.0.0.0','5.147.255.255','IANA CZ88.NET'); INSERT INTO zxzx VALUES(32,'5.148.0.0','5.148.255.255','加拿大 CZ88.NET'); INSERT INTO zxzx VALUES(33,'5.149.0.0','5.255.255.255','IANA CZ88.NET'); INSERT INTO zxzx VALUES(34,'6.0.0.0','8.255.255.255','美国 DoD网络信息中心'); INSERT INTO zxzx VALUES(35,'9.0.0.0','9.255.255.255','美国 纽约IBM公司'); INSERT INTO zxzx VALUES(36,'10.0.0.0','10.255.255.255','局域网 对方和您在同一内部网'); INSERT INTO zxzx VALUES(37,'11.0.0.0','11.255.255.255','美国 DoD网络信息中心'); INSERT INTO zxzx VALUES(38,'12.0.0.0','12.0.47.255','美国 ATT用户'); INSERT INTO zxzx VALUES(39,'12.0.48.0','12.0.63.255','美国 哈佛大学'); INSERT INTO zxzx VALUES(40,'12.0.64.0','12.2.168.255','美国 ATT用户'); INSERT INTO zxzx VALUES(41,'12.2.169.0','12.2.169.255','美国 Leepfrog Technologies'); INSERT INTO zxzx VALUES(42,'12.2.170.0','12.3.133.255','美国 ATT用户'); INSERT INTO zxzx VALUES(43,'12.3.134.0','12.3.135.255','美国 Lycoming College'); INSERT INTO zxzx VALUES(44,'12.3.136.0','12.5.176.239','美国 ATT用户'); INSERT INTO zxzx VALUES(45,'12.5.176.240','12.5.176.255','美国 Friends University'); INSERT INTO zxzx VALUES(46,'12.5.177.0','12.6.207.255','美国 ATT用户'); INSERT INTO zxzx VALUES(47,'12.6.208.0','12.6.223.255','美国 哈佛大学'); INSERT INTO zxzx VALUES(48,'12.6.224.0','12.6.229.255','美国 ATT用户'); INSERT INTO zxzx VALUES(49,'12.6.230.0','12.6.231.255','美国 Marlboro College'); INSERT INTO zxzx VALUES(50,'12.6.232.0','12.11.138.255','美国 ATT用户'); INSERT INTO zxzx VALUES(51,'12.11.139.0','12.11.139.255','美国 南佛蒙特学院'); INSERT INTO zxzx VALUES(52,'12.11.140.0','12.13.176.127','美国 ATT用户'); INSERT INTO zxzx VALUES(53,'12.13.176.128','12.13.176.255','美国 Spelman College'); INSERT INTO zxzx VALUES(54,'12.13.177.0','12.16.215.255','美国 ATT用户'); INSERT INTO zxzx VALUES(55,'12.16.216.0','12.16.219.255','美国 太平洋联合学院'); INSERT INTO zxzx VALUES(56,'12.16.220.0','12.19.229.255','美国 ATT用户'); INSERT INTO zxzx VALUES(57,'12.19.230.0','12.19.230.255','美国 Houghton College'); INSERT INTO zxzx VALUES(58,'12.19.231.0','12.22.84.255','美国 ATT用户'); INSERT INTO zxzx VALUES(59,'12.22.85.0','12.22.85.255','美国 新泽西'); INSERT INTO zxzx VALUES(60,'12.22.86.0','12.22.177.255','美国 ATT用户'); INSERT INTO zxzx VALUES(61,'12.22.178.0','12.22.179.255','美国 First Technology Solutions'); INSERT INTO zxzx VALUES(62,'12.22.180.0','12.25.238.223','美国 ATT用户'); INSERT INTO zxzx VALUES(63,'12.25.238.224','12.25.238.255','美国 InFlow STL01'); INSERT INTO zxzx VALUES(64,'12.25.239.0','12.38.253.255','美国 ATT用户'); INSERT INTO zxzx VALUES(65,'12.38.254.0','12.38.254.31','美国 卡森纽曼学院'); INSERT INTO zxzx VALUES(66,'12.38.254.32','12.44.221.127','美国 ATT用户'); INSERT INTO zxzx VALUES(67,'12.44.221.128','12.44.221.255','美国 斯波丁尔大学'); INSERT INTO zxzx VALUES(68,'12.44.222.0','12.45.205.143','美国 ATT用户'); INSERT INTO zxzx VALUES(69,'12.45.205.144','12.45.205.159','美国 AAA AI SOFTWARE SOLUTIONS'); INSERT INTO zxzx VALUES(70,'12.45.205.160','12.73.85.255','美国 ATT用户'); INSERT INTO zxzx VALUES(71,'12.73.86.0','12.73.86.255','美国 休斯顿'); INSERT INTO zxzx VALUES(72,'12.73.87.0','12.107.33.191','美国 ATT用户'); INSERT INTO zxzx VALUES(73,'12.107.33.192','12.107.33.255','美国 Lenoir-Rhyne College'); INSERT INTO zxzx VALUES(74,'12.107.34.0','12.111.69.127','美国 ATT用户'); INSERT INTO zxzx VALUES(75,'12.111.69.128','12.111.69.255','美国 Springfield College'); INSERT INTO zxzx VALUES(76,'12.111.70.0','12.151.129.255','美国 ATT用户'); INSERT INTO zxzx VALUES(77,'12.151.130.0','12.151.130.255','美国 STONEHILL COLLEGE'); INSERT INTO zxzx VALUES(78,'12.151.131.0','12.153.51.255','美国 ATT用户'); INSERT INTO zxzx VALUES(79,'12.153.52.0','12.153.55.255','美国 哥伦比亚联合学院'); INSERT INTO zxzx VALUES(80,'12.153.56.0','12.154.115.255','美国 ATT用户'); INSERT INTO zxzx VALUES(81,'12.154.116.0','12.154.117.255','美国 BARBOURVILLE UTILITIES'); INSERT INTO zxzx VALUES(82,'12.154.118.0','12.154.159.255','美国 ATT用户'); INSERT INTO zxzx VALUES(83,'12.154.160.0','12.154.160.255','美国 Salve Regina University'); INSERT INTO zxzx VALUES(84,'12.154.161.0','12.159.255.255','美国 ATT用户'); INSERT INTO zxzx VALUES(85,'12.160.0.0','12.160.255.255','美国 新泽西'); INSERT INTO zxzx VALUES(86,'12.161.0.0','12.168.120.255','美国 ATT用户'); INSERT INTO zxzx VALUES(87,'12.168.121.0','12.168.121.255','美国 CARILION HEALTH SYSTEM'); INSERT INTO zxzx VALUES(88,'12.168.122.0','12.175.95.255','美国 ATT用户'); INSERT INTO zxzx VALUES(89,'12.175.96.0','12.175.96.7','美国 耶鲁大学'); INSERT INTO zxzx VALUES(90,'12.175.96.8','12.215.255.255','美国 ATT用户'); INSERT INTO zxzx VALUES(91,'12.216.0.0','12.216.255.255','美国 爱阿华州'); INSERT INTO zxzx VALUES(92,'12.217.0.0','12.255.255.255','美国 ATT用户'); INSERT INTO zxzx VALUES(93,'13.0.0.0','13.255.255.255','美国 Xerox'); INSERT INTO zxzx VALUES(94,'14.0.0.0','14.234.255.255','美国 ATT用户'); INSERT INTO zxzx VALUES(95,'14.235.0.0','14.235.255.255','美国 洛杉矶'); INSERT INTO zxzx VALUES(96,'14.236.0.0','14.255.255.255','美国 ATT用户'); INSERT INTO zxzx VALUES(97,'15.0.0.0','15.255.255.255','美国 Hewlett-Packard公司'); INSERT INTO zxzx VALUES(98,'16.0.0.0','16.255.255.255','美国 Digital'); INSERT INTO zxzx VALUES(99,'17.0.0.0','17.255.255.255','美国 Apple公司'); INSERT INTO zxzx VALUES(100,'18.0.0.0',