ASP.NETÓëMySqlµÄÁ¬½Ó——ÍøÕ¾µÄ²¿Êð
1. Êý¾Ý¿âµÄ²¿Êð
£¨1£©Èí¼þµÄ°²×°
A. MySql——±ØÐë°²×°ÔÚCÅÌÏ£¬·ñÔò°²×°mysql-connector-net-6.2.2ºóÎÞÕýÈ·ÅäÖÃ
B. mysql-connector-net-6.2.2——½«MySql.Data.dll·ÅÔÚBinÎļþ¼ÐÏÂ
£¨2£©Êý¾Ý¿âµÄµ¼³öµ¼Èë
MySQL-FrontµÄ"Áí´æΪ"¹¦ÄÜ¿ÉÒÔ½«Êý¾Ý¿âµ¼³öΪ.sqlÎļþ£¬È»ºóÔÙͨ¹ýËüÖ±½Óµ¼Èë.sqlÎļþ¿ÉÒÔÉú³ÉÊý¾Ý¿â
A. µ¼³öΪ.sqlÎļþʱ±ØÐëÑ¡ÔñÊý¾Ý¿â£¬·ñÔò.sqlÎļþÖв»°üº¬Êý¾Ý¿âµÄ´´½¨Óï¾ä£¬ÔÚµ¼Èëʱ»á±¨´í
B. Êý¾Ý¿âºÍ±í¸ñµÄ±àÂë±ØÐëΪutf-8¸ñʽ£¬·ñÔò½«Ôì³ÉÔÚµ¼Èë.sqlÎļþʱ£¬±íÖеÄÖÐÎÄÊý¾ÝÎÞ·¨µ¼Èë»ò³ÉΪÂÒÂë
C. MySql½«ÊÓͼViewµ±×ö±í¸ñTableÀ´´¦Àí£¬Òò´Ëµ¼³öµÄ.sqlÎļþÖлὫView´´½¨ºóÌí¼ÓInsertÓï¾äºÍEnable DataKey£»µ¼ÈëÇ°Ð轫InsertÓï¾äºÍÏÂÃæµÄÒ»¾äÈ«²¿É¾³ý£¬·ñÔò½«µ¼ÖÂÊÓͼµ¼Èëʧ°Ü¡£
2.ÍøÕ¾µÄ²¿Êð
£¨1£©IIS
A. ½«ÍøÕ¾µÄÖ÷Ŀ¼ÉèÖõ½ÍøÕ¾Îļþ¼ÐµÄĿ¼
B. Ð뽫Îļþ¼ÐµÄÊôÐÔÉèÖù²Ïí£¬·ñÔò½«Ôì³ÉÎÞ·¨·ÃÎÊ
£¨2£©ÍøÕ¾
A. ÓÐʱ»áÌáʾMySql.Data.dllÒýÓÃʧ°Ü£¬Ðè¼ì²éÊÇ·ñÒѾµ¼ÈëºÍÒýÓÃ
B. ÍøÕ¾µÄÑùʽ±íµÄ±àÂ뷽ʽӦÉèÖÃΪutf-8£¬·ñÔò²»Í¬µÄä¯ÀÀÆ÷£¨ÈçIE6£©´ò¿ªÍøÒ³µÄÑùʽ»á´íÂÒ
Ïà¹ØÎĵµ£º
1.½«flex±àÒëºóµÄ³ÌÐò²åÈëµ½asp.netÒ³Ãæ
flexµÄ×îÖÕÊä³ö¾ÍÊÇÒ»ÕÅÍøÒ³+Ò»¸öflash(.swfÎļþ)
Õâô˵ÄãÃ÷°×ÁË°É£¬Æäʵ¾ÍÊÇÓÃËûÉú³ÉµÄÍøÒ³µÄ·½Ê½°ÑÄǸö.swfÎļþ²åÈëµ½ÄãµÄasp.netÒ³Ãæ¾Í¿ÉÒÔÁË¡£
¼ÙÈçÄãµÄflex3ÏîÄ¿Ãû×Ö½ÐTestApp£¬×î¼òµ¥Ö±½ÓµÄ°ì·¨¾ÍÊÇ£¬
°Ñ"bin-debug"Ŀ¼Ïµģº
TestApp.html
TestApp.swf
AC_OETags.js ......
×î½üÓöµ½Ò»¸öÐèÇóÒªÔÚlinuxÏÂÓÃjava µ÷ÓÃmysql¿Í»§¶ËÔ¶³ÌµÇ½mysql·þÎñÆ÷£¬´Ó¿Í»§¶Ë»úÆ÷µ¼Èëmysql½Å±¾£¬´Ómysql·þÎñÆ÷¶Ëµ¼³ö±íÖеÄÊý¾Ý¡£ÒÔÏÂÊÇÓõ½µÄÖ÷Òª·½·¨£º
Java ´úÂë
/**
* µ¼ÈëÊý¾Ý
* @param ½Å±¾µÄµØÖ·ºÍÃû³Æ
* @return ÊÇ·ñ³É¹¦&nb ......
Êý¾Ý²Ö¿âÖ®¸¸Bill InmonÔÚ1991Äê³ö°æµÄ“Building the Data
Warehouse”Ò»ÊéÖÐËùÌá³öµÄ¶¨Òå±»¹ã·º½ÓÊÜ——Êý¾Ý²Ö¿â£¨Data Warehouse£©ÊÇÒ»¸öÃæÏòÖ÷ÌâµÄ£¨Subject
Oriented£©¡¢¼¯³ÉµÄ£¨Integrated£©¡¢Ïà¶ÔÎȶ¨µÄ£¨Non-Volatile£©¡¢·´Ó³ÀúÊ·±ä»¯£¨Time
Variant£©µÄÊý¾Ý¼¯ºÏ£¬ÓÃÓÚÖ§³Ö¹ÜÀí¾ö²ß(D ......
ÔÚÒìµØµÄ·þÎñÆ÷±¸·ÝMysqlʱ£¬ÒìµØµÄ·þÎñÆ÷ûÓа²×°MysqlÊý¾Ý¿â£¬±¸·ÝµÄmysqldumpÃüÁîÊDz»ÄÜÉúЧµÄ¡£ËùÒÔ¿ÉÒÔ°Ñ°²×°mysqlÊý¾Ý¿âËùÔÚ·þÎñÆ÷ÖеÄmysqldump.exe£¨È磺C:\Program Files\MySQL\MySQL Server 5.0\binĿ¼ÖеÄmysqldump.exe£©¿½±´µ½ÒìµØ·þÎñÆ÷ÖеÄÒ»¸öĿ¼ÖУ¨È磺F:\MySQLBackup£©¡£
±ÈÈçÎļþà ......
1¡¢ÓÃMySQLDriverCSÁ¬½ÓMySQLÊý¾Ý¿â
ÏÈÏÂÔغͰ²×°MySQLDriverCS£¬µØ
Ö·£º
http://sourceforge.net/projects/mysqldrivercs/
ÔÚ°²×°Îļþ¼ÐÏÂÃæÕÒµ½
MySQLDriver.dll
£¬È»ºó½«
MySQLDriver.dll
Ìí¼ÓÒýÓõ½ÏîÄ¿ÖÐ
×¢£ºÎÒÏÂÔصÄÊÇ°æ±¾ÊÇ
MySQLDriverCS-n-EasyQueryTools-4.0.1-DotNet2.0.exe
using
S ......