十天冲刺（5）
昨天的任務是完成模糊查詢功能的相關代碼，這個功能可以根據物品的描述，物品丟失的地點，物品丟失的時間來進行模糊查詢。功能基本完成。
存在問題：對于查詢完畢后的失物應該與用戶提交的表單相結合，這樣可以進行失物和失主的自動匹配，這個功能將會在以后實現。
今天的任務：完成用戶的個人功能，修改個人密碼等功能。
<%@ 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> </head> <body> <% int id = Integer.parseInt(request.getParameter("id")); if(dao.deleteds(id)){%><script>alert('刪除成功！');parent.location("main_right.jsp");</script><%}%> </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%; width: 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%; width: 55%; height: 55%; padding: 20px; border: 10px solid orange; background-color: white; z-index:1002; overflow: auto; } </style> </head> <body> <%Object message = request.getAttribute("message");//放置一個字符串，并取出if(message!=null && !"".equals(message)){%><script type="text/javascript">alert("<%=request.getAttribute("message")%>");</script> <%} %> <!-- 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="main_right.jsp" class="active"><span>我發表的失物表單</span></a></li><li><a href="main_right1.jsp"><span>我發表的招領表單</span></a></li></ul></div><!-- End Main Nav --></div> </div> <!-- End Header --><!-- Container --> <div id="container"><div class="shell"><div id="main"><div class="cl">?</div><!-- Content --><div id="content"><!-- Box --><div class="box"><% int id = Integer.parseInt(request.getParameter("id"));ResultSet rs=dao.listdsByid(id);if(rs==null){ %>沒有記錄顯示！<%}else{if(rs.next()){%><!-- Box --><div class="box"><!-- Box Head --><div class="box-head"><h2>修改信息</h2></div><!-- End Box Head --><form action="addServlet?method=main_right_updateds" method="post"><!-- Form --><div class="form"><P><label>物品類別</label><input type="text" name="name" value=" <%=rs.getString("name") %>" class="field size1"></P> <P><label>丟失地點</label><input type="text" name="place" value=" <%=rs.getString("place") %>" class="field size1" ></P><P><label>丟失時間</label><input type="datetime-local" name="time" class="field size1"></P> <P><label>聯系方式</label><input type="text" name="people" value=" <%=rs.getString("people") %>" class="field size1"></P> <P><label>詳細信息</label><input type="text" name="info" value=" <%=rs.getString("info") %>" class="field size1" ></P> <input type="hidden" name="id" value="<%=rs.getInt("id") %>"></div><!-- End Form --><!-- Form Buttons --><div class="buttons"><input type="submit" class="button" value="確認修改" /></div><!-- End Form Buttons --></form></div><!-- End Box --></div><%}}%> <!-- Table --></div><!-- End Box --><!-- Box --><!-- End Box --></div><!-- End Content --><!-- Sidebar --><!-- End Sidebar --><div class="cl">?</div> </div><!-- Main --></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%; width: 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%; width: 55%; height: 55%; padding: 20px; border: 10px solid orange; background-color: white; z-index:1002; overflow: auto; } </style> </head> <body> <!-- String userName = String.valueOf(session.getAttribute("userName")); -- > <% String userName = String.valueOf(session.getAttribute("userName"));Object message = request.getAttribute("message");//放置一個字符串，并取出if(message!=null && !"".equals(message)){%><script type="text/javascript">alert("<%=request.getAttribute("message")%>");</script> <%} %><!-- 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="main_right.jsp" class="active"><span>我發表的尋物啟事</span></a></li><li><a href="main_right1.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 --><form action="searchdsByuserName.jsp" method="post"><div class="box-head"><h2 class="left">列表</h2></div></form><!-- End Box Head --> <!-- Table --><form action="addServlet?method=main_right_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><%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><h3><%=rs.getString("name") %></h3></td><td><%=rs.getString("place") %></td><td><%=rs.getString("time") %></td><td><%=rs.getString("people") %></td><td><%=rs.getString("info") %></td><td><a οnclick="return check()" href="main_right_deleteds.jsp?id=<%=rs.getInt("id") %>" class="ico del">刪除</a><a href="main_right_updateds.jsp?id=<%=rs.getInt("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"οnclick="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> </head> <body> <% int id = Integer.parseInt(request.getParameter("id")); if(dao.deletejd(id)){%><script>alert('刪除成功！');parent.location("main_right1.jsp");</script><%}%> </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%; width: 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%; width: 55%; height: 55%; padding: 20px; border: 10px solid orange; background-color: white; z-index:1002; overflow: auto; } </style> </head> <body> <%Object message = request.getAttribute("message");//放置一個字符串，并取出if(message!=null && !"".equals(message)){%><script type="text/javascript">alert("<%=request.getAttribute("message")%>");</script> <%} %> <!-- 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="main_right.jsp"><span>我發表的失物表單</span></a></li><li><a href="main_right1.jsp" class="active"><span>我發表的招領表單</span></a></li></ul></div><!-- End Main Nav --></div> </div> <!-- End Header --><!-- Container --> <div id="container"><div class="shell"><div id="main"><div class="cl">?</div><!-- Content --><div id="content"><!-- Box --><div class="box"><% int id = Integer.parseInt(request.getParameter("id"));ResultSet rs=dao.listjdByid(id);if(rs==null){ %>沒有記錄顯示！<%}else{if(rs.next()){%><!-- Box --><div class="box"><!-- Box Head --><div class="box-head"><h2>修改信息</h2></div><!-- End Box Head --><form action="addServlet?method=main_right1_updatejd" method="post"><!-- Form --><div class="form"><P><label>物品類別</label><input type="text" name="name" value=" <%=rs.getString("name") %>" class="field size1"></P> <P><label>丟失地點</label><input type="text" name="place" value=" <%=rs.getString("place") %>" class="field size1" ></P><P><label>丟失時間</label><input type="datetime-local" name="time" class="field size1"></P> <P><label>聯系方式</label><input type="text" name="people" value=" <%=rs.getString("people") %>" class="field size1"></P> <P><label>詳細信息</label><input type="text" name="info" value=" <%=rs.getString("info") %>" class="field size1" ></P> <input type="hidden" name="id" value="<%=rs.getInt("id") %>"></div><!-- End Form --><!-- Form Buttons --><div class="buttons"><input type="submit" class="button" value="確認修改" /></div><!-- End Form Buttons --></form></div><!-- End Box --></div><%}}%> <!-- Table --></div><!-- End Box --><!-- Box --><!-- End Box --></div><!-- End Content --><!-- Sidebar --><!-- End Sidebar --><div class="cl">?</div> </div><!-- Main --></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%; width: 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%; width: 55%; height: 55%; padding: 20px; border: 10px solid orange; background-color: white; z-index:1002; overflow: auto; } </style> </head> <body> <!-- String userName = String.valueOf(session.getAttribute("userName")); -- > <% String userName = String.valueOf(session.getAttribute("userName"));Object message = request.getAttribute("message");//放置一個字符串，并取出if(message!=null && !"".equals(message)){%><script type="text/javascript">alert("<%=request.getAttribute("message")%>");</script> <%} %><!-- 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="main_right.jsp" ><span>我發表尋物啟事</span></a></li><li><a href="main_right1.jsp" class="active"><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 --><form action="searchdsByuserName.jsp" method="post"><div class="box-head"><h2 class="left">列表</h2></div></form><!-- End Box Head --> <!-- Table --><form action="addServlet?method=main_right1_deletejd" 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><%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="checkjd" value="<%=rs.getInt("id") %>" /></td><td><h3><%=rs.getString("name") %></h3></td><td><%=rs.getString("place") %></td><td><%=rs.getString("time") %></td><td><%=rs.getString("people") %></td><td><%=rs.getString("info") %></td><td><a οnclick="return check()" href="main_right1_deletejd.jsp?id=<%=rs.getInt("id") %>" class="ico del">刪除</a><a href="main_right1_updatejd.jsp?id=<%=rs.getInt("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"οnclick="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>
?
轉載于:https://www.cnblogs.com/zjl-0217/p/10933285.html
總結
- 上一篇： mysql重置auto_incremen
- 下一篇： vue嵌套数据多层级里面的数据不自动更新