Criminal Record Management System — Java

A Java Swing desktop application for law enforcement agencies to maintain criminal records. It supports role-based access (Admin / User), offender registration with photo upload, record viewing, editing, and search — all backed by a MySQL/MariaDB database.

---

Features

• Role-based access: Admin login and public/user sign-up
• Register new criminal records including: name, gender, age, nationality, offense, file number, bail status, jail term, and photo (stored as BLOB)
• View all criminal records in a tabular list
• Edit existing records
• Admin panel to manage registered admin accounts
• Dedicated sign-in, sign-up, and home screens
• Full SQL dumps for both register and admin tables

---

Tech Stack

Component	Technology
Language	Java SE
GUI Framework	Java Swing (javax.swing.JFrame, JPanel, JTable)
Database	MySQL / MariaDB (crimedetection DB)
DB Connectivity	JDBC
Build Tool	Apache Ant (NetBeans project)
IDE	Apache NetBeans

---

Database Schema

Database name: crimedetection

Table	Key Columns
register	fullnames, gender, age, nationality, offense, fileNumber, bail, jail, image (LONGBLOB)
admin	id, position, username, password

---

Getting Started

Prerequisites

• JDK 8+
• MySQL or MariaDB server
• Apache NetBeans IDE (recommended)

1. Import the database

mysql -u root -p < sql/register.sql
mysql -u root -p < sql/admin.sql

2. Configure the JDBC connection

Edit src/dbaseConnx.java to set your database host, username, and password.

3. Build and run

Via NetBeans:

1. Open the project in NetBeans
2. Clean and Build the project
3. Click Run

Via Ant CLI:

ant clean build run

---

File Structure

├── src/
│   ├── Homepage.java / .form         # Application home screen
│   ├── HomeSignIn.java / .form       # Admin sign-in
│   ├── HomeSignup.java / .form       # User sign-up
│   ├── Register.java / .form         # Criminal record registration
│   ├── ShowRecords.java / .form      # View all records
│   ├── SEdit.java / .form            # Edit a record
│   ├── HomeView.java / .form         # View record detail
│   ├── dbaseConnx.java               # JDBC database connector
│   └── images/                       # UI images and avatars
├── sql/
│   ├── register.sql                  # Criminal records table dump
│   └── admin.sql                     # Admin accounts table dump
├── build.xml                         # Ant build script
└── nbproject/                        # NetBeans project metadata

---

Screenshots

Add screenshots of the homepage, registration form, and records table here.

---

License

This project is licensed under the MIT License.