ʹÓÃDelphiÈçºÎÁ¬½ÓSQLÊý¾Ý¿â£¿
×îºÃÄÜ˵µÄÏêϸµã
¾ÍÒ»¸öÁ¬½Ó×Ö·û´®£¬×Ô¼º·Å¸öadoconnectionÔÚ½çÃæÉÏ£¬Ë«»÷£¬È»ºóÑ¡ÔñbuildÔÚÁбíÖÐÑ¡Ôñ...for sql servÏÆäËû×Ô¼º¶Ô׎çÃæÉϵÄÄÚÈÝÈ¥¿´
¶î »¹ÊDz»Ì«Ã÷°× ´ÓÀ´Ã»ÓùýÕⶫÎ÷
ÔÚÍøÉÏËÑÒ»ÏÂ
3Â¥µÄдµÃºÜϸÁË¡£
ÎÒÉÏ´«ÁËƪÎÄÕ£¬Í¼ÎIJ¢Ã¯£¬¿ÉÒԲο¼Ò»Ï£ºÊ¹ÓÃDecision Cube½øÐÐÊý¾ÝµÄ¾ö²ß·ÖÎö
http://download.csdn.net/source/2222831
Èý¥дµÄºÜ×ÐϸÁË£¬ÒªÊÇ»¹Óв»Ã÷°×µÄ½¨ÒéÂ¥Ö÷Âò±¾DELPHIµÄÊé¿´¡£
Delphi(Pascal) code:
var
conn: Variant;//Connection
begin
//½¨Á¢Êý¾Ý¿âÁ¬½Ó
conn := CreateOleObject('ADODB.Connection');
try
conn.Open('Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=;Data Source='+ ASSECCÊý¾Ý¿â¾ø¶Ô·¾¶);
except //Á¬½Ó³ö´í
result := '';
exit;
end;
end;
ÔÙ¸øµã½¨Òé
Á¬½ÓSQLÊý¾Ý¿â£¬Òª·ÖÇåsqlµÄµÇ¼·½Ê½
SQL ServerÉí·ÝÑéÖ¤»¹ÊÇWindowsÉí·ÝÑéÖ¤
²»Í¬µÄµÇ¼·½Ê½Á¬½Ó×Ö·û´®Ò²²»Ò»Ñù
WindowsÉí·ÝÑéÖ¤
Delphi(Pascal) code:
Self.ADOConnection1.Connected:=False;
Self.ADOConnection1.ConnectionString:='Provider=SQLOLEDB.1;Integrated Security=SSPI;'
+'Persist Security Info=False;Initial Catalog=master';
try
Self.ADOConnection1.Connecte
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì »·¾³ÊÇSQL2000Êý¾Ý¿â
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
Ñ»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)
......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP
²Î¿¼:http://hi.baidu.com/toiota ......