Untitled

<%
 try{
 if(session.getAttribute("ses_uname").toString().length()==0){
    out.println("You are not Authorised User-try properly");
    //this.destroy();
 }
}catch(Exception e){
    out.println("You are not Authorised User-try properly");%>
<jsp:forward page="./index.jsp"/><%

}


%>
    <%

            int mcole;
            String mcoleName=new String();
            String madd1=new String();
            String madd2=new String();
            String madd3=new String();
            String mColephone=new String();
            String mfax=new String();
            String memail=new String();
            String mdsnName=new String();
            String mimage=new String();
            String mdataUID=new String();
            String mdataPass=new String();

              //mcole =Integer.parseInt(session.getAttribute("coleCode") );
              mcoleName= String.valueOf(session.getAttribute("coleName") );
              madd1= String.valueOf(session.getAttribute("add1")) ;
              madd2=String.valueOf( session.getAttribute("add2")) ;
              madd3= String.valueOf(session.getAttribute("add3")) ;
              mColephone= String.valueOf(session.getAttribute("phone")) ;
              mfax= String.valueOf(session.getAttribute("fax") );
              memail= String.valueOf(session.getAttribute("memail")) ;
              mdsnName=String.valueOf( session.getAttribute("dsnName")) ;
              mimage=String.valueOf(session.getAttribute("logo") );

    %>

<%@ page import="java.io.*,javax.servlet.http.HttpServletRequest,javax.servlet.ServletInputStream" %>
<%@ page import="java.io.FileWriter,java.io.IOException" %>
<%@page import ="java.util.Date,java.text.SimpleDateFormat"%>
<%@ page import="java.io.*, java.lang.*" %>
<%@ page import="java.sql.*" %>
<%@page import ="java.util.Date"%>
<%@ page import="org.apache.poi.hssf.usermodel.*"%>


    <P align=center style="color:#990000;"><FONT
 color="#990000" size=5><img src=<%=mimage%> border="0">
<html>
    <head>
        <title>
            Examination Marks Entry / Modify
        </title>
    </head>

    <body bgcolor="#dbe7fb">


<p align="right" style="font-size:10pt;"  ><a href="aerpLogOut.jsp">Log Out</a></p>
<%
	String savePath = "", filepath = "", filename ="";
	String contentType = "", fileData = "", strLocalFileName = "";
	int startPos = 0, endPos = 0;
	int BOF = 0, EOF = 0;
    String fixfname="";
%>
<%!
	//copy specified number of bytes from main data buffer to temp data buffer
	void copyByte(byte [] fromBytes, byte [] toBytes, int start, int len)
	{
		for(int i=start;i<(start+len);i++)
		{
			toBytes[i - start] = fromBytes[i];
		}
	}
%>

<%
	contentType = request.getContentType();
//	out.println("<br>Content type is :: " +contentType);
	if ((contentType != null) && (contentType.indexOf("multipart/form-data") >= 0))
	{
		DataInputStream in = new DataInputStream(request.getInputStream());
		DataInputStream in1 = in;
		int formDataLength = request.getContentLength();
        //out.println(formDataLength);
		byte dataBytes[] = new byte[formDataLength];
		int byteRead = 0;
		int totalBytesRead = 0;
		while (totalBytesRead < formDataLength)
		{
			byteRead = in1.read(dataBytes, totalBytesRead, formDataLength);
			totalBytesRead += byteRead;
		}
//		out.println("<br>totalBytesRead : " + totalBytesRead + "    :   formDataLength = " + formDataLength);

//		String file = new String(dataBytes);
//		out.println("<br>File Contents:<br>////////////////////////////////////<br>" + file + "<br>////////////////////////////////<br>");

		byte[] line = new byte[128];
		if (totalBytesRead < 3)
		{
		  return;	//exit if file length is not sufficiently large
		}

		String boundary = "";
		String s = "";
		int count = 0;
		int pos = 0;

		//loop for extracting boundry of file
		//could also be extracted from request.getContentType()
		do
		{
			copyByte(dataBytes, line, count ,1);	//read 1 byte at a time
			count+=1;
			s = new String(line, 0, 1);
			fileData = fileData + s;
			pos = fileData.indexOf("Content-Disposition: form-data; name=\""); //set the file name
			if(pos != -1)
				endPos = pos;
		}while(pos == -1);
		boundary = fileData.substring(startPos, endPos);

		//loop for extracting filename
		startPos = endPos;
		do
		{
			copyByte(dataBytes, line, count ,1);	//read 1 byte at a time
			count+=1;
			s = new String(line, 0, 1);
			fileData = fileData + s;
			pos = fileData.indexOf("filename=\"", startPos); //set the file name
			if(pos != -1)
				startPos = pos;
		}while(pos == -1);
		do
		{
			copyByte(dataBytes, line, count ,1);	//read 1 byte at a time
			count+=1;
			s = new String(line, 0, 1);
			fileData = fileData + s;
			pos = fileData.indexOf("Content-Type: ", startPos);
			if(pos != -1)
				endPos = pos;
		}while(pos == -1);
		filename = fileData.substring(startPos + 10, endPos - 3);	//to eliminate " from start & end
        fixfname=filename;
		strLocalFileName = filename;
		int index = filename.lastIndexOf("\\");
		if(index != -1)
			filename = filename.substring(index + 1);
		else
			filename = filename;

		//loop for extracting ContentType
		boolean blnNewlnFlag = false;
		startPos = endPos;	//added length of "Content-Type: "
		do
		{
			copyByte(dataBytes, line, count ,1);	//read 1 byte at a time
			count+=1;
			s = new String(line, 0, 1);
			fileData = fileData + s;
			pos = fileData.indexOf("\n", startPos);
			if(pos != -1)
			{
				if(blnNewlnFlag == true)
					endPos = pos;
				else
				{
					blnNewlnFlag = true;
					pos = -1;
				}
			}
		}while(pos == -1);
		contentType = fileData.substring(startPos + 14, endPos);

		//loop for extracting actual file data (any type of file)
		BOF = count + 1;

		do
		{
			copyByte(dataBytes, line, count ,1);	//read 1 byte at a time
			count+=1;
			s = new String(line, 0, 1);
			fileData = fileData + s;
			pos = fileData.indexOf(boundary, startPos);	//check for end of file data i.e boundry value
            //out.println(count+"<br>");
		}while(pos == -1);
		EOF = count - boundary.length();
       // out.println(fileData);
		//file data extracted

	/*	out.println("<br><br>0. Local File Name = " + strLocalFileName);
		out.println("<br><br>1. filename = " + filename);
		out.println("<br>2. contentType = " + contentType);
		out.println("<br>3. startPos = " + BOF);
		out.println("<br>4. endPos = " + EOF);
		out.println("<br>5. boundary = " + boundary);
        */


		//create destination path & save file there
		String appPath = application.getRealPath("/");
	//	out.println("<br>appPath : " + appPath);
		String destFolder = appPath + "marksfile/"+session.getAttribute("coleCode").toString().trim().concat("/");	//change this as required
        //String destFolder = "/images/photo/";	//change this as required
        String mlname=fixfname.substring(fixfname.length()-4,fixfname.length());
        java.util.Date date= new java.util.Date();
		filename= destFolder + "f"+date.getTime() +mlname;


//String date1_2=String.valueOf(date);
//int date1=Integer.parseInt(date1_2.substring(date1_2.length()-4,date1_2.length()));
//        String filename1="";
 //       filename1=destFolder+mdeptcode.concat("_").concat(String.valueOf(date1)).concat(".jpg");
  //      out.println(filename);
        try{
        //FileWriter fstream = new FileWriter("/home/iemcrp/public_html/iemEn/xx.jpg");
        //fstream.close();
        out.println(dataBytes);

		FileOutputStream fileOut = new FileOutputStream(filename);
//			byteRead = in1.read(dataBytes, totalBytesRead, formDataLength);

		//fileOut.write(dataBytes, BOF, (EOF - BOF));

		//fileOut.write(dataBytes, BOF, EOF );
        //fileOut.write(dataBytes, BOF, boundary.length());

		fileOut.write(dataBytes, BOF, (EOF - BOF));


		fileOut.flush();
		fileOut.close();
        }catch(Exception ext){
            out.println("Error - to Upload");
        }
		//out.println("<br>File saved as >> " + filename);
/*		FileOutputStream fileOut1 = new FileOutputStream(filename1);
		fileOut1.write(dataBytes, BOF, (EOF - BOF));
		fileOut1.flush();
		fileOut1.close();
        */


%>
<p align="center">


</p>
<%
try{
//String filePathOnServer= application.getRealPath("main.csv"); //here main.csv in root folder.  FileInputStream fis = new FileInputStream(filePathOnServer); DataInputStream dis = new DataInputStream(fis); //Following code may required some tweaking because I have used readLine() in different manner.while(dis.readLine()){      //Split the line and assign to array than validate and save to db      //Here you can use class object for each line} String filePathOnServer= application.getRealPath("main.csv"); //here main.csv in root folder.

   String fName = filename;
   String muser=session.getAttribute("ses_uname").toString();
     String thisLine;
//      int count=0;
      FileInputStream fis = new FileInputStream(fName);
      DataInputStream myInput = new DataInputStream(fis);
      int i=0;
      %>
<%@ page import="java.sql.*" %>
<%@ page import="java.text.Format"%>
<%@page import ="java.util.Date,java.text.SimpleDateFormat"%>

<%
try{
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
//String dbUrl_sub="jdbc:odbc:".concat(mdsnName);
//Connection connl_sub = DriverManager.getConnection(dbUrl_sub,mdataUID,mdataPass) ;
            boolean chkOS;
            String mos=(System.getProperty("os.name"));
            chkOS = mos.startsWith("Windows");
            Connection connl_sub;
            String dbUrl_sub="jdbc:odbc:sis";
            if (chkOS==true){
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
                 dbUrl_sub="jdbc:odbc:".concat(mdsnName);
                 connl_sub = DriverManager.getConnection(dbUrl_sub,mdataUID,mdataPass) ;

            } else{
                   dbUrl_sub="jdbc:mysql://localhost/iemcrp_iemen?user=iemcrp_sourav&password=piku3976";
                   Class.forName("org.gjt.mm.mysql.Driver").newInstance(); ;
                 // Class.forName("com.mysql.jdbc.Driver").newInstance();
                   dbUrl_sub="jdbc:mysql://localhost/".concat(mdsnName);
                   connl_sub = DriverManager.getConnection(mdsnName) ;
            }
Statement stml;
//out.println(" select subjectcode,subname,prio from asrp_unittestsubjectmaster11 where (class=11 or class='XI') and (streamcode='"+mstream+"' or streamcode='All') and (sub_subjectcode=subjectcode) order by prio");
String mpara=session.getAttribute("ses_csv").toString();
out.println(mpara);
//String mparacsv=batch+","+mmdegree+","+stream+","+meyear+","+memonth+","+msem+","+msubsel;


String mpara_Arr[]=mpara.split(",");
String mbatch=mpara_Arr[0];
String mdegree=mpara_Arr[1];
String mstream=mpara_Arr[2];
String myear=mpara_Arr[3];
String memonth=mpara_Arr[4];
String msem=mpara_Arr[5];
String msubsel=mpara_Arr[6];
String msec=mpara_Arr[7];

String menrlno="";
String mmarks="";
String str1="";
//Following code may required some tweaking because I have used readLine() in different manner.
while ((thisLine = myInput.readLine()) != null)
{
String strar[] = thisLine.split(",");
 menrlno="";
 mmarks="";

try{
    if (strar[0].trim().length()>0){
        menrlno=strar[0].trim();
    }
}catch(Exception e){
    break;
}
try{
    if (strar[1].trim().length()>0){
        mmarks=strar[1].trim();
    }
}catch(Exception e){
    break;
}

str1="update aerp_unit_marks_resuslt set marks="+mmarks+" where enrlno='"+menrlno+"' and subject_code='"+msubsel+"' and examyear="+myear+" and exammonth="+memonth;

stml=connl_sub.createStatement();
int j1=stml.executeUpdate(str1);
stml.close();
}
connl_sub.close();

%>
<form name="form1" id="form1" action="unitmarksEntrySubmitDone.jsp" method="post">
<input type="hidden" name="tbatch" value="<%=mbatch%>">
<input type="hidden" name="tdegree" value="<%=mdegree%>">
<input type="hidden" name="tstream" value="<%=mstream%>">
<input type="hidden" name="texamyear" value="<%=myear%>">
<input type="hidden" name="texammonth" value="<%=memonth%>">
<input type="hidden" name="tsem" value="<%=msem%>">
<input type="hidden" name="subsel" value="<%=msubsel%>">
<input type="hidden" name="tsec" value="<%=msec%>">


<input type="submit">

</form>
            <script>
            alert("Update Successfully");
            form1.submit();
            </script>

<%
}catch(Exception ex){
      out.println(ex.toString());

}
       } catch ( Exception ex ) {
      out.println(ex.toString());
    }


}else{
    out.println("Upload Again");
}
%>