⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 displayfloinfo.jsp

📁 精美的画面。完善的功能
💻 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>&nbsp;</td>
                <td>&nbsp;</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"%>
              &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="ManagerMain.jsp">返回管理员主页</a>
            </P>
          </form>
          <P>&nbsp;</P>
          <P>&nbsp;</P>
          <P>&nbsp;</P>
        </td>
      </tr>
    </table>
  </body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -