android studio 使用sqlite 进行数据库操作

android studio 使用sqlite 进行数据库操作

话不多说，看代码
一下是我写的，虽然不是太好，但不过还是勉强可以看看的
这是实现的效果图

（MyDatabases类）

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.widget.Toast;

public class MyDatabases extends SQLiteOpenHelper {//继承SQLiteOpenHelper类，创建数据库
// autoincrement设置自动递增，只有主键可以实现自动递增
// 创建表语句
private static final String name = “Student”;//定义数据库名称
private Context mcontext;
private static final String sql = “create table Student(” +
“id integer primary key autoincrement,” +
“name text,” +
“number real)”;
public MyDatabases(Context context) {
//context连接上下文对象，name数据库名称，factory默认为null，（为null时使用SQLiteOpenHelper中的onCreate和onUpgrade方法）
/new后自己重写这两个方法，version数据库版本号/
super (context, name, null, 1);
mcontext = context;
}
@Override
public void onCreate(SQLiteDatabase db) {
/数据库存在时，调用创建表的方法，若不存在创建数据库，并创建表/
// 在创建数据库时调用次方法，只调用一次
// 创建数据库时需要调用getWritableDatabase（）方法才能创建数据库
db.execSQL (sql);
Toast.makeText (mcontext,“创建成功”,Toast.LENGTH_SHORT).show ();
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// 次方法在跟新数据库时调用，int oldVersion, int newVersion值增加时，数据库更新
}
}

（MainActivity类）

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.Button;
import android.widget.EditText;
import android.widget.TextView;
import android.widget.Toast;
public class MainActivity extends AppCompatActivity {
private MyDatabases databases;
private Button createDatabase;
private Button insertDatabase;
private Button selectDatabase;
private Button deleteDatabase;
private TextView foundDatabase;
private EditText username;
private EditText number;
private EditText delect;
ContentValues values;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate (savedInstanceState);
setContentView (R.layout.activity_main);
//调用MyDatabases类创建数据库
databases = new MyDatabases (MainActivity.this);
//创建数据库按钮
createDatabase = (Button) findViewById (R.id.create);
createDatabase.setOnClickListener (new View.OnClickListener () {
@Override
public void onClick(View v) {
databases.getWritableDatabase ();
}
});

// 插入数据按钮
username = (EditText) findViewById (R.id.username);
number = (EditText) findViewById (R.id.number);
insertDatabase = (Button) findViewById (R.id.insert);
insertDatabase.setOnClickListener (new View.OnClickListener () {
@Override
public void onClick(View v) {
String name = username.getText ().toString ();
int Number = Integer.parseInt (number.getText ().toString ());
values = new ContentValues ();//使用ContentValues（）方法添加数据
// 在每次需要使用sql语句是都需要获取SQLiteDatabase对象
SQLiteDatabase db = databases.getWritableDatabase ();
values.put (“name”,name);
values.put (“number”,Number);
db.insert (“Student”,null,values);
Toast.makeText (MainActivity.this,“插入数据成功”,Toast.LENGTH_SHORT).show ();
}
});

// 查询所有数据按钮
selectDatabase = (Button) findViewById (R.id.select);
foundDatabase =(TextView) findViewById (R.id.found);
selectDatabase.setOnClickListener (new View.OnClickListener () {
@Override
public void onClick(View v) {
SQLiteDatabase db = databases.getWritableDatabase ();
// 设置游标cursor
Cursor cursor = db.query (“Student”,null,null,null,null,null,null);
if(cursor.moveToFirst ()){
do{
String id = cursor.getString (cursor.getColumnIndex (“id”));
String name = cursor.getString (cursor.getColumnIndex (“name”));
int number = cursor.getInt (cursor.getColumnIndex (“number”));
Log.d (“MainActivity”,“学号：”+id);
Log.d (“MainActivity”,“姓名：”+name);
Log.d (“MainActivity”,“电话号码：”+number);
foundDatabase.setText (“学号：”+id+" 姓名："+name+“电话号码：”+number);
}while (cursor.moveToNext ());
cursor.close ();
}
}
});
// 删除数据按钮
delect = (EditText) findViewById (R.id.delect);
deleteDatabase = (Button) findViewById (R.id.delete);
deleteDatabase.setOnClickListener (new View.OnClickListener () {
@Override
public void onClick(View v) {
String delete = delect.getText ().toString ();
SQLiteDatabase db = databases.getWritableDatabase ();
db.delete (“Student”,“name=?”,new String[]{delete});
Toast.makeText (MainActivity.this,“删除数据成功”,Toast.LENGTH_LONG).show ();
}
});
}
}

总体来就是这样写的，还有一些功能没有实现，比如单个条件查询，