📄 songsetlist.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" language="java"
import="java.util.*,java.sql.*,music.*" %>
<html>
<head><title>专辑管理</title></head>
<body bgcolor="">
<table width=500 border=1 align="center" cellPadding=5 cellSpacing=0 borderColor=#afb5ff >
<tr>
<th>专辑名</th>
<th>专辑类别</th>
<th>专辑地区</th>
<th>专辑描述</th>
<th>更新</th>
<th>删除</th>
<th>选择专辑所含歌曲</th>
<th>取消选择专辑所含歌曲</th>
</tr>
<%
DBManager db=DBManager.getInstance("localhost","music","root","589060");
String id=LoadDriver.convert(request.getParameter("id"));
String sql=null;
Connection con=db.getCon();
if(id!=null){
try{
con.setAutoCommit(false);
sql="delete from publish where songsetid="+id;
db.executeUpdate(sql);
sql="delete from comefrom where songsetid="+id;
db.executeUpdate(sql);
sql="delete from songset where id="+id;
db.executeUpdate(sql);
con.commit();
con.setAutoCommit(true);
out.print("删除成功！");
}
catch(Exception e){
con.rollback();
out.print("删除失败！");
}
}
sql="select * from songset";
ResultSet rs=db.executeQuery(sql);
if(!rs.next())
out.print("没有相关记录！");
else
do
{ %>
<tr>
<form method="post" action="modifysongset.jsp">
<input type=hidden name="id" value="<%=rs.getString(1)%>">
<input type=hidden name="name" value="<%=rs.getString(2)%>">
<input type=hidden name="kind" value="<%=rs.getString(3)%>">
<input type=hidden name="district" value="<%=rs.getString(4)%>">
<input type=hidden name="description" value="<%=rs.getString(5)%>">
<td><%=rs.getString(2)%></td>
<td><%=rs.getString(3)%></td>
<td><%=rs.getString(4)%></td>
<td><%=rs.getString(5)%></td>
<td><input type="submit" value="更新" ></td>
<td><a href="songsetlist.jsp?id=<%=rs.getString(1)%>">删除</a></td>
<td><a href="comefrom.jsp?id=<%=rs.getString(1)%>">进入...</a></td>
<td><a href="cancelcomefrom.jsp?id=<%=rs.getString(1)%>">进入...</a></td>
</form>
</tr>
<%
}while(rs.next());
%>
</table>
<p><center><a href="addsongset.jsp" >插入新专辑...</a></center></p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -