数据库SQlite:
SQlite语句:
添加表: 表名为 userinfo (主键 类型 , 组名 文本类型 , 组名 文本类型)
create table userinfo (_id integer primary key autoincrement, username text,phone text);
插入数据: 表名为 userinfo (组名,组名) valeue (插入对应的数据)
insert into userinfo (username,phone) values ("张三","123456");
修改数据: 把username为张三改为username为李四
update userinfo set username="李四" where username="张三"
查询数据: 查询username ,phone 从userinfo表中 username为李四的一组数据
select username,phone from userinfo where username="李四"
删除数据: 删除username中 username为李四的一组数据
delete from userinfo where username="李四"
数据库的增删查改
mainActivity:
import android.os.Bundle;
import android.support.v7.app.AppCompatActivity;
import android.util.Log;
import android.view.View;
/**
* 1.创建4个按钮,分别是增删查改,设置点击事件
* 2.新建一个类继承SQLiteOpenHelper,并创建表
* 3.新建一个类来放常量池
* 4.新建一个Dao类,分别创建增删查改方法
* 5.分别传值调用Dao方法
*/
public class MainActivity extends AppCompatActivity {
private UserDao userDao;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
}
public void insert(View view) {
userDao = new UserDao(this);
userDao.insertUser("张三", "13416662723");
}
public void delete(View view) {
userDao.deleteUser("李四");
}
public void query(View view) {
UserDao.User user = userDao.queryUser("李四");
if (user != null) {
Log.v(" 520it", user.toString());
}
}
public void update(View view) {
userDao.updateUser("张三", "李四");
}
}
我的数据帮助类:
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class MyDbOpenHelper extends SQLiteOpenHelper {
public static final String DB_NAME = "user.db";
public static final int DB_VERSION = 1;
public MyDbOpenHelper(Context context) {
// name 数据库⽂件名称
// factory 游标⼯⼚ 默认为null
// version 数据库版本
super(context, DB_NAME, null, DB_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
//因为经常会用到这些常量,所以封装到常量池
db.execSQL("create table " + UserConst.USER_TABLE + " ( " +
UserConst._ID + " integer primary key autoincrement , " +
UserConst.USER_NAME + " text, " +
UserConst.PHONE + " text);");
}
@Override//数据库版本更新才调用这个方法
//升级数据库表的操作
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}
常量类:
import android.provider.BaseColumns;
//实现这个接口,因为里面有两个常量_id和_count
public class UserConst implements BaseColumns {
public static final String USER_TABLE= "userinfo";
public static final String USER_NAME = "username" ;
public static final String PHONE = "phone " ;
}
增删查改Dao:
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
public class UserDao {
private MyDbOpenHelper mHelper;
private SQLiteDatabase db;
public UserDao(Context c) {
mHelper = new MyDbOpenHelper(c);
db = mHelper.getWritableDatabase();
}
public void insertUser(String name, String phone) {
//后面string数据代表插入的数据,传进来的数据,?号代表固定改变的值
db.execSQL("insert into userinfo (username,phone) values (?,?);", new String[]{name, phone});
}
public void updateUser(String olderName, String newName) {
db.execSQL("update userinfo set username=? where username=?", new String[]{newName, olderName});
}
public User queryUser(String name) {
//Cursor 游标对象
Cursor cursor = db.rawQuery("select username,phone from userinfo where username=?);", new String[]{name});
//cursor.moveToNext() 相当于让游标移动到下一行,如果下一行有数据,则返回ture
while (cursor.moveToNext()) {
String username = cursor.getString(0);
String phone = cursor.getString(0);
return new User(username, phone);
}
return null;
}
public void deleteUser(String username) {
db.execSQL("delete from userinfo where username=?", new String[]{username});
}
public class User {
private String name;
private String phone;
public User(String username, String phone) {
this.name =username;
this.phone = phone;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
}
}
Sqlite3⼯具的位置: D:\AndroidSDK\platform-toolssqlite3.exe
- 先执⾏adb -s 模拟器名称 shell
- linux shell命令: cd /data/data/包名/databases 到databases⽬录下 pwd 查看当前的⽬录位置
Sqlite3⼯具常⽤操作: sqlite3 数据库⽂件名(进⼊了数据库)
查看该⽂件下的所有数据库表 .tables
Sqlite3⼯具的使⽤
查看某个数据库表结构 select * from 表名;
退出sqlite3 .quit