Insert statement in Servlet JDBC program
Posted on 2004-03-21
I am new to oracle 9i on Windows.I have written a Servlet program which uses JDBC for insertion data in table maintained in Oralce Database.The query statements (like SELECT ) are running fine.But I encountered problem in Insert Statement in table created from command prompt. My code statement is:-
HttpServletRequest req;String Name,Email;
s.executeUpdate("INSERT INTO Table VALUES('"+Name+"','"+Email+"');");
I am getting Email and Name variable in browser but insertion is not taking place.
Insertion query is I think the syntax of query is correct.