如何在Android上读取数据库？
我是数据库新手，并且已经阅读了各种教程，但它们都教我如何创建数据库以及如何插入和删除数据库。我已经有一个 data.db 文件，不需要更改，只需从中读取。第一列是日期和时间，其余是有关当时发生的情况的信息。用户输入他们感兴趣的开始时间和结束时间，或者选择全部，然后以图形方式显示该数据。 我该如何做这个数据库方面的工作呢？我需要研究哪些方法？
I'm new to databases and have been going through various tutorials, but they all teach me how to create databases, and insert and remove from them. I already have a data.db file that I will not need to change, only read from it. The first column is a date and time, and the rest are information regarding what happened then. The user inputs a start time and end time that they are interested in, or selects all, and that data is displayed graphically.
How do I do this database aspect of it? What methods do I need to look into?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
这是一个非常好的基础教程，可能会对您有所帮助 - http://www.vogella .de/articles/AndroidSQLite/article.html#todo_database
您应该检查 fetchAllTodos() 和 fetchTodo(long rowId) 函数并尝试获取您的记录。您可以进一步了解如何向 sqlite 查询添加约束（例如 WHERE startTime > userStartTime AND endTime < userEndTime）
This is a very good basic tutorial that might help you - http://www.vogella.de/articles/AndroidSQLite/article.html#todo_database
You should inspect fetchAllTodos() and fetchTodo(long rowId) functions and try fetching your records. You could look further to see how to add constraints to your sqlite query (something like WHERE startTime > userStartTime AND endTime < userEndTime)
Android 开发者网站还提供了一个很好的快速参考 SQLite实现
Also the Android Developer's site provide a good quick reference of SQLite implementation