public class RiderInfo_Fragment extends Fragment {

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

 @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中獲取數(shù)據(jù)，參數(shù)二 infoList會(huì)存儲(chǔ)獲得數(shù)據(jù) 
  getDataFromInfoList(); //將list中的數(shù)據(jù)添加到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});
  // 第一個(gè)參數(shù)是上下文對(duì)象
  // 第二個(gè)是listitem------數(shù)據(jù)加載
  // 第三個(gè)是指定每個(gè)列表項(xiàng)的布局文件
  // 第四個(gè)是指定Map對(duì)象中定義的兩個(gè)鍵（這里通過(guò)字符串?dāng)?shù)組來(lái)指定）
  // 第五個(gè)是用于指定在布局文件中定義的id（也是用數(shù)組來(lái)指定）
  adapter.setViewBinder(new SimpleAdapter.ViewBinder() {

   //通過(guò)實(shí)現(xiàn)ViewBinder()這個(gè)接口，在里面定義數(shù)據(jù)和視圖的匹配關(guān)系 ---加載圖片 Bitmap類(lèi)型（默認(rèn)是使用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);
  //監(jiān)聽(tīng)item項(xiàng)并攜帶數(shù)據(jù)跳轉(zhuǎn)到另一個(gè)界面
  listView.setOnItemClickListener(new AdapterView.OnItemClickListener() {
   @Override
   public void onItemClick(AdapterView<?> 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);//初始設(shè)置ViewPager選中第一幀
  //ViewPager的監(jiān)聽(tīng)事件
  vp.setOnPageChangeListener(new ViewPager.OnPageChangeListener() {
   @Override
   public void onPageScrolled(int position, float positionOffset, int positionOffsetPixels) {

   }

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

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

 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) { //用于判斷當(dāng)前為哪一個(gè)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是指向表中的下一行數(shù)據(jù)
    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();
  }
 }