基于Andriod平台的安卓记事本程序源码.doc
文本预览下载声明
DatabaseHelper.java
package com.notepad.namespace;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
public class DatabaseHelper extends SQLiteOpenHelper {
private String tableName = record;
private Context mContext = null;
private String sql = create table if not exists + tableName +
(_id integer primary key autoincrement, +
title varchar, +
content text, +
time varchar);
public DatabaseHelper(Context context, String name, CursorFactory factory,
int version) {
super(context, name, factory, version);
// TODO Auto-generated constructor stub
}
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
//创建表
db.execSQL(sql);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
}
}
DatabaseManage.java
package com.notepad.namespace;
import java.util.Date;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.util.Log;
public class DatabaseManage {
private Context mContext = null;
private SQLiteDatabase mSQLiteDatabase = null;//用于操作数据库的对象
private DatabaseHelper dh = null;//用于创建数据库的对象
private String dbName = notepad.db;
private int dbVersion = 1;
public DatabaseManage(Context context){
mContext = context;
}
/**
* 打开数据库
*/
public void open(){
try{
dh = new DatabaseHelper(mContext, dbName, null, dbVersion);
if(dh == null){
Log.v(msg, is null);
return ;
}
mSQLiteDatabase = dh.getWritableDatabase();
//dh.onOpen(mSQLiteDatabase);
}catch(SQLiteException se){
se.printStackTrace();
}
}
/**
* 关闭数据库
*/
public void close(){
mSQLiteDatabase.close(
显示全部