燃尽图：
任务板：
会议照片：
昨天完成的任务：修改了发布表单添加了上传图片的功能，并且能够在信息展示兰中显示失物相关的描述图片
今天的任务：用户可以发表意见表，同时按照失物丢失时间查询和捡到时间查询，对查询结果加上相关图片的描述
明天的任务：做普通用户的个人中心，对寻物表单和招领表单进行修改和删除，并且完善管理界面，增加一些选择性删除等小功能。
<%@ page language="java" contentType="text/html;charset=UTF-8" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html lang="zxx">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>查询</title>
<!-- Meta tag Keywords -->
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="keywords" content="" />
<script>
addEventListener("load", function() {
setTimeout(hideURLbar, 0);
}, false);
function hideURLbar() {
window.scrollTo(0, 1);
}
</script>
<!-- //Meta tag Keywords -->
<!-- Custom-Files -->
<link rel="stylesheet" href="css/bootstrap.css">
<!-- Bootstrap-Core-CSS -->
<link rel="stylesheet" href="css/style.css" type="text/css" media="all" />
<link rel="stylesheet" href="css/slider.css" type="text/css" media="all" />
<!-- Style-CSS -->
<!-- font-awesome-icons -->
<link href="css/font-awesome.css" rel="stylesheet">
<!-- //font-awesome-icons -->
<!-- /Fonts -->
<link href="http://fonts.googleapis.com/css?family=Catamaran:100,200,300,400,500,600,700,800" rel="stylesheet">
<!-- //Fonts -->
</head>
<%
String shouj="手机";
String fk="饭卡";
String shuj="书";
String sfz="身份证";
%>
<body>
<%
if(session.getAttribute("userName")==null)
{
response.sendRedirect("jiemian.jsp");
}
%>
<!-- mian-content -->
<div class="main-w3-pvt-header-sec page-w3pvt-inner" id="home">
<div class="overlay-innerpage">
<!-- header -->
<header>
<div class="container">
<div class="header d-lg-flex justify-content-between align-items-center py-lg-3 px-lg-3">
<!-- logo -->
<div id="logo">
<h1><a href="index.jsp"><span class="fa fa-recycle mr-2"></span>返回首页</a></h1>
</div>
<!-- //logo -->
<div class="w3pvt-bg">
<!-- nav -->
<div class="nav_w3pvt">
<nav>
<label for="drop" class="toggle">Menu</label>
<input type="checkbox" id="drop" />
<ul class="menu">
<li><a href="index.jsp">首页</a></li>
<li>
<!-- First Tier Drop Down -->
<label for="drop-2" class="toggle toogle-2">表单信息 <span class="fa fa-angle-down" aria-hidden="true"></span>
</label>
<a href="blog.jsp">失物寻物信息栏 <span class="fa fa-angle-down" aria-hidden="true"></span></a>
<input type="checkbox" id="drop-2" />
<ul>
<li><a href="blog.jsp" class="drop-text">寻物启事</a></li>
<li><a href="blog1.jsp" class="drop-text">失物招领</a></li>
</ul>
</li>
<li>
<label for="drop-2" class="toggle toogle-2">发布信息 <span class="fa fa-angle-down" aria-hidden="true"></span>
</label>
<a href="contact.jsp">发布信息 <span class="fa fa-angle-down" aria-hidden="true"></span></a>
<input type="checkbox" id="drop-2" />
<ul>
<li><a href="contact.jsp" class="drop-text">发布寻物启事</a></li>
<li><a href="contact1.jsp" class="drop-text">发布失物招领</a></li>
</ul>
</li>
<li><a href="search.jsp">查询</a></li>
</ul>
</nav>
</div>
<!-- //nav -->
<div class="justify-content-center">
<!-- search -->
<div class="apply-w3-pvt ml-lg-3">
<a class="btn read" href="linshi.jsp" role="button"><%=session.getAttribute("userName")%></a>
</div>
<!-- //search -->
</div>
<div class="justify-content-center">
<!-- search -->
<div class="apply-w3-pvt ml-lg-3">
<a class="btn read" href="jiemian.jsp" role="button">退出</a>
</div>
<!-- //search -->
</div>
</div>
</div>
</div>
</header>
<!-- //header -->
<!-- /banner-inner -->
<!-- //banner-inner -->
</div>
</div>
<!-- //banner -->
<!-- //banner-botttom -->
<section class="content-info py-5">
<div class="container py-md-5">
<h3 class="title-w3ls mb-5 text-center">查询及帮助</h3>
<div class="row">
<!-- left side -->
<div class="col-lg-8 single-left">
<div class="single-left1">
<h5 class="card-title">
功能说明
</h5>
<p>你要是丢东西啦可以在右侧通过物品的描述，物品的丢失地点以及丢失物品的时间查询失物招领，看看有没有同学捡到你的东西。<br>
你要是捡到东西啦也可以在右侧通过物品的描述，捡到物品的地方以及捡到物品的时间查询寻物启事，看看有没有同学在找你捡到的东西。
</p>
<div class="mt-4">
<span class="badge badge-primary">Posted 2019-04-02 10:05:00</span>
<div class="float-sm-right">
<a href="#" class="badge badge-secondary">ToPD</a>
<a href="#" class="badge badge-success">龙哥</a>
<a href="#" class="badge badge-danger">媛姐</a>
</div>
</div>
<hr>
<img src="images/three.png" alt=" " class="img-fluid" />
<ul class="courses_list my-4">
<li>
<h6 class="courses-first text-bl">
<span class="fa fa-user mr-2"></span>three
</h6>
</li>
<li>
<a>
<span class="fa fa-heart mr-1"></span>
</a>
</li>
<li>
<a>
<span class="fa fa-comments mr-1"></span>
</a>
</li>
</ul>
<h5 class="card-title">
<a href="single.html" class="text-bl">感谢！！！</a>
</h5>
<p>您的每一次使用都会给我们涨学分！！！</p>
<p>您的每一次使用都会给我们涨学分！！！</p>
<p>您的每一次使用都会给我们涨学分！！！</p>
</div>
<div class="admin p-4 my-4">
<p>
<span class="fa fa-quote-left mr-2"></span>你是一个礼物，却不能拆封。像夏夜绽放在天空的烟火，灿烂缤纷，无法触摸。像遥远的星星，在晴朗的夜空下，静静在头顶，仿佛为我存在，我们之间却有几亿光年的距离。但，无论如何，亲爱的朋友，感谢你出现在我的生命里。
<span class="fa fa-quote-right ml-2"></span>
</p>
<a class="mt-3 font-weight-bold text-right blockquote-footer">作者：寂地 出处：缺氧</a>
</div>
<div class="leave-coment-form text-left">
<h3 class="courses-title mb-4">意见表</h3>
<form action="addServlet?method=addTip" method="post">
<div class="row">
<div class="col-sm-6 form-group">
<input type="text" name="Name" class="form-control" placeholder="姓名" required="required">
</div>
<div class="col-sm-6 form-group">
<input type="email" name="Email" class="form-control" placeholder="邮箱" required="required">
</div>
</div>
<div class="form-group">
<textarea name="Message" class="form-control" placeholder="意见" required="required"></textarea>
</div>
<div class="mm_single_submit">
<button type="submit" class="btn">提交</button>
</div>
</form>
</div>
</div>
<!-- //left side -->
<!-- right side -->
<div class="col-lg-4 event-right mt-lg-0 mt-5">
<div class="event-right1">
<div class="categories mt-4 p-sm-4 p-3 border">
<h3 class="courses-title ">按丢失时间查询</h3>
<form class="form-inline" action="searchsjsw.jsp" method="post" name="diushi" >
<table>
<tr>
<td>
<input class="form-control rounded-0 mr-sm-2" type="datetime-local" name="time" id="time">
</td>
</tr>
<tr>
<td colspan="2" align="center">
<button class="btn read mt-3" type="submit">查询</button>
</td>
</tr>
</table>
</form>
<br>
<h3 class="courses-title ">按捡到时间查询</h3>
<form class="form-inline" action="searchsjxw.jsp" method="post" name="diushi" >
<table>
<tr>
<td>
<input class="form-control rounded-0 mr-sm-2" type="datetime-local" name="time" id="time">
</td>
</tr>
<tr>
<td colspan="2" align="center">
<button class="btn read mt-3" type="submit">查询</button>
</td>
</tr>
</table>
</form>
</div>
<div class="categories mt-4 p-sm-4 p-3 border">
<h3 class="courses-title ">条件查询</h3>
<form class="form-inline" name="searchformsw" method="post" action="searchtjsw.jsp">
<table>
<tr bgcolor="#f5f5f5">
<td align="center" colspan="5">
条件查询失物招领：
<select name="subsql">
<option value="name">描述</option>
<option value="place">地点</option>
</select>
<input class="form-control rounded-0 mr-sm-2" type="text" name="subsqlvalue" size="17">
<button class="btn read mt-3" type="submit">查询</button>
</td>
</tr>
</table>
</form>
<form class="form-inline" name="searchformxw" method="post" action="searchtjxw.jsp">
<table>
<tr bgcolor="#f5f5f5">
<td align="center" colspan="5">
条件查询寻物启事：
<select name="subsql">
<option value="name">描述</option>
<option value="place">地点</option>
</select>
<input class="form-control rounded-0 mr-sm-2" type="text" name="subsqlvalue" size="17">
<button class="btn read mt-3" type="submit">查询</button>
</td>
</tr>
</table>
</form>
</div>
<div class="categories mt-4 p-sm-4 p-3 border">
<h3 class="courses-title ">常用</h3>
<ul>
<li class="mt-3">
<span class="fa fa-check mr-2"></span>
<a href="hot.jsp?subsql=name&&subsqlvalue=手机"> 找手机 </a>
</li>
<li class="mt-3">
<span class="fa fa-check mr-2"></span>
<a href="hot.jsp?subsql=name&&subsqlvalue=饭卡">找饭卡</a>
</li>
<li class="mt-3">
<span class="fa fa-check mr-2"></span>
<a href="hot.jsp?subsql=name&&subsqlvalue=书">找书籍</a>
</li>
<li class="mt-3">
<span class="fa fa-check mr-2"></span>
<a href="hot.jsp?subsql=name&&subsqlvalue=身份证">找身份证</a>
</li>
</ul>
</div>
<div class="tags mt-4 p-4 border">
<h3 class="courses-title">帮助</h3>
<ul class="mt-4">
<li>
<a href="" class="text-bl border">挂失饭卡</a>
</li>
<li>
<a href="" class="text-bl border">补办饭卡</a>
</li>
<li>
<a href="" class="text-bl border">挂失身份证</a>
</li>
<li>
<a href="" class="text-bl border">补办身份证</a>
</li>
</ul>
</div>
</div>
</div>
<!-- //right side -->
</div>
</div>
</section>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<jsp:useBean id="dao" class="Dao.Dao" scope="page"/>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link rel="stylesheet" href="css/style1.css" type="text/css" media="all" />
<title>查询结果</title>
<style>
.black_overlay{
display: none;
position: absolute;
top: 0%;
left: 0%;
100%;
height: 100%;
background-color: black;
z-index:1001;
-moz-opacity: 0.8;
opacity:.80;
filter: alpha(opacity=88);
}
.white_content {
display: none;
position: absolute;
top: 25%;
left: 25%;
55%;
height: 55%;
padding: 20px;
border: 10px solid orange;
background-color: white;
z-index:1002;
overflow: auto;
}
</style>
</head>
<body>
<%
if(session.getAttribute("userName")==null)
{
response.sendRedirect("jiemian.jsp");
}
%>
<!-- Header -->
<div id="header">
<div class="shell">
<!-- Logo + Top Nav -->
<div id="top">
<h1><a href="#">管理员界面</a></h1>
<div id="top-navigation">
欢迎 <a href="#"><strong>管理员</strong></a>
<span>|</span>
<a href="#">帮助</a>
<span>|</span>
<a href="index.jsp">退出</a>
<span>|</span>
</div>
</div>
<!-- End Logo + Top Nav -->
<!-- Main Nav -->
<div id="navigation">
<ul>
<li><a href="managerds.jsp" class="active"><span>失物信息管理</span></a></li>
<li><a href="managerjd.jsp"><span>招领信息管理</span></a></li>
<li><a href="usermanager.jsp"><span>用户管理</span></a></li>
</ul>
</div>
<!-- End Main Nav -->
</div>
</div>
<!-- End Header -->
<!-- Container -->
<div id="container">
<div class="shell">
<!-- Small Nav -->
<!-- End Small Nav -->
<!-- Message OK -->
<!--
<div class="msg msg-ok">
<p><strong>Your file was uploaded succesifully!</strong></p>
<a href="#" class="close">close</a>
</div> -->
<!-- End Message OK -->
<!-- Message Error -->
<!--
<div class="msg msg-error">
<p><strong>You must select a file to upload first!</strong></p>
<a href="#" class="close">close</a>
</div> -->
<!-- End Message Error -->
<br />
<!-- Main -->
<div id="main">
<div class="cl"> </div>
<!-- Content -->
<div id="content">
<!-- Box -->
<div class="box">
<!-- Box Head -->
<div class="box-head">
<h2 class="left">失物信息列表</h2>
</div>
<!-- End Box Head -->
<!-- Table -->
<form action="addServlet?method=deleteds" method="post">
<div class="table">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<th width="13"> </th>
<th>发布人</th>
<th>物品类别</th>
<th>丢失地点</th>
<th>丢失时间</th>
<th>详细信息</th>
<th width="110" class="ac">操作</th>
</tr>
<%
String userName = request.getParameter("userName");
ResultSet rs = dao.searchdsByuserName(userName);
int dsnumber = 1;
if(rs==null){
%>
<tr align="center" valign="middle"><td colspan="4">没有记录显示！</td>
</tr>
<%
}
else{
while(rs.next()){%>
<tr>
<td><input type="checkbox" class="checkbox" name="checkds" value="<%=rs.getInt("id") %>" /></td>
<td><h2><%=rs.getString("userName") %></h3></td>
<td><h3><%=rs.getString("name") %></h3></td>
<td><%=rs.getString("place") %></td>
<td><%=rs.getString("time") %></td>
<td><%=rs.getString("info") %></td>
<td><a onclick="return check()" href="deleteds.jsp?id=<%=rs.getString("id") %>" class="ico del">删除</a><a href="updateds.jsp?id=<%=rs.getString("id") %>" class="ico edit">修改</a></td>
</tr>
<%
dsnumber++;}
}%>
</table>
<script type="text/javascript">
function check() {
if (confirm("确定删除吗？")){
return true;
}else{
return false;
}
}
</script>
<!-- Pagging -->
<div class="pagging">
<div class="left">1-<%=dsnumber-1 %></div>
<div class="left">
<input type="submit"onclick="return check()" class="button" value="删除所选内容" />
</form>
</div>
<div class="right">
<a href="#">前一页</a>
<a href="#">1</a>
<a href="#">2</a>
<a href="#">3</a>
<a href="#">4</a>
<span>...</span>
<a href="#">下一页</a>
</div>
</div>
<!-- End Pagging -->
</div>
<!-- Table -->
</div>
<!-- End Box -->
<!-- Box -->
<div class="box">
<!-- Box Head -->
<div class="box-head">
<h2>添加备注记录</h2>
</div>
<!-- End Box Head -->
<form action="" method="post">
<!-- Form -->
<div class="form">
<p>
<span class="req">100字以内</span>
<label>备注主题<span>(必填)</span></label>
<input type="text" class="field size1" />
</p>
<p class="inline-field">
<label>日期</label>
<input type="datetime-local" class="field size1" name="date">
</p>
<p>
<span class="req">1000以内</span>
<label>备注内容 <span>(必填)</span></label>
<textarea class="field size1" rows="10" cols="30"></textarea>
</p>
</div>
<!-- End Form -->
<!-- Form Buttons -->
<div class="buttons">
<input type="submit" class="button" value="提交" />
</div>
<!-- End Form Buttons -->
</form>
</div>
<!-- End Box -->
</div>
<!-- End Content -->
<!-- Sidebar -->
<div id="sidebar">
<!-- Box -->
<div class="box">
<!-- Box Head -->
<div class="box-head">
<h2>管理</h2>
</div>
<!-- End Box Head-->
<div class="box-content">
<div class="cl"> </div>
<p class="select-all"><input type="checkbox" class="checkbox" /><label>选择全部</label></p>
<p><a href="#">其他</a></p>
<!-- Sort -->
<!-- End Sort -->
</div>
</div>
<!-- End Box -->
</div>
<!-- End Sidebar -->
<div class="cl"> </div>
</div>
<!-- Main -->
</div>
</div>
<!-- End Container -->
<!-- Footer -->
<div id="footer">
<div class="shell">
<span class="left"> </span>
<span class="right">
</span>
</div>
</div>
<!-- End Footer -->
</body>
</html>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<jsp:useBean id="dao" class="Dao.Dao" scope="page"/>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link rel="stylesheet" href="css/style1.css" type="text/css" media="all" />
<title>查询结果</title>
<style>
.black_overlay{
display: none;
position: absolute;
top: 0%;
left: 0%;
100%;
height: 100%;
background-color: black;
z-index:1001;
-moz-opacity: 0.8;
opacity:.80;
filter: alpha(opacity=88);
}
.white_content {
display: none;
position: absolute;
top: 25%;
left: 25%;
55%;
height: 55%;
padding: 20px;
border: 10px solid orange;
background-color: white;
z-index:1002;
overflow: auto;
}
</style>
</head>
<body>
<%
if(session.getAttribute("userName")==null)
{
response.sendRedirect("jiemian.jsp");
}
%>
<!-- Header -->
<div id="header">
<div class="shell">
<!-- Logo + Top Nav -->
<div id="top">
<h1><a href="#">管理员界面</a></h1>
<div id="top-navigation">
欢迎 <a href="#"><strong>管理员</strong></a>
<span>|</span>
<a href="#">帮助</a>
<span>|</span>
<a href="index.jsp">退出</a>
<span>|</span>
</div>
</div>
<!-- End Logo + Top Nav -->
<!-- Main Nav -->
<div id="navigation">
<ul>
<li><a href="managerds.jsp" class="active"><span>失物信息管理</span></a></li>
<li><a href="managerjd.jsp"><span>招领信息管理</span></a></li>
<li><a href="usermanager.jsp"><span>用户管理</span></a></li>
</ul>
</div>
<!-- End Main Nav -->
</div>
</div>
<!-- End Header -->
<!-- Container -->
<div id="container">
<div class="shell">
<!-- Small Nav -->
<!-- End Small Nav -->
<!-- Message OK -->
<!--
<div class="msg msg-ok">
<p><strong>Your file was uploaded succesifully!</strong></p>
<a href="#" class="close">close</a>
</div> -->
<!-- End Message OK -->
<!-- Message Error -->
<!--
<div class="msg msg-error">
<p><strong>You must select a file to upload first!</strong></p>
<a href="#" class="close">close</a>
</div> -->
<!-- End Message Error -->
<br />
<!-- Main -->
<div id="main">
<div class="cl"> </div>
<!-- Content -->
<div id="content">
<!-- Box -->
<div class="box">
<!-- Box Head -->
<div class="box-head">
<h2 class="left">失物信息列表</h2>
</div>
<!-- End Box Head -->
<!-- Table -->
<form action="addServlet?method=deleteds" method="post">
<div class="table">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<th width="13"> </th>
<th>发布人</th>
<th>物品类别</th>
<th>丢失地点</th>
<th>丢失时间</th>
<th>详细信息</th>
<th width="110" class="ac">操作</th>
</tr>
<%
String userName = request.getParameter("userName");
ResultSet rs = dao.searchjdByuserName(userName);
int dsnumber = 1;
if(rs==null){
%>
<tr align="center" valign="middle"><td colspan="4">没有记录显示！</td>
</tr>
<%
}
else{
while(rs.next()){%>
<tr>
<td><input type="checkbox" class="checkbox" name="checkds" value="<%=rs.getInt("id") %>" /></td>
<td><h2><%=rs.getString("userName") %></h3></td>
<td><h3><%=rs.getString("name") %></h3></td>
<td><%=rs.getString("place") %></td>
<td><%=rs.getString("time") %></td>
<td><%=rs.getString("info") %></td>
<td><a onclick="return check()" href="deleteds.jsp?id=<%=rs.getString("id") %>" class="ico del">删除</a><a href="updateds.jsp?id=<%=rs.getString("id") %>" class="ico edit">修改</a></td>
</tr>
<%
dsnumber++;}
}%>
</table>
<script type="text/javascript">
function check() {
if (confirm("确定删除吗？")){
return true;
}else{
return false;
}
}
</script>
<!-- Pagging -->
<div class="pagging">
<div class="left">1-<%=dsnumber-1 %></div>
<div class="left">
<input type="submit"onclick="return check()" class="button" value="删除所选内容" />
</form>
</div>
<div class="right">
<a href="#">前一页</a>
<a href="#">1</a>
<a href="#">2</a>
<a href="#">3</a>
<a href="#">4</a>
<span>...</span>
<a href="#">下一页</a>
</div>
</div>
<!-- End Pagging -->
</div>
<!-- Table -->
</div>
<!-- End Box -->
<!-- Box -->
<div class="box">
<!-- Box Head -->
<div class="box-head">
<h2>添加备注记录</h2>
</div>
<!-- End Box Head -->
<form action="" method="post">
<!-- Form -->
<div class="form">
<p>
<span class="req">100字以内</span>
<label>备注主题<span>(必填)</span></label>
<input type="text" class="field size1" />
</p>
<p class="inline-field">
<label>日期</label>
<input type="datetime-local" class="field size1" name="date">
</p>
<p>
<span class="req">1000以内</span>
<label>备注内容 <span>(必填)</span></label>
<textarea class="field size1" rows="10" cols="30"></textarea>
</p>
</div>
<!-- End Form -->
<!-- Form Buttons -->
<div class="buttons">
<input type="submit" class="button" value="提交" />
</div>
<!-- End Form Buttons -->
</form>
</div>
<!-- End Box -->
</div>
<!-- End Content -->
<!-- Sidebar -->
<div id="sidebar">
<!-- Box -->
<div class="box">
<!-- Box Head -->
<div class="box-head">
<h2>管理</h2>
</div>
<!-- End Box Head-->
<div class="box-content">
<div class="cl"> </div>
<p class="select-all"><input type="checkbox" class="checkbox" /><label>选择全部</label></p>
<p><a href="#">其他</a></p>
<!-- Sort -->
<!-- End Sort -->
</div>
</div>
<!-- End Box -->
</div>
<!-- End Sidebar -->
<div class="cl"> </div>
</div>
<!-- Main -->
</div>
</div>
<!-- End Container -->
<!-- Footer -->
<div id="footer">
<div class="shell">
<span class="left"> </span>
<span class="right">
</span>
</div>
</div>
<!-- End Footer -->
</body>
</html>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<jsp:useBean id="dao" class="Dao.Dao" scope="page"/>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>失物招领信息</title>
<!-- Meta tag Keywords -->
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta charset="UTF-8" />
<meta name="keywords" content="" />
<script>
addEventListener("load", function() {
setTimeout(hideURLbar, 0);
}, false);
function hideURLbar() {
window.scrollTo(0, 1);
}
</script>
<!-- //Meta tag Keywords -->
<!-- Custom-Files -->
<link rel="stylesheet" href="css/bootstrap.css">
<!-- Bootstrap-Core-CSS -->
<link rel="stylesheet" href="css/style.css" type="text/css" media="all" />
<link rel="stylesheet" href="css/slider.css" type="text/css" media="all" />
<!-- Style-CSS -->
<!-- font-awesome-icons -->
<link href="css/font-awesome.css" rel="stylesheet">
<!-- //font-awesome-icons -->
<!-- /Fonts -->
<link href="http://fonts.googleapis.com/css?family=Catamaran:100,200,300,400,500,600,700,800" rel="stylesheet">
<!-- //Fonts -->
</head>
<%
if(session.getAttribute("userName")==null)
{
response.sendRedirect("jiemian.jsp");
}
%>
<%
ResultSet rs=null;
boolean mark=true;
String mess="";
request.setCharacterEncoding("utf-8");
String time=request.getParameter("time");
System.out.print("!"+time);
%>
<body>
<div class="main-w3-pvt-header-sec page-w3pvt-inner" id="home">
<div class="overlay-innerpage">
<!-- header -->
<header>
<div class="container">
<div class="header d-lg-flex justify-content-between align-items-center py-lg-3 px-lg-3">
<!-- logo -->
<div id="logo">
<h1><a href="index.jsp"><span class="fa fa-recycle mr-2"></span>返回首页</a></h1>
</div>
<!-- //logo -->
<div class="w3pvt-bg">
<!-- nav -->
<div class="nav_w3pvt">
<nav>
<label for="drop" class="toggle">Menu</label>
<input type="checkbox" id="drop" />
<ul class="menu">
<li><a href="index.jsp">首页</a></li>
<li>
<!-- First Tier Drop Down -->
<label for="drop-2" class="toggle toogle-2">表单信息 <span class="fa fa-angle-down" aria-hidden="true"></span>
</label>
<a href="blog.jsp">失物寻物信息栏 <span class="fa fa-angle-down" aria-hidden="true"></span></a>
<input type="checkbox" id="drop-2" />
<ul>
<li><a href="blog.jsp" class="drop-text">寻物启事</a></li>
<li><a href="blog1.jsp" class="drop-text">失物招领</a></li>
</ul>
</li>
<li>
<label for="drop-2" class="toggle toogle-2">发布信息 <span class="fa fa-angle-down" aria-hidden="true"></span>
</label>
<a href="contact.jsp">发布信息 <span class="fa fa-angle-down" aria-hidden="true"></span></a>
<input type="checkbox" id="drop-2" />
<ul>
<li><a href="contact.jsp" class="drop-text">发布寻物启事</a></li>
<li><a href="contact1.jsp" class="drop-text">发布失物招领</a></li>
</ul>
</li>
<li><a href="search.jsp">查询</a></li>
</ul>
</nav>
</div>
<!-- //nav -->
<div class="justify-content-center">
<!-- search -->
<div class="apply-w3-pvt ml-lg-3">
<a class="btn read" href="linshi.jsp" role="button"><%=session.getAttribute("userName")%></a>
</div>
<!-- //search -->
</div>
<div class="justify-content-center">
<!-- search -->
<div class="apply-w3-pvt ml-lg-3">
<a class="btn read" href="jiemian.jsp" role="button">退出</a>
</div>
<!-- //search -->
</div>
</div>
</div>
</div>
</header>
<!-- //header -->
<!-- /banner-inner -->
<!-- //banner-inner -->
</div>
</div>
<!-- //banner -->
<!-- //banner-botttom -->
<section class="content-info py-5">
<div class="container py-md-5">
<h3 class="title-w3ls mb-5 text-center">输入时间之后的失物招领</h3>
<div class="row">
<%
rs=dao.listAlljd();
if(rs==null){
%>
<tr align="center" valign="middle"><td colspan="4">没有记录显示！</td>
</tr>
<%
}
else{
while(rs.next()&&rs.getString("time").compareTo(time)>0){%>
<!-- mian-content -->
<div class="col-lg-4 col-md-6 mt-4">
<div class="thumbnail card">
<div class="position-relative">
<img src="upload<%=rs.getString("photoname") %>" width="600" height="400"class="img-fluid" alt="">
<ul class="blog-icons position-absolute">
<li><a href="#"><span class="fa fa-heart-o"></span></a></li>
<li><a href="#"><span class="fa fa-comment-o"></span></a></li>
<li><a href="#"><span class="fa fa-share-square-o"></span></a></li>
</ul>
</div>
<div class="blog-info card-body">
<h4 class="">描述：<%=rs.getString("name") %></h4>
<h6 class="mt-4">地点：<%=rs.getString("place") %></h6>
<p class="mt-2">时间：<%=rs.getString("time") %></p>
<p class="mt-2">发布人<%=rs.getString("userName") %></p>>
<div class="read-icon">
<a href="single1.jsp?id=<%=rs.getString("id") %>" class="btn read">More Info</a>
</div>
</div>
</div>
</div>
<%
}
}
%>
</div>
</div>
</section>
<!-- //banner-botttom -->
</body>
</html>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<jsp:useBean id="dao" class="Dao.Dao" scope="page"/>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>失物招领信息</title>
<!-- Meta tag Keywords -->
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta charset="UTF-8" />
<meta name="keywords" content="" />
<script>
addEventListener("load", function() {
setTimeout(hideURLbar, 0);
}, false);
function hideURLbar() {
window.scrollTo(0, 1);
}
</script>
<!-- //Meta tag Keywords -->
<!-- Custom-Files -->
<link rel="stylesheet" href="css/bootstrap.css">
<!-- Bootstrap-Core-CSS -->
<link rel="stylesheet" href="css/style.css" type="text/css" media="all" />
<link rel="stylesheet" href="css/slider.css" type="text/css" media="all" />
<!-- Style-CSS -->
<!-- font-awesome-icons -->
<link href="css/font-awesome.css" rel="stylesheet">
<!-- //font-awesome-icons -->
<!-- /Fonts -->
<link href="http://fonts.googleapis.com/css?family=Catamaran:100,200,300,400,500,600,700,800" rel="stylesheet">
<!-- //Fonts -->
</head>
<%
if(session.getAttribute("userName")==null)
{
response.sendRedirect("jiemian.jsp");
}
%>
<%
ResultSet rs=null;
boolean mark=true;
String mess="";
request.setCharacterEncoding("utf-8");
String time=request.getParameter("time");
System.out.print("!"+time);
%>
<body>
<div class="main-w3-pvt-header-sec page-w3pvt-inner" id="home">
<div class="overlay-innerpage">
<!-- header -->
<header>
<div class="container">
<div class="header d-lg-flex justify-content-between align-items-center py-lg-3 px-lg-3">
<!-- logo -->
<div id="logo">
<h1><a href="index.jsp"><span class="fa fa-recycle mr-2"></span>返回首页</a></h1>
</div>
<!-- //logo -->
<div class="w3pvt-bg">
<!-- nav -->
<div class="nav_w3pvt">
<nav>
<label for="drop" class="toggle">Menu</label>
<input type="checkbox" id="drop" />
<ul class="menu">
<li><a href="index.jsp">首页</a></li>
<li>
<!-- First Tier Drop Down -->
<label for="drop-2" class="toggle toogle-2">表单信息 <span class="fa fa-angle-down" aria-hidden="true"></span>
</label>
<a href="blog.jsp">失物寻物信息栏 <span class="fa fa-angle-down" aria-hidden="true"></span></a>
<input type="checkbox" id="drop-2" />
<ul>
<li><a href="blog.jsp" class="drop-text">寻物启事</a></li>
<li><a href="blog1.jsp" class="drop-text">失物招领</a></li>
</ul>
</li>
<li>
<label for="drop-2" class="toggle toogle-2">发布信息 <span class="fa fa-angle-down" aria-hidden="true"></span>
</label>
<a href="contact.jsp">发布信息 <span class="fa fa-angle-down" aria-hidden="true"></span></a>
<input type="checkbox" id="drop-2" />
<ul>
<li><a href="contact.jsp" class="drop-text">发布寻物启事</a></li>
<li><a href="contact1.jsp" class="drop-text">发布失物招领</a></li>
</ul>
</li>
<li><a href="search.jsp">查询</a></li>
</ul>
</nav>
</div>
<!-- //nav -->
<div class="justify-content-center">
<!-- search -->
<div class="apply-w3-pvt ml-lg-3">
<a class="btn read" href="linshi.jsp" role="button"><%=session.getAttribute("userName")%></a>
</div>
<!-- //search -->
</div>
<div class="justify-content-center">
<!-- search -->
<div class="apply-w3-pvt ml-lg-3">
<a class="btn read" href="jiemian.jsp" role="button">退出</a>
</div>
<!-- //search -->
</div>
</div>
</div>
</div>
</header>
<!-- //header -->
<!-- /banner-inner -->
<!-- //banner-inner -->
</div>
</div>
<!-- //banner -->
<!-- //banner-botttom -->
<section class="content-info py-5">
<div class="container py-md-5">
<h3 class="title-w3ls mb-5 text-center">输入时间之前的寻物启事</h3>
<div class="row">
<%
rs=dao.listAllds();
if(rs==null){
%>
<tr align="center" valign="middle"><td colspan="4">没有记录显示！</td>
</tr>
<%
}
else{
while(rs.next()&&rs.getString("time").compareTo(time)<0){%>
<!-- mian-content -->
<div class="col-lg-4 col-md-6 mt-4">
<div class="thumbnail card">
<div class="position-relative">
<img src="upload<%=rs.getString("photoname") %>" width="600" height="400"class="img-fluid" alt="">
<ul class="blog-icons position-absolute">
<li><a href="#"><span class="fa fa-heart-o"></span></a></li>
<li><a href="#"><span class="fa fa-comment-o"></span></a></li>
<li><a href="#"><span class="fa fa-share-square-o"></span></a></li>
</ul>
</div>
<div class="blog-info card-body">
<h4 class="">描述：<%=rs.getString("name") %></h4>
<h6 class="mt-4">地点：<%=rs.getString("place") %></h6>
<p class="mt-2">时间：<%=rs.getString("time") %></p>
<p class="mt-2">发布人<%=rs.getString("userName") %></p>
<div class="read-icon">
<a href="single.jsp?id=<%=rs.getString("id") %>" class="btn read">More Info</a>
</div>
</div>
</div>
</div>
<%
}
}
%>
</div>
</div>
</section>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<jsp:useBean id="dao" class="Dao.Dao" scope="page"/>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>失物招领信息</title>
<!-- Meta tag Keywords -->
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta charset="UTF-8" />
<meta name="keywords" content="" />
<script>
addEventListener("load", function() {
setTimeout(hideURLbar, 0);
}, false);
function hideURLbar() {
window.scrollTo(0, 1);
}
</script>
<!-- //Meta tag Keywords -->
<!-- Custom-Files -->
<link rel="stylesheet" href="css/bootstrap.css">
<!-- Bootstrap-Core-CSS -->
<link rel="stylesheet" href="css/style.css" type="text/css" media="all" />
<link rel="stylesheet" href="css/slider.css" type="text/css" media="all" />
<!-- Style-CSS -->
<!-- font-awesome-icons -->
<link href="css/font-awesome.css" rel="stylesheet">
<!-- //font-awesome-icons -->
<!-- /Fonts -->
<link href="http://fonts.googleapis.com/css?family=Catamaran:100,200,300,400,500,600,700,800" rel="stylesheet">
<!-- //Fonts -->
</head>
<%
if(session.getAttribute("userName")==null)
{
response.sendRedirect("jiemian.jsp");
}
%>
<%
ResultSet rs=null;
boolean mark=true;
String mess="";
request.setCharacterEncoding("utf-8");
String time=request.getParameter("time");
System.out.print("!"+time);
%>
<body>
<div class="main-w3-pvt-header-sec page-w3pvt-inner" id="home">
<div class="overlay-innerpage">
<!-- header -->
<header>
<div class="container">
<div class="header d-lg-flex justify-content-between align-items-center py-lg-3 px-lg-3">
<!-- logo -->
<div id="logo">
<h1><a href="index.jsp"><span class="fa fa-recycle mr-2"></span>返回首页</a></h1>
</div>
<!-- //logo -->
<div class="w3pvt-bg">
<!-- nav -->
<div class="nav_w3pvt">
<nav>
<label for="drop" class="toggle">Menu</label>
<input type="checkbox" id="drop" />
<ul class="menu">
<li><a href="index.jsp">首页</a></li>
<li>
<!-- First Tier Drop Down -->
<label for="drop-2" class="toggle toogle-2">表单信息 <span class="fa fa-angle-down" aria-hidden="true"></span>
</label>
<a href="blog.jsp">失物寻物信息栏 <span class="fa fa-angle-down" aria-hidden="true"></span></a>
<input type="checkbox" id="drop-2" />
<ul>
<li><a href="blog.jsp" class="drop-text">寻物启事</a></li>
<li><a href="blog1.jsp" class="drop-text">失物招领</a></li>
</ul>
</li>
<li>
<label for="drop-2" class="toggle toogle-2">发布信息 <span class="fa fa-angle-down" aria-hidden="true"></span>
</label>
<a href="contact.jsp">发布信息 <span class="fa fa-angle-down" aria-hidden="true"></span></a>
<input type="checkbox" id="drop-2" />
<ul>
<li><a href="contact.jsp" class="drop-text">发布寻物启事</a></li>
<li><a href="contact1.jsp" class="drop-text">发布失物招领</a></li>
</ul>
</li>
<li><a href="search.jsp">查询</a></li>
</ul>
</nav>
</div>
<!-- //nav -->
<div class="justify-content-center">
<!-- search -->
<div class="apply-w3-pvt ml-lg-3">
<a class="btn read" href="linshi.jsp" role="button"><%=session.getAttribute("userName")%></a>
</div>
<!-- //search -->
</div>
<div class="justify-content-center">
<!-- search -->
<div class="apply-w3-pvt ml-lg-3">
<a class="btn read" href="jiemian.jsp" role="button">退出</a>
</div>
<!-- //search -->
</div>
</div>
</div>
</div>
</header>
<!-- //header -->
<!-- /banner-inner -->
<!-- //banner-inner -->
</div>
</div>
<!-- //banner -->
<!-- //banner-botttom -->
<section class="content-info py-5">
<div class="container py-md-5">
<h3 class="title-w3ls mb-5 text-center">输入时间之前的寻物启事</h3>
<div class="row">
<%
rs=dao.listAllds();
if(rs==null){
%>
<tr align="center" valign="middle"><td colspan="4">没有记录显示！</td>
</tr>
<%
}
else{
while(rs.next()&&rs.getString("time").compareTo(time)<0){%>
<!-- mian-content -->
<div class="col-lg-4 col-md-6 mt-4">
<div class="thumbnail card">
<div class="position-relative">
<img src="upload<%=rs.getString("photoname") %>" width="600" height="400"class="img-fluid" alt="">
<ul class="blog-icons position-absolute">
<li><a href="#"><span class="fa fa-heart-o"></span></a></li>
<li><a href="#"><span class="fa fa-comment-o"></span></a></li>
<li><a href="#"><span class="fa fa-share-square-o"></span></a></li>
</ul>
</div>
<div class="blog-info card-body">
<h4 class="">描述：<%=rs.getString("name") %></h4>
<h6 class="mt-4">地点：<%=rs.getString("place") %></h6>
<p class="mt-2">时间：<%=rs.getString("time") %></p>
<p class="mt-2">发布人<%=rs.getString("userName") %></p>
<div class="read-icon">
<a href="single.jsp?id=<%=rs.getString("id") %>" class="btn read">More Info</a>
</div>
</div>
</div>
</div>
<%
}
}
%>
</div>
</div>
</section>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<jsp:useBean id="dao" class="Dao.Dao" scope="page"/>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>失物招领信息</title>
<!-- Meta tag Keywords -->
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta charset="UTF-8" />
<meta name="keywords" content="" />
<script>
addEventListener("load", function() {
setTimeout(hideURLbar, 0);
}, false);
function hideURLbar() {
window.scrollTo(0, 1);
}
</script>
<!-- //Meta tag Keywords -->
<!-- Custom-Files -->
<link rel="stylesheet" href="css/bootstrap.css">
<!-- Bootstrap-Core-CSS -->
<link rel="stylesheet" href="css/style.css" type="text/css" media="all" />
<link rel="stylesheet" href="css/slider.css" type="text/css" media="all" />
<!-- Style-CSS -->
<!-- font-awesome-icons -->
<link href="css/font-awesome.css" rel="stylesheet">
<!-- //font-awesome-icons -->
<!-- /Fonts -->
<link href="http://fonts.googleapis.com/css?family=Catamaran:100,200,300,400,500,600,700,800" rel="stylesheet">
<!-- //Fonts -->
</head>
<%
if(session.getAttribute("userName")==null)
{
response.sendRedirect("jiemian.jsp");
}
%>
<%
ResultSet rs=null;
boolean mark=true;
String mess="";
request.setCharacterEncoding("utf-8");
String subsql=request.getParameter("subsql");
String subsqlvalue=request.getParameter("subsqlvalue");
System.out.print("!"+subsqlvalue);
if(subsql==null||subsql.equals("")){
mark=false;
mess+="<li>请输入<b>查询条件！</b></li>";
}
if(subsqlvalue==null||subsqlvalue.equals("")){
mark=false;
mess+="<li>请输入<b>查询的值！</b></li>";
}
%>
<body>
<div class="main-w3-pvt-header-sec page-w3pvt-inner" id="home">
<div class="overlay-innerpage">
<!-- header -->
<header>
<div class="container">
<div class="header d-lg-flex justify-content-between align-items-center py-lg-3 px-lg-3">
<!-- logo -->
<div id="logo">
<h1><a href="index.jsp"><span class="fa fa-recycle mr-2"></span>返回首页</a></h1>
</div>
<!-- //logo -->
<div class="w3pvt-bg">
<!-- nav -->
<div class="nav_w3pvt">
<nav>
<label for="drop" class="toggle">Menu</label>
<input type="checkbox" id="drop" />
<ul class="menu">
<li><a href="index.jsp">首页</a></li>
<li>
<!-- First Tier Drop Down -->
<label for="drop-2" class="toggle toogle-2">表单信息 <span class="fa fa-angle-down" aria-hidden="true"></span>
</label>
<a href="blog.jsp">失物寻物信息栏 <span class="fa fa-angle-down" aria-hidden="true"></span></a>
<input type="checkbox" id="drop-2" />
<ul>
<li><a href="blog.jsp" class="drop-text">寻物启事</a></li>
<li><a href="blog1.jsp" class="drop-text">失物招领</a></li>
</ul>
</li>
<li>
<label for="drop-2" class="toggle toogle-2">发布信息 <span class="fa fa-angle-down" aria-hidden="true"></span>
</label>
<a href="contact.jsp">发布信息 <span class="fa fa-angle-down" aria-hidden="true"></span></a>
<input type="checkbox" id="drop-2" />
<ul>
<li><a href="contact.jsp" class="drop-text">发布寻物启事</a></li>
<li><a href="contact1.jsp" class="drop-text">发布失物招领</a></li>
</ul>
</li>
<li><a href="search.jsp">查询</a></li>
</ul>
</nav>
</div>
<!-- //nav -->
<div class="justify-content-center">
<!-- search -->
<div class="apply-w3-pvt ml-lg-3">
<a class="btn read" href="linshi.jsp" role="button"><%=session.getAttribute("userName")%></a>
</div>
<!-- //search -->
</div>
<div class="justify-content-center">
<!-- search -->
<div class="apply-w3-pvt ml-lg-3">
<a class="btn read" href="jiemian.jsp" role="button">退出</a>
</div>
<!-- //search -->
</div>
</div>
</div>
</div>
</header>
<!-- //header -->
<!-- /banner-inner -->
<!-- //banner-inner -->
</div>
</div>
<!-- //banner -->
<!-- //banner-botttom -->
<section class="content-info py-5">
<div class="container py-md-5">
<h3 class="title-w3ls mb-5 text-center">符合条件的寻物启事</h3>
<div class="row">
<%
rs=dao.getdsPartRs(subsql,subsqlvalue);
if(rs==null){
%>
<tr align="center" valign="middle"><td colspan="4">没有记录显示！</td>
</tr>
<%
}
else{
while(rs.next()){%>
<!-- mian-content -->
<div class="col-lg-4 col-md-6 mt-4">
<div class="thumbnail card">
<div class="position-relative">
<img src="upload<%=rs.getString("photoname") %>" width="600" height="400"class="img-fluid" alt="">
<ul class="blog-icons position-absolute">
<li><a href="#"><span class="fa fa-heart-o"></span></a></li>
<li><a href="#"><span class="fa fa-comment-o"></span></a></li>
<li><a href="#"><span class="fa fa-share-square-o"></span></a></li>
</ul>
</div>
<div class="blog-info card-body">
<h4 class="">描述：<%=rs.getString("name") %></h4>
<h6 class="mt-4">地点：<%=rs.getString("place") %></h6>
<p class="mt-2">时间：<%=rs.getString("time") %></p>
<p class="mt-2">发布人<%=rs.getString("userName") %></p>
<div class="read-icon">
<a href="single.jsp?id=<%=rs.getString("id") %>" class="btn read">More Info</a>
</div>
</div>
</div>
</div>
<%
}
}
%>
</div>
</div>
</section>
<!-- //banner-botttom -->
<!-- footer -->
</body>
</html>
运行截图：
