RFID課程設(shè)計(jì)-駕校計(jì)時(shí)系統(tǒng)

1、童履厭z夬辱rfid課程設(shè)計(jì)計(jì)算機(jī)科學(xué)與工程 學(xué)院 物聯(lián)網(wǎng)工程專(zhuān)業(yè) 312 班設(shè)計(jì)題目：駕校計(jì)時(shí)系統(tǒng)組長(zhǎng)：成員：本人在組內(nèi)完成的主要工作:wifi模塊成 績(jī)：設(shè)計(jì)方案20%完成功能20%設(shè)計(jì)報(bào)告20%態(tài)度能力10%演示答辯30%學(xué) 號(hào)：姓 名：時(shí) 間：2016丄10目錄一、設(shè)計(jì)方案21. 系統(tǒng)功能實(shí)現(xiàn)22. wifi連接功能實(shí)現(xiàn)33. 系統(tǒng)流程圖3二、硬件原理41. wifi模塊簡(jiǎn)介42. wifi模塊圖43.ic 卡6三、系統(tǒng)設(shè)計(jì)61. 數(shù)據(jù)傳輸程序設(shè)計(jì)62. 數(shù)據(jù)接收程序設(shè)計(jì)8四、系統(tǒng)測(cè)試及結(jié)果101. 偵件調(diào)試102. 測(cè)試結(jié)果11pc端顯示獲取的數(shù)據(jù)：wifi連接成功11五、設(shè)計(jì)總結(jié)1

2、1六、參考文獻(xiàn)12七、附錄12一、設(shè)計(jì)方案1. 系統(tǒng)功能實(shí)現(xiàn)以tc卡號(hào)作為駕校人員的編號(hào)，用mrfc522讀出卡號(hào)，將mrfc522通過(guò)wifi信號(hào)與數(shù) 據(jù)庫(kù)連接，再通過(guò)java和數(shù)據(jù)庫(kù)的鏈接及操作進(jìn)行打卡功能。第一次打卡表示開(kāi)始計(jì)時(shí)， 第二次打卡表示結(jié)束計(jì)時(shí)，以此循環(huán)。根據(jù)駕校計(jì)時(shí)系統(tǒng)的需要，用java做了以下功能：1、新卡打卡進(jìn)行注冊(cè)，不是新卡直接打卡開(kāi)始計(jì)吋。2、開(kāi)始計(jì)時(shí)，結(jié)束計(jì)時(shí)，打卡時(shí)長(zhǎng)以及剩余打卡時(shí)長(zhǎng)以及打卡記錄。3、所有的數(shù)據(jù)均在數(shù)據(jù)庫(kù)的表中。2wifi連接功能實(shí)現(xiàn)通過(guò)pc發(fā)送wifi,使wifi模塊與pc進(jìn)行連接并向pc傳送數(shù)據(jù)：1、按要求將pc連接電源。2、通過(guò)串口調(diào)試助手對(duì)

3、wifi模塊進(jìn)行調(diào)試，發(fā)送at指令對(duì)wifi模塊進(jìn)行檢測(cè)，如at+rst 指令，表示重啟模塊。發(fā)送at+cwjap指令讓模塊連上自己的路由器。如果調(diào)試成功，就表 示該wifi模塊可以使用。3、在wifi模塊中燒錄程序，程序中設(shè)置可以連接上的無(wú)線路由名字和密碼，將程序中的tp 地址設(shè)置成與木機(jī)上的tp地址相同。4、將pc路由名字和密碼設(shè)置成與程序中的相同，然后就能進(jìn)行wifi連接了。5、通過(guò)wifi傳送數(shù)據(jù)。3 系統(tǒng)流程圖(1)系統(tǒng)流程圖:(3)數(shù)據(jù)流程圖:二、硬件原理1. wifi模塊簡(jiǎn)介wifi模塊又名串口wifi模塊，屬于物聯(lián)網(wǎng)傳輸層，功能是將串口或ttl電平轉(zhuǎn)為符合 wifi無(wú)線網(wǎng)絡(luò)通信

4、標(biāo)準(zhǔn)的嵌入式模塊，內(nèi)置無(wú)線網(wǎng)絡(luò)協(xié)ixieee802.11b.g.n協(xié)議棧以及 tcp/ip協(xié)議棧。傳統(tǒng)的硬件設(shè)備嵌入wifi模塊可以直接利用wifi聯(lián)入互聯(lián)網(wǎng)，是實(shí)現(xiàn)無(wú)線 智能家居、m2m等物聯(lián)網(wǎng)應(yīng)用的重耍組成部分?；秩胧絯ifi模塊，32位單片機(jī)，內(nèi)置wifi 驅(qū)動(dòng)和協(xié)議，接口為一般的mcu接口如uart等。適合于各類(lèi)智能家居或智能硬件單品。技術(shù)參數(shù)：?jiǎn)?v或3.3v供電工作溫度范圍：45°0+85°0尺寸：32mm x 20mm x 4.5mm2. wifi模塊圖(2).原理圖» nb3c卡智能tc卡工作的基木原理是：射頻讀寫(xiě)器向tc卡發(fā)一組固定頻率的電磁波，

5、卡片內(nèi) 有一個(gè)ic串聯(lián)協(xié)振電路，具頻率與讀寫(xiě)器發(fā)射的頻率相同，這樣在電磁波激勵(lì)卜lc協(xié)振 電路產(chǎn)生共振，從1何使電容內(nèi)有了電荷；在這個(gè)電荷的另一端，接有一個(gè)單向?qū)ǖ碾娮颖? 將電容內(nèi)的電荷送到另一個(gè)電容內(nèi)存儲(chǔ)，當(dāng)所積累的電荷達(dá)到2v時(shí)，此電容可作為電源為 其它電路提供工作電壓，將卡內(nèi)數(shù)據(jù)發(fā)射出去或接受讀寫(xiě)器的數(shù)據(jù)。接觸式1c卡接口技術(shù) 原理tc卡讀寫(xiě)器要能讀寫(xiě)符合is07816標(biāo)準(zhǔn)的tc卡。三、系統(tǒng)設(shè)計(jì)1 數(shù)據(jù)傳輸程序設(shè)計(jì)(1)wifi模塊傳輸設(shè)計(jì)wifi模塊通過(guò)at指令進(jìn)行重啟，設(shè)置模塊為sta和ap模式，讓模塊連上自己的路 由器，啟動(dòng)模塊多連接，讓模塊連上我們的tcp服務(wù)器利發(fā)送數(shù)據(jù)。部

6、分代碼：(1)重啟:unsigned char xdata chl = ,at+rstrn0"(2 )設(shè)置模塊為 sta 和 ap 模式：unsigned char xdata ch2="at+cwmode=3rn0h;(3) 讓模塊連上自己的路由器：unsigned char xdata ch3=,at+cwjap=,qwe,>,12341234,rnh;(4) 啟動(dòng)模塊多連接:unsigned char xdata ch4 = "at+cipmux=lrn0"(5) 讓模塊連上我們的tcp服務(wù)器：unsigned char xdata ch5=

7、”at+cipstart=”tcpj”192168：l9：l：l”，9999rrr'(6)發(fā)送數(shù)據(jù)：void main()unsigned unsigned unsigned unsigned unsignedchar status;char mes4;char card10;char str="at+cipsend=4j10rn0"int i;initializesystem(); pcdreset();pcdantennaoff(); pcdantennaon();inituart();initwifi();card0=,c,;cardl='a'

8、send_sbuf(,at+cipsend=4>6rn0");delayms(1000);send_sbuf(,123456rn0m);delayms(1000);while ( 1 )p2=0x00;led_green = 0;status = pcdrequest(picc_reqallj g_uctempbuf);/復(fù)位操作if (status != mi_ok)led_green = 1;continue;status = pcdanticoll(g_uctempbuf);/防沖撞if (status != mi_ok)continue;p2=0xff； status

9、= pcdselect(g_uctempbuf);/選定卡片if (status != mi_ok) continue;status = pcdauthstate(picc_authentla> 1, defaultkey? g_uctempbuf);/驗(yàn)證卡密碼if (status != mi_ok) continue;p2=0xff； elsep2=0xff;for(i=0;i<4;i+)mesi=g_uctempbufi; /printf (,%c,>mesi);card2=(unsigned char)(0x30+mes0/10);card3=(unsigned ch

10、ar)(0x30+mes0%10); card7=(unsigned char)(0x30+mes2%10); card8=(unsigned char)(0x30+mes3/10); card9=(unsigned char)(0x30+mes3%10); card10=,0,;card4=(unsignedchar)(0x30+mesl/10);card5=(unsignedchar)(0x30+mes1%10);card6=(unsignedchar)(0x30+mes2/10);send_sbuf(uat+cipsend=4,10rn0n); delayms(1000);send_sb

11、uf(card); delayms(1000);status = pcdwrite(l, datal);/寫(xiě)數(shù)據(jù)到卡片if (status != mi_ok) continue;/扣款和充值p2=0xff; status = pcdvaluecpicdecrement, 1, data2);if (status != mi_ok) continue; status = pcdbakvalue(l> 2);/備份錢(qián)包if (status != mi_ok) continue;p2=0xff; status = pcdread(2, g_uctempbuf);/讀卡數(shù)據(jù)if (status

12、!= mi_ok) continue;p2=0xff; pcdhalt();/進(jìn)入休眠2. 數(shù)據(jù)接收程序設(shè)計(jì)(1) wifi 連接代碼如下：package wifi;import java.io.ioexception;import .serversocket;import javanet.socket;import javautil.concurrentexecutorservice;import javautilconcurrentexecutors;public class server public static void main(string args) server server

13、二new server(); server.startserver();/啟動(dòng)服務(wù)器public void startserver()serversocket ss=null;try ss=new serversocket(9999);/設(shè)置連接端口為 9999 while(true)system. out printin (”正在連接”);socket s=ss.accept();/這是一個(gè)阻塞的方法system.out. print in ("連接成功”)；/創(chuàng)建出一個(gè)線程來(lái)deviceuser devicellser=new devicellser(s);executorser

14、viceexecutorservice=executors.newfixedthreadpool(10);/設(shè)置一個(gè)最多只能容納 10 個(gè)線 程的線程池。executorservice execute(deviceuser);/執(zhí) 行該線程 catch (ioexception e) e.printstacktrace();(2)連入數(shù)據(jù)庫(kù)代碼如下：public static connection getconnection()string url = "jdbc: derby:/localhost: 1527/jsy"/jsy 代表要使用的數(shù)據(jù) 庫(kù)string user

15、= "jjj"string pwd = "jjj"/數(shù)據(jù)庫(kù)的密碼connection conn=null ;try class forname("org.apachederbyjdbc clientdriver"); conn = drivermanager.getconnection(url, user, pwd); catch (exception e) / todo auto-generated catch block eprintstacktrace();return conn;(3)接收wifi傳遞的數(shù)據(jù) 代碼如下：/構(gòu)造函

16、數(shù)，川于獲取相應(yīng)的通信的流public deviceuser(socket s) throws ioexception this.s = s;inputstream is = s.getlnputstream(); this is = is;outputstream os = s>getoutputstream(); this.os = os;/用于關(guān)閉流public void end() try this.os.close();this.is.close(); this.s.close(); catch (exception e) e>printstacktrace();us系統(tǒng)

17、測(cè)試及結(jié)果1硬件調(diào)試檢測(cè)各硬件模塊是否斷路或者短路，根據(jù)電路圖查看接線線路是否正確。檢測(cè)接線無(wú)誤 后，接入電源，測(cè)量各芯片的供電電壓，檢査無(wú)誤后，進(jìn)入軟件調(diào)試階段。2. 測(cè)試結(jié)果pc端顯示獲取的數(shù)據(jù)：wifi連接成功123456cas09a4：2五、設(shè)計(jì)總結(jié)兩周的課程和設(shè)計(jì)讓我受益良多。這次課程設(shè)計(jì)使我對(duì)esp8266w1f1模塊有了一定的了 解,知道了一些at指令,如at+rst指令、at+cwjap指令以及at+c1psend指令等,同時(shí)也 對(duì)通過(guò)wifi接收數(shù)據(jù)也有了一定的認(rèn)識(shí)，同樣，這次課程設(shè)計(jì)也使我深深地認(rèn)識(shí)到了口己 的不足，以便讓我在之后的學(xué)習(xí)中應(yīng)當(dāng)更加努力。當(dāng)通過(guò)wifi接收數(shù)據(jù)

18、時(shí)，我遇到了很大 困難，經(jīng)過(guò)與小組成員一起協(xié)商思考以及其他同學(xué)的幫助后，最后還是解決了這個(gè)閑難。這次實(shí)驗(yàn)的基木功能都已經(jīng)實(shí)現(xiàn)，但總體思路比較簡(jiǎn)單，系統(tǒng)不夠完善，功能也較為簡(jiǎn) 單?？偟膩?lái)說(shuō)這次課程設(shè)計(jì)我學(xué)會(huì)了很多知識(shí)，獲得了一些開(kāi)發(fā)設(shè)計(jì)經(jīng)驗(yàn)，為今后能夠完成 其他的設(shè)計(jì)奠定了基礎(chǔ)。六、參考文獻(xiàn)1 射頻識(shí)別(rftd)原理與應(yīng)用，單承贛、單圭峰，電子工業(yè)出版社。2 esp8266開(kāi)發(fā)資料七、附錄設(shè)計(jì)代碼:通過(guò)wifi模塊發(fā)送數(shù)據(jù)#include "lpcreg.h"#include 11 main h'*#include "mfrc522.hh #inelude

19、 <stdio.h> /#include nreg52.h"#include “tempsh"unsigned unsigned unsigned unsigned unsignedcharcharcharcharcharint num =1;unsigned char unsignedxda taxda taxda taxdataxda taxda tachl=nat+rstrn0n;ch2=l,at+cwmode=3rn0,1;ch3=,at+cwjap=l,qwel,j,l12341234,rn11；ch4=,at+cipmux=lrn0,1;ch5=&q

20、uot;at+c：lpstart=tcpjt92：l68：l9：l：lj9999rrr；ch6 =i,at+cipsend=4,2rn0n;charcodedatal160x12,0x34,0x56,0x78,oxed.oxcb.oxag,0x87,0x12,0x34,0x56,0x78,0x01,0xfe,0x01,0xfe;/m2卡的某一塊寫(xiě)為如下格式，則該塊為錢(qián)包，可接收扣款和充值命令/4字節(jié)金額(低字節(jié)在前)+4字節(jié)金額取反+4字節(jié)金額+ 1字節(jié)塊地址+ 1字節(jié)塊地址収反+ 1字節(jié) 塊地址+ 1字節(jié)塊地址取反 void delayms(unsigned int ms) unsigned

21、 charcode data24=0x12,0,0,0;unsigned charcode defaultkey6 = 0xff, 0xff, 0xff, 0xff, 0xff, 0xff;unsignedchar g_uctempbuf20;int ij;for(i=0;i<ms;i+)for(j=0;j<114;j+)void send_sbuf(unsigned char *str) unsigned char i = 0;while (stri != 10*) sbuf = stri+;/change(stri+);while (!ti)等待數(shù)據(jù)傳送完畢ti = 0； 淸中

22、斷標(biāo)志void inituart(void)/ unsigned char buff;/ p0 = 0xff;p2 = 0xff;scon = 0x50； /設(shè)定串口工作方式1,接收使能pcon = 0x00； /波特率不倍增tmod = 0x20； /定時(shí)器1工作于8位門(mén)動(dòng)重載模式，用于產(chǎn)牛波特率ea = 1；tl1 = 0xfd;th1 = 0xfd； /波特率 9600tri = 1；1111illi delayms(100);illiilli send_str(strl); /發(fā)送英文字符串illi delayms(1000);illi txdatacxn*); /換行illi sen

23、d_str(str2); 發(fā)送中文字符串illi delayms(1000);illiilli txdata('o');illi txdata('k');illi txdatacn'); 換行illi delayms(1000);illiilli ii send_str(g_uctempbuf); 發(fā)送序列號(hào)/void initwifi(void)send_sbuf(chi);delayms(1000);send_sbuf(ch2);delayms(1000);send_sbuf(ch3);delayms(5000);send_sbuf(ch4);del

24、ayms(5000);send_sbuf(ch5);delayms(5000);void main()unsigned char status;unsigned char mes4;unsigned char card10;unsigned char str=hat+cipsend=4>10rn0n; unsigned int i;initializesys);pcdreset();pcdantennaoff();pcdantennaon();inituart();initwifi();card0='c*;cardl = lat;send_sbuf (l'at+cipse

25、nd=4j 6rn0h);delayms(1000);send_sbuf (l,123456rn0,1);delayms(1000);while ( 1 )p2=0x00；復(fù)位操作led_green = 0；status = pcdrequest(picc_reqall g_uctempbuf); if (status != mi_ok)led_green = 1;continue;status = pcdanticoll (g_uct empbuf);/防沖撞if (status != mi_ok)continue;p2=0xff; status = pcdselect(g_uctempbu

26、f);/選定卡片if (status != mi_ok) continue;status = pcdauthstatecpiccauthentla 1, defaultkey g_uctempbuf);/驗(yàn)證卡密碼if (status != mi_ok)continue;p2=0xff; elsep2=0xff;for(i=0;i<4;i+)mesi=g_uctempbufi; /printf(“c”esi);card2=(unsigned char)(0x30+mes0/10); card3=(unsigned char)(0x30+mes0%10); card4=(unsigned

27、char)(0x30+mesl/10); card5=(unsigned char)(0x30+mesl%10); card6=(unsigned char)(0x30+mes2/10); card7=(unsigned char)(0x30+mes2%10); card8=(unsigned char)(0x30+mes3/10); card9=(unsigned char)(0x30+mes3%10); card10='0*;send_sbuf (llat+cipsend=4j 10rn0h); delayms(1000);send_sbuf(card);delayms(1000)

28、;status = pcdwrite(l, datal);/寫(xiě)數(shù)據(jù)到卡片if (status != mi_ok)continue;p2=0xff; /扣款和充值status = pcdvalue(picc_decrement,l，data2);if (status != mi_ok)continue;status = pcdbakvalue(l 2);/備份錢(qián)包if (status != mi_ok)continue;讀卡數(shù)據(jù)p2=0xff; status = pcdread(2 g_uctempbuf); if (status != mi_ok)continue;p2=0xff; pcdha

29、lt();/進(jìn)入休眠/系統(tǒng)初始化/void initializesystem()p0m1=0x0；p0m2 = 0x0；p1m1=0x0；p1m2 = 0x0；p3m1=0x0；p3m2 = 0xff；p0 =0xff；pl = 0xff； p3 = 0xff；連接wifi :package wifi;import java.io.ioexception;import serversocket;import .socket;import java.util.concurrentexecutorservice;import java.util.concurrent.executors;publi

30、c class server public static void main(string args) server server=new server();server.staltserver();/啟動(dòng)服務(wù)器public void startserver()serversocket ss=nu11;try ss=new serversocket(9999);/設(shè)置連接端口為 9999while(true)system. out. printin (” 正在連接”);socket s=ss.accept();/這是一個(gè)阻塞的方法system. out. printin ("連接成功

31、");/創(chuàng)建出一個(gè)線程來(lái)deviceuser deviceuser=new devicellser(s);executorservice executorservice=executors.newfixedthreadpool(10);/設(shè)置一個(gè)最多只能容納10個(gè)線程的線程池。executorservice. execute (deviceuser); /執(zhí)行該線程 catch (ioexception e) e.printstacktrace();接收數(shù)據(jù)：package wifi;import java.io.ioexception;import javaio.inputstre

32、am; import java.io.outputstream;import javanet>socket;import java>sql.connection;import javasqlpreparedstaternent; import java.sql.resultset;import java.sqles tat erne nt; import javatextsimpledateformat; import java>util>date;import javax.swing.joptionpane;public class deviceuser implem

33、ents runnable public socket s = null;public inputstream is = null;public outputstream os = null;/構(gòu)造函數(shù)，用于獲取相應(yīng)的通信的流public devicellser(socket s) throws ioexception this.s = s;inputstream is = s.getlnputstream();this is = is;outputstrearn os = s.getoutputstream(); this.os = os;用于關(guān)閉流public void end() try

34、 this.os.close();this.is.close();thises<close(); catch (exception e) e.printstacktrace();overridepublic void run() try while (true) byte b = new byte20;int i = is<read(b);string cardnum 二 new string(b);system.outprintin(cardnum);if(cardnum.length()<71|cardnum.equals("123456”)；elsetryco

35、nnection conn=db.getconnection();statement stmt=null;resultset rs=nu11，rs2=nu11 rs3二nu11;stmt=conncreatestatement();string zh=null;int k=0;rs3=stmt.executequery("select *from code"); /編碼隊(duì)列 while(rs3next()if (card num. equals (rs3.ge tstrin g(llcode")system. out. print in (rs3. getstri

36、ng( "number ")+"為該卡號(hào)k=l;zh=rs3 getstring(”number"); break;if(k=l)rs=stmt. execut equery ("select *from ontime"); /數(shù)據(jù)庫(kù)隊(duì)列/ jtextfield2.settext(zh);/獲取賬號(hào)int z=0;while(rsnext()if (zh equals (rs getstring(''n umber")”);sys tem out print in (rs getstr ing( ”nu mb

37、er")+n :正在打卡 z=l；break;simpledateformat df = new simpledateformat(”yyyymmddssn); /時(shí)間system011上卩:111七1門(mén)(df.format(new date();/ jlabell. settext(df. format (new date();/顯示打卡時(shí)if(z=0)int j=0;rs2=stmtexecutequery(”select *from meber");while(rs2.next()查看if (zh. equals(rs2.ge tstr in g(h nu mber1

38、1)是否有該賬戶sys tem out print in (rs2 getstr ing (” nu mber”)+ ”:正在打r j=l;break;if(j=l)object option="正在打卡"；joptionpane.showmessagedialog(nu11， option);system. out. printin ("開(kāi)始打卡");string sq=,finsert into ontime values？)”；preparedstatement pstmt=conn.preparestatement(sq); pstmtsetst

39、ring(l zh);pstmtsetstring(2df.format(new date();pstmtexecuteupdate();pstmtclose();else object option=h該卡號(hào)未注冊(cè)“；joptionpane.showmessagedialog(nu11， option);elsesystem. out. printin (“打卡結(jié)朿“);/打卡結(jié)束string ll=df.format(new date();date dl=dfparse(ll);string 12二rs getstring(mestart”)；date d2=df.parse(12);st

40、ring sqlrocord=hinsert into record values(?，？，？)”；/記錄preparedstatementpstmtl=conn.preparestatement(sqlrocord);pstmtlsetstring(lzh);pstmtl setstring(2, 12);pstmtl.setstring(3, 11);pstmtlexecuteupdate();pstmtl>close();systemoutprintin(rs.getstring(ntimestart");long h2=d2.gettime();long hl=dl.g

41、ettime();long sj=hl-h2;int hh=(int) (sj/3600000);if(hh>=6) hh=6;system.out.println(h 打卡,+hh+n 小時(shí)”)；object option=h打卡結(jié)束!”+“本次打卡"+hh+h小時(shí)”;joptionpane.showmessagedialog(nu11, option);日言息string sql="delete from ontime where number=?m;/刪除打preparedstatement pstmt2=conn.prepaystatement(sql); p

42、stmt2.setstring(ljzh);pstmt2executeupdate();pstmt2.close();rs2=stmt.executequery(”select *from meber");while(rs2 .nexto)if(zh.equals(rs2.getstring(hnumber")break;int resttime=rs2 getlnt(f,resttime");if(resttimehh>0)object option0="還有"+(resttime-hh)+"ds時(shí)"；joptionpane.showmessagedialog(nu11， option);string sq2=nupdate meber set resttime=? where number=?"preparedstatement pstmt3=connpreparestatement(sq2);pstmt3>setlnt(1，resttime-hh);pstmt3setstring(2, zh);pstmt3 execu tellpda te();pstmt3>close();elseobject option"