Android(安卓)SQLiteHelper
16lz
2022-05-27
1 package com.liren.news.data;
2
3 import android.content.ContentValues;
4 import android.content.Context;
5 import android.database.Cursor;
6 import android.database.sqlite.SQLiteDatabase;
7
8 public class SQLiteHelper extends android.database.sqlite.SQLiteOpenHelper{
9
10 private final static StringDATABASE_NAME = " db_name " ;
11 private final static int DATABASE_VERSION = 1 ;
12 private final static StringTABLE_NAME = " mytable " ;
13 private final static StringFIELD_ID = " ID " ;
14 private final static StringFIELD_NAME = " NAME " ;
15
16 public SQLiteHelper(Contextcontext){
17 super (context,DATABASE_NAME, null ,DATABASE_VERSION);
18 }
19
20 @Override
21 public void onCreate(SQLiteDatabasedb){
22 Stringsql = " Createtable%s(%sintegerprimarykeyautoincrement,%stext); " ;
23 sql = String.format(sql,TABLE_NAME,FIELD_ID,FIELD_NAME);
24 db.execSQL(sql);
25 }
26
27 @Override
28 public void onUpgrade(SQLiteDatabasedb, int oldVersion, int newVersion){
29 Stringsql = " DROPTABLEIFEXISTS " + TABLE_NAME;
30 db.execSQL(sql);
31 onCreate(db);
32 }
33
34 public Cursorselect(){
35 SQLiteDatabasedb = this .getReadableDatabase();
36 Cursorcursor = db.query(TABLE_NAME, null , null , null , null , null ,
37 FIELD_ID);
38 return cursor;
39
40 }
41
42 public long insert(Stringname){
43 SQLiteDatabasedb = this .getWritableDatabase();
44 ContentValuescv = new ContentValues();
45 cv.put(FIELD_NAME,name);
46 long row = db.insert(TABLE_NAME, null ,cv);
47 return row;
48 }
49
50 public void delete( int id){
51 SQLiteDatabasedb = this .getWritableDatabase();
52 Stringwhere = FIELD_ID + " =? " ;
53 String[]wherevalue = {Integer.toString(id)};
54 db.delete(TABLE_NAME,where,wherevalue);
55 }
56
57 public void update( int id,Stringname)
58 {
59 SQLiteDatabasedb = this .getWritableDatabase();
60 Stringwhere = FIELD_ID + " =? " ;
61 String[]wherevalue = {Integer.toString(id)};
62 ContentValuescv = new ContentValues();
63 cv.put(FIELD_NAME,name);
64 db.update(TABLE_NAME,cv,where,wherevalue);
65 }
66 }
67
2
3 import android.content.ContentValues;
4 import android.content.Context;
5 import android.database.Cursor;
6 import android.database.sqlite.SQLiteDatabase;
7
8 public class SQLiteHelper extends android.database.sqlite.SQLiteOpenHelper{
9
10 private final static StringDATABASE_NAME = " db_name " ;
11 private final static int DATABASE_VERSION = 1 ;
12 private final static StringTABLE_NAME = " mytable " ;
13 private final static StringFIELD_ID = " ID " ;
14 private final static StringFIELD_NAME = " NAME " ;
15
16 public SQLiteHelper(Contextcontext){
17 super (context,DATABASE_NAME, null ,DATABASE_VERSION);
18 }
19
20 @Override
21 public void onCreate(SQLiteDatabasedb){
22 Stringsql = " Createtable%s(%sintegerprimarykeyautoincrement,%stext); " ;
23 sql = String.format(sql,TABLE_NAME,FIELD_ID,FIELD_NAME);
24 db.execSQL(sql);
25 }
26
27 @Override
28 public void onUpgrade(SQLiteDatabasedb, int oldVersion, int newVersion){
29 Stringsql = " DROPTABLEIFEXISTS " + TABLE_NAME;
30 db.execSQL(sql);
31 onCreate(db);
32 }
33
34 public Cursorselect(){
35 SQLiteDatabasedb = this .getReadableDatabase();
36 Cursorcursor = db.query(TABLE_NAME, null , null , null , null , null ,
37 FIELD_ID);
38 return cursor;
39
40 }
41
42 public long insert(Stringname){
43 SQLiteDatabasedb = this .getWritableDatabase();
44 ContentValuescv = new ContentValues();
45 cv.put(FIELD_NAME,name);
46 long row = db.insert(TABLE_NAME, null ,cv);
47 return row;
48 }
49
50 public void delete( int id){
51 SQLiteDatabasedb = this .getWritableDatabase();
52 Stringwhere = FIELD_ID + " =? " ;
53 String[]wherevalue = {Integer.toString(id)};
54 db.delete(TABLE_NAME,where,wherevalue);
55 }
56
57 public void update( int id,Stringname)
58 {
59 SQLiteDatabasedb = this .getWritableDatabase();
60 Stringwhere = FIELD_ID + " =? " ;
61 String[]wherevalue = {Integer.toString(id)};
62 ContentValuescv = new ContentValues();
63 cv.put(FIELD_NAME,name);
64 db.update(TABLE_NAME,cv,where,wherevalue);
65 }
66 }
67
更多相关文章
- 代码中设置drawableleft
- android 3.0 隐藏 系统标题栏
- Android开发中activity切换动画的实现
- Android(安卓)学习 笔记_05. 文件下载
- Android中直播视频技术探究之—摄像头Camera视频源数据采集解析
- 技术博客汇总
- android 2.3 wifi (一)
- AndRoid Notification的清空和修改
- Android中的Chronometer