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

accessÁ¬½Ó×Ö·û´®ÎÊÌâ

¿É²»¿ÉÒÔ°ÑaccessÁ¬½Ó×Ö·û´®Ð´½øÒ»¸öÀàÖУ¬È»ºóÒªÓõÄʱºòµ÷ÓÃ
¾ÍÏñSQLÄÇÑùÑù£º

using System.Data.SqlClient;

public class DBHelper
{
    public DBHelper()
    {
    }
    public static SqlConnction Create()
    {return new SqlConnection("server=.;uid=sa;pwd=;database=xxx.mdf");}
}

µ÷ÓõÄʱºòÖ±½ÓSqlConnetion conn=DBhelper.Create();

Èç¹ûÊÇACCESSµÄ»°ÔõôҲ£¬ÎÒÏñÕâÑùÊÔ¹ý£¬Ìáʾ¡°ÉÏÏÂÎÄÖв»´æÔÚserver¡±accessÏà¶Ô·¾¶ÓÃServer.MaPpath()
¿ÉÄܵģ¬ÄãÒ²¿ÉÒÔÓö¯ÈíµÄ´úÂëÉú³ÉÆ÷À´ÊµÏÖ¡£×Ô¶¯Éú³É¡£

private  string  _strConn; 
  private  string  strConnection 
  { 
        get  { 
              if(  _strConn==null  ) 
                    _strConn  ="Provider=Microsoft.Jet.OleDb.4.0;  data  source="  +  Server.MapPath(".")+"\\dbWebIS.mdb"; 
              return  _strConn; 
        } 
  }

connectionstring.com
<add name="accessConnStr" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data


Ïà¹ØÎÊ´ð£º

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

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

ÈçºÎ´ÓACCESSÊý¾Ý¿âÖÐÒ»´Î²éѯ¶à¸ö±í²¢¼ÓÈëÊý¾Ý¼¯?

ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......

½â¾öaccess¼¶Áª¸üÐÂÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

CREATE TABLE Product(model integer, 
maker varchar(20), 
CONSTRAINT SAND PRIMARY KEY (model), 
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model) 
ON DELETE CASCADE ......

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ºÅ