packagecom.zhou.db;importjava.util.ArrayList;importjava.util.List;importcom.zhou.utils.Books;importcom.zhou.utils.Reader;importandroid.content.ContentValues;importandroid.content.Context;importandroid.database.Cursor;importandroid.database.sqlite.SQLiteDatabase;importandroid.util.Log;public classReaderManager {
ReaderOpenHelper readerOpenHelper;
Context context;publicReaderManager(Context conetxt) {this.context =context;
readerOpenHelper= newReaderOpenHelper(conetxt);
}//增加读者
public voidaddSQL(Reader reader) {
SQLiteDatabase db= null;try{
db=readerOpenHelper.getWritableDatabase();
ContentValues values= newContentValues();
values.put("renumber", reader.getReNumber());
values.put("rename", reader.getName());
values.put("retype", reader.getSex());
values.put("reage", reader.getAge());
values.put("rephone", reader.getPhoneNumber());
values.put("createtime", reader.getCreateTime());
values.put("usename", reader.getUseName());
values.put("password", reader.getPassword());
db.insert("readers", null, values);
}catch(Exception e) {//TODO: handle exception
} finally{
db.close();
}
}//增加图书
public voidbookAddSQL(Books book) {
SQLiteDatabase db= null;try{
db=readerOpenHelper.getWritableDatabase();
ContentValues values= newContentValues();
values.put("booknumber", book.getBookNumber());
values.put("bookname", book.getBookName());
values.put("booktype", book.getBookType());
values.put("bookeditor", book.getBookEditer());
values.put("intime", book.getInTime());
values.put("incounts", book.getCount());
db.insert("books", null, values);
}catch(Exception e) {//TODO: handle exception
} finally{
db.close();
}
}//读者查询
public ListselectSQL() {
List list = new ArrayList();
SQLiteDatabase db= null;//获取一个光标对象
Cursor cursor = null;try{
db=readerOpenHelper.getReadableDatabase();
cursor= db.query("readers", null, null, null, null, null, null);
Reader reader= null;while(cursor.moveToNext()) {
reader= newReader();
reader.setReNumber(cursor.getInt(cursor
.getColumnIndex("renumber")));
reader.setName(cursor.getString(cursor.getColumnIndex("rename")));
reader.setSex(cursor.getString(cursor.getColumnIndex("retype")));
reader.setAge(cursor.getString(cursor.getColumnIndex("reage")));
reader.setPhoneNumber(cursor.getString(cursor
.getColumnIndex("rephone")));
reader.setCreateTime(cursor.getString(cursor
.getColumnIndex("createtime")));
reader.setUseName(cursor.getInt(cursor
.getColumnIndex("usename")));
reader.setPassword(cursor.getInt(cursor
.getColumnIndex("password")));
list.add(reader);
}
}catch(Exception e) {//TODO: handle exception
} finally{
cursor.close();
db.close();
}returnlist;
}//图书查询
public ListbookSelectSQL() {
List list = new ArrayList();
SQLiteDatabase db= null;//获取一个光标对象
Cursor cursor = null;try{
db=readerOpenHelper.getReadableDatabase();
cursor= db.query("books", null, null, null, null, null, null);
Books book= null;while(cursor.moveToNext()) {
book= newBooks();
book.setBookNumber(cursor.getInt(cursor
.getColumnIndex("booknumber")));
book.setBookName(cursor.getString(cursor
.getColumnIndex("bookname")));
book.setBookType(cursor.getString(cursor
.getColumnIndex("booktype")));
book.setBookEditer(cursor.getString(cursor
.getColumnIndex("bookeditor")));
book.setInTime(cursor.getString(cursor.getColumnIndex("intime")));
book.setCount(cursor.getInt(cursor.getColumnIndex("incounts")));
Log.d("TAGG", cursor.getString(cursor.getColumnIndex("intime")));
list.add(book);
}
}catch(Exception e) {//TODO: handle exception
} finally{
cursor.close();
db.close();
}returnlist;
}//读者删除
public void deleteSQL(final longid) {
SQLiteDatabase db= null;try{
db=readerOpenHelper.getWritableDatabase();
db.delete("readers", "renumber=" + id, null);
}catch(Exception e) {
}finally{
db.close();
}
}//读者更新
public void updateData(intid, String name, String sex, String age,
String phoneNumber,intpassword) {
SQLiteDatabase db= null;try{
db=readerOpenHelper.getWritableDatabase();
ContentValues values= newContentValues();
values.put("rename", name);
values.put("retype", sex);
values.put("reage", age);
values.put("rephone", phoneNumber);
values.put("password", password);
db.update("readers", values, "renumber=" + id, null);
}catch(Exception e) {//TODO: handle exception
} finally{
db.close();
}
}//public long getCount() {//
//Cursor cursor = null;//long count = 0;//SQLiteDatabase db = null;//try {//db = readerOpenHelper.getWritableDatabase();//cursor = db.query("readers", null, null, null, null, null, null);//
//if (null != cursor) {//count = cursor.getCount();//cursor.close();//}//} catch (Exception e) {//} finally {//db.close();//}//return count;//}
}