blocks|key|848396|text|/data/data/packagename/databases/|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|848397|即|848398|/data/data/com.example.program/databases/|848399|entityMap^0|0|X|0|0|0|15|0^^$0|@$1|2|3|4|5|6|7|L|8|@$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|O|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|P|8|@$9|Q|A|R|B|C]]|D|@]|E|$]]|$1|J|3|-4|5|6|7|S|8|@]|D|@]|E|$]]]|K|$]]

<code>/data/data/packagename/databases/</code>

ie

<code>/data/data/com.example.program/databases/</code>

blocks|key|848443|text|您可以找到已创建的名为<your-database-name>的数据库|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|848444|在……里面|848445|//data/data/<Your-Application-Package-Name>/databases/<your-database-name>|code-block|syntax|javascript|848446|使用文件资源管理器将其拉出，并将其重命名为在SQLiteExplorer中使用的.db3扩展名|848447|使用DDMS的文件资源管理器导航到模拟器目录。|848448|entityMap^0|B|K|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|V|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|W|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|X|8|@]|D|@]|E|$]]|$1|O|3|P|5|6|7|Y|8|@]|D|@]|E|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]]|R|$]]

You can find your created database, named <code>&lt;your-database-name&gt;</code>

in

<pre><code>//data/data/&lt;Your-Application-Package-Name&gt;/databases/&lt;your-database-name&gt;
</code></pre>

Pull it out using File explorer and rename it to have .db3 extension to use it in SQLiteExplorer

Use File explorer of DDMS to navigate to emulator directory.

blocks|key|848470|text|如果你说的是真实的设备，/data/data/<application-package-name>是无法访问的。您必须具有root权限...|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|848471|entityMap^0|C|11|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

If you're talking about real device <code>/data/data/&lt;application-package-name&gt;</code> is unaccessible. You must have root rights...

blocks|key|848502|text|SQLite数据库只是一个文件。您可以获取该文件，移动它，甚至将其复制到另一个系统(例如，从您的手机到您的工作站)，它将工作得很好。安卓将该文件存储在/data/data/packagename/databases/目录中。您可以使用adb+command或Eclipse中的File+Explorer+view+(Window+>+Show+View+>+Other...+>+Android+>+File+Explorer)来查看、移动或删除它。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|848503|entityMap^0|23|X|39|B|3U|I|4E|1J|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]|$9|M|A|N|B|C]|$9|O|A|P|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|G|$]]

A SQLite database is just a file. You can take that file, move it around, and even copy it to another system (for example, from your phone to your workstation), and it will work fine. Android stores the file in the <code>/data/data/packagename/databases/</code> directory. You can use the <code>adb command</code> or the <code>File Explorer view</code> in Eclipse (<code>Window &gt; Show View &gt; Other... &gt; Android &gt; File Explorer</code>) to view, move, or delete it.

blocks|key|1062876|text|为此，我所做的是|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1062877|File+f=new+File("/data/data/your.app.package/databases/your_db.db3");
FileInputStream+fis=null;
FileOutputStream+fos=null;

try
{
++fis=new+FileInputStream(f);
++fos=new+FileOutputStream("/mnt/sdcard/db_dump.db");
++while(true)
++{
++++int+i=fis.read();
++++if(i!=-1)
++++{fos.write(i);}
++++else
++++{break;}
++}
++fos.flush();
++Toast.makeText(this,+"DB+dump+OK",+Toast.LENGTH_LONG).show();
}
catch(Exception+e)
{
++e.printStackTrace();
++Toast.makeText(this,+"DB+dump+ERROR",+Toast.LENGTH_LONG).show();
}
finally
{
++try
++{
++++fos.close();
++++fis.close();
++}
++catch(IOException+ioe)
++{}
}|code-block|syntax|javascript|1062878|为此，您的应用程序必须具有访问SD卡的权限，并将以下设置添加到您的manifest.xml|1062879|<uses-permission+android:name="android.permission.WRITE_EXTERNAL_STORAGE"+/>|1062880|这不是一种很好的方式，但很有效。|1062881|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

For this, what I did is

<pre><code>File f=new File("/data/data/your.app.package/databases/your_db.db3");
FileInputStream fis=null;
FileOutputStream fos=null;

try
{
 fis=new FileInputStream(f);
 fos=new FileOutputStream("/mnt/sdcard/db_dump.db");
 while(true)
 {
 int i=fis.read();
 if(i!=-1)
 {fos.write(i);}
 else
 {break;}
 }
 fos.flush();
 Toast.makeText(this, "DB dump OK", Toast.LENGTH_LONG).show();
}
catch(Exception e)
{
 e.printStackTrace();
 Toast.makeText(this, "DB dump ERROR", Toast.LENGTH_LONG).show();
}
finally
{
 try
 {
 fos.close();
 fis.close();
 }
 catch(IOException ioe)
 {}
}
</code></pre>

And to do this, your app must have permission to access SD card, add following setting to your manifest.xml

<pre><code>&lt;uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" /&gt;
</code></pre>

Not a brilliant way, but works.

blocks|key|848596|text|您还可以检查您的IDE是否具有类似Eclipse的DDMS透视图的实用程序，该实用程序允许您浏览目录和/或将文件复制到Emulator或根设备，以及从Emulator或根设备复制文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|848597|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 can also check whether your IDE has a utility like Eclipse's DDMS perspective which allows you to browse through the directory and/or copy files to and from the Emulator or a rooted device.

blocks|key|848642|text|这是一个古老的问题，但回答可能会对其他人有所帮助。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|848643|非rooted设备无法访问Android保存数据库的默认路径。因此，访问数据库文件(仅适用于调试环境)的最简单方法是修改类的构造函数：|848644|public+class+MySQLiteOpenHelper+extends+SQLiteOpenHelper+{
++++MySQLiteOpenHelper(Context+context)+{
++++++++super(context,+"/mnt/sdcard/database_name.db",+null,+0);
++++}
}|code-block|syntax|javascript|848645|请记住使用以下几行代码更改生产环境：|848646|public+class+MySQLiteOpenHelper+extends+SQLiteOpenHelper+{
++++MySQLiteOpenHelper(Context+context)+{
++++++++super(context,+"database_name.db",+null,+0);
++++}
}|848647|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

This is and old question, but answering may help others.

Default path where Android saves databases can not be accesed on non-rooted devices. So, the easiest way to access to database file (only for debugging environments) is to modify the constructor of the class:

<pre><code>public class MySQLiteOpenHelper extends SQLiteOpenHelper {
 MySQLiteOpenHelper(Context context) {
 super(context, "/mnt/sdcard/database_name.db", null, 0);
 }
}
</code></pre>

Remember to change for production environments with these lines:

<pre><code>public class MySQLiteOpenHelper extends SQLiteOpenHelper {
 MySQLiteOpenHelper(Context context) {
 super(context, "database_name.db", null, 0);
 }
}
</code></pre>

blocks|key|1063035|text|定义数据库名称，如下所示：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1063036|private+static+final+String+DATABASE_NAME+=+"/mnt/sdcard/hri_database.db";|code-block|syntax|javascript|1063037|您可以在以下位置查看您的数据库：|1063038|storage/sdcard0/yourdatabasename.db|1063039|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Define your database name like :

<pre><code>private static final String DATABASE_NAME = "/mnt/sdcard/hri_database.db";
</code></pre>

And you can see your database in :

<pre><code>storage/sdcard0/yourdatabasename.db
</code></pre>

blocks|key|1063063|text|如果您的应用程序创建了一个数据库，则缺省情况下此数据库保存在目录DATA/data/APP_NAME/databases/FILENAME.中|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1063064|上述目录的各个部分是基于以下规则构建的。DATA是Environment.getDataDirectory()方法返回的路径。APP_NAME是您的应用程序名称。FILENAME是您在应用程序代码中为数据库指定的名称。|1063065|entityMap^0|W|12|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|N|8|@]|D|@]|E|$]]]|I|$]]

If your application creates a database, this database is by default saved in the directory <code>DATA/data/APP_NAME/databases/FILENAME.</code>

The parts of the above directory are constructed based on the following rules. DATA is the path which the Environment.getDataDirectory() method returns. APP_NAME is your application name. FILENAME is the name you specify in your application code for the database.

blocks|key|848751|text|如果你将数据库命名为文件而不给出路径，那么获取其文件夹的最常见方法如下：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|848752|final+File+dbFile+=+new+File(getFilesDir().getParent()%2B"/databases/"%2BDBAdapter.DATABASE_NAME);|code-block|syntax|javascript|848753|其中DBAdapter.DATABASE_NAME只是一个类似于"mydatabase.db“的String。|offset|length|style|CODE|848754|Context.getFilesDir()返回应用程序文件的路径，如：/data/data/<your.app.packagename>/files/这就是为什么你需要.getParent()%2B"/databases/"，删除“文件”而添加“数据库”。|848755|顺便说一句，Eclipse将警告您有关硬编码的"data/data/“字符串，但在这种情况下不会。|848756|entityMap^0|0|0|2|N|1C|6|0|0|L|Z|14|2C|Q|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@$I|V|J|W|K|L]|$I|X|J|Y|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|Z|8|@$I|10|J|11|K|L]|$I|12|J|13|K|L]|$I|14|J|15|K|L]]|9|@]|A|$]]|$1|O|3|P|5|6|7|16|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|17|8|@]|9|@]|A|$]]]|R|$]]

If you name your db as a file without giving a path then most common way to get its folder is like:

<pre><code>final File dbFile = new File(getFilesDir().getParent()+"/databases/"+DBAdapter.DATABASE_NAME);
</code></pre>

where <code>DBAdapter.DATABASE_NAME</code> is just a <code>String</code> like "mydatabase.db". <code>Context.getFilesDir()</code> returns path for app's files like: <code>/data/data/&lt;your.app.packagename&gt;/files/</code> thats why you need to <code>.getParent()+"/databases/"</code>, to remove "files" and add "databases" instead. 
BTW Eclipse will warn you about hardcoded "data/data/" string but not in this case.

blocks|key|1063208|text|上下文包含许多路径函数:+Context.getXXXPath()|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1063209|其中之一是android.content.Context.getDatabasePath(String+dbname)，它返回名为dbname的数据库的绝对路径。|1063210|Context+ctx+=+this;+//+for+Activity,+or+Service.+Otherwise+simply+get+the+context.
String+dbname+=+"mydb.db";
Path+dbpath+=+ctx.getDatabasePath(dbname);|code-block|syntax|javascript|1063211|在本例中，返回的路径类似于：|1063212|/data/data/com.me.myapp/databases/mydb.db|1063213|请注意，如果使用SQLiteOpenHelper打开数据库，则会自动生成此路径。|1063214|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

The Context contains many path functions: Context.getXXXPath()
 
One of them is android.content.Context.getDatabasePath(String dbname) that returns the absolute path of a database called dbname.

<pre><code>Context ctx = this; // for Activity, or Service. Otherwise simply get the context.
String dbname = "mydb.db";
Path dbpath = ctx.getDatabasePath(dbname);
</code></pre>

The returned path, in this case, would be something like:

<pre><code>/data/data/com.me.myapp/databases/mydb.db
</code></pre>

Note that this path is autogenerated if using SQLiteOpenHelper to open the DB.

blocks|key|848900|text|By+Default+it+stores+to:++++

String+DATABASE_PATH+=+"/data/data/"+%2B+PACKAGE_NAME+%2B+"/databases/"+%2B+DATABASE_NAME;

Where:

String+DATABASE_NAME+=+"your_dbname";
String+PACKAGE_NAME+=+"com.example.your_app_name";|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|848901|并检查您的数据库是否存储在设备存储中。如果是这样，您必须在Manifest.xml中使用权限：|unstyled|848902|<uses-permission+android:name="android.permission.WRITE_EXTERNAL_STORAGE"+/>|848903|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|L|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$B|C]]|$1|I|3|-4|5|F|7|N|8|@]|9|@]|A|$]]]|J|$]]

<pre><code>By Default it stores to: 

String DATABASE_PATH = "/data/data/" + PACKAGE_NAME + "/databases/" + DATABASE_NAME;

Where:

String DATABASE_NAME = "your_dbname";
String PACKAGE_NAME = "com.example.your_app_name";
</code></pre>

And check whether your database is stored to Device Storage. If So, You have to use permission in Manifest.xml :

<pre><code>&lt;uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" /&gt;
</code></pre>

blocks|key|848978|text|不要像//data/data/<Your-Application-Package-Name>/databases/<your-database-name>那样硬编码路径。它在大多数情况下都可以工作，但在设备可以支持多个用户的设备上就不起作用了。路径可以类似于//data/user/10/<Your-Application-Package-Name>/databases/<your-database-name>。可能的解决方案是使用context.getDatabasePath(<your-database-name>)。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|848979|entityMap^0|3|22|3L|25|61|19|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]|$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|O|8|@]|D|@]|E|$]]]|G|$]]

Do not hardcode path like <code>//data/data/&lt;Your-Application-Package-Name&gt;/databases/&lt;your-database-name&gt;</code>. Well it does work in most cases, but this one is not working in devices where device can support multiple users. The path can be like <code>//data/user/10/&lt;Your-Application-Package-Name&gt;/databases/&lt;your-database-name&gt;</code>. Possible solution to this is using <code>context.getDatabasePath(&lt;your-database-name&gt;)</code>.

blocks|key|1063374|text|您可以找到您的数据库文件：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1063375|Context.getDatabasePath(getDatabaseName())|code-block|syntax|javascript|1063376|来自类SQLiteOpenHelper的getDatabaseName|1063377|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

You can find your database file :
<pre><code>Context.getDatabasePath(getDatabaseName())
</code></pre>
getDatabaseName from class SQLiteOpenHelper

blocks|key|1063421|text|在kotlin中，你可以这样找到它：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1063422|++++val+data:+File+=+Environment.getDataDirectory()
++++val+currentDBPath+=+"//data//$packageName//databases//"
++++val+destDir+=+File(data,+currentDBPath)|code-block|syntax|javascript|1063423|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

In kotlin you can find it in this way:
<pre><code> val data: File = Environment.getDataDirectory()
 val currentDBPath = &quot;//data//$packageName//databases//&quot;
 val destDir = File(data, currentDBPath)
</code></pre>

blocks|key|849171|text|@Shardul的答案是正确的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|849172|除此之外，新的Android+Studio有一个名为App+Inspection的工具，你可以直接查看数据库。|849173|Android+Studio的版本如下：|849174|Android+Studio+Arctic+Fox+%7C+2020.3.1+Patch+3
Build+#AI-203.7717.56.2031.7784292,+built+on+October+1,+2021|code-block|syntax|javascript|849175|​|849176|📷|atomic|offset|length|849177|849178|849179|849180|849181|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/9792afc82d000f6ec97c5e2bc9534475.png|imageAlt|1|https://ask.qcloudimg.com/http-save/yehe-900000/ac3224eb24ab42fbc51f933ad1fbc4f6.png^0|0|0|0|0|0|0|1|0|0|0|0|0|1|1|0|0^^$0|@$1|2|3|4|5|6|7|16|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|17|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|18|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|19|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|1A|8|@]|9|@]|A|$]]|$1|M|3|N|5|O|7|1B|8|@]|9|@$P|1C|Q|1D|1|1E]]|A|$]]|$1|R|3|L|5|6|7|1F|8|@]|9|@]|A|$]]|$1|S|3|L|5|6|7|1G|8|@]|9|@]|A|$]]|$1|T|3|N|5|O|7|1H|8|@]|9|@$P|1I|Q|1J|1|1K]]|A|$]]|$1|U|3|L|5|6|7|1L|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|1M|8|@]|9|@]|A|$]]]|W|$X|$5|Y|Z|10|A|$11|12|13|-4]]|14|$5|Y|Z|10|A|$11|15|13|-4]]]]

@Shardul's answer is correct.
Besides that, new Android Studio has a tool called: App Inspection, which you can view database directly.
Here is the version of Android Studio:
<pre><code>Android Studio Arctic Fox | 2020.3.1 Patch 3
Build #AI-203.7717.56.2031.7784292, built on October 1, 2021
</code></pre>
<a href="https://i.stack.imgur.com/xZPbF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xZPbF.png" alt="enter image description here" /></a>
<a href="https://i.stack.imgur.com/N7lS3.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/N7lS3.png" alt="enter image description here" /></a>

I've created a sqlite database programmatically with the default way of extending <code>SQLiteOpenHelper</code> and overriding <code>onCreate()</code>. This way the db gets created on the fly when needed.

I'd like to check the contents of the db file on my OS X machine with a sqlite browser.
I know the name of the db file, but I can't find it on the device. I've connected to the device via USB and looked with finder and terminal, but I just can't find the db file. 

What is the default location for a sqlite databases on an android device?

Location of sqlite database on the device

Android Studio

文件存储

数据库

Android

Eclipse

SQLite

我已经使用扩展SQLiteOpenHelper和覆盖onCreate()的默认方式以编程方式创建了一个sqlite数据库。这样，就可以在需要时即时创建数据库。我想用sqlite浏览器在我的OS X机器上检查db文件的内容。我知道数据库文件的名称，但在设备上找不到它。我已经通过USB连接到了这个设备，并且用finder和...

问sqlite数据库在设备上的位置
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问sqlite数据库在设备上的位置EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问sqlite数据库在设备上的位置
EN