how to insert date into database using jsp?

Yes it was that!

  ResultSet rs=st.executeQuery(sql);  //                           ^^^

No! Use:

  ResultSet rs=st.executeQuery();

Or better

  st.executeUpdate();

When you call executeQuery(sql), you in fact call the inherited Statement.executeQuery that won't use your prepared statement at all.

sql oracle jsp

also you can write.

int returnval=st.executeUpdate();

Returns:either (1) the row count for SQL Data Manipulation Language (DML) statements or (2) 0 for SQL statements that return nothing

CodeHunter