Adding Columns dynamically through UI

[hariharan jayaprakash]

How to add columns dynamically through UI?..

I am just doing simple exercises on Servlets and JSP's.

I have a doubt:

Created One table called "Product" and added few columns like "ID, Name etc"..

Now i want to add new columns through UI Itself, can we achieve tat?..

For ex: create a page called "Add column" , In that we have to provide

Column Name(Price) and Data type(Integer) for the new column .. once click on create button, It should create a new column in our existing table..

[Rob Spoor]

You'll need to execute an "ALTER TABLE" query. The exact syntax depends on the database server used, but in general it's something like this:
ALTER TABLE mytable ADD COLUMN newcolumn type NULLThat last NULL indicates the column can have NULL values. Use "NOT NULL" instead to indicate it cannot have NULL values, but that's only possible if you have no rows yet, unless you specify a default value:
ALTER TABLE mytable ADD COLUMN newcolumn type DEFAULT defaultvalue NOT NULLFinal part of the lesson: you can also change existing columns, to change the type, allow/disallow NULL values or change the default:
ALTER TABLE mytable ALTER COLUMN mycolumn newtype NOT NULL -- after you've set the value for all rows to require an explicit value ALTER TABLE mytable ALTER COLUMN mycolumn newtype DEFAULT defaultvalue NOT NULL

[hariharan jayaprakash]

I want to achieve this through User Interface Itself..

not like through query.. i want to do some logic in JDBC Code to add column dynamically..

Like I created one JSP

Column Name: ***
Data Type : ***

and add one button, when we click on tat button, i should add new column dynamically..

am i clear?

[Jan Cumps]

Yes. That is what Rob is suggesting.
The UI can grab what the user enters. Then, your code uses JDBC to send an ALTER TABLE... statement to your database.

[hariharan jayaprakash]

oh okay thanks .. i ll start tryin to implement..