android.database.sqlite.SQLiteException：near“SELECT”：语法错误(代码1):,同时编译：SELECT * FROM Table_Name

我得到 android.database.sqlite.sqliteException：接近“SELECT”：语法错误(代码1):,同时编译：SELECT * FROM Universities错误.

我有以下课程

用户类为

public class User {
    privatE int univ_id;

    private String univ_name,univ_abbr;

    public User(int univ_id,String univ_name,String univ_abbr) {

        thi@R_673_11163@niv_id = univ_id;
        thi@R_673_11163@niv_name = univ_name;
        thi@R_673_11163@niv_abbr = univ_abbr;
    }

    public User(String univ_name,String univ_abbr) {

        thi@R_673_11163@niv_name = univ_name;
        thi@R_673_11163@niv_abbr = univ_abbr;
    }

    public User() {
        // TODO Auto-generated constructor stub
    }

    public int getUniv_id() {
        return univ_id;
    }

    public void setUniv_id(int univ_id) {
        thi@R_673_11163@niv_id = univ_id;
    }

    public String getUniv_name() {
        return univ_name;
    }

    public void setUniv_name(String univ_Name) {
        thi@R_673_11163@niv_name = univ_name;
    }

    public String getUniv_abbr() {
        return univ_abbr;
    }

    public void setUniv_abbr(String univ_abbr) {
        thi@R_673_11163@niv_abbr = univ_abbr;
    }
}@H_262_12@ 
 
DBStorageFirst Class as
 
 
 
 
public class DBStorageFirst extends sqliteOpenHelper {

    public static final String DATABASE_NAME = "stuPIDSID_OFFLINE_DB";

    public static final String table_NAME_UNIVERSITIES = "universities";


    public static final String columN_UNIV_ID = "univ_id";
    public static final String columN_UNIV_NAME = "univ_name";
    public static final String columN_UNIV_ABBR = "univ_abbr";

    public DBStorageFirst(Context context) {
        super(context,DATABASE_NAME,null,1);
    }

    @Override
    public void onCreate(sqliteDatabase db) {
        // TODO Auto-generated method stub
        db.execsql("create table " + TABLE_NAME_UNIVERSITIES
                + "(" + columN_UNIV_ID + " Integer RIMary KEY," + columN_UNIV_NAME
                + " text," + columN_UNIV_ABBR + " text )");
        Log.e("success","Universities Table Created");

    }

    @Override
    public void onUpgrade(sqliteDatabase db,@R_616_1648@,int newVersion) {
        // TODO Auto-generated method stub
        db.execsql("drop table IF EXISTS " + TABLE_NAME_UNIVERSITIES);

        onCreate(db);
    }

    public void addUniversities(int univ_id,String univ_abbr) {
         sqliteDatabase db = this.getWritableDatabase();
        String sql1 = "insert into " + DBStorageFirst.TABLE_NAME_UNIVERSITIES
                + " (" + DBStorageFirst.columN_UNIV_ID + ","
                + DBStorageFirst.columN_UNIV_NAME + ","
                + DBStorageFirst.columN_UNIV_ABBR + ")" + " values(" + univ_id
                + ",'" + univ_name + " ','" + univ_abbr + "')";
        db.execsql(sql1);
        // database.execsql(sql2);
        Log.e("success","Data inserted successfully into Universities Table");
    }

    public List<User> getAllContacts() {
        List<User> contactList = new ArrayList<User>();

        String SELEctQuery = "SELECT * FROM "+TABLE_NAME_UNIVERSITIES;
        sqliteDatabase db1 = this.getWritableDatabase();
        cursor cursor = db1.rawQuery(SELEctQuery,null);
        if (cursor.moveToFirst()) {
            do {
                User contact = new User();
                contact.setUniv_id(Integer.parseInt(cursor.getString(0)));
                contact.setUniv_name(cursor.getString(1));
                contact.setUniv_abbr(cursor.getString(2));
                contactList.add(contact);
            } while (cursor.moveToNext());
        }
        return contactList;
    }
}@H_262_12@ 
 
和MainActivity一样
 
 
 
 
DBStorageFirst db = new DBStorageFirst(this);

// InserTing Contacts
Log.d("Insert: ","InserTing ..");
db.addUniversities(25,"ABC","UA");
db.addUniversities(26,"DEF","UB");
List<User> list = new ArrayList<User>();
list = db.getAllContacts();

for (User cn : list) {
    String log = "Id: " + cn.getUniv_id() + ",Name: "
            + cn.getUniv_name() + ",Abbr: " + cn.getUniv_abbr();
    // WriTing Contacts to log
    Log.d("Name: ",log);
}@H_262_12@