结对作业（地铁项目）04

合集 - 软件工程日报(64)

1.新学期目标2024-03-05 2.打卡2024-05-29 3.打卡22024-05-29 4.打卡32024-05-29 5.打卡 42024-05-29 6.打卡52024-06-13 7.打卡62024-06-13 8.打卡72024-06-16 9.打卡82024-06-16 10.打卡92024-06-16 11.打卡102024-06-16 12.结对作业（地铁查询项目）012024-06-16 13.结对作业（地铁项目）022024-06-16 14.结对作业（地铁项目）032024-06-16

15.结对作业（地铁项目）042024-06-16

16.结对作业（地铁项目）052024-06-16 17.结对作业（地铁项目）062024-06-16 18.结对作业（地铁项目）072024-06-16 19.结对作业（地铁项目）082024-06-16 20.结对作业（地铁项目）092024-06-16 21.结对作业（地铁项目）102024-06-16 22.结对作业（地铁项目）112024-06-16 23.结对作业（地铁项目）122024-06-16 24.结对作业（地铁项目）132024-06-16 25.结对作业（地铁项目）142024-06-16 26.五一冲刺（政策查询系统）12024-06-16 27.五一冲刺（政策查询系统）22024-06-16 28.政策查询系统（安卓）12024-06-16 29.政策查询系统（安卓）22024-06-16 30.政策查询系统（安卓）32024-06-16 31.政策查询系统（安卓）42024-06-16 32.政策查询系统（安卓）52024-06-16 33.政策查询系统（安卓）62024-06-16 34.政策查询系统（安卓）72024-06-16 35.JS开发2024-02-28 36.安卓app开发相关2024-02-28 37.第一次个人作业（安卓学习记录系统）012024-06-16 38.第一次个人作业（安卓学习记录系统）022024-06-16 39.第一次个人作业（安卓学习记录系统）032024-06-16 40.第一次个人作业（安卓学习记录系统）042024-06-16 41.第一次个人作业（安卓学习记录系统）052024-06-16 42.第一次个人作业（安卓学习记录系统）062024-06-16 43.第一次个人作业（安卓学习记录系统）072024-06-16 44.打卡112024-06-19 45.打卡122024-06-19 46.打卡132024-06-19 47.打卡142024-06-19 48.打卡152024-06-19 49.打卡162024-06-19 50.打卡172024-06-19 51.打卡182024-06-19 52.打卡192024-06-19 53.打卡202024-06-19 54.python学习2024-06-19 55.python学习22024-06-19 56.python学习32024-06-19 57.Javaweb2024-06-19 58.打卡212024-06-19 59.fragment学习和使用2024-06-19 60.mybits学习12024-06-19 61.mybits学习22024-06-19 62.mybits学习32024-06-19 63.课程总结2024-06-19 64.个人总结2024-06-19

changeserchjudge.jsp

<%@ page language="java" import="java.sql.*"  contentType="text/html; charset=UTF-8"
         pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <title>查询</title>
</head>
<body style="text-align:center">
查询结果
<p>
    <style>





        body {
            margin:0px;
            background: url(images/2.png) no-repeat;
            background-size:100% 100%;
            background-attachment:fixed;
        }
        input {
            width: 250px;
            height: 44px;
            border: none;
            /* 元素周围的轮廓无效 */
            outline: none;
            /* 为元素指定的任何内边距和边框都将在已设定的宽度和高度内进行绘制 */
            box-sizing: border-box;
            display: block;
            padding: 0 16px;
        }
        .input-text {
            margin: 5px auto;
            border-radius: 16px;
        }

        .input-text:hover {
            border: 0.5px solid rgb(76, 76, 233);
            transition: 0.5s;
            border-radius: 4px;
        }
    </style>
    <jsp:useBean id="util" class="User.subway" scope="page" />
        <%
String station1=(String)request.getParameter("station1");
String station2=(String)request.getParameter("station2");
if(station1==""||station2==""){
    out.print("<script language='javaScript'> alert('输入为空'); window.history.back(-1); </script>");
}
else
{
    %>
<table border="1"style="text-align:center;">
    <tr>
        <td align="center" width=6%>起始站</td>
        <td align="center" width=3%>终点站</td>
        <td align="center" width=3%>经停站</td>
        <td align="center" width=3%>路线</td>

    </tr>
    <%
        int i=0;
        Connection connection = util.getConnection();
        PreparedStatement preparedStatement=null;
        ResultSet rs=null;
        try {

            String sql ="WITH RECURSIVE transfer (start_station, stop_station, stops, path) AS (\n" +
                    "    SELECT station_name, next_station, 1, CAST(CONCAT(line_name,station_name , '->', line_name,next_station) AS CHAR(1000))\n" +
                    "    FROM bj_subway WHERE station_name = ?\n" +
                    "    UNION ALL\n" +
                    "    SELECT p.start_station, e.next_station, stops + 1, CONCAT(p.path, '->', e.line_name, e.next_station)\n" +
                    "    FROM transfer p\n" +
                    "             JOIN bj_subway e\n" +
                    "                  ON p.stop_station = e.station_name AND (INSTR(p.path, e.next_station) = 0)\n" +
                    ")\n" +
                    "SELECT * FROM transfer WHERE stop_station = ?;\n";
            preparedStatement = connection.prepareStatement(sql);
            preparedStatement.setString(1,station1);
            preparedStatement.setString(2,station2);
            rs = preparedStatement.executeQuery();

            while(rs.next())
            {
                i++;
                if (station1.equals(rs.getObject(1))&&station2.equals((rs.getObject(2)))){

    %>
    <tr>
        <td align="center"><%=rs.getObject(1) %></td>
        <td align="center"><%=rs.getObject(2) %></td>
        <td align="center"><%=rs.getObject(3) %></td>
        <td align="center"><%=rs.getObject(4) %></td>

    </tr>
    <%
                    }
                }
                if(i==0)
                {
                    out.print("<script language='javaScript'> alert('没有查询到有关信息'); window.history.back(-1); </script>");
                }


            } catch (SQLException  e) {
                e.printStackTrace();
            }finally{
                util.close(rs);
                util.close(preparedStatement);
                util.close(connection);
            }
        }
    %>
</table>

<p style="text-align:center;color: black; font-family: 宋体; font-size: 20px">
    <br> <input class="input-text" type="button" value="返回菜单" onclick="location.href='menu.jsp'" /> <br>
</p>
</body>
</html>

posted @ 2024-06-16 11:38 平安喜乐× 阅读(4) 评论(0) 编辑收藏举报

pinganxile

结对作业（地铁项目）04

公告

搜索

常用链接

我的标签

合集

随笔档案

阅读排行榜