Web.configÖжÔAccessÊý¾Ý¿âÁ´½Ó¼¬ÊÖÎÊÌâ
£¨1£©ÔÚVS2008µÄWeb.configÖÐÅäÖÃÊý¾Ý¿âÁ´½Ó×Ö·û´®Ê±£¬Äܲ»ÄÜÅäÖöÔAccessµÄÁ´½Ó×Ö·û´®£¿
£¨2£©ÎÒÓÐÈçÏ´úÂ뱨´í£º
<add name="AccessStringDB" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source='FirstWeb.mdb';Persist Security Info=True" providerName="System.Data.SqlClient"/>
±¨´íÊÇ£º²»Ö§³Ö¹Ø¼ü×Ö: ¡°provider¡±¡£
ÊÔÁ˺ܶ෽·¨£¬¶¼²»ÐУ¡
Çë¸÷λ¼¼Êõʦ¸çʦ½ã°ïæ¡£¡£¡£¡£Òª¼ÇµÃÊǶÔAccessÊý¾Ý¿âÁ´½ÓµÄŶ£¡
<appSettings>
<add key="ConnProvider" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="/>
<add key="ConnSource" value="App_Data/Êý¾Ý¿â.mdb"/>
</appSettings>
<add name="accessConnStr" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source= |DataDirectory|a.mdb" providerName="System.Data.OleDb"/>
<appSettings>
<add key="ConnString" value="provider=microsoft.jet.oledb.4.0;data source="/>
<add key="dbPath" value="~/App_Data/a.mdb"/>
</appSettings>
<add name="accessConnStr" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source= |DataDirectory|a.mdb" providerName="System.Data.OleDb"/>
<appSettings>
<add key="ConnString" value=&qu
Ïà¹ØÎÊ´ð£º
dwr.xml:
<create creator="struts" javascript="PrisonerActionForm">
<param name="formBean" value="prisonerForm"/>
< ......
´ó¼Ò°ïÏÂæÁË
Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ
±ÈÈçÎÒÏÖÔÚ²éѯ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú'
²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿
±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......
vcÖÐÓÃodbcµÄ·½·¨·ÃÎÊaccessÊý¾Ý¿â£¬Óõ½ÁËcdatabaseÀàºÍcrecordsetÀà¡£Êý¾ÝÔ´ÔÚ´°¿Ú³õʼ»¯µÄʱºò±»´ò¿ªg_datasource.Open("data",FALSE,FALSE); µã»÷Ò»¸ö°´Å¥Æô¶¯Ò»¸ö¶¨Ê±Æ÷£¬ÔÚ¶¨Ê±Æ÷ÄÚÍê³ÉÒÔϲÙ×÷£¬¶¨ ......
ÎÒ×öÁËÒ»¸öС³ÌÐò£¬ÏëʵÏֵŦÄܾÍÊÇÔÚÎı¾¿òÖÐÊäÈëÐÕÃû£¬µã»÷²éѯ°´Å¥£¬¾ÍÄܲ鵽ACCESSÊý¾Ý¿âÖдËѧÉúµÄÐÅÏ¢£¨±àºÅ£¬ÐÕÃû£¬ÐÔ±ð£¬ÄêÁ䣩¿ÉÎÒ²»ÖªµÀÓï·¨¸ñʽ£¬ÎÒ×Ô¼ºÐ´µÄÓï¾äµ÷ÊÔÄÜͨ¹ý£¬¿ÉÊÇÔËÐÐʱ³ö´í£¨µã»÷²éѯ°´ ......
rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬ËÄܸøµãÌáʾ£¿Ð»Ð»
ÄãÔõôÁ¬µÄ£¿
AccesÊý¾Ý¿â..
ÄãÔõôÁ·µÄÄØ£¿
Java code:
static String DBDRIVER = "sun.jd ......