📄 musicadmin.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page language="java" import="java.sql.*"%>
<%@page import="java.io.*"%>
<html>
<head>
<link rel="stylesheet" href="css/css.css" type="text/css" /><title>
音乐删除
</title>
</head>
<body bgcolor="#ffffff">
<%
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String db=getServletContext().getRealPath("\\")+"music.mdb";
File dbpath=new File(db);
String path = new java.io.File(db).getAbsolutePath();
Connection conn= DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};" +
"DBQ="+path);
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select id,music,name from mp3 ");
int rowNum=0;
int Total=0;
int id;%>
<Table Border="0" align="center" class="table">
<TR class="1">
<TH width=100>歌曲</th>
<TH width=100>艺术家</th>
<TH width=100>删除</th>
</TR>
<%
while(rs.next())
{
rowNum++;
String name=rs.getString(2);
id=rs.getInt(1);
String geshou=rs.getString(3);
%>
<tr>
<td width=100 class="2" align="center"><%=name%></td>
<td width=100 class="2" align="center"><%=geshou%></td>
<td width=100 align="center" class="2"><a href=delet.jsp?id=<%=id%> ><img src=delet.gif></a></td>
</tr>
<%
}
}
catch(Exception e)
{
out.println(e);
}
%>
</Table>
<br>
<center><a href="javascript:window.close();">关闭窗口</a>
<a href="index.jsp">返回主页</a></center>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -