Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

sqlite Êý¾Ý¿âµÄ²Ù×÷

********´´½¨***********
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
public class DataBaseOpenHelper extends SQLiteOpenHelper {
 public static final String DATABASE_NAME = "my.db";
 /**
  * @param context ÉÏÏÂÎÄ
  * @param name Êý¾Ý¿âµÄÃû³Æ
  * @param factory Óα깤³§ --CursorFactory factoryÒ»°ãÇé¿öÏÂÊDz»ÐèÒªÖ¸¶¨µÄ
  * @param version °æ±¾ µ±ÎÒÃǵİ汾ºÅ¸üеÄʱºòϵͳ»á×Ô¶¯µ÷ÓÃonCreate(SQLiteDatabase db)Õâ¸ö·½·¨
  *
  */
 public DataBaseOpenHelper(Context context,int version) {
  super(context, DATABASE_NAME, null, version);
 }
 /**
  * 1. Õâ¸ö·½·¨ÓÃÓÚ³õʼ»¯Êý¾Ý¿â±í£¬±í½á¹¹µÄ´´½¨
  */
 @Override
 public void onCreate(SQLiteDatabase db) {
  db.execSQL("CREATE TABLE person (personid integer primary key autoincrement, name varchar(20), age integer)");
  
 }
 /**
  * µ±°æ±¾ºÅ¸ü¸ÄµÄʱºò»áµ÷ÓÃÕâ¸ö·½·¨ @Override
  */
 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  db.execSQL("DROP TABLE IF EXISTS person");
        onCreate(db);
 }
}
********²Ù×÷***********
import java.util.ArrayList;
import java.util.List;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import cn.itcast.domain.Person;
import cn.itcast.sqlite.opendb.DataBaseOpenHelper;
public class DataBaseService {
 private DataBaseOpenHelper opendb;
 private SQLiteDatabase db ;
 public DataBaseService(DataBaseOpenHelper opendb) {
  this.opendb = opendb;
  db = this.opendb.getReadableDatabase();
 }
 public void save(Person person) {
  db.execSQL("insert into person(name,age) values(?,?)",new Object[]{person.getName(),person.getAge()})


Ïà¹ØÎĵµ£º

SQLiteÓëC½áºÏ

SQLite¹Ù·½ÍøÕ¾Àý×Ó£º
#include <stdio.h>
#include <sqlite3.h>
static int callback(void *NotUsed, int argc, char **argv, char **azColName){
int i;
for(i=0; i<argc; i++){
printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");
}
printf("\n");
return 0;
}
i ......

SQLiteÊý¾Ý¿âµÄÔöɾ¸Ä²é´úÂë

//ËѼ¯ÕûÀíÁËÒ»ÏÂÍøÉϵĴúÂë.ÕÒÁ˰ëÌì¾ÓÈ»ÕÒ²»µ½Ò»Ìõ²åÈëÓï¾ä.ºÃÓôÃÆµÄ
//¸Ð¾õËÙ¶È»¹¿ÉÒÔ.СÎļþ.ºÜ¶àСӦÓóÌÐòÔÚÓÃÕâ¸öÊý¾Ý¿â
//SQLiteʹÓð취.Ö±½ÓCOPYDLLÎļþSystem.Data.SQLite.DLLµ½Ó¦ÓóÌÐòDEBUGĿ¼Ï¡£ È»ºóÔÚÏîÄ¿ÖÐÌí¼ÓÒýÓÃ,ÕÒµ½Õâ¸öÎļþ¼´¿É
//Ìí¼ÓÒýÓÃ
using System;
using System.Collections.Generic; ......

AutoIt3¿ª·¢µÄ²Ù×÷SQliteÊý¾Ý¿âµÄÔ´Âë

AutoIt3¿ª·¢µÄ²Ù×÷SQliteÊý¾Ý¿âµÄÔ´ÂëÏÂÔØ
²¿·ÖÔ´Âë
_SQLite_Startup () ;¼ÓÔØ SQLite.dll
If Not FileExists($SQLite_Data_Path) Then
    SQLCreate()
EndIf
$GUI_Form = GUICreate($Title, 300, 435, -1, -1)
GUISetBkColor(0xECE9D8)  ; will change background color
$GUI_ListBox = GUIC ......

SQLite°Ù¶È


[±à¼­±¾¶Î
]
SQLite¼ò½é
SQLite
µÚÒ»¸öAlpha°æ±¾µ®ÉúÓÚ2000Äê5ÔÂ. ÖÁ½ñÒѾ­ÓÐ10¸öÄêÍ·ÁË. SQLiteÒ²Ó­À´ÁËÒ»¸ö°æ±¾ SQLite 3ÒѾ­·¢²¼.
¡¡¡¡SQLiteÊÇÒ»¿îÇáÐ͵ÄÊý¾Ý¿â£¬ÊÇ×ñÊØACIDµÄ¹ØÁªÊ½Êý¾Ý¿â¹ÜÀíϵͳ£¬ËüµÄÉè¼ÆÄ¿±êÊÇǶÈë
ʽµÄ£¬¶øÇÒĿǰÒѾ­ÔںܶàǶÈëʽ²úÆ·ÖÐʹÓÃÁËËü£¬ËüÕ¼ÓÃ×ÊÔ´·Ç³£µÄµÍ£¬ÔÚǶÈëʽÉ豸ÖУ¬¿ ......

SQLiteÃüÁîÐгÌÐò˵Ã÷

sqlite3: Ò»¸öSQLiteÊý¾Ý¿âµÄÃüÁîÐнӿÚ
ÒëÕß×¢
Ô­ÎĵØÖ·£ºhttp://www.sqlite.org/sqlite.html
    SQLite¿â°üº¬Ò»¸öÃû×Ö½Ð×ösqlite3 µÄÃüÁîÐÐ,Ëü¿ÉÒÔÈÃÓû§ÊÖ¹¤ÊäÈë²¢Ö´ÐÐÃæÏòSQLiteÊý¾Ý¿âµÄSQLÃüÁî¡£±¾ÎĵµÌṩһ¸öÑùʹÓÃsqlite3µÄ¼òҪ˵Ã÷¡£
¿ªÊ¼
    Æô¶¯sqlite3 ³ÌÐò£¬½ö½öÐèÒªÇÃÈ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ