位置：首页>> 软件编程>> java编程>> 详解基于MVC的数据查询模块进行模糊查询

详解基于MVC的数据查询模块进行模糊查询

作者：小任性嘛　　发布时间：2022-02-13 19:26:49　

标签：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<TestBean> list = (List<TestBean>)request.getAttribute("list");
if(list == null){
list = new ArrayList<TestBean>();
}

％>
<!doctype html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport"
content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>Document</title>
</head>
<body>
<form action="ScoreServlet">
NAME:<input type="text" name="Name">
<input type="submit" method="post">

<table border="1px solid black">
<tr>
<th>ID</th>
<th>Name</th>
</tr>
<％
for(int i = 0 ; i < list.size() ; i++){
TestBean record = list.get(i);
％>
<tr>
<td><％=record.getId()％></td>
<td><％=record.getName()％></td>
</tr>
<％
}
％>
</table>
</form>
</body>
</html>

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<TestBean> 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<TestBean> findByName(String Name) throws ClassNotFoundException,SQLException{
List<TestBean> list = new ArrayList<TestBean>();
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;
}
}

来源：https://blog.csdn.net/weixin_43728903/article/details/103970650

投稿

详解基于MVC的数据查询模块进行模糊查询

猜你喜欢