Android中结合OrmLite for android组件对SQLite的CRUD(增删改查)操作实例（三）

最新推荐文章于 2025-12-30 10:16:51 发布

转载最新推荐文章于 2025-12-30 10:16:51 发布 · 1.6k 阅读

文章标签：

#android #sqlite #delete #listview #menu #action

Android 数据库专栏收录该内容

3 篇文章

订阅专栏

StudentListActivity.java源码：

package com.andyidea.ormsqlite;
import java.sql.SQLException;
import java.util.List;
import Android.app.AlertDialog;
import Android.content.Context;
import Android.content.DialogInterface;
import Android.content.Intent;
import Android.os.Bundle;
import Android.view.ContextMenu;
import Android.view.ContextMenu.ContextMenuInfo;
import Android.view.LayoutInflater;
import Android.view.Menu;
import Android.view.MenuItem;
import Android.view.View;
import Android.view.ViewGroup;
import Android.widget.AdapterView.AdapterContextMenuInfo;
import Android.widget.BaseAdapter;
import Android.widget.ListView;
import Android.widget.TextView;
import com.andyidea.bean.Student;
import com.andyidea.db.DatabaseHelper;
import com.j256.ormlite.Android.apptools.OrmLiteBaseActivity;
import com.j256.ormlite.dao.Dao;
public class StudentListActivity extends OrmLiteBaseActivity<DatabaseHelper> {
private Context mContext;
private ListView lvStudents;
private Dao<Student,Integer> stuDao;
private List<Student> students;
private StudentsAdapter adapter;
private Student mStudent;
private final int MENU_VIEW = Menu.FIRST;
private final int MENU_EDIT = Menu.FIRST+1;
private final int MENU_DELETE = Menu.FIRST+2;
private int position;
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.students);
mContext = getApplicationContext();
lvStudents = (ListView)findViewById(R.id.stulist);
registerForContextMenu(lvStudents); //注册上下文菜单
queryListViewItem();
adapter = new StudentsAdapter(students);
lvStudents.setAdapter(adapter);
}
@Override
public void onCreateContextMenu(ContextMenu menu, View v,
ContextMenuInfo menuInfo) {
if(v == lvStudents)
position = ((AdapterContextMenuInfo)menuInfo).position;
menu.add(0,MENU_VIEW, 0, "查看");
menu.add(0,MENU_EDIT, 0, "编辑");
menu.add(0,MENU_DELETE,0,"删除");
super.onCreateContextMenu(menu, v, menuInfo);
}
@Override
public boolean onContextItemSelected(MenuItem item) {
switch (item.getItemId()) {
case MENU_VIEW:
viewListViewItem(position);
break;
case MENU_EDIT:
editListViewItem(position);
break;
case MENU_DELETE:
deleteListViewItem(position);
break;
default:
break;
}
return super.onContextItemSelected(item);
}
/**
* 查询记录项
*/
private void queryListViewItem(){
try {
stuDao = getHelper().getStudentDao();
//查询所有的记录项
students = stuDao.queryForAll();
} catch (SQLException e) {
e.printStackTrace();
}
}
/**
* 查看记录项
* @param position
*/
private void viewListViewItem(int position){
mStudent = students.get(position);
Intent intent = new Intent();
intent.setClass(mContext, MainActivity.class);
intent.putExtra("action", "viewone");
intent.putExtra("entity", mStudent);
startActivity(intent);
}
/**
* 编辑记录项
*/
private void editListViewItem(int position){
mStudent = students.get(position);
Intent intent = new Intent();
intent.setClass(mContext, MainActivity.class);
intent.putExtra("action", "edit");
intent.putExtra("entity", mStudent);
startActivity(intent);
}
/**
* 删除记录项
* @param position
*/
private void deleteListViewItem(int position){
final int pos = position;
AlertDialog.Builder builder2 = new AlertDialog.Builder(StudentListActivity.this);
builder2.setIcon(Android.R.drawable.ic_dialog_alert)
.setTitle("警告")
.setMessage("确定要删除该记录");
builder2.setPositiveButton("确定", new DialogInterface.OnClickListener() {
@Override
public void onClick(DialogInterface dialog, int which) {
Student mDelStudent = (Student)lvStudents.getAdapter().getItem(pos);
try {
stuDao.delete(mDelStudent); //删除记录
queryListViewItem();
} catch (SQLException e) {
e.printStackTrace();
}
}
});
builder2.setNegativeButton("取消", new DialogInterface.OnClickListener() {
@Override
public void onClick(DialogInterface dialog, int which) {
dialog.dismiss();
}
});
builder2.show();
}
class StudentsAdapter extends BaseAdapter{
private List<Student> listStu;
public StudentsAdapter(List<Student> students){
super();
this.listStu = students;
}
@Override
public int getCount() {
return listStu.size();
}
@Override
public Student getItem(int position) {
return listStu.get(position);
}
@Override
public long getItemId(int position) {
return position;
}
@Override
public View getView(int position, View convertView, ViewGroup parent) {
ViewHolder holder;
if(convertView == null){
LayoutInflater mInflater = (LayoutInflater) mContext
.getSystemService(Context.LAYOUT_INFLATER_SERVICE);
convertView = mInflater.inflate(R.layout.studentitem, null);
holder = new ViewHolder();
holder.tvNO = (TextView)convertView.findViewById(R.id.itemno);
holder.tvName = (TextView)convertView.findViewById(R.id.itemname);
holder.tvScore = (TextView)convertView.findViewById(R.id.itemscore);
convertView.setTag(holder);
}else{
holder = (ViewHolder)convertView.getTag();
}
Student objStu = listStu.get(position);
holder.tvNO.setText(objStu.getStuNO());
holder.tvName.setText(objStu.getName());
holder.tvScore.setText(String.valueOf(objStu.getScore()));
return convertView;
}
}
static class ViewHolder{
TextView tvNO;
TextView tvName;
TextView tvScore;
}
}