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 80
- Downloads 0
Impact of Random Waypoint Mobility on Reactive Routing Protocols of Scalable Mobile Ad hoc Network
Abstract : Mobile Ad hoc networks are the self-configuring network, in which there is no centralized access point. The mobile nodes itself act as routers for one another. MANET is basically a wireless ad hoc network with...
Design and Simulation of Dct Chip In Vhdl and Application in Watermark Extraction
Abstract: The paper presented the design, modeling and chip implementation of 2D Discrete Cosine Transform (DCT) domain for copyright protection of images, as digital watermarking chip. Recent improvement in comput...
Comparative Study of RBFS & ARBFS Algorithm
RBFS is a best-first search that runs in space that is linear with respect to the maximum search depth, regardless of the cost function used. This algorithm allows the use of all available memory. One major ...
An Overview of Localization for Wireless Sensor Networks
Abstract: Localization is an important issue for location-dependent applications of wireless sensor networks. In Sensor networks, data collected by sensor nodes need to be tagged with time and location information. Local...
Multi-Tier Web Security on Web Applications from Sql Attacks
Abstract: This paper deals with the techniques that are used to prevent the web applications from web security vulnerabilities caused by hackers which leads to the misusage of data. Web services and applications ha...