@Override
public void onClick(View view) {
switch (view.getId()) {
case R.id.bt:
DatabaseHelper myDbHelper = new DatabaseHelper(this);
usuario = et.getText().toString();
try {
myDbHelper.createDatabase();
} catch (Exception e) {
throw new Error("No se creo");
}
try {
myDbHelper.openDataBase();
SQLiteDatabase db = myDbHelper.getWritableDatabase();
ContentValues valores = new ContentValues();
valores.put("dni", "009");
valores.put("nombre", usuario);
valores.put("apellido", "NH");
db.insert("usuarios", null, valores);
db.close();
myDbHelper.close();
} catch (SQLException sqle) {
throw sqle;
}
break;
case R.id.bt2:
DatabaseHelper myDbHelper2 = new DatabaseHelper(this);
usuario = et.getText().toString();
try {
myDbHelper2.createDatabase();
} catch (Exception e) {
throw new Error("No se pudo crear");
}
try {
myDbHelper2.openDataBase();
Cursor cursor = myDbHelper2.buscarusuario(usuario);
if (cursor != null) {
tv1.setText(cursor.getString(0));
tv2.setText(cursor.getString(1));
cursor.close();
myDbHelper2.close();
} else {
cursor.close();
myDbHelper2.close();
}
} catch (Exception e) {
}
break;
default:
break;
}
}
@Override
protected void onStop() {
super.onStop();
// TODO something goes wrong with the spinner
// close cursors
if (cursorBusLineNames != null) {
cursorBusLineNames.close();
}
// close adapters
if ((adapterBusLineNames != null) && (adapterBusLineNames.getCursor() != null)) {
adapterBusLineNames.getCursor().close();
adapterBusLineNames = null;
}
if ((adapterLineSearch != null) && (adapterLineSearch.getCursor() != null)) {
adapterLineSearch.getCursor().close();
adapterLineSearch = null;
}
// close database helper
if (dbhelper != null) {
dbhelper.close();
}
// store position state of spinner to SharedPreferences
// SettingsHelper.saveSpinnerVehicleCategoryPosition(
// getApplicationContext(), vehicleCatSpinnerSelIndex);
Log.d(TAG, "onPause()");
}
@Override
protected void onPostExecute(final Boolean success) {
mAuthTask = null;
if (success) {
String[] registerMsg = RegisterMsg.split(":");
DatabaseHelper dbHelper = new DatabaseHelper(RegisterActivity.this, "iPin");
SQLiteDatabase db = dbHelper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("ID", registerMsg[1]);
values.put("username", register_name_str);
values.put("password", MD5_Password);
values.put("sex", register_sex);
values.put("telephone", register_telephone_str);
values.put("HeadImageVersion", 0);
values.put("autoLogin", true);
db.update("LoginUser", values, "autoLogin=?", new String[] {"0"});
db.close();
dbHelper.close();
Intent intent = new Intent(RegisterActivity.this, InfoListActivity.class);
startActivity(intent);
RegisterActivity.this.finish();
} else {
showProgress(false);
register_password_confirm.setError("注册失败");
register_password_confirm.requestFocus();
}
try {
socket.close();
} catch (Exception e) {
}
}
@Override
public void onDestroy() {
super.onDestroy();
((CursorAdapter) getListAdapter()).getCursor().close();
db.close();
}
@Override
protected HistoryAdapter doInBackground(AppCompatActivity... activity) {
ArrayList<String> history = new ArrayList<>();
DatabaseHelper helper = new DatabaseHelper(MainActivity.mContext);
SQLiteDatabase db = helper.getReadableDatabase();
Cursor c =
db.query(
DatabaseHelper.Columns.TABLE_NAME,
new String[] {
DatabaseHelper.Columns.COLUMN_INPUT, DatabaseHelper.Columns.COLUMN_RESULT
},
null,
null,
null,
null,
DatabaseHelper.Columns._ID + " DESC");
if (c.moveToFirst()) {
do history.add(c.getString(0) + " = " + c.getString(1));
while (c.moveToNext());
}
c.close();
db.close();
helper.close();
if (activity.length > 0) return new HistoryAdapter(history, activity[0]);
else return new HistoryAdapter(history, null);
}
// 在使用该函数之前最好先判断数据库中movieList这个表是否为空
public List<UriInstance> queryFromUserID(int userID) {
DatabaseHelper dbHelper = new DatabaseHelper(context, "CAMO_db1");
SQLiteDatabase db = dbHelper.getWritableDatabase();
Cursor cursor =
db.query(
"playList",
new String[] {"userID", "uri", "classType", "name", "mediaType"},
"userID=?",
new String[] {Integer.toString(userID)},
null,
null,
null);
// UriInstance item = new UriInstance();
String uri = null;
String classType = null;
String name = null;
String mediaType = null;
List<UriInstance> list = new ArrayList<UriInstance>();
while (cursor.moveToNext()) {
uri = cursor.getString(cursor.getColumnIndex("uri"));
classType = cursor.getString(cursor.getColumnIndex("classType"));
name = cursor.getString(cursor.getColumnIndex("name"));
mediaType = cursor.getString(cursor.getColumnIndex("mediaType"));
RdfFactory factory = RdfFactory.getInstance();
UriInstance item = factory.createInstance(uri, mediaType, classType, name);
list.add(item);
}
dbHelper.close();
return list;
}
public static void updateCanUpgradePlugins(Context context, int value, String selection) {
DatabaseHelper helper = PluginsDatabaseHelper.getDatabaseHelperInstance(context);
SQLiteDatabase db = helper.getWritableDatabase();
Cursor cursor =
db.rawQuery(
"SELECT * FROM "
+ PluginsDatabaseHelper.PLUGIN_TABLE
+ " AS T1 INNER JOIN "
+ PluginsDatabaseHelper.PLUGIN_TABLE_EXTRA
+ " AS T2 ON T1.id = T2.id "
+ "WHERE T1.filename = ?",
new String[] {selection});
if (cursor != null && cursor.getCount() > 0 && cursor.moveToFirst()) {
if (cursor.getInt(cursor.getColumnIndex("update_flag")) == 1) {
int id = cursor.getInt(cursor.getColumnIndex("id"));
ContentValues values = new ContentValues();
values.put("update_flag", value);
db.update(
PluginsDatabaseHelper.PLUGIN_TABLE_EXTRA,
values,
"id = ?",
new String[] {String.valueOf(id)});
}
}
cursor.close();
db.close();
helper.close();
}
public void reset(Context context) {
DatabaseHelper old = this.databaseHelper;
this.databaseHelper =
new DatabaseHelper(context.getApplicationContext(), DATABASE_NAME, null, DATABASE_VERSION);
old.close();
fillCache();
}
/**
* {@inheritDoc}
*
* @see android.app.Service#onDestroy()
*/
@Override
public void onDestroy() {
LOGGER.info("onDestroy(): Terminating this instance.");
super.onDestroy();
// Shutdown the databaseHelper
databaseHelper.close();
databaseHelper = null;
if (MoatIoTService.motionSensorListener != null) {
// Remove BroadcastReceiver
MoatIoTService.motionSensorListener.invalidate();
MoatIoTService.motionSensorListener = null;
}
final MoatAndroidFactory factory = MoatAndroidFactory.getInstance();
if (factory.isValid(moat)) {
// Remove unused model descriptors
moat.removeModel(ShakeEvent.class);
moat.removeModel(VibrationDevice.class);
}
factory.destroyMoat(moat);
moat = null;
LOGGER.info("onDestroy(): Done!");
}
public void onClickDeleteRecord(View view) {
helper.open();
if (helper.deleteRecord(getId())) {
Toast.makeText(this, "Delete process succeded", Toast.LENGTH_SHORT).show();
} else {
Toast.makeText(this, "Record could not be deleted", Toast.LENGTH_SHORT).show();
}
helper.close();
}
public void onStop() {
// cam.release();
try {
db.close();
} catch (Exception e) {
}
super.onStop();
} // end of onStop
// Terminate DB
public void close() {
if (mDb != null) {
mDb.close();
mDb = null;
}
if (mDbHelper != null) {
mDbHelper.close();
mDbHelper = null;
}
}
public void onDestroy() {
// cam.release();
try {
db.close();
} catch (Exception e) {
}
super.onDestroy();
}
public void dropTable(@NonNull Class<?> type) {
if (!DatabaseSchemaParser.isTable(type))
throw new UnsupportedOperationException(
"Unable to drop table for type " + type.getSimpleName());
String table = DatabaseSchemaParser.getTableName(type);
DatabaseHelper database =
new DatabaseHelper(context, databaseName, table, null, databaseVersion);
database.dropTable();
database.close();
}
public int length() {
DatabaseHelper dbHelper = new DatabaseHelper(context, "CAMO_db1");
SQLiteDatabase db = dbHelper.getWritableDatabase();
Cursor cursor = db.query("playList", new String[] {"COUNT(*)"}, null, null, null, null, null);
int length = 0;
if (cursor.moveToNext()) {
dbHelper.close();
length = cursor.getInt(0);
}
// dbHelper.close();
return length;
}
// id的值最好连续，这样方便遍历
public void insert(
int id, int userID, String uri, String classType, String name, String mediaType) {
ContentValues value = new ContentValues();
value.put("userID", userID);
value.put("id", id);
value.put("uri", uri);
value.put("classType", classType);
value.put("name", name);
value.put("mediaType", mediaType);
DatabaseHelper dbHelper = new DatabaseHelper(context, "CAMO_db1");
SQLiteDatabase db = dbHelper.getWritableDatabase();
db.insert("playList", null, value);
dbHelper.close();
}
public void onClickGetRecord(View view) {
helper.open();
Cursor c = helper.getSingleRecord((long) getId());
if (c != null) {
Toast.makeText(
this,
"The name is: "
+ c.getString(0)
+ " phone number is "
+ c.getString(1)
+ " and enail is"
+ c.getString(2),
Toast.LENGTH_SHORT)
.show();
} else {
Toast.makeText(this, "No records found", Toast.LENGTH_SHORT).show();
}
helper.close();
}
public static boolean hasCanUpgradePlugins(Context context) {
boolean result = false;
DatabaseHelper helper = PluginsDatabaseHelper.getDatabaseHelperInstance(context);
SQLiteDatabase db = helper.getWritableDatabase();
Cursor cursor =
db.rawQuery(
"SELECT * FROM "
+ PluginsDatabaseHelper.PLUGIN_TABLE
+ " AS T1 INNER JOIN "
+ PluginsDatabaseHelper.PLUGIN_TABLE_EXTRA
+ " AS T2 ON T1.id = T2.id "
+ "WHERE T2.update_flag = ?",
new String[] {String.valueOf(1)});
result = cursor != null && cursor.getCount() > 0 && cursor.moveToFirst();
cursor.close();
db.close();
helper.close();
return result;
}
public void onClickGetAllRecords(View view) {
helper.open();
Cursor c = helper.getAllRecords();
if (c != null) {
do {
Toast.makeText(
this,
"The name is "
+ c.getString(0)
+ "\nThe phone is "
+ c.getString(1)
+ "\nThe email is "
+ c.getString(2),
Toast.LENGTH_SHORT)
.show();
} while (c.moveToNext());
} else {
Toast.makeText(this, "No records found", Toast.LENGTH_SHORT).show();
}
helper.close();
}
public List<Categoria> selecionarTodas() {
List<Categoria> lista = new ArrayList<Categoria>();
db = helper.getReadableDatabase();
Cursor cursor = db.query(Categoria.TABELA, null, null, null, null, null, Categoria.NOME);
if (cursor.moveToFirst()) {
do {
Categoria categoria = new Categoria();
categoria.setId(cursor.getInt(cursor.getColumnIndex(Categoria.ID)));
categoria.setNome(cursor.getString(cursor.getColumnIndex(Categoria.NOME)));
lista.add(categoria);
} while (cursor.moveToNext());
}
cursor.close();
db.close();
helper.close();
return lista;
}
public void close() {
mDbHelper.close();
}
public static synchronized void closeDatabase() {
sDatabaseHelper.close();
}
public void close() {
mDatabaseHelper.close();
}
public void delete(int id) {
DatabaseHelper dbHelper = new DatabaseHelper(context, "CAMO_db1");
SQLiteDatabase db = dbHelper.getWritableDatabase();
db.delete("playList", "id=?", new String[] {Integer.toString(id)});
dbHelper.close();
}
// closes database
public void close() {
ourHelper.close();
}
// ---closes the database---
public void close() {
DBHelper.close();
}
public void close() {
if (mDbHelper != null) {
mDbHelper.close();
}
}
public void close() {
ourDatabase.close();
ourHelper.close();
}
public void close() {
dbHelper.close();
}
public DBAdapter close() {
mDatabaseHelper.close();
return this;
}
