📄 getviewersofimage.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN""http://www.w3.org/TR/REC-html40/loose.dtd"><!--NewPage--><HTML><HEAD><!-- Generated by javadoc on Sat May 03 22:10:36 PDT 2003 --><TITLE>GetViewersOfImage (PhotoServlet API Documentation - build 120 from 2003/05/03 22:10)</TITLE><META NAME="keywords" CONTENT="net.spy.photo.sp.GetViewersOfImage,GetViewersOfImage class"><LINK REL ="stylesheet" TYPE="text/css" HREF="../../../../stylesheet.css" TITLE="Style"></HEAD><SCRIPT>function asd(){parent.document.title="GetViewersOfImage (PhotoServlet API Documentation - build 120 from 2003/05/03 22:10)";}</SCRIPT><BODY BGCOLOR="white" onload="asd();"><!-- ========== START OF NAVBAR ========== --><A NAME="navbar_top"><!-- --></A><TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0"><TR><TD COLSPAN=3 BGCOLOR="#EEEEFF" CLASS="NavBarCell1"><A NAME="navbar_top_firstrow"><!-- --></A><TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3"> <TR ALIGN="center" VALIGN="top"> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A> </TD> <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> <FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="class-use/GetViewersOfImage.html"><FONT CLASS="NavBarFont1"><B>Use</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../index-all.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A> </TD> </TR></TABLE></TD><TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM></EM></TD></TR><TR><TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> <A HREF="../../../../net/spy/photo/sp/GetProperties.html"><B>PREV CLASS</B></A> <A HREF="../../../../net/spy/photo/sp/InsertACLEntry.html"><B>NEXT CLASS</B></A></FONT></TD><TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> <A HREF="../../../../index.html" TARGET="_top"><B>FRAMES</B></A> <A HREF="GetViewersOfImage.html" TARGET="_top"><B>NO FRAMES</B></A> <SCRIPT> <!-- if(window==top) { document.writeln('<A HREF="../../../../allclasses-noframe.html" TARGET=""><B>All Classes</B></A>'); } //--></SCRIPT><NOSCRIPT><A HREF="../../../../allclasses-noframe.html" TARGET=""><B>All Classes</B></A></NOSCRIPT></FONT></TD></TR><TR><TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2"> SUMMARY: NESTED | <A HREF="#fields_inherited_from_class_net.spy.SpyDB">FIELD</A> | <A HREF="#constructor_summary">CONSTR</A> | <A HREF="#method_summary">METHOD</A></FONT></TD><TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">DETAIL: FIELD | <A HREF="#constructor_detail">CONSTR</A> | <A HREF="#method_detail">METHOD</A></FONT></TD></TR></TABLE><!-- =========== END OF NAVBAR =========== --><HR><!-- ======== START OF CLASS DATA ======== --><H2><FONT SIZE="-1">net.spy.photo.sp</FONT><BR>Class GetViewersOfImage</H2><PRE><A HREF="http://java.sun.com/j2se/1.3/docs/api/java/lang/Object.html">java.lang.Object</A> | +--<A HREF="http://bleu.west.spy.net/~dustin/spyjar/j2/doc/net/spy/SpyObject.html">net.spy.SpyObject</A> | +--<A HREF="http://bleu.west.spy.net/~dustin/spyjar/j2/doc/net/spy/SpyDB.html">net.spy.SpyDB</A> | +--<A HREF="http://bleu.west.spy.net/~dustin/spyjar/j2/doc/net/spy/db/SpyCacheDB.html">net.spy.db.SpyCacheDB</A> | +--<A HREF="http://bleu.west.spy.net/~dustin/spyjar/j2/doc/net/spy/db/DBSP.html">net.spy.db.DBSP</A> | +--<A HREF="http://bleu.west.spy.net/~dustin/spyjar/j2/doc/net/spy/db/DBSQL.html">net.spy.db.DBSQL</A> | +--<B>net.spy.photo.sp.GetViewersOfImage</B></PRE><DL><DT><B>All Implemented Interfaces:</B> <DD><A HREF="http://bleu.west.spy.net/~dustin/spyjar/j2/doc/net/spy/db/DBSPLike.html">DBSPLike</A></DD></DL><HR><DL><DT>public class <B>GetViewersOfImage</B><DT>extends <A HREF="http://bleu.west.spy.net/~dustin/spyjar/j2/doc/net/spy/db/DBSQL.html">DBSQL</A></DL><P>Get all of the viewers of a given image. <p> Generated by SPGen 1.27 on Sat May 03 22:10:14 PDT 2003. </p> <p> <b>SQL Query</b> <ul> <li> <b> -default- </b> <pre> select log.log_id as id, wwwusers.username, text(log.remote_addr) as remote_addr, user_agent.user_agent, log.extra_info as img_size, log.ts from wwwusers, photo_logs log, user_agent where log.wwwuser_id = wwwusers.id and log.photo_id = ? and user_agent.user_agent_id = log.user_agent and log.log_type = get_log_type('ImgView') order by log.ts desc limit 100 </pre> </li> </ul> <b>Required Parameters</b> <ul> <li>image_id - <CODE>java.sql.Types.INTEGER</CODE> - The image id for which we want the viewers.</li> </ul> </p> <p> <b>Optional Parameters</b> <ul> <li><i>none</i></li> </ul> </p> <p> <b>Results</b> <ul> <li>username - <CODE>VARCHAR</CODE> - The user who saw the image.</li> <li>remote_addr - <CODE>VARCHAR</CODE> - The IP address to which the image was served.</li> <li>user_agent - <CODE>VARCHAR</CODE> - The user agent that requested the image.</li> <li>img_size - <CODE>VARCHAR</CODE> - The dimensions at which the image was requested.</li> <li>ts - <CODE>TIMESTAMP</CODE> - The time at which the image was served.</li> </ul> <b>Cache Time</b> <ul> <li>The results of this call will be cached for 00:60:00.0 (3,600 seconds) by default.</li> </ul> </p><P><P><HR><P><!-- ======== NESTED CLASS SUMMARY ======== --><!-- =========== FIELD SUMMARY =========== --><A NAME="field_summary"><!-- --></A><TABLE BORDER="1" CELLPADDING="3" CELLSPACING="0" WIDTH="100%"><TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"><TD COLSPAN=2><FONT SIZE="+2"><B>Field Summary</B></FONT></TD></TR></TABLE> <A NAME="fields_inherited_from_class_net.spy.SpyDB"><!-- --></A><TABLE BORDER="1" CELLPADDING="3" CELLSPACING="0" WIDTH="100%"><TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor"><TD><B>Fields inherited from class net.spy.<A HREF="http://bleu.west.spy.net/~dustin/spyjar/j2/doc/net/spy/SpyDB.html">SpyDB</A></B></TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD><CODE><A HREF="http://bleu.west.spy.net/~dustin/spyjar/j2/doc/net/spy/SpyDB.html#INIT_FROM_CONFIG">INIT_FROM_CONFIG</A>, <A HREF="http://bleu.west.spy.net/~dustin/spyjar/j2/doc/net/spy/SpyDB.html#INIT_FROM_CONN">INIT_FROM_CONN</A></CODE></TD></TR></TABLE> <!-- ======== CONSTRUCTOR SUMMARY ======== --><A NAME="constructor_summary"><!-- --></A><TABLE BORDER="1" CELLPADDING="3" CELLSPACING="0" WIDTH="100%"><TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"><TD COLSPAN=2><FONT SIZE="+2"><B>Constructor Summary</B></FONT></TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD><CODE><B><A HREF="../../../../net/spy/photo/sp/GetViewersOfImage.html#GetViewersOfImage(java.sql.Connection)">GetViewersOfImage</A></B>(<A HREF="http://java.sun.com/j2se/1.3/docs/api/java/sql/Connection.html">Connection</A> conn)</CODE><BR> Construct a DBSP which use the existing Connection for database operations.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD><CODE><B><A HREF="../../../../net/spy/photo/sp/GetViewersOfImage.html#GetViewersOfImage(net.spy.SpyConfig)">GetViewersOfImage</A></B>(<A HREF="http://bleu.west.spy.net/~dustin/spyjar/j2/doc/net/spy/SpyConfig.html">SpyConfig</A> conf)</CODE><BR> Construct a DBSP which will get its connections from SpyDB using the given config.</TD></TR></TABLE> <!-- ========== METHOD SUMMARY =========== --><A NAME="method_summary"><!-- --></A><TABLE BORDER="1" CELLPADDING="3" CELLSPACING="0" WIDTH="100%"><TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"><TD COLSPAN=2><FONT SIZE="+2"><B>Method Summary</B></FONT></TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> void</CODE></FONT></TD><TD><CODE><B><A HREF="../../../../net/spy/photo/sp/GetViewersOfImage.html#setImageId(int)">setImageId</A></B>(int to)</CODE><BR> Set the ``image_id'' parameter.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> void</CODE></FONT></TD><TD><CODE><B><A HREF="../../../../net/spy/photo/sp/GetViewersOfImage.html#setImageId(java.lang.Integer)">setImageId</A></B>(<A HREF="http://java.sun.com/j2se/1.3/docs/api/java/lang/Integer.html">Integer</A> to)</CODE><BR> Set the ``image_id'' parameter.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> void</CODE></FONT></TD><TD><CODE><B><A HREF="../../../../net/spy/photo/sp/GetViewersOfImage.html#setImageId(short)">setImageId</A></B>(short to)</CODE>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -