基于Android系统英语学习助手APP设计开发

三、设计成果简介

3.1作品特点

3.1.1技术指标

3.1.2性能特点

1. 单词背诵，对单词的中文和发音并进行校验，有相关的信息提示；
2. 兼容性比较好，Android系统都支持安装；
3. 该APP界面友好，用户操作起来无难度，易于掌握，便捷用户的使用体验；
4. 该APP兼容性强，模块功能明确，模块化程度高。

3.1.3创新之处

1. 兼容性强，占用空间较小，且操作简单明了，容易上手；
2. 维护方便、快速，页面功能设计明确。

3.2毕业设计总结

3.2.1归纳总结

首页感谢老师的培养和教导，此项目得与开发还是离不开老师的教导，在开发过程遇到不少问题也是在老师的帮助下完成，主要体现在sqlite数据库的应用，解决疑难问题，调式过程中经常卡克，另外需要感谢同学的鼓励和帮助，是他们一起学习生活中渡过一段时光，在枯燥乏味的日子，同学们的欢声笑语滋润了心田，是他们的一起前行中学习到了每个知识点，课外经常讨论不明白的问题，梳理了不少疑惑。

    此项目离使用还存在很多的不足，希望能在积累知识点的同时继续完善功能，尽量满足每一个功能，能够达到投入使用的状态，解决用户学习英语的需求，主要问题是云交互阶段和跨端的调式，也是我需要继续挖掘和学习的地方；

此项目虽然不是很完美，但是从中学习到了一个项目的整体设计和实现过程，把理论知识应用到实践中，提升实践能力。

3.2.2待解决的问题

1. 数据使用的时sqlite静态数据，并没有实时连接到远程数据库；
2. 目前词汇量并不是很大；
3. 页面中，打卡计算问题还是对词汇量的统计等；
4. 并未部署到云服务器中去。

3.2.3改进意见

1. 查询英文不仅仅是本地，需要远程查询；
2. 词汇量信息不够全；
3. 资讯列表没有维护，基本上都是假数据；
4. 将项目部署到Tomcat服务器中去，有条件可以购买一个云服务器进行部署。

3.3详细设计成果

3.3.1欢迎页面

欢迎页面如图3-1所示。

图3-1  欢迎页面

核心代码：

//欢迎页面

package com.yunus.remember.activity.begin;

import android.content.Intent;

import android.os.Build;

import android.os.Bundle;

import android.view.View;

import com.example.yunus.activity.BaseActivity;

import com.yunus.remember.R;

import com.yunus.remember.activity.chief.MainActivity;

import com.yunus.remember.entity.SevenDaysReview;

import com.yunus.remember.utils.StorageUtil;

import org.litepal.crud.DataSupport;

import java.util.ArrayList;

import java.util.List;

public class WelcomeActivity extends BaseActivity implements Runnable {

    @Override

    protected void onCreate(Bundle savedInstanceState) {

        super.onCreate(savedInstanceState);

        setContentView(R.layout.activity_welcome);

        new Thread(this).start();

    }

    @Override

    public void onWindowFocusChanged(boolean hasFocus) {

        super.onWindowFocusChanged(hasFocus);

        if (hasFocus && Build.VERSION.SDK_INT >= 19) {

            View decorView = getWindow().getDecorView();

            decorView.setSystemUiVisibility(

                    View.SYSTEM_UI_FLAG_LAYOUT_STABLE

                            | View.SYSTEM_UI_FLAG_LAYOUT_HIDE_NAVIGATION

                            | View.SYSTEM_UI_FLAG_LAYOUT_FULLSCREEN

                            | View.SYSTEM_UI_FLAG_HIDE_NAVIGATION

                            | View.SYSTEM_UI_FLAG_FULLSCREEN

                            | View.SYSTEM_UI_FLAG_IMMERSIVE_STICKY);

        }

    }

    @Override

    public void run() {

        try {

            Thread.sleep(3000);

            //todo 添加引导页

            String email = StorageUtil.getString(WelcomeActivity.this, StorageUtil.EMAIL, "qxf323 ");

            if (" ".equals(email)) {

                Intent intent = new Intent(WelcomeActivity.this, LoginActivity.class);

                startActivity(intent);

                finish();

            } else {

                Intent intent = new Intent(WelcomeActivity.this, MainActivity.class);

                startActivity(intent);

                finish();

            }

        } catch (Exception e) {

            e.printStackTrace();

        }

        DataSupport.deleteAll(SevenDaysReview.class);

            List<SevenDaysReview> reviews = new ArrayList<>();

            for (int i = 0; i < 7; i++) {

                SevenDaysReview review = new SevenDaysReview();

                review.setTheDate("2018.05." + (23 + i));

                review.setAllWordsCount(200 + i * 20);

                review.setAllHadCount(100 + i * 20);

                review.setStudiedTime((int) (20 + Math.random() * (60 - 20 + 1)));

                review.setTodayStudiedCount((int) (60 + Math.random() * (100 - 60 + 1)));

                reviews.add(review);

            }

            DataSupport.saveAll(reviews);

    }

}

3.3.2首页

英语助手APP首页如图3-2所示。

图3-2  APP首页

核心代码：

//首页

package com.yunus.remember.adapter;

import android.content.Intent;

import android.os.AsyncTask;

import android.os.Bundle;

import android.support.annotation.Nullable;

import android.support.v4.app.Fragment;

import android.support.v7.view.menu.MenuAdapter;

import android.support.v7.widget.GridLayoutManager;

import android.support.v7.widget.LinearLayoutManager;

import android.support.v7.widget.RecyclerView;

import android.view.LayoutInflater;

import android.view.View;

import android.view.ViewGroup;

import android.widget.Button;

import android.widget.ImageView;

import android.widget.LinearLayout;

import android.widget.ProgressBar;

import android.widget.TextView;

import com.example.yunus.utils.LogUtil;

import com.google.gson.Gson;

import com.google.gson.reflect.TypeToken;

import com.yunus.remember.R;

import com.yunus.remember.activity.home.DiariesActivity;

import com.yunus.remember.activity.home.TestActivity;

import com.yunus.remember.activity.home.WordsDetailActivity;

import com.yunus.remember.activity.mine.BooksActivity;

import com.yunus.remember.activity.mine.ProgressActivity;

import com.yunus.remember.bean.Menu;

import com.yunus.remember.entity.Book;

import com.yunus.remember.entity.SevenDaysReview;

import com.yunus.remember.entity.TodayWord;

import com.yunus.remember.entity.Word;

import com.yunus.remember.utils.HttpUtil;

import com.yunus.remember.utils.StorageUtil;

import org.litepal.crud.DataSupport;

import java.io.IOException;

import java.sql.Date;

import java.util.ArrayList;

import java.util.List;

import okhttp3.Call;

import okhttp3.Callback;

import okhttp3.FormBody;

import okhttp3.RequestBody;

import okhttp3.Response;

/**

 * Created by yun on 2018/3/29.

 */

public class HomeFragment extends Fragment {

    TextView doneDay;

    TextView newNum;

    TextView todayNum;

    TextView remainNum;

    TextView mineNum;

    TextView btMineNum;

    Button startStudy;

    LinearLayout numLayout;

    LinearLayout welcomeLayout;

    LinearLayout commonLayout;

    TextView addBook;

    ProgressBar progress;

    ImageView allDiary;

    WordsListAdapter menuAdapter;

    HomeListAdapter listAdapter;

    RecyclerView recyclerView,listRecyclerView;

    public HomeFragment() {

    }

    @Nullable

    @Override

    public View onCreateView(LayoutInflater inflater, @Nullable ViewGroup container,

                             @Nullable Bundle savedInstanceState) {

        View view = inflater.inflate(R.layout.main_pager_home_new, container, false);

        return view;

    }

    @Override

    public void onActivityCreated(@Nullable Bundle savedInstanceState) {

        super.onActivityCreated(savedInstanceState);

        doneDay = getActivity().findViewById(R.id.done_day);

        newNum = getActivity().findViewById(R.id.home_num_new);

        todayNum = getActivity().findViewById(R.id.home_num_today);

        remainNum = getActivity().findViewById(R.id.home_num_remain);

        mineNum = getActivity().findViewById(R.id.home_num_mine);

        btMineNum = getActivity().findViewById(R.id.home_bt_mine);

        startStudy = getActivity().findViewById(R.id.start_study);

        numLayout = getActivity().findViewById(R.id.home_num_layout);

        welcomeLayout = getActivity().findViewById(R.id.home_welcome_layout);

        commonLayout = getActivity().findViewById(R.id.home_common_layout);

        addBook = getActivity().findViewById(R.id.home_add_book);

        progress = getActivity().findViewById(R.id.home_progress);

        allDiary = getActivity().findViewById(R.id.home_calendar);

        recyclerView = getActivity().findViewById(R.id.menu_recycler_view);

        listRecyclerView = getActivity().findViewById(R.id.mlist_recycler_view);

        startStudy.setOnClickListener(new View.OnClickListener() {

            @Override

            public void onClick(View view) {

                Intent intent = new Intent(getActivity(), TestActivity.class);

                startActivity(intent);

            }

        });

        btMineNum.setOnClickListener(new View.OnClickListener() {

            @Override

            public void onClick(View view) {

                Intent intent = new Intent(getActivity(), ProgressActivity.class);

                startActivity(intent);

            }

        });

        addBook.setOnClickListener(new View.OnClickListener() {

            @Override

            public void onClick(View view) {

                Intent intent = new Intent(getActivity(), BooksActivity.class);

                getActivity().startActivity(intent);

            }

        });

        allDiary.setOnClickListener(new View.OnClickListener() {

            @Override

            public void onClick(View v) {

                Intent intent = new Intent(getActivity(), DiariesActivity.class);

                getActivity().startActivity(intent);

            }

        });

        menuAdapter = new WordsListAdapter();

        listAdapter = new HomeListAdapter();

        menuAdapter.setDataList(getContext(),getData());

        listAdapter.setDataList(getContext(),getData());

        recyclerView.setLayoutManager(new GridLayoutManager(getContext(),4));

        recyclerView.setAdapter(menuAdapter);

        listRecyclerView.setLayoutManager(new LinearLayoutManager(getContext()));

        listRecyclerView.setAdapter(listAdapter);

        menuAdapter.setOnItemClickListener(new WordsListAdapter.OnItemClickListener() {

            @Override

            public void onItemClick(int position) {

                if (position==7){

                    Intent intent = new Intent(getContext(), WordsDetailActivity.class);

                    getActivity().startActivity(intent);

                }else{

                    Intent intent = new Intent(getContext(), DiariesActivity.class);

                    getActivity().startActivity(intent);

                }

            }

            @Override

            public void onClickMoreOp(int position, View view, Menu ArrangeBean) {

            }

            @Override

            public void onClickConnectPrint(int position, Menu ArrangeBean) {

            }

        });

    }

    @Override

    public void onStart() {

        super.onStart();

        if (!StorageUtil.getString(getContext(), StorageUtil.TODAY_DATE, " ").equals(StorageUtil

                .getToday())) {

//

//            commonLayout.setVisibility(View.GONE);

//            numLayout.setVisibility(View.VISIBLE);

//            welcomeLayout.setVisibility(View.VISIBLE);

            startStudy.setText("准备中");

            startStudy.setEnabled(false);

            if (!(DataSupport.count(Book.class) == 0)) {

                new DownloadTask().execute();

            }

        }

        initText();

    }

    private void initText() {

        doneDay.setText(String.valueOf(StorageUtil.getInt(getContext(), StorageUtil.REGISTER_DAY,

                0)));

        newNum.setText(String.valueOf(StorageUtil.getInt(getContext(), StorageUtil

                .TODAY_REAL_NEW_NUM, 0)));

        todayNum.setText(String.valueOf(StorageUtil.getInt(getContext(), StorageUtil.TODAY_NUM,

                0)));

        remainNum.setText(String.valueOf(StorageUtil.getInt(getContext(), StorageUtil

                .TODAY_REMAIN_NUM, 0)));

        mineNum.setText(String.valueOf(StorageUtil.getInt(getContext(), StorageUtil.WORDS_NUM, 0)));

    }

    private Word getWord(int level) {

        if (DataSupport.where("level > 0").count(Word.class) <= 0) {

            return null;

        } else {

            if (DataSupport.where("level = ?", level + "").count(Word.class) == 0) {

                return getWord(level % 5 + 1);

            }

            int importance;

            switch ((int) (Math.random() * 10)) {

                case 0:

                case 1:

                case 2:

                case 3:

                case 4:

                    importance = 3;

                    break;

                case 5:

                case 6:

                case 7:

                    importance = 2;

                    break;

                case 8:

                case 9:

                    importance = 1;

                    break;

                default:

                    importance = 3;

            }

            if (DataSupport.where("level = ? and importance = ?", level + "", importance + "")

                    .count(Word.class) == 0) {

                return getWord(level);

            }

            Word word = DataSupport.where("level = ? and importance = ?", level + "", importance

                    + "").findFirst(Word

                    .class);

            DataSupport.delete(Word.class, word.getId());

            return word;

        }

    }

    class DownloadTask extends AsyncTask<Void, Integer, Boolean> {

        @Override

        protected void onPreExecute() {

            progress.setVisibility(View.VISIBLE);

        }

        @Override

        protected Boolean doInBackground(Void... voids) {

            //前期更新

            if (StorageUtil.getInt(getContext(), StorageUtil.TODAY_NUM, 0) == 0) {

                StorageUtil.updateInt(getContext(), StorageUtil.TODAY_NUM, 100);

            }

            if (StorageUtil.getInt(getContext(), StorageUtil.TODAY_NEW_NUM, 0) == 0) {

                StorageUtil.updateInt(getContext(), StorageUtil.TODAY_NEW_NUM, 20);

            }

            List<Word> allWord = DataSupport.where("level > 0").find(Word.class);

            for (Word word : allWord) {

                word.setImportance(word.getImportance() + 1);

            }

            DataSupport.saveAll(allWord);

            //计算要下载单词量

            int needStudyNum = StorageUtil.getInt(getContext(), StorageUtil.WORDS_NUM, 0) -

                    StorageUtil.getInt(getContext(), StorageUtil.WORDS_STUDIED_NUM, 0);

            if (needStudyNum < StorageUtil.getInt(getContext(), StorageUtil.TODAY_NUM, 100)) {

                StorageUtil.updateInt(getContext(), StorageUtil.TODAY_REAL_NEW_NUM, StorageUtil

                        .getInt(getContext(),

                                StorageUtil.TODAY_NUM, 0) - needStudyNum);

            } else {

                int wordNum = DataSupport.where("importance > 3").count(Word.class);

                if (wordNum >= StorageUtil.getInt(getContext(), StorageUtil.TODAY_NEW_NUM, 20)) {

                    StorageUtil.updateInt(getContext(), StorageUtil.TODAY_REAL_NEW_NUM, 0);

                } else {

                    StorageUtil.updateInt(getContext(), StorageUtil.TODAY_REAL_NEW_NUM,

                            StorageUtil.getInt(getContext

                                    (), StorageUtil.TODAY_NEW_NUM, 0) - wordNum);

                }

            }

            //更新上次登陆记录

            if (DataSupport.where("DATE(theDate) <  DATE('now', '-6 day', 'localtime')").count

                    (SevenDaysReview.class) > 0) {

                DataSupport.deleteAll(SevenDaysReview.class, "theDate < DATE(?)",

                        StorageUtil.getDate(new Date(System.currentTimeMillis()

                                - (long) (6 * 24 * 60 * 60 * 1000))));

            }

            SevenDaysReview lastReview = DataSupport.findLast(SevenDaysReview.class);

            if (lastReview != null &&

                    StorageUtil.getInt(getContext(), StorageUtil.STUDY_TIME, 0) != 0) {

                lastReview.setStudiedTime(StorageUtil.getInt(getContext(), StorageUtil

                        .STUDY_TIME, 0));

                lastReview.setTodayStudiedCount(StorageUtil.getInt(getContext(), StorageUtil

                        .TODAY_STUDY_NUM, 0));

                lastReview.save();

            }

            StorageUtil.updateInt(getContext(), StorageUtil.STUDY_TIME, 0);

            StorageUtil.updateInt(getContext(), StorageUtil.TODAY_STUDY_NUM, 0);

            //本地词库填充

            DataSupport.deleteAll(TodayWord.class);

            int needNum = StorageUtil.getInt(getContext(), StorageUtil.TODAY_NUM, 100) -

                    StorageUtil.getInt(getContext

                            (), StorageUtil.TODAY_REAL_NEW_NUM, 0);

            List<Word> words = DataSupport.where("importance > 3").limit(needNum).order

                    ("importance desc").find(Word.class);

            List<TodayWord> todayWords = new ArrayList<>();

            for (Word word : words) {

                todayWords.add(new TodayWord(word.getSpell(), word.getMean(), word.getPhonogram()

                        , word.getSentence()

                        , 1));

            }

            needNum = needNum - words.size();

            List<Word> saveWords = new ArrayList<>();

            while (needNum > 0) {

                int levelNeed = (needNum + 3) / 4;

                int level;

                for (level = 1; level < 5; level++) {

                    for (int i = 0; i < levelNeed; i++) {

                        saveWords.add(getWord(level));

                        needNum--;

                        if (needNum == 0) {

                            break;

                        }

                    }

                }

            }

            DataSupport.saveAll(saveWords);

            for (Word word : saveWords) {

                todayWords.add(new TodayWord(word.getSpell(), word.getMean(), word.getPhonogram()

                        , word.getSentence()

                        , 1));

            }

            DataSupport.saveAll(todayWords);

            //联网，下载生成今日单词

            RequestBody body = new FormBody.Builder()

                    .add("userId", "" + StorageUtil.getInt(getContext(), StorageUtil.USER_ID, 0))

                    .add("bookId", "" + DataSupport.where("state = -1").findFirst(Book.class)

                            .getId())

                    .add("needNum", "" + StorageUtil.getInt(getContext(), StorageUtil

                            .TODAY_REAL_NEW_NUM, 0))

                    .build();

            HttpUtil.todayWord(body, new Callback() {

                @Override

                public void onFailure(Call call, IOException e) {

                }

                @Override

                public void onResponse(Call call, Response response) throws IOException {

                    String result = response.body().string();

                    LogUtil.d("word", result);

                    Gson gson = new Gson();

                    List<Word> netWords = gson.fromJson(result, new TypeToken<List<Word>>() {

                    }.getType());

                    for (Word word : netWords) {

                        word.setLevel(5);

                        word.setImportance(0);

                        new TodayWord(word.getSpell(), word.getMean(), word.getPhonogram(),

                                word.getSentence(), 1).save();

                    }

                    DataSupport.saveAll(netWords);

                    StorageUtil.updateInt(getContext(), StorageUtil.WORDS_NUM,

                            DataSupport.count(Word.class));

                    //更新今天记录

                    int studiedNum = DataSupport.where("level < 1").count(Word.class);

                    int allNum = DataSupport.count(Word.class);

                    SevenDaysReview newReview = new SevenDaysReview(StorageUtil.getDate(new Date

                            (System.currentTimeMillis())), studiedNum, allNum);

                    newReview.save();

                }

            });

            StorageUtil.updateString(getContext(), StorageUtil.TODAY_DATE, StorageUtil.getToday());

            StorageUtil.updateInt(getContext(), StorageUtil.STUDY_TIME, 0);

            StorageUtil.updateInt(getContext(), StorageUtil.TODAY_REMAIN_NUM,

                    StorageUtil.getInt(getContext(), StorageUtil.TODAY_NUM, 0));

            return true;

        }

        @Override

        protected void onPostExecute(Boolean aBoolean) {

            progress.setVisibility(View.GONE);

            commonLayout.setVisibility(View.VISIBLE);

            startStudy.setText("学习");

            startStudy.setEnabled(true);

            numLayout.setVisibility(View.VISIBLE);

            welcomeLayout.setVisibility(View.GONE);

            initText();

        }

    }

    private List<Menu> getData(){

        List<Menu> list = new ArrayList<>();

        for (int i = 1; i < 9; i++) {

            Menu menu = new Menu();

            if (i==1){

                menu.setName("外刊阅读");

            }

            else if (i==2){

                menu.setName("高中听力");

            }

            else if (i==3){

                menu.setName("高中写作");

            }

            else if (i==4){

                menu.setName("更多");

            }

            else if (i==5){

                menu.setName("情景对话");

            }

            else if (i==6){

                menu.setName("语法讲练");

            }

            else if (i==7){

                menu.setName("每日一句");

            }

            else if (i==8){

                menu.setName("背单词");

            }

            list.add(menu);

        }

        return list;

    }

}

3.3.3背单词详情

APP背单词详情页面如图3-3所示。

图3-3  背单词详情

核心代码：

package com.yunus.remember.activity.home;

import android.content.Intent;

import android.os.Bundle;

import android.support.v7.widget.Toolbar;

import android.view.Menu;

import android.view.MenuItem;

import android.view.View;

import android.widget.Button;

import android.widget.ImageButton;

import android.widget.TextView;

import android.widget.Toast;

import com.example.yunus.activity.BaseActivity;

import com.yunus.remember.R;

import com.yunus.remember.activity.chief.SearchActivity;

import com.yunus.remember.bean.NeologismWords;

import com.yunus.remember.bean.Words;

import com.yunus.remember.dao.NeologismListDao;

import com.yunus.remember.dao.WordsListDao;

import com.yunus.remember.entity.TodayWord;

import com.yunus.remember.entity.Word;

import com.yunus.remember.utils.StorageUtil;

import java.util.List;

public class WordsDetailActivity extends BaseActivity {

    TextView words;

    TextView pero;

    TextView chains;

    Button next;

    Button wrong;

    TodayWord todayWord;

    long beginTime;

    List<Words> list;

    int count = 0;

    @Override

    protected void onCreate(Bundle savedInstanceState) {

        super.onCreate(savedInstanceState);

        setContentView(R.layout.activity_detail);

        WordsListDao wordsListDao = new WordsListDao();

        list = wordsListDao.getContactAll();

        todayWord = getIntent().getParcelableExtra("today_word");

        final Toolbar toolbar = findViewById(R.id.detail_toolBar);

        toolbar.setTitle("背单词");

        setSupportActionBar(toolbar);

        toolbar.setNavigationOnClickListener(new View.OnClickListener() {

            @Override

            public void onClick(View view) {

                finish();

            }

        });

        words = findViewById(R.id.words);

        pero = findViewById(R.id.pero);

        next = findViewById(R.id.detail_next);

        wrong = findViewById(R.id.detail_wrong);

        chains = findViewById(R.id.chains);

        final NeologismListDao neologismListDao = new NeologismListDao();

        if (list != null && list.size()>0){

            words.setText(list.get(count).getContent());

            pero.setText(list.get(count).getPron());

        }

        toolbar.setNavigationOnClickListener(new View.OnClickListener() {

            @Override

            public void onClick(View view) {

                finish();

            }

        });

        next.setOnClickListener(new View.OnClickListener() {

            @Override

            public void onClick(View view) {

                count ++;

                chains.setVisibility(View.GONE);

                words.setText(list.get(count).getContent());

                pero.setText(list.get(count).getPron());

                chains.setText(list.get(count).getDefinition());

            }

        });

        wrong.setOnClickListener(new View.OnClickListener() {

            @Override

            public void onClick(View view) {

                chains.setVisibility(View.VISIBLE);

                NeologismWords neologismWords = new NeologismWords();

                neologismWords.setId(System.currentTimeMillis()+"");

                neologismWords.setContent(list.get(count).getContent());

                neologismWords.setPron(list.get(count).getPron());

                neologismWords.setDefinition(list.get(count).getDefinition());

                neologismListDao.addOrUpdate(neologismWords);

                chains.setText(list.get(count).getDefinition());

                Toast.makeText(WordsDetailActivity.this,"已加入生词本",Toast.LENGTH_LONG).show();

            }

        });

    }

    @Override

    protected void onStart() {

        super.onStart();

        beginTime = System.currentTimeMillis();

    }

    @Override

    protected void onStop() {

        super.onStop();

    }

}

3.3.4单词管理

  单词管理主要是对单词的编辑，可以修改和删除； 如下图所示

public class RankingFragment extends Fragment implements View.OnClickListener {

    Button allWord;

    Button allTime;

    Button friendWord;

    Button friendTime;

    RecyclerView recyclerView;

    NeologismListAdapter neologismListAdapter ;

    NeologismListDao neologismListDao;

    List<NeologismWords> list ;

    public RankingFragment() {

    }

    @Nullable

    @Override

    public View onCreateView(LayoutInflater inflater, @Nullable ViewGroup container, @Nullable

            Bundle savedInstanceState) {

        View view = inflater.inflate(R.layout.main_pager_ranking, container, false);

        return view;

    }

    @Override

    public void onActivityCreated(@Nullable Bundle savedInstanceState) {

        super.onActivityCreated(savedInstanceState);

        allWord = getActivity().findViewById(R.id.ranking_all_word);

        allWord.setOnClickListener(this);

        allTime = getActivity().findViewById(R.id.ranking_all_time);

        allTime.setOnClickListener(this);

        friendWord = getActivity().findViewById(R.id.ranking_friend_word);

        friendWord.setOnClickListener(this);

        friendTime = getActivity().findViewById(R.id.ranking_friend_time);

        recyclerView = getActivity().findViewById(R.id.neoglog);

        friendTime.setOnClickListener(this);

        final NeologismListDao neologismListDao = new NeologismListDao();

        final List<NeologismWords> list = neologismListDao.getContactAll();

        neologismListAdapter = new NeologismListAdapter();

        recyclerView.setAdapter(neologismListAdapter);

        neologismListAdapter.setDataList(getActivity(),list);

        recyclerView.setLayoutManager(new LinearLayoutManager(getActivity()));

        neologismListAdapter.setOnItemClickListener(new NeologismListAdapter.OnItemClickListener() {

            @Override

            public void onItemClick(int position) {

                Toast.makeText(getContext(),"删除",Toast.LENGTH_LONG).show();

                neologismListDao.delete(list.get(position));

                list.remove(position);

                neologismListAdapter.setDataList(getActivity(),list);

            }

            @Override

            public void onClickMoreOp(int position, View view, NeologismWords ArrangeBean) {

            }

            @Override

            public void onClickConnectPrint(int position, NeologismWords ArrangeBean) {

            }

        });

    }

    @Override

    public void onClick(View v) {

        Intent intent = new Intent(getActivity(), RankingActivity.class);

        switch (v.getId()) {

            case R.id.ranking_all_word:

                intent.putExtra("mode", 0);

                break;

            case R.id.ranking_all_time:

                intent.putExtra("mode", 1);

                break;

            case R.id.ranking_friend_word:

                intent.putExtra("mode", 2);

                break;

            case R.id.ranking_friend_time:

                intent.putExtra("mode", 3);

                break;

            default:

                break;

        }

        startActivity(intent);

    }

    @Override

    public void onResume() {

        super.onResume();

        neologismListDao = new NeologismListDao();

        list = neologismListDao.getContactAll();

        neologismListAdapter = new NeologismListAdapter();

        recyclerView.setAdapter(neologismListAdapter);

        neologismListAdapter.setDataList(getActivity(),list);

        recyclerView.setLayoutManager(new LinearLayoutManager(getActivity()));

        neologismListAdapter.setOnItemClickListener(new NeologismListAdapter.OnItemClickListener() {

            @Override

            public void onItemClick(int position) {

                showNormalDialog(position);

            }

            @Override

            public void onClickMoreOp(int position, View view, NeologismWords ArrangeBean) {

            }

            @Override

            public void onClickConnectPrint(int position, NeologismWords ArrangeBean) {

            }

        });

    }

    private void showNormalDialog(final int position){

        /* @setIcon 设置对话框图标

         * @setTitle 设置对话框标题

         * @setMessage 设置对话框消息提示

         * setXXX方法返回Dialog对象，因此可以链式设置属性

         */

        final AlertDialog.Builder normalDialog =  new AlertDialog.Builder(getActivity());

        normalDialog.setTitle("删除");

        normalDialog.setMessage("是否需要删除?"  );

        normalDialog.setPositiveButton("确定",  new DialogInterface.OnClickListener() {

            @Override

            public void onClick(DialogInterface dialog, int which) {

                //...To-do

                Toast.makeText(getContext(),"删除成功",Toast.LENGTH_LONG).show();

                neologismListDao.delete(list.get(position));

                list.remove(position);

                neologismListAdapter.setDataList(getActivity(),list);

            }

        });

        normalDialog.setNegativeButton("取消",  new DialogInterface.OnClickListener() {

            @Override

            public void onClick(DialogInterface dialog, int which) {

                //...To-do

                dialog.dismiss();

            }

        });

        // 显示

        normalDialog.show();

    }

}

四、致谢

首页感谢老师的培养和教导，此项目得与开发还是离不开老师的教导，在开发过程遇到不少问题也是在老师的帮助下完成，主要体现在sqlite数据库的应用，解决疑难问题，调式过程中经常卡克，另外需要感谢同学的鼓励和帮助，是他们一起学习生活中渡过一段时光，在枯燥乏味的日子，同学们的欢声笑语滋润了心田，是他们的一起前行中学习到了每个知识点，课外经常讨论不明白的问题，梳理了不少疑惑。

    此项目离使用还存在很多的不足，希望能在积累知识点的同时继续完善功能，尽量满足每一个功能，能够达到投入使用的状态，解决校园的需求，主要问题是云交互阶段和跨端的调式，也是我需要继续挖掘和学习的地方；

生就像一面镜子，你用什么样的态度去面对她，她就会用同样的结果反馈给你。面对论文，如果你用认真的态度面对它，你所获得的将会是满意的成绩和丰收。论文能够顺利完成，首先需要感谢的就是我的论文指导老师对我的细心指导，同时他也用行动告诉我该怎样去面对社会、面对人生。同时感谢其他给予我帮助的老师和同学。

五、参考文献

[1]李刚彪.数据库加密技术的研讨与完成[D].太原理工大学，2010:18-78.

[2]杨云君.Android的设计与完成[M].北京：机械工业出版社，2013:5-65.

[3]秦明甫.基于混沌实际的数字图像加密研讨[D].重庆大学，2009:34-48.

[4]柯除夕.Android内核分析[M].北京：电子工业出版社，2011:67-98.

[5]李刚.疯狂Android讲义[M].北京：电子工业出版社，2013:12-87.

[6]吴明航.DES和RSA混合加密算法的研讨[D].哈尔滨工业大学，2013:13-56.

[7]顶峰.Linux内存管理的设计与完成[D].沈阳工业大学，2007:45-89

[8]陈最.基于Android平台挪动终端通明加密零碎的研讨与完成[D].重庆理工大学，2012:108-150.

[9]佟晓筠，王翥，杜宇，岳银亮.基于软件平安混合加密技术的研讨[J].计算机工程，2004,23(33)：98-100.

[10]程庭，张明慧，石公营.一种基于DES和RSA算法的数据加密方案及完成[J].河南教育学院学报(自然迷信版)，2003,22(3)：69-71.

[11]XinChen,SongweiMa,BingliGuo,YanWang,JuhaoLi,ZhangyuanChen,YongqiHe.Anovelfragmentation-awarespectrumallocationalgorithminflexiblebandwidthopticalnetworks[J].OpticalSwitchingandNetworking,2014(12)：6-22.

[12]廉士国，李忠新，王执铨.两种基于局部加密的图像和视频加密方案[J].计算机工程，2004,4(11)：11-34.

[13]Zhu,ZhiwuLiu,XuLi,Xiangyu.RatchetingBehaviorsoftheCarbonFiberReinforcedPEEKComposites:ExperimentalStudyandNumericalSimulation[J].Polymers&PolymerComposite,2014,(221)