I am designing a GUI for DB operations.I am facing a problem while inserting data.
I have retrieve all the columns from table and then depending on the type I have to give the values for the fields to insert data.
Kindly help me with any ideas.
I am using java swings in netbeans.
let me be clear with the question.
See the user just types in the table name and he doesn't know any thing about the fields in the table.I think for this we need the desc of the table and then looking at the desc he would enter data.This is purely gui based DB operations.From the front end only the user can operate on database.