Get Started

1. 다운로드

• download

1. 설치하기

• 제공된 jar 파일을 복사하여 eclipse 프로젝트에 붙여 넣기 후, 빌드 패스를 설정하고 사용하면 된다.
• 설치방법 자세히 보기

1. Cookbook You'll find some wireloop recipes here!
2. 샘플프로젝트

• create
  Usage example:

  DatabaseOpenHelper databaseHelper = new DatabaseOpenHelper(this);
  EntityManager em = EntityManagerFactory.getEntityManager();
  entityManager.createTable(My.class);
  

  And without any SQL code:

  @Override
  public void onCreate(SQLiteDatabase db) {
  db.execSQL("CREATE TABLE " + NOTES_TABLE_NAME + " ("
  + Notes._ID + " INTEGER PRIMARY KEY,"
  + Notes.TITLE + " TEXT,"
  + Notes.NOTE + " TEXT,"
  + Notes.CREATED_DATE + " INTEGER,"
  + Notes.MODIFIED_DATE + " INTEGER"
  + ");");
  }
  @Override
  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  Log.w(TAG, "Upgrading database from version " + oldVersion + " to "
  + newVersion + ", which will destroy all old data");
  db.execSQL("DROP TABLE IF EXISTS notes");
  onCreate(db);
  }
  

• insert / update
  Usage example:

  EntityManager em = EntityManagerFactory.getEntityManager();
  em.getTransaction().begin();
  MyClass my = new MyClass(“something”);
  em.persist(my);
  em.getTransaction().commit();
  

  And without any SQL code:

  @Override
  public Uri insert(Uri uri, ContentValues initialValues) {
  // Validate the requested uri
  if (sUriMatcher.match(uri) != NOTES) {
  throw new IllegalArgumentException("Unknown URI " + uri);
  }
  ContentValues values;
  if (initialValues != null) {
  values = new ContentValues(initialValues);
  } else {
  values = new ContentValues();
  }
  Long now = Long.valueOf(System.currentTimeMillis());
  // Make sure that the fields are all set
  if (values.containsKey(NotePad.Notes.CREATED_DATE) == false) {
  values.put(NotePad.Notes.CREATED_DATE, now);
  }
  if (values.containsKey(NotePad.Notes.MODIFIED_DATE) == false) {
  values.put(NotePad.Notes.MODIFIED_DATE, now);
  }
  if (values.containsKey(NotePad.Notes.TITLE) == false) {
  Resources r = Resources.getSystem();
  values.put(NotePad.Notes.TITLE, r.getString(android.R.string.untitled));
  }
  if (values.containsKey(NotePad.Notes.NOTE) == false) {
  values.put(NotePad.Notes.NOTE, "");
  }
  SQLiteDatabase db = mOpenHelper.getWritableDatabase();
  long rowId = db.insert(NOTES_TABLE_NAME, Notes.NOTE, values);
  if (rowId > 0) {
  Uri noteUri = ContentUris.withAppendedId(NotePad.Notes.CONTENT_URI, rowId);
  getContext().getContentResolver().notifyChange(noteUri, null);
  return noteUri;
  }
  throw new SQLException("Failed to insert row into " + uri);
  }
  

• delete
  Usage example:

  DatabaseOpenHelper databaseHelper = new DatabaseOpenHelper(this);
  EntityManager em = EntityManagerFactory.getEntityManager();
  entityManager.dropTable(My.class);
  

  And without any SQL code:

  @Override
  public int delete(Uri uri, String where, String[] whereArgs) {
  SQLiteDatabase db = mOpenHelper.getWritableDatabase();
  int count;
  switch (sUriMatcher.match(uri)) {
  case NOTES:
  count = db.delete(NOTES_TABLE_NAME, where, whereArgs);
  break;
  case NOTE_ID:
  String noteId = uri.getPathSegments().get(1);
  count = db.delete(NOTES_TABLE_NAME, Notes._ID + "=" + noteId
  + (!TextUtils.isEmpty(where) ? " AND (" + where + ')' : ""), whereArgs);
  break;
  default:
  throw new IllegalArgumentException("Unknown URI " + uri);
  }
  getContext().getContentResolver().notifyChange(uri, null);
  return count;
  }
  

1. Troubleshooting
2. [JPA 공부방](JPA 공부방)