Arduino、MFRC522

/*MFRC522 pin layout used:
   ---------------------------------------
               MFRC522      Arduino       
               Reader/PCD   Uno/101       
   Signal      Pin          Pin           
   ---------------------------------------
   RST/Reset   RST          5             
   SPI SS      SDA(SS)      9            
   SPI MOSI    MOSI         11
   SPI MISO    MISO         12
   SPI SCK     SCK          13
*/

#include <SPI.h>
#include <MFRC522.h>

#define SS_PIN 9
#define RST_PIN 5

#include <Ethernet.h>
#include <MySQL_Connection.h>
#include <MySQL_Cursor.h>

byte mac_addr[] = { 0xDE, 0xAD, 0xBE, 0xEF, 0xFE, 0xED };
IPAddress ip(192,168,1,222);
IPAddress server_addr(192,168,1,104); // IP of the MySQL *server* here
char user[] = "root"; // MySQL user login username
char password[] = "usbw"; // MySQL user login password

// Sample query
char INSERT_DATA[] = "INSERT INTO test_arduino.hello_sensor (message,sensor_num, value) VALUES (%s,%d,%s)";
char query[128];
char temperature[10];
EthernetClient client;
MySQL_Connection conn((Client *)&client);

MFRC522 rfid(SS_PIN, RST_PIN); // Instance of the class
MFRC522::MIFARE_Key key;
// Init array that will store new NUID
byte nuidPICC[4];
char nuid[2*4+1];

void setup() {
  Serial.begin(9600);
  while (!Serial); // wait for serial port to connect

  SPI.begin(); // Init SPI bus
  rfid.PCD_Init(); // Init MFRC522

  for (byte i = 0; i < 6; i++) {
    key.keyByte[i] = 0xFF;
  }

  Serial.println(F("This code scan the MIFARE Classsic NUID."));
  Serial.print(F("Using the following key:"));
  printHex(key.keyByte, MFRC522::MF_KEY_SIZE);

}

void loop() {
// Reset the loop if no new card present on the sensor/reader. This saves the entire process when idle.
  if ( ! rfid.PICC_IsNewCardPresent())
    return;

  // Verify if the NUID has been readed
  if ( ! rfid.PICC_ReadCardSerial())
    return;

  Serial.print(F("PICC type: "));
  MFRC522::PICC_Type piccType = rfid.PICC_GetType(rfid.uid.sak);
  Serial.println(rfid.PICC_GetTypeName(piccType));

  // Check is the PICC of Classic MIFARE type
  if (piccType != MFRC522::PICC_TYPE_MIFARE_MINI &&  
    piccType != MFRC522::PICC_TYPE_MIFARE_1K &&
    piccType != MFRC522::PICC_TYPE_MIFARE_4K) {
    Serial.println(F("Your tag is not of type MIFARE Classic."));
    return;
  }

  if (rfid.uid.uidByte[0] != nuidPICC[0] ||
    rfid.uid.uidByte[1] != nuidPICC[1] ||
    rfid.uid.uidByte[2] != nuidPICC[2] ||
    rfid.uid.uidByte[3] != nuidPICC[3] ) {
    Serial.println(F("A new card has been detected."));

      // Store NUID into nuidPICC array
    for (byte i = 0; i < 4; i++) {
        nuidPICC[i] = rfid.uid.uidByte[i];
    }
      
    Serial.println(F("The NUID tag is:"));
    Serial.print(F("In hex: "));
    printHex(rfid.uid.uidByte, rfid.uid.size);
    Serial.print(F("In dec: "));
    printDec(rfid.uid.uidByte, rfid.uid.size);
    Serial.println();   
        
    array2String(rfid.uid.uidByte, 4, nuid);
    insertNUID();
  }
  else Serial.println(F("Card read previously."));

  // Halt PICC
  rfid.PICC_HaltA();

  // Stop encryption on PCD
  rfid.PCD_StopCrypto1();
}

/**
* Helper routine to dump a byte array as hex values to Serial.
*/
void printHex(byte *buffer, byte bufferSize) {
  for (byte i = 0; i < bufferSize; i++) {
    Serial.print(buffer[i] < 0x10 ? " 0" : " ");
    Serial.print(buffer[i], HEX);
  }
}

/**
* Helper routine to dump a byte array as dec values to Serial.
*/
void printDec(byte *buffer, byte bufferSize) {
  for (byte i = 0; i < bufferSize; i++) {
    Serial.print(buffer[i] < 0x10 ? " 0" : " ");
    Serial.print(buffer[i], DEC);
  }
}

void insertNUID(){
  Ethernet.begin(mac_addr,ip);
  Serial.println("Connecting...");
  if (conn.connect(server_addr, 3307, user, password)) {
    delay(1000);
    // Initiate the query class instance
    MySQL_Cursor *cur_mem = new MySQL_Cursor(&conn);
    // Save
    dtostrf(50.125, 1, 1, temperature);
    sprintf(query, INSERT_DATA, nuid, 24, temperature);
    // Execute the query
    Serial.println(query);
    cur_mem->execute(query);
    // Note: since there are no results, we do not need to read any data
    // Deleting the cursor also frees up memory used
    delete cur_mem;
    Serial.println("Data recorded.");
    Serial.println(nuid);
    }
  else
    Serial.println("Connection failed.");
  conn.close();  
}

void array2String(byte *arr, byte len, char buff[]){
  for(byte i=0; i<len; i++){
    byte nib1=(arr[i]>>4) & 0x0f;
    byte nib2=(arr[i]>>0) & 0x0f;
    buff[i*2+0]=nib1<0x0a ? '0'+nib1 : 'A'+nib1 - 0x0a;
    buff[i*2+1]=nib2<0x0a ? '0'+nib2 : 'A'+nib2 - 0x0a;    
  }
  buff[len*2+0]='\0';
}