public class RiderInfo_Fragment extends Fragment {

 List<Map<String, Object>> listitem = new ArrayList<Map<String, Object>>(); //存儲數據的數組列表---里面的數據將顯示在ListView中
 ListView listView = null; 
 List<Info> infoList = new ArrayList<>(); //從SQLite中獲得的數據將存儲在改集合中-------info是bean類

 @Override
 public View onCreateView(@NonNull LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState) {
  // Inflate the layout for this fragment
  View view = inflater.inflate(R.layout.rider_info_fragment, null);

  listView = (ListView) view.findViewById(R.id.showRiderInfo); //綁定Listview
  getRiderHistoryInfoFromSQite(getActivity(), infoList); //該方法用于從SQLite中獲取數據，參數二 infoList會存儲獲得數據 
  getDataFromInfoList(); //將list中的數據添加到map集合中
  initListData();
  return view;
 }
  private void getDataFromInfoList() {
  for (int i = 0; i < infoList.size(); i++) {
   Map<String, Object> map = new HashMap<String, Object>();
   map.put("name", infoList.get(i).getUsername());
   map.put("address", "f");
   map.put("price", "444");
   map.put("objectID", infoList.get(i).objectIds);
   listitem.add(map);
  }
 }

  private void initListData() {
  SimpleAdapter adapter = new SimpleAdapter(getActivity()
    , listitem
    , R.layout.rider_info_fragment_item
    , new String[]{"name", "address", "price", "objectID"}
    , new int[]{R.id.time, R.id.address, R.id.price, R.id.objectID});
  // 第一個參數是上下文對象
  // 第二個是listitem------數據加載
  // 第三個是指定每個列表項的布局文件
  // 第四個是指定Map對象中定義的兩個鍵（這里通過字符串數組來指定）
  // 第五個是用于指定在布局文件中定義的id（也是用數組來指定）
  adapter.setViewBinder(new SimpleAdapter.ViewBinder() {

   //通過實現ViewBinder()這個接口，在里面定義數據和視圖的匹配關系 ---加載圖片 Bitmap類型（默認是使用R.id.---）
   @Override
   public boolean setViewValue(View view, Object data,
          String textRepresentation) {
    if ((view instanceof ImageView) & (data instanceof Bitmap)) {
     ImageView iv = (ImageView) view;
     Bitmap bm = (Bitmap) data;
     iv.setImageBitmap(bm);
     return true;
    }
    return false;
   }
  });
  listView.setAdapter(adapter);
  //監聽item項并攜帶數據跳轉到另一個界面
  listView.setOnItemClickListener(new AdapterView.OnItemClickListener() {
   @Override
   public void onItemClick(AdapterView<&#63;> adapterView, View view, int i, long l) {
    ListView listView = (ListView) adapterView;
    HashMap<String, String> map = (HashMap<String, String>) listView.getItemAtPosition(i);
    Intent intent = new Intent(getActivity(), RiderInfoManager.class);
    Bundle bundle = new Bundle();
    bundle.putString("objectid", map.get("objectID"));
    intent.putExtras(bundle);
    startActivity(intent);
   }
  });
 }

public class MainActivity extends AppCompatActivity implements View.OnClickListener {

private ViewPager vp;
 CustomerInfo_Fragment customerInfo_fragment;
 RiderInfo_Fragment riderInfo_fragment;
 private List<Fragment> mFragmentList = new ArrayList<Fragment>();
 FragmentAdapter mFragmentAdapter;
 TextView custome, rider;

 @Override
 protected void onCreate(Bundle savedInstanceState) {

  super.onCreate(savedInstanceState);
  setContentView(R.layout.activity_main);
  initView();
  mFragmentAdapter = new FragmentAdapter(this.getSupportFragmentManager(), mFragmentList);
  vp.setOffscreenPageLimit(2);//ViewPager的緩存為2幀
  vp.setAdapter(mFragmentAdapter);
  vp.setCurrentItem(0);//初始設置ViewPager選中第一幀
  //ViewPager的監聽事件
  vp.setOnPageChangeListener(new ViewPager.OnPageChangeListener() {
   @Override
   public void onPageScrolled(int position, float positionOffset, int positionOffsetPixels) {

   }

   @Override
   public void onPageSelected(int position) {
    /*此方法在頁面被選中時調用*/
    //title.setText(titles[position]);
    changeTextColor(position);
   }

   @Override
   public void onPageScrollStateChanged(int state) {
    /*此方法是在狀態改變的時候調用，其中arg0這個參數有三種狀態（0，1，2）。
    arg0==1的時辰默示正在滑動，
    arg0==2的時辰默示滑動完畢了，
    arg0==0的時辰默示什么都沒做。*/
   }
  });
 }

 void initView() {
  custome = findViewById(R.id.customer);
  rider = findViewById(R.id.rider);
  custome.setOnClickListener(this);
  rider.setOnClickListener(this);
  vp = (ViewPager) findViewById(R.id.mainViewPager);
  customerInfo_fragment = new CustomerInfo_Fragment();
  riderInfo_fragment = new RiderInfo_Fragment();
  mFragmentList.add(customerInfo_fragment);
  mFragmentList.add(riderInfo_fragment);
 }
@Override
 public void onClick(View view) { //用于判斷當前為哪一個fragment
  int i = view.getId();
  if (i == R.id.customer) {
   vp.setCurrentItem(0, true);
  } else if (i == R.id.rider) {
   vp.setCurrentItem(1, true);
  }
 }

 public class FragmentAdapter extends FragmentPagerAdapter {

  List<Fragment> fragmentList = new ArrayList<Fragment>();

  public FragmentAdapter(android.support.v4.app.FragmentManager fm, List<Fragment> fragmentList) {
   super(fm);
   this.fragmentList = fragmentList;
  }

  @Override
  public Fragment getItem(int position) {
   return fragmentList.get(position);
  }

  @Override
  public int getCount() {
   return fragmentList.size();
  }

 }

 public static void getRiderHistoryInfoFromSQite(Activity activity, List<Info> infoList) {
  DBOpenHelper helper = new DBOpenHelper(activity, "qianbao.db", null, 1);
  SQLiteDatabase db = helper.getWritableDatabase();
  Cursor c = db.query("RiderHistoryInfo", null, null, null, null, null, null);
  if (c != null && c.getCount() >= 1) {
   while (c.moveToNext()) { //moveToNext是指向表中的下一行數據
    infoList.add(new Info(c.getString(c.getColumnIndex("userName")), c.getString(c.getColumnIndex("userPhone")),
      c.getString(c.getColumnIndex("price")), c.getString(c.getColumnIndex("address")),
      c.getString(c.getColumnIndex("createTime")), c.getString(c.getColumnIndex("objectId")),""));
   }
   c.close();
   db.close();
  }
 }