創建表

//創建表
    create table student(sid integer primary key autoincrement not null,
gender varchar(20)  not null,
score  integer  not null);

增

insert into student(sname,gender,score) values('Li','male',88);



CREATE TABLE Cars(Id integer PRIMARY KEY, Name text, Cost integer);
INSERT INTO Cars VALUES(1,'Audi',52642);

刪

delete from student where sid=3;

改

update student set score=100,gender='male' where sname='Mike';

查

select * from student;
select * from student where gender='female';
//模糊查詢
select * from student where sname like '%a%';
select * from student where sname like 'a%';
//排序查詢
select * from student order by score desc;    降序
select * from student order by score；         默認升序
select * from student order by score asc;    升序

報錯：

android.database.sqlite.SQLiteException: no such column: (Sqlite code 1)

AndroidRuntime: FATAL EXCEPTION: main
  Process: com.xq.mygreendao, PID: 1742
 android.database.sqlite.SQLiteException: no such column: 許強 (Sqlite code 1): , while compiling: insert into user(name,age,sex,salary) values(許強,18,男,160000), (OS error - 2:No such file or directory)
 at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:925)
at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:536)
at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:603)
 at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:63)
    at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
   at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1965)
    at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1890)
    at com.xq.mygreendao.db.helper.UserSqlUtils.insertSQL(UserSqlUtils.java:52)
    at com.xq.mygreendao.MainActivity.insertSql(MainActivity.java:256)
     at com.xq.mygreendao.MainActivity.onClick(MainActivity.java:125)
        at android.view.View.performClick(View.java:5647)
       at android.view.View$PerformClick.run(View.java:22479)
        at android.os.Handler.handleCallback(Handler.java:761)
        at android.os.Handler.dispatchMessage(Handler.java:98)
        at android.os.Looper.loop(Looper.java:156)
          at android.app.ActivityThread.main(ActivityThread.java:6623)
      at java.lang.reflect.Method.invoke(Native Method)
        at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:942)
       at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:832)

檢查建表字段的類型，然后打印輸出的語句是否符合：

字段都為字符串。

 public void insertSQL(String name, String age, String sex, String salary) {
        SQLiteDatabase db = DBHelper.getInstance(context).getReadableDatabase();
        //String stu_sql="insert into user(name,age,sex,salary) values('許強','18','男','12700')";
        String strSql = "insert into " + UserTableUtil.TABLE_NAME +
                "(" + UserTableUtil.NAME + "," + UserTableUtil.AGE + "," + UserTableUtil.SEX + "," + UserTableUtil.SALARY + ")" +
                " values('" + name + "','" + age + "','" + sex + "','" + salary + ")";
        Log.e("UserSqlUtils", "插入數據====" + strSql);
        db.execSQL(strSql);
    }

打印log：

insert into user(name,age,sex,salary) values('許強','18','男','500000)

發現最后少了一個單引號

修改后：

 public void insertSQL(String name, String age, String sex, String salary) {
        SQLiteDatabase db = DBHelper.getInstance(context).getReadableDatabase();
        //String stu_sql="insert into user(name,age,sex,salary) values('許強','18','男','12700')";
        String strSql = "insert into " + UserTableUtil.TABLE_NAME +
                "(" + UserTableUtil.NAME + "," + UserTableUtil.AGE + "," + UserTableUtil.SEX + "," + UserTableUtil.SALARY + ")" +
                " values('" + name + "','" + age + "','" + sex + "','" + salary + "')";
        Log.e("UserSqlUtils", "插入數據====" + strSql);
        db.execSQL(strSql);
    }

再次運行打印log：

insert into user(name,age,sex,salary) values('許強','18','男','500000')