Design and implementation of massive MYSQL data intelligent export system to excel by using Apache –POI libraries
Journal Title: IOSR Journals (IOSR Journal of Computer Engineering) - Year 2014, Vol 16, Issue 5
Abstract
Abstract: To export nearly 1,0000 attribute from database to excel of 10-20 column information of students and papers of database format into the target Excel sheet, we developed the intelligent export system which distinguished the simple export system. The system uses Netbeans/Eclipse as the development tool, object-oriented language java as the programming language, MySQL as the background database, POI-HSSF as the apache Library for reading & writing data from excel, used AWT and SWING for design of an application ,and uses the mysql-connector as connection technology to database. The system realizes to export the massive data of database into the Excel format intellectually that convenient for integrating and managing the multiple data required for regular examination process in the institutes and universities.HSSF is the POI Project's pure Java implementation of the Excel '97(-2007) file format. XSSF is the POI Project's pure Java implementation of the Excel 2007 OOXML (.xlsx) file format.HSSF and XSSF provide ways to read spreadsheets create, modify, read and write XLS spreadsheets.
Authors and Affiliations
Kamalakant L Bawankule , N B. Raut
Keywords
Related Articles
- EP ID EP131966
- DOI -
- Views 128
- Downloads 0
Quantum Cellular Automata Circuit Mixed Strategy Game Theoretic Optimization
Abstract : Gates and circuits made of Quantum Cellular Automata are subject to manufacturing errors due to imprecision of measurement. Our work examines the use of game theory optimization to correct Gaussian measurement...
Implementing Security algorithm to worm hole attack using AOMDV protocol & comparison using NS2 simulator
Abstract: In present era, where every person has become addicted to wireless networks, MANET’S has fulfilled the demand of the people by removing the dependency of fixed network. Mobile ad-hoc networks have extende...
Implementation of English-Text to Marathi-Speech (ETMS)Synthesizer
Abstract: This paper describes the Implementation of Natural Sounding Speech Synthesizer for MarathiLanguage using English Script. The natural synthesizer is developed using unit selection on the basis ofconcatenat...
Brain Tumor Detection through MR Images: A Review of Literature
Abstract: A brain tumor is an abnormal growth of tissue in the brain or central spine that can disrupt proper brain function and creates an increasing pressure in the brain. This paper is intended to present a comprehens...
Data attribute security and privacy in distributed database system
Now a days there are a need of data attribute security in distributed database while preserving privacy. In the proposed work, we consider problem related in publishing collaborative data for anonymizing,vertically and h...