android——CRUD(在上一篇博客的基础上)

本文介绍了一个基于Android平台的SQLite数据库操作案例,包括Person类定义、PersonDao类实现增删改查功能及测试用例。演示了如何通过Java代码进行数据库交互。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

1、Person

package com.njupt.sqlite;

public class Person {

	private Integer id;
	private String name;
	private Integer balance;
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public Integer getBalance() {
		return balance;
	}
	public void setBalance(Integer balance) {
		this.balance = balance;
	}
	@Override
	public String toString() {
		return "Person [id=" + id + ", name=" + name + ", balance=" + balance
				+ "]";
	}
	public Person(Integer id, String name, Integer balance) {
		super();
		this.id = id;
		this.name = name;
		this.balance = balance;
	}
	
	public Person() {
		super();
	}
	
	
	
}


2、PersonDao

package com.njupt.sqlite;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

public class PersonDao {

	private DBOpenHelper helper;
	
	public PersonDao(Context context){
		helper = new DBOpenHelper(context);
	}
	
	public void insert(Person p){
		SQLiteDatabase db = helper.getWritableDatabase();
		
		db.execSQL("insert into person1(name,balance) values(?,?)",new Object[]{p.getName(),p.getBalance()});
	    db.close();
	}
	
	public void delete(int id){
		 SQLiteDatabase db = helper.getWritableDatabase();
		    db.execSQL("delete from person1 where id = ?",new Object[]{id});
		    db.close();
	}
	
	
	public void update(Person p){
		SQLiteDatabase db = helper.getWritableDatabase();
		db.execSQL("update person1 set name = ? , balance = ? where id = ?", new Object[]{p.getName(),p.getBalance(),p.getId()});
		db.close();
	}
	
	public Person query(int id){
		SQLiteDatabase db = helper.getReadableDatabase();
		Cursor c = db.rawQuery("select name ,balance from person1 where id = ?", new String[]{id + ""});
		Person p = null;
		
		if(c.moveToNext()){
			String name = c.getString(0);
			int balance = c.getInt(1);
			
			p = new Person(id,name,balance);
		}
		
		
		return p;
	}
	   
	    		
	
}

3、DBTest

以下附上测试类

package com.njupt.sqlite;

import android.test.AndroidTestCase;

public class DBTest extends AndroidTestCase{

	public void test1(){
		DBOpenHelper helper = new DBOpenHelper(getContext());
		helper.getWritableDatabase();
		
	}
	
	public void testInsert(){
		PersonDao dao = new PersonDao(getContext());
		
		Person p = new Person(3,"章泽天",45000);
		
		dao.insert(p);
	}
	
	public void testDelete(){
		PersonDao dao = new PersonDao(getContext());
		
		int id = 1;
		dao.delete(id);
	}
	
	public void testUpdate(){
		PersonDao dao = new PersonDao(getContext());
		
		Person p = new Person(2,"lss",40000);
		
		dao.update(p);
		
	}
	
	
	public void testQuery(){
		PersonDao dao = new PersonDao(getContext());
		
		Person p = dao.query(3);
		
		System.out.println(p);
	}
}

4、最后我们可以在SQLiteExpert中看到相应的变化


评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

帅气的东哥

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值