content.jsp

Sun公司Dream项目

<%@ include file="common_imports.jsp" %>

<%
    showFlashy = false;
    if(jspPath == null)
        jspPath = "/shop/my_account.jsp";
    
    if (! "admin".equals(userID)) {
        request.getRequestDispatcher(jspPath).forward(request,response);
    }        
        
    String selectAllContentsSQL = "SELECT prod.contentid,meta.title, prod.category,meta.description,prod.listprice,prod.price, prod.filename,meta.publisher,meta.artist,meta.creationdata,meta.language,meta.country,meta.runtime,meta.previewfile,meta.thumbnail1,meta.thumbnail2,meta.contentloc,meta.datatype,meta.resolution,meta.bitrate,meta.mimetype,meta.rating,meta.drmtype,meta.deliverymode,meta.relprod FROM SHOP_PRODUCT prod LEFT OUTER JOIN OPERA_CONTENT_METADATA meta ON prod.contentid = meta.contentid WHERE prod.contentid IN (SELECT contentid FROM SHOP_PRODUCT)";
    //                                         0           1            2          3              4            5               6             7             8               9           10            11            12                13            14              15             16               17            18            19          20          21              22                  23
    int[] selectAllContentsTypes = new int[] {java.sql.Types.VARCHAR,java.sql.Types.VARCHAR,java.sql.Types.VARCHAR,java.sql.Types.VARCHAR,java.sql.Types.FLOAT,java.sql.Types.FLOAT,java.sql.Types.VARCHAR,java.sql.Types.VARCHAR,java.sql.Types.VARCHAR,java.sql.Types.VARCHAR,java.sql.Types.VARCHAR,java.sql.Types.VARCHAR,java.sql.Types.VARCHAR,java.sql.Types.VARCHAR,java.sql.Types.VARCHAR,java.sql.Types.VARCHAR,java.sql.Types.VARCHAR,java.sql.Types.VARCHAR,java.sql.Types.VARCHAR,java.sql.Types.VARCHAR,java.sql.Types.VARCHAR,java.sql.Types.VARCHAR,java.sql.Types.VARCHAR,java.sql.Types.VARCHAR,java.sql.Types.VARCHAR};    
        
    String [] columnHeaders = {"Content ID", "Title", "Category","Description", "List Price", "Price", "Filename", "Publisher", "Artist", "Creation Data", "Language", "Country of Origin", "Run Time", "Preview File", "Thumbnail S", "Thumbnail L", "Content Location", "Data Type", "XY Resolution", "Bit Rate", "Mime Type", "Rating", "DRM Type", "Delivery Mode", "Related Product", "Action"};

    String nullValue = "<span style=\"color:red;\" align=\"center\">Not Set</span>";
    
    Vector contentMetaInfo = DBUtil.getRecords(selectAllContentsSQL, selectAllContentsTypes, null);   
    
    String prodDeleteSQL = "DELETE FROM SHOP_PRODUCT WHERE contentid = '";
    String metaDeleteSQL = "DELETE FROM OPERA_CONTENT_METADATA WHERE contentid = '";

    // Check if we have a delete action.
    if ("delete".equals(request.getParameter("action"))) {
	String cID = request.getParameter("content_id");
	DBUtil.execute(prodDeleteSQL + cID + "'");
	DBUtil.execute(metaDeleteSQL + cID + "'");
    }
%>

<%@ include file="top_body.jsp" %>

        <td width="700" valign="top" align="center">
          <table width="680" border="0" cellspacing="0" cellpadding="5">           
            <tr>
              <td class="song_title" colspan="2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
              Content Metadata Info</td>
            </tr>                         
            <tr>
              <td colspan="2">&nbsp;&nbsp;&nbsp;&nbsp;
              <a href="content_form.jsp" style="text-decoration:none;font-size:18px;">Add New Content</a></td>
            <tr>
              <td>&nbsp;&nbsp;</td>
              <td width="100%" align="center">
                <table cellspacing="0" cellpadding="3" border="1">                  
                  <tr>
<%
    for (int i=0; i < columnHeaders.length; i++) {
%>
                    <td class="subsong_detail" align="center"><b><%=columnHeaders[i]%></b></td>       
<%
    }
%>
                  </tr>                
                
<%
    if (contentMetaInfo.size() > 0) {
        for (int m=0; m <contentMetaInfo.size(); m++) {
            String[] aContent = (String[]) contentMetaInfo.elementAt(m);
		String contentID = aContent[0];
%>
                  <tr>
<%
            for (int i=0; i < aContent.length; i++) {
                if (i == 0) //contentid
                    aContent[i] = "<a href=\"content_form.jsp?content_id="+ aContent[0] + "\" style=\"text-decoration:none\">" + aContent[0] + "</a>";
                if (aContent[i] == null || "".equals(aContent[i].trim()))
                    aContent[i] = nullValue;
%>
                    <td class="subsong_detail"><%=aContent[i]%></td>                   
<%
            }
%>
                    <td class="subsong_detail"><a href="content.jsp?action=delete&content_id=<%=contentID%>">Delete</a></td>
                  </tr>
<%
        }
    }
%>  

                </table>
              </td>
            </tr>
            <tr>
              <td colspan="2">&nbsp;</td>
            </tr>
          </table>
        </td>
                                      
<%@ include file = "footer.jsp" %>