android中的sqlite实现程序

package org.hxsd.events;
 
import static android.provider.BaseColumns._ID;
import static org.hxsd.events.Constants.TABLE_NAME;
import static org.hxsd.events.Constants.TIME;
import static org.hxsd.events.Constants.TITLE;
import android.app.ListActivity;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.widget.SimpleCursorAdapter;
 
public class Events extends ListActivity {
 private EventsData events;
 //查询的字段
 private static String[] FROM = {_ID, TIME, TITLE};
 //排序
 private static String ORDER_BY = TIME + " DESC";
 //显示
 private static int[] TO = {R.id.rowid, R.id.time, R.id.title};
 
    /** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        events = new EventsData(this);
        try{
         //添加记录
         addEvent("Hello, Android!");
         //获得记录信息
         Cursor cursor = getEvents();
         //显示记录信息
         showEvents(cursor);
        }finally{
         //关闭数据库
         events.close();
        }
    }
 
    /**
     * 添加数据
     * @param string
     */
    private void addEvent(String string){
     SQLiteDatabase db = events.getWritableDatabase();
     ContentValues values = new ContentValues();
     values.put(TIME, System.currentTimeMillis());
     values.put(TITLE, string);
     db.insertOrThrow(TABLE_NAME, null, values);
    }
 
    /**
     * 获得记录
     * @return
     */
    private Cursor getEvents(){
     SQLiteDatabase db = events.getReadableDatabase();
     Cursor cursor = db.query(TABLE_NAME, FROM, null, null, null, null, ORDER_BY);
     startManagingCursor(cursor);
     return cursor;
    }
 
    /**
     * 显示记录
     * @param cursor
     */
    private void showEvents(Cursor cursor){
     /*StringBuilder builder = new StringBuilder("Saved events:n");
     while(cursor.moveToNext()){
      long id = cursor.getLong(0);
      long time = cursor.getLong(1);
      String title = cursor.getString(2);
      builder.append(id).append(": ");
      builder.append(time).append(": ");
      builder.append(title).append("n");
     }
     TextView textView = (TextView) findViewById(R.id.TextView01);
     textView.setText(builder);*/
 
     SimpleCursorAdapter adapter = new SimpleCursorAdapter(this, R.layout.item, cursor, FROM, TO);
     setListAdapter(adapter);
    }
}
EventsData.java文件大致如下：

package org.hxsd.events;
 
import static android.provider.BaseColumns._ID;
import static org.hxsd.events.Constants.TABLE_NAME;
import static org.hxsd.events.Constants.TIME;
import static org.hxsd.events.Constants.TITLE;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
 
public class EventsData extends SQLiteOpenHelper{
 //数据库名称
 private static final String DATABASE_NAME = "events.db";
 //数据库版本
 private static final int DATABASE_VERSION = 2;
 
 //构造函数
 public EventsData(Context ctx){
  super(ctx, DATABASE_NAME, null, DATABASE_VERSION);
 }
 
 @Override
 public void onCreate(SQLiteDatabase db) {
  // 创建数据表events
  db.execSQL("CREATE TABLE " + TABLE_NAME + "(" + _ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + TIME + " INTEGER," + TITLE + " TEXT NOT NULL)");
 }
 
 @Override
 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  //如果版本有改动，删除表events然后新建
  db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
  onCreate(db);
 }
 
}

package org.hxsd.events;
 
import android.provider.BaseColumns;
 
public interface Constants extends BaseColumns{
 //表名称
   public static final String TABLE_NAME = "events";
   //字段名称
   public static final String TIME = "time";
   public static final String TITLE = "title";
}
item.xml文件为布局文件，位于res文件夹下的layout下面，大致如下：

<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout
 xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent"
    android:padding="10dip"
    android:orientation="horizontal"
    >
<TextView 
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:id="@+id/rowid"
    android:paddingRight="40dip"/>
<TextView 
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:id="@+id/time"
    android:layout_toRightOf="@id/rowid"
    android:paddingRight="40dip"/>
<TextView 
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:id="@+id/title"
    android:layout_toRightOf="@id/time"
    android:paddingRight="40dip"/>
</RelativeLayout>

froyopackagesappsLauncher2reslayout-landworkspace_screen.xml

froyopackagesappsLauncher2reslayout-portworkspace_screen.xml

launcher:shortAxisCells=”4″

launcher:longAxisCells=”4″

launcher:longAxisStartPadding=”65dip”

launcher:longAxisEndPadding=”65dip”

launcher:shortAxisStartPadding=”0dip”
launcher:shortAxisEndPadding=”0dip”

 
package org.loon.game.lgametest1;
 
import org.loon.framework.android.game.core.graphics.Screen;
import org.loon.framework.android.game.core.graphics.opengl.GLEx;
import org.loon.framework.android.game.core.graphics.opengl.LTexture;
import org.loon.framework.android.game.core.input.LTouch;
import org.loon.framework.android.game.core.timer.LTimerContext;
 
import android.util.Log;
 
public class TestScreen extends Screen {
 
 private LTexture[] images;
 
 @Override
 public void onLoad() {
                //记录日志
  Log.d("LGAMETEST1", "here it is onLoad");
 
  LTexture.AUTO_LINEAR();
  images = new LTexture[1];
 
                //assets放置资源文件
  images[0] = new LTexture("assets/background.png");
 
  //设置当前Screen的背景图片
  setBackground(getImage(0));
 
  //背景音乐,"main.mp3"文件放置在assets文件夹下面
  playAssetsMusic("main.mp3", true);
 }
 
 /**
  * 获得图片
  * @param i
  * @return LTexture
  */
 public LTexture getImage(int i) {
  return images[i];
 }
 
 @Override
 public void alter(LTimerContext arg0) {
  // TODO Auto-generated method stub
 
 }
 
 @Override
 public void draw(GLEx arg0) {
  // TODO Auto-generated method stub
 
 }
 
 @Override
 public void touchDown(LTouch arg0) {
  // TODO Auto-generated method stub
 
 }
 
 @Override
 public void touchMove(LTouch arg0) {
  // TODO Auto-generated method stub
 
 }
 
 @Override
 public void touchUp(LTouch arg0) {
  // TODO Auto-generated method stub
 
 }
}

半透明 <RelativeLayout android:background=”#c0000000″…>
完全不透明<RelativeLayout android:background=”#ff000000″ … />
完全透明<RelativeLayout android:background=”#00000000″ … />