To update

try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:university","SYSTEM","12345");

String name=request.getParameter("name");
String duration=request.getParameter("duration");
String subject=request.getParameter("subject");
String fee=request.getParameter("fee");
String code=request.getParameter("code");


String query = "update COURSE set NAME =?,DURATION=?,SUBJECT=?,TOTAL_FEE=? where COURSE_CODE=? ";
PreparedStatement pstmt = con.prepareStatement(query); // create a statement
pstmt.setString(1,name);
pstmt.setString(2,duration);
pstmt.setString(3,subject);
pstmt.setString(4,fee);
pstmt.setString(5,code);


pstmt.executeUpdate();
} catch(Exception e) {
e.printStackTrace();

}
%>