我们在使用数据库的时候,大多数都会是多表联合操作,不会只有一个表的,下面我们就来说一下,多表的操作,这里先拿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了,下面我们看一下,生成的文件列表

        

    

green ios怎么使用 green如何使用_List

     

         这样,我们的新建的两个表的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);
            }
        });
    }
}