/*
* 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项目安卓应用源码下载Android 用户注册,登录的简单实现.zip项目安卓应用源码下载 1.适合学生毕业设计研究参考 2.适合个人学习研究参考 3.适合公司开发项目技术参考
资源推荐
资源详情
资源评论
收起资源包目录
Android 用户注册,登录的简单实现.zip (81个子文件)
Android 用户注册,登录的简单实现
Android 用户注册,登录的简单实现
TeachManageSys
.project 850B
bin
jarlist.cache 119B
TestLogin.apk 376KB
res
drawable-ldpi
icon.png 2KB
drawable-hdpi
default_bg_hdpi.png 217KB
icon.png 4KB
drawable-mdpi
faceback.png 3KB
btn_check_off_pressed.png 557B
default_bg.png 111KB
button2_down.png 1KB
btn_check_off_selected.png 1024B
button2_over.png 901B
h001.png 3KB
button2.png 413B
login_back.9.png 1KB
input_over.9.png 1008B
login_input.9.png 639B
btn_check_off.png 331B
btn_check_on_selected.png 1KB
bottom.9.png 295B
option_selected.png 2KB
btn_check_on_pressed.png 1KB
btn_check_on.png 872B
option_normal.png 629B
icon.png 2KB
resources.ap_ 369KB
classes
com
android
nxd
R$string.class 927B
R$layout.class 390B
UserDataManager$DataBaseManagementHelper.class 2KB
UserDataManager.class 5KB
R$drawable.class 1KB
R.class 600B
LoginActivity.class 4KB
R$style.class 388B
R$color.class 400B
BuildConfig.class 339B
R$attr.class 331B
LoginActivity$1.class 912B
R$id.class 853B
UserData.class 1KB
TeachManageSys.apk 379KB
classes.dex 13KB
AndroidManifest.xml 659B
src
com
android
nxd
UserData.java 816B
UserDataManager.java 5KB
LoginActivity.java 4KB
project.properties 563B
res
values
styles.xml 418B
strings.xml 1KB
layout
loginpage.xml 5KB
drawable-ldpi
icon.png 2KB
drawable-hdpi
default_bg_hdpi.png 217KB
icon.png 4KB
drawable-mdpi
faceback.png 3KB
btn_check_off_pressed.png 557B
default_bg.png 111KB
button2_down.png 1KB
option.xml 416B
btn_check_off_selected.png 1024B
button2_over.png 901B
h001.png 3KB
login_head.xml 401B
qq_edit_login.xml 377B
button2.png 413B
login_back.9.png 1KB
input_over.9.png 1KB
login_input.9.png 483B
btn_check_off.png 331B
qq_btn_check.xml 1KB
btn_check_on_selected.png 1KB
bottom.9.png 372B
option_selected.png 2KB
btn_check_on_pressed.png 1KB
btn_check_on.png 872B
more_select.xml 404B
option_normal.png 629B
icon.png 3KB
drawable-xhdpi
color
qq_checkbox_text_color.xml 264B
.classpath 364B
gen
com
android
nxd
R.java 4KB
BuildConfig.java 157B
assets
共 81 条
- 1
资源评论
yxkfw
- 粉丝: 76
- 资源: 2万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- pta题库答案c语言之排序4统计工龄.zip
- pta题库答案c语言之树结构7堆中的路径.zip
- pta题库答案c语言之树结构3TreeTraversalsAgain.zip
- pta题库答案c语言之树结构2ListLeaves.zip
- pta题库答案c语言之树结构1树的同构.zip
- 基于C++实现民航飞行与地图简易管理系统可执行程序+说明+详细注释.zip
- pta题库答案c语言之复杂度1最大子列和问题.zip
- 三维装箱问题(Three-Dimensional Bin Packing Problem,3D-BPP)是一个经典的组合优化问题
- 以下是一些关于Linux线程同步的基本概念和方法.txt
- 以下是一个简化的示例,它使用pygame库来模拟烟花动画的框架.txt
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功