GreenDao的简单使用说明(三)多表的操作1:n

        我们在使用数据库的时候，大多数都会是多表联合操作，不会只有一个表的，下面我们就来说一下，多表的操作，这里先拿1：n来说。这是我们平时在设计数据库时最常用的模式。下面我来看一下，GreenDao对1:n的模式是怎么处理的。

        一，我们先要新建两个表，用来实现1：n。我们先来修改MyDaoGenerator.java这个文件。代码如下：

      

package pl.surecase.eu;import de.greenrobot.daogenerator.DaoGenerator;import de.greenrobot.daogenerator.Entity;import de.greenrobot.daogenerator.Property;import de.greenrobot.daogenerator.Schema;import de.greenrobot.daogenerator.ToMany;public class MyDaoGenerator {    public static void main(String args[]) throws Exception {        Schema schema = new Schema(3, "greendao");        schema.setDefaultJavaPackageDao("com.guangda.dao");        Entity userBean = schema.addEntity("Users");        userBean.setTableName("Users");        //userBean.addLongProperty("id").primaryKey().index().autoincrement();        userBean.addIdProperty();        userBean.addStringProperty("uSex");        userBean.addStringProperty("uTelphone");        userBean.addStringProperty("uAge");        userBean.addStringProperty("uName");        //上面是我们用于单表操作的时建立的表        //下面是我们要建的两个新表，一个上信息类别，一个是信自，它们的关系是1:n.        //对于信息类别表，没有什么好说的，和上面一样，直接建立一个表就完了，我们主要来看一下信息表中，如何设置外键        Entity infoTypeBean = schema.addEntity("infoType");        //此处是用来实现序列化的接口        infoTypeBean.implementsSerializable();        infoTypeBean.addIdProperty();        infoTypeBean.addStringProperty("infoName");        //信息表进行建立        Entity infoBean = schema.addEntity("infos");        infoBean.implementsSerializable();        infoBean.addIdProperty();        infoBean.addStringProperty("infoTitle");        infoBean.addStringProperty("infoAuthor");        infoBean.addStringProperty("infoContent");        //这里我们为信息表，添加一个typeId外键，它就是infoType表的id        Property typeId = infoBean.addLongProperty("typeId").getProperty();                //这里是重点，我们为这两个表建立1:n的关系，并设置关联字段。        infoBean.addToOne(infoTypeBean, typeId);        ToMany addToMany = infoTypeBean.addToMany(infoBean,typeId);        addToMany.setName("infoes");        new DaoGenerator().generateAll(schema, args[0]);    }}

          我在代码中加了比较详细的注解，相信大家一看就明白了。

         注意：

                    Schema schema = new Schema(3, "greendao");这里的版本号，你要比之前的版本号大1,原来咱们是1，我这里是3，是因为我当时写代码的时候，写错了一个地方，没法子，就又升了一次。哈哈。。。。。。。。

      

       二，修改我们封装的DaoMaster.OpenHelper代码，让他进行升级，代码如下

       

package com.example.cg.greendaolearn;import android.content.Context;import android.database.sqlite.SQLiteDatabase;import com.guangda.dao.DaoMaster;import com.guangda.dao.infoTypeDao;import com.guangda.dao.infosDao;/** * 封装DaoMaster.OpenHelper方法, 在更新的时候,用来保存原来的数据 * greenDao默认在更新的时候,会新建表,原来的数据就丢失了 * Created by cg on 2015/12/28. */public class THDevOpenHelper extends DaoMaster.OpenHelper {    public THDevOpenHelper(Context context, String name, SQLiteDatabase.CursorFactory factory) {        super(context, name, factory);    }    @Override    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {        switch (oldVersion) {            case 2:                //创建新表，注意createTable()是静态方法                infosDao.createTable(db, true);                infoTypeDao.createTable(db,true);                // 加入新字段                // db.execSQL("ALTER TABLE 'moments' ADD 'audio_path' TEXT;");                // TODO                break;        }    }}

       这里我们修改就是onUpgrade方法，在这里添加了创建新表的方法，在这里我多说一句，就是GreenDao在修改原表的时候，它会把原表删除，这样就会有一个问题，你原有的数据会丢，这样，我们就要在这里处理一下，把原表数据存入临时表中，然后再删除，最后把数据再导回来。

     三，生成建表，我们运行代码，来看一下生成后的效果

             这里有时候，我们在运行MyDaoGenerator.java代码，生成类的时候，会提示GKB代码无法运行，这是因为你在这个文件里写了中文，它不认，就算是你把这个文件转成了utf-8，也会报这个错，这时候，我们只能用记事本打开这个文件，然后覆盖保存，在保存时，编码选择 ANSI。就ok了，下面我们看一下，生成的文件列表

        

          

         这样，我们的新建的两个表的bean和操作dao文件都已经生成好了。我们就可以进行后面的，增，删，改，查工作了。

    四， 查看生成的bean文件

            我们来看一下这里生成的infos.java和infoType.java两个文件有什么特别之后。我们先来看一下infoType.java代码，处了代码被序列化外，我们发现里面多了一些方法，这里主要说一下与1：N关联有关的方法

           

public List<infos> getInfoes() {        if (infoes == null) {            if (daoSession == null) {                throw new DaoException("Entity is detached from DAO context");            }            infosDao targetDao = daoSession.getInfosDao();            List<infos> infoesNew = targetDao._queryInfoType_Infoes(id);            synchronized (this) {                if(infoes == null) {                    infoes = infoesNew;                }            }        }        return infoes;    }

这个方法，一看名字就知道，这是得到信息列表的，也就是说，我们在得到一个信息分类的同时，只要点一下这个方法，你就可以同时得到此分类下所有的信息，这对于信息量比较少的操作来说，是相当方便的方法。但是对于大数据量来说，就没有什么意义了。因为List这个分页处理不行，你可能会说，我直接修改它的代码不就完了吗，这个可行，可是GreenDao给出的说明是这个类，最好不要进行修改。

         它里面其它的方法，update,delete个人感觉没什么意义，我一直开始以为，它会产生联动的效果，就是删除这个分类的时候，子信息也会被删除，可是却没有发生。

         我们再来看一下infos.java里面的代码

       

public void setInfoType(infoType infoType) {        synchronized (this) {            this.infoType = infoType;            typeId = infoType == null ? null : infoType.getId();            infoType__resolvedKey = typeId;        }    }

        这个个人感觉相当使用，就是我们在得到条信息的时候，可以同时取得它的分类信息。这个在显示详细信息的时候相当有用啊。

       下面我写的一些代码片断，就是两个页，一个显示信息分类，点击信息分类，显示此分类下所有的信息。信息分类和信息的添加，依然采用，toolbar的menu，修改与删除功能，是长按listView。下面我把代码放出来：

      1,  DbService.java添加对两个新类的操作方法

       

package com.example.cg.greendaolearn.db;import android.content.Context;import android.text.TextUtils;import android.util.Log;import com.guangda.dao.DaoSession;import com.guangda.dao.UsersDao;import com.guangda.dao.infoTypeDao;import com.guangda.dao.infosDao;import java.util.List;import greendao.Users;import greendao.infoType;import greendao.infos;/** * 用户操作类 * Created by cg on 2015/12/29. */public class DbService {    private static final String TAG = DbService.class.getSimpleName();    private static DbService instance;    private static Context appContext;    private DaoSession mDaoSession;    private UsersDao userDao;    private infosDao infoDao;    private infoTypeDao typeDao;    private DbService() {    }    /**     * 采用单例模式     * @param context     上下文     * @return            dbservice     */    public static DbService getInstance(Context context) {        if (instance == null) {            instance = new DbService();            if (appContext == null){                appContext = context.getApplicationContext();            }            instance.mDaoSession = BaseApplication.getDaoSession(context);            instance.userDao = instance.mDaoSession.getUsersDao();            instance.infoDao = instance.mDaoSession.getInfosDao();            instance.typeDao = instance.mDaoSession.getInfoTypeDao();        }        return instance;    }    /**     * 根据用户id,取出用户信息     * @param id           用户id     * @return             用户信息     */    public Users loadNote(long id) {        if(!TextUtils.isEmpty(id + "")) {            return userDao.load(id);        }        return  null;    }    /**     * 取出所有数据     * @return      所有数据信息     */    public List<Users> loadAllNote(){        return userDao.loadAll();    }    /**     * 生成按id倒排序的列表     * @return      倒排数据     */    public List<Users> loadAllNoteByOrder()    {        return userDao.queryBuilder().orderDesc(UsersDao.Properties.Id).list();    }    /**     * 根据查询条件,返回数据列表     * @param where        条件     * @param params       参数     * @return             数据列表     */    public List<Users> queryNote(String where, String... params){        return userDao.queryRaw(where, params);    }    /**     * 根据用户信息,插件或修改信息     * @param user              用户信息     * @return 插件或修改的用户id     */    public long saveNote(Users user){        return userDao.insertOrReplace(user);    }    /**     * 批量插入或修改用户信息     * @param list      用户信息列表     */    public void saveNoteLists(final List<Users> list){        if(list == null || list.isEmpty()){            return;        }        userDao.getSession().runInTx(new Runnable() {            @Override            public void run() {                for(int i=0; i<list.size(); i++){                    Users user = list.get(i);                    userDao.insertOrReplace(user);                }            }        });    }    /**     * 删除所有数据     */    public void deleteAllNote(){        userDao.deleteAll();    }    /**     * 根据id,删除数据     * @param id      用户id     */    public void deleteNote(long id){        userDao.deleteByKey(id);        Log.i(TAG, "delete");    }    /**     * 根据用户类,删除信息     * @param user    用户信息类     */    public void deleteNote(Users user){        userDao.delete(user);    }    /**********************信息类别*********************************/    /**     * 添加或修改信息类别     * @param iType     信息类别     * @return          返回修改信息的id或是新增的信息id     */    public Long SaveInfoType(infoType iType)    {        return typeDao.insertOrReplace(iType);    }    /**     * 根据类别id,删除信息类别     * @param id      信息id     */    public void deleteInfoType(long id)    {        typeDao.load(id).delete();    }    /**     * 按id倒排序,来显示所信息类别     * @return      信息类别列表     */    public List<infoType> getAllInfoTypeList()    {        return  typeDao.queryBuilder().orderDesc(infoTypeDao.Properties.Id).list();    }    /**     * 根据类别id,取出类别信息     * @param id     * @return     */    public infoType getInfoType(long id)    {        return typeDao.load(id);    }    /**********************信息列表*********************************/    /**     * 根据信息类别id,取出其类别下所有的信息     * @param typeid         类别id     * @return               信息列表     */    public List<infos> getInfosByTypeId(long typeid)    {        return typeDao.load(typeid).getInfoes();    }    /**     * 添加或修改     * @param info    信息     * @return        添加或修改的id     */    public long saveInfo(infos info)    {        return infoDao.insertOrReplace(info);    }    /**     * 返回所有新闻,用于测试类别删除的同步性     * @return    返回所有新闻     */    public List<infos> getAllInfos()    {        return infoDao.loadAll();    }    /**     * 分页显示信息     * @param typeid          信息类别     * @param pageNum         当前页数     * @param pageSize        每页显示数     * @return                信息列表     */    public List<infos> getInfosBypageSize(long typeid,int pageNum,int pageSize)    {        return infoDao.queryBuilder().where(infosDao.Properties.TypeId.eq(typeid)).offset(pageNum-1).limit(pageSize).list();    }}

   2, 分类信息页面布局代码：

     activity_two_table.xml

    

<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"    xmlns:tools="http://schemas.android.com/tools" android:layout_width="match_parent"    android:layout_height="match_parent"    tools:context="com.example.cg.greendaolearn.twoTableActivity"    android:orientation="vertical"    android:background="@color/cornflowerblue">    <include        layout="@layout/toolbar" />    <ListView        android:id="@+id/lv_twoTable"        android:layout_width="match_parent"        android:layout_height="0dp"        android:layout_weight="1" /></LinearLayout>

   3, 分类信息页面中listView的item布局：

      activity_twotable_lv_item.xml

<?xml version="1.0" encoding="utf-8"?><LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"    android:layout_width="match_parent"    android:layout_height="match_parent">    <TextView        android:id="@+id/txt_twotable_item_typeName"        android:layout_width="match_parent"        android:layout_height="wrap_content"        android:padding="5dp"        android:textColor="@color/greenyellow"/></LinearLayout>

  4，信息列表的Adapter代码：

     twotable_type_adpter.java

    

package com.example.cg.greendaolearn.adpater;import android.content.Context;import android.view.LayoutInflater;import android.view.View;import android.view.ViewGroup;import android.widget.BaseAdapter;import android.widget.TextView;import com.example.cg.greendaolearn.R;import java.util.List;import greendao.infoType;/** * 两表间，1:n中主表信息列表的adapter * Created by cg on 2016/1/4. */public class twotable_type_adpter extends BaseAdapter {    private List<infoType> list_type;    private LayoutInflater inflater;    public twotable_type_adpter(Context context,List<infoType> list_type) {        this.inflater = LayoutInflater.from(context);        this.list_type = list_type;    }    @Override    public int getCount() {        return list_type.size();    }    @Override    public Object getItem(int position) {        return list_type.get(position);    }    @Override    public long getItemId(int position) {        return position;    }    @Override    public View getView(int position, View convertView, ViewGroup parent) {        twoTableType tType;        if(convertView==null)        {            tType = new twoTableType();            convertView = inflater.inflate(R.layout.activity_twotable_lv_item,null);            tType.typeName = (TextView)convertView.findViewById(R.id.txt_twotable_item_typeName);            convertView.setTag(tType);        }else        {            tType = (twoTableType)convertView.getTag();        }        tType.typeName.setText(list_type.get(position).getInfoName());        return convertView;    }    class twoTableType    {        TextView typeName;    }}

    5, 信息列表程序代码：

       twoTableActivity.java

      

package com.example.cg.greendaolearn;import android.content.Intent;import android.os.Bundle;import android.support.v7.app.AppCompatActivity;import android.support.v7.widget.Toolbar;import android.view.Menu;import android.view.MenuItem;import android.view.View;import android.widget.AdapterView;import android.widget.ListView;import android.widget.Toast;import com.example.cg.greendaolearn.adpater.twotable_type_adpter;import com.example.cg.greendaolearn.db.DbService;import java.util.ArrayList;import java.util.List;import greendao.infoType;public class twoTableActivity extends AppCompatActivity implements twoTableDialogTypeFragment.addInfoTypeOnClickListener,twoTableDialogTypeItemFragment.txtClickListener {    private Toolbar toolbar;                                                   //定义toolbar    private ListView lv_twoTable;    private List<infoType> list_type;    private twotable_type_adpter tAdapter;    private DbService db;    private twoTableDialogTypeFragment twoDialogType;    private twoTableDialogTypeItemFragment twoDialogTypeItem;    @Override    protected void onCreate(Bundle savedInstanceState) {        super.onCreate(savedInstanceState);        setContentView(R.layout.activity_two_table);        toolbar = (Toolbar)this.findViewById(R.id.toolbar);        toolbar.setTitle("多表操作");                     // 标题的文字需在setSupportActionBar之前，不然会无效        setSupportActionBar(toolbar);        db = DbService.getInstance(this);        initControls();        initData();    }    /**     * 初始化控件     */    private void initControls() {        lv_twoTable = (ListView)findViewById(R.id.lv_twoTable);        lv_twoTable.setOnItemClickListener(new AdapterView.OnItemClickListener() {            @Override            public void onItemClick(AdapterView<?> parent, View view, int position, long id) {                Intent dIntent = new Intent();                dIntent.setClass(twoTableActivity.this,twoTableDetailActivity.class);                dIntent.putExtra("typeId", list_type.get(position).getId());                dIntent.putExtra("typeName", list_type.get(position).getInfoName());                startActivity(dIntent);            }        });        /**         * 长按事件         */        lv_twoTable.setOnItemLongClickListener(new AdapterView.OnItemLongClickListener() {            @Override            public boolean onItemLongClick(AdapterView<?> parent, View view, int position, long id) {                twoDialogTypeItem = new twoTableDialogTypeItemFragment(list_type.get(position).getId(),position);                twoDialogTypeItem.show(getFragmentManager(),"item");                return true;            }        });    }    private void initData()    {        list_type = new ArrayList<>();        list_type = db.getAllInfoTypeList();        tAdapter = new twotable_type_adpter(this,list_type);        lv_twoTable.setAdapter(tAdapter);    }    @Override    public boolean onCreateOptionsMenu(Menu menu) {        // Inflate the menu; this adds items to the action bar if it is present.        getMenuInflater().inflate(R.menu.menu_two_table, menu);        return true;    }    @Override    public boolean onOptionsItemSelected(MenuItem item) {        // Handle action bar item clicks here. The action bar will        // automatically handle clicks on the Home/Up button, so long        // as you specify a parent activity in AndroidManifest.xml.        int id = item.getItemId();        //noinspection SimplifiableIfStatement        if (id == R.id.menu_twoTable_typeAdd) {            twoDialogType = new twoTableDialogTypeFragment(0,"",0);            twoDialogType.show(getFragmentManager(),"add");            return true;        }        return super.onOptionsItemSelected(item);    }    @Override    public void OnaddInfoTypeOnClickListener(String typeName, long typeId,int postion) {        infoType iType = new infoType();        iType.setInfoName(typeName);        if(typeId!=0)        {            iType.setId(typeId);        }        if(db.SaveInfoType(iType) < 1)        {            Toast.makeText(this, "数据修改失败！", Toast.LENGTH_SHORT).show();        }        if(typeId!=0)        {            list_type.remove(postion);        }        list_type.add(postion,iType);        tAdapter.notifyDataSetChanged();        twoDialogType.dismiss();    }    @Override    public void OntxtClickListener(int flag,long typeId,int postion) {        //0：删除 1：修改        if(flag==0)        {            db.deleteInfoType(typeId);            list_type.remove(postion);            tAdapter.notifyDataSetChanged();            Toast.makeText(this,"删除成功！",Toast.LENGTH_SHORT).show();        }else        {            twoDialogType = new twoTableDialogTypeFragment(list_type.get(postion).getId(),list_type.get(postion).getInfoName(),postion);            twoDialogType.show(getFragmentManager(),"edit");        }        twoDialogTypeItem.dismiss();    }}

      6，点击add按钮弹出框布局：

      fragment_onetable_dialog.xml

   

<?xml version="1.0" encoding="utf-8"?><LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"    android:layout_width="match_parent"    android:layout_height="match_parent">    <TextView        android:layout_width="0dp"        android:layout_height="wrap_content"        android:layout_weight="1"        android:text="新闻类别："        android:textColor="@color/black"        android:padding="5dp"/>    <EditText        android:id="@+id/edit_twotable_typeName"        android:layout_width="0dp"        android:layout_height="wrap_content"        android:layout_weight="2"        android:textColor="@color/black"/></LinearLayout>

   7，点击add按钮弹出框代码：

    twoTableDialogTypeFragment.java

  

package com.example.cg.greendaolearn;import android.app.AlertDialog;import android.app.Dialog;import android.app.DialogFragment;import android.content.DialogInterface;import android.os.Bundle;import android.view.LayoutInflater;import android.view.View;import android.widget.EditText;/** * 两表操作，1:n 新闻类别添加弹出框 * Created by cg on 2016/1/4. */public class twoTableDialogTypeFragment extends DialogFragment {    private String typeName;    private long typeId;    private int postion;    private String btnText;    public twoTableDialogTypeFragment(long typeId,String typeName,int postion) {        this.typeId = typeId;        this.typeName = typeName;        this.postion = postion;    }    public interface addInfoTypeOnClickListener    {        void OnaddInfoTypeOnClickListener(String typeName,long typeId,int postion);    }    private EditText edit_twotable_typeName;    @Override    public Dialog onCreateDialog(Bundle savedInstanceState) {        AlertDialog.Builder builder = new AlertDialog.Builder(getActivity());        // Get the layout inflater        LayoutInflater inflater = getActivity().getLayoutInflater();        View view = inflater.inflate(R.layout.fragment_twotable_typedialog, null);        edit_twotable_typeName = (EditText)view.findViewById(R.id.edit_twotable_typeName);        edit_twotable_typeName.setText(typeName);        if(typeId!=0)        {            btnText = "修改";        }else        {            btnText = "添加";        }        builder.setView(view)                .setTitle("添加新闻类别")                .setPositiveButton(btnText,                        new DialogInterface.OnClickListener() {                            @Override                            public void onClick(DialogInterface dialog, int id) {                                addInfoTypeOnClickListener addtype = (addInfoTypeOnClickListener)getActivity();                                addtype.OnaddInfoTypeOnClickListener(edit_twotable_typeName.getText().toString(),typeId,postion);                            }                        })                .setNegativeButton("取消",                        new DialogInterface.OnClickListener() {                            @Override                            public void onClick(DialogInterface dialog, int which) {                                edit_twotable_typeName.setText("");                            }                        });        return builder.show();    }}

 8,长按item弹出操作框布局：

   fragment_twotable_typeitemdialog.xml

  

<?xml version="1.0" encoding="utf-8"?><LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"    android:layout_width="match_parent"    android:layout_height="match_parent"    android:orientation="vertical">    <TextView        android:id="@+id/txt_twotable_typeitem_edit"        android:layout_width="match_parent"        android:layout_height="wrap_content"        android:text="编辑"        android:textSize="18sp"        android:gravity="center"        android:padding="15dp"/>    <View        android:layout_width="match_parent"        android:layout_height="1dp"        android:background="@color/gray"/>    <TextView        android:id="@+id/txt_twotable_typeitem_delete"        android:layout_width="match_parent"        android:layout_height="wrap_content"        android:text="删除"        android:textSize="18sp"        android:gravity="center"        android:padding="15dp"/></LinearLayout>

9，长按item弹出操作框代码：

    twoTableDialogTypeItemFragment.java

package com.example.cg.greendaolearn;import android.app.DialogFragment;import android.os.Bundle;import android.support.annotation.Nullable;import android.view.LayoutInflater;import android.view.View;import android.view.ViewGroup;import android.view.Window;import android.widget.TextView;/** * 两表操作 1:n，长按弹出修改与删除按钮 * Created by cg on 2016/1/4. */public class twoTableDialogTypeItemFragment extends DialogFragment {    public interface txtClickListener    {        void OntxtClickListener(int flag,long typeId,int postion);    }    private long typeId;    private int postion;    public twoTableDialogTypeItemFragment(long typeId,int postion) {        this.typeId = typeId;        this.postion = postion;    }    private TextView txt_twotable_typeitem_edit;    private TextView txt_twotable_typeitem_delete;    @Override    public void onViewCreated(View view, Bundle savedInstanceState) {        super.onViewCreated(view, savedInstanceState);        txt_twotable_typeitem_edit = (TextView)view.findViewById(R.id.txt_twotable_typeitem_edit);        txt_twotable_typeitem_edit.setOnClickListener(new View.OnClickListener() {            @Override            public void onClick(View v) {                txtClickListener txtClick = (txtClickListener)getActivity();                txtClick.OntxtClickListener(1,typeId,postion);            }        });        txt_twotable_typeitem_delete = (TextView)view.findViewById(R.id.txt_twotable_typeitem_delete);        txt_twotable_typeitem_delete.setOnClickListener(new View.OnClickListener() {            @Override            public void onClick(View v) {                txtClickListener txtClick = (txtClickListener)getActivity();                txtClick.OntxtClickListener(0,typeId,postion);            }        });    }    @Nullable    @Override    public View onCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState) {        getDialog().requestWindowFeature(Window.FEATURE_NO_TITLE);        View view = inflater.inflate(R.layout.fragment_twotable_typeitemdialog,container);        return view;    }}

 10,子页，信息列表布局：

    activity_two_table_detail.xml

<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"    xmlns:tools="http://schemas.android.com/tools" android:layout_width="match_parent"    android:layout_height="match_parent"    tools:context="com.example.cg.greendaolearn.twoTableDetailActivity"    android:orientation="vertical">    <include        layout="@layout/toolbar" />    <ListView        android:id="@+id/lv_twoTable_detail"        android:layout_width="match_parent"        android:layout_height="0dp"        android:layout_weight="1" /></LinearLayout>

11,子页，listview中item的布局：

 activty_twotable_detail_lv_item.xml

<?xml version="1.0" encoding="utf-8"?><LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"    android:layout_width="match_parent"    android:layout_height="match_parent"    android:orientation="vertical">    <TextView        android:id="@+id/txt_twotable_detail_item_title"        android:layout_width="match_parent"        android:layout_height="wrap_content"        android:padding="5dp"        android:textColor="@color/black"/>    <TextView        android:id="@+id/txt_twotable_detail_item_author"        android:layout_width="match_parent"        android:layout_height="wrap_content"        android:padding="5dp"        android:textColor="@color/black"        android:gravity="right"/>    <TextView        android:id="@+id/txt_twotable_detail_item_content"        android:layout_width="match_parent"        android:layout_height="wrap_content"        android:padding="5dp"        android:textColor="@color/black"/></LinearLayout>

12, 子页，Adatper代码：

   twotable_info_adpter.java

package com.example.cg.greendaolearn.adpater;import android.content.Context;import android.view.LayoutInflater;import android.view.View;import android.view.ViewGroup;import android.widget.BaseAdapter;import android.widget.TextView;import com.example.cg.greendaolearn.R;import java.util.List;import greendao.infos;/** * 两表操作 1:n  子表的列表Adapter * Created by cg on 2016/1/4. */public class twotable_info_adpter extends BaseAdapter {    private List<infos> list_info;    private LayoutInflater inflater;    public twotable_info_adpter(Context context,List<infos> list_info) {        this.inflater = LayoutInflater.from(context);        this.list_info = list_info;    }    @Override    public int getCount() {        return list_info.size();    }    @Override    public Object getItem(int position) {        return list_info.get(position);    }    @Override    public long getItemId(int position) {        return position;    }    @Override    public View getView(int position, View convertView, ViewGroup parent) {        infoDetail iDetail;        if(convertView==null)        {            iDetail = new infoDetail();            convertView = inflater.inflate(R.layout.activty_twotable_detail_lv_item,null);            iDetail.title = (TextView)convertView.findViewById(R.id.txt_twotable_detail_item_title);            iDetail.author = (TextView)convertView.findViewById(R.id.txt_twotable_detail_item_author);            iDetail.content = (TextView)convertView.findViewById(R.id.txt_twotable_detail_item_content);            convertView.setTag(iDetail);        }else        {            iDetail = (infoDetail)convertView.getTag();        }        iDetail.title.setText(list_info.get(position).getInfoTitle());        iDetail.author.setText(list_info.get(position).getInfoType().getInfoName() + "-" + list_info.get(position).getInfoAuthor());        iDetail.content.setText(list_info.get(position).getInfoContent());        return convertView;    }    class infoDetail    {        TextView title;        TextView author;        TextView content;    }}

13, 子页，代码：

    twoTableDetailActivity.java

   

package com.example.cg.greendaolearn;import android.os.Bundle;import android.support.v7.app.AppCompatActivity;import android.support.v7.widget.Toolbar;import android.view.Menu;import android.view.MenuItem;import android.widget.ListView;import com.example.cg.greendaolearn.adpater.twotable_info_adpter;import com.example.cg.greendaolearn.db.DbService;import java.util.ArrayList;import java.util.List;import greendao.infos;public class twoTableDetailActivity extends AppCompatActivity implements twoTableDetailDailogFragment.addDetailClickListener {    private Toolbar toolbar;                                                   //定义toolbar    private ListView lv_twoTable_detail;    private List<infos> list_info;    private twotable_info_adpter iAdapter;    public long typeId;    public String typeName;    private DbService db;    private twoTableDetailDailogFragment detail;    @Override    protected void onCreate(Bundle savedInstanceState) {        super.onCreate(savedInstanceState);        setContentView(R.layout.activity_two_table_detail);        typeId = getIntent().getLongExtra("typeId",0);        typeName = getIntent().getStringExtra("typeName");        toolbar = (Toolbar)this.findViewById(R.id.toolbar);        toolbar.setTitle(typeName);                     // 标题的文字需在setSupportActionBar之前，不然会无效        setSupportActionBar(toolbar);        db = DbService.getInstance(this);        initControls();        initData();    }    /**     * 初始化数据     */    private void initData() {        list_info = new ArrayList<>();        list_info = db.getInfosByTypeId(typeId);        iAdapter = new twotable_info_adpter(this,list_info);        lv_twoTable_detail.setAdapter(iAdapter);    }    /**     * 初始化控件     */    private void initControls() {        lv_twoTable_detail = (ListView)findViewById(R.id.lv_twoTable_detail);    }    @Override    public boolean onCreateOptionsMenu(Menu menu) {        // Inflate the menu; this adds items to the action bar if it is present.        getMenuInflater().inflate(R.menu.menu_two_table_detail, menu);        return true;    }    @Override    public boolean onOptionsItemSelected(MenuItem item) {        // Handle action bar item clicks here. The action bar will        // automatically handle clicks on the Home/Up button, so long        // as you specify a parent activity in AndroidManifest.xml.        int id = item.getItemId();        //noinspection SimplifiableIfStatement        if (id == R.id.menu_twoTable_detailAddAdd) {            detail = new twoTableDetailDailogFragment("","","",0,0);            detail.show(getFragmentManager(),"add");            return true;        }        return super.onOptionsItemSelected(item);    }    @Override    public void OnaddDetailClickListener(String title, String author, String content, long infoId, int postion) {        infos info = new infos();        info.setInfoAuthor(author);        info.setInfoTitle(title);        info.setInfoContent(content);        info.setTypeId(typeId);        db.saveInfo(info);        detail.dismiss();        list_info.add(0,info);        iAdapter.notifyDataSetChanged();    }}

14, 子页，添加信息布局：

     fragment_twotable_typedetaildialog.xml

    

<?xml version="1.0" encoding="utf-8"?><LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"    android:layout_width="match_parent"    android:layout_height="match_parent"    android:orientation="vertical">    <LinearLayout        android:layout_width="match_parent"        android:layout_height="wrap_content">        <TextView            android:layout_width="0dp"            android:layout_height="wrap_content"            android:layout_weight="1"            android:text="标题："            android:gravity="center"            android:padding="5dp"/>        <EditText            android:id="@+id/edit_detail_title"            android:layout_width="0dp"            android:layout_height="wrap_content"            android:layout_weight="2"            android:textColor="@color/black"/>    </LinearLayout>    <LinearLayout        android:layout_width="match_parent"        android:layout_height="wrap_content">        <TextView            android:layout_width="0dp"            android:layout_height="wrap_content"            android:layout_weight="1"            android:text="作者："            android:gravity="center"            android:padding="5dp"/>        <EditText            android:id="@+id/edit_detail_author"            android:layout_width="0dp"            android:layout_height="wrap_content"            android:layout_weight="2"            android:textColor="@color/black"/>    </LinearLayout>    <LinearLayout        android:layout_width="match_parent"        android:layout_height="wrap_content">        <TextView            android:layout_width="0dp"            android:layout_height="wrap_content"            android:layout_weight="1"            android:text="内容："            android:gravity="center"            android:padding="5dp"/>        <EditText            android:id="@+id/edit_detail_content"            android:layout_width="0dp"            android:layout_height="wrap_content"            android:layout_weight="2"            android:lines="3"            android:gravity="top|left"            android:textColor="@color/black"/>    </LinearLayout></LinearLayout>

15，子页，添加代码

      oneTableItemDialogFragment.java

      

package com.example.cg.greendaolearn;import android.app.DialogFragment;import android.os.Bundle;import android.support.annotation.Nullable;import android.view.LayoutInflater;import android.view.View;import android.view.ViewGroup;import android.view.Window;import android.widget.TextView;/** * Created by cg on 2015/12/30. */public class oneTableItemDialogFragment extends DialogFragment {    private long id;                                  //用户id    private int postion;                              //list中的编号    private TextView txt_onetable_update;    private TextView txt_onetable_delete;    public interface EditUserOnClickListener    {        //flag标识,0表示删除,1表示修改        void onEditUserOnClick(long id,int postion,int flag);    }    public oneTableItemDialogFragment(long id,int postion) {        this.id = id;        this.postion = postion;    }    @Nullable    @Override    public View onCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState) {        getDialog().requestWindowFeature(Window.FEATURE_NO_TITLE);        View view = inflater.inflate(R.layout.fragment_onetable_itemdialog,container);        return view;    }    @Override    public void onViewCreated(View view, Bundle savedInstanceState) {        super.onViewCreated(view, savedInstanceState);        txt_onetable_update = (TextView)view.findViewById(R.id.txt_onetable_update);        txt_onetable_update.setOnClickListener(new View.OnClickListener() {            @Override            public void onClick(View v) {                EditUserOnClickListener listener = (EditUserOnClickListener) getActivity();                listener.onEditUserOnClick(id,postion,1);            }        });        txt_onetable_delete = (TextView)view.findViewById(R.id.txt_onetable_delete);        txt_onetable_delete.setOnClickListener(new View.OnClickListener() {            @Override            public void onClick(View v) {                EditUserOnClickListener listener = (EditUserOnClickListener) getActivity();                listener.onEditUserOnClick(id,postion,0);            }        });    }}