I am doing a project for a hospital near by. I am using Java, Hibernate and SQL server 2008. In an occasion when I am dealing with the clinical lab module I have come across a problem.
I made a JTable which contain the names of patients who ordered the test in reception. Consider the situation where there are more than 1 computer at the sample collection bay. When a technician or a lab assistant from the lab click the name of a patient (when he/she tries to attend a patient) from the JTable then the name should be removed from the JTable from all the computers in the sample collection bay(because if someone is attending a patient then the name should not be shown to others, so they can attend other patient). And also if a patient comes to reception and register himself for a test, then the name should be shown in the computer of sample collection bay(ie the JTable of all the system should be updated when the data is registered to database).
I heard about the function fireTableDataChanged() in java to use in this instance. My doubt is if a technician clicks a name, I am sure that his table will be updated through this function. But is it possible to repaint all the Jtables in all the system when a change to database is made from a system(ie is it possible to remove the name from all the other systems when a name is clicked from a system).
In another occasion I used firebird, because it itself has the functionality as I said. But here it is not possible because 80% of the project is in Microsoft SQL server. Can anyone suggest me a method. Thanks in advance.