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

sqlite ʹÓÃ

ÎÒÀÏÆÅ¹¤×÷Òª¹ÜÀíºÃ¶àµÄexcel±í¸ñ±È½ÏµÄÂé·³£¬ÓÚÊÇÏë×Űïæд¸öÈí¼þÈÃËý·½±ãµã
ÆäʵÎÒwinformÈí¼þ»¹Ã»ÓÐд¹ýÄØ£¬ÒÔǰдµÄ¶¼ÊÇwebµÄ
ÒòΪдµÄÈí¼þ¾ÍÊÇËý×Ô¼ºÓÃÓÃÎÒÏëÓ¦¸Ã²»ÐèÒªÓÃʲô´óµÄÊý¾Ý¿âµÄ£¬ËùÒÔÎÒ×îÏÈÏëµ½ÓÃaccessÊý¾Ý¿âͦ·½±ãµÄÎļþ¸´ÖƾͿÉÒÔÁË
¿ÉÊÇÎÒûÓÐoffice access°¡£¬²»¹ýÎҼǵõçÄÔÉϺÃÏñÓÐaccessÊý¾Ý¿âÎļþµÄ£¬ËùÓÐÕÒµ½Õâ¸öÎļþ¿ªÊ¼É¾³ý±í¸ñ£¬½¨ÐèÒªµÄ±í¸ñ
Ïë×Å·½±ãµã¾Íд¹ý¿ÉÒÔÖ´ÐÐsqlµÄ´°¿Ú£¬ÖØÀ´Ã»ÓÐд¹ý»¹ÊÇÓеãÂé·³µÄ£¬Ð´Á˸ö²Ù×÷Êý¾Ý¿âµÄÀ࣬дÍêÕâЩÎÒÒѾ­»¨ÁËÎÒÁ½¸öСʱʱ£¬ÎÒ»¹ÏëÏëÐèÒª½¨Á¢µÄ±í¸ñʲôµÄ¡£¾ÍÐÝÏ¢ÁË
ÐÝϢʱÎÒͻȻÏëµ½Óиö¿ªÔ´µÄsqliteÊý¾Ý¿â£¬ÎªÊ²Ã´²»ÓÃÕâ¸öÊý¾Ý¿âÄØ£¬ÓÃÄÇaccess¸ÉÂï°¡£¬»¹Â鷳Ĩ
µÚ¶þÌìÎÒÏÂÔØÁËÒ»¸ösqliteµÄ£¬¸ÕÏÂÔØÁËÔÚ¡£netϲ»ÄÜÓ㬺óÀ´·¢ÏÖ»¹Óиö¡£net°æµÄ
ÏÂÔØµØÖ·ÈçÏ  http://sqlite.phxsoftware.com/
ÏÂÔØµ½Õâ¸ö¾Í¿ÉÒÔÖ±½ÓʹÓÃÁ˲Ù×÷Êý¾Ý¿â¸úÆäËüÊý¾Ý¿âÊÇÒ»ÑùµÄºÜ·½±ã°¡
½ñÌìÎÒ²Ù×÷Êý¾Ý¿âÊÇÓöµ½Á˵ÚÒ»¸öÎÊÌâÊÇ£¬²éѯÏÔʾÊÇÁ¬½Ó ×Ö¶ÎÖµµÄ
ÎÒµÚÒ»Ïëµ½µÄÊÇÓüӺţ¬ÒòΪÓùáÁËsql server¡£ºóÀ´ÍøÉϲéѯÁËһϾ¹È»ÊÇÓÃÁË||Õâ¸öµÄ£¬ºÜÆæ¹Ö°¡
»¹¾ÍÊÇʱ¼äÈÕÆÚÊÇÓöµ½ÎÊÌâÁË£¬²éѯÎĵµµÃµ½Ê¹Óà datetime() ±£´æµ½Êý¾Ý¿âÒ»²éѯ¾¹È»ÊǸúÎÒµÄʱ¼ä²î¸ö°ËСʱµÄ£¬ÓôÃÆ¡£ÒÔǰÎÒдphpµÄʱºòÒ²Óöµ½¹ýÕâÑùµÄÎÊÌ⣬Ӧ¸ÃÊÇÉèÖÃÊ±ÇøµÄÎÊÌ⣬²éѯһÏÂsqliteÊý¾Ý¿âÊÇ·ñÓÐÉèÖÃÊ±ÇøµÄºÃÏñûµÄ£¬±£´æÊý¾Ý¿âʱÓà datetime('now','localtime') ÕâÑù¾ÍÕý³£ÁË
±£´æÈÕÆÚʱºóÀ´ÓÖÓöµ½ÎÊÌâÁË£¬ÒÔΪÎÒÖ±½Ó´Ó¡£netµÄÈÕÆÚת»¯Îª×Ö·û´®±£´æÊÇûÓÐÎÊÌâͦºÃµÄ¿ÉÊÇÎÒÒ»²éѯ¾Í³öÎÊÌâÁË
ºóÀ´ÔÚ http://www.xueit.com/html/2009-02/21_644_00.html ÕÒµ½ÎÊÌâÁË
¿´À´»¹ÓкöàҪѧϰ°¡


Ïà¹ØÎĵµ£º

sqlite Êý¾Ý¿â¿ÉÊÓ»¯²é¿´Ð޸ķÖÎö¹¤¾ßsqlitebrowser


SQLite Database Browser
 
 
SQLite Database browser is a light GUI editor for SQLite databases, built on top of Qt. The main goal of the project is to allow non-technical users to create, modify and edit SQLite databases using a set of wizards and a spreadsheet-like interface.
Downlo ......

2010ÄêSQLiteѧϰ±Ê¼ÇÖ®Ò»


2010ÄêSQLiteѧϰ±Ê¼ÇÖ®Ò»
Ò»£®            ÈçºÎ»ñÈ¡SQLite×îа汾
¹Ù·½Õ¾µã£ºhttp://www.sqlite.org/
´Óhttp://www.sqlite.org/ÍøÕ¾µÄDownloadÒ³Ãæ»ñÈ¡
¼´ÈçÏÂÒ³ÃæÏÂÔØ
http://www.sqlite.org/download.html
¶þ£®WindowsϵÄSQLiteµÄÔ´´úÂëÊÇÄĸöÈí¼þÑ¹Ë ......

sqliteÊý¾Ý¿â»ù±¾²Ù×÷

//²åÈë¼°¸üвÙ×÷
 int nRet = 0;
 sqlite3 * db = NULL;
 CString strFilePath;  //Êý¾Ý¿â´æ´¢Â·¾¶
//·¾¶¸³Öµ£¨Ê¡ÂÔ£©
 //Á¬½ÓÊý¾Ý¿â
 nRet = sqlite3_open16(strFilePath, &db);    //Óм¸¸ö´ò¿ªº¯Êý¿É¹©µ÷Óã¬Ê¹ÓÃWCHARÀàÐÍ·¾¶ÓÃÕâ¸ö
 if(nRet != SQLIT ......

Sqlite Êý¾Ý¿â

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