Bouquet Shop Management System is a desktop-based Java application developed using Java Swing for the user interface and Microsoft Access as the backend database. It automates bouquet shop operations such as user registration, login, bouquet selection, billing, and payment processing using multiple payment modes.
The system simplifies sales management for bouquet shops by providing an interactive GUI. Users can browse bouquets, add them to their cart, and complete secure payments. It enhances both customer experience and administrative efficiency.
| Component | Technology |
|---|---|
| Frontend | Java Swing |
| Backend | Microsoft Access |
| Database Connectivity | JDBC (UCanAccess) |
| Language | Java (JDK 8+) |
| IDE | Eclipse / IntelliJ / NetBeans |
| OS | Windows 10 / 11 |
Authenticates users with credentials stored in the database.
Allows new users to register securely using name, email, mobile number, and password.
Displays available bouquets (Tulip, Rose, Lily, Mixed) and allows adding to cart.
Shows selected bouquets, total cost, and allows modifying cart items.
Handles multiple payment modes such as UPI, QR Code, Net Banking, and Cards.
| Field | Type | Description | |——–|——|————-| | first | Text | First Name | | last | Text | Last Name | | mobile | Number | Mobile Number | | email | Text | Email Address | | password | Text | Password | | cpassword | Text | Confirm Password | | address | Text | Address |
| Field | Type | Description | |——–|——|————-| | proname | Text | Bouquet Name | | proprice | Number | Price |
Software:
Hardware:
Place bouquetshop.accdb inside a database/ folder.
Download and add the following .jar files to lib/:
javac -cp "lib/*" -d build src/*.java
java -cp "build:lib/*" login
Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
Connection conn = DriverManager.getConnection("jdbc:ucanaccess://D://Javaproject//Bouquetshop//bouquetshop.accdb");
String sql = "SELECT * FROM user WHERE mobile='" + mobile + "' AND password='" + pass + "'";
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
if(rs.next()) {
JOptionPane.showMessageDialog(null, "Login Successful!");
} else {
JOptionPane.showMessageDialog(null, "Invalid Credentials!");
}
PreparedStatement ps = conn.prepareStatement("INSERT INTO product (proname, proprice) VALUES (?, ?)");
ps.setString(1, "Rose Bouquet");
ps.setDouble(2, 750.00);
ps.executeUpdate();
The Bouquet Shop Management System automates bouquet sales and simplifies operations. It’s an ideal solution for small flower businesses looking to transition from manual to digital management.
Department of Computer Science and Applications
The Gandhigram Rural Institute (Deemed to be University)
May 2024
This project is created for academic purposes and distributed under the MIT License.