Android Sqlite 链表查询语句

来源：互联网发布：骁龙835支持5g网络吗编辑：程序博客网时间：2024/04/26 12:57

安卓有时候需要用到本地数据库存储数据，用到数据库就会用到增删改查的方法，本文主要讲本地多表查询的语句。

需求是:查询一条服务的签名，根据航班表（ACCA_FLIGHT）中的_flight_seq字段和服务表（ACCA_SERVICE）中的_link_flight_id字段查询，然后判断_operationState字段不为空，并且排序，如果相同则符合条件，把查询出来的数据添加到自定义的list集合中。

 /**     * 查询服务签名，根据航班fligth_seq查询，并显示签名预览     *     * @param flightSeq 航班的唯一标识     * @return list集合 包涵所有服务信息     */    public List<EyeInfo.FlightDataBean.SignInfoBean> selectServiceSign(String flightSeq) {        List<EyeInfo.FlightDataBean.SignInfoBean> signList = new ArrayList<>();        SQLiteDatabase db = getReadableDatabase();        Cursor cursor = db.rawQuery("select  a._item_name ,a._item_value,a._end_time,a._server_sign,a._service_seq,a._start_time  from ACCA_SERVICE as a INNER JOIN ACCA_FLIGHT as b ON b._flight_seq = a._link_flight_id where a._link_flight_id = ? and a._operationState is not ? order by a._update_time desc ", new String[]{flightSeq,"D"});        while (cursor.moveToNext()) {            EyeInfo.FlightDataBean.SignInfoBean signInfoBean = new EyeInfo.FlightDataBean.SignInfoBean();            //判断，如果签名字段为空的， 就不把这条服务信息添加的list集合中            if (cursor.getString(cursor.getColumnIndex("_server_sign")) != null) {                signInfoBean.setEnd_Time(cursor.getString(cursor.getColumnIndex("_end_time")));                signInfoBean.setItem_Name(cursor.getString(cursor.getColumnIndex("_item_name")));                signInfoBean.setItem_Value(cursor.getString(cursor.getColumnIndex("_item_value")));                signInfoBean.setServer_Sign(cursor.getString(cursor.getColumnIndex("_server_sign")));                signInfoBean.setService_Seq(cursor.getString(cursor.getColumnIndex("_service_seq")));                signInfoBean.setStart_Time(cursor.getString(cursor.getColumnIndex("_start_time")));                signList.add(signInfoBean);            }        }        db.close();        return signList;    }

记录一下。

0 0