/*
* 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应用源码之用户注册,登录的简单实现.zip项目安卓应用源码下载
共81个文件
png:44个
class:14个
xml:10个
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
0 下载量 196 浏览量
2022-03-08
22:06:11
上传
评论
收藏 1.82MB ZIP 举报
温馨提示
Android应用源码之用户注册,登录的简单实现.zip项目安卓应用源码下载Android应用源码之用户注册,登录的简单实现.zip项目安卓应用源码下载 1.适合学生毕业设计研究参考 2.适合个人学习研究参考 3.适合公司开发项目技术参考
资源推荐
资源详情
资源评论
收起资源包目录
Android应用源码之用户注册,登录的简单实现.zip (81个子文件)
Android应用源码之用户注册,登录的简单实现
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
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
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
共 81 条
- 1
资源评论
yxkfw
- 粉丝: 76
- 资源: 2万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功