c# web service ʵÀý
΢ÈíÔÚÆä.netÕ½ÂÔÖУ¬¶ÔÆäÖ÷ÍÆµÄWeb Service×öÁË´óËÁµÄÐûÑï¡£ÏÖÔÚ£¬Web
ServiceÕýÈç»ðÈçݱµØ·¢Õ¹×Å£¬Ïà¹ØµÄ¸÷Ïîм¼Êõ²ã³ö²»Çî¡£Web
ServiceµÄ·¢Õ¹Õý¹¹Öþ×Å»¥ÁªÍøÊ±´úÃÀºÃµÄÃ÷Ìì¡£ÔÚ±¾ÎÄÖУ¬ÎÒ½«Ïò´ó¼Ò½éÉÜWeb ServiceµÄһЩ»ù±¾ÖªÊ¶¡¢ÈçºÎÓÃC££½¨Á¢Ò»¸öWeb
Service¡£Í¨¹ýÎÄÕ£¬ÎÒÃÇ»¹½«¶ÔWSDL¡¢UDDIÒÔ¼°Î´À´µÄWeb ServiceÓÐÒ»¸ö´óÖµÄÁ˽⡣
ΪʲôÐèÒªWeb Service£¿
ÒÔǰ£¬·Ö²¼Ê½µÄÓ¦ÓóÌÐòÂß¼ÐèҪʹÓ÷ֲ¼Ê½µÄ¶ÔÏóÄ£ÐÍ£¬Í¨¹ýʹÓÃDCOM¡¢CORBA¡¢RMIÖ®ÀàµÄ»ù±¾½á¹¹£¬¿ª·¢ÈËÔ±ÈÔ¿ÉÓµÓÐʹÓñ¾µØÄ£ÐÍËùÌṩµÄ·á¸»×ÊÔ´ºÍ¾«È·ÐÔ£¬²¢¿É½«·þÎñÖÃÓÚÔ¶³ÌϵͳÖС£
µ±ÒѾÓÐÖÐÒâµÄÖмä¼þƽ̨£¨RMI¡¢Jini¡¢CORBA¡¢DCOM
µÈµÈ£©Ê±£¬ÎÒÃÇΪʲô»¹ÒªÎªWeb¶ø·³ÄÕÄØ£¿Öмä¼þȷʵÌṩÁËÇ¿´óµÄ·þÎñʵÏÖÊֶΣ¬µ«ÊÇ£¬ÕâЩϵͳÓÐÒ»¸ö¹²Í¬µÄȱÏÝ£¬ÄǾÍÊÇËüÃÇÎÞ·¨À©Õ¹µ½»¥ÁªÍøÉÏ£ºËüÃÇ
ÒªÇó·þÎñ¿Í»§¶ËÓëϵͳÌṩµÄ·þÎñ±¾ÉíÖ®¼ä±ØÐë½øÐнôÃÜñîºÏ£¬¼´ÒªÇóÒ»¸öͬÀà»ù±¾½á¹¹¡£È»¶øÕâÑùµÄϵͳÍùÍùÊ®·Ö´àÈõ£ºÈç¹ûÒ»¶ËµÄÖ´ÐлúÖÆ·¢Éú±ä»¯£¬ÄÇôÁíÒ»
¶Ë±ã»á±ÀÀ£¡£ÀýÈ磬Èç¹û·þÎñÆ÷Ó¦ÓóÌÐòµÄ½Ó¿Ú·¢Éú¸ü¸Ä£¬ÄÇô¿Í»§¶Ë±ã»á±ÀÀ£¡£ÎªÁËÄÜÀ©Õ¹µ½»¥ÁªÍøÔËÓã¬ÎÒÃÇÐèÒªÒ»ÖÖËÉɢżºÏµÄ»ù±¾½á¹¹À´½â¾öÕâ¸öÎÊÌâ¡£Èç
´ËµÄÇé¿öϾÍÓÀ´ÁËWeb ServiceµÄµ®Éú¡£
ʲôÊÇWeb Service?
Web Service ÊÇÒ»ÖÖеÄWebÓ¦ÓóÌÐò·ÖÖ§£¬ËûÃÇÊÇ×Ô°üº¬¡¢×ÔÃèÊö¡¢Ä£¿é»¯µÄÓ¦Ó㬿ÉÒÔ·¢²¼¡¢¶¨Î»¡¢Í¨¹ýWebµ÷Óá£Web
Service¿ÉÒÔÖ´ÐдӼòµ¥µÄÇëÇ󵽸´ÔÓÉÌÎñ´¦ÀíµÄÈκι¦ÄÜ¡£Ò»µ©²¿ÊðÒÔºó£¬ÆäËûWeb ServiceÓ¦ÓóÌÐò¿ÉÒÔ·¢ÏÖ²¢µ÷ÓÃËü²¿ÊðµÄ·þÎñ¡£
Web
ServiceÊÇÒ»ÖÖÓ¦ÓóÌÐò£¬ËüÔËÓÃÁËWebÍøÂç¼¼ÊõºÍ»ùÓÚ×é¼þ¿ª·¢µÄ¾«»ª³É·Ö¡£¿ÉÒÔʹÓñê×¼µÄ»¥ÁªÍøÐÒ飬Ïñ³¬Îı¾´«ÊäÐÒé(HTTP)ºÍXML£¬½«
¹¦ÄܸÙÁìÐÔµØÌåÏÖÔÚ»¥ÁªÍøºÍÆóÒµÄÚ²¿ÍøÉÏ¡£ÏñDCOM¡¢RMI¡¢IIOPµÈ»ùÓÚ×é¼þµÄ¶ÔÏóÄ£ÐÍÒѾÁ÷ÐÐÁ˽ϳ¤Ò»¶Îʱ¼äÁË¡£È»¶øÕâЩģÐͶ¼ÊÇÒÀÀµÓÚÒ»¸öÌØ¶¨
µÄ¶ÔÏóÄ£ÐÍÐÒé¡£Web ServiceÀ©Õ¹ÁËÕâЩģÐÍ£¬Ê¹Ö®¿ÉÒԺͼòµ¥¶ÔÏó·ÃÎÊÐÒ飨Simple Object Access
Protocol£¬SOAP£©ÒÔ¼°XMLͨÐÅÒÔ¸ù³ýÌØ¶¨¶ÔÏóÄ£ÐÍÐÒé´øÀ´µÄÕϰ¡£¿É½«WebServiceÊÓ×÷WebÉϵÄ×é¼þ±à³Ì¡££¨²Î¼ûÈçͼ1£©
Web Service»ù±¾ÉÏÊÇÀûÓó¬Îı¾´«ËÍÐÒ飨HTTP£©ºÍSOAPÀ´Ê¹ÉÌÒµÊý¾Ý¿ÉÒÔÔÚÍøÉÏ»ñµÃ¡£Ëü½«ÉÌÒµ¶ÔÏó£¨COM¶ÔÏó¡¢Java
BeansµÈ£©ÏÔ¶¸øÔÚHTTPÉϵÄSOAPµ÷Óò¢Ö´ÐÐÔ¶³Ì¹¦Äܵ÷Óá£Òò´Ë£¬Web
ServiceµÄʹÓÃÕß¿ÉÒÔÔÚÔ¶³Ì¶ÔÏóÉÏͨ¹ýSOAPºÍHTTPÔÚWeb
Ïà¹ØÎĵµ£º
ÏÂÃæÕâ¶ÎC# ´úÂë¿ÉÒÔÓÃÀ´Ñ¹ËõºÍÐÞ¸´AccessÊý¾Ý¿â,²»¹ÜËüÊÇÒ»¸ö¼òµ¥µÄ".mdb"ACCESSÊý¾Ý¿â»¹ÊÇÒ»¸ö".mdw"ÍøÂç¹²ÏíÊý¾Ý¿â,Õâ¸ö¹ý³ÌºÍÄãÔÚÓÃMS AccessÓ¦ÓóÌÐòÖÐʹÓõÄ"¹¤¾ß-Êý¾Ý¿âʵÓù¤¾ß-ѹËõºÍÐÞ¸´"ʱִÐеIJÙ×÷ÍêȫһÑù.ʵÀý´úÂëʹÓÃÁË"³Ù°ó¶¨"(ÔËÐÐÖÐÔÚÄÚ´æÖн¨Á¢COM¶ÔÏó),ÕâÑù¾Í²»ÐèÒªÔÚ¹¤³ÌÖмÓÈëCOMÒýÓÃÁË,Ò²²»ÐèÒªÔÚP ......
bigint ´Ó -2^63 (-9223372036854775808) µ½ 2^63-1 (9223372036854775807) µÄÕûÐÍÊý¾Ý£¨ËùÓÐÊý×Ö£©¡£´æ´¢´óСΪ 8 ¸ö×Ö½Ú¡£ Int64
int ´Ó -2^31 (-2,147,483,648) µ½ 2^31 - 1 (2,147,483,647) µÄÕûÐÍÊý¾Ý£¨ËùÓÐÊý×Ö£©¡£´æ´¢´óСΪ 4 ¸ö×Ö½Ú¡£int µÄ SQL-92 ͬÒå×ÖΪ integer¡£ Int32
smallint ´Ó -2^15 (-32,768) µ½ ......
C#Á¬½ÓMySQLÊý¾Ý¿â·½·¨
1¡¢ÓÃMySQLDriverCSÁ¬½ÓMySQLÊý¾Ý¿âÏÈÏÂÔØºÍ°²×°MySQLDriverCS£¬µØÖ·£º
http://sourceforge.net/projects/mysqldrivercs
ÔÚ°²×°Îļþ¼ÐÏÂÃæÕÒµ½MySQLDriver.dll£¬È»ºó½«MySQLDriver.dllÌí¼ÓÒýÓõ½ÏîÄ¿ÖÐ
×¢£ºÎÒÏÂÔØµÄÊǰ汾ÊÇ MySQLDriverCS-n-EasyQueryTools-4.0.1-DotNet2.0.exe
using System; ......
xmlpost by HttpWebRequest:
protected string PostXmlToURL(string url,string data)
{
HttpWebRequest hwr = (HttpWebRequest)HttpWebRequest.Create(url);
hwr.Method = "POST";
Stream stream = hwr.GetRequestStream();
StreamWri ......
µ±ÔÚC#ÓïÑÔÖУ¬Á¬½ÓsqlÊý¾Ý¿âµÄʱºò£¬³£Óõ½sqlconnection½¨Á¢ÓëÊý¾Ý¿âµÄÁ¬½Ó¡£ Óï·¨ÈçÏ£º
String sqlcon = "***";//ÕâÀïÊÇÒ»¸ö×Ö·û´®£¬¾ßÌå¸úÊý¾Ý¿âµÄÑéÖ¤·½Ê½Óйء£
//sql server Éí·ÝÑéÖ¤ Á¬½Ó×Ö·û´®
private string ConnstrSqlServer = "server=·þÎñÆ÷Ãû³ ......