Á¬½ÓaccessµÄÆæ¹ÖÎÊÌâ
×¢²á»áÔ±³É¹¦ÁË£¬Êý¾Ý¿âÒ²ÓÐÁË£¬È»ºóÎÒÓÃ×¢²áµÄÓû§µÇ¼£¬Ö»Óд洢Êý¾Ý¿â×îºóÒ»ÌõÊý¾ÝÄܵǼ£¬ÆäÓà¶¼²»ÄܵǼʲôÔÒò
û¿´µ½ÄãµÄ´úÂë²»ÖªµÀ£¡£è£å£è£å
Ìù´úÂë³öÀ´¿´¿´°É!!!!
Äǿ϶¨ÊÇÄãµÄ´úÂëµÄÔÒò£¬ÄãʹÓÃÁËÓ²±àÂëÁ˰ɣ¿
°ÑÄãµÄµÇ¼²¿·Ö´úÂëÌùÉÏÀ´¿´¿´¡£
string usname = null;
string psw = null;
string role = "";
string conString = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=aa.mdb";
OleDbConnection conn = new OleDbConnection(conString);
conn.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
cmd.CommandText = "select username,[password],role from [user]";
OleDbDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
usname = rdr["username"].ToString();
psw = rdr["password"].ToString();
Ïà¹ØÎÊ´ð£º
DbgridÁ¬½Óaccess ÏÔʾÊý¾ÝʱÍ϶¯¹ö¶¯ÌõËÀ»ú£¿Ôõô½â¾ö°¡£¿
»úÆ÷Ì«²îÁ˰ɣ¿
ÊDz»ÊÇÄãÊý¾ÝÁ¿Ì«´óÁ˰¡
ÄãÊý¾ÝÉÙһЩ¿´¿´»¹ËÀ»úÂð£¿
Êý¾ÝºÜÉÙ°¡ ¾ÍÒ»Ò³¡£
ÎÒÔÚBCB6ÏÂ×ö¹ý²»ÉÙ DBGRID+ACCESS £¬´ÓÀ´Ã»ÓÐÓöµ½ ......
¸÷λ¸ßÊֺã¬Âé·³°ïÎÒ¿´ÏÂÕâ¸öÊý¾Ý¿âÁ¬½ÓÎÊÌ⣺
×öÁËÒ»¸öBBSµ«ÊÇÊý¾Ý¿â¾ÍÊÇÁ¬½Ó²»ÉÏ¡£´íÎó´úÂëÈçÏÂ
HTTP Status 500 -
------------------------------------------------------------------------------- ......
rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬ËÄܸøµãÌáʾ£¿Ð»Ð»
ÄãÔõôÁ¬µÄ£¿
AccesÊý¾Ý¿â..
ÄãÔõôÁ·µÄÄØ£¿
Java code:
static String DBDRIVER = "sun.jd ......
ÎÒÊÖ¶¯Ìí¼Ó»ùÓÚCRecordSetÀàµÄÅÉÉúÀàCODBCDemoSetÀà,ÊÇÀûÓÃclass wizardÌí¼ÓµÄ¡£²¢ÇÒ¶¨ÒåÁËÒ»¸öÈ«¾Ö±äÁ¿CODBSDemoSet*m_pCommon.µ«ÊÇÎÒ³ÌÐò²»ÄÜÔËÐС£ÎÒ¸ú×ÙÁËһϣ¬µ½ÁËm_pCommon->Isopen£¨£©´¦·¢Éú´íÎ󣬣 ......
±í½á¹¹:
table1
Ö¤¼þºÅ ʱ¼ä
X31 2010-01-11
3BC 2010-02-03
3AD 2010-02-03
F23 2010-02-09
......
ÏÖÔÚҪͳ¼ÆÒ»¸öʱ¼ä¶ÎÈç 2010-01-09 µ½ 2010-02-09¼äµÄÊý¾Ý,
ÆÚ´ý½ ......