Sun公司Dream项目

				

				

								    jspPath = "/shop/game.jsp";

				    gameTab = "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='game'";

				    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 = "game";    

				%>