<html>
<%@ page language="java"  contentType="text/html; charset=gb2312" 
import="javazoom.upload.*,java.util.*" %>
<%@ page errorPage="ExceptionHandler.jsp" %>
<jsp:useBean id="upBean" scope="application" class="javazoom.upload.UploadBean" >
<jsp:setProperty name="upBean" property="blacklist"
   value="*.txt" />
</jsp:useBean>
<%
  Properties props = new Properties();
  props.put("user","sa");
  props.put("password","123");
  upBean.setDatabasestore("com.microsoft.jdbc.sqlserver.SQLServerDriver",
   "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=student", props);
%>
</jsp:useBean>
<jsp:setProperty name="upBean" property="overwrite" value="true" />
<head>
<title>Samples : Database Upload</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<ul><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">
<%
request.setCharacterEncoding("gb2312"); 
      if (MultipartFormDataRequest.isMultipartFormData(request))
      {
         // Uses MultipartFormDataRequest to parse the HTTP request.
         //MultipartFormDataRequest mrequest = new MultipartFormDataRequest(request);
  MultipartFormDataRequest mrequest = new MultipartFormDataRequest(request,null,50*1024*1024,MultipartFormDataRequest.COSPARSER,"gb2312"); 
         String todo = mrequest.getParameter("todo");
 String addtext = mrequest.getParameter("addtext");
 out.println(addtext);
 if ( (todo != null) && (todo.equalsIgnoreCase("upload")) )
 {
                Hashtable files = mrequest.getFiles();
                if ( (files != null) || (!files.isEmpty()) )
                {
                    UploadFile file = (UploadFile) files.get("uploadfile");
                    out.println("<li>Form field : uploadfile"+"<BR> Uploaded file : "+file.getFileName()+" ("+file.getFileSize()+" bytes)"+"<BR> Content Type : "+file.getContentType());
                    // Uses the bean now to store specified by jsp:setProperty at the top.
                    upBean.store(mrequest, "uploadfile");
                    // int lastid = ((DefaultDBStore)upBean.getDatabasestoreimplementation()).getLastId();
                }
                else
                {
                  out.println("<li>No uploaded files");
                }
 }
         else out.println("<BR> todo="+todo);
      }
      Vector history = upBean.getHistory();
      int amount = 0;
      if (history != null) amount = history.size();
     %>
  <br><i>(Uploaded files : <%= amount %>)</i>
</font></ul>
<form method="post" action="DatabaseUpload.jsp" name="upform" enctype="multipart/form-data">
  <table width="60%" border="0" cellspacing="1" cellpadding="1" align="center">
    <tr>
      <td align="left"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif"><b>Select
        a file to upload :</b></font></td>
    </tr>
    <tr>
      <td align="left">
        <p><font size="-1" face="Verdana, Arial, Helvetica, sans-serif"> 
          <input type="file" name="uploadfile" size="50">
          </font></p>
        <p>
          <input type="text" name="addtext">
        </p>
      </td>
    </tr>
    <tr>
      <td align="left"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">
<input type="hidden" name="todo" value="upload">
        <input type="submit" name="Submit" value="Upload">
        <input type="reset" name="Reset" value="Cancel">
        </font></td>
    </tr>
  </table>
  <br>
  <br>
  <table width="90%" border="0" cellspacing="1" cellpadding="0" align="center">
    <tr>
      <td bgcolor="#666666">
        <table width="100%" border="0" cellspacing="1" cellpadding="0" align="center">
          <tr>
            <td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif"><b><font color="#0000FF">&nbsp;Needed
              HTML tags :</font></b></font></td>
          </tr>
          <tr>
            <td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;&lt;<b>form</b>
              <b>method</b>=&quot;<b><font color="#FF0000">post</font></b>&quot;
              <b>action</b>=&quot;<b><font color="#FF0000">DatabaseUpload.jsp</font></b>&quot;
              name=&quot;upload&quot; <b>enctype</b>=&quot;<b><font color="#FF0000">multipart/form-data</font></b>&quot;&gt;</font></td>
          </tr>
          <tr>
            <td bgcolor="#FFFFFF"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;&lt;<b>input</b>
              <b>type</b>=&quot;<b><font color="#FF0000">file</font></b>&quot;
              <b>name</b>=&quot;<font color="#FF0000"><b>uploadfile</b></font>&quot;
              size=&quot;50&quot;&gt;</font></td>
          </tr>
        </table>
      </td>
    </tr>
  </table>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p align="center">&nbsp;</p>
  <p align="center">&nbsp;</p>
  <p align="center">&nbsp;</p>
  <p align="center"><font size="-1" face="Courier New, Courier, mono">Copyright
    &copy; <a href="http://www.javazoom.net" target="_blank">JavaZOOM</a> 1999-2003</font></p>
</form>
</body>
</html>