Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Êý¾Ý¿â

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

[×ªÔØ]ÄÚ´æÊý¾Ý¿âFastDBºÍSQLiteÐÔÄܲâÆÀ


ÄÚ´æÊý¾Ý¿âFastDBºÍSQLiteÐÔÄܲâÆÀ
×÷Õߣºtamsyn 
À´Ô´£ºwww.sqlite.com.cn 
ʱ¼ä£º2009-10-21  



Ò»¡¢ÒýÑÔ
ÔںܶàÏîÄ¿ÖУ¬¾­³£»áÅöµ½ÕâÑùµÄÐèÇó£¬ÐèÒª¶Ô´óÁ¿Êý¾Ý½øÐпìËÙ´æ´¢¡¢²éѯ¡¢É¾³ýµÈ²Ù×÷£¬ÌرðÊÇÔÚһЩÕë¶ÔÖîÈçÔËÓªÉÌ¡¢ÒøÐеȴóÐÍÆóÒµµÄÓ¦ÓÃÖУ¬ÕâЩ ......

ÓÃEclipse±àÒëÏòsqliteÊý¾Ý¿â²åÈëÊý¾ÝµÄpython³ÌÐò

½ñÌìÓöµ½ÁËÂé·³£º
      ÓÃEclipse±àÒëpythonÏòsqliteÊý¾Ý¿â²åÈëÊý¾Ý×ÜÊÇÌáʾ±àÂëµÄÎÊÌ⣬ÎÒÉèÖÃÁËEclipseµÄworkspaceÓÃutf-8±àÂ뻹ÊDz»ÐÐ
µ«ÊÇÓÃEclipseдµÄ³ÌÐò±£´æÔÙÓÃIDLE´ò¿ªÈ´ÄܱàÒë£¬Ææ¹ÖÁË
ÎÒ¿¼Âǵ½¿ÉÄÜÊÇÅäÖõÄÔ­Òò£¬ÕÒÕÒ±éÁËËùÓеÄÅäÖ㬶¼Ã»ÓÐÎÊÌ⣬°üÀ¨¹¤³ÌÎļþ
×îºóÎÒÓÃxvi32´ò¿ ......

SQLiteÓï·¨ CREATE TRIGGER


ʱ¼ä:
2009-08-14 21:18:18À´Ô´:
ÍøÂç ×÷Õß:
δ
Öª µã»÷:
214
´Î
CREATE TRIGGER
    
        
            sql-statement ::=
       ......

sqlite´¥·¢Æ÷Ò»Àý

int column_names_printed = 0;
void print_row(int n_values, char** values)
{
    int i;
    for (i = 0; i < n_values; ++i) {
        printf("%10s", values[i]);
    }
    printf("\n& ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ