hi
sir i m having problem in updating the record .

i m trying the query to update .but it is giving me the "
Syntax error problem"

Code:
 //stmt.executeUpdate("UPDATE StdInfo SET(STD_GR='"+gr+"', Name='"+name+"', Fname='"+fname+"', Surname='"+sname+"', Guardian-Name='"+gname+"', Religion='"+rel+"',Age='"+age+"',Date-of-Birth='"+dd+"',Month-of-Birth='"+mon+"',Year-of-Birth='"+year+"',Birth-Place='"+birthplace+"',Birth-District='"+bitrhdistrict+"',Country='"+country+"',Temp-Address='"+add+"',Perm-Address='"+padd+"',Phone='"+phone+"',Password='"+password+"') where STD_GR='"+gr+"'");
2nd

Code:
	stmt.executeUpdate("insert into StdInfo values('"+gr+"','"+name+"','"+fname+"','"+sname+"','"+gname+"','"+rel+"','"+age+"','"+dd+"','"+mon+"','"+year+"','"+birthplace+"','"+bitrhdistrict+"','"+country+"','"+add+"','"+padd+"','"+phone+"','"+password+"') where STD_GR='"+gr+"'");
	%>