地铁查询系统部分代码
地铁查询系统部分代码
index.jsp
1 <%-- 2 Created by IntelliJ IDEA. 3 User: 十年磨一剑 4 Date: 2022/3/25 5 Time: 9:53 6 To change this template use File | Settings | File Templates. 7 --%> 8 <%@ page contentType="text/html;charset=UTF-8" language="java" %> 9 <html> 10 <head> 11 <title>北京地铁查询</title> 12 <style> 13 .equary{ 14 margin-top: 20px; 15 list-style: none; 16 text-align: center; 17 margin-left: 0px; 18 margin-bottom: 10px; 19 } 20 </style> 21 <script type="javascript"> 22 function xianlu(){ 23 document.getElementById("chaxunkuang").innerHTML="<form action=\"c1Servlet\" onsubmit=\"return check()\" method=\"post\">" 24 +"<table id='show'><br><br>" 25 +" <tr>" 26 +" <td>请选择地铁线路名" 27 +" <select name=\"linename\">" 28 +" <option value=\"1号线(八通线)\">1号线(八通线)</option>" 29 +" <option value=\"2号线\">2号线</option>" 30 +" <option value=\"4号线\">4号线</option>" 31 +" <option value=\"5号线\">5号线</option>" 32 +" <option value=\"6号线\">6号线</option>" 33 +" <option value=\"7号线\">7号线</option>" 34 +" <option value=\"8号线\">8号线</option>" 35 +" <option value=\"9号线\">9号线</option>" 36 +" <option value=\"10号线外环\">10号线外环</option>" 37 +" <option value=\"11号线\">11号线</option>" 38 +" <option value=\"13号线\">13号线</option>" 39 +" <option value=\"14号线\">14号线</option>" 40 +" <option value=\"15号线\">15号线</option>" 41 +" <option value=\"16号线\">16号线</option>" 42 +" <option value=\"17号线\">17号线</option>" 43 +" <option value=\"19号线\">19号线</option>" 44 +" <option value=\"S1号线\">S1号线</option>" 45 +" <option value=\"S2号线主线\">S2号线主线</option>" 46 +" <option value=\"S2号线支线\">S2号线支线</option>" 47 +" <option value=\"亦庄线\">亦庄线</option>" 48 +" <option value=\"亦庄T1线\">亦庄T1线</option>" 49 +" <option value=\"大兴机场线\">大兴机场线</option>" 50 +" <option value=\"房山线\">房山线</option>" 51 +" <option value=\"昌平线\">昌平线</option>" 52 +" <option value=\"燕房线\">燕房线</option>" 53 +" <option value=\"西郊线\">西郊线</option>" 54 +" <option value=\"首都机场线\">首都机场线</option>" 55 + "</select>" 56 +" </td>" 57 +" </tr>" 58 +"</table>" 59 +"<input type=\"submit\" value=\"提交\">" 60 +"</form>" 61 document.getElementById("result").innerHTML=""; 62 63 } 64 </script> 65 </head> 66 <body> 67 <h1 align="center">北京地铁查询</h1> 68 <%-- <%--%> 69 <%-- Object message = request.getAttribute("message");//放置一个字符串,并取出--%> 70 <%-- if(message!=null && !"".equals(message)){--%> 71 72 <%-- %>--%> 73 <%-- <script type="text/javascript">--%> 74 <%-- alert("<%=request.getAttribute("message")%>");--%> 75 <%-- </script>--%> 76 <%-- <%} %>--%> 77 <div align="center"> 78 79 80 <div id="left-bottom1"> 81 <ul> 82 <li class="equary"><button id="stiation" onclick="station1()">站点查询</button></li> 83 <li class="equary"><button id="xianlu" onclick="xianlu()">线路查询</button></li> 84 <li class="equary"><button id="qizhong" onclick="qizhong()">起点终点查询</button></li> 85 </ul> 86 </div> 87 88 <form action="c1Servlet" method="post" onsubmit="return check()"> 89 <select name="linename" id=""> 90 <option value="1号线(八通线)">1号线(八通线)</option> 91 <option value="2号线">2号线</option> 92 <option value="4号线">4号线</option> 93 <option value="5号线">5号线</option> 94 <option value="6号线">6号线</option> 95 <option value="7号线">7号线</option> 96 <option value="8号线">8号线</option> 97 <option value="9号线">9号线</option> 98 <option value="10号线外环">10号线外环</option> 99 <option value="11号线">11号线</option> 100 <option value="13号线">13号线</option> 101 <option value="14号线">14号线</option> 102 <option value="15号线">15号线</option> 103 <option value="16号线">16号线</option> 104 <option value="17号线">17号线</option> 105 <option value="19号线">19号线</option> 106 <option value="S1号线">S1号线</option> 107 <option value="S2号线主线">S2号线主线</option> 108 <option value="S2号线支线">S2号线支线</option> 109 <option value="亦庄线">亦庄线</option> 110 <option value="亦庄T1线">亦庄T1线</option> 111 <option value="大兴机场线">大兴机场线</option> 112 <option value="房山线">房山线</option> 113 <option value="昌平线">昌平线</option> 114 <option value="燕房线">燕房线</option> 115 <option value="西郊线">西郊线</option> 116 <option value="首都机场线">首都机场线</option> 117 </select> 118 <button type="submit" value="查询">查询</button> 119 </form> 120 <% 121 String station = (String) request.getAttribute("station"); 122 %> 123 <%=station%> 124 125 </div> 126 <script type="text/javascript"> 127 function check() { 128 var username = document.getElementById("sname");; 129 var password = document.getElementById("ename"); 130 //非空 131 if(username.value == '') { 132 alert('始发站不能为空'); 133 same.focus(); 134 return false; 135 } 136 if(password.value == '') { 137 alert('终点站不能为空'); 138 ename.focus(); 139 return false; 140 } 141 142 } 143 </script> 144 </body> 145 </html>
c3Servlet
1 package servlet; 2 3 import dao.StationDAO; 4 import entity.station; 5 6 import javax.servlet.ServletException; 7 import javax.servlet.annotation.WebServlet; 8 import javax.servlet.http.HttpServlet; 9 import javax.servlet.http.HttpServletRequest; 10 import javax.servlet.http.HttpServletResponse; 11 import java.io.IOException; 12 import java.sql.SQLException; 13 14 @WebServlet 15 public class c3Servlet extends HttpServlet { 16 @Override 17 protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException{ 18 req.setCharacterEncoding("UTF-8"); 19 req.getParameter("start"); 20 req.getParameter("end"); 21 StationDAO SD = new StationDAO(); 22 23 station s1 = null; 24 station s2 = null; 25 try { 26 s1 = SD.checkstation("start"); 27 s2 = SD.checkstation("end"); 28 } catch (SQLException e) { 29 e.printStackTrace(); 30 } catch (ClassNotFoundException e) { 31 e.printStackTrace(); 32 } 33 34 35 if(SD.isonsameline(s1,s2)){ 36 if(s1.getId()>=s2.getId()){ 37 for(int i=s1.getId();i>=s2.getId();i--){ 38 39 } 40 } 41 if(s1.getId()<s2.getId()){ 42 for(int i=s1.getId();i<=s2.getId();i++){ 43 44 } 45 } 46 } 47 } 48 49 @Override 50 protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { 51 super.doPost(req, resp); 52 } 53 }
c1servlet
1 package servlet; 2 3 import dao.LineDAO; 4 5 import javax.servlet.ServletException; 6 import javax.servlet.annotation.WebServlet; 7 import javax.servlet.http.HttpServlet; 8 import javax.servlet.http.HttpServletRequest; 9 import javax.servlet.http.HttpServletResponse; 10 import java.io.IOException; 11 import java.sql.SQLException; 12 13 @WebServlet("/c1Servlet") 14 public class c1Servlet extends HttpServlet{ 15 @Override 16 protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { 17 req.setCharacterEncoding("UTF-8"); 18 String linename = req.getParameter("linename"); 19 LineDAO ld = new LineDAO(); 20 try { 21 String station = ld.checkallstation(linename); 22 req.setAttribute("station",station); 23 } catch (SQLException e) { 24 e.printStackTrace(); 25 } catch (ClassNotFoundException e) { 26 e.printStackTrace(); 27 } 28 req.getRequestDispatcher("index.jsp").forward(req,resp); 29 } 30 31 @Override 32 protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { 33 super.doPost(req, resp); 34 } 35 }
 
                    
                
 
                
            
         浙公网安备 33010602011771号
浙公网安备 33010602011771号