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

c# sqlite Êý¾Ý¿â¼ÓÃÜ


ÓÃÁËADO.NET 2.0 SQLite Data Provider ÕâÑù¿ÉÒÔÖ±½ÓÀûÓÃËüÀ´´´½¨Ò»¸ö¼ÓÃܵÄsqliteÊý¾Ý¿â¡£
ÓйØc#´úÂëÈçÏ£º
1¡¢´´½¨¿ÕµÄsqliteÊý¾Ý¿â¡£
//Êý¾Ý¿âÃûµÄºó׺Äã¿ÉÒÔÖ±½ÓÖ¸¶¨£¬ÉõÖÁûÓкó׺¶¼¿ÉÒÔ
//·½·¨Ò»£º´´½¨Ò»¸ö¿ÕsqliteÊý¾Ý¿â£¬ÓÃIOµÄ·½Ê½
FileStream fs = File.Create(“c:\\test.db“);
//·½·¨¶þ£ºÓÃSQLiteConnection
SQLiteConnection.CreateFile(“c:\\test.db“);
´´½¨µÄÊý¾Ý¿âÊǸö0×Ö½ÚµÄÎļþ¡£
2¡¢´´½¨¼ÓÃܵĿÕsqliteÊý¾Ý¿â
//´´½¨Ò»¸öÃÜÂëΪpasswordµÄ¿ÕµÄsqliteÊý¾Ý¿â
SQLiteConnection.CreateFile£¨“c:\\test2.db“);                
SQLiteConnection cnn = new SQLiteConnection(“Data Source=c:\\test2.db“);
SQLiteConnection cnn = new SQLiteConnection(“Data Source=D:\\test2.db“);
cnn.Open();
cnn.ChangePassword(“password“);
3¡¢¸øδ¼ÓÃܵÄÊý¾Ý¿â¼ÓÃÜ
SQLiteConnection cnn = new SQLiteConnection(“Data Source=c:\\test.db“);
cnn.Open();
cnn.ChangePassword(“password“);
4¡¢´ò¿ª¼ÓÃÜsqliteÊý¾Ý¿â
//·½·¨Ò»
SQLiteConnection cnn = new SQLiteConnection(“Data Source=c:\\test2.db“);
cnn.SetPassword(“password“);
cnn.Open();
//·½·¨¶þ
SQLiteConnectionStringBuilder builder = new SQLiteConnectionStringBuilder();
builder.DataSource = @”c:\test.db“;
builder.Password = @”password“;
SQLiteConnection cnn = new SQLiteConnection(builder.ConnectionString);
cnn .Open();
×¢£º
A¡¢ÒòΪ¼ÓÃܵĺ¯ÊýÊÇÀûÓÃwindows api£¬¹Ê¼ÓÃܺóµÄÊý¾Ý¿âÖ»ÄÜÊÊÓÃÔÚwindowsƽ̨£¬¼ÓÃܵķ½Ê½ÊÇÕûÌåÎļþ¼ÓÃÜ¡£
B¡¢¼ÓÃܵÄËã·¨ÊÇRC4£¬Èç¹ûÄãÏë²ÉÓñðµÄ¼ÓÃÜËã·¨À´¼ÓÃÜ£¬Çë²Î¿¼ADO.NET 2.0 SQLite Data Provider µÄÔ´ÂëÀ´Ð޸ġ£
c¡¢Ïà¹ØsqliteÊý¾Ý¿â²Ù×÷ÀàËÆADO.NET 2.0¡£Ïê¼ûADO.NET 2.0 SQLite Data ProviderµÄ°ïÖúÎĵµ¡£
c¡¢ADO.NET 2.0 SQLite Data Provider °æ±¾Îª£º1.0.53.0 £¬SQLite°æ±¾ : 3.6.0¡£
d¡¢¿ª·¢»·¾³Îªvs2008¡£


Ïà¹ØÎĵµ£º

ASP.NET C# ÑéÖ¤Âë Ö§³ÖÖÐÎÄ Ôëµã ÍäÇú

/// <summary>
        /// ¸ù¾ÝÖ¸¶¨²ÎÊý·µ»ØBitMap¶ÔÏó
        /// ÒýÓÃÈçÏ£º
        /// using System.Drawing;
        /// µ÷ÓÃÀý×ÓÈçÏ£º
   ......

xml post(C#)

xmlpost by HttpWebRequest:
protected string PostXmlToURL(string url,string data)
{
    HttpWebRequest hwr = (HttpWebRequest)HttpWebRequest.Create(url);
    hwr.Method = "POST";
    Stream stream = hwr.GetRequestStream();
    StreamWri ......

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

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

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 fi ......

sqlite¼ÓÃÜÉè¼ÆµÄȱÏÝÓë¸Ä½ø


sqliteÊÇ
Ò»¸ö·Ç³£Ð¡ÇɵĿçƽ̨ǶÈëʽÊý¾Ý¿â£¬Ëü±¾Éí²»Ìṩ¼ÓÃܹ¦ÄÜ£¬²»¹ýÉè¼ÆÕßÃ÷ÏÔÒ²¿¼ÂÇÁ˼ÓÃܵķ½°¸£¬ÎÒÃÇÔÚÔ´ÂëÖпÉÒÔÕÒµ½Á½¸öÔ¤ÁôµÄ¼ÓÃܽÓ
¿Ú£ºsqlite3_keyºÍsqlite3_rekey£¬¿ÉÒÔͨ¹ýʵÏÖÕâÁ½¸ö½Ó¿ÚÀ´´ïµ½¼ÓÃܵÄÄ¿µÄ¡£
        ÈçºÎ¼ÓÃÜ£¬ÒѾ­ÓкܶàÎÄÕÂÃèÊö£¬¿ÉÒԲο¼:¡¶
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ