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

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

//ËѼ¯ÕûÀíÁËÒ»ÏÂÍøÉϵĴúÂë.ÕÒÁ˰ëÌì¾ÓÈ»ÕÒ²»µ½Ò»Ìõ²åÈëÓï¾ä.ºÃÓôÃÆµÄ
//¸Ð¾õËÙ¶È»¹¿ÉÒÔ.СÎļþ.ºÜ¶àСӦÓóÌÐòÔÚÓÃÕâ¸öÊý¾Ý¿â
//SQLiteʹÓð취.Ö±½ÓCOPYDLLÎļþSystem.Data.SQLite.DLLµ½Ó¦ÓóÌÐòDEBUGĿ¼Ï¡£ È»ºóÔÚÏîÄ¿ÖÐÌí¼ÓÒýÓÃ,ÕÒµ½Õâ¸öÎļþ¼´¿É
//Ìí¼ÓÒýÓÃ
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.IO;
using System.Net;
using System.Data.SQLite;
private static string FavoriteDbPath = System.Environment.CurrentDirectory + "\\Favorite.db";
private bool CreateSQLiteDb()
        {
            try
            {
                System.Data.SQLite.SQLiteConnection.CreateFile(FavoriteDbPath);
                System.Data.SQLite.SQLiteConnection Conn = new System.Data.SQLite.SQLiteConnection();
                System.Data.SQLite.SQLiteConnectionStringBuilder ConnStr = new System.Data.SQLite.SQLiteConnectionStringBuilder();
                ConnStr.DataSource = FavoriteDbPath;
                ConnStr.Password = "Admin";//ÉèÖÃÃÜÂ룬SQLite ADO.NETʵÏÖÁËÊý¾Ý¿âÃÜÂë±£»¤
                Conn.ConnectionString = ConnStr.ToString();
                Conn.Open();
                System.Data.SQLite.SQLiteComman


Ïà¹ØÎĵµ£º

Sqlite Êý¾Ý¿â

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

SQLiteѧϰ±Ê¼Ç£¨2£©

ÔÙ˵ÔÚlinuxϽ¨Á¢.a ºÍµãso
     µ½ÍøÕ¾ÏÂÔØ sqlite-amalgamation-3.6.22.tar.gz Õâ¸ö°ü£¬·´ÕýÎÒÏÂÁËsqlite3-3.6.22.bin.gz½âѹºó±àÒë²»ÁË¡£
     ½âѹ£¬ÔËÐÐ
    #  ./configure --host=armv5l-linux --prefix=/opt/sqlite3/arm --enable-threadsafe. ......

SQLiteµÄ²éѯÓÅ»¯

±¾ÆªÎÄÕÂÀ´Ô´ÓÚ£º¿ª·¢Ñ§Ôº http://edu.codepub.com   Ô­ÎÄÁ´½Ó£ºhttp://edu.codepub.com/2009/0825/14358.php
SQLiteÊǸöµäÐ͵ÄǶÈëʽDBMS£¬ËüÓкܶàÓŵ㣬ËüÊÇÇáÁ¿¼¶µÄ£¬ÔÚ±àÒëÖ®ºóºÜС£¬ÆäÖÐÒ»¸öÔ­Òò¾ÍÊÇÔÚ²éѯÓÅ»¯·½Ãæ±È½Ï¼òµ¥£¬ËüÖ»ÊÇÔËÓÃË÷Òý»úÖÆÀ´½øÐÐÓÅ»¯µÄ£¬¾­¹ý¶ÔSQLiteµÄ²éѯÓÅ»¯µÄ·ÖÎöÒÔ¼°¶ÔÔ´´úÂëµÄ ......

sqlite ʹÓÃ

ÎÒÀÏÆÅ¹¤×÷Òª¹ÜÀíºÃ¶àµÄexcel±í¸ñ±È½ÏµÄÂé·³£¬ÓÚÊÇÏë×Űïæд¸öÈí¼þÈÃËý·½±ãµã
ÆäʵÎÒwinformÈí¼þ»¹Ã»ÓÐд¹ýÄØ£¬ÒÔǰдµÄ¶¼ÊÇwebµÄ
ÒòΪдµÄÈí¼þ¾ÍÊÇËý×Ô¼ºÓÃÓÃÎÒÏëÓ¦¸Ã²»ÐèÒªÓÃʲô´óµÄÊý¾Ý¿âµÄ£¬ËùÒÔÎÒ×îÏÈÏëµ½ÓÃaccessÊý¾Ý¿âͦ·½±ãµÄÎļþ¸´ÖƾͿÉÒÔÁË
¿ÉÊÇÎÒûÓÐoffice access°¡£¬²»¹ýÎҼǵõçÄÔÉϺÃÏñÓÐaccessÊý¾Ý¿â ......

ǶÈëʽÊý¾Ý¿âµäÐͼ¼Êõ¨DSQLiteºÍBerkeley DBµÄÑо¿

Õª Òª: Óë³£¼ûµÄÊý¾Ý¿âÏà±È£¬Ç¶Èëʽ
Êý
¾Ý¿â¾ßÓÐÌå»ýС¡¢¹¦ÄÜÆë±¸¡¢¿ÉÒÆÖ²ÐÔ¡¢½¡×³ÐÔµÈÌØµã£¬±¾ÎÄ·ÖÎöºÍ±È½ÏÁ˵äÐ͵ÄǶÈëʽÊý¾Ý¿âSQLiteºÍBerkeley DB¡£Ê×ÏÈ´ÓÌåϵ½á¹¹¡¢×Óϵͳ
¼äµ÷ÓùØÏµ¡¢ÈÎÎñÖ´Ðйý³ÌµÈ½Ç¶È¶ÔSQLiteºÍBerkeley DB½øÐÐÁËÏêϸ·ÖÎö£¬È»ºóÖØµã´ÓÊý¾ÝÀàÐÍ¡¢´æ´¢·½Ê½¡¢Ä£Ê½¡¢Êý¾Ý¿âÒýÇ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ