data.jsp

在线影音网站

<style type="text/css">
<!--
body {
	background-color: #216184;
}
-->
</style><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" class="style1"><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/DataAdd.jsp" style="color:#FFFFFF " ><%=strto.toChinese("数据添加")%></a></div></td>
              </tr>
              <tr>
                <td width="22" height="30"><div align="center">ID</div></td>
                <td width="134" height="30"><div align="center"><%=strto.toChinese("名称")%></div></td>
                <td width="67" height="30"><div align="center"><%=strto.toChinese("类别")%></div></td>
                <td width="78" height="30"><div align="center"><%=strto.toChinese("歌手")%></div></td>
                <td height="30"><div align="center"><%=strto.toChinese("操作")%></div></td>
              </tr>
              <% String sqldata="select * from tb_Audio";
				 ResultSet rsdata=con.executeQuery(sqldata);
									  while(rsdata.next())
									  {
									  	String ID=rsdata.getString("ID");
									  	String Name=rsdata.getString("Name");
									  	String Actor=rsdata.getString("Actor");
									  	String Style=rsdata.getString("Style");
									  %>
              <tr>
                <td height="18"><div align="center"><%=ID%></div></td>
                <td height="18"><div align="center"><%=Name%></a></div></td>
					<td height="18"><div align="center"><%=Style%></div></td>
                <td height="18"><div align="center"><%=Actor%></div></td>
				 <td height="18"><div align="center"><a href="../Manage/Audio/Datadel.jsp?ID=<%=ID%>"><font color="#FFFFFF"><%=strto.toChinese("删除")%></font></a></div></td> 
              </tr>
              <% }rsdata.close();
									  %>
          </table></td>
        </tr>
    </table></td>
  </tr>
</table>