RFID Based Attendance System

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.

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. 😀

Praveen-KumarI 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?

godfatherCan 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! 😀

what is rfid?????

musicfreakmandywhat is rfid?????

Radio Frequency Identification

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

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

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.

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

Praveen-KumarRadio Frequency Identification

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

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

Use hyperterminal! 😀

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

sidworlihey 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?

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.

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

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

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 */ }
              }
          }
      }
  }

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.

Praveen-KumarCompile 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.

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

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

Thankz... 😀