📄 displayfloinfo.jsp
字号:
<%@ page contentType="text/html;charset=GBK"%>
<%
if(session.getAttribute("midentity")==null)
{
// request.setAttribute("result","您没有权力进入此页");
// getServletContext().getRequestDispatcher("display.jsp").forward(request,response);
response.sendRedirect("FlowerIndex.jsp");
}
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<title>untitled</title>
<link href="css/jdeveloper.css" rel="stylesheet" media="screen"/>
</head>
<body>
<table cellspacing="0" cellpadding="0" border="0" width="578" align="left">
<tr>
<td>
<H1 align="center">花卉基本信息查询结果</H1>
<form>
<table cellspacing="0" cellpadding="0" border="1" width="90%" align="center">
<tr>
<td>花卉编号</td>
<td>花卉名称</td>
<td>花卉类别</td>
<td>花卉颜色</td>
<td>花卉图片</td>
<td>花卉描述</td>
<td> </td>
<td> </td>
</tr>
<%
Connection con=null;
Iterator it=null;
Flowerinfo fi=null;
PreparedStatement pstmt=null;
ResultSet rs=null;
try
{
Collection c=null;
c=(Collection)request.getAttribute("FlowerInfo");
it=(Iterator)c.iterator();
while(it.hasNext())
{
fi=(Flowerinfo)it.next();
%>
<tr>
<td><%=fi.getFlowerid()%></td>
<td><%=fi.getFlowername()%></td>
<%
con=DBConnect.getConnection();
pstmt=con.prepareStatement("select * from FlowerType where FlowerTypeid=?");
pstmt.setString(1,fi.getFlowertypeid());
rs=pstmt.executeQuery();
while(rs.next())
{
%>
<td><%=rs.getString(2)%></td>
<%
}
rs.close();
pstmt.close();
con.close();
%>
<td><%=fi.getFlowercolor()%></td>
<td><img src="<%=fi.getFlowerphoto()%>" height="100" width="100"></img></td>
<td><%=fi.getFlowerdescription()%></td>
<td><a href=Flowerinfoupdate.jsp?flowerid=<%=fi.getFlowerid()%>>修改</a></td>
<td><a href=flowerinfoservlet?action=del&flowerid=<%=fi.getFlowerid()%>>删除</a></td>
</tr>
<%
}
}
catch(Exception ex)
{
ex.printStackTrace();
}
%>
</table>
<P>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.Collection"%>
<%@ page import="java.util.Iterator"%>
<%@ page import="Flower.model.FlowerInfoBean"%>
<%@ page import="Flower.model.Flowerinfo"%>
<%@ page import="Flower.model.DBConnect"%>
<a href="ManagerMain.jsp">返回管理员主页</a>
</P>
</form>
<P> </P>
<P> </P>
<P> </P>
</td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -