International Journal of Advance Computational Engineering and Networking (IJACEN)
.
current issues
Volume-7, Issue-9  ( Sep, 2019 )
Past issues
  1. Volume-7, Issue-8  ( Aug, 2019 )
  2. Volume-7, Issue-7  ( Jul, 2019 )
  3. Volume-7, Issue-6  ( Jun, 2019 )
  4. Volume-7, Issue-5  ( May, 2019 )
  5. Volume-7, Issue-4  ( Apr, 2019 )
  6. Volume-7, Issue-3  ( Mar, 2019 )
  7. Volume-7, Issue-2  ( Feb, 2019 )
  8. Volume-7, Issue-1  ( Jan, 2019 )
  9. Volume-6, Issue-12  ( Dec, 2018 )
  10. Volume-6, Issue-11  ( Nov, 2018 )

Statistics report
Nov. 2019
Submitted Papers : 80
Accepted Papers : 10
Rejected Papers : 70
Acc. Perc : 12%
Issue Published : 80
Paper Published : 1200
No. of Authors : 3014
  Journal Paper

Paper Title
Design And Implementation Of Massive Excel Data Intelligent Import System To Database (Mysql) By Using Libraries

Abstract
Abstract—To import nearly 1,0000 to attribute to the tables of 10-20 column information of students and papers database of Excel format into the target tables of MySQL database, we developed the intelligent import system which distinguished the simple import 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 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 import the massive data of Excel format into the MySQL database 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.


Author - Kamalakant L Bawankule, N B. Raut

| PDF |
Viewed - 39
| Published on 2014-05-16
   
   
IRAJ Other Journals
IJACEN updates
Paper Submission is open now for upcoming Issue.
The Conference World

JOURNAL SUPPORTED BY