今天要实现的功能如下:点击登录,把输入的姓名和学号存储在sqlite数据库里并显示在页面上
主体布局:
Myservice是服务,这次不使用它。
MyDatabaseHelper.java
//创建数据库
public class MyDatabaseHelper extends SQLiteOpenHelper {
public static final String CREATE_Message = "create table Student ("//数据库
+ "id integer primary key autoincrement, "
+ "name text," +
"stuID text)";
private Context mContext;
public MyDatabaseHelper(Context context, String name,
SQLiteDatabase.CursorFactory factory, int version) {
super(context, name, factory, version);
mContext = context;
}
@Override
public void onCreate(SQLiteDatabase db) {//创建数据库
db.execSQL(CREATE_Message);
Toast.makeText(mContext, "Create succeeded", Toast.LENGTH_SHORT).show();
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {//更新数据库
db.execSQL("drop table if exists Student");
onCreate(db);
}
}
AndroidManifest.xml
<?xml version="1.0" e