适老智能家居门禁模块功能实现

适老智能家居门禁模块功能实现问题导入？门禁数据库设计门禁管理系统数据库门禁授权信息门禁出入记录信息项名项类型备注kahao文本授权的RFID卡号，主键beizhu文本卡片使用者姓名user表使用Access数据库query_menjin_db函数privatevoidquery_menjin_db(){stringstrConnection="Provider=Microsoft.ACE.OLEDB.12.0;DataSource=|DataDirectory|/user.accdb";OleDbConnectionmyconn=newOleDbConnection(strConnection);myconn.Open();DataSetmydataset=newDataSet();stringstrcmd="SELECTuser.[kahao],user.[beizhu]FROM[user];";OleDbDataAdaptermycommand=newOleDbDataAdapter(strcmd,myconn);mycommand.Fill(mydataset,"user");myconn.Close();dataGridView1.DataSource=mydataset.Tables["user"];

}首先创建并打开与数据库的链接创建数据集和数据适配器填充数据集，并设置为DataGridView控件的数据源Iskahao函数privateintiskahao(stringcardsn)

{stringstrConnection="Provider=Microsoft.ACE.OLEDB.12.0;DataSource=|DataDirectory|/user.accdb";OleDbConnectionmyconn=newOleDbConnection(strConnection);myconn.Open();stringstrcmd="selectcount(*)FROM[user]WHERE[kahao]='"+cardsn+"'";OleDbCommandcmd=newOleDbCommand(strcmd,myconn);intiret=Convert.ToInt32(cmd.ExecuteScalar());

myconn.Close();returniret;

}首先创建并打开与数据库的链接以SelectcountSQL语句创建Command对象执行Command对象的ExecuteScalar方法获得结果dukahao函数privatevoiddukahao(){Byte[]data=newbyte[200];intidx;intbcc=0;data[0]=0x02;data[1]=0x00;data[2]=0x03;data[3]=0x25;data[4]=0x26;data[5]=0x00;for(idx=1;idx<6;idx++)bcc=bcc^data[idx];data[idx++]=Convert.ToByte(bcc);data[idx++]=0x03;spComRfid.Write(data,0,idx);