//第一部分创建数据库表格
public class MySqlDataBase extends SQLiteOpenHelper {
public MySqlDataBase(Context context) {
/*
* °æ±¾ºÅ²»Äܸø0
* */
super(context, "Week_Two", null, 1);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("create table Week(name varchar(20),project varchar(20))");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}
//第二部分 写Dao层代码,实现增删改查
public class MySqlDao {
private SQLiteDatabase db;
private MySqlDataBase ms;
private List<Person> list;
public MySqlDao(Context context) {
super();
ms = new MySqlDataBase(context);
}
public void add(String name,String project){
db = ms.getWritableDatabase();
db.execSQL("insert into Week(name,project)values('"+name+"','"+project+"');");
db.close();
}
/* ***************************************** */
public List<Person> query(){
SQLiteDatabase db = ms.getWritableDatabase();
Cursor cur = db.rawQuery("select * from Week", new String[]{});
list = new ArrayList<Person>();
while(cur.moveToNext()){
String name = cur.getString(cur.getColumnIndex("name"));
String project = cur.getString(cur.getColumnIndex("project"));
list.add(new Person(name, project));
}
db.close();
return list;
}
/* ************************************** */
public void update(String name,String project){
SQLiteDatabase writableDatabase = ms.getWritableDatabase();
writableDatabase.execSQL("update Week set name=?,project=? where name=?", new Object[]{name,project,name});
writableDatabase.close();
}
}
//在主类中直接通过类调用方法就可以了