search_base.jsp

来自「基于WEB的会议管理系统」· JSP 代码 · 共 54 行

JSP
54
字号
<%@ page language="java" import="java.util.*" pageEncoding="GB18030"%>
<jsp:useBean id="meet" class="com.meet.bean.meeting" scope="page"/>
<%@page import="java.sql.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>   
    <title>会议管理系统---$--J2EE</title>
  </head>
  
  <body background="../file/bg.jpg">
   <center>
   <%@include file="top.jsp"%>
   <br>
   <p><font size="6" color="#6600FF">会议基本信息</font></p>
    <table  width="650" border="2" width="92%" bordercolorlight="#3399FF" bordercolordark="#FFFFFF" align="center">
    <tr>
      <td width="10%" align="center">ID号</td>
      <td width="40%" align="center">会议主题</td>
      <td width="15%" align="center">会议类型</td>
      <td width="20%" align="center">会议状态</td>
      <td width="10%" align="center">更新</td>
    </tr>
    <%
     
      String key=meet.codeToString(request.getParameter("key"));
      String type=request.getParameter("type");
      String str=null;
      ResultSet rs=null;
      int i=0; 
      if("1".equalsIgnoreCase(type))
      str="select * from base where meet_title like '%"+key+"%'";
      else if("2".equals(type))
      str="select * from base where meet_type like '%"+key+"%'";
      else if("3".equalsIgnoreCase(type))
      str="select * from base where meet_state like '%"+key+"%'";
      else str="select * from taile where meet_ID=1001";
      rs=meet.executeFind(str);
      i=rs.getRow();    
      while(rs!=null&&rs.next())
      { int id=rs.getInt("meet_ID");
        out.println("<tr><td>"+rs.getInt("meet_ID")+"</td>");
        out.println("<td>"+rs.getString("meet_title")+"</td>");
        out.println("<td>"+rs.getString("meet_type")+"</td>");
        out.println("<td>"+rs.getString("meet_state")+"</td>");
       %>
       <td width="10%" align="center"><a href="detaile.jsp?id=<%=id%>">更新</a></td>
      <%} %>
       </table>
       </center>
       <%@include file="foot.jsp" %>
  </body>

</html>

⌨️ 快捷键说明

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