inserting values in the oracle 9i database through a JSP page.

[ghai_gaurav205]

can anyone please tell me what is the syntax for inserting values in the oracle 9i database through a JSP page.
say i have a table named student with attributes name, age, city.

[BigDog]

you will need to use JDBC (http://java.sun.com/products/jdbc/), regardless if it is in a JSP page . If you are using a full J2EE container then you are better off using a data source and entity bean (or other persistance framework like Hibernate)

[ghai_gaurav205]

you will need to use JDBC (http://java.sun.com/products/jdbc/), regardless if it is in a JSP page . If you are using a full J2EE container then you are better off using a data source and entity bean (or other persistance framework like Hibernate)


i am using jdbc, but i am not able to insert records. so can u please give an example.

[Khalid Ali]

you need to show us your code so that one can tell whats going on....there could be allots of things that can go wrong...
1. JDBC connectivity problem
2. Wrong sql statement etc etc