jsp1.jsp

java编写的b/s结构的文件上传程序

<%@ 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());
}*/
%>