How to insert date into database using jsp?

Question

I am trying to insert a date into a database with a query that I am making in java, but I am getting this error

java.sql.SQLException: ORA-03115: unsupported network data type or view

String req=request.getParameter("date");

try
{
      SimpleDateFormat d=new SimpleDateFormat("dd/MM/yyyy");
      Date dt=d.parse(req);          

      java.sql.Date sqlDate = new java.sql.Date(dt.getTime());    

      Class.forName("oracle.jdbc.driver.OracleDriver");
      Connection co=null;
      co=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","java","java");
      String sql="insert Into login_table(date_dt)values(?)";        

      PreparedStatement st=co.prepareStatement(sql);
      st.setDate(1, sqlDate);
      ResultSet rs=st.executeQuery(sql);
}
catch(Exception xe)
{
     out.println(xe);
}

but I do not understand what I am doing wrong.

Answer 1

Yes it was!

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

No! Using:

  ResultSet rs=st.executeQuery();

Or better

  st.executeUpdate();

---

When you call executeQuery(sql), you are actually calling an inherited Statement.executeQueryone that your prepared statement will not use at all.

Answer 2

also you can write.

int returnval=st.executeUpdate();

: (1) SQL Data Manipulation Language (DML) (2) 0 SQL,