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

Ò»¸ö¹ØÓÚSQLiteС³ÌÐò £¬Çë´ó¼Ò¶à¶àÖ¸½Ì£¡

package com.jiao.sqlite;
import android.app.Activity;
import android.database.Cursor;
import android.os.Bundle;
import android.view.KeyEvent;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;
import android.widget.Toast;
public class DbDemo extends Activity {
 /**
  * SQLite Demo
  *
  * ¹©Activity˽ÓзÃÎʵÄÊý¾Ý¿â ûÓÐʹÓÃContentProvider ·½Ê½ Ôö¼Ó ²éѯÊý¾Ý
  *
  * @author daguangspecial@gmail.com
  *
  */
  EditText inputTxt;
  Button btnAdd;
  Button btnViewAll;
  TextView viewAll;
  DBHelper db;
  @Override
  protected void onCreate(Bundle savedInstanceState) {
   // TODO Auto-generated method stub
   super.onCreate(savedInstanceState);
   this.setContentView(R.layout.main);
   // ³õʼ»¯UI
   btnAdd = (Button) findViewById(R.id.btnAdd);
   btnViewAll = (Button) findViewById(R.id.btnViewAll);
   viewAll = (TextView) findViewById(R.id.viewAll);
   inputTxt = (EditText) findViewById(R.id.txtInput);
   // ³õʼ»¯DB
   db = new DBHelper(this);
   // ³õʼ»¯¼àÌý
   OnClickListener listener = new OnClickListener() {
    public void onClick(View v) {
     if (v.getId() == R.id.btnAdd) {
      // Ôö¼Ó
      boolean flat=db.save(inputTxt.getText().toString());
                                      
        


Ïà¹ØÎĵµ£º

SQLiteÆô¶¯ÊÂÎï

ÊÂÎñ£¨DbTransaction£©£º
SQLite ȱʡΪÿ¸ö²Ù×÷Æô¶¯Ò»¸öÊÂÎñ£¬ËùÒÔ³ÉÅú²åÈëµÄʱºò£¬Æô¶¯ÊÂÎñ£¬±È²»Æô¶¯ÊÂÎñ¿ìn±¶¡£
ÔÚûÆô¶¯ÊÂÎñ֮ǰÍùSqliteÊý¾Ý¿âÀï²åÈë1000¶àÌõÊý¾ÝµÄÇé¿ö,½á¹ûÿ´Î¶¼ÐèÒªÒ»Á½·ÖÖÓ²ÅÄÜÍê³É.
¶øÔÚÆô¶¯ÊÂÎïÒÔºóËùÐèÒªµÄʱ¼äÖ±½Ó±ä³É²»µ½2Ãë!Ô­À´sqlite»¨Á½·ÖÖÓÊÇÓÉÓÚExecuteNonQuery·½·¨Ö´ÐÐʱ×Ô¼ºÌá½» ......

SQLiteÊý¾Ý¿â

@ǶÈëʽ¹ØÏµÐÍÊý¾Ý¿âSQLite
    ÌØµã
        1.Ö§³ÖÎåÖÖÊý¾ÝÀàÐÍ null,INTEGER,REAL(¸¡µãÊý),TEXT(×Ö·û´®Îı¾)ºÍBLOB£¨¶þ½øÖÆÎı¾£©Êý¾ÝÀàÐÍ£¬ËäÈ»
        ËüÖ»ÓÐÎåÖÖ£¬µ«Êµ¼ÊÉÏsqlite3Ò²½ÓÊÖvarcher(n),char(n),decimal(p,s)µÈÊý¾ÝÀàÐÍ£ ......

SQLiteµÄ·â×°Àà

package
{
import flash.data.SQLConnection;
import flash.data.SQLResult;
import flash.data.SQLStatement;
import flash.errors.SQLError;
import flash.events.SQLErrorEvent;
import flash.events.SQLEvent;
import flash.filesystem.File;

import mx.collections.Ar ......

QT¶ÁдSqliteÊý¾Ý¿â FurtherChan

QT¶ÁдSqliteÊý¾Ý¿â
//.h
/****************************************************************************
**
** Date    : 2010-05-08
** Author  : furtherchan
** If you have any questions , please contact me
**
****************************************************************** ......

SQLiteÓï·¨ CREATE TRIGGER


ʱ¼ä:
2009-08-14 21:18:18À´Ô´:
ÍøÂç ×÷Õß:
δ
Öª µã»÷:
214
´Î
CREATE TRIGGER
    
        
            sql-statement ::=
       ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ