安卓 mysql 本地_Android 使用SQLite本地数据库

二、程序文件

1、SQLiteHelper.java文件

然后输入以下代码：

packagecom.example.yanlei.my;importandroid.content.ContentValues;importandroid.content.Context;importandroid.database.Cursor;importandroid.database.sqlite.SQLiteDatabase;importandroid.database.sqlite.SQLiteOpenHelper;public class SQLiteHelper extendsSQLiteOpenHelper {private final static String DATABASE_NAME = "Library";private final static int DATABASE_VERSION = 1;private final static String TABLE_NAME = "Book";//构造函数，创建数据库

publicSQLiteHelper(Context context) {super(context, DATABASE_NAME, null, DATABASE_VERSION);

}//建表

public voidonCreate(SQLiteDatabase db) {

String sql= "CREATE TABLE " +TABLE_NAME+ "(_id INTEGER PRIMARY KEY,"

+ " BookName VARCHAR(30) NOT NULL,"

+ " Author VARCHAR(20),"

+ " Publisher VARCHAR(30))";

db.execSQL(sql);

}public void onUpgrade(SQLiteDatabase db, int oldVersion, intnewVersion) {

String sql= "DROP TABLE IF EXISTS " +TABLE_NAME;

db.execSQL(sql);

onCreate(db);

}//获取游标

publicCursor select() {

SQLiteDatabase db= this.getReadableDatabase();

Cursor cursor= db.query(TABLE_NAME, null, null, null, null, null, null);returncursor;

}//插入一条记录

public longinsert(String bookName,String author,String publisher ) {

SQLiteDatabase db= this.getWritableDatabase();

ContentValues cv= newContentValues();

cv.put("BookName", bookName);

cv.put("Author", author);

cv.put("Publisher", publisher);long row =