ringtone.jsp

Sun公司Dream项目

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

<%
    jspPath = "/shop/ringtone.jsp";
    ringtoneTab = "on";

    final int MAX_ITEMS_DISPLAYED = 2;
    boolean showAll = false;
    
    String showAllStr = request.getParameter("show_all");
    if (showAllStr != null) showAll = true;

    String selectedContentID = request.getParameter("selected_content_id");
    String[] selectedContent = null;

    String prodSQL = "SELECT prod.contentid FROM SHOP_PRODUCT prod WHERE prod.category='ringtone'";
    int[] prodTypes = new int[] {java.sql.Types.VARCHAR};
    
    String detailInfoSQL = "SELECT prod.contentid,prod.listprice,prod.price, prod.filename,meta.title,meta.description,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, prod.category FROM SHOP_PRODUCT prod LEFT OUTER JOIN OPERA_CONTENT_METADATA meta ON prod.contentid = meta.contentid WHERE prod.contentid=?";    
    //                                      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[] detailInfoTypes = new int[] {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,java.sql.Types.VARCHAR,java.sql.Types.VARCHAR};    
    
    Vector products = DBUtil.getRecords(prodSQL, prodTypes, null);
    
    Vector shownProducts = new Vector();
    
    if (selectedContentID == null) {        
        if (products.size() > 0) {
            String[] aRec = (String[]) products.elementAt(getRandomNumber (0.0, products.size()-1));
            selectedContentID = aRec[0]; 
        }
    }
    
    if (selectedContentID != null) {
        selectedContent = DBUtil.getRecord(detailInfoSQL, detailInfoTypes, null, new String[] {selectedContentID});
    
    }
    
    String category = "ringtone"; 
%>

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

<%@ include file = "right_content.jsp" %>                                      
<%@ include file = "footer.jsp" %>