详解基于MVC的数据查询模块进行模糊查询 详解基于 的数据查询模块进行模糊查询 主要介绍了Java基于MVC的数据查询模块进行模糊查询，文中通过示例代码介绍的非常详细，对大家的学习或 者工作具有一定的参考学习价值，需要的朋友们下面随着小编来一起学习学习吧 完成一个简单的基于MVC的数据查询模块，要求能够按照name进行模糊查询。 Index.jsp： <%@ page import="student.TestBean" %> <%@ page import="java.util.List" %> <%@ page import="java.util.ArrayList" %> <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <% List list = (List)request.getAttribute("list"); if(list == null){ list = new ArrayList(); } %>

NAME: <% for(int i = 0 ; i < list.size() ; i++){ TestBean record = list.get(i); %> <% } %>

ID	Name
<%=record.getId()%>	<%=record.getName()%>

ScoreServlet.java： import student.TestBean; import student.TestDb; 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.sql.SQLException; import java.util.List; @WebServlet(name = "/ScoreServlet") public class ScoreServlet extends HttpServlet { protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { } protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String strName = request.getParameter("Name"); 

if(strName == null) strName = ""; TestDb testDb = new TestDb(); try { List list = testDb.findByName(strName); request.setAttribute("list",list); request.getRequestDispatcher("index.jsp").forward(request,response); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } } } TestBean.java： package student; public class TestBean { private int id; private String name; public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } } TestDb.java： package student; import student.TestBean; import java.sql.*; import java.util.ArrayList; import java.util.List; public class TestDb { public List findByName(String Name) throws ClassNotFoundException,SQLException{ List list = new ArrayList(); String url="jdbc:h2:D:/temp/h2/mydb"; Class.forName("org.h2.Driver"); Connection conn = DriverManager.getConnection(url,"sa",""); PreparedStatement pstmt = conn.prepareStatement("select ID,NAME from TEST where name like ?"); pstmt.setString(1,"%"+Name+"%"); ResultSet rs = pstmt.executeQuery(); //执行查询 while(rs.next()){ TestBean record = new TestBean(); record.setId(rs.getInt(1)); record.setName(rs.getString(2)); list.add(record); } rs.close(); pstmt.close(); conn.close(); return list; } } 以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持我们。