ver

package com.example.myandroid;import android.app.*;import android.view.*;import android.widget.*;import android.os.*;import android.content.*;import android.content.res.*;import android.graphics.drawable.*;import android.database.*;import android.database.sqlite.*;import android.util.*;import java.util.*;class DatabaseManager extends SQLiteOpenHelper {	public final String	TAG		= "com.example.myandroid.DatabaseManager";	public final String	DBNAME		= "MyDatabaseName";	public final String	DBTABLE		= "serverlist";	DatabaseManager(Context context) {		// calls the super constructor, requesting the default cursor factory.		super(context, "fhs.db", null, 1);	}	@Override	public void onCreate(SQLiteDatabase db) {		db.execSQL("CREATE TABLE IF NOT EXISTS " + DBTABLE + " ( _id INTEGER PRIMARY KEY AUTOINCREMENT, title VARCHAR(32), url TEXT);");	}	@Override	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)	{		// Logs that the database is being upgraded		Log.w(TAG, "Upgrading database from version " + oldVersion + " to "					 + newVersion + ", which will destroy all old data");		// Kills the table and existing data		db.execSQL("DROP TABLE IF EXISTS " + DBTABLE);		// Recreates the database with a new version		onCreate(db);	}}--- and usage:package com.example.myandroid;import android.app.Activity;import android.graphics.*;import android.graphics.drawable.*;import android.view.*;import android.view.LayoutInflater.Factory;import android.view.animation.*;import android.widget.*;import android.widget.AdapterView.OnItemClickListener;import android.os.*;import android.content.*;import android.util.*;import android.database.*;import android.database.sqlite.*;import android.app.AlertDialog.Builder;import android.app.AlertDialog;import android.app.Dialog;import java.io.*;import java.util.*;import org.json.*;import org.apache.http.*;import org.apache.http.client.*;import com.example.myandroid.Connection;public class Settings_EditEntry extends Activity {	private final		String			TAG		= "Settings_EditEntry";	private static		DatabaseManager		dbManager;	private static		SQLiteDatabase		db;		private long					server_id;	@Override	public void onCreate(Bundle savedInstanceState)	{		super.onCreate(savedInstanceState);		setContentView(R.layout.settings_editentry);				if( dbManager == null )			dbManager = new DatabaseManager(this);		if( db == null )			db = dbManager.getWritableDatabase();				Bundle params = getIntent().getExtras();		String action = params.getString("action");		if( action.equals("edit") )		{			server_id = params.getLong("server_id");						Cursor cur = db.query(dbManager.DBTABLE, new String[] {"title", "url"}, "_id=?", new String[] {String.valueOf(server_id)}, null, null, null);			cur.moveToFirst();			String title = cur.getString(0);			String url = cur.getString(1);						EditText w_title = (EditText)findViewById(R.id.settings_editentry_title);			EditText w_url = (EditText)findViewById(R.id.settings_editentry_url);						w_title.setText(title);			w_url.setText(url);						Button b = (Button)findViewById(R.id.settings_editentry_button_delete);			b.setVisibility(View.VISIBLE);					cur.close();		}		else if( action.equals("new") )		{			server_id = 0;		}	}		@Override	public void onDestroy()	{		super.onDestroy();	}		private final int CONFIRM_DELETE = 1;		protected Dialog onCreateDialog(int id) {		switch( id )		{			case CONFIRM_DELETE:				AlertDialog.Builder builder = new AlertDialog.Builder(this);				builder.setMessage("This action cannot be undone.  Are you sure you wish to delete this entry?")					.setCancelable(false)					.setPositiveButton("Yes", new DialogInterface.OnClickListener() {						public void onClick(DialogInterface dialog, int id) {							doDelete();						}					})					.setNegativeButton("No", new DialogInterface.OnClickListener() {						public void onClick(DialogInterface dialog, int id) {							dialog.cancel();						}					});				AlertDialog alert = builder.create();				return alert;			default:		}		return null;	}		public void createEntry(String title, String url)	{		ContentValues vals = new ContentValues();				vals.put("title", title);		vals.put("url", url);				db.insert(dbManager.DBTABLE, null, vals);	}	public void editEntry(long server_id, String title, String url)	{		ContentValues vals = new ContentValues();				vals.put("title", title);		vals.put("url", url);				db.update(dbManager.DBTABLE, vals, "_id=?", new String[] { String.valueOf(server_id) } );	}	public void btnSave(View v)	{		EditText w_title = (EditText)findViewById(R.id.settings_editentry_title);		EditText w_url = (EditText)findViewById(R.id.settings_editentry_url);				String title = w_title.getText().toString();		String url = w_url.getText().toString();		if( server_id == 0 )		{			createEntry(title, url);		}		else		{			editEntry(server_id, title, url);		}				Intent in = new Intent();		in.putExtra("invalid", true);		setResult(1, in);				finish();	}		public void doDelete()	{		db.delete(dbManager.DBTABLE, "_id=?", new String[] { String.valueOf(server_id) });		Intent in = new Intent();		in.putExtra("invalid", true);		setResult(1, in);				finish();	}	public void btnDelete(View v)	{		showDialog(CONFIRM_DELETE);	}		public void btnCancel(View v)	{		finish();	}