android分页查询功能工具类的实现

在一个项目中，常常需要频繁的分页，所以有必要实现一个封装的类来统一管理实现。

首先看下效果图：
 

从上图我们可以看出，这里是将listview中的数据通过底下的分页工具实现分页显示。那我们接下来先贴出代码：
复制代码
1、实现布局,这里有两个布局文件，第一个主布局文件main.xml

<RelativeLayout  xmlns:android="http://schemas.android.com/apk/res/android"
                android:id="@+id/whole_region"
                android:layout_width="fill_parent"
                android:layout_height="fill_parent"
                android:orientation="vertical" >

                <HorizontalScrollView
                    android:id="@+id/HorizontalScrollView01"
                    android:layout_width="fill_parent"
                    android:layout_height="wrap_content"
                    android:layout_above="@+id/pagebtn"
                    android:layout_alignParentTop="true" >

                    <LinearLayout
                        android:layout_width="wrap_content"
                        android:layout_height="fill_parent"
                        android:orientation="vertical" >

                        <LinearLayout
                            android:id="@+id/list_view_title"
                            android:layout_width="wrap_content"
                            android:layout_height="wrap_content"
                            android:orientation="horizontal">                        
                        </LinearLayout>

                        <ListView
                            android:id="@+id/list"
                            android:layout_width="wrap_content"
                            android:layout_height="wrap_content"
                            android:fadeScrollbars="false" >
                        </ListView>
                    </LinearLayout>
                </HorizontalScrollView>

                <LinearLayout
                    android:id="@id/pagebtn"
                    android:layout_width="fill_parent"
                    android:layout_height="wrap_content"
                    android:layout_alignParentBottom="true"
                    android:orientation="vertical" >

                    <include layout="@layout/pagebutton" />
                </LinearLayout>
            </RelativeLayout>

第二个布局文件pagebutton.xml.这个文件嵌套在第一个主文件中。
复制代码
复制代码
<pre class="html" name="code"><?xml version="1.0" encoding="utf-8"?>
<merge xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="fill_parent" android:layout_height="fill_parent">
    <TableLayout android:id="@+id/TableLayout1"
        android:layout_width="fill_parent" android:layout_height="wrap_content"
        android:stretchColumns="0,1,2,3,4,5,6,7" android:shrinkColumns="0,1,2,3,4,5,6,7" 
        android:paddingTop="5dip" android:paddingLeft="5dip" android:paddingRight="5dip">
        <TableRow>
            <TextView android:text="共" android:layout_width="wrap_content"
                android:layout_height="wrap_content" android:textSize="18sp" />
            <TextView android:id="@+id/total_page_num" android:minWidth="30dp"
                android:layout_width="wrap_content" android:layout_height="wrap_content"
                android:textColor="#C71585"
                android:textSize="18sp" />
            <TextView android:text="页" android:layout_width="wrap_content"
                android:layout_height="wrap_content" android:textSize="18sp" />
            <TextView android:id="@+id/total_record_num"
                android:minWidth="60dp" android:layout_width="wrap_content"
                android:layout_height="wrap_content" android:textColor="#C71585" android:textSize="18sp" />
            <TextView android:text="条，" android:layout_width="wrap_content"
                android:layout_height="wrap_content" android:textSize="18sp" />
            <TextView android:text="每页" android:layout_width="wrap_content"
                android:layout_height="wrap_content" android:textSize="18sp" />
            <TextView android:id="@+id/record_num_each_page"
                android:layout_width="wrap_content" 
复制代码
                                    android:layout_height="wrap_content"                      
复制代码
                                    android:textColor="#C71585"
                android:textSize="18sp" />
            <TextView android:text="条" android:layout_width="wrap_content"
                android:layout_height="wrap_content" android:textSize="18sp" />
        </TableRow>
    </TableLayout>
    <TableLayout android:id="@+id/TableLayout1"
        android:layout_width="fill_parent" android:layout_height="wrap_content"
        android:stretchColumns="0,1,2,3,4,5,6,7" android:shrinkColumns="0,1,2,3,4,5,6,7,8" android:paddingTop="5dip">
        <TableRow>
            <Button android:id="@+id/first_page" android:text="|<"
                android:layout_width="wrap_content" android:layout_height="wrap_content"
                android:textSize="18sp" />
            <Button android:id="@+id/page_up" android:text=" < "
                android:layout_width="wrap_content" android:layout_height="wrap_content"
                android:textSize="18sp" />
            <Button android:id="@+id/page_down" android:text=" > "
                android:layout_width="wrap_content" android:layout_height="wrap_content"
                android:textSize="18sp" />
            <Button android:id="@+id/last_page" android:text=">|"
                android:layout_width="wrap_content" android:layout_height="wrap_content"
                android:textSize="18sp" />
            <TextView android:text="第" android:layout_width="wrap_content"
                android:layout_height="wrap_content" android:textSize="18sp" />
            <EditText android:id="@+id/current_page" android:maxWidth="40dip"
                android:singleLine="true" android:layout_width="wrap_content"
                android:layout_height="wrap_content"  android:textColor="#C71585" android:textSize="18sp" />
            <TextView android:text="页" android:layout_width="wrap_content"
                android:layout_height="wrap_content" android:textSize="18sp" />
            <Button android:id="@+id/to_page" android:text="转到"
                android:layout_width="wrap_content" android:layout_height="wrap_content"
                android:textSize="18sp" />
        </TableRow>
    </TableLayout>
</merge>
复制代码
第二步：新建一个activity,用来显示界面
复制代码
public class BuilderList1 extends QueryContextActivity {
    private PagedQueryResultHelper pagedQueryResultHelper;
    private Map<String, Object> params;
    private ListView list;
    private List<Integer> columnWidths;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        // TODO Auto-generated method stub
        super.onCreate(savedInstanceState);
        setContentView(R.layout.mynotifylist);
        setOnClickListener();
        

        columnWidths = new ArrayList<Integer>();
        int weight = this.getWindowManager().getDefaultDisplay().getWidth();
        columnWidths.add(weight);

        pagedQueryResultHelper = new PagedQueryResultHelper(this);
        pagedQueryResultHelper.setTitleCellWidth(columnWidths);
复制代码
//这个方法是用来查询数据并显示在LISTVIEW中的，我们这次的重点不在这里，我只列出不详讲，有兴趣的朋友可以自己研究下listview               query();  
复制代码
    }

    <p>        protected void query() {
                params = new HashMap<String, Object>();
                params.put("userName", UserInfo.getUserName());</p><p>                pagedQueryResultHelper.setQueryParams("getBuilderList", params,
               "startNum", "endNum", "MyNotifyList", R.array.build_list_name, R.array.build_list);
             if (pagedQueryResultHelper.initialQuery() == null) {
                             new AlertDialog.Builder(this)
                            .setTitle(R.string.message_title)
                            .setMessage("没有查询到相关信息，请返回！")
                            .setPositiveButton(R.string.OK_text, null)
                            .setPositiveButton(R.string.OK_text,
                           new DialogInterface.OnClickListener() {
                       @Override
                    public void onClick(DialogInterface dialog, int which) {</p><p>                            BuilderList1.this.finish();</p><p>                     } }).show();
  };</p><p>             list = (ListView) findViewById(R.id.list);</p><p>             list.setOnItemClickListener(new OnItemClickListener() {
             @Override
            public void onItemClick(AdapterView<?> adapterView, View view, int index, long arg3) {</p><p>                  List<Map<String, Object>> data = pagedQueryResultHelper .getWholeResult();
                  Intent intent = new Intent(BuilderList1.this,FloorInfo.class);
                  intent.putExtra("value", (Serializable) data.get(index));
                  intent.putExtra("buildid", data.get(index).get("BUILDID").toString());
                  startActivity(intent); }});
 }</p><p>             @Override
            public void onClick(View arg0) {
              switch (arg0.getId()) {
              case R.id.first_page:
               pagedQueryResultHelper.firstPage();
                  break;
              case R.id.page_down:
               pagedQueryResultHelper.pageDown();
                  break;
              case R.id.page_up:
               pagedQueryResultHelper.pageUp();
                break;
              case R.id.last_page:
               pagedQueryResultHelper.lastPage();
                 break;
              case R.id.to_page:
               pagedQueryResultHelper.toPage();
                break;
        }
    }</p><p>        @Override
              protected void clear() {
   }</p><p>       @Override
    protected void setOnClickListener() {
   }</p><p>}</p><p> </p>第三步：实现这个工具类，这个类代码有些多
复制代码
复制代码
<pre class="java" name="code">package org.Base.Utils;

import java.util.Arrays;
import java.util.List;
import java.util.Map;

import org.Base.Activities.QueryContextActivity;
import org.Base.Container.DataTableAdapter;
import org.Base.Container.myListViewTitle;
import org.Base.Webservice.WSObjectListUtil;
import org.Base.Webservice.WSObjectMapUtil;
import org.Base.Webservice.WSObjectUtil;
import org.Base.Webservice.WSUtil;
import org.Base.Webservice.WebServiceConfig;
import org.DigitalCM.R;
import org.ksoap2.serialization.SoapObject;

import android.app.AlertDialog;
import android.util.Log;
import android.widget.Button;
import android.widget.EditText;
import android.widget.ListView;
import android.widget.TextView;

public class PagedQueryResultHelper {
    private final static int initialFromRecordNum = 1;//每页从第1条开始
    private final static int initialToRecordNum = 20;//每页可以显示20条

    public PagedQueryResultHelper(QueryContextActivity contextActivity) {//构造函数用来初始化，主要是用来接收传过来的activity做为上下文对象
        this.contextActivity = contextActivity;

        findViews();//调用此方法找到传过来的activity的控件对象
        setOnClickListener();//给控件设置监听
        if (currentPageText != null) {//如果所有页面只有一页，那就只显示一页
            setCurrentPage(1);
        }
    }

    public List<List<String>> initialQuery() {
        setRecordNumEachPage(initialToRecordNum - initialFromRecordNum + 1);//设置每页的记录条数
        return query(initialFromRecordNum, initialToRecordNum);

    }

    public List<List<String>> initialQuery01() {
        return query(methodName, params);
    }

    private void setCurrentPage(int currentPage) {//设置当前页
        this.currentPage = currentPage;
        currentPageText.setText(String.valueOf(currentPage));
    }

    public void setMarkable(boolean bMarkable) {//这个是用来标记记录的
        this.bMarkable = bMarkable;
    }

    public void setRecordNumEachPage(int recordNumEachPage) {);//设置每页的记录条数
        this.recordNumEachPage = recordNumEachPage;
        recordNumEachPageText.setText(String.valueOf(recordNumEachPage));
    }

    public void setTotalRecord(int totalRecord) {//设置总记录数
        this.totalRecord = totalRecord;
        totalRecordNumText.setText(String.valueOf(totalRecord));
        getTotalPageNumText();
    }

    private QueryContextActivity contextActivity;
    private TextView totalPageNumText;
    private TextView totalRecordNumText;
    private TextView recordNumEachPageText;
    private Button firstPage;
    private Button pageDown;
    private Button pageUp;
    private Button lastPage;
    private EditText currentPageText;
    private Button toPage;

    private int totalPage;
    private int totalRecord;
    private int recordNumEachPage;
    private int currentPage;
    private String fromRecordNumField;
    private String toRecordNumField;
    private String methodName;
    private Map<String, Object> params;
    private String contentTableName;
    // private String countTableName;
    private int headerNameId;
    private int headerId;
    private List<Integer> columnWidths = null;
    private boolean bSetTitleValue = false;
    private List<Map<String, Object>> wholeresult = null;
    private List<List<String>> rows = null;
    private boolean bMarkable = false;
    private DataTableAdapter dataTableAdapter;

    public void setQueryParams(String methodName, Map<String, Object> params,
            String fromRecordNumField, String toRecordNumField,
            String contentTableName, int headerNameId, int headerId) {
        this.methodName = methodName;
        this.params = params;
        this.fromRecordNumField = fromRecordNumField;
        this.toRecordNumField = toRecordNumField;
        this.contentTableName = contentTableName;
        // this.countTableName = countTableName;
        this.headerNameId = headerNameId;
        this.headerId = headerId;
    }

    public void setQueryParams(String methodName, Map<String, Object> params,
            String fromRecordNumField, String toRecordNumField,
            String contentTableName) {
        this.methodName = methodName;
        this.params = params;
        this.fromRecordNumField = fromRecordNumField;
        this.toRecordNumField = toRecordNumField;
        this.contentTableName = contentTableName;
        // this.countTableName = countTableName;

    }

    public void setQueryParams(String methodName, Map<String, Object> params,
            String contentTableName, int headerNameId, int headerId) {
        this.methodName = methodName;
        this.params = params;

        this.contentTableName = contentTableName;

        this.headerNameId = headerNameId;
        this.headerId = headerId;

    }

    public void setTitleCellWidth(List<Integer> columnWidths) {
        this.columnWidths = columnWidths;
    }

    /*
     * public int getCurrentPage(){ return currentPage; }
     */

    private void findViews() {
        totalPageNumText = (TextView) contextActivity
                .findViewById(R.id.total_page_num);
        totalRecordNumText = (TextView) contextActivity
                .findViewById(R.id.total_record_num);
        recordNumEachPageText = (TextView) contextActivity
                .findViewById(R.id.record_num_each_page);
        firstPage = (Button) contextActivity.findViewById(R.id.first_page);
        pageDown = (Button) contextActivity.findViewById(R.id.page_down);
        pageUp = (Button) contextActivity.findViewById(R.id.page_up);
        lastPage = (Button) contextActivity.findViewById(R.id.last_page);
        currentPageText = (EditText) contextActivity
                .findViewById(R.id.current_page);
        toPage = (Button) contextActivity.findViewById(R.id.to_page);
    }

    private void setOnClickListener() {
        if (firstPage != null) {
            firstPage.setOnClickListener(contextActivity);
        }
        if (pageDown != null) {
            pageDown.setOnClickListener(contextActivity);
        }
        if (pageUp != null) {
            pageUp.setOnClickListener(contextActivity);
        }
        if (lastPage != null) {
            lastPage.setOnClickListener(contextActivity);
        }
        if (toPage != null) {
            toPage.setOnClickListener(contextActivity);
        }
    }

    private void getRecordNumEachPageText() {
        try {
            recordNumEachPage = Integer.parseInt(recordNumEachPageText
                    .getText().toString());
        } catch (NumberFormatException e) {
            Log.e("NumberFormatException", e.getMessage());
        }
    }

    private boolean outOfEachPageRange() {
        recordNumEachPage = Integer.parseInt(recordNumEachPageText.getText()
                .toString());
        if (recordNumEachPage > 20 || recordNumEachPage < 1) {
            return true;
        }
        return false;
    }

    private void getTotalPageNumText() {
        getRecordNumEachPageText();
        if (recordNumEachPage == 0)
            return;
        if (totalRecord == 0) {
            totalPage = 0;
            totalPageNumText.setText(String.valueOf(0));
            return;
        }
        if (totalRecord % recordNumEachPage == 0) {//java中分页常用到的计算公式
            totalPage = totalRecord / recordNumEachPage;
        } else {
            totalPage = totalRecord / recordNumEachPage + 1;
        }
        totalPageNumText.setText(String.valueOf(totalPage));
    }

    public void pageDown() {
        if (outOfEachPageRange()) {
            AlertDialog.Builder dialog = new AlertDialog.Builder(
                    contextActivity);
            dialog.setTitle("提示：").setMessage("每页显示条数在1~20之间！")
                    .setPositiveButton("确认", null).show();
            return;
        }
        if (currentPage != totalPage) {
            setCurrentPage(++currentPage);
            getTotalPageNumText();
            query(recordNumEachPage * (currentPage - 1) + 1, recordNumEachPage
                    * currentPage);
        }
    }

    public void pageUp() {
        if (outOfEachPageRange()) {
            AlertDialog.Builder dialog = new AlertDialog.Builder(
                    contextActivity);
            dialog.setTitle("提示：").setMessage("每页显示条数在1~20之间！")
                    .setPositiveButton("确认", null).show();
            return;
        }
        if (currentPage != 1 && currentPage != 0) {
            setCurrentPage(--currentPage);
            getTotalPageNumText();
            query(recordNumEachPage * (currentPage - 1) + 1, recordNumEachPage
                    * currentPage);
        }
    }

    public void firstPage() {
        if (outOfEachPageRange()) {
            AlertDialog.Builder dialog = new AlertDialog.Builder(
                    contextActivity);
            dialog.setTitle("提示：").setMessage("每页显示条数在1~20之间！")
                    .setPositiveButton("确认", null).show();
            return;
        }
        getTotalPageNumText();
        if (totalPage > 1) {
            setCurrentPage(1);
            query(1, recordNumEachPage);
        }
    }

    public void lastPage() {
        if (outOfEachPageRange()) {
            AlertDialog.Builder dialog = new AlertDialog.Builder(
                    contextActivity);
            dialog.setTitle("提示：").setMessage("每页显示条数在1~20之间！")
                    .setPositiveButton("确认", null).show();
            return;
        }
        getTotalPageNumText();
        if (totalPage != 1 && totalPage != 0) {
            setCurrentPage(totalPage);
            query(recordNumEachPage * (totalPage - 1) + 1, totalRecord);
        }
    }

    public void toPage() {
        if (outOfEachPageRange()) {
            AlertDialog.Builder dialog = new AlertDialog.Builder(
                    contextActivity);
            dialog.setTitle("提示：").setMessage("每页显示条数在1~20之间！")
                    .setPositiveButton("确认", null).show();
            return;
        }
        try {
            currentPage = Integer
                    .parseInt(currentPageText.getText().toString());
        } catch (NumberFormatException e) {
            Log.e("NumberFormatException", e.getMessage());
            return;
        }
        getTotalPageNumText();
        query(recordNumEachPage * (currentPage - 1) + 1, recordNumEachPage
                * currentPage);
        currentPageText.setText(String.valueOf(currentPage));
    }

    public List<List<String>> query(int fromRecordNum, int toRecordNum) {
        return query(methodName, params, fromRecordNumField, toRecordNumField,
                fromRecordNum, toRecordNum);
    }

    private List<List<String>> query(String methodName,
            Map<String, Object> params, String fromRecordNumField,
            String toRecordNumField, int fromRecordNum, int toRecordNum) {
        params.put(fromRecordNumField, fromRecordNum);
        params.put(toRecordNumField, toRecordNum);

        return query(methodName, params);
    }

    public List<Map<String, Object>> getWholeResult() {
        return wholeresult;
    }

    public List<Map<String, Object>> getResult() {
        return wholeresult;
    }

    public List<Boolean> getCheckBoxState() {
        return dataTableAdapter.getCheckBoxState();
    }

    public List<List<String>> query(String methodName,
            Map<String, Object> params) {//此方法要重点注意，因为这里是根据webservice查询到的数据，所以要传递来方法和参数
        SoapObject result = null;

        if (methodName == null) {
            if (bSetTitleValue == false) {//下面是实现listview的标题显示
                bSetTitleValue = true;
                myListViewTitle listViewTitle = new myListViewTitle(
                        contextActivity);
                if (this.columnWidths != null) {
                    listViewTitle.setTitleCellWidth(this.columnWidths);
                }
                List<String> headerList = Arrays.asList(contextActivity
                        .getResources().getStringArray(headerId));
                listViewTitle.setTitleCellValue(headerList);
            }
            return null;
        }

        try {
            result = WSUtil.getSoapObjectByCallingWS(//这里是android调用webservice的典型方法
                    WebServiceConfig.NAMESPACE, methodName, params,
                    WebServiceConfig.wsdl);
        } catch (Exception e) {
            new AlertDialog.Builder(contextActivity)
                    .setTitle(R.string.message_title)
                    .setMessage(R.string.connection_error)
                    .setPositiveButton(R.string.OK_text, null).show();
            Log.e("Exception", e.getMessage());
        }

        if (result == null) {//如果从webservice得到的结果为null，那我们就找到listview，并赋空值，将分页的显示值设为0
            ListView list = (ListView) contextActivity.findViewById(R.id.list);
            list.setAdapter(null);
            setTotalRecord(0);
            this.setCurrentPage(0);
            return null;
        }

        SoapObject dataSet = WSObjectUtil.getDataSetObject(result);//如果从webservice得到的结果不为空，则转化成dataSet          
复制代码
if (dataSet == null) {//如果dataSet为空，则显示对话框，没有查询到相关数据   
  1.                             new AlertDialog.Builder(contextActivity)  
  2.             .setTitle(R.string.message_title).setMessage("没有查询到相关数据！")  
  3.             .setPositiveButton(R.string.OK_text, null);  
  4.   
  5.     return null;  
  6. }  
// 否则，就取得列名，并将取得的dataset转化成list型的数据，最后将数据显示在listview,并通过rows返回数据 
复制代码
     List<String> columnNameList = Arrays.asList(contextActivity
                .getResources().getStringArray(headerNameId));
        WSObjectListUtil wsObjectListUtil = new WSObjectListUtil();
        if (contentTableName != null) {
            rows = wsObjectListUtil.getTableValueList(dataSet,
                    contentTableName, columnNameList);
        } else {
            rows = wsObjectListUtil.getTableValueList(dataSet, columnNameList);
        }
        if (wholeresult != null) {
            wholeresult.clear();
        }
        WSObjectMapUtil wsObjectMapUtil = new WSObjectMapUtil();
        if (contentTableName != null) {
            wholeresult = wsObjectMapUtil.getRowMapList(contentTableName,
                    dataSet);
        } else {
            wholeresult = WSObjectMapUtil.getRowMapList(dataSet);
        }
        SoapObject countTable = (SoapObject) dataSet.getProperty(dataSet
                .getPropertyCount() - 1);
        try {
            totalRecord = Integer
                    .parseInt(countTable.getProperty(0).toString());
        } catch (Exception e) {
            Log.e("Exception", e.getMessage());
        }
        if (totalRecord != 0 && this.totalRecord == 0
                && currentPageText != null) {
            this.setCurrentPage(1);
        }
        setTotalRecord(totalRecord);

        if (bSetTitleValue == false) {
            bSetTitleValue = true;
            myListViewTitle listViewTitle = new myListViewTitle(contextActivity);
            if (this.columnWidths != null) {
                listViewTitle.setTitleCellWidth(this.columnWidths);
            }
            List<String> headerList = Arrays.asList(contextActivity
                    .getResources().getStringArray(headerId));
            listViewTitle.setTitleCellValue(headerList);
        }

        ListView list = (ListView) contextActivity.findViewById(R.id.list);
        dataTableAdapter = new DataTableAdapter(contextActivity, rows);
        if (bMarkable) {
            dataTableAdapter.setMarkable(true);
        }
        if (this.columnWidths != null) {
            dataTableAdapter.setColumnWidths(this.columnWidths);
        }
        list.setAdapter(dataTableAdapter);//注意，关键点：将数据显示在listview

        return rows;//返回数据
    }
}
复制代码
posted @ 2012-06-04 14:56  移动应用开发  阅读(2214)  评论(1)  编辑  收藏  举报