<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="fileupload.*,java.sql.*" %>
<jsp:useBean id="TheBean" scope="page" class="fileupload.FileUploadBean" />
<jsp:useBean id="transdata" scope="page" class="fileupload.transformdata" />
<jsp:useBean id="dbconn" scope="page" class="fileupload.DbConn" />
<!--jsp:setpropery id="TheBean" property="savePath" value="d:\\" /-->
<%
TheBean.setSavePath("d:\\tt\\");
out.println("test");
out.println(request.getParameter("addno") +"&&" +request.getParameter("deptno"));
/*transdata.clearError();
TheBean.doUpload(request);
out.println("Filename:" + TheBean.getFilename());
out.println("<BR>內容類型:" + TheBean.getContentType());
out.println("<BR>所屬地區:" + TheBean.getFieldValue("addno"));
out.println("<BR>單位:" + TheBean.getFieldValue("deptno"));
out.println("<BR>說明:" + TheBean.getFilename());

Connection con = dbconn.getDBConnection();
String sqlStr = "select * from importerror";
ResultSet rs = dbconn.executeQuery(con,sqlStr);
String sTableStr ="數據導入出錯記錄：<br><table border = 1>";
try
{
  while (rs.next())
  {
    sTableStr += "<tr><td>" + rs.getString(1) + "</td><td>" + rs.getString(2) + "</td></tr>";
  }
  sTableStr += "</table>";
  if (sTableStr.indexOf("<td>") < 1) out.println("數據導入成功，沒有錯誤記錄!");
  else out.println(sTableStr);
}catch(Exception e)
{
  out.println("jsp1:" +e.toString());
}*/
%>