如何将SQLite3 创建的数据库与android 程序连接

Question

如题所述

Answer 1

Sqlite3是android自带的一种轻型的数据库，使用的话也是很方便的。
下面是例子：
package yeshu.sqlite3;

import android.app.Activity;

import android.content.ContentValues;

import android.database.Cursor;

import android.database.sqlite.SQLiteDatabase;

import android.os.Bundle;

import android.view.View;

import android.view.View.OnClickListener;

import android.widget.Button;

import android.widget.EditText;

public class sqlite3 extends Activity {

private Button createdatabase;

private Button updatedatabase;

private Button insert;

private Button update;

private Button select;

private Button delete;

private EditText edittext01;

private EditText edittext02;

private String name;

private int id;

private String dbname;

/** Called when the activity is first created. */

@Override

public void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.main);

createdatabase = (Button) findViewById(R.id.xxx);

updatedatabase = (Button)findViewById(R.id.Button02);

insert = (Button)findViewById(R.id.Button03);

update = (Button)findViewById(R.id.Button04);

select = (Button)findViewById(R.id.Button05);

delete = (Button)findViewById(R.id.Button06);

edittext01 = (EditText)findViewById(R.id.EditText01);

edittext02 = (EditText)findViewById(R.id.EditText02);

createdatabase.setOnClickListener(new OnClickListener_create());

updatedatabase.setOnClickListener(new OnClickListener_updatedatabase());

insert.setOnClickListener(new OnClickListener_insert());

update.setOnClickListener(new OnClickListener_update());

select.setOnClickListener(new OnClickListener_select());

delete.setOnClickListener(new OnClickListener_delete());

}

class OnClickListener_delete implements OnClickListener

{

public void onClick(View v) {

// TODO Auto-generated method stub

id = Integer.parseInt(edittext01.getText().toString());

Data temp = new Data(sqlite3.this, "data_yeshu");

SQLiteDatabase db = temp.getWritableDatabase();

db.delete("user", "id=?", new String[]{id+""});

}

}

class OnClickListener_insert implements OnClickListener

{

public void onClick(View v) {

// TODO Auto-generated method stub

name = edittext02.getText().toString();

id = Integer.parseInt(edittext01.getText().toString());

Data temp = new Data(sqlite3.this, "data_yeshu");

SQLiteDatabase db = temp.getWritableDatabase();

ContentValues value = new ContentValues();

value.put("id", id);

value.put("name", name);

db.insert("user", null, value);

System.out.println("insert");

}

}

class OnClickListener_update implements OnClickListener

{

public void onClick(View v) {

// TODO Auto-generated method stub

name = edittext02.getText().toString();

id = Integer.parseInt(edittext01.getText().toString());

Data temp = new Data(sqlite3.this, "data_yeshu");

SQLiteDatabase db = temp.getWritableDatabase();

ContentValues value = new ContentValues();

value.put("name", name);

db.update("user", value, "id=?", new String[]{id+""});

}

}

class OnClickListener_updatedatabase implements OnClickListener

{

public void onClick(View v) {

// TODO Auto-generated method stub

Data temp = new Data(sqlite3.this, "data_yeshu", 2);

SQLiteDatabase db = temp.getReadableDatabase();

}

}

class OnClickListener_select implements OnClickListener

{

public void onClick(View v) {

// TODO Auto-generated method stub

Data temp = new Data(sqlite3.this, "data_yeshu");

SQLiteDatabase db = temp.getReadableDatabase();

Cursor cursor = db.query("user", new String[]{"id", "name"}, "id=?", new String[]{"1"}, null, null, null);

while(cursor.moveToNext())

{

System.out.println(cursor.getShort(cursor.getColumnIndex("id")));

System.out.println(cursor.getString(cursor.getColumnIndex("name")));

}

}

}

class OnClickListener_create implements OnClickListener

{

public void onClick(View v) {

// TODO Auto-generated method stub

Data temp = new Data(sqlite3.this, "data_yeshu");

SQLiteDatabase db = temp.getReadableDatabase();

}

}

}

================================

package yeshu.sqlite3;

import android.content.Context;

import android.database.sqlite.SQLiteDatabase;

import android.database.sqlite.SQLiteDatabase.CursorFactory;

import android.database.sqlite.SQLiteOpenHelper;

public class Data extends SQLiteOpenHelper {

private static final int VERSION = 1;

public Data(Context context, String name, CursorFactory factory,

int version) {

super(context, name, factory, version);

// TODO Auto-generated constructor stub

}

public Data(Context context, String name, int version)

{

this(context, name, null, version);

}

public Data(Context context , String name)

{

this(context, name, null, VERSION);

}

@Override

public void onCreate(SQLiteDatabase db) {

// TODO Auto-generated method stub

System.out.println("create a new database");

db.execSQL("create table user(id int, name VERCHAR(20))");

}

@Override

public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

// TODO Auto-generated method stub

System.out.println("update a database");

}

}

Answer 2

连接代码？网上搜搜。。