📄 own.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" language="java"
import="java.sql.*,music.*" errorPage="" %>
<html>
<head></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>
</tr>
<% String sql=null;
String id=LoadDriver.convert(request.getParameter("id"));
String imageid=LoadDriver.convert(request.getParameter("imageid"));
DBManager db=DBManager.getInstance("localhost","music","root","589060");
ResultSet rs=null;
if(imageid!=null)
{
sql="insert into own(imageid,singerid) values('"+imageid+"','"+id+"')";
db.executeUpdate(sql);
}
sql="select * from image where id not in (select imageid from own )";
rs=db.executeQuery(sql);
if(!rs.next())
out.print("没有图片信息记录！");
else
do
{%>
<tr>
<form method="post" action="own.jsp">
<input type="hidden" name="id" value="<%=id%>" >
<input type="hidden" name="imageid" value="<%=rs.getString(1)%>" >
<td><img src=<%=rs.getString(5).substring(1)%> width="168" height="100" ></td>
<td><%=rs.getString(2)%></td>
<td><%=rs.getString(3)%></td>
<td><%=rs.getString(4)%></td>
<td><%=rs.getString(6)%></td>
<td><input type="submit" value="选择" ></td>
</form>
</tr>
<%
}while(rs.next());
%>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -