📄 search_base.jsp
字号:
<%@ 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 + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -