Android Open Source - AndroidSqlite Register

• Back to SQLite/example  ↑

From Project

Back to project page AndroidSqlite.

License

The source code is released under:

Apache License

Java Source Code

package org.ffmmx.example.androidsqlite2.business;
/*w w w.ja  va 2s.c  o  m*/
import java.text.SimpleDateFormat;

import org.ffmmx.example.androidsqlite2.domain.User;

import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

public class Register {
  public static boolean register(SQLiteDatabase db, User user) {
    boolean result = false;

    SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");

    ContentValues values = new ContentValues();
    values.put("username", user.getUsername());
    values.put("password", user.getPassword());
    values.put("email", user.getEmail());
    values.put("birth", sdf.format(user.getBirth()));
    values.put("name", user.getName());

    if (!isAvailableUser(db, user.getUsername())) {
      throw new RuntimeException("??????????");
    }
    db.beginTransaction();
    long count = db.insert("t_user", null, values);
    db.setTransactionSuccessful();
    db.endTransaction();
    if (count > 0)
      result = true;
    return result;
  }

  public static boolean isAvailableUser(SQLiteDatabase db, String username) {
    long count = 0;
    Cursor cur = db.query("t_user", new String[] { "id" }, "username=?",
        new String[] { username }, null, null, null);
    count = cur.getCount();
    if (count > 0)
      return false;
    else
      return true;
  }
}

Java Source Code List

• Back to SQLite/example  ↑