Python 爬取 热词并进行分类数据分析-[云图制作+数据导入]
日期:2020.01.28
博客期:136
星期二
【本博客的代码如若要使用,请在下方评论区留言,之后再用(就是跟我说一声)】
所有相关跳转:
a.【简单准备】
b.【云图制作+数据导入】(本期博客)
c.【拓扑数据】
d.【数据修复】
e.【解释修复+热词引用】
f.【JSP演示+页面跳转】
g.【热词分类+目录生成】
h.【热词关系图+报告生成】
i . 【App制作】
j . 【安全性改造】
今天主要是在网上找学习网站,爬取方面就参照之前爬到的数据做了一个简单的云图信息展示(Java Web),但是老师要求最好是用APP或者微信小程序(你认真的吗?),我目前就知道使用 Android Studio 开发App 项目,使用官方的软件开发微信小程序。但已经有半年不动这方面的东西了。还有就是那个文档生成…这大数据的数据量要用来生成的doc文档大小我不敢想!!!究竟要怎样的完成需求呢?我还要花一段时间思考,可能还是要进一步咨询老师的需求… …
1、使用Navicat导入文件数据或者使用Java编写代码使其自动生成sql语句再添加
建表语句:
1 Create Table data 2 ( 3 name varchar(255) , 4 num int, 5 Primary Key (name) 6 )
CREATE
数据插入语句:(超长行数提醒!!!)
1 Insert into data VALUES (\'技术\',304); 2 Insert into data VALUES (\'开发\',237); 3 Insert into data VALUES (\'人工智能\',197); 4 Insert into data VALUES (\'数据\',165); 5 Insert into data VALUES (\'代码\',160); 6 Insert into data VALUES (\'开发者\',149); 7 Insert into data VALUES (\'程序员\',139); 8 Insert into data VALUES (\'开源\',115); 9 Insert into data VALUES (\'AI\',110); 10 Insert into data VALUES (\'云计算\',110); 11 Insert into data VALUES (\'工具\',105); 12 Insert into data VALUES (\'Python\',99); 13 Insert into data VALUES (\'技能\',99); 14 Insert into data VALUES (\'Windows\',91); 15 Insert into data VALUES (\'微软\',90); 16 Insert into data VALUES (\'华为\',90); 17 Insert into data VALUES (\'Java\',85); 18 Insert into data VALUES (\'编程语言\',85); 19 Insert into data VALUES (\'系统\',79); 20 Insert into data VALUES (\'互联网\',71); 21 Insert into data VALUES (\'操作系统\',70); 22 Insert into data VALUES (\'GitHub\',67); 23 Insert into data VALUES (\'5G\',66); 24 Insert into data VALUES (\'Linux\',65); 25 Insert into data VALUES (\'架构\',64); 26 Insert into data VALUES (\'机器学习\',63); 27 Insert into data VALUES (\'谷歌\',58); 28 Insert into data VALUES (\'苹果\',57); 29 Insert into data VALUES (\'数据库\',53); 30 Insert into data VALUES (\'软件\',51); 31 Insert into data VALUES (\'Android\',46); 32 Insert into data VALUES (\'芯片\',41); 33 Insert into data VALUES (\'网络\',39); 34 Insert into data VALUES (\'浏览器\',38); 35 Insert into data VALUES (\'大数据\',37); 36 Insert into data VALUES (\'Google\',36); 37 Insert into data VALUES (\'计算机\',34); 38 Insert into data VALUES (\'编程\',34); 39 Insert into data VALUES (\'趋势\',33); 40 Insert into data VALUES (\'研发\',33); 41 Insert into data VALUES (\'网络安全\',31); 42 Insert into data VALUES (\'功能\',30); 43 Insert into data VALUES (\'禁令\',26); 44 Insert into data VALUES (\'运营商\',25); 45 Insert into data VALUES (\'运维\',24); 46 Insert into data VALUES (\'JavaScript\',20); 47 Insert into data VALUES (\'IT\',19); 48 Insert into data VALUES (\'指标\',18); 49 Insert into data VALUES (\'企业\',18); 50 Insert into data VALUES (\'人生第一份工作\',18); 51 Insert into data VALUES (\'区块链\',17); 52 Insert into data VALUES (\'机器人\',17); 53 Insert into data VALUES (\'微信\',17); 54 Insert into data VALUES (\'iOS\',17); 55 Insert into data VALUES (\'服务器\',17); 56 Insert into data VALUES (\'微信半月刊\',17); 57 Insert into data VALUES (\'技术栈\',17); 58 Insert into data VALUES (\'科技\',16); 59 Insert into data VALUES (\'安全\',16); 60 Insert into data VALUES (\'设计\',16); 61 Insert into data VALUES (\'漏洞\',15); 62 Insert into data VALUES (\'腾讯\',15); 63 Insert into data VALUES (\'iPhone\',15); 64 Insert into data VALUES (\'行业\',15); 65 Insert into data VALUES (\'Web\',14); 66 Insert into data VALUES (\'手机\',14); 67 Insert into data VALUES (\'Oracle\',14); 68 Insert into data VALUES (\'多云\',14); 69 Insert into data VALUES (\'容器\',13); 70 Insert into data VALUES (\'算法\',13); 71 Insert into data VALUES (\'框架\',12); 72 Insert into data VALUES (\'混合云\',12); 73 Insert into data VALUES (\'标准\',12); 74 Insert into data VALUES (\'语言\',12); 75 Insert into data VALUES (\'裁员\',12); 76 Insert into data VALUES (\'智能\',11); 77 Insert into data VALUES (\'量子\',11); 78 Insert into data VALUES (\'Windows10\',11); 79 Insert into data VALUES (\'物联网\',11); 80 Insert into data VALUES (\'甲骨文\',11); 81 Insert into data VALUES (\'MySQL\',11); 82 Insert into data VALUES (\'CIO\',11); 83 Insert into data VALUES (\'深度学习\',11); 84 Insert into data VALUES (\'面试\',11); 85 Insert into data VALUES (\'Docker\',11); 86 Insert into data VALUES (\'工程师\',10); 87 Insert into data VALUES (\'App\',10); 88 Insert into data VALUES (\'前端\',10); 89 Insert into data VALUES (\'存储\',10); 90 Insert into data VALUES (\'SaaS\',10); 91 Insert into data VALUES (\'数据中心\',10); 92 Insert into data VALUES (\'工信部\',10); 93 Insert into data VALUES (\'PostgreSQL\',10); 94 Insert into data VALUES (\'亚马逊\',10); 95 Insert into data VALUES (\'SQL\',9); 96 Insert into data VALUES (\'Chrome\',9); 97 Insert into data VALUES (\'阿里\',9); 98 Insert into data VALUES (\'AWS\',9); 99 Insert into data VALUES (\'半导体\',9); 100 Insert into data VALUES (\'Redis\',9); 101 Insert into data VALUES (\'云\',9); 102 Insert into data VALUES (\'携号转网\',9); 103 Insert into data VALUES (\'应用程序\',9); 104 Insert into data VALUES (\'FaceBook\',9); 105 Insert into data VALUES (\'云平台\',9); 106 Insert into data VALUES (\'员工\',9); 107 Insert into data VALUES (\'跳槽那些事儿\',9); 108 Insert into data VALUES (\'Windows7\',8); 109 Insert into data VALUES (\'技巧\',8); 110 Insert into data VALUES (\'流量\',8); 111 Insert into data VALUES (\'数据科学\',8); 112 Insert into data VALUES (\'鸿蒙\',8); 113 Insert into data VALUES (\'超算\',8); 114 Insert into data VALUES (\'信息安全\',7); 115 Insert into data VALUES (\'安卓\',7); 116 Insert into data VALUES (\'智能手机\',7); 117 Insert into data VALUES (\'UOS\',7); 118 Insert into data VALUES (\'IBM\',7); 119 Insert into data VALUES (\'Gartner\',7); 120 Insert into data VALUES (\'量子计算机\',7); 121 Insert into data VALUES (\'移动系统\',6); 122 Insert into data VALUES (\'库克\',6); 123 Insert into data VALUES (\'隐私\',6); 124 Insert into data VALUES (\'公共云\',6); 125 Insert into data VALUES (\'Nginx\',6); 126 Insert into data VALUES (\'QQ\',6); 127 Insert into data VALUES (\'美国\',6); 128 Insert into data VALUES (\'应用\',6); 129 Insert into data VALUES (\'人脸识别\',5); 130 Insert into data VALUES (\'平台\',5); 131 Insert into data VALUES (\'攻击\',5); 132 Insert into data VALUES (\'恶意软件\',5); 133 Insert into data VALUES (\'优化\',5); 134 Insert into data VALUES (\'百度\',5); 135 Insert into data VALUES (\'数据泄露\',5); 136 Insert into data VALUES (\'4G\',5); 137 Insert into data VALUES (\'开源项目\',5); 138 Insert into data VALUES (\'边缘计算\',5); 139 Insert into data VALUES (\'PHP\',5); 140 Insert into data VALUES (\'黑客\',5); 141 Insert into data VALUES (\'密码\',5); 142 Insert into data VALUES (\'通信\',5); 143 Insert into data VALUES (\'云端\',5); 144 Insert into data VALUES (\'Hadoop\',5); 145 Insert into data VALUES (\'迁移\',5); 146 Insert into data VALUES (\'Springboot\',5); 147 Insert into data VALUES (\'云迁移\',5); 148 Insert into data VALUES (\'小程序\',4); 149 Insert into data VALUES (\'Kubernetes\',4); 150 Insert into data VALUES (\'电子商务\',4); 151 Insert into data VALUES (\'支付宝\',4); 152 Insert into data VALUES (\'5G手机\',4); 153 Insert into data VALUES (\'Kotlin\',4); 154 Insert into data VALUES (\'C++\',4); 155 Insert into data VALUES (\'移动互联网\',4); 156 Insert into data VALUES (\'私有云\',4); 157 Insert into data VALUES (\'阿里巴巴\',4); 158 Insert into data VALUES (\'公有云\',4); 159 Insert into data VALUES (\'C语言\',4); 160 Insert into data VALUES (\'网络攻击\',4); 161 Insert into data VALUES (\'乔布斯\',4); 162 Insert into data VALUES (\'分析\',4); 163 Insert into data VALUES (\'微服务\',4); 164 Insert into data VALUES (\'报告\',4); 165 Insert into data VALUES (\'高通\',4); 166 Insert into data VALUES (\'DevOps\',4); 167 Insert into data VALUES (\'分布式\',4); 168 Insert into data VALUES (\'移动\',4); 169 Insert into data VALUES (\'6G\',3); 170 Insert into data VALUES (\'性能\',3); 171 Insert into data VALUES (\'电脑\',3); 172 Insert into data VALUES (\'AR\',3); 173 Insert into data VALUES (\'国产操作系统\',3); 174 Insert into data VALUES (\'VSCode\',3); 175 Insert into data VALUES (\'微信支付\',3); 176 Insert into data VALUES (\'经济\',3); 177 Insert into data VALUES (\'5G牌照\',3); 178 Insert into data VALUES (\'手机厂商\',3); 179 Insert into data VALUES (\'平板电脑\',3); 180 Insert into data VALUES (\'金融\',3); 181 Insert into data VALUES (\'中国\',3); 182 Insert into data VALUES (\'爬虫\',3); 183 Insert into data VALUES (\'自动驾驶\',3); 184 Insert into data VALUES (\'网站\',3); 185 Insert into data VALUES (\'年薪\',3); 186 Insert into data VALUES (\'量子计算\',3); 187 Insert into data VALUES (\'职业\',3); 188 Insert into data VALUES (\'工作\',3); 189 Insert into data VALUES (\'项目\',3); 190 Insert into data VALUES (\'鸿蒙OS\',3); 191 Insert into data VALUES (\'创业\',3); 192 Insert into data VALUES (\'网络爬虫\',3); 193 Insert into data VALUES (\'云服务\',3); 194 Insert into data VALUES (\'脚本语言\',3); 195 Insert into data VALUES (\'iOS13\',3); 196 Insert into data VALUES (\'MongoDB\',3); 197 Insert into data VALUES (\'阿里云\',3); 198 Insert into data VALUES (\'函数\',3); 199 Insert into data VALUES (\'Go\',3); 200 Insert into data VALUES (\'搜索引擎\',3); 201 Insert into data VALUES (\'任正非\',3); 202 Insert into data VALUES (\'工资\',3); 203 Insert into data VALUES (\'中兴\',3); 204 Insert into data VALUES (\'硬件\',3); 205 Insert into data VALUES (\'小米\',3); 206 Insert into data VALUES (\'Word\',2); 207 Insert into data VALUES (\'iPhone11\',2); 208 Insert into data VALUES (\'线程\',2); 209 Insert into data VALUES (\'管理\',2); 210 Insert into data VALUES (\'网络钓鱼\',2); 211 Insert into data VALUES (\'云时代\',2); 212 Insert into data VALUES (\'ERP\',2); 213 Insert into data VALUES (\'协议\',2); 214 Insert into data VALUES (\'电池\',2); 215 Insert into data VALUES (\'程序\',2); 216 Insert into data VALUES (\'内存\',2); 217 Insert into data VALUES (\'薪资\',2); 218 Insert into data VALUES (\'月薪\',2); 219 Insert into data VALUES (\'隐私保护\',2); 220 Insert into data VALUES (\'5G通信\',2); 221 Insert into data VALUES (\'eSIM\',2); 222 Insert into data VALUES (\'IT部门\',2); 223 Insert into data VALUES (\'ElasticSearch\',2); 224 Insert into data VALUES (\'薪酬\',2); 225 Insert into data VALUES (\'离职\',2); 226 Insert into data VALUES (\'文章\',2); 227 Insert into data VALUES (\'CSS\',2); 228 Insert into data VALUES (\'预测\',2); 229 Insert into data VALUES (\'社交\',2); 230 Insert into data VALUES (\'SOC\',2); 231 Insert into data VALUES (\'安全运营中心\',2); 232 Insert into data VALUES (\'面部识别\',2); 233 Insert into data VALUES (\'工业互联网\',2); 234 Insert into data VALUES (\'图像识别\',2); 235 Insert into data VALUES (\'网络连接\',2); 236 Insert into data VALUES (\'TF\',2); 237 Insert into data VALUES (\'Mac\',2); 238 Insert into data VALUES (\'微博\',2); 239 Insert into data VALUES (\'电商\',2); 240 Insert into data VALUES (\'自动化\',2); 241 Insert into data VALUES (\'IT主管\',2); 242 Insert into data VALUES (\'观远数据\',2); 243 Insert into data VALUES (\'VisualStudio\',2); 244 Insert into data VALUES (\'HR\',2); 245 Insert into data VALUES (\'简历\',2); 246 Insert into data VALUES (\'麦肯锡\',2); 247 Insert into data VALUES (\'招聘\',2); 248 Insert into data VALUES (\'英特尔\',2); 249 Insert into data VALUES (\'AI芯片\',2); 250 Insert into data VALUES (\'网易\',2); 251 Insert into data VALUES (\'IPv4\',2); 252 Insert into data VALUES (\'经验\',2); 253 Insert into data VALUES (\'收集数据\',2); 254 Insert into data VALUES (\'搜索\',2); 255 Insert into data VALUES (\'岗位\',2); 256 Insert into data VALUES (\'虚拟化\',2); 257 Insert into data VALUES (\'Go语言\',2); 258 Insert into data VALUES (\'大学\',2); 259 Insert into data VALUES (\'缓存\',2); 260 Insert into data VALUES (\'双11\',2); 261 Insert into data VALUES (\'业务\',2); 262 Insert into data VALUES (\'数字化\',2); 263 Insert into data VALUES (\'规范\',2); 264 Insert into data VALUES (\'NoSQL\',2); 265 Insert into data VALUES (\'GitLab\',2); 266 Insert into data VALUES (\'中国移动\',2); 267 Insert into data VALUES (\'移动支付\',2); 268 Insert into data VALUES (\'IoT\',2); 269 Insert into data VALUES (\'数字化转型\',2); 270 Insert into data VALUES (\'华尔街\',2); 271 Insert into data VALUES (\'成本管理\',2); 272 Insert into data VALUES (\'数据分析师\',2); 273 Insert into data VALUES (\'VR\',2); 274 Insert into data VALUES (\'陷阱\',2); 275 Insert into data VALUES (\'统计\',2); 276 Insert into data VALUES (\'固态硬盘\',2); 277 Insert into data VALUES (\'BAT\',2); 278 Insert into data VALUES (\'Rust\',2); 279 Insert into data VALUES (\'数据结构\',2); 280 Insert into data VALUES (\'三星\',2); 281 Insert into data VALUES (\'辞退\',2); 282 Insert into data VALUES (\'车联网\',2); 283 Insert into data VALUES (\'数据存储\',2); 284 Insert into data VALUES (\'托管\',2); 285 Insert into data VALUES (\'信息泄露\',2); 286 Insert into data VALUES (\'内核\',2); 287 Insert into data VALUES (\'Fuchsia\',2); 288 Insert into data VALUES (\'虚拟机\',2); 289 Insert into data VALUES (\'CPU\',2); 290 Insert into data VALUES (\'汽车\',2); 291 Insert into data VALUES (\'制造业\',2); 292 Insert into data VALUES (\'红帽\',2); 293 Insert into data VALUES (\'NFC\',2); 294 Insert into data VALUES (\'鸿蒙系统\',2); 295 Insert into data VALUES (\'特朗普\',2); 296 Insert into data VALUES (\'下半场\',2); 297 Insert into data VALUES (\'Firefox\',2); 298 Insert into data VALUES (\'脸书\',2); 299 Insert into data VALUES (\'平板\',2); 300 Insert into data VALUES (\'iPadOS\',2); 301 Insert into data VALUES (\'客户\',2); 302 Insert into data VALUES (\'云安全\',2); 303 Insert into data VALUES (\'TensorFlow\',2); 304 Insert into data VALUES (\'996\',2); 305 Insert into data VALUES (\'Edge\',2); 306 Insert into data VALUES (\'WindowsXP\',1); 307 Insert into data VALUES (\'教程\',1); 308 Insert into data VALUES (\'Cookie\',1); 309 Insert into data VALUES (\'Token\',1); 310 Insert into data VALUES (\'Session\',1); 311 Insert into data VALUES (\'入职阿里\',1); 312 Insert into data VALUES (\'输入法\',1); 313 Insert into data VALUES (\'超宽带\',1); 314 Insert into data VALUES (\'iOS13.3.1\',1); 315 Insert into data VALUES (\'转型\',1); 316 Insert into data VALUES (\'技术人\',1); 317 Insert into data VALUES (\'赏金\',1); 318 Insert into data VALUES (\'大数据工程师\',1); 319 Insert into data VALUES (\'分析师\',1); 320 Insert into data VALUES (\'威胁\',1); 321 Insert into data VALUES (\'读书\',1); 322 Insert into data VALUES (\'现代化\',1); 323 Insert into data VALUES (\'营销\',1); 324 Insert into data VALUES (\'京东\',1); 325 Insert into data VALUES (\'优惠券\',1); 326 Insert into data VALUES (\'开放\',1); 327 Insert into data VALUES (\'春节红包\',1); 328 Insert into data VALUES (\'付费阅读\',1); 329 Insert into data VALUES (\'太赫兹\',1); 330 Insert into data VALUES (\'云数据库\',1); 331 Insert into data VALUES (\'出货\',1); 332 Insert into data VALUES (\'5G商用\',1); 333 Insert into data VALUES (\'传感器\',1); 334 Insert into data VALUES (\'无按键\',1); 335 Insert into data VALUES (\'360\',1); 336 Insert into data VALUES (\'DeepinOS\',1); 337 Insert into data VALUES (\'编码\',1); 338 Insert into data VALUES (\'Salesforce\',1); 339 Insert into data VALUES (\'设备商\',1); 340 Insert into data VALUES (\'SysFlow\',1); 341 Insert into data VALUES (\'以旧换新\',1); 342 Insert into data VALUES (\'回收价格\',1); 343 Insert into data VALUES (\'iPhone12\',1); 344 Insert into data VALUES (\'流程\',1); 345 Insert into data VALUES (\'职位晋升\',1); 346 Insert into data VALUES (\'年终考核\',1); 347 Insert into data VALUES (\'人脸识别硬件\',1); 348 Insert into data VALUES (\'2024年\',1); 349 Insert into data VALUES (\'应届生\',1); 350 Insert into data VALUES (\'手机导航\',1); 351 Insert into data VALUES (\'搜狐\',1); 352 Insert into data VALUES (\'IT安全\',1); 353 Insert into data VALUES (\'网络安全公司\',1); 354 Insert into data VALUES (\'总结\',1); 355 Insert into data VALUES (\'互联网江湖\',1); 356 Insert into data VALUES (\'达摩院\',1); 357 Insert into data VALUES (\'CES\',1); 358 Insert into data VALUES (\'首席信息官\',1); 359 Insert into data VALUES (\'王小琴\',1); 360 Insert into data VALUES (\'飞越旅行\',1); 361 Insert into data VALUES (\'董事长\',1); 362 Insert into data VALUES (\'5G体验\',1); 363 Insert into data VALUES (\'5G频谱\',1); 364 Insert into data VALUES (\'社区\',1); 365 Insert into data VALUES (\'居民\',1); 366 Insert into data VALUES (\'信息\',1); 367 Insert into data VALUES (\'故事\',1); 368 Insert into data VALUES (\'勒索软件\',1); 369 Insert into data VALUES (\'国产CAD\',1); 370 Insert into data VALUES (\'技术资讯\',1); 371 Insert into data VALUES (\'51CTO\',1); 372 Insert into data VALUES (\'中国企业年终评选\',1); 373 Insert into data VALUES (\'移动应用\',1); 374 Insert into data VALUES (\'CPU处理器\',1); 375 Insert into data VALUES (\'工业物联网\',1); 376 Insert into data VALUES (\'2020科技趋势\',1); 377 Insert into data VALUES (\'字符串\',1); 378 Insert into data VALUES (\'安全从业人员\',1); 379 Insert into data VALUES (\'联想\',1); 380 Insert into data VALUES (\'联想手机\',1); 381 Insert into data VALUES (\'Excel\',1); 382 Insert into data VALUES (\'产业大事记\',1); 383 Insert into data VALUES (\'网络购票\',1); 384 Insert into data VALUES (\'基因\',1); 385 Insert into data VALUES (\'微前端\',1); 386 Insert into data VALUES (\'前端工程师\',1); 387 Insert into data VALUES (\'运营\',1); 388 Insert into data VALUES (\'网约车\',1); 389 Insert into data VALUES (\'虚拟\',1); 390 Insert into data VALUES (\'商业模式\',1); 391 Insert into data VALUES (\'传统IT\',1); 392 Insert into data VALUES (\'企业资源计划\',1); 393 Insert into data VALUES (\'信息安全证书\',1); 394 Insert into data VALUES (\'Cortana\',1); 395 Insert into data VALUES (\'192号段\',1); 396 Insert into data VALUES (\'中国广电\',1); 397 Insert into data VALUES (\'集群\',1); 398 Insert into data VALUES (\'朋友圏评论\',1); 399 Insert into data VALUES (\'国创上头条\',1); 400 Insert into data VALUES (\'全面屏\',1); 401 Insert into data VALUES (\'保险\',1); 402 Insert into data VALUES (\'客户服务\',1); 403 Insert into data VALUES (\'WebKit\',1); 404 Insert into data VALUES (\'Pytorc\',1); 405 Insert into data VALUES (\'英语\',1); 406 Insert into data VALUES (\'国家电网\',1); 407 Insert into data VALUES (\'云游戏\',1); 408 Insert into data VALUES (\'Istio\',1); 409 Insert into data VALUES (\'服务网格\',1); 410 Insert into data VALUES (\'车次\',1); 411 Insert into data VALUES (\'春运\',1); 412 Insert into data VALUES (\'抢票\',1); 413 Insert into data VALUES (\'5G平板\',1); 414 Insert into data VALUES (\'服务平台\',1); 415 Insert into data VALUES (\'机器视觉\',1); 416 Insert into data VALUES (\'实践\',1); 417 Insert into data VALUES (\'图形\',1); 418 Insert into data VALUES (\'神经网络\',1); 419 Insert into data VALUES (\'开源社区\',1); 420 Insert into data VALUES (\'违规\',1); 421 Insert into data VALUES (\'高并发\',1); 422 Insert into data VALUES (\'秒杀\',1); 423 Insert into data VALUES (\'域名\',1); 424 Insert into data VALUES (\'.com\',1); 425 Insert into data VALUES (\'网络威胁\',1); 426 Insert into data VALUES (\'油管\',1); 427 Insert into data VALUES (\'电子产品\',1); 428 Insert into data VALUES (\'抖音\',1); 429 Insert into data VALUES (\'新零售\',1); 430 Insert into data VALUES (\'马云\',1); 431 Insert into data VALUES (\'5GiPhone\',1); 432 Insert into data VALUES (\'虚拟主机\',1); 433 Insert into data VALUES (\'Rambler\',1); 434 Insert into data VALUES (\'数据科学家\',1); 435 Insert into data VALUES (\'编程元知识\',1); 436 Insert into data VALUES (\'交通运输部\',1); 437 Insert into data VALUES (\'项目经理\',1); 438 Insert into data VALUES (\'运维工程师\',1); 439 Insert into data VALUES (\'IT技术\',1); 440 Insert into data VALUES (\'东南亚\',1); 441 Insert into data VALUES (\'数据服务\',1); 442 Insert into data VALUES (\'下架\',1); 443 Insert into data VALUES (\'基础设施\',1); 444 Insert into data VALUES (\'研发团队激励\',1); 445 Insert into data VALUES (\'数据画像\',1); 446 Insert into data VALUES (\'技术创业\',1); 447 Insert into data VALUES (\'双十一\',1); 448 Insert into data VALUES (\'天猫\',1); 449 Insert into data VALUES (\'商业价值\',1); 450 Insert into data VALUES (\'扎克伯格\',1); 451 Insert into data VALUES (\'IaaS\',1); 452 Insert into data VALUES (\'云计算标准和应用\',1); 453 Insert into data VALUES (\'云计算标准\',1); 454 Insert into data VALUES (\'账户\',1); 455 Insert into data VALUES (\'微软账户\',1); 456 Insert into data VALUES (\'支付宝机房宕机\',1); 457 Insert into data VALUES (\'网络故障\',1); 458 Insert into data VALUES (\'Sprint\',1); 459 Insert into data VALUES (\'个人信息\',1); 460 Insert into data VALUES (\'TalkingData\',1); 461 Insert into data VALUES (\'违法违规\',1); 462 Insert into data VALUES (\'电子合同\',1); 463 Insert into data VALUES (\'CA\',1); 464 Insert into data VALUES (\'电子认证\',1); 465 Insert into data VALUES (\'初创公司\',1); 466 Insert into data VALUES (\'中国银行\',1); 467 Insert into data VALUES (\'FaceID\',1); 468 Insert into data VALUES (\'MacBook\',1); 469 Insert into data VALUES (\'数据驱动\',1); 470 Insert into data VALUES (\'元航资本\',1); 471 Insert into data VALUES (\'榜单\',1); 472 Insert into data VALUES (\'摩根大通\',1); 473 Insert into data VALUES (\'本土\',1); 474 Insert into data VALUES (\'Canalys\',1); 475 Insert into data VALUES (\'商业智能\',1); 476 Insert into data VALUES (\'项目管理\',1); 477 Insert into data VALUES (\'转出\',1); 478 Insert into data VALUES (\'协作设计\',1); 479 Insert into data VALUES (\'领域驱动\',1); 480 Insert into data VALUES (\'R语言\',1); 481 Insert into data VALUES (\'数学\',1); 482 Insert into data VALUES (\'创造\',1); 483 Insert into data VALUES (\'聊天\',1); 484 Insert into data VALUES (\'语音交互\',1); 485 Insert into data VALUES (\'战略\',1); 486 Insert into data VALUES (\'问题\',1); 487 Insert into data VALUES (\'PPT\',1); 488 Insert into data VALUES (\'收藏\',1); 489 Insert into data VALUES (\'创新\',1); 490 Insert into data VALUES (\'IT架构\',1); 491 Insert into data VALUES (\'福利\',1); 492 Insert into data VALUES (\'阿里巴巴集团\',1); 493 Insert into data VALUES (\'设计模式\',1); 494 Insert into data VALUES (\'API\',1); 495 Insert into data VALUES (\'绝症\',1); 496 Insert into data VALUES (\'数据仓库\',1); 497 Insert into data VALUES (\'数据湖\',1); 498 Insert into data VALUES (\'资讯\',1); 499 Insert into data VALUES (\'ZorinOS15Lite\',1); 500 Insert into data VALUES (\'团队\',1); 501 Insert into data VALUES (\'全栈\',1); 502 Insert into data VALUES (\'教育\',1); 503 Insert into data VALUES (\'少儿编程\',1); 504 Insert into data VALUES (\'5G服务\',1); 505 Insert into data VALUES (\'5G套餐\',1); 506 Insert into data VALUES (\'PC\',1); 507 Insert into data VALUES (\'收入\',1); 508 Insert into data VALUES (\'VisualStudioCode\',1); 509 Insert into data VALUES (\'企业上云\',1); 510 Insert into data VALUES (\'多线程\',1); 511 Insert into data VALUES (\'云策略\',1); 512 Insert into data VALUES (\'东汉\',1); 513 Insert into data VALUES (\'语音识别\',1); 514 Insert into data VALUES (\'诈骗犯罪\',1); 515 Insert into data VALUES (\'OpenStack社区\',1); 516 Insert into data VALUES (\'Mirantis\',1); 517 Insert into data VALUES (\'笔记本\',1); 518 Insert into data VALUES (\'Wi-Fi6\',1); 519 Insert into data VALUES (\'AMDSVM\',1); 520 Insert into data VALUES (\'IntelV\',1); 521 Insert into data VALUES (\'技术周刊\',1); 522 Insert into data VALUES (\'号码\',1); 523 Insert into data VALUES (\'北极\',1); 524 Insert into data VALUES (\'组织\',1); 525 Insert into data VALUES (\'管理岗\',1); 526 Insert into data VALUES (\'RevokeMsgPatche\',1); 527 Insert into data VALUES (\'奖金\',1); 528 Insert into data VALUES (\'工业和信息化部\',1); 529 Insert into data VALUES (\'失败\',1); 530 Insert into data VALUES (\'收购\',1); 531 Insert into data VALUES (\'厂商\',1); 532 Insert into data VALUES (\'京东数科\',1); 533 Insert into data VALUES (\'IT职场\',1); 534 Insert into data VALUES (\'IT求职\',1); 535 Insert into data VALUES (\'IT技能\',1); 536 Insert into data VALUES (\'阿里云计算\',1); 537 Insert into data VALUES (\'拼多多\',1); 538 Insert into data VALUES (\'刷脸支付\',1); 539 Insert into data VALUES (\'云成本\',1); 540 Insert into data VALUES (\'安全感\',1); 541 Insert into data VALUES (\'优麒麟\',1); 542 Insert into data VALUES (\'中国联通\',1); 543 Insert into data VALUES (\'中国电信\',1); 544 Insert into data VALUES (\'enSilo\',1); 545 Insert into data VALUES (\'终端安全\',1); 546 Insert into data VALUES (\'Fortinet\',1); 547 Insert into data VALUES (\'共生关系\',1); 548 Insert into data VALUES (\'专家\',1); 549 Insert into data VALUES (\'产业新闻;十月大事\',1); 550 Insert into data VALUES (\'无人超市\',1); 551 Insert into data VALUES (\'接受风险\',1); 552 Insert into data VALUES (\'数据安全\',1); 553 Insert into data VALUES (\'内部威胁\',1); 554 Insert into data VALUES (\'Alphabet\',1); 555 Insert into data VALUES (\'Olmstead\',1); 556 Insert into data VALUES (\'密码法\',1); 557 Insert into data VALUES (\'生活冷知识人生第一份工作\',1); 558 Insert into data VALUES (\'优化策略\',1); 559 Insert into data VALUES (\'商业\',1); 560 Insert into data VALUES (\'IT创造力\',1); 561 Insert into data VALUES (\'Librem5\',1); 562 Insert into data VALUES (\'LinuxQQ\',1); 563 Insert into data VALUES (\'IT技术人员\',1); 564 Insert into data VALUES (\'Android9\',1); 565 Insert into data VALUES (\'手机号转账\',1); 566 Insert into data VALUES (\'解决方案\',1); 567 Insert into data VALUES (\'网络战\',1); 568 Insert into data VALUES (\'不完美妈妈\',1); 569 Insert into data VALUES (\'增强分析\',1); 570 Insert into data VALUES (\'数据分析\',1); 571 Insert into data VALUES (\'医药行业\',1); 572 Insert into data VALUES (\'云计算3.0\',1); 573 Insert into data VALUES (\'Droidcon\',1); 574 Insert into data VALUES (\'年度盛会\',1); 575 Insert into data VALUES (\'移动开发\',1); 576 Insert into data VALUES (\'敏捷\',1); 577 Insert into data VALUES (\'企业高管\',1); 578 Insert into data VALUES (\'无代码\',1); 579 Insert into data VALUES (\'低代码\',1); 580 Insert into data VALUES (\'IT支出\',1); 581 Insert into data VALUES (\'4G网络\',1); 582 Insert into data VALUES (\'折叠屏手机\',1); 583 Insert into data VALUES (\'AmazonAurora\',1); 584 Insert into data VALUES (\'费曼学习法\',1); 585 Insert into data VALUES (\'清华大学\',1); 586 Insert into data VALUES (\'好好学习\',1); 587 Insert into data VALUES (\'相册权限\',1); 588 Insert into data VALUES (\'通讯录\',1); 589 Insert into data VALUES (\'配置错误\',1); 590 Insert into data VALUES (\'汇编语言\',1); 591 Insert into data VALUES (\'周边业务\',1); 592 Insert into data VALUES (\'IT人员\',1); 593 Insert into data VALUES (\'认证\',1); 594 Insert into data VALUES (\'成本\',1); 595 Insert into data VALUES (\'2G手机\',1); 596 Insert into data VALUES (\'5G网络\',1); 597 Insert into data VALUES (\'门户网站\',1); 598 Insert into data VALUES (\'Bing\',1); 599 Insert into data VALUES (\'多云策略\',1); 600 Insert into data VALUES (\'云区域\',1); 601 Insert into data VALUES (\'云业务\',1); 602 Insert into data VALUES (\'Python开发\',1); 603 Insert into data VALUES (\'Python教程\',1); 604 Insert into data VALUES (\'旧手机\',1); 605 Insert into data VALUES (\'iTunes\',1); 606 Insert into data VALUES (\'监控\',1); 607 Insert into data VALUES (\'朋友圈\',1); 608 Insert into data VALUES (\'旅行\',1); 609 Insert into data VALUES (\'中国工厂\',1); 610 Insert into data VALUES (\'Andorid\',1); 611 Insert into data VALUES (\'GoogleCloud\',1); 612 Insert into data VALUES (\'云市场\',1); 613 Insert into data VALUES (\'TimCook\',1); 614 Insert into data VALUES (\'城市大数据\',1); 615 Insert into data VALUES (\'大数据平台\',1); 616 Insert into data VALUES (\'智慧城市\',1); 617 Insert into data VALUES (\'第二代\',1); 618 Insert into data VALUES (\'灾难恢复\',1); 619 Insert into data VALUES (\'中断\',1); 620 Insert into data VALUES (\'旅游\',1); 621 Insert into data VALUES (\'天翼云\',1); 622 Insert into data VALUES (\'微信电脑版\',1); 623 Insert into data VALUES (\'华为HC2019\',1); 624 Insert into data VALUES (\'多元化异构计算\',1); 625 Insert into data VALUES (\'异构计算\',1); 626 Insert into data VALUES (\'马化腾\',1); 627 Insert into data VALUES (\'产品\',1); 628 Insert into data VALUES (\'MicrosoftTeams\',1); 629 Insert into data VALUES (\'职场\',1); 630 Insert into data VALUES (\'IT人\',1); 631 Insert into data VALUES (\'高可用\',1); 632 Insert into data VALUES (\'消息系统\',1); 633 Insert into data VALUES (\'房贷\',1); 634 Insert into data VALUES (\'降薪\',1); 635 Insert into data VALUES (\'秋季发布会\',1); 636 Insert into data VALUES (\'手机互传\',1); 637 Insert into data VALUES (\'vivo\',1); 638 Insert into data VALUES (\'OPPO\',1); 639 Insert into data VALUES (\'版本\',1); 640 Insert into data VALUES (\'模板\',1); 641 Insert into data VALUES (\'调试\',1); 642 Insert into data VALUES (\'关机\',1); 643 Insert into data VALUES (\'命令\',1); 644 Insert into data VALUES (\'海康威视\',1); 645 Insert into data VALUES (\'TypeScript\',1); 646 Insert into data VALUES (\'思科\',1); 647 Insert into data VALUES (\'脚本\',1); 648 Insert into data VALUES (\'Bash\',1); 649 Insert into data VALUES (\'IBMFlashSystem900\',1); 650 Insert into data VALUES (\'Ubuntu\',1); 651 Insert into data VALUES (\'手机号\',1); 652 Insert into data VALUES (\'骚扰电话\',1); 653 Insert into data VALUES (\'号码标注\',1); 654 Insert into data VALUES (\'通信骗局\',1); 655 Insert into data VALUES (\'加班\',1); 656 Insert into data VALUES (\'WiFi\',1); 657 Insert into data VALUES (\'JSON\',1); 658 Insert into data VALUES (\'一线城市\',1); 659 Insert into data VALUES (\'数据保护\',1); 660 Insert into data VALUES (\'网站可靠性工程师\',1); 661 Insert into data VALUES (\'系统管理员\',1); 662 Insert into data VALUES (\'iPhone6\',1); 663 Insert into data VALUES (\'防火墙\',1); 664 Insert into data VALUES (\'云存储\',1); 665 Insert into data VALUES (\'智能家居\',1); 666 Insert into data VALUES (\'图\',1); 667 Insert into data VALUES (\'费马科技\',1); 668 Insert into data VALUES (\'图计算\',1); 669 Insert into data VALUES (\'鼠标\',1); 670 Insert into data VALUES (\'红帽公司\',1); 671 Insert into data VALUES (\'基础设施监控\',1); 672 Insert into data VALUES (\'Fedora\',1); 673 Insert into data VALUES (\'求职者\',1); 674 Insert into data VALUES (\'IT管理者\',1); 675 Insert into data VALUES (\'元数据\',1); 676 Insert into data VALUES (\'政治\',1); 677 Insert into data VALUES (\'Wi-Fi\',1); 678 Insert into data VALUES (\'DNS\',1); 679 Insert into data VALUES (\'Dashboard\',1); 680 Insert into data VALUES (\'网盘\',1); 681 Insert into data VALUES (\'MySQ\',1); 682 Insert into data VALUES (\'智能物联\',1); 683 Insert into data VALUES (\'数字\',1); 684 Insert into data VALUES (\'英伟达\',1); 685 Insert into data VALUES (\'JeffWilliams\',1); 686 Insert into data VALUES (\'大中华区执行董事\',1); 687 Insert into data VALUES (\'全球副总裁\',1); 688 Insert into data VALUES (\'张文翊\',1); 689 Insert into data VALUES (\'RedHa\',1); 690 Insert into data VALUES (\'游戏性能\',1); 691 Insert into data VALUES (\'Linux游戏\',1); 692 Insert into data VALUES (\'二维码\',1); 693 Insert into data VALUES (\'性别\',1); 694 Insert into data VALUES (\'物种\',1); 695 Insert into data VALUES (\'程序媛\',1); 696 Insert into data VALUES (\'跳槽\',1); 697 Insert into data VALUES (\'级别\',1); 698 Insert into data VALUES (\'开源软件\',1); 699 Insert into data VALUES (\'卖出\',1); 700 Insert into data VALUES (\'无服务器计算\',1); 701 Insert into data VALUES (\'防雷\',1); 702 Insert into data VALUES (\'雷劈\',1); 703 Insert into data VALUES (\'WindowsPhone\',1); 704 Insert into data VALUES (\'入职\',1); 705 Insert into data VALUES (\'KFS\',1); 706 Insert into data VALUES (\'KVDB\',1); 707 Insert into data VALUES (\'KSOne\',1); 708 Insert into data VALUES (\'国内\',1); 709 Insert into data VALUES (\'VDI\',1); 710 Insert into data VALUES (\'数据库排行\',1); 711 Insert into data VALUES (\'RAT\',1); 712 Insert into data VALUES (\'日志\',1); 713 Insert into data VALUES (\'操作\',1); 714 Insert into data VALUES (\'泼水\',1); 715 Insert into data VALUES (\'李彦宏\',1); 716 Insert into data VALUES (\'外包\',1); 717 Insert into data VALUES (\'云语言\',1); 718 Insert into data VALUES (\'顶会\',1); 719 Insert into data VALUES (\'博士生\',1); 720 Insert into data VALUES (\'「业务\',1); 721 Insert into data VALUES (\'劳动\',1); 722 Insert into data VALUES (\'中文版\',1); 723 Insert into data VALUES (\'iOS开发者\',1); 724 Insert into data VALUES (\'云原生\',1); 725 Insert into data VALUES (\'调度\',1); 726 Insert into data VALUES (\'刷单\',1); 727 Insert into data VALUES (\'网购好评\',1); 728 Insert into data VALUES (\'数据集成\',1); 729 Insert into data VALUES (\'数据转换\',1); 730 Insert into data VALUES (\'数据迁移\',1); 731 Insert into data VALUES (\'云计算提供商\',1); 732 Insert into data VALUES (\'专利\',1); 733 Insert into data VALUES (\'PTC\',1); 734 Insert into data VALUES (\'Creo6.0\',1); 735 Insert into data VALUES (\'Vue\',1); 736 Insert into data VALUES (\'消费者\',1); 737 Insert into data VALUES (\'辞职\',1); 738 Insert into data VALUES (\'企业安全\',1); 739 Insert into data VALUES (\'macOS\',1); 740 Insert into data VALUES (\'Adobe\',1); 741 Insert into data VALUES (\'危机\',1); 742 Insert into data VALUES (\'笔记本电脑\',1); 743 Insert into data VALUES (\'5G产业\',1); 744 Insert into data VALUES (\'折叠屏\',1); 745 Insert into data VALUES (\'货币\',1); 746 Insert into data VALUES (\'王新哲\',1); 747 Insert into data VALUES (\'容器化\',1); 748 Insert into data VALUES (\'新兴市场\',1); 749 Insert into data VALUES (\'流处理\',1); 750 Insert into data VALUES (\'无线电频谱\',1); 751 Insert into data VALUES (\'策略\',1); 752 Insert into data VALUES (\'中年人\',1); 753 Insert into data VALUES (\'越狱\',1); 754 Insert into data VALUES (\'云原生计算基金会\',1); 755 Insert into data VALUES (\'码农\',1); 756 Insert into data VALUES (\'会计师\',1); 757 Insert into data VALUES (\'商标\',1); 758 Insert into data VALUES (\'零售商\',1); 759 Insert into data VALUES (\'终端\',1); 760 Insert into data VALUES (\'IT团队\',1); 761 Insert into data VALUES (\'后厂村\',1); 762 Insert into data VALUES (\'GooglePlay\',1); 763 Insert into data VALUES (\'SD-WAN\',1); 764 Insert into data VALUES (\'云厂商\',1); 765 Insert into data VALUES (\'职位\',1); 766 Insert into data VALUES (\'云环境\',1); 767 Insert into data VALUES (\'数据治理\',1); 768 Insert into data VALUES (\'计算库\',1); 769 Insert into data VALUES (\'零售\',1); 770 Insert into data VALUES (\'开发者工具\',1); 771 Insert into data VALUES (\'智慧消防\',1); 772 Insert into data VALUES (\'光缆\',1); 773 Insert into data VALUES (\'挖掘机\',1); 774 Insert into data VALUES (\'标记\',1); 775 Insert into data VALUES (\'页面\',1); 776 Insert into data VALUES (\'静态\',1); 777 Insert into data VALUES (\'5月更新\',1); 778 Insert into data VALUES (\'应聘\',1); 779 Insert into data VALUES (\'华为人\',1); 780 Insert into data VALUES (\'IEEE\',1); 781 Insert into data VALUES (\'JEDEC协会\',1); 782 Insert into data VALUES (\'蓝牙联盟\',1); 783 Insert into data VALUES (\'WiFi联盟\',1); 784 Insert into data VALUES (\'纠纷\',1); 785 Insert into data VALUES (\'商业趋势\',1); 786 Insert into data VALUES (\'梅宏大数据\',1); 787 Insert into data VALUES (\'DBA\',1); 788 Insert into data VALUES (\'回忆\',1); 789 Insert into data VALUES (\'SQL语句\',1); 790 Insert into data VALUES (\'提速降费\',1); 791 Insert into data VALUES (\'社招\',1); 792 Insert into data VALUES (\'字节跳动\',1); 793 Insert into data VALUES (\'头条\',1); 794 Insert into data VALUES (\'飞聊\',1); 795 Insert into data VALUES (\'咨询\',1); 796 Insert into data VALUES (\'无人机\',1); 797 Insert into data VALUES (\'雷军\',1); 798 Insert into data VALUES (\'变软\',1); 799 Insert into data VALUES (\'挑战\',1); 800 Insert into data VALUES (\'美国政府\',1); 801 Insert into data VALUES (\'云基础架构\',1); 802 Insert into data VALUES (\'Winnti\',1); 803 Insert into data VALUES (\'权限\',1); 804 Insert into data VALUES (\'港科\',1); 805 Insert into data VALUES (\'微众银行\',1); 806 Insert into data VALUES (\'可视化\',1); 807 Insert into data VALUES (\'海思\',1); 808 Insert into data VALUES (\'原则\',1); 809 Insert into data VALUES (\'定律\',1); 810 Insert into data VALUES (\'反垄断\',1); 811 Insert into data VALUES (\'小冰\',1); 812 Insert into data VALUES (\'IT厂商\',1); 813 Insert into data VALUES (\'包装\',1); 814 Insert into data VALUES (\'流量资费\',1); 815 Insert into data VALUES (\'防护\',1); 816 Insert into data VALUES (\'ZombieLoad\',1); 817 Insert into data VALUES (\'赛门铁克\',1); 818 Insert into data VALUES (\'SAP\',1); 819 Insert into data VALUES (\'信用卡\',1); 820 Insert into data VALUES (\'AppleCard\',1); 821 Insert into data VALUES (\'网民\',1); 822 Insert into data VALUES (\'上市公司\',1); 823 Insert into data VALUES (\'台积电\',1); 824 Insert into data VALUES (\'A13\',1); 825 Insert into data VALUES (\'CDN\',1); 826 Insert into data VALUES (\'IDC\',1); 827 Insert into data VALUES (\'阴影者\',1); 828 Insert into data VALUES (\'Logo\',1); 829 Insert into data VALUES (\'垃圾短信\',1); 830 Insert into data VALUES (\'iMessage\',1); 831 Insert into data VALUES (\'演讲\',1); 832 Insert into data VALUES (\'SOCaaS\',1); 833 Insert into data VALUES (\'续费\',1); 834 Insert into data VALUES (\'欠薪\',1); 835 Insert into data VALUES (\'中国军备\',1); 836 Insert into data VALUES (\'加密技术\',1); 837 Insert into data VALUES (\'量子加密\',1); 838 Insert into data VALUES (\'无人驾驶\',1); 839 Insert into data VALUES (\'AppleStore\',1); 840 Insert into data VALUES (\'00后\',1); 841 Insert into data VALUES (\'90后\',1); 842 Insert into data VALUES (\'Orange\',1); 843 Insert into data VALUES (\'电信\',1); 844 Insert into data VALUES (\'巴菲特\',1); 845 Insert into data VALUES (\'大小核\',1); 846 Insert into data VALUES (\'远程医疗\',1); 847 Insert into data VALUES (\'医疗保健\',1); 848 Insert into data VALUES (\'扫码刷脸\',1); 849 Insert into data VALUES (\'苹果客服\',1); 850 Insert into data VALUES (\'LG\',1); 851 Insert into data VALUES (\'社保\',1); 852 Insert into data VALUES (\'社会保险\',1); 853 Insert into data VALUES (\'养老金\',1); 854 Insert into data VALUES (\'创业者\',1); 855 Insert into data VALUES (\'零售业\',1); 856 Insert into data VALUES (\'中关村\',1); 857 Insert into data VALUES (\'KOL\',1); 858 Insert into data VALUES (\'人才\',1); 859 Insert into data VALUES (\'手机基带\',1); 860 Insert into data VALUES (\'Intel\',1); 861 Insert into data VALUES (\'Debian10Buster\',1); 862 Insert into data VALUES (\'罗宾汉\',1); 863 Insert into data VALUES (\'谷歌云\',1); 864 Insert into data VALUES (\'密码过期\',1); 865 Insert into data VALUES (\'局域网\',1); 866 Insert into data VALUES (\'Git\',1); 867 Insert into data VALUES (\'设计团队\',1); 868 Insert into data VALUES (\'信息垃圾\',1); 869 Insert into data VALUES (\'技术人才\',1); 870 Insert into data VALUES (\'编译\',1); 871 Insert into data VALUES (\'获得场景视频\',1); 872 Insert into data VALUES (\'WOT\',1); 873 Insert into data VALUES (\'模拟器\',1); 874 Insert into data VALUES (\'分布式架构\',1); 875 Insert into data VALUES (\'Spark\',1); 876 Insert into data VALUES (\'成本优化\',1); 877 Insert into data VALUES (\'FinOps\',1);
Insert
2、接下来是找到ECharts的云图模板,利用Servlet配置数据成符合模板要求的样式。
下面是云图的具体实现步骤:
(1)、从官网下载Echarts的云图扩展包!
选择Download ZIP!
目标文件如下图:
获得文件后可以找到example文件夹里的实例看看用法,会了以后删掉就可以了!
(2)、打开Eclipse准备连接数据库的环境(包括我的连接数据库的Jar包)
先将页面设置好:
//数据对应传输Servlet代码
1 package com.servlet; 2 3 import java.io.IOException; 4 import java.sql.SQLException; 5 import java.util.List; 6 7 import javax.servlet.ServletException; 8 import javax.servlet.ServletOutputStream; 9 import javax.servlet.annotation.WebServlet; 10 import javax.servlet.http.HttpServlet; 11 import javax.servlet.http.HttpServletRequest; 12 import javax.servlet.http.HttpServletResponse; 13 14 import org.json.JSONArray; 15 import org.json.JSONObject; 16 17 import com.dblink.basic.utils.SqlUtils; 18 import com.dblink.basic.utils.sqlKind.MySql_s; 19 import com.dblink.basic.utils.user.UserInfo; 20 import com.dblink.bean.BeanGroup; 21 import com.dblink.sql.DBLink; 22 23 @SuppressWarnings("unused") 24 public class ServletForWords extends HttpServlet{ 25 /** 26 * 27 */ 28 private static final long serialVersionUID = 1L; 29 //----------------------------------------------------------------------// 30 public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException 31 { 32 request.setCharacterEncoding("utf-8"); 33 response.setCharacterEncoding("utf-8"); 34 response.setContentType("application/json"); 35 response.setHeader("Cache-Control", "no-cache"); 36 response.setHeader("Pragma", "no-cache"); 37 38 JSONArray jsonArray = new JSONArray(); 39 40 DBLink dbLink = new DBLink(new SqlUtils(new MySql_s("rc"),new UserInfo("root","123456"))); 41 BeanGroup bg = null; 42 try { 43 bg = dbLink.getSelect("Select * From data").beans; 44 int leng = bg.size(); 45 for(int i=0;i<leng;++i) 46 { 47 JSONObject jsonObject = new JSONObject(); 48 jsonObject.put("name",bg.get(i).get(0)); 49 jsonObject.put("value",bg.get(i).get(1)); 50 jsonArray.put(jsonObject); 51 } 52 } catch (SQLException e) { 53 // Do Nothing ... 54 } 55 dbLink.free(); 56 57 ServletOutputStream os = response.getOutputStream(); 58 os.write(jsonArray.toString().getBytes()); 59 os.flush(); 60 os.close(); 61 } 62 //---------------------------------------------------------------------------------// 63 }
ServletForWords.java
//云图对应js调用代码
1 function makePageToCl() 2 { 3 var Area = \'\'; 4 Area += \'<div class="row">\'; 5 Area += \'<div class="col-md-12">\'; 6 Area += \'<h2>热词云图</h2>\'; 7 Area += \'</div>\'; 8 Area += \'</div>\'; 9 Area += \'<hr />\'; 10 Area += \'<br>\'; 11 Area += \'<div id="MessageArea">\'; 12 Area += \' <div id="displayArea" style="width:1000px;height:500px;"></div>\'; 13 Area += \'</div>\'; 14 document.getElementById("page-inner").innerHTML = Area; 15 loadPartCloud(); 16 } 17 function loadPartCloud() 18 { 19 var xmlHttp = null; 20 try{ 21 xmlHttp = new XMLHttpRequest(); 22 } catch (e1) { 23 try { 24 xmlHttp = new ActiveXObject("Microsoft.XMLHTTP"); 25 } catch (e2) { 26 alert("Your browser does not support XMLHTTP!"); 27 return; 28 } 29 } 30 xmlHttp.onreadystatechange = function() { 31 if (xmlHttp.readyState == 4) { 32 if (xmlHttp.status == 200) 33 { 34 s = xmlHttp.responseText; 35 var InformationSet = eval(\'(\'+s+\')\'); 36 var leng = InformationSet; 37 var myChart = echarts.init(document.getElementById(\'displayArea\')); 38 39 var option = { 40 tooltip: {}, 41 series: [ { 42 type: \'wordCloud\', 43 gridSize: 2, 44 sizeRange: [12, 50], 45 rotationRange: [-90, 90], 46 shape: \'robot\', 47 width: 600, 48 height: 400, 49 drawOutOfBound: true, 50 textStyle: { 51 normal: { 52 color: function () { 53 return \'rgb(\' + [ 54 Math.round(Math.random() * 160), 55 Math.round(Math.random() * 160), 56 Math.round(Math.random() * 160) 57 ].join(\',\') + \')\'; 58 } 59 }, 60 emphasis: { 61 shadowBlur: 10, 62 shadowColor: \'#333\' 63 } 64 }, 65 data: leng 66 } ] 67 }; 68 69 myChart.setOption(option); 70 71 } 72 } 73 }; 74 var url ="../com/servlet/ServletForWords"; 75 76 xmlHttp.open("POST", url, true); 77 xmlHttp.setRequestHeader("Content-Type","application/x-www-form-urlencoded"); 78 xmlHttp.send(null); 79 }
cloud.js
最终云图效果展示:
看起来真的是难看,数据量大的坏处吗?
如果将Servlet中的sql语句换成 Select * From data where num > 6 ,就可以看到好看的了
最后我再皮一下,因为现在在玩《少女前线》手游,所以… …作业就用里面的角色来当作背景图吧!
1 function makePageToCl() 2 { 3 var Area = \'\'; 4 Area += \'<div class="row">\'; 5 Area += \'<div class="col-md-12">\'; 6 Area += \'<h2>热词云图</h2>\'; 7 Area += \'</div>\'; 8 Area += \'</div>\'; 9 Area += \'<hr />\'; 10 Area += \'<br>\'; 11 Area += \'<div id="MessageArea">\'; 12 Area += \' <div id="displayArea" style="width:1400px;height:2000px;"></div>\'; 13 Area += \'</div>\'; 14 document.getElementById("page-inner").innerHTML = Area; 15 loadPartCloud(); 16 } 17 function loadPartCloud() 18 { 19 var xmlHttp = null; 20 try{ 21 xmlHttp = new XMLHttpRequest(); 22 } catch (e1) { 23 try { 24 xmlHttp = new ActiveXObject("Microsoft.XMLHTTP"); 25 } catch (e2) { 26 alert("Your browser does not support XMLHTTP!"); 27 return; 28 } 29 } 30 xmlHttp.onreadystatechange = function() { 31 if (xmlHttp.readyState == 4) { 32 if (xmlHttp.status == 200) 33 { 34 s = xmlHttp.responseText; 35 var InformationSet = eval(\'(\'+s+\')\'); 36 var leng = InformationSet; 37 var maskImage = new Image(); 38 maskImage.src = \'../images/ump45.jpg\'; 39 var myChart = echarts.init(document.getElementById(\'displayArea\')); 40 41 var option = { 42 tooltip: {}, 43 series: [ { 44 type: \'wordCloud\', 45 gridSize: 2, 46 sizeRange: [12, 50], 47 rotationRange: [-90, 90], 48 maskImage: maskImage, 49 shape: \'pentagon\', 50 width: 1400, 51 height: 2000, 52 drawOutOfBound: true, 53 textStyle: { 54 normal: { 55 color: function () { 56 return \'rgb(\' + [ 57 Math.round(Math.random() * 160), 58 Math.round(Math.random() * 160), 59 Math.round(Math.random() * 160) 60 ].join(\',\') + \')\'; 61 } 62 }, 63 emphasis: { 64 shadowBlur: 10, 65 shadowColor: \'#333\' 66 } 67 }, 68 data: leng 69 } ] 70 }; 71 72 myChart.setOption(option); 73 74 } 75 } 76 }; 77 var url ="../com/servlet/ServletForWords"; 78 79 xmlHttp.open("POST", url, true); 80 xmlHttp.setRequestHeader("Content-Type","application/x-www-form-urlencoded"); 81 xmlHttp.send(null); 82 }
cloud.js
看Ump45!