關于ormlite增刪改查操作，在這里以一個查詢歷史記錄和根據歷史記錄或當前記錄查詢相關信息進行講解
宣州網站建設公司創(chuàng)新互聯(lián)建站,宣州網站設計制作，有大型網站制作公司豐富經驗。已為宣州上千多家提供企業(yè)網站建設服務。企業(yè)網站搭建\成都外貿網站建設要多少錢，請找那個售后服務好的宣州做網站的公司定做！
增刪改查有很多方法，在這我還是先把工具類代碼粘上，就不作多的解釋啦
public class DataBasehelper extends OrmLiteSqliteOpenHelper {
????private static DataBasehelper db;
????public DataBasehelper(Context context) {
????????super(context, "fwsssssss", null, 8);
????}
?
????@Override
????public void onCreate(SQLiteDatabase sqLiteDatabase, ConnectionSource connectionSource) {
????????try {
????????????TableUtils.createTable(connectionSource , Om_Em.class);
????????} catch (SQLException e) {
????????????e.printStackTrace();
????????}
????}
?
????@Override
????public void onUpgrade(SQLiteDatabase sqLiteDatabase, ConnectionSource connectionSource, int i, int i1) {
????????try {
????????????TableUtils.dropTable(connectionSource , Om_Em.class , true);
????????????????onCreate(sqLiteDatabase , connectionSource);
????????} catch (SQLException e) {
????????????e.printStackTrace();
????????}
????}
????public static synchronized DataBasehelper getInstance(Context context){
????????if(db == null){
????????????db = new DataBasehelper(context);
????????}
????????return db;
????}
}
?
然后就是實體類
@DatabaseTable(tableName = "Luck")
public class Om_Em {
????@DatabaseField(generatedId = true)
????int id;
????@DatabaseField
????String name;
????@DatabaseField
????int count;
????@DatabaseField
????int scort;
????@DatabaseField
????int money;
?
????public Om_Em(String name, int count, int scort, int money) {
????????this.name = name;
????????this.count = count;
????????this.scort = scort;
????????this.money = money;
????}
?
????public Om_Em() {
????}
?
????public int getId() {
????????return id;
????}
?
????public void setId(int id) {
????????this.id = id;
????}
?
????public String getName() {
????????return name;
????}
?
????public void setName(String name) {
????????this.name = name;
????}
?
????public int getCount() {
????????return count;
????}
?
????public void setCount(int count) {
????????this.count = count;
????}
?
????public int getScort() {
????????return scort;
????}
?
????public void setScort(int scort) {
????????this.scort = scort;
????}
?
????public int getMoney() {
????????return money;
????}
?
????public void setMoney(int money) {
????????this.money = money;
????}
}
?
然后就是Dao模式了
?
public class Om_Daos {
????Context context;
????public Om_Daos(Context context) {
????????this.context = context;
????}
????public DataBasehelper getHelper(){
????????return DataBasehelper.getInstance(context);
????}
????public Dao
????????????return getHelper().getDao(Om_Em.class);
????}
????public Dao.CreateOrUpdateStatus Update(Om_Em om_em) throws SQLException {
????????return ?getDao().createOrUpdate(om_em);
????}
?
}
?
布局XML代碼如下
????android:id="@+id/list_tab_toolbar" ????layout="@layout/toolbar_main"/> ? ????android:id="@+id/textView5" ????android:layout_width="wrap_content" ????android:layout_height="wrap_content" ????android:layout_alignParentStart="true" ????android:layout_alignParentLeft="true" ????android:layout_alignParentTop="true" ????android:layout_marginStart="196dp" ????android:layout_marginLeft="196dp" ????android:layout_marginTop="139dp" ????android:text="車輛違章居民身份信息查詢" ????android:textColor="#000" ????android:textSize="30dp" /> ? ????android:id="@+id/textView6" ????android:layout_width="wrap_content" ????android:layout_height="wrap_content" ????android:layout_alignParentStart="true" ????android:layout_alignParentLeft="true" ????android:layout_alignParentTop="true" ????android:layout_marginStart="228dp" ????android:layout_marginLeft="228dp" ????android:layout_marginTop="222dp" ????android:text="車牌號" ????android:textSize="20dp" /> ? ????android:id="@+id/sm_4_edit" ????android:layout_width="wrap_content" ????android:layout_height="wrap_content" ????android:layout_alignParentStart="true" ????android:layout_alignParentLeft="true" ????android:layout_alignParentTop="true" ????android:layout_marginStart="326dp" ????android:layout_marginLeft="326dp" ????android:layout_marginTop="212dp" ????android:digits="ABCDabcd0123456789" ????android:ems="10" ????android:inputType="text" /> ? ????android:id="@+id/sm_4_seach" ????android:layout_width="wrap_content" ????android:layout_height="wrap_content" ????android:layout_alignParentTop="true" ????android:layout_alignParentEnd="true" ????android:layout_alignParentRight="true" ????android:layout_marginTop="209dp" ????android:layout_marginEnd="286dp" ????android:layout_marginRight="286dp" ????android:text="查詢" /> 這里是編輯框的判斷邏輯，很簡單，就不多說了 public class Smart4 extends BaseActivity { ????@Override ????protected void onCreate(@Nullable Bundle savedInstanceState) { ????????super.onCreate(savedInstanceState); ????????InitView(); ????} ????private void InitView() { ????????initToolBar(findViewById(R.id.toolbar), true, getString(R.string.item1)); ????????daos = new Om_Daos(getApplicationContext()); ????????requestQueue = Volley.newRequestQueue(getApplicationContext()); ????????sm_4_seach = findViewById(R.id.sm_4_seach); ????????sm_4_edit = findViewById(R.id.sm_4_edit); ????????sm_4_seach.setOnClickListener(new View.OnClickListener() { ????????????@Override ????????????public void onClick(View view) { ????????????????String s = sm_4_edit.getText().toString().trim(); ????????????????if("".equals(s)){ ????????????????????Toast.makeText(Smart4.this, "不能為空！", Toast.LENGTH_SHORT).show(); ????????????????}else{ ????????????????????InitData(s); ????????????????} ????????????} ????????}); ????} } ? ? ?private void InitData(String carnumber){ ???????????? ???????????? ?.... ?????? ????????JsonObjectRequest jor = new JsonObjectRequest(url, job, new Response.Listener ????????????@Override ????????????public void onResponse(JSONObject jsonObject) { ????????????????Toast.makeText(Smart4.this, "查詢成功！", Toast.LENGTH_SHORT).show(); ????????????????Intent intent = new Intent(Smart4.this, Smart4_watch.class); ????????????????intent.putExtra("carnumber",job.optString("carnumber")); ????????????????startActivity(intent); ????????????} ????????}, new Response.ErrorListener() { ????????????@Override ????????????public void onErrorResponse(VolleyError volleyError) { ????????????????Toast.makeText(Smart4.this, "未查詢到"+job.optString("carnumber")+"信息", Toast.LENGTH_SHORT).show(); ????????????} ????????}); ????????requestQueue.add(jor); ????} ? 首先我需要定義一個棋子 ?private boolean isInsert = true; 其次，執(zhí)行數(shù)據庫的查詢操作 使用queryForAll（）方法查詢list集合 ????String s = getIntent().getStringExtra("carnumber"); ????????Om_Daos = new Om_Daos(getApplicationContext()); ????????om_ems = Om_Daos.getDao().queryForAll();//查詢操作 ?????? 查詢返回的是一個list集合，然后遍歷集合中的元素，并且尋找是否重復查找數(shù)據 ??if(om_ems.size() != 0){ ????????????for (int i = 0; i < om_ems.size(); i++) { ????????????????if(om_ems.get(i).getName().equals(s)){ ????????????????????isInsert = false; ????????????????????break; ????????????????} ????????????} ????????}else{ ????????//執(zhí)行插入語句,因為后面用到更新，所以在這里我先給這條數(shù)據其他成員都設為0 ????????????Om_Daos.getDao().create(new Om_Em(s,0,0,0)); ????????????isInsert = false; ????????} 使用create（）方法插入一個實體類 if(isInsert){ ????????????Om_Daos.getDao().create(new Om_Em(s,0,0,0)); ????????} ???????//重新查詢list集合 ????????om_ems = Om_Daos.getDao().queryForAll(); 注意，在執(zhí)行插入語句之后，記得重新查詢一次list ,然后這里省略根據JSON數(shù)據查詢的實體類信息，因為是側重點，所以就不提起了，之后，自定義左右兩個適配器,用來展示不重復的歷史記錄信息 class MyLeftAdapter extends BaseAdapter{ ? ????????@Override ????????public int getCount() { ????????????return om_ems.size(); ????????} ? ????????@Override ????????public Object getItem(int i) { ????????????return null; ????????} ? ????????@Override ????????public long getItemId(int i) { ????????????return 0; ????????} ? ????????@Override ????????public View getView(int position, View context, ViewGroup viewGroup) { ????????????if(context == null){ ????????????????context = getLayoutInflater().inflate(R.layout.sm_4_left , null); ????????????} ????????????return context; ????????} ????} ???? class MyRightAdapter extends BaseAdapter{ ????????@Override ????????public int getCount() { ????????????return right_adapter.getROWS_DETAIL().size(); ????????} ? ????????@Override ????????public Object getItem(int i) { ????????????return null; ????????} ? ????????@Override ????????public long getItemId(int i) { ????????????return 0; ????????} ? ????????@Override ????????public View getView(int position, View context, ViewGroup viewGroup) { ????????????if(context == null){ ????????????????context = getLayoutInflater().inflate(R.layout.sm_4_right , null); ????????????} ????????????return context; ? ????????} ????} 給兩個適配器設置監(jiān)聽事件 ?sm_4_right.setOnItemClickListener(new AdapterView.OnItemClickListener() { ????????????@Override ????????????public void onItemClick(AdapterView adapterView, View view, int i, long l) { ??????????????????????? ????????????} ????????}); ????????sm_4_left.setOnItemClickListener(new AdapterView.OnItemClickListener() { ????????????@Override ????????????public void onItemClick(AdapterView adapterView, View view, int position, long l) { ???????????????? ????????????} ????????}); 右邊的適配器點擊進入另外一個界面，查看詳情，實現(xiàn)查看放大縮小的功能，這里只展示手勢的核心代碼 public class Smart4_Guet extends android.support.v7.widget.AppCompatImageView implements ScaleGestureDetector.OnScaleGestureListener { ????private ScaleGestureDetector scaleGestureDetector; ????private Matrix matrix; ????boolean first = true; ? ????public Smart4_Guet(Context context) { ????????super(context); ????????initView(context); ????} ? ????public Smart4_Guet(Context context, @Nullable AttributeSet attrs) { ????????super(context, attrs); ????????initView(context); ????} ? ????@Override ????protected void onDraw(Canvas canvas) { ????????super.onDraw(canvas); ????????if (first){ ????????????first = false; ????????????matrix.reset(); ????????????matrix.postTranslate(getWidth()/2,getHeight()/2); ????????????setImageMatrix(matrix); ????????} ????} ? ????private void initView(Context context) { ????????setScaleType(ScaleType.MATRIX); ?????????scaleGestureDetector = new ScaleGestureDetector(context,this); ?????????matrix = new Matrix(); ????????setOnTouchListener(new OnTouchListener() { ????????????@Override ????????????public boolean onTouch(View v, MotionEvent event) { ????????????????scaleGestureDetector.onTouchEvent(event); ????????????????return true; ????????????} ????????}); ????} ? ????@Override ????public boolean onScale(ScaleGestureDetector detector) { ????????float scaleFactor = detector.getScaleFactor(); ????????function(){ //隔夜利息 http://www.fx61.com/faq/muniu/414.html ????????matrix.postScale(scaleFactor,scaleFactor,getWidth()/2,getHeight()/2); ????????setImageMatrix(matrix); ????????return true; ????} 現(xiàn)在重點來說查找的功能和更新的功能 ?try { ????????????????????//動態(tài)查找id ????????????????????int id = 0 , money = 0; ????????????????????//查詢list集合 ????????????????????List ????????????????????//這里查找ID的條件我就以名字為例name是 輸入框中傳來的 ????????????????????for (int i = 0; i < om_emsS.size(); i++) { ????????????????????????if(om_emsS.get(i).getName().equals(name)){ ????????????????????????????id = om_emsS.get(i).getId(); ???????????????????????? ????????????????????????????break; ????????????????????????} ????????????????????} 使用queryForId()方法，根據ID查詢實體類 Om_Em om_em = Om_Daos.getDao().queryForId(id); ? //向實體類設置一些屬性 .... //執(zhí)行更新方法 ? ?om_em.setCount(11); ????????????????????????????Om_Daos.Update(om_em); ????????????????????????????//重新查詢list然后設置給適配器 ????????????????????????????om_ems = Om_Daos.getDao().queryForAll(); ? ?
網站題目：ormlite-android-5.1.jar和ormlite-core-5.1.jar
鏈接URL：http://weahome.cn/article/gdpgjo.html
重慶分公司
重慶分公司
