blocks|key|4637784|text|要设置数据库，请执行以下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4637785|4637786|创建新的SQLite数据库的推荐方法是创建SQLiteOpenHelper的子类并覆盖onCreate()方法，在该方法中可以执行SQLite命令在数据库中创建表。|blockquote|offset|length|style|CODE|4637787|4637788|4637789|要使用它：|4637790|4637791|您可以使用SQLiteDatabase+query()方法执行SQLite查询，这些方法接受各种查询参数，例如要查询的表、投影、选择、列、分组等。对于复杂的查询，比如那些需要列别名的查询，您应该使用SQLiteQueryBuilder，它为构建查询提供了几种方便的方法。|4637792|4637793|4637794|4637795|资源:|BOLD|4637796|4637797|developer.android.com+-+Data+Storage|unordered-list-item|4637798|4637799|entityMap|0|LINK|mutability|MUTABLE|url|http://developer.android.com/reference/android/database/sqlite/SQLiteOpenHelper.html|1|http://developer.android.com/reference/android/database/sqlite/SQLiteOpenHelper.html#onCreate%2528android.database.sqlite.SQLiteDatabase%2529|2|http://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html|3|http://developer.android.com/reference/android/database/sqlite/SQLiteQueryBuilder.html|4|http://developer.android.com/guide/topics/data/data-storage.html^0|0|0|L|G|17|A|L|G|0|17|A|1|0|0|0|0|0|5|E|K|7|2R|I|5|M|2|2R|I|3|0|0|0|0|0|3|0|0|0|10|4|0|0^^$0|@$1|2|3|4|5|6|7|1H|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|1J|8|@$F|1K|G|1L|H|I]|$F|1M|G|1N|H|I]]|9|@$F|1O|G|1P|1|1Q]|$F|1R|G|1S|1|1T]]|A|$]]|$1|J|3|-4|5|6|7|1U|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|1V|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|1W|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|1X|8|@]|9|@]|A|$]]|$1|O|3|P|5|E|7|1Y|8|@$F|1Z|G|20|H|I]|$F|21|G|22|H|I]|$F|23|G|24|H|I]]|9|@$F|25|G|26|1|27]|$F|28|G|29|1|2A]]|A|$]]|$1|Q|3|-4|5|6|7|2B|8|@]|9|@]|A|$]]|$1|R|3|-4|5|6|7|2C|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|2D|8|@]|9|@]|A|$]]|$1|T|3|U|5|6|7|2E|8|@$F|2F|G|2G|H|V]]|9|@]|A|$]]|$1|W|3|-4|5|6|7|2H|8|@]|9|@]|A|$]]|$1|X|3|Y|5|Z|7|2I|8|@]|9|@$F|2J|G|2K|1|2L]]|A|$]]|$1|10|3|-4|5|6|7|2M|8|@]|9|@]|A|$]]|$1|11|3|-4|5|6|7|2N|8|@]|9|@]|A|$]]]|12|$13|$5|14|15|16|A|$17|18]]|19|$5|14|15|16|A|$17|1A]]|1B|$5|14|15|16|A|$17|1C]]|1D|$5|14|15|16|A|$17|1E]]|1F|$5|14|15|16|A|$17|1G]]]]

To set up your database :

<blockquote>
 The recommended method to create a new SQLite database is to create a subclass of <a href="http://developer.android.com/reference/android/database/sqlite/SQLiteOpenHelper.html" rel="nofollow"><code>SQLiteOpenHelper</code></a> and override the <a href="http://developer.android.com/reference/android/database/sqlite/SQLiteOpenHelper.html#onCreate%28android.database.sqlite.SQLiteDatabase%29" rel="nofollow"><code>onCreate()</code></a> method, in which you can execute a SQLite command to create tables in the database.
</blockquote>

To use it :

<blockquote>
 You can execute SQLite queries using the <a href="http://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html" rel="nofollow"><code>SQLiteDatabase</code> <code>query()</code></a> methods, which accept various query parameters, such as the table to query, the projection, selection, columns, grouping, and others. For complex queries, such as those that require column aliases, you should use <a href="http://developer.android.com/reference/android/database/sqlite/SQLiteQueryBuilder.html" rel="nofollow"><code>SQLiteQueryBuilder</code></a>, which provides several convienent methods for building queries.
</blockquote>

<hr>

Resources :

<ul>
<li><a href="http://developer.android.com/guide/topics/data/data-storage.html" rel="nofollow">developer.android.com - Data Storage</a></li>
</ul>

blocks|key|3227396|text|看看这里：http://developer.android.com/guide/topics/data/data-storage.html#db|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3227397|您应该使用扩展SQLiteOpenHelper：http://developer.android.com/reference/android/database/sqlite/SQLiteOpenHelper.html的自定义类|style|CODE|3227398|它为你提供了像onCreate，onOpen和onUpgrade这样非常有用的方法。|3227399|entityMap|0|LINK|mutability|MUTABLE|url|http://developer.android.com/guide/topics/data/data-storage.html#db|1|http://developer.android.com/reference/android/database/sqlite/SQLiteOpenHelper.html^0|5|1V|0|0|7|G|O|2C|1|0|7|8|G|6|N|9|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]]|C|$]]|$1|D|3|E|5|6|7|X|8|@$A|Y|B|Z|F|G]]|9|@$A|10|B|11|1|12]]|C|$]]|$1|H|3|I|5|6|7|13|8|@$A|14|B|15|F|G]|$A|16|B|17|F|G]|$A|18|B|19|F|G]]|9|@]|C|$]]|$1|J|3|-4|5|6|7|1A|8|@]|9|@]|C|$]]]|K|$L|$5|M|N|O|C|$P|Q]]|R|$5|M|N|O|C|$P|S]]]]

Take a look here: <a href="http://developer.android.com/guide/topics/data/data-storage.html#db" rel="nofollow">http://developer.android.com/guide/topics/data/data-storage.html#db</a>

You should use a custom class extending <code>SQLiteOpenHelper</code>: <a href="http://developer.android.com/reference/android/database/sqlite/SQLiteOpenHelper.html" rel="nofollow">http://developer.android.com/reference/android/database/sqlite/SQLiteOpenHelper.html</a>

It gives you methods like <code>onCreate</code>, <code>onOpen</code> and <code>onUpgrade</code> which are very useful.

blocks|key|3227309|text|你用的是Java吗。你可以看看http://www.zentus.com/sqlitejdbc/|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3227310|entityMap|0|LINK|mutability|MUTABLE|url|http://www.zentus.com/sqlitejdbc/^0|F|X|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]]]]

Are you using Java.
You can have a look <a href="http://www.zentus.com/sqlitejdbc/" rel="nofollow">http://www.zentus.com/sqlitejdbc/</a>

blocks|key|1133331|text|Android有一个名为SqliteOpenHelper的类，你可以在sqlite上使用java创建和通信(进行读/写操作)。一旦你开始在网上搜索，你就可以找到很多样本。这里就有一个这样的例子。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1133332|http://www.reigndesign.com/blog/using-your-own-sqlite-database-in-android-applications/|1133333|如果你想打开你的数据库，你可以使用Firefox+，它可以作为一个插件与一起使用。它有一个简单的界面，所以你可以直接加载你的数据库并进行检查。|BOLD|1133334|entityMap|0|LINK|mutability|MUTABLE|url^0|C|G|0|0|2F|0|0|10|Z|0^^$0|@$1|2|3|4|5|6|7|R|8|@$9|S|A|T|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|U|8|@]|D|@$9|V|A|W|1|X]]|E|$]]|$1|H|3|I|5|6|7|Y|8|@$9|Z|A|10|B|J]]|D|@]|E|$]]|$1|K|3|-4|5|6|7|11|8|@]|D|@]|E|$]]]|L|$M|$5|N|O|P|E|$Q|G]]]]

Android has a class named <code>SqliteOpenHelper</code> using which you can create and communicate(do read / write operations) on sqlite using java. You can find many samples once you start searching in net. Here is one such sample. 

<a href="http://www.reigndesign.com/blog/using-your-own-sqlite-database-in-android-applications/" rel="nofollow">http://www.reigndesign.com/blog/using-your-own-sqlite-database-in-android-applications/</a> 

If you want to open your database you can use Sqlite Manager which is available with Firefox as a Addon. It has a easy interface so that you can load your database directly and check .

blocks|key|3227491|text|如果您计划创建一个新的SQLite数据库，那么覆盖并实现onCreate()方法。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3227492|但是，如果您使用的是由另一个外部源创建的SQLite数据库，并且您打算将其删除，则将onCreate()方法留空。|3227493|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

If you are planning to create a new SQLite database then over ride and implement the onCreate() Method.

But if you are using a SQLite database that is created by another external source and you are going to pull it down, then leave the onCreate() method empty.

blocks|key|1133417|text|您可能会看到Linux，它是一个免费的SQLite，有多种版本可供使用。我强烈推荐它。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1133418|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

You might look at SQLite Manager, which is a free GUI and available in a Linux variety. I highly recommend it.

Sorry I am a noob, I am trying to learn about sqlite databases using linux, I cannot find any tutorial that covers what I need from setup to creating to using. At the moment tutorials I find say open a shell using adb shell command but when I open a terminal this does not work even if I navigate to the android tools folder, I can get the sqlite command working but the tutorials dont explain how I use it. For instance, how do I store urls and map coordinates and how to I reference them.

I have tried to use the firefox plugin but I havent got a clue what it all means and every tutorial says sqlite database is easy but it seems so complicated.......HELP!!!!

P.S would it be possible to create the data within the application code, I have seen some apps that do this 

Does anyone have a set up guide and tutorial that can help?

Setting up sqlite database

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

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

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

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

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

对不起，我是一个菜鸟，我正在尝试学习使用linux的sqlite数据库，我找不到任何教程，涵盖了我需要的从安装到创建到使用。目前，我发现教程说使用adb shell命令打开一个shell，但当我打开一个终端时，即使我导航到android工具文件夹，这也不起作用，我可以让sqlite命令工作，但是教程没有解释我是如何使用它的。例如，如何存储urls和地图坐标以及如何引用它们。我试过使用firefox

问设置sqlite数据库
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问设置sqlite数据库EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问设置sqlite数据库
EN