java and oracle

i have my page in html in which there are textboxes and buttons for quering.in the text box if u enter the item code,(item codes and other information present in oracle database 10g),click the required button(view stock ,update item,delete item)it should display back the result in the same webpage but in different panel.

first doubt,r these statements correct:

String query ="SELECT "+stock+" FROM " + dress +"WHERE"+ item_code=textfield.value+";";

String queryupdate ="UPDATE" + dress +" SET "+item_code,category,price,stock+"="+"WHERE"+item_code=textfield.value+";";

String querydelete ="DELETE FROM"+ dress+"WHERE"+item_code=textfield.value+";";

how do u display the result obtained in the different panel on the same webpage?(for view stock)

[1089 byte] By [anya_aaa] at [2007-11-27 2:19:56]
# 1
> String query = "SELECT "+stock+" FROM " + dress + > "WHERE"+ item_code=textfield.value+";";use Prepared Statements.> how do u display the result obtained in > the different panel on the same webpage?(via the ResultSet object.
mlka at 2007-7-12 2:20:50 > top of Java-index,Java Essentials,Java Programming...
# 2
that i know via the ResultSetbut it should display in the HTML page in a specific layer
anya_aaa at 2007-7-12 2:20:50 > top of Java-index,Java Essentials,Java Programming...
# 3
> that i know via the ResultSet> but it should display in the HTML page in a specific> layerYour question is rather open ended. * Look up MVC? * a loop and some output.print( "<htmlystuff>" );?
mlka at 2007-7-12 2:20:50 > top of Java-index,Java Essentials,Java Programming...