📄 developerguide.html
字号:
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#EEEEEE"><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><font size="-2"><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><jsp:useBean
id="upBean" scope="session"
class="javazoom.upload.UploadBean"><br>
</font></font></font></font></font></font></font></font><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><font size="-2"><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"> <jsp:setProperty
name="<b>upBean</b>" property="<b><font color="#FF0000">zipfilestore</font></b>"
<br>
value="<b>D:/Inetpub/customers/uploads.zip</b>"
/><br>
</jsp:useBean></font></font></font></font></font></font></font></font></td>
</tr>
</table>
</td>
</tr>
</table>
<p><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><font size="-2"><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><u><font size="-2"><b><font color="#333333">Notes</font></b></font></u><font color="#333333"><b><font size="-2">
: </font></b><font size="-2"><br>
1 - Appending process could be slow because UploadBean need
to create a temporary archive. Try to avoid big archives.<br>
2 - Don't pay attention about "/" or "\"
in path. UploadBean will use always use the good one.<br>
3 - </font><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><font size="-2"><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><font size="-2"><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><font face="Verdana, Arial, Helvetica, sans-serif" size="-2">A
full sample is available through <a href="../MultipleUploads.jsp">MultipleUploads.jsp</a></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font><br>
</font></font></font></font></font></font></font></font><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"></font></font></font></font></p>
<table width="100%" border="0" cellspacing="1" cellpadding="1">
<tr>
<td valign="top" bgcolor="#FFFFCC"><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><font size="-2"><b><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><font size="-2"><b><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><font size="-2"><b><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font color="#FF0000"><img src="img/right_red-arrow.gif" width="18" height="14" align="absmiddle"> </font></font></font></font></font></font></b></font></font></font></font></font><font color="#FF0000"></font></font></font></font></font></font></b></font></font></font></font></font><font color="#FF0000">Database
</font></font></font><font color="#FF0000">:</font><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><font size="-2"><b><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><font size="-2"><b><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><font color="#FF0000"><a name="database"></a></font></font></font></font></b></font></font></font></font></font></font></font></font></b></font></font></font></font></font></font></font></font></b></font></font></font></font></font></td>
</tr>
</table>
<p><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><font size="-2"><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><font size="-2"><b><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><img src="img/database.gif" width="33" height="35" align="left"></font></font></font></b></font></font></font></font></font><font face="Verdana, Arial, Helvetica, sans-serif" size="-1">UploadBean
can store uploaded files in any database supporting long RAW
data (i.e. binary files). You need a table (UPLOADS) with
one column for upload identifiers (UPLOADID), one column for
uploaded filenames (FILENAME) and one column for binary data
(BINARYFILE). Note that you can modify tables and columns
names through SQLUPLOAD* public static fields of UploadBean
class. <br>
<br>
Two methods are available to initialize to JDBC connection
:<br>
</font></font></font></font></font></font></font></font></font></p>
<ul>
<li><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><font size="-2"><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1">public
void <b>setDatabasestore</b>(String driver, String URL,
Properties credentials)<br>
<font color="#666666">Inputs parameters are the JDBC driver
identifier, the JDBC URL and some connection properties
(usually login/password).</font><br>
<font color="#666666">This method will load the driver in
memory and open a database connection. </font></font></font></font></font></font></font></font></font></font></li>
<li><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><font size="-2"><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1">public
void <b>setDatabasestore</b>(Connection jdbcconnection)<br>
<font color="#666666">Input parameter is a database connection
that could come from a DataSource or any connection pool.</font><br>
</font></font></font></font></font></font></font></font></font></li>
</ul>
<p><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><font size="-2"><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1">One<font face="Verdana, Arial, Helvetica, sans-serif" size="-1">
method is available to replace database store implementation
:<br>
</font></font></font></font></font></font></font></font></font></p>
<ul>
<li><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><font size="-2"><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1">public
void <b>setDatabasestoreimplementation</b>(String newimpl)<br>
<font color="#666666">Inputs parameter is your extended
DBStore classname. See note 5 below. </font></font></font></font></font></font></font></font></font></font></li>
</ul>
<p><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><font size="-2"><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1">Here
is a sample for Oracle.</font> We assume that ORCL is a database
instance running on mydbhost server (port 1521) and a test
(login=test, password=test) account is available. A table
matches to the <a href="sql/upload_oracle.sql">upload_oracle.sql</a>
script. We also assume that we're using the Oracle THIN JDBC
driver.<br>
</font></font></font></font></font></font></font></font></p>
<table width="100%" border="0" cellspacing="1" cellpadding="1">
<tr>
<td bgcolor="#333333">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#EEEEEE"><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><font face="Verdana, Arial, Helvetica, sans-serif" size="-1"><font size="-2"><font face="Verdana, Arial, Helvetica, sans-serif"><font face="Verdana, Arial, Helvetica, sans-serif"><font size="-1"><jsp:useBean
id="upBean" scope="application"
class="javazoom.upload.UploadBean"><br>
<%<br>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -