Android中结合OrmLite for android组件对SQLite的CRUD(增删改查)操作实例Android中结合OrmLite for android组件对SQLite的CRUD(增删改查)操作实例
本博客文章中曾经提到过Ormlite的第三方组件包，Ormlite 是一种ORM工具，并且是一种轻量级别的工具。我们可以使用它来对Android中内嵌的sqlite数据库进行相关的操作。Android 的应用程序应使用 Ormlite for android 版本来进行相关的开发。Ormlite是对android提供的sqlite部分的API进行了封装。提供了更加方便的接口来供使用。
本文以一个学生的信息实例程序来展示如何使用ormlite for android的第三方组件来开发Sqlite的C[增加]，R[查询]，U[更新]，D[查询]应用程序，以便更方便的对sqlite数据库的操作。我们先看下程序的结构图：
jfinal增删改查【1】.程序结构图如下：
其中包com.andyidea.bean下Student.java为实体类，包com.andyidea.db下DatabaseHelper.java为数据库辅助类，包sqlite下的MainActivity.java和StudentListActivity.java是界面信息类。同时我们别忘了在根目录下创建一个lib的文件夹，把第三方组件包ormlite-android-4.31.jar ，ormlite-core-4.31.jar，ormlite-jdbc-4.31.jar放到lib文件夹下，然后在项目中引用这三个包就OK了。
【2】布局文件源码如下：
<?xml version="1.0" encoding="utf-8"?><LinearLayout xmlns:android="schemas.android/apk/res/android" android:orientation="vertical" android:layout_width="fill_parent" android:layout_height="fill_parent" android:padding="5dip"> <TextView android:layout_width="fill_parent" android:layout_height="wrap_content" android:gravity="center" android:text="ORMLite-AddPage"/> <LinearLayout android:layout_width="fill_parent" android:layout_height="wrap_content" android:orientation="horizontal" android:padding="1dip" android:gravity="center_vertical"> <TextView android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="学号: "/> <EditText android:id="@+id/stuno" android:layout_width="fill_parent" android:layout_height="wrap_content"/> </LinearLayout> <LinearLayout android:layout_width="fill_parent" android:layout_height="wrap_content" android:orientation="horizontal" android:padding="1dip" android:gravity="center_vertical"> <TextView android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="姓名: "/> <EditText android:id="@+id/name" android:layout_width="fill_parent" android:layout_height="wrap_content"/> </LinearLayout>
<LinearLayout android:layout_width="fill_parent" android:layout_height="wrap_content" android:orientation="horizontal" android:padding="1dip" android:gravity="center_vertical"> <Tex
tView android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="年龄: "/> <EditText android:id="@+id/age" android:layout_width="fill_parent" android:layout_height="wrap_content"/> </LinearLayout> <LinearLayout android:layout_width="fill_parent" android:layout_height="wrap_content" android:orientation="horizontal" android:padding="1dip" android:gravity="center_vertical"> <TextView android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="性别: "/> <EditText android:id="@+id/sex" android:layout_width="fill_parent" android:layout_height="wrap_content"/> </LinearLayout> <LinearLayout android:layout_width="fill_parent" android:layout_height="wrap_content" android:orientation="horizontal" android:padding="1dip" android:gravity="center_vertical"> <TextView android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="分数: "/> <EditText android:id="@+id/score" android:layout_width="fill_parent" android:layout_height="wrap_content"/> </LinearLayout> <LinearLayout android:layout_width="fill_parent" android:layout_height="wrap_content" androi
d:orientation="horizontal" android:padding="1dip" android:gravity="center_vertical"> <TextView android:layout_width="wrap_content" android:layout_height="wrap_content" android:text="地址: "/> <EditText android:id="@+id/address" android:layout_width="fill_parent" android:layout_height="wrap_content"/> </LinearLayout> </LinearLayout&l源码：
<?xml version="1.0" encoding="utf-8"?><LinearLayout xmlns:android="schemas.android/apk/res/android" android:orientation="vertical" android:layout_width="fill_parent" android:layout_height="fill_parent"> <TextView android:layout_width="fill_parent" android:layout_height="wrap_content" android:gravity="center" android:text="ORMLite-Students"/> <ListView android:id="@+id/stulist" android:layout_width="fill_parent" android:layout_height="fill_parent"/></LinearLayout&l源码：
<?xml version="1.0" encoding="utf-8"?><LinearLayout xmlns:android="schemas.android/apk/res/android" android:orientation="horizontal" android:layout_width="fill_parent" android:layout_height="fill_parent"> <TextView android:id="@+id/itemno" android:layout_width="fill_parent" android:layout_height="wrap_conten
t" android:layout_weight="1" android:text="学号" android:gravity="center"/> <TextView android:id="@+id/itemname" android:layout_width="fill_parent" android:layout_height="wrap_content" android:layout_weight="1" android:text="姓名" android:gravity="center"/> <TextView
android:id="@+id/itemscore" android:layout_width="fill_parent" android:layout_height="wrap_content" android:layout_weight="1" android:text="分数" android:gravity="center"/></LinearLayout>【3】包com.andyidea.bean下Student.java源码：
package com.andyidea.bean;import java.io.Serializable;import lite.field.DatabaseField;public class Student implements Serializable { private static final long serialVersionUID = -5683263669918171030L; @DatabaseField(id=true) private String stuNO; @DatabaseField private String name; @DatabaseField private int age; @DatabaseField private String sex; @DatabaseField private double score; @DatabaseField private String address; public String getStuNO() { return stuNO; } public void setStuNO(String stuNO) { this.stuNO = stuNO; } public String getName() { return name; } public void setName(String name) { this.name = name; } public int getAge() { return age; } public void setAge(int age) { this.age = age; } public String getSex() { return sex; } public void setSex(String sex) { this.sex = sex; } public double getSco
re() { return score; } public void setScore(double score) { this.score = score; } public String getAddress() { return address; } public void setAddress(String address) { this.address = address; } }【4】包com.andyidea.db下DatabaseHelper.java源码：
package com.andyidea.db;import java.sql.SQLException;t.Context;import android.database.sqlite.SQLiteDatabase;import android.util.Log;import com.andyidea.bean.Student;import lite.android.apptools.OrmLiteSqliteOpenHelper;import lite.dao.Dao;import lite.support.ConnectionSource;import lite.table.TableUtils;public class DatabaseHelper extends OrmLiteSqliteOpenHelper { private static final String DATABASE_NAME = "ormlite.db"; private static final int DATABASE_VERSION = 1; private Dao<Student,Integer> stuDao = null; public DatabaseHelper(Context context){ super(context, DATABASE_NAME, null, DATABASE_VERSION); } /** * 创建SQLite数据库 */ @Override public void onCreate(SQLiteDatabase sqliteDatabase, ConnectionSource connectionSource) { try { ateTable(connectionSource, Student.class); } catch (SQLException e) { Log.e(Name(), "Unable to create datbases", e); } } /** * 更新SQLite数据库 */ @Override public void onUpgrade( SQLiteDatabase sqliteDatabase, ConnectionSource connect
ionSource, int oldVer, int newVer) { try { TableUtils.dropTable(connectionSource, Student.class, true); onCreate(sqliteDatabase, connectionSource); } catch (SQLException e) { Log.e(Name(), "Unable to upgrade database from version " + oldVer + " to new " + newVer, e); } } public Dao<Student,Integer> getStudentDao() throws SQLException{ if(stuDao == null){ stuDao = getDao(Student.class); } return stuDao; }}【5】包sqlite下源码：
MainActiv
ity.java源码：
package sqlite;import java.sql.SQLException;import com.andyidea.bean.Student;import com.andyidea.db.DatabaseHelper;import lite.android.apptools.OrmLiteBaseActivity;import lite.dao.Dao;t.Intent;import android.os.Bundle;import android.view.Menu;import android.view.MenuItem;import android.widget.EditText;public class MainActivity extends OrmLiteBaseActivity<DatabaseHelper> { private EditText stuNO; private EditText stuName; private EditText stuAge; private EditText stuSex; private EditText stuScore; private EditText stuAddress; priv
ate Student mStudent; private Dao<Student,Integer> stuDao; private final int MENU_ADD = Menu.FIRST; private final int MENU_VIEWALL = Menu.FIRST+1; private final int MENU_EDIT = Menu.FIRST+2; private Bundle mBundle = new Bundle(); /** Called when the activity is first created. */ @Override public void onCreate(Bundle savedInstanceState) { Create(savedInstanceState); setContentView(R.layout.main); initializeViews(); } /** * 初始化UI界面 */ private void initializeViews(){ stuNO = (EditText)findViewById(R.id.stuno); stuName = (EditText)findViewById(R.id.name); stuAge = (EditText)findViewById(R.id.age); stuSex = (EditText)findViewById(R.id.sex); stuScore = (EditText)findViewById(R.id.score); stuAddress = (EditText)findViewById(R.id.address); mBundle = getIntent().getExtras(); if(mBundle!=null && String("action").equals("viewone")){ mStudent = (Student)getIntent().getSerializableExtra("entity"); setStudentUIData(mStudent); } if(mBundle!=null && String("action").equals("edit")){ mStudent = (Student)getIntent().getSerializableExtra("entity"); setStudentUIData(mStudent); } } @Override public boolean onPrepareOptionsMenu(Menu menu) { if(mBundle!=null && String("action").equals("viewone")) return false; else PrepareOptionsMenu(menu); } @Override public boolean onCreateOptionsMenu(Menu me
nu) { if(mBundle!=null && String("action").equals("edit")){ menu.add(1,MENU_EDIT,0,"保存"); }else{ menu.add(0,MENU_ADD,0,"增加"); menu.add(0,MENU_VIEWALL,0,"查看"); } CreateOptionsMenu(menu); } @Override public boolean onOptionsItemSelected(MenuItem item) { switch (ItemId()) { case MENU_ADD: try { stuDao = getHelper().getStudentDao(); getStudentData(); if(mStudent != null){ //创建记录项 ate(mStudent); } } catch (SQLException e) { e.printStackTrace(); } break; case MENU_VIEWALL: Intent intent = new Intent(); intent.setClass(MainActivity.this, StudentListActivity.class); startActivity(intent); break; case MENU_EDIT: try { getStudentData(); stuDao = getHelper().getStudentDao(); if(mStudent != null){ //更新某记录项
stuDao.update(mStudent); } } catch (SQLException e) { e.printStackTrace(); } break; default: break; } OptionsItemSelected(item); } /** * 获取界面值(实体信息) */ private void getStudentData(){ mStudent = new Student(); mStudent.Text().toString()); mStudent.Text().toString()); mStudent.setAge(Integer.Text().toString())); mStudent.Text().toString()); mStudent.setScore(Double.parseDouble(stuScore.g
etText().toString())); mStudent.Text().toString()); } /** * 赋值给UI界面 * @param student */ private void setStudentUIData(Student student){ stuNO.StuNO()); stuName.Name()); stuAge.setText(String.Age())); stuSex.Sex()); stuScore.setText(String.Score())); stuAddress.Address()); }}StudentListActivity.java源码：
package sqlite;import java.sql.SQLException;import java.util.List;import android.app.AlertDialog;t.Context;t.DialogInterface;t.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 lite.android.apptools.OrmLiteBaseActivity;import lite.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) { Create(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,"删除"); CreateContextMenu(menu, v, menuInfo); } @Override
public boolean onContextItemSelected(MenuItem item) { switch (ItemId()) { 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 = (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 = (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 = (Adapter().getItem(pos); try { stuDao.delete(mDelStudent); //删除记录 queryListViewItem(); } catch (SQLException e) { e.printStackTrace(); } } }); builder2.setNegativeButton("取消", new DialogInterface.OnClickListener() { @Override public voi
d 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) { (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.itemsc
版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。
发表评论