📄
字号:
范例manager_meeting.jsp的源代码
001 <%@ page errorPage="ErrPage.jsp"
002 import="Java.util.Date, Java.sql.*"
003 contentType="text/html;charset=gb2312"%>
004 <JSP:useBean id="pool" scope="application" class="com.PoolBean"/>
005 <%
006 String strLoginUser = (String)session.getAttribute("LoginUser");
007 if (strLoginUser == null || strLoginUser.length() == 0)
008 response.sendRedirect("../Login.jsp");
009 %>
10 <HTML>
011 <HEAD>
012 <LINK REL="stylesheet" HREF="../littleproject.css" TYPE="text/css">
013 <TITLE>会务管理</TITLE>
014 </HEAD>
015 <BODY bgcolor=LightBlue>
016 <%
017 try{
018 //得到注册用户的用户名
019 if (pool.getConnectionSize() == 0)
020 {
021 pool.initializePool();
022 }
023 Connection con = null;
024 Statement stmt = null;
025 ResultSet rs=null;
026 int PageSize = 10; //设置每张网页显示十条记录
027 int ShowPage = 1; //设置欲显示的页数
028 int RowCount = 0; //ResultSet的记录笔数
029 int PageCount = 0; //ResultSet分页后的总页数
030 int p,m,n;
031 double box_1=0;
032 double box_2=0;
033 con = pool.getConnection();
034 stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
035 ResultSet.CONCUR_READ_ONLY);
036 //建立Statement对象, 并设置记录指标类型为可前后移动
037 String sql=null;
038 String search_txt="";
039 String ToPage = request.getParameter("ToPage");
040 String box_title="";
041 String box_place="";
042 if (request.getParameter("box_title") != null
043 && !request.getParameter("box_title").equals(""))
044 {
045 box_title= new
046 String(request.getParameter("box_title").trim().getBytes("8859_1"));
047 if (box_title != null && !box_title.equals(""))
048 {
049 box_1=Double.parseDouble(box_title);
050 }
051 }
052 if (request.getParameter("box_place") != null
053 && !request.getParameter("box_place").equals(""))
054 {
055 box_place= new
056 String(request.getParameter("box_place").trim().getBytes("8859_1"));
057 if (box_place != null && !box_place.equals(""))
058 {
059 box_2=Double.parseDouble(box_place);
060 }
061 }
062 if (request.getParameter("search_txt") != null
063 && !request.getParameter("search_txt").equals(""))
064 {
065 search_txt = new
066 String(request.getParameter("search_txt").trim().getBytes("8859_1"));
067 }
068 if (search_txt != null && !search_txt.equals("")) //
069 {
070 if(box_1==0 && box_2==0 )
071 {
072 sql="select * from meeting where num like '%" + search_txt + "%'";
073 sql=sql + " or title like '%" + search_txt + "%'";
074 sql=sql + " or begin_time like '%" + search_txt + "%' or end_time like
075 '%" + search_txt + "%'";
076 sql=sql + " or place like '%" + search_txt + "%'";
077 sql=sql + "order by num";
078 }
079 else
080 {
081 sql="select * from meeting where";
082 if(box_1==1)
083 {
084 sql=sql + " title like '%" + search_txt + "%'";
085 }
086 if(box_2==1)
087 {
088 if(box_1==0)
089 {
090 sql=sql + " place like '%" + search_txt + "%'";
091 }
092 else
093 {
094 sql=sql + " or place like '%" + search_txt + "%'";
095
096 }
097 }
098 sql=sql + " order by num";
099 }
100 }
101 else
102 {
103 sql="SELECT id,num,title,place FROM meeting order by num";
104 }
105 rs = stmt.executeQuery(sql);
106 rs.last(); //将指标移至最后一笔记录
107 RowCount = rs.getRow(); //取得ResultSet中记录的笔数
108 PageCount = ((RowCount % PageSize) == 0 ?
109 (RowCount/PageSize) : (RowCount/PageSize)+1);
110 //计算显示的页数
111 //判断是否可正确取得ToPage参数,
112 //可取得则表示JSP网页应显示特定分页记录的语句
113 if(ToPage != null)
114 {
115 //取得指定显示的分页页数
116 ShowPage = Integer.parseInt(ToPage);
117 //下面的if语句将判断用户输入的页数是否正确
118 if(ShowPage > PageCount)
119 {
120 //判断指定页数是否大于总页数, 是则设置显示最后一页
121 ShowPage = PageCount;
122 }
123 else if(ShowPage <= 0)
124 { //若指定页数小于0, 则设置显示第一页的记录
125 ShowPage = 1;
126 }
127 }
128 rs.absolute((ShowPage - 1) * PageSize + 1);
129 //计算欲显示页的第一笔记录位置
130 %>
131 <center>
132 <table border="0" width="800">
133 <tr>
134 <td colspan="2">
135 <font size="6" face="隶书">会议管理首页</font>
136 </td>
137 </tr>
138 <tr>
139 <td width="600" height="10">
140 <%
141 if (search_txt != null && !search_txt.equals(""))
142 {
143 %>
144 下是包含关键字<font color="#ff0000"><%=search_txt%></font>的所有信息
145 <%
146 }
147 else
148 {
149 %>
150 以下是所有的信息
151 <%
152 }
153 %>
154 共:
155 <font color="blue">
156 <%=RowCount%>
157 </font>条 共
158 <font color="blue">
159 <%=PageCount%>
160 </font>页 当前页为第
161 <font color="red">
162 <%=ShowPage%>
163 </font>页
164 <%
165 if (PageCount>1)
166 {
167 if (ShowPage-3>0)
168 {
169 m=ShowPage-3;
170 }
171 else
172 {
173 m=1;
174 }
175 if (ShowPage+3<PageCount)
176 {
177 n=ShowPage+3;
178 }
179 else
180 {
181 n=PageCount;
182 }
183 %>
184 转到页码:[
185 <%
186 for( p=m;p<=n;p++)
187 {
188 if( ShowPage==p )
189 {
190 %>
191 <font color="red"><b><%=p%></b></font>
192 <%
193 }
194 else
195 {
196 %>
197 <a <%
198 if (ShowPage==p)
199 {
200 %>
201 style="color:red"
202 <%
203 }
204 %>
205 href="manager_meeting.jsp?ToPage=<%=p%>&search_txt=<%=search_txt%>
206 &box_title=<%=box_title %>&box_place=<%=box_place %>">
207 <%=p%>
208 </a>
209 <%
210 }
211 }
212 %>
213 ]
214 <%
215 }
216 %>
217 </td>
218 <td width="200" align="right">
219 <a href="manager_meeting_add.jsp">新建会议</a>
220
221 <img border="0" src="../images/enter.gif" width="30" height="30">
222 <a href="../default.jsp">
223 退出管理
224 </a>
225 </td>
226 </tr>
227 </table>
228 <TABLE border=1 bordercolor=RoyalBlue bgcolor=LightBlue width=800>
229 <tr>
230 <TD bgcolor=LightYellow width=50 align=center>序号</TD>
231 <TD bgcolor=LightYellow width=350 align=center>会议主题</TD>
232 <TD bgcolor=LightYellow width=250 align=center>会议地址</TD>
233 <TD bgcolor=LightYellow width=75 align=center>修改</TD>
234 <TD bgcolor=LightYellow width=75 align=center>删除</TD>
235 </tr>
236 <%
237 //利用For循环配合PageSize属性输出一页中的记录
238 for(int i = 1; i <= PageSize; i++)
239 {
240 int select_id = rs.getInt("id");
241 int select_num = rs.getInt("num");
242 String select_title= rs.getString("title");
243 String select_place= rs.getString("place");
244 out.println("<TR>");
245 out.println("<TD align=center width=50>" + select_num +"</TD>");
246 out.println("<TD align=center width=350>" + select_title +"</TD>");
247 out.println("<TD align=center width=250>" + select_place +"</TD>");
248 out.println("<TD align=center width=75>
249 <a href=manager_meeting_edit.jsp?num="+select_num+">修改</a>
250 </TD>");
251 out.println("<TD align=center width=75>
252 <a href=manager_meeting_delete.jsp?num="+select_num+">删除</a>
253 </TD>");
254 out.println("</TR>");
255 if(!rs.next()) //判断是否到达最后一笔记录
256 break; //跳出for循环
257 }
258 %>
259
260 </TABLE>
261 <TABLE border="0" width="700">
262 <TR valign=baseline align=center>
263 <td width=500> </td>
264 <%
265 if(ShowPage != 1)
266 {
267 %>
268 <TD Width=50>
269 <A Href=manager_meeting.jsp?ToPage=<%= 1 %>
270 &search_txt=<%=search_txt%>&box_title=<%=box_title %>
271 &box_place=<%=box_place %>>第一页</A>
272 </TD>
273 <TD Width=50>
274 <A Href=manager_meeting.jsp?ToPage=<%= ShowPage - 1 %>
275 &search_txt=<%=search_txt%>&box_title=<%=box_title %>
276 &box_place=<%=box_place %>>上一页</A>
277 </TD>
278 <%
279 }
280 if(ShowPage != PageCount)
281 {
282 %>
283 <TD Width=50>
284 <A Href=manager_meeting.jsp?ToPage=<%= ShowPage + 1%>
285 &search_txt=<%=search_txt%>&box_title=<%=box_title %>
286 &box_place=<%=box_place %>>下一页</A>
287 </TD>
288 <TD Width=50>
289 <A Href=manager_meeting.jsp?ToPage=<%= PageCount %>
290 &search_txt=<%=search_txt%>&box_title=<%=box_title %>
291 &box_place=<%=box_place %>>最后页</A>
292 </TD>
293 <%
294 }
295 %>
296 </TR>
297 </TABLE>
298 <FORM action=manager_meeting.jsp method=POST>
299 <table border="0" width="800" align="center" cellspacing="0">
300 <tr>
301 <td align="center">
302 <input type="checkbox" name="box_title" value="1">会议主题
303 <input type="checkbox" name="box_place" value="1">会议地址
304 </td>
305 </tr>
306 <tr>
307 <td width="700" align="center">
308 <img border="0" src="../images/search.gif" width="30" height="25">
309 信息关键字搜索:
310 <input type="text" name="search_txt" size="17"
311 value="<%=search_txt%>">
312 <input type="submit" value="搜索" name="B1">
313 </td>
314 </tr>
315 <tr>
316 <td width="700" align="center">
317 <font color="red">(如果关键字内容为空则列出所有信息)</font>
318 </td>
319 </tr>
320 </table>
321 </form>
322 </CENTER>
323 <%
324 if (rs != null) rs.close();
325 pool.releaseConnection(con);
326 }
327 catch(Exception e)
328 {
329 System.out.println("Exception: " + e.getMessage());
330 }
331 %>
332 </BODY>
333 </HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -