在Android应用程序中使用sqlite3数据库

发布于 2024-10-29 23:55:36 字数 801 浏览 1 评论 0原文

大家好，我正在尝试使用 sqlite3 数据库在我正在制作的 Android 应用程序中使用。我们制作了一个数据库，其中包含公交车时刻表和公交车站因此，像这样的查询

SELECT DISTINCT M.departure_time, N.trip_headsign
FROM mt_stop_time M, mt_trip N
WHERE (M.stop_id=8338) AND (M.trip_id = N.trip_id) AND (M.day = 'su') 
AND (M.departure_time < 18) AND (M.departure_time >= 15) AND M.trip_id LIKE '%2010_11%' ORDER BY trip_headsign ASC;

将返回类似的内容，

17:26:00 1 SPRING GARDEN TO DARTMOUTH
17:41:00 1 SPRING GARDEN TO DARTMOUTH
17:56:00 1 SPRING GARDEN TO DARTMOUTH
15:26:00 10 WESTPHAL
16:26:00 10 WESTPHAL
17:26:00 10 WESTPHAL
15:13:00 14 DOWNTOWN
16:13:00 14 DOWNTOWN
17:17:00 80 HALIFAX
17:47:00 80 HALIFAX

它显示时间、公交车号、目的地所以我的问题是如何通过 Java 调用 sqlite3，以便我可以在我的应用程序中使用这些信息，以便在用户单击公交车站后显示公交车时刻表时间？

谢谢

原文

Hey guys I am trying to use sqlite3 database to use in this android application I am making.
We have a database we made that has the bus schedule and the bus stops
So the queries like this

SELECT DISTINCT M.departure_time, N.trip_headsign
FROM mt_stop_time M, mt_trip N
WHERE (M.stop_id=8338) AND (M.trip_id = N.trip_id) AND (M.day = 'su') 
AND (M.departure_time < 18) AND (M.departure_time >= 15) AND M.trip_id LIKE '%2010_11%' ORDER BY trip_headsign ASC;

will return something like

17:26:00 1 SPRING GARDEN TO DARTMOUTH
17:41:00 1 SPRING GARDEN TO DARTMOUTH
17:56:00 1 SPRING GARDEN TO DARTMOUTH
15:26:00 10 WESTPHAL
16:26:00 10 WESTPHAL
17:26:00 10 WESTPHAL
15:13:00 14 DOWNTOWN
16:13:00 14 DOWNTOWN
17:17:00 80 HALIFAX
17:47:00 80 HALIFAX

It shows the Time, bus #, destination
So my question is how can I call sqlite3 through Java so I can use these informations for my application to show up the bus schedule time once the user clicks the bus stops?

Thanks

分享到QQ

分享到微博