Dynamically create table and insert data on the fly
Posted by: Yuhong Qian
Date: April 10, 2010 07:22AM

Hi, I am developing an Java standalone application that allows user to upload an EXCEL file into MySQL. The Excel file contains contact information.

The application is written in Swing and access MysQL by JDBC. The applicaiton provide a dialog to allow user to navigate to the EXECL file , and then read the EXECL file, create table based on the column names on the fly and move data from EXECL to database table.

The EXCEL table may have different column names and different column number. This requres the application can create table and insert data dynamicaly at run time.
At the same time, the application also need to have the ability to query the database table and show the data in Swing Jtable.

Any suggestion about how to create Mysql Table and insert resords dynamically?

Options: ReplyQuote


Subject
Written By
Posted
Dynamically create table and insert data on the fly
April 10, 2010 07:22AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.