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 106
- Downloads 0
Analysis of Image and Video Using Color, Texture and ShapeFeatures for Object Identification
Abstract: The recent developments in cognitive sciences and Artificial Intelligence has made possible theprocess of automation in object detection and recognition using various low level visual features used torepr...
Load Balancing In Cloud Computing:A Review
As the IT industry is growing day by day, the need of computing and storage is increasing rapidly. The amount of data exchanged over the network is constantly increasing. Thus the process of this increasi...
A System for Task Scheduling and Task Migration in Cloud Environment
Abstract: Large scale data processing is increasingly common in cloud computing systems in recent years. In these systems, files are split into many small blocks and all blocks are replicated over several servers....
A New Web Document Retrieval Method Using Extended-IOWA (Extended-Induced Ordered Weighted Averaging) Operator on HTML Tags
Abstract: A new scenario has arisen into the information retrieval (IR) field with the increase in the use of mark-up languages. This paper targets structured IR and is focused on documents with structure. This assumptio...
Propose Data Mining AR-GA Model to Advance Crime analysis
Historically solving crimes has been the privilege of the criminal justice and law enforcement specialists. With the increasing use of the computerized systems to track crimes, computer data analysts have sta...