安卓获取本地时间插入sqlite_Android 本地SQLite创建database

Android 可以在本地创建数据库-SQLite, 是一种轻型的数据库，是设计目标是嵌入式，具有占用资源非常低等特点

创建数据库和数据表：DatabaseHelper.java

public class DatabaseHelper extends SQLiteOpenHelper {

// Logcat tag

private static final String LOG = "DatabaseHelper";

// Database Version

private static final int DATABASE_VERSION = 1;

// Database Name

private static final String DATABASE_NAME = "contactsManager";

// Table Names

private static final String TABLE_TODO = "todos";

// Common column names

private static final String KEY_ID = "id";

private static final String KEY_CREATED_AT = "created_at";

// NOTES Table - column nmaes

private static final String KEY_TODO = "todo";

private static final String KEY_STATUS = "status";

// Table Create Statements

// Todo table create statement

private static final String CREATE_TABLE_TODO = "CREATE TABLE "

+ TABLE_TODO + "(" + KEY_ID + " INTEGER PRIMARY KEY," + KEY_TODO

+ " TEXT," + KEY_STATUS + " INTEGER," + KEY_CREATED_AT

+ " DATETIME" + ")";

public DatabaseHelper(Context context) {

super(context, DATABASE_NAME, null, DATABASE_VERSION);

}

@Override

public void onCreate(SQLiteDatabase db) {