Colleges track lab equipment on paper and in scattered Excel files. Identical items cannot be told apart, nobody knows who has which projector or kit today, vendor dues and repair costs are unknown, transfers are not recorded and physical verification takes days, with missing items never followed up.
AssetTag – Lab Equipment Asset Register Java project is a Java desktop application that replaces the handwritten dead-stock register of college laboratories. Every physical item - desktop, laptop, projector, oscilloscope, microcontroller kit, science instrument, UPS or furniture - gets a unique asset tag (for example AT-LAP-0009) that is printed as a QR code sticker. The system records the complete life of each item: purchase with GST and partial vendor payments, issue and return to faculty and students with due dates and late fine, repair complaints, lab-to- lab transfers with admin approval, yearly physical verification and finally condemnation, with straight-line depreciation giving the book value on any date. Three roles work on one MySQL database over the college LAN.
How it works
- Store keeper enters a vendor invoice with item lines; one asset with its own tag is created per unit and QR labels are printed
- Lab assistant issues portable items to faculty / students (max 2 per student) and records the return with condition; late fine is calculated
- Faults are raised as complaints; the store keeper sends the item to a vendor and closes it as Fixed or Not repairable
- Transfers and condemnations go to the admin for approval; approved transfers print a gate pass
- Twice a year each lab is verified by scanning tags; missing and damaged items are reported. Dashboards and reports show the result
Users
- Admin – Dashboard, asset register, purchases, issue / return, repairs, transfer approval, verification, condemnation approval, labs, categories, vendors, members, users, reports, alerts, activity log, settings, backup / restore
- Lab Assistant – My-lab dashboard, lab assets & QR labels, issue / return with slip and reminder, members, complaints, transfer request, physical verification, lab reports
- Store Keeper – Store dashboard, asset register & CSV import, purchase entry, vendor payments & voucher, repair updates, condemnation proposal, vendors, categories, reports
Highlights
- 3 roles, 42 screens, 15 tables, 103 Java classes, 8 reports (PDF / CSV / Print), 5 printouts (QR labels, issue slip, payment voucher, gate pass, verification sheet)
- Each item identified by tag and QR; complete movement history
- Correct asset status at every step because related changes run in one transaction
- Lab-wise access control and full activity log
- Audit-ready reports: register with book value, purchases, dues, repairs, discrepancies
- Sample data and demo logins so every screen has data on the first run
What you get
- Complete Java source code (Eclipse project, runs in NetBeans / IntelliJ too)
- MySQL database SQL file with sample data
- Project report (55 pages) with all diagrams, abstract, project explanation with viva questions
- Setup guide and README with a 10-minute demo script
- Setup help from Ananda Technologies
Who can use this project
BCA and BSc (CS / IT) final year students who want a Java Swing MySQL project with source code that is easy to explain in viva and has enough content for 3 students and 3 college demos.
Frequently asked questions
- Does it need internet? No, it is a desktop application and works fully offline.
- Which IDE do I need? Eclipse is used in the setup guide; NetBeans and IntelliJ also open it because the screens are plain Swing code.
- Can 3 students share this project? Yes, the README gives a 3-student split and a 3-demo plan.
- Is the report editable? Yes, the report is given in Word and PDF.