blocks|key|2734154|text|SQLite显然是Android的一部分：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2734155|http://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html|offset|length|2734156|但是，您可能必须创建自己的抽象层(用于简单查询的查询生成器)，或者以其他方式处理SQL。|2734157|也许http://developer.android.com/reference/android/database/sqlite/SQLiteQueryBuilder.html就是你所需要的？|2734158|entityMap|0|LINK|mutability|MUTABLE|url|1|http://developer.android.com/reference/android/database/sqlite/SQLiteQueryBuilder.html^0|0|0|2A|0|0|0|2|2E|1|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@$D|U|E|V|1|W]]|A|$]]|$1|F|3|G|5|6|7|X|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|Y|8|@]|9|@$D|Z|E|10|1|11]]|A|$]]|$1|J|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|C]]|Q|$5|M|N|O|A|$P|R]]]]

SQLite is explicitly part of Android:

<a href="http://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html" rel="nofollow noreferrer">http://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html</a>

However you might have to create your own abstraction layer (query builder for simple queries), or otherwise deal with SQL.

Maybe <a href="http://developer.android.com/reference/android/database/sqlite/SQLiteQueryBuilder.html" rel="nofollow noreferrer">http://developer.android.com/reference/android/database/sqlite/SQLiteQueryBuilder.html</a> is what you need?

blocks|key|1135863|text|还有新提斯和佩斯特(Lite)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1135864|一年前我就和珀斯特玩过了，我认为这不值得。|1135865|毕竟，(+a)+Android运行在一个限制很小的设备上，每个应用程序的堆空间约为16+on；(+b)您的客户会非常欣赏性能和低功耗。|1135866|因此，我的建议是使用SQLite和手写的SQL。这并不难，而且Android提供的包装非常好。|1135867|编辑:在2012年，建议是使用DroidParts的ORM组件(这是我的项目)。|offset|length|1135868|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/yanchenko/droidparts^0|0|0|0|0|F|A|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|V|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@$J|Y|K|Z|1|10]]|A|$]]|$1|L|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S]]]]

There's also Neodatis and Perst (Lite). 
I've toyed with Perst a year ago and concluded it's not worth it. 
After all, a) Android runs on a rather restricted device with ~16mb of heap space per app and b) You customers would really appreciate performance and low power consumption. 
So my advice is to go with SQLite and hand-written SQL. It's not hard at all and the wrappers provided by Android SDK are really nice.

EDIT: In 2012 the advice would be to use the ORM component of <a href="https://github.com/yanchenko/droidparts" rel="nofollow noreferrer">DroidParts</a> (which is my project).

blocks|key|2734256|text|试试ActiveAndroid。它是免费的开放源码(ApacheVersion2.0)。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2734257|在网站上：|2734258|ActiveAndroid是一种活动记录样式ORM+(对象关系映射器)。..。ActiveAndroid允许您保存和检索SQLite数据库记录，而无需编写一条SQL语句。每个数据库记录都整齐地包装成一个类，其中包含了保存()和delete()等方法。
..。至少可以说，在Android系统中，访问数据库是个麻烦。ActiveAndroid负责所有的设置和杂乱无章的工作，只需几个简单的配置步骤即可。|blockquote|2734259|entityMap|0|LINK|mutability|MUTABLE|url|http://www.activeandroid.com/^0|2|D|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|6|7|U|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|V|8|@]|9|@]|C|$]]|$1|I|3|-4|5|6|7|W|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

Try <a href="http://www.activeandroid.com/" rel="nofollow noreferrer">ActiveAndroid</a>. It is free and open source (Apache Version 2.0).

From the website:

<blockquote>
 ActiveAndroid is an active record style ORM (object relational
 mapper). [...] ActiveAndroid allows you
 to save and retrieve SQLite database records without ever writing a
 single SQL statement. Each database record is wrapped neatly into a
 class with methods like save() and delete().
 
 [...] Accessing the database is a hassle, to say the least, in Android. 
 ActiveAndroid takes care of all the setup and messy stuff, and all
 with just a few simple steps of configuration.
</blockquote>

blocks|key|1211025|text|有一个“Android活动记录”项目，它为访问Android+SQLite数据库提供了SQLite抽象。它可以在这里获得：http://code.google.com/p/android-active-record|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1211026|它允许在对数据库实体执行CRUD操作时消除大多数样板编码，并使创建/维护数据库结构的工作最小化。|1211027|entityMap|0|LINK|mutability|MUTABLE|url|http://code.google.com/p/android-active-record^0|1P|1A|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

There is an 'android-active-record' project which provides ActiveRecord abstraction for accessing Android SQLite database. 
It's available here: <a href="http://code.google.com/p/android-active-record" rel="noreferrer">http://code.google.com/p/android-active-record</a>

It allows to eliminate most of boilerplate coding when performing CRUD operations on database entities and also minimizes efforts for creating/maintaining a database structure

blocks|key|1135914|text|我是ORMLite的主要作者，它被设计成很小，但仍然提供更高级别的功能。ORMLite调用本地Android数据库API以支持其ORM功能。有关一般信息，请参阅以下内容|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1135915|orm.shtml|blockquote|1135916|下面是一些Android示例应用程序：|1135917|http://ormlite.com/docs/android-examples|1135918|entityMap|0|LINK|mutability|MUTABLE|url|http://ormlite.com/|1|http://ormlite.com/sqlite_java_android_orm.shtml|2^0|2|7|0|0|0|9|1|0|0|0|14|2|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@$A|W|B|X|1|Y]]|C|$]]|$1|D|3|E|5|F|7|Z|8|@]|9|@$A|10|B|11|1|12]]|C|$]]|$1|G|3|H|5|6|7|13|8|@]|9|@]|C|$]]|$1|I|3|J|5|F|7|14|8|@]|9|@$A|15|B|16|1|17]]|C|$]]|$1|K|3|-4|5|6|7|18|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]|S|$5|N|O|P|C|$Q|T]]|U|$5|N|O|P|C|$Q|J]]]]

I am the main author of <a href="http://ormlite.com/" rel="noreferrer">ORMLite</a> which was designed to be small[ish] but still provide higher level functionality. ORMLite makes calls to the native Android OS database APIs to support its ORM functionality. See the following for general information

<blockquote>
 <a href="http://ormlite.com/sqlite_java_android_orm.shtml" rel="noreferrer">http://ormlite.com/sqlite_java_android_orm.shtml</a>
</blockquote>

Here are some Android example applications:

<blockquote>
 <a href="http://ormlite.com/docs/android-examples" rel="noreferrer">http://ormlite.com/docs/android-examples</a>
</blockquote>

blocks|key|1211081|text|看看安德鲁姆。它是开源的，并且有很好的文档(请看这里)。如果您曾经使用django，您会注意到语法非常相似。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1211082|Androrm还支持最常见字段类型的抽象类，以及关系字段。通过这种方式，您可以以非常简单的方式查询您的数据，只需在您这方面做很少的工作。|1211083|entityMap|0|LINK|mutability|MUTABLE|url|http://androrm.com/|1|http://androrm.com/documentation^0|2|4|0|M|4|1|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]|$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]]]

Have a look at <a href="http://androrm.com" rel="nofollow noreferrer">Androrm</a>. It is open source and well documented (<a href="http://androrm.com/documentation" rel="nofollow noreferrer">see here</a>). If you ever worked with django, you will notice, that the syntax is very similar. 

Androrm also supports abstraction classes for the most common field types, plus relational fields. This way it enables you to query for your data in an very easy manner with only very little effort on your side.

blocks|key|1211121|text|我也面临着同样的问题，我查看了和ActiveAndroid。我发现ActiveAndroid没有处理我关心的事情(比如关系)，而且ActiveAndroid也不是免费的。因此，我决定写我自己的图书馆。它被称为AndroidRecord，它是托管在GitHub上，您可以随意使用它(我想我将使用麻省理工学院的许可)。我每天都用这个，我对它很满意，但我很想得到反馈。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1211122|如果您需要知道如何使用它，我正在编写文档。如果你马上就需要它，你可以查看这个蹩脚的例子项目，它应该足够你的脚趾浸入。当然，你也可以给我发电子邮件。|1211123|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/lyudmil/androidrecord|1|https://github.com/lyudmil/polimi^0|3C|A|0|0|10|9|1|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]]|C|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]]]

I faced the same problem and looked at both android-active-record and ActiveAndroid. I found android-active-record didn't handle the things I cared about (relationships for example), and ActiveAndroid isn't free. Therefore, I decided to write my own library. It's called AndroidRecord and it's <a href="https://github.com/lyudmil/androidrecord" rel="nofollow">hosted on GitHub</a> and you're free to do with it what you want (I think I'm going to go with the MIT license). I use this every day and I'm content with it, but I'd love to get feedback.

If you need to know how to use it, I'm working on the documentation. If you need it right away, you can check out <a href="https://github.com/lyudmil/polimi" rel="nofollow">this lame example project</a> which should be enough to dip your toes in. You can also email me of course.

blocks|key|2734402|text|如果性能和大小很重要，那么您应该看看我们的开源ORM工具greenDAO。我们写它是因为我们不想在速度上妥协。其他工具在很大程度上依赖于反射，这在Android上非常缓慢。尽管体积很小(<100+k)，但它支持关系、查询生成器等。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2734403|entityMap|0|LINK|mutability|MUTABLE|url|http://greendao-orm.com/^0|S|8|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

If performance and size matter, you should have a look at our open source ORM tool <a href="http://greendao-orm.com" rel="nofollow">greenDAO</a>. We wrote it because we did not want to compromise on speed. Other tools heavily rely on reflection, which is very slow on Android. Despite the tiny size (&lt;100k), it supports relations, query builders, etc.

blocks|key|1211215|text|一段时间前，我在比较莫来特和绿岛的基础知识。您可能想看看那里。我计划在不久的将来写一些后续的更高级的东西，但就目前而言，它只是一个基本的东西。在我自己的项目中，我使用GreenDAO。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1211216|entityMap|0|LINK|mutability|MUTABLE|url|http://software-workshop.eu/content/comparing-android-orm-libraries-greendao-vs-ormlite^0|S|2|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I was comparing basics of ormlite and greendao some time ago. You might want to take a look <a href="http://software-workshop.eu/content/comparing-android-orm-libraries-greendao-vs-ormlite" rel="nofollow">there</a>. I plan to write some follow up with more advanced stuff in the near future but for now it's only a basic stuff. In my own project I'm using GreenDAO.

blocks|key|1136000|text|无耻的插件，但我一直在开发一个新的开源安卓框架，名为无穷大。它的主要特性之一是ORM，它具有类似Hibernate的标准API和其他一些优秀特性(关联、延迟加载等)。它还处于初级阶段，但我认为进展得很好。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1136001|entityMap|0|LINK|mutability|MUTABLE|url|http://code.google.com/p/infinitum-framework/^0|Q|3|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Shameless plug, but I've been working on a new open source Android framework called <a href="http://code.google.com/p/infinitum-framework/" rel="nofollow">Infinitum</a>. One of its main features is an ORM which has a criteria API similar to Hibernate and a few other nifty features (associations, lazy loading, etc.). It's still in its early stages, but I think it's coming along pretty nicely.

blocks|key|1136016|text|我尝试了Sugar，它非常基本(而且易于使用)，但它满足了我的需要。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1136017|糖网站|offset|length|1136018|entityMap|0|LINK|mutability|MUTABLE|url|http://onsoftwareandstuff.com/2011/08/14/sugar-android-database-made-easy/^0|0|0|3|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

I tried the Sugar ORM, which is very basic (and easy to use) but it worked for my needs.

<a href="http://onsoftwareandstuff.com/2011/08/14/sugar-android-database-made-easy/" rel="noreferrer">Sugar website</a>

blocks|key|2734481|text|我已经为android编写了一个新的ORM，它的目标是尽可能容易地实现。它支持列表和SQL自由迁移--我一直发现这在其他库中有一些开销。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2734482|http://www.rushorm.com/|offset|length|2734483|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|N|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@$D|O|E|P|1|Q]]|A|$]]|$1|F|3|-4|5|6|7|R|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|C]]]]

I have written a new ORM, for android, that's aimed and being as easy as possible to implement. It support lists and SQL free migration a couple things which I always found had an overhead in other libraries.

<a href="http://www.rushorm.com/" rel="nofollow">http://www.rushorm.com/</a>

Are there any good database abstraction layers/object relational mappers/ActiveRecord implementations/whatever they are called for Android? I'm aware that <a href="http://www.db4o.com/Android/default.aspx" rel="noreferrer">db4o</a> is officially supported, but it has quite a large footprint and I'd rather use a more conventional database (<code>SQLite</code>).

Higher level database layer for Android?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

是否有任何良好的数据库抽象层/对象关系映射器/ActiveRecord实现/任何它们对Android的调用？我知道是官方支持的，但是它占用了相当大的内存，我宁愿使用更传统的数据库(SQLite)。

问Android的高级数据库层？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Android的高级数据库层？EN