/*
* Copyright (c) 2011, QUALCOMM Incorporated.
* All Rights Reserved.
* QUALCOMM Proprietary and Confidential.
* Developed by QRD Engineering team.
*/
package com.android.nxd;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;
public class UserDataManager {
private static final String TAG = "UserDataManager";
private static final String DB_NAME = "user_data";
private static final String TABLE_NAME = "users";
public static final String ID = "_id";
public static final String USER_NAME = "user_name";
public static final String USER_PWD = "user_pwd";
public static final String SILENT = "silent";
public static final String VIBRATE = "vibrate";
private static final int DB_VERSION = 2;
private Context mContext = null;
private static final String DB_CREATE = "CREATE TABLE " + TABLE_NAME + " ("
+ ID + " integer primary key," + USER_NAME + " varchar,"
+ USER_PWD + " varchar" + ");";
private SQLiteDatabase mSQLiteDatabase = null;
private DataBaseManagementHelper mDatabaseHelper = null;
private static class DataBaseManagementHelper extends SQLiteOpenHelper {
DataBaseManagementHelper(Context context) {
super(context, DB_NAME, null, DB_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
Log.i(TAG,"db.getVersion()="+db.getVersion());
db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME + ";");
db.execSQL(DB_CREATE);
Log.i(TAG, "db.execSQL(DB_CREATE)");
Log.e(TAG, DB_CREATE);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
Log.i(TAG, "DataBaseManagementHelper onUpgrade");
onCreate(db);
}
}
public UserDataManager(Context context) {
mContext = context;
Log.i(TAG, "UserDataManager construction!");
}
public void openDataBase() throws SQLException {
mDatabaseHelper = new DataBaseManagementHelper(mContext);
mSQLiteDatabase = mDatabaseHelper.getWritableDatabase();
}
public void closeDataBase() throws SQLException {
mDatabaseHelper.close();
}
public long insertUserData(UserData userData) {
String userName=userData.getUserName();
String userPwd=userData.getUserPwd();
ContentValues values = new ContentValues();
values.put(USER_NAME, userName);
values.put(USER_PWD, userPwd);
return mSQLiteDatabase.insert(TABLE_NAME, ID, values);
}
public boolean updateUserData(UserData userData) {
int id = userData.getUserId();
String userName = userData.getUserName();
String userPwd = userData.getUserPwd();
ContentValues values = new ContentValues();
values.put(USER_NAME, userName);
values.put(USER_PWD, userPwd);
return mSQLiteDatabase.update(TABLE_NAME, values, ID + "=" + id, null) > 0;
}
public Cursor fetchUserData(int id) throws SQLException {
Cursor mCursor = mSQLiteDatabase.query(false, TABLE_NAME, null, ID
+ "=" + id, null, null, null, null, null);
if (mCursor != null) {
mCursor.moveToFirst();
}
return mCursor;
}
public Cursor fetchAllUserDatas() {
return mSQLiteDatabase.query(TABLE_NAME, null, null, null, null, null,
null);
}
public boolean deleteUserData(int id) {
return mSQLiteDatabase.delete(TABLE_NAME, ID + "=" + id, null) > 0;
}
public boolean deleteAllUserDatas() {
return mSQLiteDatabase.delete(TABLE_NAME, null, null) > 0;
}
public String getStringByColumnName(String columnName, int id) {
Cursor mCursor = fetchUserData(id);
int columnIndex = mCursor.getColumnIndex(columnName);
String columnValue = mCursor.getString(columnIndex);
mCursor.close();
return columnValue;
}
public boolean updateUserDataById(String columnName, int id,
String columnValue) {
ContentValues values = new ContentValues();
values.put(columnName, columnValue);
return mSQLiteDatabase.update(TABLE_NAME, values, ID + "=" + id, null) > 0;
}
public int findUserByName(String userName){
Log.i(TAG,"findUserByName , userName="+userName);
int result=0;
Cursor mCursor=mSQLiteDatabase.query(TABLE_NAME, null, USER_NAME+"="+userName, null, null, null, null);
if(mCursor!=null){
result=mCursor.getCount();
mCursor.close();
Log.i(TAG,"findUserByName , result="+result);
}
return result;
}
public int findUserByNameAndPwd(String userName,String pwd){
Log.i(TAG,"findUserByNameAndPwd");
int result=0;
Cursor mCursor=mSQLiteDatabase.query(TABLE_NAME, null, USER_NAME+"="+userName+" and "+USER_PWD+"="+pwd,
null, null, null, null);
if(mCursor!=null){
result=mCursor.getCount();
mCursor.close();
Log.i(TAG,"findUserByNameAndPwd , result="+result);
}
return result;
}
}
Android 用户注册，登录的简单实现-IT计算机-毕业设计.zip
版权申诉
5星 · 超过95%的资源 8 浏览量
2022-04-05
20:33:32
上传
评论 1
收藏 1.81MB ZIP 举报 
Android 用户注册，登录的简单实现-IT计算机-毕业设计.zip （81个子文件） 
Android 用户注册，登录的简单实现 TeachManageSys bin 
classes.dex 13KB res drawable-ldpi 
icon.png 2KB drawable-hdpi default_bg_hdpi.png 217KB icon.png 4KB drawable-mdpi button2_down.png 1KB default_bg.png 111KB h001.png 3KB faceback.png 3KB option_normal.png 629B btn_check_off_pressed.png 557B option_selected.png 2KB btn_check_on_selected.png 1KB button2.png 413B icon.png 2KB bottom.9.png 295B btn_check_on.png 872B input_over.9.png 1008B btn_check_off.png 331B btn_check_on_pressed.png 1KB button2_over.png 901B btn_check_off_selected.png 1024B login_input.9.png 639B login_back.9.png 1KB jarlist.cache 119B classes com android nxd BuildConfig.class 339B UserDataManager$DataBaseManagementHelper.class 2KB R$layout.class 390B UserData.class 1KB R$id.class 853B R$drawable.class 1KB R$attr.class 331B R.class 600B UserDataManager.class 5KB R$string.class 927B LoginActivity.class 4KB R$color.class 400B R$style.class 388B LoginActivity$1.class 912B resources.ap_ 369KB TeachManageSys.apk 379KB TestLogin.apk 376KB res drawable-ldpi icon.png 2KB drawable-hdpi default_bg_hdpi.png 217KB icon.png 4KB drawable-xhdpi color qq_checkbox_text_color.xml 264B values strings.xml 1KB styles.xml 418B drawable-mdpi button2_down.png 1KB default_bg.png 111KB login_head.xml 401B h001.png 3KB faceback.png 3KB qq_edit_login.xml 377B option_normal.png 629B btn_check_off_pressed.png 557B option_selected.png 2KB more_select.xml 404B btn_check_on_selected.png 1KB button2.png 413B icon.png 3KB bottom.9.png 372B btn_check_on.png 872B option.xml 416B qq_btn_check.xml 1KB input_over.9.png 1KB btn_check_off.png 331B btn_check_on_pressed.png 1KB button2_over.png 901B btn_check_off_selected.png 1024B login_input.9.png 483B login_back.9.png 1KB layout loginpage.xml 5KB assets gen com android nxd BuildConfig.java 157B R.java 4KB src com android nxd UserDataManager.java 5KB UserData.java 816B LoginActivity.java 4KB .project 850B .classpath 364B project.properties 563B AndroidManifest.xml 659B
评论1