求jspsmartupload上传/下载调试成功完整代码！（调试成功再加一百分，绝不失言）

smartupload上的example很清楚啊,看一看抄过来就是了

谢谢，看过了，但不太懂。
既然有插入数据的过程 String strSql = "insert into test(id,name,content) values('" + id + "','" + fileName + "',empty_blob())";
                stmt.execute(strSql);
为何又要select，而且zyw_test和test什么区别？
("select content from zyw_test where id='" + id + "' for update ");
                if (rs.next()) {
                    oracle.sql.BLOB blob = ( (oracle.jdbc.OracleResultSet) rs).getBLOB("content");
                    OutputStream outStream = blob.getBinaryOutputStream();
                    inStream.read(bytes);
                    outStream.write(bytes);
                    outStream.flush();
                    stmt.execute("commit");
                    outStream.close();
("select content from zyw_test where id='" + id + "' for update ");
                if (rs.next()) {
                    oracle.sql.BLOB blob = ( (oracle.jdbc.OracleResultSet) rs).getBLOB("content");
                    OutputStream outStream = blob.getBinaryOutputStream();
                    inStream.read(bytes);
                    outStream.write(bytes);
                    outStream.flush();
                    stmt.execute("commit");
                    outStream.close();
针对sqlserver数据库又该如何改写这段代码？
请帮帮我！

看看我的：new.jsp:<%@ page contentType="text/html;charset=gbk" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>内容管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="/images/css.css" rel="stylesheet" type="text/css">
</head><body leftmargin="0" topmargin="0">
<%
    String sCode = "";
    String sName = "";
%>
<jsp:useBean id="dbList" class="com.abc.db.dbabc" scope="page"/><table width="760" border="0" align="center" height="277">
  <tr>
    <td height="273" width="75%" align="center" valign="top">
      <table width="100%" height="71%">
        <tr>
          <td height="148" valign="top">
        <form name="form1" method="post" action="tblupload.jsp" ENCTYPE="multipart/form-data">
            <table width="100%" border="0" cellspacing="1" cellpadding="1">
              <tr>
                <td colspan="2" align="center"><font size="4" color="#FF0000">新
                  建表格</font></td>
              </tr>
              <tr>
                <td width="19%" align="center">文件标题</td>
                <td width="81%">
                  <input type="text" name="EditTitle" size="50">
                </td>
              </tr>
              <tr>
                <td width="19%" align="center">文件名称</td>
                <td width="81%">
                  <input type="file" name="file" size="50">
                </td>
              </tr>
              <tr>
                <td width="19%" align="center">用户类别</td>
                <td width="81%">
                  <select name="UserType" >
                    <%
String sql0 = "";
if (s_iType==100)
  {
  sql0 = "SELECT CODE,NAME From "+cfgDbPrefix+"t_UserType where RoleType=1";
  }
else
  {
  sql0 = "SELECT CODE,NAME From "+cfgDbPrefix+"t_UserType where RoleType="+s_sType;
  }
dbList.getList(sql0);
    while (dbList.next())
     {
        sCode = dbList.getString("CODE");
        sName = dbList.getString("NAME");
%>
                    <option value=<%=sCode%>><%=sName%></option>
                    <%   }%>
                  </select>
                </td>
              </tr>
              <tr>
                <td width="19%" align="center">文件模块</td>
                <td width="81%">
                  <select name="selectPartType">
                    <%
String sql1 = "SELECT CODE,NAME From "+cfgDbPrefix+"t_DocPartType";
dbList.getList(sql1);
    while (dbList.next())
     {
        sCode = dbList.getString("CODE");
        sName = dbList.getString("NAME");
%>
                    <Option VALUE=<%=sCode%>><%=sName%></Option>
                    <%   }%>
                  </select>
                </td>
              </tr>
              <tr>
                <td width="19%" align="center">文件业务</td>
                <td width="81%">
                  <select name="selectOpeType">
                    <%
String sql2 = "SELECT CODE,NAME From "+cfgDbPrefix+"t_DocOperateType";
dbList.getList(sql2);
    while (dbList.next())
     {
        sCode = dbList.getString("CODE");
        sName = dbList.getString("NAME");
%>
                    <Option VALUE=<%=sCode%>><%=sName%></Option>
                    <%   }%>
                  </select>
                </td>
              </tr>
              <tr>
                <td width="19%" align="center"> </td>
                <td width="81%"> </td>
              </tr>
            </table>
          </td>
        </tr>
        <tr>
          <td height="15"> </td>
        </tr>
        <tr>
          <td align="center">
            <input type="submit" name="Submit" value="提交">
            <input type="reset" name="Submit2" value="重置" >
          </td>
        </tr>
      </table>
</form>    </td>
  </tr>
</table>
<%dbList.close();%>
</body>
</html>tblupload.jsp:<%@ page contentType="text/html;charset=gbk" %>
<%@ page language="java" import="com.jspsmart.upload.*"%>
<jsp:useBean id="mySmartUpload" scope="page" class="com.jspsmart.upload.SmartUpload" />
<jsp:useBean id="dbList" scope="page" class="com.abc.db.dbabc" />
<%
int count=0;
String sSqlStr,sSqlStr1 = "";

String sFileTitle,sFileName,sUserType,sPartType,sOperateType;

mySmartUpload.initialize(pageContext);
mySmartUpload.upload();

sFileTitle = mySmartUpload.getRequest().getParameter("EditTitle");
sUserType = mySmartUpload.getRequest().getParameter("UserType");
sPartType = mySmartUpload.getRequest().getParameter("selectPartType");
sOperateType = mySmartUpload.getRequest().getParameter("selectOpeType");

com.jspsmart.upload.File myFile = mySmartUpload.getFiles().getFile(0);

sFileName = myFile.getFileName();
sSqlStr1 = "select FileTitle From "+cfgDbPrefix+"t_DocDownload where FileName ='"+sFileName+"'";
//out.println(sSqlStr1);
count = dbList.getList(sSqlStr1);
out.println(count);

sSqlStr = "Insert Into ";
sSqlStr += cfgDbPrefix+"t_DocDownload ";
sSqlStr += "(FileTitle,FileName,userType,PartType,OperateType,PubTime,PubUnit,PubUser,ApproveUser,ApproveTime,IsPigeonhole,Hits)";
sSqlStr += " Values (";
sSqlStr += "'"+sFileTitle+"',";
sSqlStr += "'"+sFileName+"',";
sSqlStr += "'"+sUserType+"',";
sSqlStr += "'"+sPartType+"',";
sSqlStr += "'"+sOperateType+"',";
sSqlStr += "'"+sNow+"',";
sSqlStr += "'"+s_sName+"',";
sSqlStr += "'"+s_sName+"',";
sSqlStr += "'"+s_sName+"',";
sSqlStr += "'"+sNow+"',";
sSqlStr += "0,";
sSqlStr += "0";
sSqlStr += ")";

//out.println(sSqlStr);
if (count==0 )
  {
     if (!myFile.isMissing()) {
myFile.saveAs( sUploadLocalDir+ myFile.getFileName(), mySmartUpload.SAVE_PHYSICAL);
dbList.executeUpdate(sSqlStr);
dbList.close();
response.sendRedirect("tbllist.jsp");
     }
  }
        else
          {
      dbList.close();
%>
<script language="javascript">
  window.alert("上传未成功！\n\r<%=sFileName%>已经存在，请重新命名后再上传！");
  window.history.back();
</script>
<%
          }
%>

http://www.csdn.net/develop/Read_Article.asp?Id=18987

ResultSet result=null;
  String Sql=null;
  PreparedStatement prestmt=null;
  DBstep.iDBManager2000 DbaObj=new DBstep.iDBManager2000();
  DbaObj.OpenConnection();
打开数据，怎么连数据库名和用户/口令都没有？

还有king1012,dbList是什么bean？
怎么没有列出来，我有么？
你的连接数据库的部分在那里，怎么找不到！
请指教！

<%@ page import="DBstep.iDBManager2000.*"%>
DBstep.iDBManager2000 DbaObj=new DBstep.iDBManager2000();
DbaObj.OpenConnection();是作者的连接操作数据库的javabean，连数据库名和用户/口令被封装在javabean里面了！

那我要到那里去下栽这个javaben呢，还是自带的。
而且封装了的javaben，难道他就知道我是要连接哪个数据库，口令名也知道，
没有这么神吧，我想这个javabean是不是要配置呀？

任我行：
而且我报了这样的错误：
javac] C:\jakarta-tomcat-4.1.24\work\Standalone\localhost\_\dam\upload_jsp.java:60: package com.jspsmart.upload does not exist
    [javac]    com.jspsmart.upload.File myFile = mySmartUpload.getFiles().getFile(i);
    [javac]                       ^
    [javac] C:\jakarta-tomcat-4.1.24\work\Standalone\localhost\_\dam\upload_jsp.java:88: package DBstep does not exist
    [javac]    DBstep.iDBManager2000 DbaObj=new DBstep.iDBManager2000();
    [javac]          ^
    [javac] C:\jakarta-tomcat-4.1.24\work\Standalone\localhost\_\dam\upload_jsp.java:88: package DBstep does not exist
    [javac]    DBstep.iDBManager2000 DbaObj=new DBstep.iDBManager2000();肯定是DBstep.iDBManager2000();在我这里出了什么问题才对吧。
请指教！

<%@ page language="java" import="com.jspsmart.upload.*"%>
<jsp:useBean id="mySmartUpload" scope="page" class="com.jspsmart.upload.SmartUpload" /><HTML>
<BODY BGCOLOR="white"><H1>jspSmartUpload : Sample 2</H1>
<HR><%String name = (String) session.getValue("username");

// Variables
int count=0;         // Initialization mySmartUpload.initialize(pageContext); // Upload
mySmartUpload.upload(); // Select each file
for (int i=0;i<mySmartUpload.getFiles().getCount();i++){ // Retreive the current file
com.jspsmart.upload.File myFile = mySmartUpload.getFiles().getFile(i); // Save it only if this file exists
if (!myFile.isMissing()) { // Save the files with its original names in a virtual path of the web server
myFile.saveAs("/upload/" + myFile.getFileName());
// myFile.saveAs("/upload/" + myFile.getFileName(), mySmartUpload.SAVE_VIRTUAL); // sample with a physical path
// myFile.saveAs("c:\\temp\\" + myFile.getFileName(), mySmartUpload.SAVE_PHYSICAL); //  Display the properties of the current file
out.println("FieldName = " + myFile.getFieldName() + "<BR>");
out.println("Size = " + myFile.getSize() + "<BR>");
out.println("FileName = " + myFile.getFileName() + "<BR>");
out.println("FileExt = " + myFile.getFileExt() + "<BR>");
out.println("FilePathName = " + myFile.getFilePathName() + "<BR>");
out.println("ContentType = " + myFile.getContentType() + "<BR>");
out.println("ContentDisp = " + myFile.getContentDisp() + "<BR>");
out.println("TypeMIME = " + myFile.getTypeMIME() + "<BR>");
out.println("SubTypeMIME = " + myFile.getSubTypeMIME() + "<BR>"); count ++;


} } // Display the number of files which could be uploaded
out.println("<BR>" + mySmartUpload.getFiles().getCount() + " files could be uploaded.<BR>"); // Display the number of files uploaded
out.println(count + " file(s) uploaded.");
%>
<%

%>
</BODY>
</HTML>

任我行：
你给的代码起什么作用，能不能说下。
还有，我刚才问的问题请回答：
1、那我要到那里去下栽这个javaben呢，还是自带的。
而且封装了的javaben，难道他就知道我是要连接哪个数据库，口令名也知道，
没有这么神吧，我想这个javabean是不是要配置呀？、
2、而且我报了这样的错误：
javac] C:\jakarta-tomcat-4.1.24\work\Standalone\localhost\_\dam\upload_jsp.java:60: package com.jspsmart.upload does not exist
    [javac]    com.jspsmart.upload.File myFile = mySmartUpload.getFiles().getFile(i);
    [javac]                       ^
    [javac] C:\jakarta-tomcat-4.1.24\work\Standalone\localhost\_\dam\upload_jsp.java:88: package DBstep does not exist
    [javac]    DBstep.iDBManager2000 DbaObj=new DBstep.iDBManager2000();
    [javac]          ^
    [javac] C:\jakarta-tomcat-4.1.24\work\Standalone\localhost\_\dam\upload_jsp.java:88: package DBstep does not exist
    [javac]    DBstep.iDBManager2000 DbaObj=new DBstep.iDBManager2000();肯定是DBstep.iDBManager2000();在我这里出了什么问题才对吧。
请指教！

你给的代码报错如下：
java.lang.NegativeArraySizeException
at com.jspsmart.upload.SmartUpload.upload(SmartUpload.java:218)
at org.apache.jsp.test_jsp._jspService(test_jsp.java:75)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:210)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
at java.lang.Thread.run(Thread.java:534)

http://www.fecit.com.cn/Pages/Guest.DD.L.P.asp
《JSP应用开发详解》代码
里面有

也给我一份！！
[email protected]
谢谢！！！！！！！！！！！！！！！！！！！！！！

调试易

求jspsmartupload上传/下载调试成功完整代码！（调试成功再加一百分，绝不失言）

解决方案 »