摘要
设计一个动态可配置数据采集系统。该系统在Java Web开发平台上,利用Apache POI插件,开发出一套可以直接导入Excel数据模板文件并快速生成数据采集网页的Web应用程序。该数据采集网页可以根据用户的需求进行个性化的动态配置,然后通过QQ、微信和短信等多种方式向信息被采集人推送,被采集人可利用个人电脑、手机以及各类移动终端随时随地打开数据采集网页填写并提交信息,信息提交后即写入服务器端数据库,所有信息采集完毕后,可从系统中导出数据生成Excel文档。利用该系统,用户可在Excel文档和Web网页之间进行快速灵活的相互转换,使得原本费时费力的数据采集变得快捷方便,从而为未来的大数据分析提供充足而真实的数据源。
Abstract The paper designed a dynamic configurable data acquisition system.The system developed a template file that can directly import Excel data and quickly generate data collection page of Web application by using the Apache POI plug-in in Java Web development platform.The data acquisition page could also make a personalized dynamic configuration according to the customer’s demand,and then push the information to the collected one through QQ,WeChat,SMS and a variety of ways.The person who was being collected could open data collection page,fill in and submit the information anytime and anywhere by using a PC,mobile phone and all kinds of mobile terminal.The information was saved into the database of server after submission.And it could be derived Excel documents from the system data after all information gathering.Users could convert flexibly and quickly between Excel documents and Web pages by using the system which made the original time-consuming and laborious data collection quicker and easier,thus it provided sufficient and real data source for the future of data analysis
作者
丁俊
郑辉
Ding Jun;Zheng Hui(Computer and Art Institute,Anhui Technical College of Industry and Economy,Hefei 230051,Anhui,China)
出处
《计算机应用与软件》
北大核心
2018年第3期75-79,共5页
Computer Applications and Software
基金
2015年安徽省教育厅质量工程项目(2015zy114)
