DelphiʹÓÃSQL ServerÈçºÎ¿ÉÒÔ²»°²×°SQLServer2000
ÈçÌâËùʾ
СµÜʹÓÃDelphi7»·¾³½øÐÐÊý¾Ý²É¼¯£¬²É¼¯µ½µÄÊý¾Ý·ÅÈëSQL Server2000Êý¾Ý¿âÖУ¬µ«ÊÇÏë²»°²×°SQLServer2000À´ÊµÏÖ´ÓÆäËü¼ÆËã»úÉÏÔËÐд˳ÌÐò£¬²»ÖªÈçºÎʵÏÖ£¿Íû¸÷λ´óϺ¸æÖªÒ»¶þ¡£
ÁíÍ⣬ÏÖÔÚСµÜÓöµ½ÁËÒ»¸öÎÊÌ⣬ʹÓÃADOÁ¬½ÓÊý¾Ý¿â£¬ÔÚÆäËü×°ÓÐSQLServer2000µÄ»úÆ÷ÉÏʹÓÃʱ£¬ÀÏÊǵ¯³öÊý¾Ý¿âÁ¬½Ó´íÎóµÄÌáʾ£¬²»ÖªÈçºÎ½â¾ö£¿Äܽâ¾ö´Ë¶þÕßÎÊÌâÖ®Ò»µÄ´óϺ¸øÈ«·Ö£¬Ð»Ð»À²£¡
°Ýл£¡£¡£¡
Çë¸÷λ´óϺ½«²»Óð²×°SQLserverµÄ·½·¨ÏêϸµÄ˵һÏ£¬Ð»Ð»À²£¡
midas£¬×öÒ»¸ö·þÎñÆ÷³ÌÐò
û¿´Ã÷°×ÄãÒª¸ÉÂÊǿͻ§¶Ë²»×°SqlServerÂð£¬ÕâÊ¿ÉÒÔʵÏֵģ¬Ö»Ð輸¸ödll´ò°ü½øÈ¥¾ÍÐÐÁË
win2000£¨»ò¸ü¸ß°æ±¾£©¼°°²×°ÁËoffice2000£¨»ò¸ü¸ß°æ±¾£©µÄϵͳ£¬¶¼²»Óð²×°sql2000¼´¿ÉÒÔ·ÃÎʱðµÄ»úÆ÷ÉϵÄsql2000Êý¾Ý¿â
ÎÒû˵Çå³þ£¬²»ºÃÒâ˼£¬ÊÇÕâÑùµÄ£¬ÎÒÓõÄDelphi±àдµÄ³ÌÐò²É¼¯Êý¾Ý£¬Êý¾Ý´æÈëSQLserver2000Êý¾Ý¿âÖУ¬È»ºóÎÒÏë°ÑÎÒ±àдµÄ³ÌÐòºÍÊý¾Ý¿âÎļþ¿½µ½±ðµÄ»ú×ÓÉÏÒ²ÄÜÕý³£Ê¹Óã¬Ä¿±ê»ú²»°²×°SQLserver2000£¬²»ÖªµÀÔõÑùʵÏÖ¡£
»»accessÖ®ÀàµÄÎļþÐ͵İÉ,Èç¹ûÄãÏë°ÑÊý¾Ý¶¼´ø×Å,ÄÇ»ù±¾ÉÏ×°¸ö·þÎñ³ÌÐòÊDZØÒªµÄ,´Ósqlserver2K,µ½MSDE
1¡¢Ê¹ÓÃACCESS»òÆäËü×ÀÃæÊý¾Ý¿â¿ÉÃâ°²×°Ö®ÈÅ£¬µ«Ç°ÌáÒª¿´ÄãµÄÊý¾ÝÁ¿µÈÐèÇóÇé¿ö
2¡¢Èç¹ûÈÔʹÓÃSQL Server£¬¿É¿¼ÂÇÆä×ÀÃæ°æ£¨MSDE£¬2005Ö®ºó³ÆÎªExpress Edition£©
²»´óÃ÷°×
»Ø¸´ÄÚÈÝÌ«¶ÌÁË£¡ »Ø¸´ÄÚÈÝÌ«¶ÌÁË£¡ »Ø¸´ÄÚÈÝÌ«¶ÌÁË£¡
XP²»ÓÃװʲô£¬WINDOWS2000¼°ÒÔÏ¿ÉÒÔ°²×°MSADO 2.7
Èç¹ûÖ»Êǿͻ§¶ËÓÃodbc»òADO¿ÉÒÔ²»°²×°SQL SERVER¿Í»§¶Ë
Èç¹ûÒªÊÇÓÃÊý¾Ý¿â·þÎñÆ÷,²»×°sqlserver ¿ÉÒÔ×°Ò»¸öMSDE(Microsoft SQL Server Desktop Engine)
Èç¹ûÒ»¶¨Ò
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......
protected void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡
Ëæ±ã¸ãÒ»D°æ°É£¬
ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù
http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP
²Î¿¼:http://hi.baidu.com/toiota ......