Java Web简单搜索功能实现

2023-07-19 22:40| 来源: 网络整理| 查看: 265

小demo，没有使用框架。

webapp项目，用到了servlet + jsp，使用jdbc从MySQL中查询数据

构建工具maven

先上截图

pom.xml 注意版本问题！

UTF-8 1.7 1.7 2.8.2 4.11 3.0.1 2.1 1.2 junit junit ${junit.version} test org.apache.logging.log4j log4j-core ${log4j-core.version} mysql mysql-connector-java 8.0.15 javax.servlet javax.servlet-api ${servlet.version} provided javax.servlet.jsp jsp-api ${jsp.version} provided javax.servlet jstl ${jstl.version}

index.jsp 前端页面

#keyword { background-image: url('https://static.runoob.com/images/mix/searchicon.png'); /* 搜索按钮 */ background-position: 10px 12px; /* 定位搜索按钮 */ background-repeat: no-repeat; /* 不重复图片 */ width: 100%; font-size: 16px; padding: 12px 20px 12px 40px; border: 1px solid #ddd; margin-bottom: 12px; } #myTable { border-collapse: collapse; width: 100%; border: 1px solid #ddd; font-size: 18px; } #myTable th, #myTable td { text-align: left; padding: 12px; } #myTable tr { /* 表格添加边框 */ border-bottom: 1px solid #ddd; } #myTable tr.header, #myTable tr:hover { /* 表头及鼠标移动过 tr 时添加背景 */ background-color: #f1f1f1; } // onclick事件 function search() { // var $keyword = $("#keyword").val(); var $keyword = document.getElementById("keyword").value; // todo 发起请求 window.location.href = "/query?param=" + $keyword; } // 按Enter键,执行事件 function entersearch() { var event = window.event || arguments.callee.caller.arguments[0]; if (event.keyCode == 13) { search(); } } phone start_time end_time host rule type ${u.id} ${u.startTime} ${u.endTime} ${u.hostss} ${u.rule} ${u.type}

ResultServlet.java servlet

package com.dinary.controller; import com.dinary.pojo.Datax; import com.dinary.util.JDBCUtil; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.IOException; import java.util.List; /** * @author dcy * @create 2019-07-23 上午9:41 */ @WebServlet(name = "ResultServlet", urlPatterns = "/query") public class ResultServlet extends HttpServlet { @Override protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String param = request.getParameter("param"); List res = null; try { if ("".equals(param) && param.length() == 0) { res = JDBCUtil.queryAll(); } else { res = JDBCUtil.query(param); } } catch (Exception e) { e.printStackTrace(); } request.setAttribute("list", res); request.getRequestDispatcher("index.jsp").forward(request, response); } @Override protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request, response); } }

Datax.java 返回数据

package com.dinary.pojo; /** * 返回给前端数据 */ public class Datax { private String id; private String startTime; private String endTime; private String hostss; private String rule; private String type; public String getId() { return id; } public void setId(String id) { this.id = id; } public String getStartTime() { return startTime; } public void setStartTime(String startTime) { this.startTime = startTime; } public String getEndTime() { return endTime; } public void setEndTime(String endTime) { this.endTime = endTime; } public String getHostss() { return hostss; } public void setHostss(String hostss) { this.hostss = hostss; } public String getRule() { return rule; } public void setRule(String rule) { this.rule = rule; } public String getType() { return type; } public void setType(String type) { this.type = type; } }

JDBCUtil.java 数据库工具类

package com.dinary.util; import com.dinary.pojo.Datax; import java.io.BufferedReader; import java.io.File; import java.io.FileInputStream; import java.io.InputStreamReader; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.Statement; import java.util.ArrayList; import java.util.Arrays; import java.util.List; /** * @author dcy * @create 2019-07-23 上午7:48 */ public class JDBCUtil { /** * mysql 8 :com.mysql.cj.jdbc.Driver */ static final String JDBC_DRIVER = "com.mysql.cj.jdbc.Driver"; static final String DB_URL = "jdbc:mysql://localhost:3306/dinary"; static final String USER = "root"; static final String PASS = "123456"; static Connection conn; static PreparedStatement ps; static { // 注册 JDBC 驱动 try { Class.forName(JDBC_DRIVER); // 打开链接 conn = DriverManager.getConnection(DB_URL, USER, PASS); } catch (Exception e) { e.printStackTrace(); } } public static List query(String param) throws Exception{ String sql = "select * from datax where id = ?"; ps = conn.prepareStatement(sql); ps.setString(1, param); ResultSet rs = ps.executeQuery(); List list = new ArrayList(); while (rs.next()) { Datax s = new Datax(); s.setId(rs.getString(1)); s.setStartTime(rs.getString(2)); s.setEndTime(rs.getString(3)); s.setHostss(rs.getString(4)); s.setRule(rs.getString(5)); s.setType(rs.getString(6)); list.add(s); } return list; } public static List queryAll() throws Exception{ String sql = "select * from datax"; Statement st = conn.createStatement(); ResultSet rs = st.executeQuery(sql); List list = new ArrayList(); while (rs.next()) { Datax s = new Datax(); s.setId(rs.getString(1)); s.setStartTime(rs.getString(2)); s.setEndTime(rs.getString(3)); s.setHostss(rs.getString(4)); s.setRule(rs.getString(5)); s.setType(rs.getString(6)); list.add(s); } return list; } public static void close() throws Exception{ if (conn != null) { conn.close(); } if (ps != null) { ps.close(); } } }

一个简单的搜索功能就完成了

【本文地址】

公司简介

联系我们