每日总结--2023/3/26

完成同一线路的查询：

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>