1. 创建一个SQLiteOpenHelper继承类
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
|
public class MySQLiteHelper extends SQLiteOpenHelper
{ //重写构造方法,可以改为(Context context, int version)只要这两参数
public MySQLiteHelper(Context context, String name, CursorFactory factory,
int version)
{
super(context, "test.db", null, version);
}
//创建表
@Override
public void onCreate(SQLiteDatabase db)
{
db.execSQL("CREATE TABLE person(personid INTEGER PRIMARY KEY AUTOINCREMENT,name VARCHAR(20),phone VARCHAR(20))" );
db.execSQL("CREATE TABLE student(personid INTEGER PRIMARY KEY AUTOINCREMENT,name VARCHAR(20),phone VARCHAR(20))" );
}
//升级表（当Database的Version低于当前new里的Version，直接执行下面方法）
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
{
int v = newVersion - oldVersion;
switch (v)
{
case 3:
db.execSQL("ALTER TABLE person ADD salary3 VARCHAR(20)");
case 2:
db.execSQL("ALTER TABLE person ADD salary2 VARCHAR(20)");
case 1:
db.execSQL("ALTER TABLE person ADD salary1 VARCHAR(20)");
default:
break;
}
}
} |
2.使用SQLite增删改查
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
|
/** *
CREATE TABLE person( personid INTEGER PRIMARY KEY AUTOINCREMENT,
name VARCHAR(20),
phone VARCHAR(20)
)DROP TABLE person //删除表INSERT INTO person(name,phone) VALUES ("rongqin","1598088588") //插入SELECT * FROM person WHERE name="Andfeel"UPDATE person SET name="Andfeel" WHERE personid=2 //改ALTER TABLE person ADD salary //增加列DELETE FROM person WHERE name="Andfeel" //删除 *
*/
public class MainActivity extends Activity implements OnClickListener
{ private TextView textView;
private MySQLiteHelper mDBHelper;
private MySQLiteHelper bHelper;
@Override
protected void onCreate(Bundle savedInstanceState)
{
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
findViewById(R.id.btn__create_table).setOnClickListener(this);
findViewById(R.id.btn_delete_table).setOnClickListener(this);
findViewById(R.id.btn_alter_table).setOnClickListener(this);
findViewById(R.id.btn_insert).setOnClickListener(this);
findViewById(R.id.btn_delete).setOnClickListener(this);
findViewById(R.id.btn_update).setOnClickListener(this);
findViewById(R.id.btn_select).setOnClickListener(this);
textView = (TextView) findViewById(R.id.textView1);
//创建数据库
mDBHelper = new MySQLiteHelper(this, "one.db", null, 3);
bHelper = new MySQLiteHelper(this, "two.db", null, 4);
}
@Override
public boolean onCreateOptionsMenu(Menu menu)
{
getMenuInflater().inflate(R.menu.activity_main, menu);
return true;
}
@Override
public void onClick(View v)
{
switch (v.getId())
{
case R.id.btn__create_table:
btnCreateTable();
break;
case R.id.btn_delete_table:
btnDeleteTable();
break;
case R.id.btn_alter_table:
btnAlterTable();
break;
case R.id.btn_insert:
btnInsert();
break;
case R.id.btn_delete:
btnDelete();
break;
case R.id.btn_update:
btnUpdate();
break;
case R.id.btn_select:
btnSelect();
break;
default:
break;
}
}
private void btnSelect()//查
{
SQLiteDatabase db = mDBHelper.getWritableDatabase();
SQLiteDatabase db1 = bHelper.getWritableDatabase();
Cursor cursor = db.rawQuery("SELECT * FROM person WHERE name = ?", new String[]{"rongqin"});
// cursor.moveToFirst(); while(cursor.moveToNext())
{
int columnIndex = cursor.getColumnIndex("name");
String name = cursor.getString(columnIndex);
int columnIndex2 = cursor.getColumnIndex("phone");
String phone = cursor.getString(columnIndex2);
textView.setText(name + ":" + phone);
}
}
private void btnUpdate()//改
{
SQLiteDatabase db = mDBHelper.getWritableDatabase();
db.execSQL("UPDATE person SET phone='0592xxxxxx' WHERE personid=5");
}
private void btnDelete()//删
{
SQLiteDatabase db = mDBHelper.getWritableDatabase();
db.execSQL("DELETE FROM person WHERE name='Andfeel'");
}
private void btnInsert()//增
{
SQLiteDatabase db = mDBHelper.getWritableDatabase();
db.execSQL("INSERT INTO person(name,phone) VALUES ('rongqin',1598088588)");
}
private void btnAlterTable()//扩展表
{
}
private void btnDeleteTable()//删除表
{
}
private void btnCreateTable()//创建表
{
}
} |
注：
1.通过以下方法可以修改数据库存储路径
SQLiteDatabase.openOrCreateDatabase(file, factory)；
context.openOrCreateDatabase(name, mode, factory)；
本文转自 glblong 51CTO博客，原文链接：http://blog.51cto.com/glblong/1216873，如需转载请自行联系原作者