Á¬½Ó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();
Ïà¹ØÎÊ´ð£º
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
dwr.xml:
<create creator="struts" javascript="PrisonerActionForm">
<param name="formBean" value="prisonerForm"/>
< ......
´ó¼Ò°ïÏÂæÁË
Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ
±ÈÈçÎÒÏÖÔÚ²éѯ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú'
²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿
±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......
ÈçÌâ dOOdads Á¬½Ó ACCESS µÄÊý¾Ý·ÖÒ³ÎÊÌ⣡
ʹÓà dOOdads Á¬½Ó ACCESSÊý¾ÝµÄʱºò Êý¾Ý·ÖÒ³µÄÎÊÌ⣡
¸ù¾ÝÕâ¸ö¸Ä°É
C# code:
public static Product[] SearchProducts(string keyword, int categoryID, int pa ......