📄 searchservlet.java~20~
字号:
package bookservlets;import bookutil.DataDo;import javax.servlet.*;import javax.servlet.http.*;import java.io.*;import java.util.*;public class SearchServlet extends HttpServlet { private static final String CONTENT_TYPE = "text/html; charset=Big5"; //ini public void init() throws ServletException { } //Process the HTTP Get request public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType(CONTENT_TYPE); PrintWriter out = response.getWriter(); String curpage=request.getParameter("page"); String key=request.getParameter("key").trim(); key = new String(key.getBytes("ISO-8859-1")); ArrayList records=null; //get records and div pages DataDo db=new DataDo(); records=db.dataQuery("select * from book where g_title like'%"+key+"%' order by g_id desc",5,curpage); db.dataClose(); if(records == null || records.size() == 0){ out.println("<script>window.alert(\"Not found !\");</script>"); out.println("<script>window.location=\"disp.beyondplus\";</script>"); return; } out.println("<html><head><title>Leave Words List</title>"); out.println("<style>td{font-size:10pt;}</style><script src=convert.js></script>"+ "<script>function check(fm){document.f1.key.value=convert(document.f1.key.value);return true;}</script></head>"); out.println("<body bgcolor=#ffffff><center><h1>Display List</h1>"); out.println("<a href=form.jsp>WRite</a>--------------------------"); out.println("<a href=manage/masterlogin.jsp>Manage</a>"); out.println("<form action=search.beyondplus name=f1 onsubmit=\"return check(this);\">Search with title:<input type=text "+ "name=key maxlength=50> "+ "<input type=submit value=search></form>"); //display for(int i=0;i<records.size();i++){ ArrayList column=(ArrayList)records.get(i); out.println("<table width=700 cellpadding=6 cellspacing=0 border=1 "); out.println("bordercolor=#eeeeee style=\"table-layout:fixed;word-break:break-all\">"); out.println("<tr bgcolor=#aaaaaa>"); String gender = "Lady"; if(column.get(db.getColumn("g_sex")).toString().equals("true"))gender = "Sir"; out.println("<td colspan=2 width=20%><b>Name:</b>"+new String(column.get(db.getColumn("g_name")).toString().getBytes("ISO8859_1"))+ " ("+gender+")</td>"); out.println("<td colspan=2 width=20%><b>QQ:</b>"+column.get(db.getColumn("g_qq"))+"</td>"); out.println("<td colspan=2 width=60%><b>E_mail:</b>"+column.get(db.getColumn("g_mail"))+"</td>"); out.println("</tr><tr bgcolor=#cccccc>"); out.println("<td colspan=6><b> "); out.println("Title:</b>"+new String(column.get(db.getColumn("g_title")).toString().getBytes("ISO8859_1"))+"</td></tr>"); out.println("<tr><td colspan=6><b> "); out.println("Content:</b>"+new String(column.get(db.getColumn("g_content")).toString().getBytes("ISO8859_1"))+"</td></tr>"); out.println("<tr><td colspan=6><b>Master reply:</b>"+column.get(db.getColumn("g_reply"))+"</td></tr>"); out.println("<tr align=right><td colspan=6><b>ID:</b> "+column.get(db.getColumn("g_id"))+" <b>IP:</b>192.168.0.59 | "); out.println("<b>Date:</b>"+column.get(db.getColumn("g_time"))+"</td></tr> </table>"); } out.println("current page: "+db.cur_page+" <b><font style=font-size:18pt>|</font></b>"); out.println(" total page: "+db.total_page+" <b><font style=font-size:18pt>|</font></b>"); out.println(" <a href=search.beyondplus?key="+key+"&page="+(db.cur_page+1)+">next page</a> <b><font style=font-size:18pt>|</font></b>"); out.println(" <a href=search.beyondplus?key="+key+"&page="+(db.cur_page-1)+">previous page</a>"); out.println("<form action=search.beyondplus method=post><input type=hidden value="+key+" name=key>"); out.println("jump to:<input type=text name=page style=width:40>page<input style=\"width:40\" type=submit value=go>"); out.println("</form></center></body></html>"); System.out.println("-------key:"+key); } //Clean up resources public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request,response); } public void destroy() { }}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -