Android LitePal 操作 SQLite数据库

痛定思痛。 2022-05-29 13:35 334阅读 0赞

学了Android近三个月,终于完成了需求,做了一款App,客户反应还比较满意,对Android进行一些总结,以后还有很多地方需要学习

以下的东西都是我自己的理解.

首先,LitePal是一个操纵SQLite的数据库框架,思想跟hibernate,mybatis类似.它的优点就是轻量化,使用起来也比较方便.有JavaWeb的基础的话,理解起来还是很简单的.

1.引用gradle依赖(也可以引入Jar包)

dependencies {
        compile 'org.litepal.android:core:1.5.0'
    }

2.配置litepal.xml

litepal.xml 在app/assets/  目录下

<?xml version="1.0" encoding="utf-8"?>
    <litepal>
        
        <dbname value="数据库名" />
    
        
        <version value="1" />
    
        
        <list>
            <mapping class="实体类的路径"></mapping>
        </list>
    
        
    
    </litepal>

3.创建实体类继承DataSupport

public class Article extends DataSupport {
        private int id;
        private String headline;
        private String author;
        private String content;
        private String time;
        public int getId() {
            return id;
        }
        public void setId(int id) {
            this.id = id;
        }
        public String getHeadline() {
            return headline;
        }
        public void setHeadline(String headline) {
            this.headline = headline;
        }
        public String getAuthor() {
            return author;
        }
        public void setAuthor(String author) {
            this.author = author;
        }
        public String getContent() {
            return content;
        }
        public void setContent(String content) {
            this.content = content;
        }
        public String getTime() {
            return time;
        }
        public void setTime(String time) {
            this.time = time;
        }
    }

4.查

//查询id为3的Article
    Article article = DataSupport.find(Article.class, 3);
    //查询第一条Article
    Article article1 = DataSupport.findFirst(Article.class);
    //查询最后一条Article
    Article article2 = DataSupport.findLast(Article.class);
    //查询所有的
    List<Article> articleList = DataSupport.findAll(Article.class);
    //查询特定的
    List<Article> articleList1 = DataSupport.where("id > ?", "1").find(Article.class);
    //统计表的行数,Count
    int number = DataSupport.count(Article.class);

5.增

Article article1= new Article();
    article1.setId(article.getId());
    article1.setAuthor(article.getAuthor());
    article1.setHeadline(article.getHeadline());
    article1.setContent(article.getContent());
    article1.setTime(article.getTime());
    article1.save();

6.删

DataSupport.deleteAll(Article.class, "id=?", "1");

删除id为1的article

7.改

更新了id为1的Article