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

ACCESSÆæ¹ÖµÄ'±ê×¼±í´ïʽÖÐÊý¾ÝÀàÐͲ»Æ¥Åä'?

СµÜ³åACCESSÊý¾Ý¿âÏòoracleÊý¾Ý¿âµ¼ÈëÊý¾Ý,ÓõÄÊÇinsert into selectÓï¾ä.sqlÈçÏÂ:

INSERT INTO [ODBC;DSN=pjgsDNS;UID=pjuser;PWD=bssoft001;].[T001_PX_BM_XM] SELECT t2.*,45 as FDW_ID from T001_PX_BM_XM t2

T001_PX_BM_XM ±í½á¹¹ÔÚÁ½¸öÊý¾Ý¿âÖÐÊÇÒ»ÑùµÄ.

ÔÚ³ÌÐòÖÐÔËÐÐ stmt.executeUpdate(sql);±¨´í:±ê×¼±í´ïʽÖÐÊý¾ÝÀàÐͲ»Æ¥Åä.

Ææ¹ÖµÄÊÇÕâÓï¾äÔÚACCESSÖÐÔËÐпÉÒÔͨ¹ý,ËùÒÔСµÜ²»Ã÷°×´íÎóÔÚÄÄ,Ó¦¸ÃÈçºÎÐÞ¸Ä?Çë¸ßÊÖ°ïæ!



Á½±íÓÐʲô×ֶμ°×Ö¶ÎÀàÐÍ

Õæ²»ºÃÒâ˼,ÒѸ㶨ÁË,Ö÷ÒªÊDZ¸×¢ÀàÐ͵Äת»».ÎÒ¸ÄÁË×Ö¶ÎÀàÐÍΪclob½ÓÊÕ.Ô­À´ÊÇvarchar(3000).

²»¹ýÒÔǰҲÊÇ¿ÉÒÔµ¼ÈëµÄ,»¹ÊÇºÜÆæ¹Ö.

ºÇºÇ£¬×Ô¼º½â¾ö¸üºÃ


²»ÊÇ,ACCESSÊý¾ÝÀ´Ô´ÓÚMSSQLµÄ,ÄÇÀï±¾À´¾ÍÊÇvarchar(3000).ËùÒÔÔÚACCESSÖпÉÒÔÕý³£µ¼Èë.


Ïà¹ØÎÊ´ð£º

Access²éÕÒÖØ¸´ÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......

ASP+ACCESSÊä³öÎÊÌâ - Web ¿ª·¢ / ASP

ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......

ÈçºÎÐÞ¸ÄACCESSϵͳ±í

ÈçºÎÐÞ¸Ämsysobjects±íÖеÄÊý¾ÝÄØ£¿Ð»Ð»
ɶ¶¼Ã»ÓÐ,Òâ˼²»Ã÷È·,ÔÙÏêϸµã°É

²»Òª¸ÄsysobjectsÀïµÄ¶«Î÷¡£
ÓÃÆäËü·½·¨¸Ä£¬±íÃû»òÆäËû¡£

ÒªÔÚACCESS»·¾³ÏÂÅäÖÃȨÏÞ£¬²ÅÄÜ·ÃÎÊϵͳ±í...

лл´ó¼Ò¡£
ÊÇÕâÑù£¬¿´ ......

tomcatÁ¬½ÓAccessÊý¾Ý¿âÎÊÌâ¡£ - Java / Web ¿ª·¢

¸÷λ¸ßÊֺã¬Âé·³°ïÎÒ¿´ÏÂÕâ¸öÊý¾Ý¿âÁ¬½ÓÎÊÌ⣺
×öÁËÒ»¸öBBSµ«ÊÇÊý¾Ý¿â¾ÍÊÇÁ¬½Ó²»ÉÏ¡£´íÎó´úÂëÈçÏÂ
HTTP Status 500 - 
------------------------------------------------------------------------------- ......

linux²»ÄÜ·ÃÎÊaccess - Java / Java EE

rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬Ë­ÄܸøµãÌáʾ£¿Ð»Ð»
ÄãÔõôÁ¬µÄ£¿

AccesÊý¾Ý¿â..
ÄãÔõôÁ·µÄÄØ£¿

Java code:

static String DBDRIVER = "sun.jd ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ