Android SQL语句实现数据库的增删改查

android中的数据库的增删改查

复习sql语法：

* 增

insert into info (name,phone) values ('wuyudong','111')

* 删

delete from person where name = 'wuyudong'

* 改

update person set number='119' where name='wuyudong'

* 查

select * from person

select * from person where name='wuyudong'

数据库文件是在 /data/data/包名/databases/xxx.db

首先定义一个Person类

package com.wuyudong.db.domain;

public class Person {
    private int id;
    private String name;
    private String number;

    public Person() {
        
    }

    public Person(int id, String name, String number) {
        this.id = id;
        this.name = name;
        this.number = number;
    }

    public int getId() {
        return id;
    }