android sqlite创建数据库

Question

androidsqlite数据库

Answer 1

package db.cqupt;import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;public class DBconnection extends SQLiteOpenHelper{
private final static int DATABASE_VERSION=1;
private final static String DATABASE_NAME="book.db";
private static Context context;
public static void setContext(Context context){
DBconnection.context=context;
}
public DBconnection(){
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
public void onCreate(SQLiteDatabase db){
String sql="CREATE TABLE book("
+"id VARCHAR(30) NOT NULL,"
+"name VARCHAR(30) NOT NULL,"
+"price VARCHAR(30) NOT NULL);";
db.execSQL(sql);
}
public void onUpgrade(SQLiteDatabase db,int oldVersion,int newVersion){

}
public SQLiteDatabase getConnection(){
SQLiteDatabase db=getWritableDatabase();
return db;
}
public void close(SQLiteDatabase db){
db.close();
}
}

Answer 2

package control.cqupt;import model.cqupt.Book;
import model.cqupt.BookList;public class Controller{
public boolean addBook(String id,String name,String price){
BookList booklist = BookList.getBookList();
Book book=new Book(id,name,price);
if(booklist.insert(book))
return true;
else 
return false;
}
public boolean deleteBook(String name){
BookList booklist = BookList.getBookList();
if(booklist.delete(name))
return true;
else 
return false;
}
public boolean setBook(String id,String name,String price){
BookList booklist = BookList.getBookList();
Book book=new Book(id,name,price);
if(booklist.set(book))
return true;
else 
return false;
}
public BookList searchBook(){
BookList booklist = BookList.getBookList();
return booklist;
}

}

Answer 3

http://bbs.csdn.net/topics/390946061?page=1#post-398622737