photolist.jsp

一个练习JAVA的例子程序 一个练习JAVA的例子程序

                    </TR>
<%
                rs_comment = new jasp.adodb.Recordset();
                sql = "select * from iisPhotocomment where PhotoID=" + rs.getItem("PhotoID").getValue() + "";
                rs_comment.Open(sql, cn, 1, 1);
                if (!(rs_comment.getEOF()) || rs_comment.getBOF()) {
                    while (!(rs_comment.getEOF())) {
%>

                    <TR> 
                      <TD 
                            style="PADDING-RIGHT: 0px; PADDING-LEFT: 11px; PADDING-BOTTOM: 0px; PADDING-TOP: 0px" 
                            bgColor=#f0f0f0 height=27> <TABLE cellSpacing=0 cellPadding=0 width="100%" 
                              border=0>
                          <TBODY>
                            <TR vAlign=top> 
                              <TD width=25> <IMG style="MARGIN: 3px" height=17 src="../Images/Personacon/p_<%= rs_comment.getItem("PersonaconID").getValue() %>.gif" width=17 align=absMiddle> 
                              </TD>
                              <TD class=ln16 style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 3px; PADDING-TOP: 4px; word-break:break-all" width=380><A href="#" class=popmenu><%= rs_comment.getItem("Commentuser").getValue() %></A> <SPAN style="FONT-SIZE: 11px; COLOR: #9c9a9c"><SPAN>(<%= rs.getItem("Posttime").getValue() %>)</span></span>: <%= rs_comment.getItem("Comment").getValue() %> </TD>
                            </TR>
                          </TBODY>
                        </TABLE></TD>
                    </TR>
                    <TR> 
                      <TD style="BACKGROUND-IMAGE: url(../Images/Hompy/li_x_02.gif)" height=1></TD>
                    </TR>
<%
                        rs_comment.MoveNext();
                    }
                    rs_comment.Close();
                    rs_comment = (jasp.adodb.Recordset)null;
                }
%>

                    <TR> 
                      <TD height=30 style="BORDER-BOTTOM: #cecfce 1px solid;"><TABLE width="100%" height="30" border=0 cellPadding=0 cellSpacing=0>
                          <form name="frmWrite<%= i %>" action="addcomment_p.jsp?username=<%= username %>&viewmode=<%= Request.QueryString("viewmode").getValue() %>&groupid=<%= Request.QueryString("groupid").getValue() %>&photoid=<%= rs.getItem("photoid").getValue() %>" method="post" onSubmit="return formcheck(frmWrite<%= i %>);">
                            <INPUT type=hidden value=-1 name=personaconid>
                            <INPUT type=hidden value=<%= Session.getItem("username") %> name=commentuser>
                            <TBODY>
                              <TR> 
                                <TD width="11%" height=25><div align="center">评论 
                                  </div></TD>
                                <TD width="65%"> <TABLE cellSpacing=1 cellPadding=0 width=288 bgColor=#a9aaaa border=0>
                                    <TBODY>
                                      <TR bgColor=#ffffff> 
                                        <TD align=middle width=24 height=19><IMG onmousedown=javascript:showPersonacon(<%= i %>); src="../Images/Personacon/p_-1.gif" id=personasrc<%= i %> name=personasrc<%= i %> width=17 height=17 border="0"></TD>
                                        <TD width=264> <%
                if (Session.getItem("username").equals(new variant(""))) {
                    Response.Write("<INPUT style='BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; WIDTH: 260px; BORDER-BOTTOM: 0px' name='comment' value='请登录后评论！' disabled>");
                } else {
                    Response.Write("<INPUT style='BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; WIDTH: 260px; BORDER-BOTTOM: 0px' name='comment'>");
                }
%>
 
                                        </TD>
                                      </TR>
                                    </TBODY>
                                  </TABLE></TD>
                                <TD width="24%"> <%
                if (!(Session.getItem("username").equals(new variant("")))) {
                    Response.Write("<Input type='image' src='../Images/Hompy/btn_confirm.gif' width='39' height='18' align='absmiddle'></a>");
                }
%>
 </TD>
                              </TR>
                            </TBODY>
                          </form>
                        </TABLE></TD>
                    </TR>
                </TABLE></td>
            </tr>
            <tr> 
              <td height="36"><DIV id=persona<%= i %> 
                              style="DISPLAY: none; POSITION: absolute"> 
                  <TABLE style="CURSOR: hand" height=19 
                              cellSpacing=1 cellPadding=0 bgColor=#c4cad1 
                              border=0>
                    <TBODY>
                      <TR> 
                        <TD align=middle width=20 bgColor=#ffffff><IMG 
                                id=imgPersona-1 
                                onclick="javascript:setPersona('frmWrite<%= i %>', '<%= i %>', '-1', '-1','../Images/personacon/p_-1.gif')" 
                                height=17 hspace=3 src="../Images/Personacon/p_-1.gif" 
                                width=17 vspace=1></TD>
                        <TD align=middle width=20 bgColor=#ffffff><IMG 
                                id=imgPersona-2 
                                onclick="javascript:setPersona('frmWrite<%= i %>', '<%= i %>', '-2', '-2','../Images/personacon/p_-2.gif')" 
                                height=17 hspace=3 src="../Images/Personacon/p_-2.gif" 
                                width=17 vspace=1></TD>
                        <TD align=middle width=20 bgColor=#ffffff><IMG 
                                id=imgPersona-3 
                                onclick="javascript:setPersona('frmWrite<%= i %>', '<%= i %>', '-3', '-3','../Images/personacon/p_-3.gif')" 
                                height=17 hspace=3 src="../Images/Personacon/p_-3.gif" 
                                width=17 vspace=1></TD>
                        <TD align=middle width=20 bgColor=#ffffff><IMG 
                                id=imgPersona-4 
                                onclick="javascript:setPersona('frmWrite<%= i %>', '<%= i %>', '-4', '-4','../Images/personacon/p_-4.gif')" 
                                height=17 hspace=3 src="../Images/Personacon/p_-4.gif" 
                                width=17 vspace=1></TD>
                        <TD align=middle width=20 bgColor=#ffffff><IMG 
                                id=imgPersona-5 
                                onclick="javascript:setPersona('frmWrite<%= i %>', '<%= i %>', '-5', '-5','../Images/personacon/p_-5.gif')" 
                                height=17 hspace=3 src="../Images/Personacon/p_-5.gif" 
                                width=17 vspace=1></TD>
                        <TD align=middle width=20 bgColor=#ffffff><IMG 
                                id=imgPersona-6 
                                onclick="javascript:setPersona('frmWrite<%= i %>', '<%= i %>', '-6', '-6','../Images/personacon/p_-6.gif')" 
                                height=17 hspace=3 src="../Images/Personacon/p_-6.gif" 
                                width=17 vspace=1></TD>
                        <TD align=middle width=20 bgColor=#ffffff><IMG 
                                id=imgPersona-7 
                                onclick="javascript:setPersona('frmWrite<%= i %>', '<%= i %>', '-7', '-7','../Images/personacon/p_-7.gif')" 
                                height=17 hspace=3 src="../Images/Personacon/p_-7.gif" 
                                width=17 vspace=1></TD>
                        <TD align=middle width=20 bgColor=#ffffff><IMG 
                                id=imgPersona-8 
                                onclick="javascript:setPersona('frmWrite<%= i %>', '<%= i %>', '-8', '-8','../Images/personacon/p_-8.gif')" 
                                height=17 hspace=3 src="../Images/Personacon/p_-8.gif" 
                                width=17 vspace=1></TD>
                        <TD align=middle width=20 bgColor=#ffffff><IMG 
                                id=imgPersona-9 
                                onclick="javascript:setPersona('frmWrite<%= i %>', '<%= i %>', '-9', '-9','../Images/personacon/p_-9.gif')" 
                                height=17 hspace=3 src="../Images/Personacon/p_-9.gif" 
                                width=17 vspace=1></TD>
                        <TD align=middle width=20 bgColor=#ffffff><IMG 
                                id=imgPersona-10 
                                onclick="javascript:setPersona('frmWrite<%= i %>', '<%= i %>', '-10', '-10','../Images/personacon/p_-10.gif')" 
                                height=17 hspace=3 src="../Images/Personacon/p_-10.gif" 
                                width=17 vspace=1></TD>
                      </TR>
                      <TR> 
                        <TD align=middle width=20 bgColor=#ffffff><IMG 
                                id=imgPersona-11 
                                onclick="javascript:setPersona('frmWrite<%= i %>', '<%= i %>', '-11', '-11','../Images/personacon/p_-11.gif')" 
                                height=17 hspace=3 src="../Images/Personacon/p_-11.gif" 
                                width=17 vspace=1></TD>
                        <TD align=middle width=20 bgColor=#ffffff><IMG 
                                id=imgPersona-12 
                                onclick="javascript:setPersona('frmWrite<%= i %>', '<%= i %>', '-12', '-12','../Images/personacon/p_-12.gif')" 
                                height=17 hspace=3 src="../Images/Personacon/p_-12.gif" 
                                width=17 vspace=1></TD>
                        <TD align=middle width=20 bgColor=#ffffff><IMG 
                                id=imgPersona-13 
                                onclick="javascript:setPersona('frmWrite<%= i %>', '<%= i %>', '-13', '-13','../Images/personacon/p_-13.gif')" 
                                height=17 hspace=3 src="../Images/Personacon/p_-13.gif" 
                                width=17 vspace=1></TD>
                        <TD align=middle width=20 bgColor=#ffffff><IMG 
                                id=imgPersona-14 
                                onclick="javascript:setPersona('frmWrite<%= i %>', '<%= i %>', '-14', '-14','../Images/personacon/p_-14.gif')" 
                                height=17 hspace=3 src="../Images/Personacon/p_-14.gif" 
                                width=17 vspace=1></TD>
                        <TD align=middle width=20 bgColor=#ffffff><IMG 
                                id=imgPersona-15 
                                onclick="javascript:setPersona('frmWrite<%= i %>', '<%= i %>', '-15', '-15','../Images/personacon/p_-15.gif')" 
                                height=17 hspace=3 src="../Images/Personacon/p_-15.gif" 
                                width=17 vspace=1></TD>
                        <TD align=middle width=20 bgColor=#ffffff><IMG 
                                id=imgPersona-16 
                                onclick="javascript:setPersona('frmWrite<%= i %>', '<%= i %>', '-16', '-16','../Images/personacon/p_-16.gif')" 
                                height=17 hspace=3 src="../Images/Personacon/p_-16.gif" 
                                width=17 vspace=1></TD>
                        <TD align=middle width=20 bgColor=#ffffff><IMG 
                                id=imgPersona-17 
                                onclick="javascript:setPersona('frmWrite<%= i %>', '<%= i %>', '-17', '-17','../Images/personacon/p_-17.gif')" 
                                height=17 hspace=3 src="../Images/Personacon/p_-17.gif" 
                                width=17 vspace=1></TD>
                        <TD align=middle width=20 bgColor=#ffffff><IMG 
                                id=imgPersona-18 
                                onclick="javascript:setPersona('frmWrite<%= i %>', '<%= i %>', '-18', '-18','../Images/personacon/p_-18.gif')" 
                                height=17 hspace=3 src="../Images/Personacon/p_-18.gif" 
                                width=17 vspace=1></TD>
                        <TD align=middle width=20 bgColor=#ffffff><IMG 
                                id=imgPersona-19 
                                onclick="javascript:setPersona('frmWrite<%= i %>', '<%= i %>', '-19', '-19','../Images/personacon/p_-19.gif')" 
                                height=17 hspace=3 src="../Images/Personacon/p_-19.gif" 
                                width=17 vspace=1></TD>
                        <TD align=middle width=20 
                                bgColor=#ffffff><IMG 
                                id=imgPersona-19 
                                onclick="javascript:setPersona('frmWrite<%= i %>', '<%= i %>', '-20', '-20','../Images/personacon/p_-20.gif')" 
                                height=17 hspace=3 src="../Images/Personacon/p_-20.gif" 
                                width=17 vspace=1></TD>
                      </TR>
                    </TBODY>
                  </TABLE>
                </DIV></td>
              <td colspan="2" align="right"><a href="javascript:" onClick="javascript:alert('此功能暂未开通')"><img src="../Images/Hompy/w_phone.gif" width="62" height="19" border="0"></a> 
                <a href="javascript:" onClick="javascript:alert('此功能暂未开通')"><img src="../Images/Hompy/new_button_save2.gif" width="97" height="19" border="0"></a> 
              </td>
            </tr>
          </table>
          
<%
                rs.MoveNext();
                i = i + 1;
            }
            rs.Close();
            rs = (jasp.adodb.Recordset)null;
        }
%>

<table width="100%"  border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td align="center" style="FONT-SIZE: 11px">
<%
        Page();
%>

	</td>
  </tr>
</table>
          <table width="39%" height="45" border="0" cellpadding="0" cellspacing="0">
            <tr>
    <td><TABLE width="206">
                <TBODY>
                <FORM name=form onSubmit="return false;" method=get target=_self>
                  <TR> 
                    <TD><SELECT name=selsearchType>
                        <option value="wpname">标题</option>
                        <option value="title">内容</option>
                      </SELECT> <INPUT  maxLength=35 size=15 name=searchTxt> <img src="../Images/Hompy/search_b.gif" align="absmiddle"></TD>
                  </TR>
                </FORM>
              </TABLE></td>
  </tr>
</table>
<%
    } else if (viewmode.equals(new variant(1))){
        if (groupid.equals(new variant(""))) {
            sql = "select * from iisALLPhoto where Username='" + username + "' ORDER BY PhotoID DESC";
        } else {
            sql = "select * from iisALLPhoto where Username='" + username + "' and GroupID=" + groupid + " ORDER BY PhotoID DESC";
        }
        if (!(vb.IsEmpty(Request.getItem("page")))) {
            currentpage = vb.CInt(Request.getItem("page"));
        } else {
            currentpage = 1;
        }
        maxperpage = 6;
        rs = new jasp.adodb.Recordset();
        sql = "" + sql + "";
        rs.Open(sql, cn, 1, 1);
        if (rs.getEOF() || rs.getBOF()) {
%>

<table width="97%" border="0" cellpadding="0" cellspacing="0">
  <tr> 
    <td style="HEIGHT: 3px;BORDER-TOP: #cecfce 1px solid; BORDER-BOTTOM: #cecfce 1px dotted; BACKGROUND-COLOR: #f7f7f7"><img src="" width="3" height="3" alt=""></td>
  </tr>
  <tr> 
    <td></td>
  </tr>
  <tr> 
              <td height="108" align="center">暂无照片！</td>
  </tr>
  <tr> 
    <td height="1" style="BORDER-BOTTOM: #cecfce 1px solid;"><img name="" src="" width="1" height="1" alt=""> </td>
  </tr>