通讯录
这个小软件是我自己在家时候学习sqlite增删改查的时候写的,这个小app主要实现的一个是记住密码的功能,还有将照片存储在数据库中的具体操作的过程值得去仔细体验。
代码展视:
package com.example.tongxunlu.dao;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import com.example.tongxunlu.db.AppSqliteHelper;
import com.example.tongxunlu.model.User;
public class UserDao {
private AppSqliteHelper helper;
private String tablename = "user";
public UserDao(Context context){
helper = new AppSqliteHelper(context);
}
//登录
public User login(String account,String password){
SQLiteDatabase db = helper.getReadableDatabase();
Cursor c = db.query(tablename,null,"name=? and password=?",new String[]{account,password},null,null,null,null);
User user = null;
if(c!= null&&c.getCount()>0){
if(c.moveToNext()){
user = new User();
user.setId(c.getInt(c.getColumnIndex("id")));
user.setName(account);
user.setPassword(password);
user.setPhone(c.getString(c.getColumnIndex("phone")));
}
}
return user;
}
//根据账号和手机号判断用户是否存在
public boolean isExistByAccountAndPhone(String account,String phone){
SQLiteDatabase db = helper.getReadableDatabase();
Cursor c = db.query(tablename,null,"name=? or phone=?",new String[]{account,phone},null,null,null,null);
if(c!= null&&c.getCount()>0){
return c.moveToNext();
}
return false;
}
//注册
public boolean insert(User bean){
SQLiteDatabase db = helper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("name",bean.getName());
values.put("password",bean.getPassword());
values.put("phone",bean.getPhone());
long insert = db.insert(tablename,null,values);
return insert >0;
}
//根据账号或手机号查询密码
public String queryPasswordByAccountAndPhone(String account,String phone){
SQLiteDatabase db = helper.getReadableDatabase();
Cursor c = db.query(tablename,null,"name=? and phone=?",new String[]{account,phone},null,null,null,null);
if(c != null && c.getCount()>0){
if(c.moveToNext()){
return(c.getString(c.getColumnIndex("password")));
}
}
return null;
}
}