Drag and Drop Excel Column to Database Column in JSP
Posted on 2006-07-14
Maybe I'm trying to do the impossible.
I have developed a desktop application that allows the user to select an Excel spreadsheet and a MySql table. On the left side of the screen, all of the columns for the selected table are displayed. On the right side of the screen, all of the columns for the selected spreadsheet are displayed (along with some data that can be browsed).
The user can then drag the Excel column, from the right, to the row containing the corresponding table column on the left. When they let go, the name of the Excel column is placed in an empty "cell" next to the table column name.
Once all columns are selected, they then click on an "import" button and the data found in the Excel columns that have been selected for importing are imported into the table (into the table columns that they were placed next to, i.e. if Excel column Boots was dropped on MySql table column Cloths, all the data in the Boots Excel column is inserted into the MySql table in column Cloths).
Long story short, is there any way that this can be done using Java and JSP? I am attempting to re-write the application to make it web based, but this one function could be a show stopper. Thanks in advance for your help.