Part-16 JAVA-Fees Management System | Inserting data into 'fees_details' table | Unique Developer|
derby query to create fees_details table
========================================
CREATE TABLE fees_details (
reciept_no INT ,
student_name VARCHAR(255),
roll_no VARCHAR(255),
payment_mode VARCHAR(255),
cheque_no VARCHAR(255),
bank_name VARCHAR(255),
dd_no VARCHAR(255),
course_name VARCHAR(255),
gstin VARCHAR(255),
total_amount FLOAT,
date DATE,
amount FLOAT,
cgst FLOAT,
sgst FLOAT,
total_in_words VARCHAR(255),
remark VARCHAR(255),
year1 INT,
year2 INT,
PRIMARY KEY (reciept_no)
);
MySQL query to create fees_details table
=============================================
CREATE TABLE `fees_details` (
`reciept_no` int(11) NOT NULL DEFAULT 0,
`student_name` varchar(50) DEFAULT NULL,
`payment_mode` char(50) DEFAULT NULL,
`cheque_no` int(11) DEFAULT NULL,
`bank_name` varchar(50) DEFAULT NULL,
`dd_no` int(11) DEFAULT NULL,
`courses` varchar(100) DEFAULT NULL,
`gstin` varchar(50) DEFAULT NULL,
`total_amount` float DEFAULT NULL,
`date` date DEFAULT NULL,
`amount` int(11) DEFAULT NULL,
`cgst` float DEFAULT NULL,
`sgst` float DEFAULT NULL,
`total_in_words` varchar(200) DEFAULT NULL,
`remark` varchar(500) DEFAULT NULL,
`year1` int(11) DEFAULT NULL,
`year2` int(11) DEFAULT NULL,
PRIMARY KEY (`reciept_no`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Fees management Systems
Part 1 : • Fees Management System in java | Comp...
Part 2 : • Part-2 Fees Management System | How ...
Part 3 : • Part-3 Fees Management System | How ...
Part 4: • Part-4 Fees Management System | How ...
Part 5: • Part-5 Fees Management System | Logi...
part 6: • Part-6 JAVA-Fees Management System | ...
part 7: • Part-7 JAVA-Fees Management System | ...
part 8: • Part-8 JAVA-Fees Management System |D...
part 9: • Part-9 JAVA-Fees Management System |D...
part 10: • Part-10 JAVA-Fees Management System |...
part 11: • Part-11 JAVA-Fees Management System |...
part 12: • Part-12 JAVA-Fees Management System |...
part 13: • Part-14 JAVA-Fees Management System |...
part 14: • Part-14 JAVA-Fees Management System |...
part 15 : • Part-15 JAVA-Fees Management System |...
Download Icons used in the project from Below Link :
https://drive.google.com/file/d/1EANh...
How To Download JDateChooser :
• How to add JCalender , JDateChooser ,...
Download NumberToWordConverter.java file (watch video 13)
https://drive.google.com/file/d/1JmnY...
In this video, I showed you how to create fees_details table in derby and MySQL
thanks for watching
Fees Management System complete project
Java Swing Modern UI
Learn how to design a modern java UI design from scratch using Netbeans
Subscribe to the channel for more videos
validation in java
swing validation
Java Programming
Java Swing Basics
Java Tutorials
Java UI Design
JavaFX FXML Basics
JavaFX Scene Builder
JavaFX Netbeans
java complete projects
Netbeans Project
Watch video Part-16 JAVA-Fees Management System | Inserting data into 'fees_details' table | Unique Developer| online without registration, duration hours minute second in high quality. This video was added by user Unique Developer 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,599 once and liked it 29 people.