📄 my_account.jsp
字号:
<%@ include file="common_imports.jsp" %>
<%
if (jspPath == null)
jspPath = "/shop/my_account.jsp";
//if (!isSignin) {
// request.getRequestDispatcher("/shop/login.jsp").forward(request,response);
//} else
if ("admin".equals(userID)) {
request.getRequestDispatcher("/shop/content.jsp").forward(request,response);
}
//RightsInfo[] rightsInfo = sms.getUserRightsInfo(me);
Vector contents = DBUtil.getRecords("SELECT lic.contentid,lic.shopid,lic.remaining FROM OPERA_LICENSE_INFO lic WHERE lic.userid='" + userID + "' AND lic.shopid='" + operaShopID + "'",
new int[] { java.sql.Types.VARCHAR,java.sql.Types.VARCHAR, java.sql.Types.INTEGER },
null);
String[] userInfo = DBUtil.getRecord ("SELECT phone,sim,username,email FROM OPERA_USER_INFO WHERE userid='" + userID +"'",
new int[] { java.sql.Types.VARCHAR,java.sql.Types.VARCHAR,java.sql.Types.VARCHAR,java.sql.Types.VARCHAR},
null, null);
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};
%>
<%@ include file="top_body.jsp" %>
<td width="450" border="1" valign="top" align="center">
<table width="350" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="100%" align="center">
<table width="250" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2" class="song_title" align="center"style="font-size:15px">My Info</td>
</tr>
<tr>
<td class="subsong_detail" valign="top" width="40%"><b>User ID</b>: </td>
<td class="subsong_detail" align="left"><%=userID%></td>
</tr>
<tr>
<td class="subsong_detail" valign="top" width="40%"><b>Phone</b>: </td>
<td class="subsong_detail" align="left"><%=userInfo[0]%></td>
</tr>
<tr>
<td class="subsong_detail" valign="top"><b>SIM #</b>: </td>
<td class="subsong_detail" align="left"><%=userInfo[1]%></td>
</tr>
<tr>
<td class="subsong_detail" valign="top"><b>Full Name</b>: </td>
<td class="subsong_detail" align="left"><%=(userInfo[2]==null?" ":userInfo[2])%></td>
</tr>
<tr>
<td class="subsong_detail" valign="top"><b>Email</b>: </td>
<td class="subsong_detail" align="left"><%=(userInfo[3]==null?" ":userInfo[3])%></td>
</tr>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td colspan="26" class="song_title" align="center" style="font-size:15px">My Content</td>
</tr>
<tr>
<td class="subsong_detail" align="left"><b>Category</b></td>
<td> </td>
<td> </td>
<td class="subsong_detail" align="left" colspan="4"><b>Title</b></td>
<td> </td>
<td class="subsong_detail" align="center" colspan="2"><b># Simple Plays</b></td>
<td> </td>
<td> </td>
<td class="subsong_detail" align="center" colspan="2"><b># Unrestricted Plays</b></td>
<td class="subsong_detail" align="center" colspan="2"><b># Records</b></td>
<td class="subsong_detail" align="center" colspan="2"><b>Play Now</b></td>
<td class="subsong_detail" align="center" colspan="4"><b>Transfer Rights</b></td>
<td class="subsong_detail" align="center" colspan="4"><b>Assert Fair-use</b></td>
</tr>
<%
if (contents.size() > 0) {
System.out.println("in my_account.jsp: size of contents:" +contents.size());
for (int i=0; i < contents.size(); i++) {
String[] aContent = (String[])contents.elementAt(i);
if (aContent == null)
System.out.println("aContent is null");
else
System.out.println("aContent size "+aContent.length);
System.out.println("Before DBUtil.getRecord");
String[] contentInfo = DBUtil.getRecord(detailInfoSQL, detailInfoTypes, null, new String[] {aContent[0]});
if (contentInfo == null)
System.out.println("contentInfo is null");
else
System.out.println("contentInfo size: "+contentInfo.length);
if (aContent[2] == null)
System.out.println("aContent[2] is null");
int remainingPlay = Integer.parseInt(aContent[2]);
%>
<tr>
<td class="subsong_detail" align="left"><%=(contentInfo[23]==null?"No Category":contentInfo[23])%></td>
<td> </td>
<td> </td>
<td class="subsong_detail" align="left" colspan="4"><%=(contentInfo[4]==null?"No Title":contentInfo[4])%></td>
<td> </td>
<%
if (contentInfo[0] == null)
System.out.println("contentInfo[0] is null");
else
System.out.println("contentInfo[0] "+contentInfo[0]);
RightsInfo rightsInfo = conductor1.getUserRightsForContent(userID, contentInfo[0]);
if (rightsInfo == null)
System.out.println("rightsInfo is null");
printRightsInfo(rightsInfo);
int numSimplePlays = 0;
int numUnrestrictedPlays =0;
int numRecords = 0;
int numForwards = 0;
int numRewinds = 0;
if (rightsInfo.verbElements != null) {
System.out.println("in my_account.jsp: size of verbElements " +rightsInfo.verbElements.length);
for (int k=0;k<rightsInfo.verbElements.length;k++){
if (rightsInfo.verbElements[k].verbName.equals("SimplePlay") && rightsInfo.verbElements[k].verbArgName.equals("COUNT")) {
numSimplePlays = Integer.parseInt(rightsInfo.verbElements[k].verbArgValue);
System.out.println("numSimplePlays set to "+ numSimplePlays);
} else if (rightsInfo.verbElements[k].verbName.equals("ForwardPlay") && rightsInfo.verbElements[k].verbArgName.equals("COUNT")) {
numForwards = Integer.parseInt(rightsInfo.verbElements[k].verbArgValue);
System.out.println("numForwards set to "+numForwards );
} else if (rightsInfo.verbElements[k].verbName.equals("ReversePlay") && rightsInfo.verbElements[k].verbArgName.equals("COUNT")) {
numRewinds = Integer.parseInt(rightsInfo.verbElements[k].verbArgValue);
System.out.println("numRewinds set to "+numRewinds );
} else if (rightsInfo.verbElements[k].verbName.equals("Record") && rightsInfo.verbElements[k].verbArgName.equals("COUNT")) {
numRecords = Integer.parseInt(rightsInfo.verbElements[k].verbArgValue);
System.out.println("numRecords set to "+numRecords);
}
}
if (numForwards < numRewinds)
numUnrestrictedPlays = numForwards;
else
numUnrestrictedPlays = numRewinds;
numSimplePlays -= numUnrestrictedPlays;
}
%>
<td class="subsong_detail" align="center" colspan="2"><%=numSimplePlays%></td>
<td> </td>
<td> </td>
<td class="subsong_detail" align="center" colspan="2"><%=numUnrestrictedPlays%></td>
<td class="subsong_detail" align="center" colspan="2"><%=numRecords%></td>
<%
if ((numSimplePlays != 0) || (numUnrestrictedPlays!=0)) {
int numPlays = numUnrestrictedPlays;
String playMode = "UnrestrictedPlay";
if (numPlays == 0) {
numPlays = numSimplePlays;
playMode = "SimplePlay";
}
%>
<td class="subsong_detail" align="center" colspan="2"><%=(contentInfo[3] == null? "N/A":"<a href=\""+contentInfo[3]+"\" style=\"text-decoration:none\">Play</a>")%></td>
<td class="subsong_detail" align="center" colspan="4"><a href="transfer_rights.jsp?item_id=<%=contentInfo[0]%>&item_title=<%=(contentInfo[4]==null?"":contentInfo[4])%>&jsp_path=<%=jspPath%>&numPlays=<%=numPlays%>&numRecords=<%=numRecords%>&playMode=<%=playMode%>" style="text-decoration:none">Transfer</a></td>
<td class="subsong_detail" align="center" colspan="4"><a href="assert_fairuse.jsp?item_id=<%=contentInfo[0]%>&item_title=<%=(contentInfo[4]==null?"":contentInfo[4])%>&jsp_path=<%=jspPath%>&numPlays=<%=numPlays%>&numRecords=<%=numRecords%>&playMode=<%=playMode%>" style="text-decoration:none">Assert</a></td>
<%
} else {
%>
<td class="subsong_detail" align="center" colspan="2">License expired</td>
<td align="center" colspan="4"> </td>
<td align="center" colspan="4"> </td>
<%
}
%>
</tr>
<%
}
} else {
%>
<tr>
<td class="body_text" colspan="26" style="font-size:9px;color:red"> You do not have any available contents to download at this time</td>
</tr>
<%
}
%>
</table>
</td>
</tr>
</table>
</td>
<%@ include file = "footer.jsp" %>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -