hi,
I have a jsp page

i have used following prepared Statement for the update in database.

Can any one tell me that,How can i use date in following method.

I have 4 field for date as given below:(BOLD shown)

I have used String in that place.

It is not working.




PreparedStatement pstatement = conn.prepareStatement(
"UPDATE sec_mast SET catg_code=?, vou_no=?, vou_date=?, vou_amt=?, due_date1=?, due_date2=?, mat_date=? where sec_no=? ");

pstatement.setInt(1,Integer.parseInt(request.getPa rameter("catg_code")));
pstatement.setString(2,request.getParameter("vou_n o"));
pstatement.setString(3,request.getParameter("vou_d ate"));
pstatement.setInt(4,Integer.parseInt(request.getPa rameter("vou_amt")));
pstatement.setString(5,request.getParameter("due_d ate1"));
pstatement.setString(6,request.getParameter("due_d ate2"));
pstatement.setString(7,request.getParameter("mat_d ate"));
pstatement.setInt(8,Integer.parseInt(request.getPa rameter("sec_no")));


int rowCount = pstatement.executeUpdate();
conn.setAutoCommit(false);
conn.setAutoCommit(true);
}

plz help me

Check your Data type conversion like java.sql.Date & Date

Gokulan Ethiraj

U can set date by using this method :-
void setDate(int parameterIndex, Date x)
Sets the designated parameter to the given java.sql.Date value.

Have a look on this URL for more details on java.sql.PreparedStatement :-
http://java.sun.com/j2se/1.4.2/docs/...Statement.html