public class UserService { private DatabaseHelper dbHelper; public UserService(Context context){ dbHelper=new DatabaseHelper(context); } //登录用 public boolean login(String username,String password){ SQLiteDatabase sdb=dbHelper.getReadableDatabase(); String sql="select * from user where username=? and password=?"; Cursor cursor=sdb.rawQuery(sql, new String[]{username,password}); if(cursor.moveToFirst()==true){ cursor.close(); return true; } return false; } //注册用 public boolean register(User user){ SQLiteDatabase sdb=dbHelper.getReadableDatabase(); String sql="insert into user(username,password,age,sex) values(?,?,?,?)"; Object obj[]={user.getUsername(),user.getPassword(),user.getAge(),user.getSex()}; sdb.execSQL(sql, obj); return true; } }
上面代码有设及到一个cursor游标:Android之利用SQLite数据库实现登陆和注册(2)
内容版权声明:除非注明,否则皆为本站原创文章。