/*
* 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应用
5星 · 超过95%的资源 需积分: 32 160 浏览量
2013-10-04
09:42:35
上传
评论
收藏 1.8MB ZIP 举报 
(v).zip （81个子文件） 
TeachManageSys 
.project 850B project.properties 563B src com android nxd LoginActivity.java 4KB UserDataManager.java 5KB UserData.java 816B AndroidManifest.xml 659B res drawable-ldpi 
icon.png 2KB drawable-hdpi icon.png 4KB default_bg_hdpi.png 217KB drawable-mdpi login_head.xml 401B more_select.xml 404B button2.png 413B option_normal.png 629B icon.png 3KB h001.png 3KB btn_check_off.png 331B input_over.9.png 1KB option.xml 416B faceback.png 3KB qq_edit_login.xml 377B btn_check_on.png 872B login_back.9.png 1KB btn_check_off_selected.png 1024B login_input.9.png 483B btn_check_on_selected.png 1KB default_bg.png 111KB btn_check_on_pressed.png 1KB button2_over.png 901B bottom.9.png 372B qq_btn_check.xml 1KB button2_down.png 1KB option_selected.png 2KB btn_check_off_pressed.png 557B layout loginpage.xml 5KB drawable-xhdpi values strings.xml 1KB styles.xml 418B color qq_checkbox_text_color.xml 264B assets gen com android nxd BuildConfig.java 157B R.java 4KB .classpath 364B bin resources.ap_ 369KB classes com android nxd R$layout.class 390B R$style.class 388B BuildConfig.class 339B R$drawable.class 1KB R$attr.class 331B UserDataManager.class 5KB LoginActivity.class 4KB LoginActivity$1.class 912B R$id.class 853B R.class 600B R$string.class 927B UserDataManager$DataBaseManagementHelper.class 2KB UserData.class 1KB R$color.class 400B TestLogin.apk 376KB jarlist.cache 119B res drawable-ldpi icon.png 2KB drawable-hdpi icon.png 4KB default_bg_hdpi.png 217KB drawable-mdpi button2.png 413B option_normal.png 629B icon.png 2KB h001.png 3KB btn_check_off.png 331B input_over.9.png 1008B faceback.png 3KB btn_check_on.png 872B login_back.9.png 1KB btn_check_off_selected.png 1024B login_input.9.png 639B btn_check_on_selected.png 1KB default_bg.png 111KB btn_check_on_pressed.png 1KB button2_over.png 901B bottom.9.png 295B button2_down.png 1KB option_selected.png 2KB btn_check_off_pressed.png 557B TeachManageSys.apk 379KB classes.dex 13KB资源评论
qq_385474852018-04-08谢谢分享，，，，- 点孤2013-10-30例子不错，谢谢分享
- f3821175362013-12-18例子不错 ，有参考价值
