结对开发石家庄地铁
要求：
1.开发一套石家庄地铁线路查询系统。
2.功能设计
（1）数据库设计：将石家庄地铁线路图的各个线路，各个站点，换乘信息等用数据库的形式保存起来，应该保存的信息有 {线路号，线路的各个站名，车站的换乘信息}。
（2）站点查询：用户可以输入任一一条线路或输入出发地和目的地信息，可以查询到相关内容。
例如输入出发地：石家庄铁道大学 目的地 博物院
返回经历的站名的个数，和路径，如果有换乘，请列出换乘的线路
队友：马硕
数据库：
这只是一部分，线路较长，就不全部显示了。
剩下的就是开发的事情了，
观察地图
我们得出的结论是，最多两次换乘之后，便能完成任务，我们按照这个思路来开发，
这是我们的构架
在这其中Linksql是一个工具包，搬过来修改一下数据库就可以用了，basic是基础，存的是一个站点的信息，既建立数据库时的信息，
public class StationMesic { private int id; private int line; private String name; private int num; private int exchenge; public int getId() { return id; } public void setId(int id) { this.id = id; } public int getLine() { return line; } public void setLine(int line) { this.line = line; } public String getName() { return name; } public void setName(String name) { this.name = name; } public int getNum() { return num; } public void setNum(int num) { this.num = num; } public int getExchenge() { return exchenge; } public void setExchenge(int exchenge) { this.exchenge = exchenge; } }
/* * 第一次忘记数据库中含有多个相同的站名，但line与exchenge不一样 */ import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; //import java.util.Scanner; import java.util.ArrayList; import BasicMsic.StationMesic; import LinkMysql.LinkMysql; public class StationDao { PreparedStatement pst = null; ResultSet rst = null; Statement stmt = null; Connection conn = null;// 连接数据库 public StationDao() { conn = LinkMysql.LinkMysq(); } public void free() { try { if (rst != null) rst.close(); if (pst != null) pst.close(); if (conn != null) conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public static void main(String[] args) throws SQLException { StationDao d = new StationDao(); d.comeTrue(); } @SuppressWarnings("unused") public ArrayList<StationMesic> check(String nameOne, String nameTwo) throws SQLException { // TODO Auto-generated method stub // 与数据库进行匹配 ArrayList<StationMesic> best = new ArrayList<StationMesic>();// 存储最优路线 String sql = "select * from station"; StationMesic stmOne = null; StationMesic stmTwo = null; try { pst = (PreparedStatement) conn.prepareStatement(sql); ResultSet rst = pst.executeQuery(); while (rst.next()) { if (nameOne.equals(rst.getString("name"))) { stmOne = new StationMesic(); stmOne.setId(rst.getInt("id")); stmOne.setLine(rst.getInt("line")); stmOne.setName(rst.getString("name")); stmOne.setNum(rst.getInt("num")); stmOne.setExchenge(rst.getInt("exchenge")); } else if (nameTwo.equals(rst.getString("name"))) { stmTwo = new StationMesic(); stmTwo.setId(rst.getInt("id")); stmTwo.setLine(rst.getInt("line")); stmTwo.setName(rst.getString("name")); stmTwo.setNum(rst.getInt("num")); stmTwo.setExchenge(rst.getInt("exchenge")); } } // 得到起始点与终点的信息 /* * 找交点，从起点开始到交点遍历，再由交点到终点遍历。 */ best = getMidPoint(stmOne, stmTwo); } catch (Exception e) { // TODO: handle exception } //对best的重名在进行一次函数运算。 return best; } // 两点的关系 private ArrayList<StationMesic> getMidPoint(StationMesic stmOne, StationMesic stmTwo) throws SQLException { // TODO Auto-generated method stub /* * 第一步，判断两个点是否在一条线上。 考虑它是不是换乘站 */ // System.err.println(stmOne.getLine()+"+"+stmOne.getExchenge()+"+"+stmTwo.getLine()+"+"+stmTwo.getExchenge()); /* * 使用ArrayList函数来存储最优路线。 */ ArrayList<StationMesic> best = new ArrayList<StationMesic>();// 存储最优路线 if ((stmOne.getLine() == stmTwo.getLine()) || ((stmOne.getExchenge() == stmTwo.getExchenge()) && stmOne.getExchenge() != 0) || (stmOne.getExchenge() == stmTwo.getLine()) || (stmOne.getLine() == stmTwo.getExchenge())) { // 如果在一条线上，则直接遍历。 // System.err.println("我进来了！"); best = Traverse(stmOne, stmTwo);// 输出一次，换乘0 // System.out.println(best.size()); } else { // 如果不在一条线上，则找交点，再分别遍历。 // 单换乘，与双换乘。 // System.err.println("不再一条线上！"); // 成功进入。 ArrayList<StationMesic> bestOne = gettingOneMidPoint(stmOne, stmTwo); // 少换乘 // System.out.println(bestOne.size()); ArrayList<StationMesic> bestTwo = gettingTwoMidPoint(stmOne, stmTwo); // 最优路线 // System.out.println(bestTwo.size()); if (bestOne.size() < (bestTwo.size() - 2)) { best = bestOne; } else { best = bestTwo; } } return best; } @SuppressWarnings({ "unused", "unchecked" }) private ArrayList<StationMesic> gettingTwoMidPoint(StationMesic stmOne, StationMesic stmTwo) throws SQLException { // TODO Auto-generated method stub /* * 最优路线 多换乘，将两条线上所有的换乘站存储起来， 以1.烈士陵园--》2.考试中心。 * 最短路线为烈士陵园--新百广场--十一中--槐安大桥--考试中心，一共五站。 * 首先，找L1上所有的换乘站E1，再找L2上所有的换乘站E2，如果E1的ex等于E2的ex 则这为一种情况，再由一个Int值来比较个个路线的长度。 */ /* * 得到所有的可能，然后选取最优的路线，(传到servlet层)，在显示在网页上。 */ ArrayList<StationMesic> best = new ArrayList<StationMesic>();// 存储最优路线 ArrayList<StationMesic> all = new ArrayList<StationMesic>();// 存储所有可能 // System.out.println("最优路线"); ArrayList<StationMesic> stmeOne = new ArrayList<StationMesic>(); ArrayList<StationMesic> stmeTwo = new ArrayList<StationMesic>(); stmeOne = getExchengeStation(stmOne); stmeTwo = getExchengeStation(stmTwo); // System.out.println("找到了！"+stmeTwo.size()); // int numOne = stmeOne.size(); // int numTwo = stmeTwo.size(); // 得到两条线上的换乘点。 /* * 使用for循环来找所有换乘点上的exchenge值相同的换乘点 */ for (StationMesic smOne : stmeOne) { // 第一次循环第一个点上的换乘点 for (StationMesic smTwo : stmeTwo) { // 第二次循环第二个点上的换乘点 if (smOne.getExchenge() == smTwo.getExchenge()) { // 找到exchenge值相等的点，执行Traverse函数 // 1 StationMesic stOne = new StationMesic(); stOne.setId(smOne.getId()); stOne.setLine(smOne.getLine()); stOne.setName(smOne.getName()); stOne.setNum(smOne.getNum()); stOne.setExchenge(smOne.getExchenge()); // 2 StationMesic stTwo = new StationMesic(); stTwo.setId(smTwo.getId()); stTwo.setLine(smTwo.getLine()); stTwo.setName(smTwo.getName()); stTwo.setNum(smTwo.getNum()); stTwo.setExchenge(smTwo.getExchenge()); // System.err.print("起始点："); // 起始点--》换乘1 // System.err.print("换乘1："); // 换乘1--》换乘2 // exchenge值相等 // System.err.println(stOne.getExchenge()+"+"+stTwo.getExchenge()); // System.err.print("换乘2："); // 换乘2--》终点 // System.err.println("终点。"); ArrayList<StationMesic> bestOne = Traverse(stmOne, stOne); ArrayList<StationMesic> bestTwo = Traverse(stOne, stTwo); ArrayList<StationMesic> bestThree = Traverse(stTwo, stmTwo); // System.out.println(bestOne.size()); for (StationMesic stm : bestOne) { StationMesic stmTime = new StationMesic(); stmTime.setId(stm.getId()); stmTime.setLine(stm.getLine()); stmTime.setName(stm.getName()); stmTime.setNum(stm.getNum()); stmTime.setExchenge(stm.getExchenge()); all.add(stmTime); } for (StationMesic stm : bestTwo) { StationMesic stmTime = new StationMesic(); stmTime.setId(stm.getId()); stmTime.setLine(stm.getLine()); stmTime.setName(stm.getName()); stmTime.setNum(stm.getNum()); stmTime.setExchenge(stm.getExchenge()); all.add(stmTime); } for (StationMesic stm : bestThree) { StationMesic stmTime = new StationMesic(); stmTime.setId(stm.getId()); stmTime.setLine(stm.getLine()); stmTime.setName(stm.getName()); stmTime.setNum(stm.getNum()); stmTime.setExchenge(stm.getExchenge()); all.add(stmTime); } //对best复制 if (best.size() == 0) { best=(ArrayList<StationMesic>) all.clone(); } else { // System.out.println(best.size()+"+"+all.size()); if(best.size()>all.size()) { best=(ArrayList<StationMesic>) all.clone(); } } // System.out.println("前All.size:"+all.size()); all.clear(); // System.out.println("后All.size:"+all.size()); // System.out.println("Best.size:"+best.size()); } } } return best; } @SuppressWarnings({ "null", "unused" }) private ArrayList<StationMesic> getExchengeStation(StationMesic stm) throws SQLException { // TODO Auto-generated method stub StationMesic stmex = null;// 换乘站数量 int line = stm.getLine(); int i = 0;// String sql = "select * from station"; pst = (PreparedStatement) conn.prepareStatement(sql); ResultSet rst = pst.executeQuery(); // 求L1/L2上所有的换乘站 // ArrayList // System.err.println("进入循环！"); ArrayList<StationMesic> list = new ArrayList<StationMesic>(); while (rst.next()) { if (rst.getInt("exchenge") != 0 && rst.getInt("line") == line) { stmex = new StationMesic();// 声明新数组，暂时存储 stmex.setId(rst.getInt("id")); stmex.setLine(rst.getInt("line")); stmex.setName(rst.getString("name")); stmex.setNum(rst.getInt("num")); stmex.setExchenge(rst.getInt("exchenge")); list.add(stmex); i++; } } return list; } // 找交点 private ArrayList<StationMesic> gettingOneMidPoint(StationMesic stmOne, StationMesic stmTwo) throws SQLException { // TODO Auto-generated method stub /* * 根据传入的线路值，找到交点 因为每两条线只有一个或两个交点。 交点在两条线上，所以确定一条线L1，根据L1上exchenge为L2的点是换乘站。 */ ArrayList<StationMesic> best = new ArrayList<StationMesic>();// 存储最优路线 int lineOne = stmOne.getLine(); int lineTwo = stmTwo.getLine(); String sql = "select * from station"; pst = (PreparedStatement) conn.prepareStatement(sql); ResultSet rst = pst.executeQuery(); while (rst.next()) { // System.out.println(rst.getString("name")); // System.out.println(rst.getInt("line")); int line = rst.getInt("line"); if (line == lineOne) { int exchenge = rst.getInt("exchenge"); if (exchenge == lineTwo) { // System.out.println(rst.getString("name")); StationMesic stmMid = new StationMesic(); stmMid.setId(rst.getInt("id")); stmMid.setLine(rst.getInt("line")); stmMid.setName(rst.getString("name")); stmMid.setNum(rst.getInt("num")); stmMid.setExchenge(rst.getInt("exchenge")); ArrayList<StationMesic> bestOne = Traverse(stmOne, stmMid); ArrayList<StationMesic> bestTwo = Traverse(stmMid, stmTwo); for (StationMesic stm : bestOne) { StationMesic stmTime = new StationMesic(); stmTime.setId(stm.getId()); stmTime.setLine(stm.getLine()); stmTime.setName(stm.getName()); stmTime.setNum(stm.getNum()); stmTime.setExchenge(stm.getExchenge()); best.add(stmTime); } for (StationMesic stm : bestTwo) { StationMesic stmTime = new StationMesic(); stmTime.setId(stm.getId()); stmTime.setLine(stm.getLine()); stmTime.setName(stm.getName()); stmTime.setNum(stm.getNum()); stmTime.setExchenge(stm.getExchenge()); best.add(stmTime); } } // System.out.println(best.size()); } } return best; } // 遍历两点之间的站 @SuppressWarnings("null") private ArrayList<StationMesic> Traverse(StationMesic stmOne, StationMesic stmTwo) throws SQLException { // TODO Auto-generated method stub /* * 开始只想到了两中条件，所以判断很不完善， 现在仔细想了一下，又在纸上写了一下发现还有两种情况， * 开始以为L1的line值和L2的line值或Exchenge值进行比较就能得到想要的结果 仔细一想并不是，这一二号线的四个值只有两个相等，但有四种情况。 * 所以现在来不上最后两种情况。 完成所有情况的判断后，要选取最优路线。 * */ // 前提是两点必须在一条直线上， StationMesic stm = null; ArrayList<StationMesic> list = new ArrayList<StationMesic>(); if ((stmOne.getLine() == stmTwo.getLine())) { // System.err.println("非换乘站"); // 情况1：line值相等 int Line = stmOne.getLine(); int numOne = stmOne.getNum(); int numTwo = stmTwo.getNum(); if (numOne < numTwo) { String sql = "select * from station"; stmt = conn.createStatement(); rst = stmt.executeQuery(sql); pst = (PreparedStatement) conn.prepareStatement(sql); ResultSet rst = pst.executeQuery(); while (rst.next()) { // 得到当前站的信息，num和线 int num = rst.getInt("num"); int line = rst.getInt("line"); // 正遍历 if (num >= numOne && num <= numTwo) { if (line == Line) { // System.out.println(rst.getString("name")); stm = new StationMesic();// 声明新数组，暂时存储 stm.setId(rst.getInt("id")); stm.setLine(rst.getInt("line")); stm.setName(rst.getString("name")); stm.setNum(rst.getInt("num")); stm.setExchenge(rst.getInt("exchenge")); list.add(stm); } } } } else { String sql = "select * from station order by num desc"; stmt = conn.createStatement(); rst = stmt.executeQuery(sql); pst = (PreparedStatement) conn.prepareStatement(sql); ResultSet rst = pst.executeQuery(); // 倒遍历 // System.err.println("倒遍历"); while (rst.next()) { // 得到当前站的信息，num和线 int num = rst.getInt("num"); int line = rst.getInt("line"); if (num >= numTwo && num <= numOne) { if (line == Line) { // System.out.println(rst.getString("name")); stm = new StationMesic();// 声明新数组，暂时存储 stm.setId(rst.getInt("id")); stm.setLine(rst.getInt("line")); stm.setName(rst.getString("name")); stm.setNum(rst.getInt("num")); stm.setExchenge(rst.getInt("exchenge")); list.add(stm); } } } } } else if ((stmOne.getExchenge() == stmTwo.getLine())) { // 情况2：L1的exchenge值与L2的line值相等 // System.err.println("换乘站"); // ex=line，以ex为主 int Line = stmOne.getExchenge(); int numOne = 0;// 作废 int numTwo = stmTwo.getNum(); // System.err.println(Line); // 重新获取numOne numOne = reGetNum(stmOne, stmTwo, 2); if (numOne < numTwo) {// * String sql = "select * from station"; stmt = conn.createStatement(); rst = stmt.executeQuery(sql); pst = (PreparedStatement) conn.prepareStatement(sql); ResultSet rst = pst.executeQuery(); // System.err.println(numOne + "+" + numTwo); while (rst.next()) { // 得到当前站的信息，num和线 int num = rst.getInt("num"); int line = rst.getInt("line"); // 正遍历 if (num >= numOne && num <= numTwo) { if (line == Line) { // System.out.println(rst.getString("name")); stm = new StationMesic();// 声明新数组，暂时存储 stm.setId(rst.getInt("id")); stm.setLine(rst.getInt("line")); stm.setName(rst.getString("name")); stm.setNum(rst.getInt("num")); stm.setExchenge(rst.getInt("exchenge")); list.add(stm); } } } } else { String sql = "select * from station order by num desc"; stmt = conn.createStatement(); rst = stmt.executeQuery(sql); pst = (PreparedStatement) conn.prepareStatement(sql); ResultSet rst = pst.executeQuery(); // System.err.println(numOne + "+" + numTwo); // 倒遍历 // System.err.println("倒遍历"); while (rst.next()) { // 得到当前站的信息，num和线 int num = rst.getInt("num"); int line = rst.getInt("line"); if (num >= numTwo && num <= numOne) { if (line == Line) { // System.out.println(rst.getString("name")); stm = new StationMesic();// 声明新数组，暂时存储 stm.setId(rst.getInt("id")); stm.setLine(rst.getInt("line")); stm.setName(rst.getString("name")); stm.setNum(rst.getInt("num")); stm.setExchenge(rst.getInt("exchenge")); list.add(stm); } } } } } else if ((stmOne.getExchenge() == stmTwo.getExchenge())) { // 情况3：exchenge值相等 // System.err.println("换乘站"); // ex=line，以ex为主 // 以exchenge值为中心 int Line = stmOne.getExchenge(); int numOne = 0;// 传递过来的num值作废 int numTwo = 0;// 作废 // System.err.println(Line); // 重新获取numOne numOne = reGetNum(stmOne, stmTwo, 3); numTwo = reGetNum(stmTwo, stmTwo, 3); if (numOne < numTwo) {// * String sql = "select * from station"; stmt = conn.createStatement(); rst = stmt.executeQuery(sql); pst = (PreparedStatement) conn.prepareStatement(sql); ResultSet rst = pst.executeQuery(); // System.err.println(numOne + "+" + numTwo); while (rst.next()) { // 得到当前站的信息，num和线 int num = rst.getInt("num"); int line = rst.getInt("line"); // 正遍历 if (num >= numOne && num <= numTwo) { if (line == Line) { // System.out.println(rst.getString("name")); stm = new StationMesic();// 声明新数组，暂时存储 stm.setId(rst.getInt("id")); stm.setLine(rst.getInt("line")); stm.setName(rst.getString("name")); stm.setNum(rst.getInt("num")); stm.setExchenge(rst.getInt("exchenge")); list.add(stm); } } } } else { String sql = "select * from station order by num desc"; stmt = conn.createStatement(); rst = stmt.executeQuery(sql); pst = (PreparedStatement) conn.prepareStatement(sql); ResultSet rst = pst.executeQuery(); // System.err.println(numOne + "+" + numTwo); // 倒遍历 // System.err.println("倒遍历"); while (rst.next()) { // 得到当前站的信息，num和线 int num = rst.getInt("num"); int line = rst.getInt("line"); if (num >= numTwo && num <= numOne) { if (line == Line) { // System.out.println(rst.getString("name")); stm = new StationMesic();// 声明新数组，暂时存储 stm.setId(rst.getInt("id")); stm.setLine(rst.getInt("line")); stm.setName(rst.getString("name")); stm.setNum(rst.getInt("num")); stm.setExchenge(rst.getInt("exchenge")); list.add(stm); } } } } } else if ((stmOne.getLine() == stmTwo.getExchenge())) { // 情况4：L1的line值与L2的exchenge值相等 // System.err.println("L1.line=L2.exchenge"); // ex=line，以ex为主 int Line = stmOne.getLine(); int numOne = stmOne.getNum();// 作废 int numTwo = 0; // System.err.println(Line); // 重新获取numOne numTwo = reGetNum(stmTwo, stmOne, 4); // System.out.println(numTwo); if (numOne < numTwo) {// * String sql = "select * from station"; stmt = conn.createStatement(); rst = stmt.executeQuery(sql); pst = (PreparedStatement) conn.prepareStatement(sql); ResultSet rst = pst.executeQuery(); // System.err.println(numOne + "+" + numTwo); while (rst.next()) { // 得到当前站的信息，num和线 int num = rst.getInt("num"); int line = rst.getInt("line"); // 正遍历 if (num >= numOne && num <= numTwo) { if (line == Line) { // System.out.println(rst.getString("name")); stm = new StationMesic();// 声明新数组，暂时存储 stm.setId(rst.getInt("id")); stm.setLine(rst.getInt("line")); stm.setName(rst.getString("name")); stm.setNum(rst.getInt("num")); stm.setExchenge(rst.getInt("exchenge")); list.add(stm); } } } } else { String sql = "select * from station order by num desc"; stmt = conn.createStatement(); rst = stmt.executeQuery(sql); pst = (PreparedStatement) conn.prepareStatement(sql); ResultSet rst = pst.executeQuery(); // System.err.println(numOne + "+" + numTwo); // 倒遍历 // System.err.println("倒遍历"); while (rst.next()) { // 得到当前站的信息，num和线 int num = rst.getInt("num"); int line = rst.getInt("line"); if (num >= numTwo && num <= numOne) { if (line == Line) { // System.out.println(rst.getString("name")); stm = new StationMesic();// 声明新数组，暂时存储 stm.setId(rst.getInt("id")); stm.setLine(rst.getInt("line")); stm.setName(rst.getString("name")); stm.setNum(rst.getInt("num")); stm.setExchenge(rst.getInt("exchenge")); list.add(stm); } } } } } return list; } // 重新获取Num的值 private int reGetNum(StationMesic stmOne, StationMesic stmTwo, int i) throws SQLException { // TODO Auto-generated method stub String sql = "select * from station"; stmt = conn.createStatement(); rst = stmt.executeQuery(sql); pst = (PreparedStatement) conn.prepareStatement(sql); ResultSet rst = pst.executeQuery(); // 如果以line为主，在名字相同的情况下，获取与主数相同的line值上的num int num = 0; // System.out.println(stmOne.getName()+"+"+stmOne.getExchenge()+"+"+stmOne.getLine()); // System.out.println(stmTwo.getName()+"+"+stmTwo.getExchenge()+"+"+stmTwo.getLine()); while (rst.next()) { if (rst.getString("name").equals(stmOne.getName())) { // System.out.println(rst.getInt("line")+"+"+rst.getInt("num")+"+"+i); // 以2号线的line值为主 if (rst.getInt("line") == stmOne.getExchenge() && i == 2) { // System.out.println(rst.getInt("line")); // System.out.println("我进来了！2"); num = rst.getInt("num"); break; } // 以两条线的exchenge值为主 if (rst.getInt("line") == stmTwo.getExchenge() && i == 3) { // System.out.println(rst.getInt("line")); // System.out.println("我进来了！3"); num = rst.getInt("num"); break; } // 以L1的exchenge值为主 if ((rst.getInt("line") == stmTwo.getLine()) && i == 4) { // System.out.println("我进来了！4"); // System.out.println(rst.getInt("line")); num = rst.getInt("num"); break; } } } return num; } // 主函数，测试 private void comeTrue() throws SQLException { // TODO Auto-generated method stub // @SuppressWarnings("resource") /* * @SuppressWarnings("resource") Scanner sc = new Scanner(System.in); * System.out.println("请输入始发站："); String nameOne = sc.next(); * System.out.println("请输入终点站："); String nameTwo = sc.next(); check(nameOne, * nameTwo); */ // check("中星路", "东三教"); // check("中星路", "火车站"); // check("火车站", "东三教"); // check("新百广场","槐安大桥"); // check("北国商城","槐安大桥"); check("和平医院", "考试中心"); // check("上庄","北国商城");// // check("上庄", "西王"); } }
import java.io.IOException; import java.sql.SQLException; import java.util.ArrayList; 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 BasicMsic.StationMesic; import Dao.StationDao; /** * Servlet implementation class Station */ @WebServlet("/Station") public class StationServlet extends HttpServlet { private static final long serialVersionUID = 1L; /** * @see HttpServlet#HttpServlet() */ public StationServlet() { super(); // TODO Auto-generated constructor stub } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub response.getWriter().append("Served at: ").append(request.getContextPath()); } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub response.setCharacterEncoding("text/html;UTF-8"); request.setCharacterEncoding("UTF-8"); response.setCharacterEncoding("GBK"); //跳转网页时文字显示不乱码 String nameOne=request.getParameter("one"); String nameTwo=request.getParameter("two"); //System.out.println(nameOne+nameTwo); ArrayList<StationMesic> best=new ArrayList<StationMesic>(); StationDao std=new StationDao(); try { //System.out.println(nameOne+nameTwo); best=std.check(nameOne, nameTwo); //System.out.println(nameOne+nameTwo); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>石家庄地铁</title> <style type="text/css"> body { background: url(station.jpg); background-size:1360px 720px; } </style> </head> <body> <form action="show.jsp" > <input type="text" name="one" placeholder="请输入出发站"><br> <input type="text" name="two" placeholder="请输入终点站"><br> <input type="submit" value="查询"> </form> </body> </html>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <%@ page import="Servlet.StationServlet"%> <%@ page import="BasicMsic.StationMesic"%> <%@ page import="Dao.StationDao"%> <%@ page import="java.util.ArrayList"%> <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <title>欢迎使用石家庄地铁</title> <style type="text/css"> body { background: url(station.jpg); background-size: 1360px 720px; } </style> </head> <body> <table> <% String nameOne = request.getParameter("one"); String nameTwo = request.getParameter("two"); StationDao std = new StationDao(); ArrayList<StationMesic> best = std.check(nameOne, nameTwo); %> <% for (StationMesic stm : best) { %> <tr> <td><%=stm.getName()%></td> </tr> <% } %> </table> </body> </html>
