首先我们需要一个MySQLite的类去实现SQLiteOpenHelper接口
package com.example.part_seven;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class MyHelper extends SQLiteOpenHelper {
//实现SQLite的构造 创建数据库 xx.db;
public MyHelper(Context context) {
//上下文 库名 null ,版本号
super(context, "student.db", null,1);
}
//onCreate是创建表和添加表数据
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("create table user(stu_id integer primary key autoincrement,name varchar(20),age integer)");
db.execSQL("insert into user values(null,'武帝',10)");
}
//这个方法是更新版本操作
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}
主类实现:
有两中方法可以实现 一个是实现我们自定义的MySQLite
MyHelper myHelper = new MyHelper(this);
myHelper.getWritableDatabase();
另外一种是
ContemtView
new 对象
put(“列明”,“值”);
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.ArrayAdapter;
import android.widget.ListView;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
public class MainActivity extends AppCompatActivity {
SQLiteDatabase db;
ListView listView;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
listView=findViewById(R.id.list);
MyHelper myHelper = new MyHelper(this);
db = myHelper.getWritableDatabase();
}
public void insert_data(View view){
db.execSQL("insert into user values(null,'狠人大帝',20)");
find_data();
// ContentValues contentValues = new ContentValues();
// contentValues.put(“name”,“狠人大帝”);
// contentValues.put(“age”,10);
// db.insert(“User”,null,contentValues);
}
public void delete_data(View view){
// db.execSQL(“delete from user where age = 20”);
db.delete("user","name=?",new String[]{"狠人大帝"});
find_data();
}
public void update_data(View view){
db.execSQL("update user set name='无始大帝' where name='狠人大帝'");
find_data();
// ContentValues contentValues = new ContentValues();
// contentValues.put(“age”,40);
// db.update(“User”,contentValues,“age=? or name=?”,new String[]{“10”,“狠人大帝”});
}
public void find_data(){
Cursor cursor = db.rawQuery("select * from user", null);
List<HashMap<String,Object>>mapList=new ArrayList<>();
MyAdapter myAdapter;
while(cursor.moveToNext()){
String name = cursor.getString(cursor.getColumnIndex("name"));
int stu_id = cursor.getInt(cursor.getColumnIndex("stu_id"));
int age = cursor.getInt(cursor.getColumnIndex("age"));
Uu uu = new Uu();
uu.name=name;
uu.id=stu_id;
uu.age=age;
HashMap<String, Object> map = new HashMap<>();
map.put("user",uu.toString());
Log.e("##",map.toString());
mapList.add(map);
Log.e("##",uu.toString());
}
myAdapter= new MyAdapter(MainActivity.this, mapList);
myAdapter.notifyDataSetChanged();
listView.setAdapter(myAdapter);
// db.query(“User”,null,“name=?”,new String[]{“富贵”},null,null,null);
// Cursor query = db.query(“User”, new String[]{“name”}, “age=?”, new String[]{“10”}, “name”, “id=29”, “age”);
// ArrayList arr = new ArrayList<>();
// while (query.moveToNext()){
// String name = query.getString(query.getColumnIndex(“name”));
//
// Uu u=new Uu();
// u.name=name;
// arr.add(u);
// }
}
class Uu{
String name;
int id;
int age;
@Override
public String toString() {
return "Uu{" +
"name='" + name + '\'' +
", id=" + id +
", age=" + age +
'}';
}
}
}
实现效果: