电子及商务网站建设报告,建设网站虚拟主机在哪买,python编程软件官网,做网站需要的技术 规范设计思想#xff1a;地铁售票系统的关键点在于换乘#xff0c;所以首先要分为换乘和不换乘两种情况。不换乘比较简单#xff0c;通过起始站名和终点站名查询他们的num#xff0c;然后list打包输出到jsp就可以。换乘的话就先要找到两条线路#xff0c;找到两条线路的交点也… 设计思想地铁售票系统的关键点在于换乘所以首先要分为换乘和不换乘两种情况。不换乘比较简单通过起始站名和终点站名查询他们的num然后list打包输出到jsp就可以。换乘的话就先要找到两条线路找到两条线路的交点也就是换乘站然后分别输出起始站到换乘站换乘站到终点站两段路线就完成了这里面还涉及到一个最短路径问题我的想法是把全部的可能线路都找到然后比较大小就完成了。目前进度到换乘部分。 双人项目合作人郑锦 部分源代码 package Dao;import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;import connection.DBUtil;public class dao {/*** 通过name得到number(线路号)* param name* return*/public static int getNum(String name) {String sql select xianluhao from aaa where name name ;Connection conn DBUtil.getConn();Statement state null;ResultSet rs null;int number0;try {state conn.createStatement();rs state.executeQuery(sql);while (rs.next()) {number rs.getInt(xianluhao);}} catch (Exception e) {e.printStackTrace();} finally {DBUtil.close(rs, state, conn);}return number;}/*** 通过name得到zhanhao(站台号)* param name* return*/public static int getZhanhao(String name) {String sql select num from aaa where name name ;Connection conn DBUtil.getConn();Statement state null;ResultSet rs null;int zhanhao0;try {state conn.createStatement();rs state.executeQuery(sql);while (rs.next()) {zhanhao rs.getInt(num);}} catch (Exception e) {e.printStackTrace();} finally {DBUtil.close(rs, state, conn);}return zhanhao;}public static String getLine1(int zhanhao1,int zhanhao2) {String line;String sql select name from aaa where num between zhanhao1 and zhanhao2order by num ASC ;//升序Connection conn DBUtil.getConn();Statement state null;ResultSet rs null; try {state conn.createStatement();rs state.executeQuery(sql);if(rs.next())liners.getString(name);while (rs.next()) {String namers.getString(name);lineline-name;}} catch (Exception e) {e.printStackTrace();} finally {DBUtil.close(rs, state, conn);}return line;}public static String getLine2(int zhanhao1,int zhanhao2) {String line;String sql select name from aaa where num between zhanhao1 and zhanhao2 order by num DESC ;//降序Connection conn DBUtil.getConn();Statement state null;ResultSet rs null; try {state conn.createStatement();rs state.executeQuery(sql);if(rs.next())liners.getString(name);while (rs.next()) {String namers.getString(name);lineline-name;}} catch (Exception e) {e.printStackTrace();} finally {DBUtil.close(rs, state, conn);}return line;}}package servlet;import java.io.IOException;
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 Dao.dao;WebServlet(/servlet)
public class servlet extends HttpServlet {private static final long serialVersionUID 1L;protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {req.setCharacterEncoding(utf-8);String method req.getParameter(method);if (chaxun.equals(method)) {chaxun(req, resp);} }private void chaxun(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {// TODO Auto-generated method stubreq.setCharacterEncoding(utf-8);String qireq.getParameter(qi);String zhongreq.getParameter(zhong);int zhanhao1dao.getZhanhao(qi);int zhanhao2dao.getZhanhao(zhong);int number1dao.getNum(qi);int number2dao.getNum(zhong);if(number1number2) {if(zhanhao1zhanhao2){String linedao.getLine1(zhanhao1, zhanhao2);req.setAttribute(line,line );req.setAttribute(num,number1);req.getRequestDispatcher(list.jsp).forward(req,resp);}if(zhanhao1zhanhao2){String linedao.getLine2(zhanhao2, zhanhao1);System.out.print(line);req.setAttribute(num,number1);req.setAttribute(line,line );req.getRequestDispatcher(list.jsp).forward(req,resp);}
}}}实验截图 项目总结分析 这个项目因为涉及到一个最短路径的问题最开始我是想用迪杰斯特拉算法来解决这个问题。但是我尝试了很久没有成功可能是我的水平还是太有限。所以最后用了最简单的方法来解决这个问题。我了解到有的同学是用迪杰斯特拉算法完成了这个项目所以还是去请教一下。后期有时间的话还是想改善一下我程序的算法。 转载于:https://www.cnblogs.com/xuange1/p/10652328.html
