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

accessÖÐreplaceÎÊÌâ

ÎÒÓÐÒ»¸öUnits±í,½á¹¹Îª:
  ID              UnistsName
  UN1            ºÚÁú½­¶«·½Ñ§Ôº
  UN2            ÖйúÒÆ¶¯Í¨Ðż¯ÍźÚÁú½­ÓÐÏÞ¹«Ë¾
  UN3            Áìµ¼¸É²¿ÃñÖ÷²âÆÀ(¼ò)
ÎÒдÁËÒ»¸ö²éѯÓï¾ä:select  ID,UnitsName  from Units  order by (replace(Ltrim(Rtrim(ID)),'UN','')+0)
Õâ¸öÓï¾äÊǰ´"UN"ºóÃæµÄÊý×Ö´óСÅÅÐò.
ÎÊÌâÊÇÕâ¸öÓï¾äÎÒÔÚaccessÖеIJéѯÖÐÔËÐÐûÓÐÎÊÌâ,µ«ÊÇÔÚ OleDbDataAdapter ÖÐÒ»Ö±ÐоÍ˵:
"±í´ïʽÖÐ 'replace' º¯Êý䶨Òå".ÕâÊÇΪʲô?

ÕâÊÇÖ´ÐÐÕâ¸ö²éѯÓï¾äµÄ·½·¨:
        public static DataSet Query(string SQLString)
        {
            using (OleDbConnection connection = new OleDbConnection(connectionString))
            {
                DataSet ds = new DataSet();
                try
                {
                    connection.Open();
                    OleDbDataAdapter command = new OleDbDataAdapter(SQLString, connecti


Ïà¹ØÎÊ´ð£º

access SQLд·¨

accessÊý¾Ý¿â¡£ÓÐÁ½¸ö±ía£¬b
a±í±£´æÁ˺ܶàѧУµÄÐÅÏ¢
b±í±£´æÁËѧУ±¨ÃûµÄÐÅÏ¢£¬Ò»¸öѧУ¿ÉÒÔ±¨nÌõ
ÒªÇóÊä³öËùÓÐѧУµÄ±¨Ãû¼Ç¼ÊýÁ¿È磺
¼×У 25
ÒÒУ 50
±ûУ 50
¶¡Ð£ 70
.
.
.
......

ÄÄÀïÓÐÃâ·ÑµÄÖ§³ÖACCESSµÄJSPÍøÕ¾¿Õ¼ä

    ´ó¶àÊýµÄÃâ·ÑJSPÍøÕ¾¿Õ¼ä¶¼Ö»Ö§³ÖMYSQL£¬Ô­ÏÈ×öºÃµÄÍøÕ¾ÊÇACCESS£¬Ö»ºÃ¿¼ÂÇ»»³ÉMYSQLÁË£¬µ«ÊÇÕûÕûŪÁËÒ»Ìì¶¼×°²»ÉÏMYSQL£¬Í·¶¼ÔÎÁË¡£
JSPÍøÕ¾¿Õ¼äÖ§³ÖACCESSºÃÏñÊÇûÓн¨¹ýµÄ£¬JspÒ»°ãÖ§³ÖMysql£¬Ora ......

accessÁбí¿òÊý¾Ý¶ªÊ§

¸÷λ´óÏÀ£º
            ÔÚ´°ÌåÀïÓÐÒ»Áбí¿ò£¬ÃûÔ»¡°ÉÌÆ·±àºÅ¡±£¬ÐÐÀ´Ô´ÀïµÄÄÚÈÝÓУºÉÌÆ·±àºÅºÍÉÌÆ·Ãû£¨À´×ÔÉÌÆ·±í£©¡£
  µ«ÊÇÎÊÌâ³öÏÖÁË£ºÔ­À´ÉÌÆ·±íÀïµÄÉÌÆ·±àºÅÊÇ4λ£ ......

µ¼Èëexcel±í¸ñµ½accessºó²úÉúµÄÎÊÌ⣿

ϵͳÿÌì²úÉúÒ»¸öexcelÎļþ£¬¸ñʽÏàͬ£¬ÄÚÈÝÓÃÎļþÃû£¨ÓòúÉúµÄʱ¼äÃüÃû£©Çø·Ö¡£ÎÒ×öÁËÒ»¸öaccessÊý¾Ý¿â£¬µ¼ÈëexcelµÄÊý¾Ý£¬ÎÒÏë¼ÓÒ»Ïî¼Í¼ÎļþÃûÀ´Çø·ÖÄÚÈÝ£¬¿ÉÊÇÔõô×öÄØ£¿ÓÖ»òÕßÓÃʲôÆäËû·½·¨¿ÉÒÔ°ìµ½£¿Ð»ÁË
Äã ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ