title: Problem in update query in JSP
body: <p>all, i am writing an update query in jsp, but i am having a syntax error in it, can anybody help please. here is the query</p>
  
  <pre><code>&lt;%
          HttpSession ss=request.getSession();
          String get_name=ss.getAttribute("key").toString().toUpperCase();
          if(get_name == null)
          {
              response.sendRedirect("index.jsp");
          }
          else{
      %&gt;
  
      &lt;h2 align="left" style="color: white"&gt;&lt;span style="background-color: blue"&gt;Welcome &lt;%=get_name%&gt;&lt;/span&gt;&lt;/h2&gt;
      &lt;%
              }
              int i=0;
              String id=ss.getAttribute("id").toString();
              int id_num=Integer.parseInt(id);
  
              Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
              Connection c=DriverManager.getConnection("jdbc:odbc:database");
              Statement s=c.createStatement();
  
              String name_server=request.getParameter("name_ser");
              String details_ser=request.getParameter("details_ser");
              String date_ser=request.getParameter("date_ser");
              String status_ser=request.getParameter("status_ser");
              String subject_ser=request.getParameter("subject_ser");
              String cost_ser=request.getParameter("cost_ser");
              JOptionPane.showMessageDialog(null, name_server+","+details_ser+","+date_ser+","+status_ser+","+subject_ser+","+cost_ser+","+id_num+","+i);
              i=s.executeUpdate("update RECORD set NAME='"+name_server+"' ,DETAILS='"+details_ser+"' ,DATEE='"+date_ser+"' ,Status='"+status_ser+"' ,Subject='"+subject_ser+"' ,COST='"+cost_ser+"' where ID="+id_num+"");
              c.close();
              s.close();
              if(i&gt;0)
              {
                  response.sendRedirect("welcome.jsp");
              }
      %&gt;        
  </code></pre>