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 :)