?

<?xml version="1.0" encoding="utf-8"?><manifest xmlns:android="http://schemas.android.com/apk/res/android"package="cn.itcast.db"android:versionCode="1"android:versionName="1.0" ><uses-sdk android:minSdkVersion="8" /><applicationandroid:icon="@drawable/ic_launcher"android:label="@string/app_name" ><activityandroid:name=".MainActivity"android:label="@string/app_name" ><intent-filter><action android:name="android.intent.action.MAIN" /><category android:name="android.intent.category.LAUNCHER" /></intent-filter></activity><uses-library android:name="android.test.runner"/></application><instrumentation android:name="android.test.InstrumentationTestRunner"android:targetPackage="cn.itcast.db" android:label="Tests for My App"></instrumentation></manifest> package cn.itcast.db;import android.app.Activity;import android.os.Bundle;public class MainActivity extends Activity {/** Called when the activity is first created. */@Overridepublic void onCreate(Bundle savedInstanceState) {super.onCreate(savedInstanceState);setContentView(R.layout.main);}//在Android平臺上，集成了一個嵌入式關系型數據庫——SQLite//SQLite3支持NULL、INTEGER、REAL(浮點數字)、TEXT(字符串文本)和BLOB(二進制對象)數據類型//雖然它支持的類型只有5種，但實際上sqlite3也接受varchar(n)、char(n)、decimal(p, s)等數據//只不過在運行或保存時會轉成對應的五種數據類型//SQLite最大的特點是你可以把各種類型的數據保存到任何字段中，而不用關心字段聲明的數據類型是什么} package cn.itcast.domain;public class Person {private Integer id;private String name;private String phone;public Person(String name, String phone){this.name = name;this.phone = phone;}public Person(Integer id, String name, String phone){this.id = id;this.name = name;this.phone = phone;}public Integer getId() {return id;}public void setId(Integer id) {this.id = id;}public String getName() {return name;}public void setName(String name) {this.name = name;}public String getPhone() {return phone;}public void setPhone(String phone) {this.phone = phone;} } package cn.itcast.service;import android.content.Context;import android.database.sqlite.SQLiteDatabase;import android.database.sqlite.SQLiteOpenHelper;public class DBOpenHelper extends SQLiteOpenHelper{private static final int VERSION = 2; //數據庫版本public DBOpenHelper(Context context){super(context, "itcast.db", null, VERSION); //<包>/database/}@Overridepublic void onCreate(SQLiteDatabase db) { //是在數據庫第一次被創建的時候調用的db.execSQL("CREATE TABLE person(personId integer primary key autoincrement, " +"name varchar(20))"); }@Overridepublic void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { //數據庫版本號發生改變的時候調用的db.execSQL("ALTER TABLE person ADD phone VARCHAR(12) NULL");}} package cn.itcast.service;import java.util.ArrayList;import java.util.List;import android.content.Context;import android.database.Cursor;import android.database.sqlite.SQLiteDatabase;import cn.itcast.domain.Person;public class PersonService {private DBOpenHelper dbOpenHelper;public PersonService(Context context){this.dbOpenHelper = new DBOpenHelper(context);}/*** 添加記錄* @param person*/public void save(Person person){SQLiteDatabase db = dbOpenHelper.getWritableDatabase();db.execSQL("insert into person(name, phone) values(?, ?)",new Object[]{person.getName(), person.getPhone()});//如果只在一個類中使用db，則不需要關閉，提高性能//但是若是多處使用，則需要關閉// db.close();}/*** 刪除記錄* @param id 記錄ID*/public void delete(Integer id){SQLiteDatabase db = dbOpenHelper.getWritableDatabase();db.execSQL("delete from person where personId=?", new Object[]{id});}/*** 更新記錄* @param person*/public void update(Person person){SQLiteDatabase db = dbOpenHelper.getWritableDatabase();db.execSQL("update person set name=?, phone=? where personId=?",new Object[]{person.getName(), person.getPhone(), person.getId()});}/*** 查詢記錄* @param id 記錄ID* @return*/public Person find(Integer id){SQLiteDatabase db = dbOpenHelper.getReadableDatabase();Cursor cursor = db.rawQuery("select * from person where personId=?",new String[]{id.toString()});if(cursor.moveToFirst()){int personId = cursor.getInt(cursor.getColumnIndex("personId"));String name = cursor.getString(cursor.getColumnIndex("name"));String phone = cursor.getString(cursor.getColumnIndex("phone"));return new Person(personId, name, phone);}cursor.close();return null;}/*** 分布獲取記錄* @param offset 跳過前面 多少條記錄* @param maxResult 每頁獲取多少條記錄* @return*/public List<Person> getScrollData(int offset, int maxResult){List<Person> persons = new ArrayList<Person>();SQLiteDatabase db = dbOpenHelper.getReadableDatabase();Cursor cursor = db.rawQuery("select * from person order by personId asc limit ?,?", new String[]{String.valueOf(offset), String.valueOf(maxResult)});while(cursor.moveToNext()){int personId = cursor.getInt(cursor.getColumnIndex("personId"));String name = cursor.getString(cursor.getColumnIndex("name"));String phone = cursor.getString(cursor.getColumnIndex("phone"));persons.add(new Person(personId, name, phone));}cursor.close();return null;}/*** 獲取記錄總數* @return*/public long getCount(){SQLiteDatabase db = dbOpenHelper.getReadableDatabase();Cursor cursor = db.rawQuery("select count(*) from person", null);cursor.moveToFirst();long result = cursor.getLong(0);cursor.close();return result;}} package cn.itcast.test;import java.util.List;import cn.itcast.domain.Person;import cn.itcast.service.DBOpenHelper;import cn.itcast.service.PersonService;import android.test.AndroidTestCase;import android.util.Log;public class PersonServiceTest extends AndroidTestCase{private static final String TAG = "PersonServiceTest";public void testCreateDB() throws Exception{DBOpenHelper dbOpenHelper = new DBOpenHelper(getContext());dbOpenHelper.getWritableDatabase();} public void testSave() throws Exception{PersonService service = new PersonService(this.getContext());for(int i = 0; i < 20; i++){Person person = new Person("zhangsan", "123456");service.save(person);}}public void testDelete() throws Exception{PersonService service = new PersonService(this.getContext());service.delete(21);}public void testUpdate() throws Exception{PersonService service = new PersonService(this.getContext());Person person = service.find(1);person.setName("zhangxiaoxiao");service.update(person);}public void testFind() throws Exception{PersonService service = new PersonService(this.getContext());Person person = service.find(1);Log.i(TAG, person.toString());}public void testScrollData() throws Exception{PersonService service = new PersonService(this.getContext());List<Person> persons = service.getScrollData(0, 5);for(Person person : persons){Log.i(TAG, person.toString());}}public void testCount() throws Exception{PersonService service = new PersonService(this.getContext());long result = service.getCount();Log.i(TAG, result + "");}//除了execSQL()和rawQuery方法，還提供了對應于添加、刪除、更新、查詢的操作方法//insert(), delete(), update(), query()}

原帖地址：http://www.eoeandroid.com/forum.php?mod=viewthread&tid=201306

轉載于:https://www.cnblogs.com/chenchong/archive/2013/03/04/2942401.html

創作挑戰賽新人創作獎勵來咯，堅持創作打卡瓜分現金大獎

總結

以上是生活随笔為你收集整理的[转载]创建数据库与完成数据添删改查--第一种写法的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。