Android：利用本地服务器-创建数据库-构建用户表（注册）
1.创建一个用户信息类，这里包括你想要记录下的用户信息
public class UserData { private String userName; private String userPwd; private String userPhone; private String userMail; private String userAds; private int userId; public String getUserName() { return userName; } public void setUserName(String userName) { this.userName = userName; } public String getUserPwd() { return userPwd; } public void setUserPwd(String userPwd) { this.userPwd = userPwd; } public String getUserPhone(){ return userPhone ; } public void setUserPhone(String userPhone){ this.userPhone = userPhone; } public String getUserMail(){ return userMail; } public void setUserMail(String userMail){ this.userMail = userMail; } public String getUserAds(){ return userAds; } public void setUserAds(String userAds){ this.userAds = userAds; } public int getUserId() { return userId; } public void setUserId(int userId) { this.userId = userId; } public UserData(int userId,String userName, String userPwd, String userPhone,String userMail, String userAds) { super(); this.userName = userName; this.userPwd = userPwd; this.userPhone = userPhone; this.userMail = userMail; this.userAds = userAds; this.userId = userId; } public UserData(String userName, String userPwd,String userPhone,String userMail, String userAds) { super(); this.userName = userName; this.userPwd = userPwd; this.userPhone = userPhone; this.userMail = userMail; this.userAds = userAds; } }
2.创建用户信息管理类
public class UserDataManager { private static final String TAG = "UserDataManager"; private static final String DB_NAME = "Register.db"; public static final String TABLE_NAME = "Registry"; public static final String ID = "_id"; public static final String USER_NAME = "name"; public static final String USER_PWD = "pwd"; public static final String USER_PHONE = "phone"; public static final String USER_MAIL = "mail"; public static final String USER_ADD = "address"; private static final int DB_VERSION = 1; //版本号 private static final String DB_CREATE = "CREATE TABLE " + TABLE_NAME + " (" +ID + " integer primary key,"+ USER_NAME + " varchar," + USER_PWD + " varchar,"+ USER_PHONE + " varchar,"+ USER_MAIL + " varchar," + USER_ADD + " varchar" + ");"; private Context mContext = null; 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) { // 调用时间：数据库第一次创建时onCreate()方法会被调用 Log.i("调用测试", "OK"); 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.i(TAG, DB_CREATE); } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { // 调用时间：如果DATABASE_VERSION值被改为别的数,系统发现现有数据库版本不同,即会调用onUpgrade Log.i(TAG, "DataBaseManagementHelper onUpgrade"); db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME); onCreate(db); } @Override public void onOpen(SQLiteDatabase db) { super.onOpen(db); // 每次打开数据库之后首先被执行 Log.d(TAG, "DatabaseHelper onOpen"); } } 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 void insertUserData(UserData userData) { String userName=userData.getUserName(); String userPwd=userData.getUserPwd(); String userPhone = userData.getUserPhone(); String userMail = userData.getUserMail(); String userAds = userData.getUserAds(); mSQLiteDatabase.beginTransaction(); // 开始事务 try { mSQLiteDatabase.execSQL("INSERT INTO " + TABLE_NAME + " VALUES(null, ?, ?, ?, ?, ?)", new Object[] { userName,userPwd, userPhone, userMail, userAds }); // 带两个参数的execSQL()方法，采用占位符参数？，把参数值放在后面，顺序对应 // 一个参数的execSQL()方法中，用户输入特殊字符时需要转义 // 使用占位符有效区分了这种情况 mSQLiteDatabase.setTransactionSuccessful(); // 设置事务成功完成 } finally { mSQLiteDatabase.endTransaction(); // 结束事务 } } /** * 更新整个注册表的用户信息 * @param userData 用户信息类 * @return */ public boolean updateUserData(UserData userData) { int id = userData.getUserId(); String userName = userData.getUserName(); String userPwd = userData.getUserPwd(); String userPhone = userData.getUserPhone(); String userMail = userData.getUserMail(); String userAds = userData.getUserAds(); ContentValues values = new ContentValues(); values.put(USER_NAME, userName); values.put(USER_PWD, userPwd); values.put(USER_PHONE, userPhone); values.put(USER_MAIL, userMail); values.put(USER_ADD, userAds); return mSQLiteDatabase.update(TABLE_NAME, values, ID + "=" + id, null) > 0; } /** * query all persons, return cursor * * @return Cursor */ public Cursor queryTheCursor() { Log.d(TAG, "DBManager --> queryTheCursor"); mSQLiteDatabase = mDatabaseHelper.getReadableDatabase(); Cursor c = mSQLiteDatabase.rawQuery("SELECT * FROM " + TABLE_NAME, null); return c; } /** * 通过ID号删除用户 * @param id * @return */ public boolean deleteUserData(int id) { return mSQLiteDatabase.delete(TABLE_NAME, ID + "=" + id, null) > 0; } /** * 删除所有用户 * @return */ public boolean deleteAllUserDatas() { return mSQLiteDatabase.delete(TABLE_NAME, null, null) > 0; } /** * 通过ID号更新用户表信息 * @param columnName * @param id * @param columnValue * @return */ 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; } /** * 通过用户名查找用户 * @param userName * @return */ public int findUserByName(String userName){ Log.i(TAG,"findUserByName"); Cursor mCursor = queryTheCursor(); String name; int result=0; while(mCursor.moveToNext()){ Log.i(TAG,"moveToNext"); name = mCursor.getString(mCursor.getColumnIndex(USER_NAME)); Log.i(TAG,"name="+name); if(name.equals(userName)){ result = 1; Log.i(TAG,"findUserByName , result="+result); break; } } return result; } /** * 通过用户名/电话/邮箱和密码查找用户 * @param userName * @param pwd * @return */ public int findUserByNameAndPwd(String userName,String pwd){ Log.i(TAG,"findUserByNameAndPwd()"); Cursor mCursor = queryTheCursor(); String name,password,phone,mail; int result=0; while(mCursor.moveToNext()){ Log.i(TAG,"moveToNext"); name = mCursor.getString(mCursor.getColumnIndex(USER_NAME)); password = mCursor.getString(mCursor.getColumnIndex(USER_PWD)); phone = mCursor.getString(mCursor.getColumnIndex(USER_PHONE)); mail = mCursor.getString(mCursor.getColumnIndex(USER_MAIL)); if((name.equals(userName) || name.equals(mail) || name.equals(phone)) && password.equals(pwd)){ result = 1; Log.i(TAG,"findUserByNameAndPwd , result="+result); break; } } return result; } }
3.使用方法
private UserDataManager mUserDataManager; //首先：创建注册表 if (mUserDataManager == null) { mUserDataManager = new UserDataManager(this); mUserDataManager.openDataBase(); } /** * 添加新的用户信息时 * @param Pname 用户名 * @param Ppwd 密码 * @param Pphone电话 * @param Pmail 邮箱 * @param Plocat地址 */ public void addperson(String Pname,String Ppwd, String Pphone, String Pmail, String Plocat){ UserData mUser = new UserData(Pname,Ppwd,Pphone,Pmail,Plocat); mUserDataManager.openDataBase(); mUserDataManager.insertUserData(mUser); }
