基于Layui+vue.js+ajax的地铁查询系统三

后端传递回json格式的数据，前端ajax进行解析，通过vue.js进行渲染

工程目录如下

 

 

 后端代码

bean包

package Bean;

public class bean {
    private String Xid;
    private String Cid;
    public bean(String xid, String cid, String zname, String next, String changeid, String xname) {
        Xid = xid;
        Cid = cid;
        Zname = zname;
        Next = next;
        Changeid = changeid;
        Xname = xname;
    }

    private String Zname;
    private String Next;
    private String Changeid;
    private String Xname;



    public bean() {

    }

    public String getXid() {
        return Xid;
    }

    public void setXid(String xid) {
        Xid = xid;
    }

    public String getCid() {
        return Cid;
    }

    public void setCid(String cid) {
        Cid = cid;
    }

    public String getZname() {
        return Zname;
    }

    public void setZname(String zname) {
        Zname = zname;
    }

    public String getNext() {
        return Next;
    }

    public void setNext(String next) {
        Next = next;
    }

    public String getChangeid() {
        return Changeid;
    }

    public void setChangeid(String changeid) {
        Changeid = changeid;
    }

    public String getXname() {
        return Xname;
    }

    public void setXname(String xname) {
        Xname = xname;
    }
}

 

package Bean;

public class changebean {
    private String id1;
    private String id2;

    public String getStopid() {
        return stopid;
    }

    public void setStopid(String stopid) {
        this.stopid = stopid;
    }

    private String stopid;
    public String getId1() {
        return id1;
    }

    public void setId1(String id1) {
        this.id1 = id1;
    }

    public String getId2() {
        return id2;
    }

    public void setId2(String id2) {
        this.id2 = id2;
    }


}

package Bean;

public class changestop {
    private String xname;
    private String changestop;
    private String next;
    private String zname;

    public changestop(String xname, String changestop, String next, String zname) {
        this.xname = xname;
        this.changestop = changestop;
        this.next = next;
        this.zname = zname;
    }



    public String getZname() {
        return zname;
    }

    public void setZname(String zname) {
        this.zname = zname;
    }

    public String getXname() {
        return xname;
    }

    public void setXname(String xname) {
        this.xname = xname;
    }

    public String getChangestop() {
        return changestop;
    }

    public void setChangestop(String changestop) {
        this.changestop = changestop;
    }

    public String getNext() {
        return next;
    }

    public void setNext(String next) {
        this.next = next;
    }


}

servlet包

package Servlet;
import Bean.changestop;
import Dao.Dao;
import com.fasterxml.jackson.databind.ObjectMapper;

import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.annotation.*;
import java.io.IOException;
import java.sql.SQLException;
import java.util.ArrayList;

@WebServlet("/ServletStart")
public class ServletStart extends HttpServlet {
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String start=request.getParameter("start");
        String end=request.getParameter("end");
        Dao dao=new Dao();
        ArrayList arrayList=new ArrayList<changestop>();
        try {
            arrayList=dao.SelectS(start,end);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        response.setContentType("text/html;charset=UTF-8");
        ObjectMapper mapper = new ObjectMapper();
        mapper.writeValue(response.getWriter(),arrayList);//将数组转换成json数据传递到前端*/

    }
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        this.doPost(request, response);

    }
}

package Servlet;



import Bean.bean;
import Dao.Dao;
import com.fasterxml.jackson.databind.ObjectMapper;

import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.annotation.*;
import java.io.IOException;
import java.sql.SQLException;
import java.util.ArrayList;

@WebServlet("/ServletXian")
public class ServletXian extends HttpServlet {
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String Xid=request.getParameter("Xid");
        bean b=new bean();
        b.setXid(Xid);
        Dao dao=new Dao();
        ArrayList<bean> arrayList=new ArrayList<bean>();
        try {
            arrayList=dao.SelectX(b);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        response.setContentType("text/html;charset=UTF-8");
        ObjectMapper mapper = new ObjectMapper();
        mapper.writeValue(response.getWriter(),arrayList);//将数组转换成json数据传递到前端*/
    }

    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        this.doPost(request, response);
    }
}

package Servlet;

import Bean.bean;
import Dao.Dao;
import com.fasterxml.jackson.databind.ObjectMapper;

import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.annotation.*;
import java.io.IOException;
import java.sql.SQLException;
import java.util.ArrayList;

@WebServlet("/ServletZhan")
public class ServletZhan extends HttpServlet {
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String Zname=request.getParameter("Zname");
        bean b=new bean();
        b.setZname(Zname);
        Dao dao=new Dao();
        ArrayList<bean> arrayList=new ArrayList<bean>();
        try {
            arrayList=dao.SelectC(b);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        response.setContentType("text/html;charset=UTF-8");
        ObjectMapper mapper = new ObjectMapper();
        mapper.writeValue(response.getWriter(),arrayList);//将数组转换成json数据传递到前端*/
    }

    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        this.doPost(request, response);
    }
}

dao包

package Dao;

import Bean.bean;
import Bean.changebean;
import Bean.changestop;
import Utils.JDBCUtils;

import java.sql.*;
import java.util.ArrayList;

public class Dao {
    private Connection connection ;
    private PreparedStatement preparedStatement;
    private ResultSet rs;
    private Statement state;
    private int i;

    public ArrayList<bean> SelectX(bean b) throws SQLException {
        ArrayList arrayList=new ArrayList<bean>();
        connection= JDBCUtils.getConnection();
        String sql="select * from xianlu";
        preparedStatement = connection.prepareStatement(sql);
        rs=preparedStatement.executeQuery();
        while(rs.next())
        {
             String Xid=rs.getString("Xid");
             String Cid=rs.getString("Cid");
             String Zname= rs.getString("Zname");
             String Next= rs.getString("Next");
             String Changeid= rs.getString("Changeid");
              String Xname=rs.getString("Xname");
              Xname="地铁"+Xname+"号线";
              bean a=new bean(Xid,Cid,Zname,Next,Changeid,Xname);
              if(b.getXid().equals(Xid))
              arrayList.add(a);
        }
        JDBCUtils.close(connection, preparedStatement);
        return arrayList;
    }
    public ArrayList<bean> SelectC(bean b) throws SQLException {
        ArrayList arrayList=new ArrayList<bean>();
        connection= JDBCUtils.getConnection();
        String sql="select * from xianlu";
        preparedStatement = connection.prepareStatement(sql);
        rs=preparedStatement.executeQuery();
        while(rs.next())
        {
            String Xid=rs.getString("Xid");
            String Cid=rs.getString("Cid");
            String Zname= rs.getString("Zname");
            String Next= rs.getString("Next");
            String Changeid= rs.getString("Changeid");
            String Xname=rs.getString("Xname");
            Xname="地铁"+Xname+"号线";
            bean a=new bean(Xid,Cid,Zname,Next,Changeid,Xname);
            if(b.getZname().equals(Zname))
                arrayList.add(a);
        }
        JDBCUtils.close(connection, preparedStatement);
        return arrayList;
    }

    public ArrayList SelectS(String start, String end) throws SQLException {
        ArrayList arrayList=new ArrayList<changebean>();
        String id1="";
        String id2="";
        String changeid="";
        int sid = 0;
        int sid1=0;
        String stopid = "";
        connection = JDBCUtils.getConnection();
        String sql="select * from xianlu where Zname = ?";
        preparedStatement = connection.prepareStatement(sql);
        preparedStatement.setString(1, start);
        rs =  preparedStatement.executeQuery();
        while(rs.next())
        {
            id1=rs.getString("Xid");
        }
        JDBCUtils.close(connection,preparedStatement);
        connection=JDBCUtils.getConnection();
        String sql1 = "select * from xianlu where Zname = ?";
        preparedStatement = connection.prepareStatement(sql1);
        preparedStatement.setString(1, end);
        rs =  preparedStatement.executeQuery();
        while(rs.next())
        {
            id2=rs.getString("Xid");
        }
        JDBCUtils.close(connection,preparedStatement);
        if(id1.equals(id2))
        {
            connection= JDBCUtils.getConnection();
            String sql3="select * from xianlu";
            preparedStatement = connection.prepareStatement(sql3);
            rs=preparedStatement.executeQuery();
            while(rs.next())
            {
                String Zname= rs.getString("Zname");
                String Next= rs.getString("Next");
                String Xname=rs.getString("Xname");
                Xname="地铁"+Xname+"号线";
                changestop a=new changestop(Xname,"",Next,Zname);
                if(!Zname.equals(end))
                    arrayList.add(a);
                else{
                    arrayList.add(a);
                    JDBCUtils.close(connection,preparedStatement);
                    return arrayList;
                }
            }
        }
        else{
            connection= JDBCUtils.getConnection();
            String sql4="select * from sss";
            preparedStatement = connection.prepareStatement(sql4);
            rs=preparedStatement.executeQuery();
            while(rs.next())
            {
                String i1= rs.getString("id1");
                String i2=rs.getString("id2");
                changeid=rs.getString("stopid");

            }
            JDBCUtils.close(connection,preparedStatement);
            String sql5="select * from xianlu";
            connection= JDBCUtils.getConnection();
            preparedStatement = connection.prepareStatement(sql5);
            rs=preparedStatement.executeQuery();
            while(rs.next())
            {
                String Cid=rs.getString("Cid");
             String zname=rs.getString("Zname");
             if(zname.equals(start))
             {
                 String Zname= rs.getString("Zname");
                 String Next= rs.getString("Next");
                 String Xname=rs.getString("Xname");
                 Xname="地铁"+Xname+"号线";
                 changestop a=new changestop(Xname,"",Next,Zname);
                 arrayList.add(a);
                 sid=1;
             }
            if(!Cid.equals(changeid)&&sid==1)
            {String Zname= rs.getString("Zname");
                String Next= rs.getString("Next");
                String Xname=rs.getString("Xname");
                Xname="地铁"+Xname+"号线";
                changestop a=new changestop(Xname,"",Next,Zname);
                arrayList.add(a);}
            else if(Cid.equals(changeid)){
                String Changeid=rs.getString("Changeid");
                String Zname= rs.getString("Zname");
                String Next= rs.getString("Next");
                String Xname=rs.getString("Xname");
                stopid=Changeid;
                Xname="地铁"+Xname+"号线";
                Changeid="换乘地铁"+Changeid+"线";
                changestop a=new changestop(Xname,Changeid,Next,Zname);
                arrayList.add(a);
                break;
            }
            }
            JDBCUtils.close(connection,preparedStatement);
            connection=JDBCUtils.getConnection();
            String sql6="select * from xianlu";
            preparedStatement = connection.prepareStatement(sql6);
            rs=preparedStatement.executeQuery();
            while(rs.next()){
                String Xid=rs.getString("Xid");
                String Zname= rs.getString("Zname");
                String Next= rs.getString("Next");
                String Xname=rs.getString("Xname");
                Xname="地铁"+Xname+"号线";
                   if(Xid.equals(stopid))
                   {
                       sid1=1;
                   }
                 if(sid1==1&&!end.equals(Zname))
                 {
                     String zname= rs.getString("Zname");
                     String next= rs.getString("Next");
                     String xname=rs.getString("Xname");
                     xname="地铁"+xname+"号线";
                     changestop a=new changestop(xname,"",next,Zname);
                     arrayList.add(a);
                 }
                 else if(end.equals(Zname))
                 {
                     String zname= rs.getString("Zname");
                     String next= rs.getString("Next");
                     String xname=rs.getString("Xname");
                     xname="地铁"+xname+"号线";
                     changestop a=new changestop(xname,"",next,Zname);
                     arrayList.add(a);
                     return arrayList;
                 }
            }
        }
return arrayList;
    }
}

utils包

package Utils;

import java.sql.*;

public class JDBCUtils {
    public static String url="jdbc:mysql://localhost:3306/test?useSSL=false";
    public static String user="root";
    public static String password="root";
    public static Connection getConnection(){
        Connection conn=null;
        try{
            Class.forName("com.mysql.jdbc.Driver");
            conn= DriverManager.getConnection(url,user,password);

        }catch (ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        }
        return conn;
    }

    public static void close(Statement state, Connection conn){
        if(state!=null){
            try{
                state.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
        if(conn!=null){
            try{
                conn.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }

    }
    public static void close(Connection conn, PreparedStatement ps ){
        if(ps!=null){
            try{
                ps.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
        if(conn!=null){
            try{
                conn.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
    }

    public static void close(ResultSet rs, Statement state, Connection conn){
        if(rs!=null){
            try{
                rs.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
        if(state!=null){
            try{
                state.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
        if(conn!=null){
            try{
                conn.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
    }
    public static void close(ResultSet rs,PreparedStatement state,Connection conn){
        if(rs!=null){
            try{
                rs.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
        if(state!=null){
            try{
                state.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
        if(conn!=null){
            try{
                conn.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
    }

}