RFID Based Attendance System

Replies

• 

  Harshad Italiya

  As i told you there is no need to use Microcontroller you can directly get RFID reader which sends data to your PC's USB port or SERIAL port and from that data you can proceed.
• 

  PraveenKumar Purushothaman

  I have done a similar application. 😀 Just an RFID Reader, a Tag and the software to automate the process would do. We tied up with HID and completed. 😀
• 

  Harshad Italiya

  Praveen-Kumar

  I have done a similar application. 😀 Just an RFID Reader, a Tag and the software to automate the process would do. We tied up with HID and completed. 😀

  Can you please post the details of that RFID reader you have used? It operating on HF or UHF?
• 

  PraveenKumar Purushothaman

  godfather

  Can you please post the details of that RFID reader you have used? It operating on HF or UHF?

  UHF! It is the same one which uses the electromagnetic lock for the doors. The glass doors! 😀
• 

  manishks

  what is rfid?????
• 

  PraveenKumar Purushothaman

  musicfreakmandy

  what is rfid?????

  Radio Frequency Identification
• 

  sidworli

  I went to GALA stores at Grant Road it cost something 1900rs RFID reader. Will i get cheaper than this one if yes then which stores ? else i can buy this one
• 

  sidworli

  how many bytes data does RFID reader can send to the system ? 😀 So that i could write a program in java ........and establish connectivity with database
• 

  Harshad Italiya

  I wonder how they are giving at such low price rate. We used to buy UHF Class Gen2 reader. And its cost is around 25K INR, Before purchasing get the full specification of reader.
  
  And second as you asked for data bytes that's depend on which Standard RFID you're going to use.
• 

  sidworli

  OMG! 25k hmm thanx for info...........😀
  

  Praveen-Kumar

  Radio Frequency Identification

  can u tell me how to read data frm serial port using java
• 

  PraveenKumar Purushothaman

  sidworli

  OMG! 25k hmm thanx for info...........😀
  can u tell me how to read data frm serial port using java

  Use hyperterminal! 😀
• 

  sidworli

  hey RFID has 16 digit unique number right.....so can we get that no. of our own choice ....................I am asking this because i m finding difficulty in my database .........when a student will show the rfid card to the reader it will accept the data and store it in a table but we hav 9 classes in my colg so the16 digit no. should go to that class table but it will be a slow process can any one giv me idea about the database [how do i make separate each student to individual class ? thank you
• 

  PraveenKumar Purushothaman

  sidworli

  hey RFID has 16 digit unique number right.....so can we get that no. of our own choice ....................I am asking this because i m finding difficulty in my database .........when a student will show the rfid card to the reader it will accept the data and store it in a table but we hav 9 classes in my colg so the16 digit no. should go to that class table but it will be a slow process can any one giv me idea about the database [how do i make separate each student to individual class ? thank you

  If you are using MySQL or Oracle, you can use joins and stuff right?
• 

  Harshad Italiya

  From that 32 bytes you can write some bytes that's called Tag number. You have to use write command from reader so it'll write that Tag number into Tag memory.
• 

  sidworli

  What are the steps to connect java and MySQL. I am aware of the java code but please can any one tell me the steps (control panel > Administrator tools > Data Sources (ODBC) > and after that how to add and what to add )and further procedure .......thank you
• 

  PraveenKumar Purushothaman

  You don't use ODBC to connect MySQL Server. You directly give the connection URL this way:

  jdbc:mysql://localhost/test?user=scott&password=tiger

• 

  PraveenKumar Purushothaman

  To connect to the MySQL server, register the JDBC driver you plan to use, then invoke its getConnection() method. The following short program, Connect.java, shows how to connect to and disconnect from a server running on the local host. It accesses a database named test, using a MySQL account with a user name and password of testuser and testpass:
  

    import java.sql.*;
   
    public class Connect
    {
        public static void main (String[] args)
        {
            Connection conn = null;
   
            try
            {
                String userName = "testuser";
                String password = "testpass";
                String url = "jdbc:mysql://localhost/test";
                Class.forName ("com.mysql.jdbc.Driver").newInstance ();
                conn = DriverManager.getConnection (url, userName, password);
                System.out.println ("Database connection established");
            }
            catch (Exception e)
            {
                System.err.println ("Cannot connect to database server");
            }
            finally
            {
                if (conn != null)
                {
                    try
                    {
                        conn.close ();
                        System.out.println ("Database connection terminated");
                    }
                    catch (Exception e) { /* ignore close errors */ }
                }
            }
        }
    }

• 

  PraveenKumar Purushothaman

  Compile Connect.java to produce a class file Connect.class that contains executable Java code:
  

    % javac Connect.java

  Then invoke the class file as follows and it should connect to and disconnect from your MySQL server:
  

    % java Connect
    Database connection established
    Database connection terminated

  If you have trouble compiling Connect.java, double check that you have a Java Software Development Kit installed and make sure that the MySQL Connector/J driver is listed in your CLASSPATH environment variable.
  The arguments to getConnection() are the connection URL and the user name and password of a MySQL account. As illustrated by Connect.java, JDBC URLs for MySQL consist of jdbc:mysql:// followed by the name of the MySQL server host and the database name. An alternate syntax for specifying the user and password is to add them as parameters to the end of the connection URL:
  

  jdbc:mysql://localhost/test?user=testuser&password=testpass

  When you specify a URL using this second format, getConnection() requires only one argument. For example, the code for connecting to the MySQL server in Connect.java could have been written like this:
  

    String userName = "testuser";
    String password = "testpass";
    String url = "jdbc:mysql://localhost/test?user="
                    + userName
                    + "&password="
                    + password;
    Class.forName ("com.mysql.jdbc.Driver").newInstance ();
    conn = DriverManager.getConnection (url);

  getConnect() returns a Connection object that may be used to interact with MySQL by issuing queries and retrieving their results. (The next section describes how to do this.) When you're done with the connection, invoke its close() method to disconnect from the MySQL server.
  
  To increase the portability of your applications, you can store the connection parameters (host, database, user name, and password) in a Java properties file and read the properties at runtime. Then they need not be listed in the program itself. This allows you to change the server to which the program connects by editing the properties file, rather than by having to recompile the program.
• 

  sidworli

  Praveen-Kumar

  Compile Connect.java to produce a class file Connect.class that contains executable Java code:
  

    % javac Connect.java

  Then invoke the class file as follows and it should connect to and disconnect from your MySQL server:
  

    % java Connect
    Database connection established
    Database connection terminated

  If you have trouble compiling Connect.java, double check that you have a Java Software Development Kit installed and make sure that the MySQL Connector/J driver is listed in your CLASSPATH environment variable.
  The arguments to getConnection() are the connection URL and the user name and password of a MySQL account. As illustrated by Connect.java, JDBC URLs for MySQL consist of jdbc:mysql:// followed by the name of the MySQL server host and the database name. An alternate syntax for specifying the user and password is to add them as parameters to the end of the connection URL:
  

  jdbc:mysql://localhost/test?user=testuser&password=testpass

  When you specify a URL using this second format, getConnection() requires only one argument. For example, the code for connecting to the MySQL server in Connect.java could have been written like this:
  

    String userName = "testuser";
    String password = "testpass";
    String url = "jdbc:mysql://localhost/test?user="
                    + userName
                    + "&password="
                    + password;
    Class.forName ("com.mysql.jdbc.Driver").newInstance ();
    conn = DriverManager.getConnection (url);

  getConnect() returns a Connection object that may be used to interact with MySQL by issuing queries and retrieving their results. (The next section describes how to do this.) When you're done with the connection, invoke its close() method to disconnect from the MySQL server.
  
  To increase the portability of your applications, you can store the connection parameters (host, database, user name, and password) in a Java properties file and read the properties at runtime. Then they need not be listed in the program itself. This allows you to change the server to which the program connects by editing the properties file, rather than by having to recompile the program.

• 

  sidworli

  hey really thanx a lot........................u explained so much really thanks
• 

  PraveenKumar Purushothaman

  sidworli

  hey really thanx a lot........................u explained so much really thanks

  Thankz... 😀