新手SQLite数据库操作（转）

fu.java 文件 

package demo.fu;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Map;

import android.app.Activity;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.Button;
import android.widget.ListView;
import android.widget.SimpleAdapter;
import android.widget.Toast;
public class fu extends Activity {
/* 全局变量 */
private static String DATABASE_NAME = "ENEST";
private static int DATABASE_VERSION = 2;
public static String TABLE_NAME_ONE = "ONE";
public static String TITLE_ONE = "Title_one";
public static String BODY_ONE = "Body_one";

public static DatabaseHelper mOpenHelper;
private static int Num_0 = 0;
private static int Num_1 = 1;
private static int Num_2 = 2;
public static ArrayList<Map<String, Object>> arraylistmap;
public static Cursor myCursor_one;

public static String mytitle;
public static String mybody;
public static HashMap<String, Object> mymap;
/* 数据库HELPER类 */
static class DatabaseHelper extends SQLiteOpenHelper {
  public DatabaseHelper(Context context) {
  
   super(context, DATABASE_NAME, null, DATABASE_VERSION);
   // TODO Auto-generated constructor stub
  }
  @Override
  public void onCreate(SQLiteDatabase db) {
      //新建一个表，以及表内的字段。
   //TODO Auto-generated method stub
   //String sql = "CREATE TABLE " + TABLE_NAME_ONE + "(" + TITLE_ONE
   //+ " text not null, " + BODY_ONE + " text not null " + ");";
   //db.execSQL(sql);
  }
  @Override
  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
   // TODO Auto-generated method stub
  }
}
/* 创建TABLE ONE */
private void create_one() {
  SQLiteDatabase db = mOpenHelper.getWritableDatabase();
  String sql = "CREATE TABLE " + TABLE_NAME_ONE + "(" + TITLE_ONE
    + " text not null, " + BODY_ONE + " text not null "