package classes.beans;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.*;
import org.jfree.data.jdbc.*;
import org.jfree.data.general.*;
 
import java.io.*;
import java.awt.*;
import java.util.*;
import java.awt.image.*;
import org.jfree.data.*;
import org.jfree.chart.*;
import org.jfree.chart.plot.*;
import org.jfree.chart.urls.*;
import org.jfree.chart.entity.*;
import javax.servlet.*;
import javax.servlet.http.*;
import org.jfree.data.general.DefaultPieDataset;
import org.jfree.chart.ChartFactory;
import org.jfree.chart.ChartUtilities.*;
import org.jfree.chart.imagemap.*;
import java.io.PrintWriter.*;
import java.lang.String.*;
import org.jfree.chart.ChartRenderingInfo.*;
 
 
 
public class votepie {
	
	
	PreparedStatement st;
	
			
	public PieDataset readData() {
		
		JDBCPieDataset data = null;
		String url = "jdbc:mysql://localhost/vote";
		Connection con;
		try {
		Class.forName("com.mysql.jdbc.Driver");
		}
		catch (ClassNotFoundException e) {
		System.err.print("ClassNotFoundException: ");
		System.err.println(e.getMessage());
		}
		 
		try {
			ResultSet rs = st.executeQuery();
			int id = rs.getInt("poll_id");
		con = DriverManager.getConnection(url, "vote", "vote001");
		data = new JDBCPieDataset(con);
				
		st  = con.prepareStatement ("SELECT option_text, counter FROM VOTE_VOTES where poll_id=?");
		st.setInt(1, id);
		rs = st.executeQuery();
				
		//data.executeQuery(sql);
		con.close();
		}
		catch (SQLException e) {
		System.err.print("SQLException: ");
		System.err.println(e.getMessage());
		}
		catch (Exception e) {
		System.err.print("Exception: ");
		System.err.println(e.getMessage());
		}
		return data;
		}
	
	
	public String getChartViewer(HttpServletRequest request, HttpServletResponse response) {
	    votepie pd = new votepie();
		
	    // create the chart...
	    JFreeChart chart = ChartFactory.createPieChart(
	          "Vote Result Pie Chart",  // chart title
	          pd.readData(),             // data
	          true,                // include legend
	          true,
	          false
	    );
 
	    // set the background color for the chart...
	    chart.setBackgroundPaint(Color.cyan);
	    PiePlot plot = (PiePlot) chart.getPlot();
	    plot.setNoDataMessage("No data available");
	     
	    // set drilldown capability...
	    //plot.setURLGenerator(new StandardPieURLGenerator("Bar3DDemo.jsp","section"));
	    //plot.setLabelGenerator(null);
 
	    // OPTIONAL CUSTOMISATION COMPLETED.
 
	    ChartRenderingInfo info = null;
	    HttpSession session = request.getSession();
	    try {
 
	      //Create RenderingInfo object
	      response.setContentType("text/html");
	      info = new ChartRenderingInfo(new StandardEntityCollection());
	      BufferedImage chartImage = chart.createBufferedImage(640, 400, info);
 
	      // putting chart as BufferedImage in session, 
	      // thus making it available for the image reading action Action.
	      session.setAttribute("chartImage", chartImage);
 
	      PrintWriter writer = new PrintWriter(response.getWriter());
	      ChartUtilities.writeImageMap(writer, "imageMap", info, true);
	      writer.flush();
	    
	    }
	    catch (Exception e) {
	       // handle your exception here
	    }
	   
	    String pathInfo = "http://";
	    pathInfo += request.getServerName();
	    int port = request.getServerPort();
	    pathInfo += ":"+String.valueOf(port);
	    pathInfo += request.getContextPath();
	    String chartViewer = pathInfo + "/servlet/ChartViewer";
	    return chartViewer;
	  }
	}

package classes.servlets;
 
import java.io.*;
import java.awt.image.*;
import javax.servlet.*;
import javax.servlet.http.*;
import com.keypoint.PngEncoder;
 
public class voteserve extends HttpServlet {
 
	  public void init() throws ServletException {
	  }
 
	  //Process the HTTP Get request
	  public void doGet(HttpServletRequest request, HttpServletResponse response)
	         throws ServletException, IOException {
 
	   // get the chart from session
	   HttpSession session = request.getSession();
	   BufferedImage chartImage = (BufferedImage) session.getAttribute("chartImage");
 
	   // set the content type so the browser can see this as a picture
	   response.setContentType("image/png");
 
	   // send the picture
	   PngEncoder encoder = new PngEncoder(chartImage, false, 0, 9);
	   response.getOutputStream().write(encoder.pngEncode());
	   
	  }
 
	  //Process the HTTP Post request
	  public void doPost(HttpServletRequest request, HttpServletResponse response)
	         throws ServletException, IOException {
	    doGet(request, response);
	  }
 
	  //Process the HTTP Put request
	  public void doPut(HttpServletRequest request, HttpServletResponse response)
	         throws ServletException, IOException {
	  }
 
	  //Clean up resources
	  public void destroy() {
	  }
 
	}

<html>
<body bgcolor="#333333">
 
<%@ page language="java" import="javazoom.upload.UploadBean*,java.util.*,java.io.*" %>
<%@ page errorPage="ExceptionHandler.jsp" %>
 
<% String directory = "c:/Missing Person"; %>
<% String tmpdirectory = "c:/Missing Person/tmp"; %>
<% boolean createsubfolders = true; %>
<% boolean allowresume = true; %>
<% boolean allowoverwrite = true; %>
<% String encoding = "ISO-8859-1"; %>
<% boolean keepalive = false; %>
 
<jsp:useBean id="upBean" scope="page" class="javazoom.upload.UploadBean" >
  <jsp:setProperty name="upBean" property="folderstore" value="<%= directory %>" />
  <jsp:setProperty name="upBean" property="parser" value="<%= MultipartFormDataRequest.CFUPARSER %>"/>
  <jsp:setProperty name="upBean" property="parsertmpdir" value="<%= tmpdirectory %>"/>
  <jsp:setProperty name="upBean" property="filesizelimit" value="8589934592"/>
  <jsp:setProperty name="upBean" property="overwrite" value="<%= allowoverwrite %>"/>
  <jsp:setProperty name="upBean" property="dump" value="true"/>
</jsp:useBean>
 
<%
  //request.setCharacterEncoding(encoding);
  //response.setContentType("text/html; charset="+encoding);
  String method = request.getMethod();
  // Head processing to support resume and overwrite features.
  if (method.equalsIgnoreCase("head"))
  {
    String filename = request.getHeader("relativefilename");
    if (filename == null) filename = request.getHeader("filename");
    if (filename!=null)
    {
    	if (keepalive == false) response.setHeader("Connection","close");
    	String account = request.getHeader("account");
 	if (account == null) account="";
    	else if (!account.startsWith("/")) account = "/"+account;
    	File fhead = new File(directory+account+"/"+filename);
    	if (fhead.exists())
    	{
    	   response.setHeader("size", String.valueOf(fhead.length()));
    	   String checksum = request.getHeader("checksum");
    	   if ((checksum != null) && (checksum.equalsIgnoreCase("crc")))
    	   {
		long crc = upBean.computeCRC32(fhead,-1);
		if (crc != -1) response.setHeader("checksum", String.valueOf(crc));
    	   }
    	   else if ((checksum != null) && (checksum.equalsIgnoreCase("md5")))
    	   {
		String md5 = upBean.hexDump(upBean.computeMD5(fhead,-1)).toLowerCase();
		if ((md5 != null) && (!md5.equals(""))) response.setHeader("checksum", md5);
    	   }
    	}
    	else response.sendError(HttpServletResponse.SC_NOT_FOUND);
       return;
    }
  }
%>
<html>
<head>
<title>Samples : Large Upload + jClientUpload Applet support</title>
<style TYPE="text/css">
<!--
.style1 {
	font-size: 12px;
	font-family: Verdana;
}
-->
</style>
<meta http-equiv="Content-Type" content="text/html; charset=<%= encoding %>">
 
 
 
 
<script language="Javascript"><!--
 
  function doClean()
  {
    document.upload.todo.value="cleanstore";
	document.upload.submit();
  }
  //--></script>
</head>
<body>
<ul class="style1">
<%
      if (MultipartFormDataRequest.isMultipartFormData(request))
      {
         // Parse multipart HTTP POST request.
         MultipartFormDataRequest mrequest = null;
         try
         {
         	mrequest = new MultipartFormDataRequest(request,null,-1,MultipartFormDataRequest.CFUPARSER,encoding,allowresume);
         } catch (Exception e)
	   {
	       // Cancel current upload (e.g. Stop transfer)
               // Only if allowresume = false
	   }
         String todo = null;
         if (mrequest != null) todo = mrequest.getParameter("todo");
         if ( (todo != null) && (todo.equalsIgnoreCase("upload")) )
         {
    	   String account = mrequest.getParameter("account");
    	   if (account == null) account="";
    	   else if (!account.startsWith("/")) account = "/"+account;
           upBean.setFolderstore(directory+account);
           Hashtable files = mrequest.getFiles();
           if ( (files != null) && (!files.isEmpty()) )
           {
             UploadFile file = (UploadFile) files.get("uploadfile");
              if (file != null) out.println("<b> Successfully Uploaded the Missing Person's photo : "+file.getFileName());
                    // Folders and subfolders creation support.
             String relative = mrequest.getParameter("relativefilename");
             if ((createsubfolders == true) && (relative != null))
             {
               int inda=relative.length();
               int indb=file.getFileName().length();
               if (inda > indb)
               {
                 String subfolder = relative.substring(0,(inda-indb)-1);
                 subfolder = subfolder.replace('\\','/').replace('/',java.io.File.separatorChar);
                 upBean.setFolderstore(directory+account+java.io.File.separator+subfolder);
               }
             }
             if (keepalive == false) response.setHeader("Connection","close");
             // Chunks recomposion support.
             String chunkidStr = mrequest.getParameter("chunkid");
             String chunkamountStr = mrequest.getParameter("chunkamount");
             String chunkbaseStr = mrequest.getParameter("chunkbase");
             if ((chunkidStr != null) && (chunkamountStr != null) && (chunkbaseStr != null))
             {
               // Always overwrite chunks.
               upBean.setOverwrite(true);
               upBean.store(mrequest, "uploadfile");
               upBean.setOverwrite(allowoverwrite);
               int chunkid = Integer.parseInt(chunkidStr);
               int chunkamount = Integer.parseInt(chunkamountStr);
               if (chunkid == chunkamount)
               {
                 // recompose file.
                 String fname = upBean.getFolderstore()+java.io.File.separator+chunkbaseStr;
                 File fread = new File(fname);
                 if (fread.canRead() && (upBean.getOverwrite()==false)) fname = upBean.loadOverwriteFilter().process(fname);
                 FileOutputStream fout = new FileOutputStream(fname);
                 byte[] buffer = new byte[4096];
                 for (int c=1;c<=chunkamount;c++)
                 {
                   File filein = new File(upBean.getFolderstore()+java.io.File.separator+chunkbaseStr+"."+c);
                   FileInputStream fin = new FileInputStream(filein);
                   int read = -1;
                   while ((read = fin.read(buffer)) > 0) fout.write(buffer,0,read);
                   fin.close();
                   filein.delete();
                 }
                 fout.close();
               }
             }
             else upBean.store(mrequest, "uploadfile");
             upBean.setFolderstore(directory+account);
           }
           else
           {
             String emptydirectory = mrequest.getParameter("emptydirectory");
             if ((emptydirectory != null) && (!emptydirectory.equals("")))
             {
               File dir = new File(directory+account+"/"+emptydirectory);
               dir.mkdirs();
             }
             out.println("<li>No uploaded files");
           }
         }
 
		 else if ( (todo != null) && (todo.equalsIgnoreCase("cleanstore")) )
	     {
            upBean.resetStore();
            out.println("<BR>Store cleaned");
         }
 
      }
%>
</ul>
<form method="post" action="umLargeUpload.jsp" name="upform" enctype="multipart/form-data">
  <table width="60%" border="0" cellspacing="1" cellpadding="1" align="center" class="style1">
    <tr>
      <td align="left"><b>Select a file to upload :</b></td>
    </tr>
    <tr>
      <td align="left">
        <input type="hidden" name="todo" value="upload">
          <input type="file" name="uploadfile" size="50">
      </td>
    </tr>
    <tr>
      <td align="left">
        <input type="submit" name="Submit" value="Upload">
        <input type="reset" name="Reset" value="Cancel">
      </td>
    </tr>
  </table>
  <p>&nbsp;</p>
</form>
</body>
</html>