list.jsp

在线影音网站

<table width="380" height="440" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td colspan="4" valign="top"><table width="380" height="60" border="0" cellpadding="0" cellspacing="0"   style="color:#FFFFFF ">
        <tr>
          <td height="20" colspan="4"><div align="center"><%=strto.toChinese("音 乐 目 录 管 理 ")%></div></td>
        </tr>
        <tr>
          <td colspan="4"><table width="375" border="0" align="center" cellpadding="2" cellspacing="2" style="color:#FFFFFF ">
              <tr>
                <td height="10" colspan="5"><div align="right"><a href="Audio/addlist.jsp" style="color:#FFFFFF " ><%=strto.toChinese("目录添加")%></a></div></td>
              </tr>
              <tr>
                <td height="30"><div align="center"><%=strto.toChinese("ID")%></div></td>
                <td height="30"><div align="center"><%=strto.toChinese("等级")%></div></td>
                <td height="30"><div align="center"><%=strto.toChinese("名称")%></div></td>
                <td height="30"><div align="center"><%=strto.toChinese("父级名称")%></div></td>
                <td height="30"><div align="center"><%=strto.toChinese("操作")%></div></td>
              </tr>
              <% String sqlmanlist="select * from tb_AudioList";
		     	 ResultSet rsmanlist=con.executeQuery(sqlmanlist);
				 while(rsmanlist.next())
				 {	
				 	String ID=rsmanlist.getString("ID");
				 	String Grade=rsmanlist.getString("Grade");
				 	String Name=rsmanlist.getString("Name");
				 	String Father=rsmanlist.getString("Father");
									  %>
              <tr>
                <td height="18"><div align="center"><%=ID%></div></td>
                <td height="18"><div align="center"><%=Grade%></div></td>
                <td height="18"><div align="center"><%=Name%></div></td>
                <td height="18"><div align="center"><%=Father%></div></td>
				<td height="18"><div align="center"><a href="../Manage/Audio/delete.jsp?ID=<%=ID%>"><font color="#FFFFFF"><%=strto.toChinese("删除")%></font></a></div></td>
				</form>
              </tr>
              <% }
			  rsmanlist.close();
									  %>
          </table></td>
        </tr>
    </table></td>
  </tr>
</table>