使用SQLite数据库完成手机通讯录的增加、删除、修改和查询功能,并进行相关消息的提示,写出主要代码即可。
时间: 2024-03-25 13:41:08 浏览: 39
好的,以下是使用SQLite数据库完成手机通讯录的增加、删除、修改和查询功能的示例代码:
1.创建数据库
```java
public class DBHelper extends SQLiteOpenHelper {
private static final String DB_NAME = "contact.db";
private static final int VERSION = 1;
public DBHelper(Context context) {
super(context, DB_NAME, null, VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("CREATE TABLE IF NOT EXISTS contacts (_id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, phone TEXT)");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}
```
2.添加联系人
```java
public class ContactManager {
private DBHelper dbHelper;
public ContactManager(Context context) {
dbHelper = new DBHelper(context);
}
public void addContact(String name, String phone) {
SQLiteDatabase db = dbHelper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("name", name);
values.put("phone", phone);
db.insert("contacts", null, values);
db.close();
}
}
```
3.删除联系人
```java
public class ContactManager {
private DBHelper dbHelper;
public ContactManager(Context context) {
dbHelper = new DBHelper(context);
}
public void deleteContact(int id) {
SQLiteDatabase db = dbHelper.getWritableDatabase();
db.delete("contacts", "_id=?", new String[]{String.valueOf(id)});
db.close();
}
}
```
4.修改联系人
```java
public class ContactManager {
private DBHelper dbHelper;
public ContactManager(Context context) {
dbHelper = new DBHelper(context);
}
public void updateContact(int id, String name, String phone) {
SQLiteDatabase db = dbHelper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("name", name);
values.put("phone", phone);
db.update("contacts", values, "_id=?", new String[]{String.valueOf(id)});
db.close();
}
}
```
5.查询联系人
```java
public class ContactManager {
private DBHelper dbHelper;
public ContactManager(Context context) {
dbHelper = new DBHelper(context);
}
public List<Contact> queryContacts() {
List<Contact> contacts = new ArrayList<>();
SQLiteDatabase db = dbHelper.getReadableDatabase();
Cursor cursor = db.query("contacts", null, null, null, null, null, null);
while (cursor.moveToNext()) {
int id = cursor.getInt(cursor.getColumnIndex("_id"));
String name = cursor.getString(cursor.getColumnIndex("name"));
String phone = cursor.getString(cursor.getColumnIndex("phone"));
Contact contact = new Contact(id, name, phone);
contacts.add(contact);
}
cursor.close();
db.close();
return contacts;
}
}
```
以上是使用SQLite数据库完成手机通讯录的增加、删除、修改和查询功能的示例代码,具体实现中需要根据实际需求进行修改。
阅读全文