用smartupload向数据库插入字段的问题

伟大的番茄炒鸡蛋 2003-08-22 11:25:35

我是把文件当成流写入数据库的一个字段，用的是fileToFiled方法，怎么插进去个空值啊？

String sql="select imgdata from infotbpagesub where "+
"infotbpageid=(select max(infotbpageid) from InfoTBPageSub ) ";
stmt=conn.createStatement() ;

rs=stmt.executeQuery(sql) ;
while(rs.next() ){
String s="ImgData";
file.fileToField(rs,s) ;
System.out.println("end") ;

}

...全文

36 2 打赏收藏转发到动态举报

写回复

用AI写文章

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

one_bird 2003-08-23

打赏
举报

<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>
<%
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"+" Uploaded file : "+file.getFileName()+" ("+file.getFileSize()+" bytes)"+" 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(" todo="+todo);
}
Vector history = upBean.getHistory();
int amount = 0;
if (history != null) amount = history.size();
%>
 (Uploaded files : <%= amount %>)
</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">Select
a file to upload :</td>
</tr>
<tr>
<td align="left">

<input type="file" name="uploadfile" size="50">


<input type="text" name="addtext">

</td>
</tr>
<tr>
<td align="left">
<input type="hidden" name="todo" value="upload">
<input type="submit" name="Submit" value="Upload">
<input type="reset" name="Reset" value="Cancel">
</td>
</tr>
</table>
 
 
<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"> Needed
HTML tags :</td>
</tr>
<tr>
<td bgcolor="#FFFFFF"> <form
method="post"
action="DatabaseUpload.jsp"
name="upload" enctype="multipart/form-data"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"> <input
type="file"
name="uploadfile"
size="50"></td>
</tr>
</table>
</td>
</tr>
</table>
 
 
 
 
 
Copyright
© <a href="http://www.javazoom.net" target="_blank">JavaZOOM</a> 1999-2003
</form>
</body>
</html>

伟大的番茄炒鸡蛋 2003-08-22