今日共同报告-14-实现app主要页面和功能

今日共同报告-14

今天经过一天的努力，我们基本完成了地铁查询App 的所有功能和基本页面。

能够实现换乘查询，站点查询，查看所有站点。能够实现点击切换和选中的选项颜色变化。

今天的编程主要由我实现，我的伙伴负责测试。

考验了一点我们对于Fragment，RecyclerView等多种知识的综合运行

第一次结对作业基本告一段落了

合作照片：

目前进度的页面展示：

线路查询页面：

查看站点页面

站点查询：

 

部分代码：

crud

package com.example.dataapplication.DataBase;

import android.annotation.SuppressLint;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

import com.example.dataapplication.Infomation.SubwayBean;

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

public class CRUD {
    private DBHelper dbHelper;

    public CRUD (Context context){dbHelper = new DBHelper(context);}

    @SuppressLint("Range")
    public ArrayList<SubwayBean> ArrayTransferStation(String station1, String station2){

        SQLiteDatabase db = dbHelper.getReadableDatabase();
        ArrayList<SubwayBean> resultArray = new ArrayList<>();
        int i=0;
        String sql =
                    "WITH RECURSIVE transfer(start_station, stop_station, stops, paths) AS (\n" +
                    "SELECT station_name, next_station, 1 stops, \n" +
                    "       line_name||station_name||'->'||line_name||next_station AS paths\n" +
                    "FROM bj_subway\n" +
                    "WHERE station_name = ?\n" +
                    "UNION ALL \n" +
                    "SELECT t.start_station, s.next_station, stops+1, paths||'->'||s.line_name||s.next_station\n" +
                    "FROM transfer t\n" +
                    "JOIN bj_subway s \n" +
                    "ON (t.stop_station = s.station_name AND instr(paths, s.next_station)=0)\n" +
                    ")\n" +
                    "SELECT *\n" +
                    "FROM transfer\n" +
                    "WHERE stop_station = ?;";

        Cursor cursor = db.rawQuery(sql,new String[]{station1,station2});

        if (cursor.moveToFirst()){
            do {
                i++;
                SubwayBean subwayBean = new SubwayBean();
                subwayBean._StartStation = cursor.getString(cursor.getColumnIndex("start_station"));
                subwayBean._EndStation = cursor.getString(cursor.getColumnIndex("stop_station"));
                subwayBean._Number = cursor.getString(cursor.getColumnIndex("stops"));
                subwayBean._Path = cursor.getString(cursor.getColumnIndex("paths"));
                resultArray.add(subwayBean);
            }while (cursor.moveToNext());
        }
        if(i==0)
        {
            return null;
        }
        cursor.close();
        db.close();
        return resultArray;
    }

    @SuppressLint("Range")
    public ArrayList<String> PositionStation(int position){

        SQLiteDatabase db = dbHelper.getReadableDatabase();
        ArrayList<String> ArrayOnly = new ArrayList<>();
        int number = 1;
        switch (position){
            case 0:number = 1;
            break;
            case 1:number = 2;
                break;
            case 2:number = 8;
                break;
            case 3:number = 4;
                break;
            case 4:number = 5;
                break;
            case 5:number = 6;
                break;
            case 6:number = 7;
                break;
            case 7:number = 9;
                break;
            case 8:number = 11;
                break;
            case 9:number = 10;
                break;
        }
        String the_line = number+"号"+"线";
        String sql = "Select * From bj_subway2 Where line_name=?";
        Cursor cursor = db.rawQuery(sql,new String[]{the_line});
        int i=0;
        if (cursor.moveToFirst()){
            do {
                    i++;
                    String a = cursor.getString(cursor.getColumnIndex("station_name"));
                    ArrayOnly.add(a);
            }while (cursor.moveToNext());
        }

        if(i==0)
        {
            return null;
        }
        cursor.close();
        db.close();
        return ArrayOnly;
    }
    @SuppressLint("Range")
    public ArrayList<String> getArrayLine(){
        SQLiteDatabase db = dbHelper.getReadableDatabase();
        ArrayList<String> ArrayLine = new ArrayList<>();
        String sql ="Select * From bj_subway2 Where station_id In (Select Max(station_id) From bj_subway2 Group By line_name)";
        Cursor cursor = db.rawQuery(sql,null);
        int i=0;
        if (cursor.moveToFirst()){
            do {
                i++;
                String a = cursor.getString(cursor.getColumnIndex("line_name"));
                ArrayLine.add(a);
            }while (cursor.moveToNext());
        }
        if(i==0)
        {
            return null;
        }
        cursor.close();
        db.close();
        return ArrayLine;
    }
    @SuppressLint("Range")
    public String getLine(String station){

        SQLiteDatabase db = dbHelper.getReadableDatabase();
        String Line = null;
        String sql = "Select * From bj_subway2 Where station_name=?";
        Cursor cursor = db.rawQuery(sql,new String[]{station});
        int i=0;
        if (cursor.moveToFirst()){
                i++;
                Line = cursor.getString(cursor.getColumnIndex("line_name"));
        }
        if(i==0)
        {
            return null;
        }
        cursor.close();
        db.close();
        return Line;

    }
}

fragment

package com.example.dataapplication.fragment.frag1;
import android.nfc.Tag;
import android.os.Bundle;

import androidx.annotation.NonNull;
import androidx.annotation.Nullable;
import androidx.fragment.app.Fragment;
import androidx.fragment.app.FragmentManager;
import androidx.fragment.app.FragmentTransaction;
import androidx.recyclerview.widget.LinearLayoutManager;
import androidx.recyclerview.widget.RecyclerView;

import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.EditText;
import android.widget.ImageButton;
import android.widget.Toast;

import com.example.dataapplication.DataBase.CRUD;
import com.example.dataapplication.Infomation.SubwayBean;
import com.example.dataapplication.MenuActivity;
import com.example.dataapplication.R;
import com.example.dataapplication.adapter.ListViewAdapter;

import java.util.ArrayList;
import java.util.List;

public class SearchFragment extends Fragment {
    private static final String ARG_PARAM1 = "param1";
    private static final String ARG_PARAM2 = "param2";
    private String mParam1,mParam2;
    private EditText mEt_start,mEt_end;
    private ImageButton mBtn_search;
    private RecyclerView mList;
    private List<SubwayBean> mData;
    private String start,end;

    public SearchFragment() {

    }
    public static SearchFragment newInstance(String param1, String param2) {
        SearchFragment fragment = new SearchFragment();
        Bundle args = new Bundle();
        args.putString(ARG_PARAM1, param1);
        args.putString(ARG_PARAM2, param2);
        fragment.setArguments(args);
        return fragment;
    }
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        if (getArguments() != null) {
            mParam1 = getArguments().getString(ARG_PARAM1);
            mParam2 = getArguments().getString(ARG_PARAM2);
        }
    }
    @Override
    public View onCreateView(LayoutInflater inflater, ViewGroup container,
                             Bundle savedInstanceState) {

        return inflater.inflate(R.layout.fragment_search, container, false);
    }
    @Override
    public void onViewCreated(@NonNull View view, @Nullable Bundle savedInstanceState) {
        super.onViewCreated(view, savedInstanceState);

        mEt_start  = view.findViewById(R.id.frag_et_start);
        mEt_end    = view.findViewById(R.id.frag_et_end);
        mBtn_search= view.findViewById(R.id.frag_btn_find);

        mList = view.findViewById(R.id.frag_recycle_show);



        mBtn_search.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                start=mEt_start.getText().toString();
                end=mEt_end.getText().toString();
                CRUD crud = new CRUD(getContext());
                if (crud.ArrayTransferStation(start,end)==null){
                    Toast.makeText(getContext(), "输入为空或查不到此数据", Toast.LENGTH_SHORT).show();
                }else {
                    initData();
                }

            }
        });



    }

    private void initData() {

            mData = new ArrayList<SubwayBean>();
            CRUD crud = new CRUD(getContext());
            //导入数据
            ArrayList<SubwayBean> subList = crud.ArrayTransferStation(start,end);

            for (int i = 0; i < subList.size(); i++) {

                SubwayBean subway = new SubwayBean();
                SubwayBean subData =subList.get(i);
                subway._StartStation = subData._StartStation;
                subway._EndStation = subData._EndStation;
                subway._Number = subData._Number;
                subway._Path = subData._Path;
                mData.add(subway);
            }
            //设置布局管理器
            LinearLayoutManager linearLayoutManager = new LinearLayoutManager(getContext());
            mList.setLayoutManager(linearLayoutManager);
            //创建适配器
            ListViewAdapter adapter = new ListViewAdapter(mData);
            //设置到listview里
            mList.setAdapter(adapter);
    }

}

package com.example.dataapplication.fragment.frag2;

import android.os.Bundle;

import androidx.annotation.NonNull;
import androidx.annotation.Nullable;
import androidx.fragment.app.Fragment;
import androidx.recyclerview.widget.LinearLayoutManager;
import androidx.recyclerview.widget.RecyclerView;

import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;

import com.example.dataapplication.DataBase.CRUD;
import com.example.dataapplication.R;
import com.example.dataapplication.adapter.LeftListAdapter;

import java.util.ArrayList;
import java.util.List;

public class LeftListFragment extends Fragment {
    private static final String ARG_PARAM1 = "param1";
    private static final String ARG_PARAM2 = "param2";
    private String mParam1;
    private String mParam2;
    private RecyclerView mList,mList2;
    private List<String> mData,mData2;

    private LeftListAdapter mAdapter,mAdapter2;
    public LeftListFragment() {

    }
    public static LeftListFragment newInstance(String param1, String param2) {
        LeftListFragment fragment = new LeftListFragment();
        Bundle args = new Bundle();
        args.putString(ARG_PARAM1, param1);
        args.putString(ARG_PARAM2, param2);
        fragment.setArguments(args);
        return fragment;
    }

    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        if (getArguments() != null) {
            mParam1 = getArguments().getString(ARG_PARAM1);
            mParam2 = getArguments().getString(ARG_PARAM2);
        }
    }

    @Override
    public View onCreateView(LayoutInflater inflater, ViewGroup container,
                             Bundle savedInstanceState) {
        return inflater.inflate(R.layout.fragment_left_list, container, false);
    }

    @Override
    public void onViewCreated(@NonNull View view, @Nullable Bundle savedInstanceState) {
        super.onViewCreated(view, savedInstanceState);
        mList = view.findViewById(R.id.frag_recycle_left);
        mList2 = view.findViewById(R.id.frag_recycle_right);
        initData1();

    }


    private void initData2(int position) {
        mData2 = new ArrayList<String>();
        CRUD crud = new CRUD(getContext());
        //导入数据
        ArrayList<String> subList = crud.PositionStation(position);

        for (int i = 0; i < subList.size(); i++) {

            String stationData = subList.get(i);
            mData2.add(stationData);
        }
        //设置布局管理器
        LinearLayoutManager linearLayoutManager = new LinearLayoutManager(getContext());
        mList2.setLayoutManager(linearLayoutManager);
        //创建适配器
        mAdapter2 = new LeftListAdapter(mData2);
        //设置到listview里
        mList2.setAdapter(mAdapter2);
    }

    private void initData1() {
        mData = new ArrayList<String>();
        CRUD crud = new CRUD(getContext());
        //导入数据
        ArrayList<String> subList = crud.getArrayLine();

        for (int i = 0; i < subList.size(); i++) {

            String stationData = subList.get(i);
            mData.add(stationData);
        }
        //设置布局管理器
        LinearLayoutManager linearLayoutManager = new LinearLayoutManager(getContext());
        mList.setLayoutManager(linearLayoutManager);
        //创建适配器
        mAdapter = new LeftListAdapter(mData);
        //设置到listview里
        mList.setAdapter(mAdapter);

        mAdapter.setOnItemClick1(new LeftListAdapter.OnItemClickListener1() {
            @Override
            public void OnItemClick1(int position) {
                initData2(position);
            }
        });

    }
}

package com.example.dataapplication.fragment.frag3;

import android.os.Bundle;

import androidx.annotation.NonNull;
import androidx.annotation.Nullable;
import androidx.fragment.app.Fragment;
import androidx.recyclerview.widget.RecyclerView;
import androidx.recyclerview.widget.StaggeredGridLayoutManager;

import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.EditText;
import android.widget.ImageButton;
import android.widget.TextView;
import android.widget.Toast;

import com.example.dataapplication.DataBase.CRUD;
import com.example.dataapplication.R;
public class MapFragment extends Fragment {
    private static final String ARG_PARAM1 = "param1";
    private static final String ARG_PARAM2 = "param2";
    private String mParam1;
    private String mParam2;

    private EditText mEt1;
    private ImageButton mBtn1;
    private TextView mTv1;
    public MapFragment() {
    }
    public static MapFragment newInstance(String param1, String param2) {
        MapFragment fragment = new MapFragment();
        Bundle args = new Bundle();
        args.putString(ARG_PARAM1, param1);
        args.putString(ARG_PARAM2, param2);
        fragment.setArguments(args);
        return fragment;
    }
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        if (getArguments() != null) {
            mParam1 = getArguments().getString(ARG_PARAM1);
            mParam2 = getArguments().getString(ARG_PARAM2);
        }
    }
    @Override
    public View onCreateView(LayoutInflater inflater, ViewGroup container,
                             Bundle savedInstanceState) {
        return inflater.inflate(R.layout.fragment_map, container, false);
    }

    @Override
    public void onViewCreated(@NonNull View view, @Nullable Bundle savedInstanceState) {
        super.onViewCreated(view, savedInstanceState);

        mEt1  = view.findViewById(R.id.map_et_1);
        mBtn1    = view.findViewById(R.id.map_btn_1);
        mTv1= view.findViewById(R.id.map_tv_1);

        mBtn1.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {

                String text1=mEt1.getText().toString();
                CRUD crud = new CRUD(getContext());
                String text2 = crud.getLine(text1);
                if (text2 != null) {
                    mTv1.setText(text1+" 位于 "+text2);
                }else {
                    Toast.makeText(getContext(), "输入为空或查不到此数据", Toast.LENGTH_SHORT).show();
                }

            }
        });

    }
}

Activity

package com.example.dataapplication;

import androidx.appcompat.app.AppCompatActivity;
import androidx.fragment.app.FragmentManager;
import androidx.fragment.app.FragmentTransaction;

import android.annotation.SuppressLint;
import android.os.Bundle;
import android.view.View;
import android.widget.ImageView;
import android.widget.LinearLayout;
import android.widget.TextView;

import com.example.dataapplication.fragment.frag2.LeftListFragment;
import com.example.dataapplication.fragment.frag3.MapFragment;
import com.example.dataapplication.fragment.frag1.SearchFragment;

public class MenuActivity extends AppCompatActivity implements View.OnClickListener{

    private LinearLayout lSearch,lSubway,lMap;
    private ImageView    ivHome,ivFind,ivMine;
    private TextView     tvHome,tvFind,tvMine;
    FragmentManager fragmentManager;
    FragmentTransaction fragmentTransaction;
    @SuppressLint("MissingInflatedId")
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_menu);
        initView();
        initEvent();
    }

    private void initEvent() {
        fragmentManager = getSupportFragmentManager();
        fragmentTransaction = fragmentManager.beginTransaction();
        SearchFragment fragment = SearchFragment.newInstance("","");
        fragmentTransaction.replace(R.id.menu_frag_search,fragment).commit();

        lSearch.setOnClickListener(this);
        lSubway.setOnClickListener(this);
        lMap.setOnClickListener(this);
    }

    private void initView() {
        lSearch = findViewById(R.id.menu_ll_1);
        lSubway = findViewById(R.id.menu_ll_2);
        lMap    = findViewById(R.id.menu_ll_3);

        ivHome = findViewById(R.id.menu_iv_1);
        ivFind = findViewById(R.id.menu_iv_2);
        ivMine = findViewById(R.id.menu_iv_3);

        tvHome = findViewById(R.id.menu_tv_1);
        tvFind = findViewById(R.id.menu_tv_1);
        tvMine = findViewById(R.id.menu_tv_1);
    }
    public void resetButton(){

        ivHome.setSelected(false);
        ivFind.setSelected(false);
        ivMine.setSelected(false);
    }
    @Override
    public void onClick(View view) {

        int id = view.getId();
        switch (id){
            case R.id.menu_ll_1:
                fragmentManager = getSupportFragmentManager();
                fragmentTransaction = fragmentManager.beginTransaction();
                SearchFragment fragment1 = SearchFragment.newInstance("","");
                fragmentTransaction.replace(R.id.menu_frag_search,fragment1).commit();

                resetButton();
                ivHome.setSelected(true);
                break;
            case R.id.menu_ll_2:

                fragmentManager = getSupportFragmentManager();
                fragmentTransaction = fragmentManager.beginTransaction();
                LeftListFragment fragment2 = LeftListFragment.newInstance("","");
                fragmentTransaction.replace(R.id.menu_frag_search,fragment2).commit();

                resetButton();
                ivFind.setSelected(true);
                break;
            case R.id.menu_ll_3:
                fragmentManager = getSupportFragmentManager();
                fragmentTransaction = fragmentManager.beginTransaction();
                MapFragment fragment3 = MapFragment.newInstance("","");
                fragmentTransaction.replace(R.id.menu_frag_search,fragment3).commit();
                resetButton();
                ivMine.setSelected(true);
                break;
        }

    }

}