安卓期末项目考核（3）--sqlite的运用

sqlite是安卓自带的数据库，老师讲这个的时候耍去了，就。。。。 我运用数据库是利用导包运用的，源码如下：

user类

package com.jiang.jzj_qq.user; public class User { private String account; private String name; private String sex; private int age; private String adress; private String email; private String phone; private String password; public User(String account, String name, String sex, int age, String phone, String password) { this.account = account; this.name = name; this.sex = sex; this.age = age; // this.adress = adress; // this.email = email; this.phone = phone; this.password = password; } public String getAccount() { return account; } public void setAccount(String account) { this.account = account; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getSex() { return sex; } public void setSex(String sex) { this.sex = sex; } public int getAge() { return age; } public void setAge(int age) { this.age = age; } // public String getAdress() { // return adress; // } // // public void setAdress(String adress) { // this.adress = adress; // } // // public String getEmail() { // return email; // } public void setEmail(String email) { this.email = email; } public String getPhone() { return phone; } public void setPhone(String phone) { this.phone = phone; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } @Override public String toString() { return "User{" + "account='" + account + '\'' + ", name='" + name + '\'' + ", sex='" + sex + '\'' + ", age=" + age + // ", adress='" + adress + '\'' + // ", email='" + email + '\'' + ", phone='" + phone + '\'' + ", password='" + password + '\'' + '}'; } }

userDB

package com.jiang.jzj_qq.user; import android.content.ContentValues; import android.content.Context; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteOpenHelper; import android.util.Log; import android.widget.Toast; import java.util.ArrayList; import java.util.List; public class UserDB { SQLiteDatabase writableDatabase; private static String DB_NAME = "user.db"; private static int DB_VERSION = 1; private static String SQL = "create table userinfo (" + " id integer primary key autoincrement," + " account text," + " name text," + " sex text," + " age integer," + " address text," + " email text," + " phone text," + " pwd text" + ")"; public User findUserByAccount(String account) { //查找 Cursor userinfo = writableDatabase.query("userinfo",null,"account = ?",new String[]{account},null,null,null); User user = null; while (userinfo.moveToNext()){ String acc = userinfo.getString(userinfo.getColumnIndex("account")); String name = userinfo.getString(userinfo.getColumnIndex("name")); String sex = userinfo.getString(userinfo.getColumnIndex("sex")); int age = Integer.parseInt(userinfo.getString(userinfo.getColumnIndex("age"))); String address = userinfo.getString(userinfo.getColumnIndex("address")); String email = userinfo.getString(userinfo.getColumnIndex("email")); String phone = userinfo.getString(userinfo.getColumnIndex("phone")); String pwd = userinfo.getString(userinfo.getColumnIndex("pwd")); user = new User(acc, name, sex, age, phone, pwd); } return user; } //修改的方法 update userinfo set name = ? ,phone = ? where account = ? public long UserUpdate(String account,String name,String phone){ ContentValues contentValues = new ContentValues(); contentValues.put("name",name); contentValues.put("phone",phone); return writableDatabase.update("userinfo",contentValues,"account = ?",new String[]{account}) ; } public boolean deleteByAccount(String account) { return writableDatabase.delete("userinfo","account=?",new String[]{account})>0; } public List<User> FindAlluser() { List<User> users = new ArrayList<>(); Cursor userinfo = writableDatabase.query("userinfo", null, null, null, null, null, null, null); while (userinfo.moveToNext()) { String account = userinfo.getString(userinfo.getColumnIndex("account")); String name = userinfo.getString(userinfo.getColumnIndex("name")); String sex = userinfo.getString(userinfo.getColumnIndex("sex")); int age = Integer.parseInt(userinfo.getString(userinfo.getColumnIndex("age"))); String address = userinfo.getString(userinfo.getColumnIndex("address")); String email = userinfo.getString(userinfo.getColumnIndex("email")); String phone = userinfo.getString(userinfo.getColumnIndex("phone")); String pwd = userinfo.getString(userinfo.getColumnIndex("pwd")); Log.d("mas", "取值"); User user = new User(account, name, sex, age, pwd, phone); users.add(user); } return users; } public static class UserDbOpenHelper extends SQLiteOpenHelper { private Context context; public UserDbOpenHelper(Context context) { super(context, DB_NAME, null, DB_VERSION); this.context = context; } /* 创建数据库 */ @Override public void onCreate(SQLiteDatabase db) { // 执行sql语句 db.execSQL(SQL); Toast.makeText(context, "创建sqlite成功", Toast.LENGTH_SHORT).show(); } /* 更新数据库（当版本号发生变化的时候） */ @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { db.execSQL("drop table if exists userinfo"); db.execSQL(SQL); } } /* 打开数据库 */ public void OpenUserDb(Context mcontext) { UserDbOpenHelper userDbOpenHelper = new UserDbOpenHelper(mcontext); writableDatabase = userDbOpenHelper.getWritableDatabase(); } /* 新增数据insert 用于用户注册(--新增语句 insert into student(name,sex,age)values ('小名','男','hello') --字段名和值要一一对应 --删除语句 delete from student where name = '小名') */ public long insertUserData(User user) { //插入 String account = user.getAccount(); String name = user.getName(); String sex = user.getSex(); int age = user.getAge(); // String email = user.getEmail(); String phone = user.getPhone(); // String address = user.getAdress(); String pwd = user.getPassword(); ContentValues contentValues = new ContentValues(); contentValues.put("account", account); contentValues.put("name", name); contentValues.put("sex", sex); contentValues.put("age", age); // contentValues.put("email", email); // contentValues.put("address", address); contentValues.put("phone", phone); contentValues.put("pwd", pwd); return writableDatabase.insert("userinfo", null, contentValues); } public List<User> FindAllUsers() { List<User> users = new ArrayList<>(); Cursor userinfo = writableDatabase.query("userinfo", null, null, null, null, null, null, null); while (userinfo.moveToNext()) { String account = userinfo.getString(userinfo.getColumnIndex("account")); String name = userinfo.getString(userinfo.getColumnIndex("name")); String sex = userinfo.getString(userinfo.getColumnIndex("sex")); int age = Integer.parseInt(userinfo.getString(userinfo.getColumnIndex("age"))); String address = userinfo.getString(userinfo.getColumnIndex("address")); String email = userinfo.getString(userinfo.getColumnIndex("email")); String phone = userinfo.getString(userinfo.getColumnIndex("phone")); String pwd = userinfo.getString(userinfo.getColumnIndex("pwd")); Log.d("mas", "取值"); User user = new User(account, name, sex, age, pwd, phone); users.add(user); } return users; } public boolean delete(String account) { return writableDatabase.delete("userinfo", "account = ?", new String[]{account})>0; } }

文件夹sql类

package com.jiang.jzj_qq.sql; import android.content.Intent; import android.os.Bundle; import android.view.View; import android.widget.AdapterView; import android.widget.ListView; import android.widget.Toast; import androidx.appcompat.app.AppCompatActivity; import com.jiang.jzj_qq.R; import com.jiang.jzj_qq.user.User; import com.jiang.jzj_qq.user.UserDB; import java.util.List; //删除 public class AllUsers extends AppCompatActivity { private ListView userlistview; private List<User> users; private UserDB userDB; private AdapterView listViewLV; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_all_users); userDB = new UserDB(); userDB.OpenUserDb(this); //1.获取listview userlistview = findViewById(R.id.user_listview); //2.添加数据源,数据库全查询（UserDB类里完成） users = userDB.FindAllUsers(); //3.构建Adapter UserAdapter userAdapter = new UserAdapter(users, this); //4.显示list userlistview.setAdapter(userAdapter); listViewLV = findViewById(R.id.user_listview); listViewLV.setOnItemLongClickListener(new AdapterView.OnItemLongClickListener() { @Override public boolean onItemLongClick(AdapterView<?> parent, View view, int position, long id) { User user = users.get(position); if (userDB.delete(user.getAccount())) { Toast.makeText(AllUsers.this, "删除成功", Toast.LENGTH_LONG); startActivity(new Intent(AllUsers.this,AllUsers.class)); } else { Toast.makeText(AllUsers.this, "删除失败", Toast.LENGTH_LONG); } return false; } }); //添加点击事件（跳转到修改页面） userlistview.setOnItemClickListener(new AdapterView.OnItemClickListener() { @Override public void onItemClick(AdapterView<?> parent, View view, int position, long id) { Intent intent = new Intent(AllUsers.this,UserUapedate.class); //携带原始数据 User user = users.get(position); String account = user.getAccount(); intent.putExtra("account",account); startActivity(intent); } }); } } package com.jiang.jzj_qq.sql; import android.content.Context; import android.content.SharedPreferences; import android.content.SharedPreferences.Editor; public class DataHelper { /** * sharepreference方式存储 * * @param context XML的文件名，通常取模块名 * @param key 存储在XML中的key * @param value 值 */ public static void putData2SharedPreferences(Context context, String moduleName, String key, Object value) { SharedPreferences sharedPreferences = context.getSharedPreferences(moduleName, Context.MODE_PRIVATE); // 私有数据 Editor editor = sharedPreferences.edit(); if (value instanceof Boolean) { editor.putBoolean(key, (Boolean) value); } else if (value instanceof Integer) { editor.putInt(key, (Integer) value); } else if (value instanceof String) { editor.putString(key, (String) value); } else if (value instanceof Long) { editor.putLong(key, (Long) value); } else if (value instanceof Float) { editor.putFloat(key, (Float) value); } editor.apply(); } public static String getStringFromSharedPreferences(Context context, String name , String key) { SharedPreferences sharedPreferences = context.getSharedPreferences(name, Context.MODE_PRIVATE); // 私有数据 return sharedPreferences.getString(key, ""); } public static Boolean getBooleanFromSharedPreferences(Context context, String name , String key) { SharedPreferences sharedPreferences = context.getSharedPreferences(name, Context.MODE_PRIVATE); // 私有数据 return sharedPreferences.getBoolean(key, false); } public static int getIntFromSharedPreferences(Context context, String name , String key) { SharedPreferences sharedPreferences = context.getSharedPreferences(name, Context.MODE_PRIVATE); // 私有数据 return sharedPreferences.getInt(key, -1); } }