Á¬½ÓACCESSÊý¾Ý¿â·¢Éú´íÎó
private void but_login_Click(object sender, EventArgs e)
{
string constring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\³ÌÐòÁ·Ï°\\database\\data.accdb;Persist Security Info=False ";
OdbcCommand comm = new OdbcCommand();
OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = constring;
comm.Connection = conn;
conn.Open();
comm.CommandText = "select * from user where user_name="+teb_username.Text +"and user_password="+teb_password.Text;
OdbcDataReader reader = new OdbcDataReader();
reader = comm.ExecuteReader();
if (reader.HasRows)
.........
ÔÚconn.open();ÖгöÏÖ´íÎó£¬ÌáʾERROR [IM002] [Microsoft][ODBC Çý¶¯³ÌÐò¹ÜÀíÆ÷] δ·¢ÏÖÊý¾ÝÔ´Ãû³Æ²¢ÇÒδָ¶¨Ä¬ÈÏÇý¶¯³ÌÐò
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\½Ìѧ\HandsOn\DesignPattern\SimpleFactory\SF.mdb;User Id=admin;Password=;
ÕâÊÇÎÒÔÚÅäÖÃÎļþдµÄ×Ö·û´®£¬Äã±È½Ïһϰ¡
\\data.accdb
accessÓ¦¸ÃÊÇmdb½áβ°É£¿
Ó¦¸ÃÊÇÄãµÄÁ¬½Ó×Ö·û´®ÓÐÎÊÌâ accessÊý¾Ý¿âµÄºó׺ÃûÊÇmdb°É »¹ÓоÍÊǰÑpersist security InfoÉèÖÃΪTrueÊÔÒ»ÊÔ
ûÁ¬ÉϿ⣬¼ì²éÁ¬½Ó´®Óï¾ä´íÎó¡£
½¨Ò飺
ÔÚweb.config/app.configÖж¨Òå
<add key="DatabaseType" value="Oledb"/>
<add key="ConnectionString" value="provider=microsoft.jet.oledb.4.0;Data Source="/>
Ïà¹ØÎÊ´ð£º
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
ÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤?
ÄãÊÇÔõÑù¸³ÖµµÄ£¿
²âÊÔÁËһϣ¬Óñ¸×¢×ֶθøÎı¾¿ò×öÊý¾ÝÔ´£¬Ã»ÓÐÌáʾÉèÖÃֵ̫³¤,14893×Ö·û
ÒýÓÃÎÒ½«Ò»¶Î4000À´×ÖµÄÎ ......
ÎÊÌâÊÇÕâÑùµÄ,ÏÖÔÚÓÐÒ»¸ö¹¤×ʱí,ÊÇEXCELµÄ,ÎÒÒª°ÑËüµ¼ÈëACCESS,ÒòΪ Òª²éѯÿ¸öÈ˵Ť×Ê,¸ù¾Ý²»Í¬µÄ±àºÅ¿ÉÒÔ²éѯµ½Ïà¶ÔµÄÈË,
ÓÃASP Ôõô½«EXCELµ¼Èëµ½ACCESS,¶øÇÒÿÔ¶¼Óв»Í¬µÄ±í,
ÒýÓÃ
Æäʵ¾ÍÊǰÑEXCELµ±³ÉÊý ......
rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬ËÄܸøµãÌáʾ£¿Ð»Ð»
ÄãÔõôÁ¬µÄ£¿
AccesÊý¾Ý¿â..
ÄãÔõôÁ·µÄÄØ£¿
Java code:
static String DBDRIVER = "sun.jd ......