javanerd21 0 Newbie Poster

please do inspect my code please, any error? in my net bean, its show the overall of the coding was red color.

here is the code :

<%--
    Document   : updateAssignment
    Created on : Jan 18, 2011, 2:09:56 PM
    Author     : Khalid Bin Dris 2008401558
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.util.*,java.sql.*" %>
  <%@ page language="java" import="javazoom.upload.*,java.util.*" %>
<%@ page errorPage="ExceptionHandler.jsp" %>
<%@page import="java.util.*" %>
<%@page import="java.lang.*" %>
<jsp:useBean id="idH" class="Entity.AssignmentMark" scope="request" />
<jsp:setProperty name="idHandler" property="*" />
<jsp:useBean id="upBean" scope="page" class="javazoom.upload.UploadBean" >
  <jsp:setProperty name="upBean" property="folderstore" value="C:\Users\Moon\Documents\NetBeansProjects\EAGM\web\UploadedFiles\AssignmentsMark" />
  <jsp:setProperty name="upBean" property="overwrite" value="true" />
</jsp:useBean>

<%
String assPath="" ;
      if (MultipartFormDataRequest.isMultipartFormData(request))
      {
         // Uses MultipartFormDataRequest to parse the HTTP request.
         MultipartFormDataRequest mrequest = new MultipartFormDataRequest(request);

         String comment=mrequest.getParameter("subInstComment");
         String mark = mrequest.getParameter("subMark");
         String percentage=mrequest.getParameter("subStudPercentage");
         String subid=mrequest.getParameter("subId");

         idH.setSubInstcomment(mrequest.getParameter("subInstComment"));
         idH.setSubmark(Integer.parseInt(mrequest.getParameter("subMark")));
         idH.setSubstudpercentage(Integer.parseInt(mrequest.getParameter("subStudPercentage")));


         String todo = null;
         if (mrequest != null) todo = mrequest.getParameter("todo");
	     if ( (todo != null) && (todo.equalsIgnoreCase("upload")) )
	     {
                Hashtable files = mrequest.getFiles();
                if ( (files != null) && (!files.isEmpty()) )
                {
                    UploadFile file = (UploadFile) files.get("uploadfile");
                    assPath+=file.getFileName();
                    idH.setSubassignmentfile(assPath);
                    if (file != null) //out.println("<li>Form field : uploadfile"+"<BR> Uploaded file : "+file.getFileName()+" ("+file.getFileSize()+" bytes)"+"<BR> Content Type : "+file.getContentType()+"directory: "+assPath);
                    // Uses the bean now to store specified by jsp:setProperty at the top.
                    upBean.store(mrequest, "uploadfile");

                }
	     }

   String sql="UPDATE SUBMISSION SET SUBINSTCOMMENT='"+comment;
   sql+="', SUBMARK='"+mark;
   sql+="', SUBSTUDPERCENTAGE='"+percentage;
   sql+="', SUBASSIGNMENTFILE='"+assPath;
   sql+="' WHERE SUBID='"+subid+"'";
   idH.updateSubmission(sql);
      }


   //String sql2="UPDATE SUBMISSION SET SUBINSTCOMMENT='mende nih?', SUBMARK='20',SUBSTUDPERCENTAGE='5',SUBASSIGNMENTFILE='Art_8_94.pdf' where SUBID='100000022'";


/*
idHandler.setSubinstcomment(request.getParameter("subInstComment"));
idHandler.setSubmark(Integer.parseInt(request.getParameter("subMark")));
idHandler.setSubstudpercentage(Integer.parseInt(request.getParameter("subStudPercentage")));
idHandler.setSubid(request.getParameter("subId"));


   String sql="UPDATE SUBMISSION SET SUBINSTCOMMENT='"+idHandler.getSubinstcomment();
   sql+="', SUBMARK='"+idHandler.getSubmark();
   sql+="', SUBSTUDPERCENTAGE='"+idHandler.getSubstudpercentage();
   sql+="' WHERE SUBID='"+idHandler.getSubid()+"'";

   idHandler.updateSubmission(sql);
*/
   response.sendRedirect("../boundary/instructorStudent.jsp");
%>

error at line 32,33,34,46,59

thanks :)