完成同一线路的查询：
sevlet代码：
package Servelet;
import DButil.DButil;
import bean.User;
import com.sun.net.httpserver.HttpServer;
import jakarta.servlet.ServletException;
import jakarta.servlet.annotation.WebServlet;
import jakarta.servlet.http.HttpServlet;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
@WebServlet("/ChangeChaxunServlet")
public class ChangeChaxunServlet extends HttpServlet {
@Override
protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
String id1 =req.getParameter("id1");
String id2 =req.getParameter("id2");
Connection connection = DButil.getConnection();
PreparedStatement statement = null;
ResultSet resultSet = null;
ArrayList<User> list = new ArrayList<User>();
String sql ="SELECT id FROM beijing WHERE `flag` BETWEEN (SELECT `flag` FROM beijing WHERE id = ?) AND (SELECT `flag` FROM beijing WHERE id = ?) ORDER BY `flag`";
try {
statement = connection.prepareStatement(sql);
statement.setString(1, id1); // 设置第一个参数为起点车站名称
statement.setString(2, id2); // 设置第二个参数为终点车站名称
resultSet = statement.executeQuery();
while(resultSet.next()){
String id = resultSet.getString("id");
User book = new User(id,null);
list.add(book);
}
} catch (SQLException e) {
throw new RuntimeException(e);
}
// 把list数据方放到一块内存里面
req.setAttribute("list",list);
// 跳转到student_list.jsp展示数据
// Dispatcher:分发 forward:转发
req.getRequestDispatcher("/ChaXun3.jsp").forward(req,resp);
}
页面代码：
<%--
Created by IntelliJ IDEA.
User: 86178
Date: 2023/3/20
Time: 16:41
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>换乘查询</title>
</head>
<body>
<h1>换乘查询</h1>
<form action="ChangeChaxunServlet" method="post">
请输入出发点：<input type="text" name="id1"><br>
请输入终点： <input type="text" name="id2"><br>
<button>查询</button>
</form>
</body>
</html>
}