毕业设计说明书

陕西理工学院毕业设计

6.3词库管理模块的实现

词库管理模块是提供用户管理本地词库的功能模块，用户可以往本地词库中添加自定义词汇和释义，可以删除已经不需要的单词，图6.7是词库管理界面，图6.8是添加单词界面，图6.9是删除单词界面：

图6.7词库管理界面

词库管理界面代码如下：

public class BookFragment extends Fragment { private ListView booklistview; private List bookstalist; ArrayList> listItem = new ArrayList>(); private View BookLayout; @Override public View onCreateView(LayoutInflater inflater, ViewGroup container,

Bundle savedInstanceState) {

BookLayout = inflater.inflate(R.layout.fragment_book, container, false); Init(BookLayout); return BookLayout; } public void Init(View v) { booklistview = (ListView) v.findViewById(R.id.bookListview); Thread nt=new booksThread(); nt.start(); } Handler handler = new Handler() { @SuppressWarnings(\ public void handleMessage(Message msg) {

第 24 页 共 32 页

陕西理工学院毕业设计

} };

public class booksThread extends Thread { List bookstalist; public void run() { BookDao bk = new LocalBookDao(); bookstalist = bk.db_bookSta(); //Log.d(\ handler.obtainMessage(9, bookstalist).sendToTarget(); } }

public class ItemClick implements OnItemClickListener { @Override public void onItemClick(AdapterView parent, View view,int position, long id) { Intent intent=new Intent(); intent.putExtra(\ intent.setClass(booklistview.getContext(), BookwordActivity.class); startActivity(intent); } }

@Override

public boolean onContextItemSelected(MenuItem item) { return super.onContextItemSelected(item);

第 25 页 共 32 页

switch (msg.what) {

case 9: bookstalist = (List) msg.obj; for (int i = 0; i < bookstalist.size(); i++) { HashMap map = new HashMap(); map.put(\ map.put(\共有\

+ bookstalist.get(i).getBookwordnum() + \单词\

listItem.add(map); } // 生成适配器的Item和动态数组对应的元素 SimpleAdapter listItemAdapter = new SimpleAdapter( BookLayout.getContext(), listItem, R.layout.list_items, new String[] { \ R.id.notename, R.id.notewordnum }); //Log.d(\ booklistview.setAdapter(listItemAdapter); // 添加点击 booklistview.setOnItemClickListener(new ItemClick()); break; default: break; }

陕西理工学院毕业设计

}

}

图6.8添加单词到词库界面

添加单词到词库代码如下：

public void AddBookWord(String english,String chinese){ int maxid=0; String sql=\ Cursor cursor=database.rawQuery(sql,null); if(cursor.moveToNext()){ maxid=cursor.getInt(0); maxid=maxid+1;

String hql=\

database.execSQL(hql); } }

第 26 页 共 32 页

陕西理工学院毕业设计

图6.9从词库删除单词界面

删除词库中的单词代码如下： }

//删除词库中的单词

public void DelBookWord(int id ) { String sql = \ database.execSQL(sql); }

@Override

public void DelBookWord1(String english) { String sql=\ Cursor cursor=database.rawQuery(sql, null); int id=cursor.getInt(0); String hql=\ database.execSQL(hql); }

第 27 页 共 32 页