结对作业（地铁项目）11

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

1.新学期目标2024-03-052.打卡2024-05-293.打卡22024-05-294.打卡32024-05-295.打卡 42024-05-296.打卡52024-06-137.打卡62024-06-138.打卡72024-06-169.打卡82024-06-1610.打卡92024-06-1611.打卡102024-06-1612.结对作业（地铁查询项目）012024-06-1613.结对作业（地铁项目）022024-06-1614.结对作业（地铁项目）032024-06-1615.结对作业（地铁项目）042024-06-1616.结对作业（地铁项目）052024-06-1617.结对作业（地铁项目）062024-06-1618.结对作业（地铁项目）072024-06-1619.结对作业（地铁项目）082024-06-1620.结对作业（地铁项目）092024-06-1621.结对作业（地铁项目）102024-06-16

22.结对作业（地铁项目）112024-06-16

23.结对作业（地铁项目）122024-06-1624.结对作业（地铁项目）132024-06-1625.结对作业（地铁项目）142024-06-1626.五一冲刺（政策查询系统）12024-06-1627.五一冲刺（政策查询系统）22024-06-1628.政策查询系统（安卓）12024-06-1629.政策查询系统（安卓）22024-06-1630.政策查询系统（安卓）32024-06-1631.政策查询系统（安卓）42024-06-1632.政策查询系统（安卓）52024-06-1633.政策查询系统（安卓）62024-06-1634.政策查询系统（安卓）72024-06-1635.JS开发2024-02-2836.安卓app开发相关2024-02-2837.第一次个人作业（安卓学习记录系统）012024-06-1638.第一次个人作业（安卓学习记录系统）022024-06-1639.第一次个人作业（安卓学习记录系统）032024-06-1640.第一次个人作业（安卓学习记录系统）042024-06-1641.第一次个人作业（安卓学习记录系统）052024-06-1642.第一次个人作业（安卓学习记录系统）062024-06-1643.第一次个人作业（安卓学习记录系统）072024-06-1644.打卡112024-06-1945.打卡122024-06-1946.打卡132024-06-1947.打卡142024-06-1948.打卡152024-06-1949.打卡162024-06-1950.打卡172024-06-1951.打卡182024-06-1952.打卡192024-06-1953.打卡202024-06-1954.python学习2024-06-1955.python学习22024-06-1956.python学习32024-06-1957.Javaweb2024-06-1958.打卡212024-06-1959.fragment学习和使用2024-06-1960.mybits学习12024-06-1961.mybits学习22024-06-1962.mybits学习32024-06-1963.课程总结2024-06-1964.个人总结2024-06-19

收起

近期地铁项目作业再次升级，部署到安卓端，我们依旧准备先从后端做起，在连接前端

package com.example.subway.database;

import java.sql.*;

public class DB {
    public Connection conn = null;
    public Statement stmt = null;
    public ResultSet rs = null;
    String url = "jdbc:mysql://172.18.56.78:3306/subway?useSSL=false&serverTimezone=UTC&allowPublicKeyRetrieval=true";
    String username = "root";
    String password = "20223959";
    public DB(){
        try{
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection(url,username,password);
            stmt = conn.createStatement();
        }catch(SQLException se){
            // 处理 JDBC 错误
            se.printStackTrace();
        }catch(Exception e){
            // 处理 Class.forName 错误
            e.printStackTrace();
        }
    }
    public void close(){
        try {
            if (rs!=null){
                rs.close();
            }
            if (stmt!=null){
                stmt.close();
            }
            if (conn!=null){
                conn.close();
            }
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }


}

package com.example.subway.dao;


import com.example.subway.database.DB;
import com.example.subway.entity.SubwayBean;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

public class Sub {

    public ArrayList<SubwayBean> ArrayTransferStation(String station1, String station2){

        ArrayList<SubwayBean> resultArray = new ArrayList<>();
        DB db = new DB();
        PreparedStatement preparedStatement=null;
        ResultSet rs = null;
        int i=0;

        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 station_table 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 station_table 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=db.conn.prepareStatement(sql);
            preparedStatement.setString(1,station1);
            preparedStatement.setString(2,station2);
            rs = preparedStatement.executeQuery();

            while (rs.next())
            {
                i++;
                SubwayBean subwayBean = new SubwayBean();
                subwayBean._StartStation = (String) rs.getObject(1);
                subwayBean._EndStation = (String) rs.getObject(2);
                subwayBean._Number = rs.getObject(3);
                subwayBean._Path = (String) rs.getObject(4);
                resultArray.add(subwayBean);

            }
            if(i==0)
            {
                return null;
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally{
            db.close();
        }
        return resultArray;
    }
    public ArrayList<String> ArrayStationLine(String line){

        DB db = new DB();
        ArrayList<String> station = new ArrayList<>();
        String l_name = "'" + line + "'";
        try {
            String selectQuery = "SELECT * FROM station_table WHERE line_name="+l_name;
            db.rs =db.stmt.executeQuery(selectQuery);

            while (db.rs.next()){

                String base_name=db.rs.getString("station_name");
                station.add(base_name);

            }

        } catch (SQLException e) {
            e.printStackTrace();
        } finally{
            db.close();
        }
        if (station.size()==0){
            return null;
        }
        return station;
    }
    public String LineStation(String name){

        DB db = new DB();
        String na = "'" + name + "'";
        String line = "地铁";
        try {
            String selectQuery = "SELECT * FROM station_table WHERE station_name="+na;
            db.rs =db.stmt.executeQuery(selectQuery);

            if (db.rs.next()){
                String base_name=db.rs.getString("line_name");
                line += base_name;
//                line += "号线";
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally{
            db.close();
        }
        if (line == "地铁"){
            return null;
        }
        return line;
    }

}

package com.example.subway;

import android.annotation.SuppressLint;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.AdapterView;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Spinner;
import android.widget.TextView;

import androidx.appcompat.app.AppCompatActivity;

import com.example.subway.dao.Sub;
import com.example.subway.entity.SubwayBean;
//import com.example.subway.database.MySQLConnection;

import java.util.ArrayList;

public class MainActivity extends AppCompatActivity implements View.OnClickListener {
    private Spinner spiLine;
    private EditText ediStation;
    private EditText ediStart;
    private EditText ediEnd;
    private TextView tvStation;

    private TextView tvLine;

    private TextView tvSe;

//    MySQLConnection mySQLConnection = new MySQLConnection();

    Sub sub = new Sub();
    @SuppressLint("MissingInflatedId")
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);


        spiLine=findViewById(R.id.spiLine);
        ediStation=findViewById(R.id.ediStaion);
        ediStart=findViewById(R.id.ediStart);
        ediEnd=findViewById(R.id.ediEnd);
        tvLine=findViewById(R.id.tvLine);
        tvStation= findViewById(R.id.tvStation);
        tvSe = findViewById(R.id.tvSe);

        findViewById(R.id.btnLine).setOnClickListener(this);
        findViewById(R.id.btnStation).setOnClickListener(this);
        findViewById(R.id.btnSe).setOnClickListener(this);

    }

    @Override
    public void onClick(View v) {
        int id = v.getId();
        if(id == R.id.btnLine){

           String select = (String) spiLine.getSelectedItem();
           Log.d( "lhw",select);

            new Thread(new Runnable() {
                @Override
                public void run() {
                    ArrayList<String> l1 = sub.ArrayStationLine(select);

                    runOnUiThread(new Runnable() {
                        @Override
                        public void run() {
                            tvLine.setText(l1.toString());
                        }
                    });

                }
            }).start();
        }else if(id == R.id.btnStation){
            String na = ediStation.getText().toString();
            new Thread(new Runnable() {
                @Override
                public void run() {
                    String line = sub.LineStation(na);
                    runOnUiThread(new Runnable() {
                        @Override
                        public void run() {
                            tvStation.setText(line);
                        }
                    });
                }
            }).start();
        }else{
            String start = ediStart.getText().toString();
            String end = ediEnd.getText().toString();
            new Thread(new Runnable() {
                @Override
                public void run() {
                    ArrayList<SubwayBean> arr = sub.ArrayTransferStation(start,end);
                    runOnUiThread(new Runnable() {
                        @Override
                        public void run() {
                            String lines = "";
                            for(int i   = 0;i<arr.size();++i){
                                 lines += arr.get(i)._Path + "\n\n";
                            }
                            tvSe.setText(lines);
                        }
                    });
                }
            }).start();
        }
    }
}