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 116
- Downloads 0
An Approach For Identifying The Forest Fire Using Land Surface Imagery By Locating The Abnormal Temperature Distribution
Forest fires have a detrimental impact on economy and environment. The rapid distribution of the fire could cause many causalities and a lot of effort is required to control. To overcome this problem it is highly...
Design Approach to Big data Systems in Developing and Maintaining the Information Security Systems
Abstract: Data is accumulating from almost all aspects of our everyday lives that it becomes huge and multistructuredand has hidden useful information. The challenges with Big Data include capture, curation, storage, sea...
Using NP Problems to Share Keys in Secret-Key Cryptography
Abstract: Public key cryptography has now become an important means for providing confidentiality by its use of key distribution, in which users can do private communication with the help of encryption keys. It also prov...
Sentiment analysis for improving healthcare system for women
Abstract: The system proposes a feedback mechanism wherein, sentiment analysis is performed from surveys and tweets based on prevailing health issues among adult women in India and the social opinion on prevalenthealth i...
Passive Image Forensic Method to Detect Resampling Forgery inDigital Images
Abstract: The digital images are becoming important part in the field of information forensics and security,because of the popularity of image editing tools, digital images can be tampered in a very efficient mannerwitho...