＆＃x27;。 ＃x27;

Question

请我需要帮助修复上面的错误_在标题_中的第一个选择中出现在此查询之后，欢迎所有建议，因此非常感谢。

       public ArrayList<HashMap<String, String>> getAll_Datas() {
    
        ArrayList<HashMap<String, String>> arrayListAllData = new 
        ArrayList<HashMap<String, String>>();
        SQLiteDatabase database = this.getWritableDatabase();
    
        Cursor cursor = database.rawQuery 

       (
        " SELECT lespontes.idPontes ,\n" +
        "  lespontes.Cage as Cage,\n" +
        " lespontes.Couvés,\n" +
        " dbfécondation.Fécondés " + "FROM " +
        (
                " SELECT idPontes FROM lespontes"+
                        " UNION "
                        + " SELECT idPontes FROM dbfécondation" ) +
        " LEFT OUTER JOIN"
        + " lespontes USING (idPontes)"+
        " LEFT OUTER JOIN "
        + " dbfécondation USING (idPontes)"+
        " Order By " +  " lespontes.Cage " + " ASC ",null);
    
        if (cursor.moveToFirst()) {
            do {
        HashMap<String, String> hashMapData= new HashMap<String, 
        String>();
    
        hashMapData.put("idPontes", cursor.getString(0));
        hashMapData.put("Cage",cursor.getString(1));
        hashMapData.put("Couvés",cursor.getString(2));
        hashMapData.put("Fécondés", cursor.getString(3));

        arrayListAllData.add(hashMapData);
            } while (cursor.moveToNext());
        }
        return arrayListAllData;
        }
    

Answer 1

尝试使用： -

Cursor cursor = database.rawQuery

          (
                  " SELECT lespontes.idPontes ," +
                          "  lespontes.Cage as Cage," +
                          " lespontes.Couvés," +
                          " dbfécondation.Fécondés " + "FROM (" +
                                  " SELECT idPontes FROM lespontes" +
                                          " UNION "
                                          + " SELECT idPontes FROM dbfécondation)" +
                          " LEFT OUTER JOIN"
                          + " lespontes USING (idPontes)" +
                          " LEFT OUTER JOIN "
                          + " dbfécondation USING (idPontes)" +
                          " Order By " + " lespontes.Cage " + " ASC ", null);

IE选择围绕的括号已嵌入SQL中。此外，也已删除了无用的线馈电（\ n）。