Programming Forums > Application Development > Java

hemanth.balaji · Dec 23rd, 2006, 12:52 PM

After the user logs in the "Student Management System" using "system" and "password" you get to view Student details. Also you get to choose a Student to delete or modify from the Combo box on the right hand top. When I select a student and delete using the delete button it gets deleted in the databse but how do i autorefresh the same in the Select student combobox...

I was not able to implement it...The code needs to be implemented in the ButtonHandler Classs. The snippet is as shown below

(Toggle Plain Text)

else if(s.equals("DELETE")){
						int returnValue  = JOptionPane.showConfirmDialog(null, "Delete Confirmation", 
											"Are you sure you wanna delete", JOptionPane.YES_NO_OPTION);
						if(returnValue == JOptionPane.YES_OPTION){
							selectedStudentname = jcmbStudentName.getSelectedItem().toString();
							String student_regNo= selectedStudentname.substring(0,7);
		  					deleteStudentRecord(student_regNo);
/*			JCOMBOBOX Refreshing Student Combo logic not implemented yet				
 * 			jcmbStudentName.addItem("Select Student Name");
						    PopulateStudentCombo();*/
						}

Note: PopulateStudentCombo() is a function used to populate the ComboBox.

The entire code for the above project is available at

http://www.java-swing-tutorial.com/student.zip

Database Created in Oracle

(Toggle Plain Text)

create table student_details (
	reg_no VARCHAR(30),
	name	VARCHAR(30),
	address	VARCHAR(50),
	fname	VARCHAR(30),
	dob	VARCHAR(30),
	phone	INTEGER,
	gender	VARCHAR(2),
	year	VARCHAR(30),
	course	VARCHAR(30),
	degree	INTEGER,
	charcert INTEGER,
	ncccert	INTEGER
);

create table student_login (
	login VARCHAR(30),
	password VARCHAR(30)
);

insert into student_login values('system', 'password');

These are the Database Specific settigns for JDBC

(Toggle Plain Text)

static String userid="scott", password = "tiger";
static String url = "jdbc:odbc:bob";

Regards,
Hemanth
Beginner Java Tutorial

BinarySurfer · Dec 23rd, 2006, 7:11 PM

I finished a student database a week ago. I made a method that loaded the students onto a JList. When a student was deleted, it ran the method after the deletion was completed, basically refreshing the list being viewed. Do keep in mind to not forget to erase contents on the list before refreshing (depending on how you do it of course).
No offense, but I will never trust another programmer enough to download their code, sorry. I would look back on how you are loading the data with the "PopulateStudentCombo()". Do you have it broken down to a decent number of operations because if you did it right, it should be working. I mean, there could be something interfering in that class. Another possiblility is in your "deleteStudentRecord(student_regNo)". Are you sure the record is deleted from the database? I know it sounds stupid, but you never know.

Game_Ender · Dec 24th, 2006, 1:08 AM

How is downloading a bunch of text going to hurt you computer? You do run Linux, Mac, or Windows with a virus scanner right? This just looks it was copied right from a homework assignment.

BinarySurfer · Dec 24th, 2006, 8:49 AM

I don't want to risk it. Is that such a bad thing? I care for my computer and I find it silly to make a risk without any return of benefit or profit. I know it should be text, but that doesn't mean it is. You know as well as I know that antiviruses are not perfect and all knowing, so how would it pick up on a good custom made virus? I'm just a very cautious person.
Besides, I think the help was sufficient. If he or she wants more, I'll be more than happy to comply.

Dec 23rd, 2006, 12:52 PM	#1
hemanth.balaji Programmer Join Date: May 2005 Posts: 54 Rep Power: 0	Automatic Refresh of JComboBox Implementation After the user logs in the "Student Management System" using "system" and "password" you get to view Student details. Also you get to choose a Student to delete or modify from the Combo box on the right hand top. When I select a student and delete using the delete button it gets deleted in the databse but how do i autorefresh the same in the Select student combobox... I was not able to implement it...The code needs to be implemented in the ButtonHandler Classs. The snippet is as shown below (Toggle Plain Text) else if(s.equals("DELETE")){ int returnValue = JOptionPane.showConfirmDialog(null, "Delete Confirmation", "Are you sure you wanna delete", JOptionPane.YES_NO_OPTION); if(returnValue == JOptionPane.YES_OPTION){ selectedStudentname = jcmbStudentName.getSelectedItem().toString(); String student_regNo= selectedStudentname.substring(0,7); deleteStudentRecord(student_regNo); /* JCOMBOBOX Refreshing Student Combo logic not implemented yet * jcmbStudentName.addItem("Select Student Name"); PopulateStudentCombo();/ } else if(s.equals("DELETE")){ int returnValue = JOptionPane.showConfirmDialog(null, "Delete Confirmation", "Are you sure you wanna delete", JOptionPane.YES_NO_OPTION); if(returnValue == JOptionPane.YES_OPTION){ selectedStudentname = jcmbStudentName.getSelectedItem().toString(); String student_regNo= selectedStudentname.substring(0,7); deleteStudentRecord(student_regNo); / JCOMBOBOX Refreshing Student Combo logic not implemented yet * jcmbStudentName.addItem("Select Student Name"); PopulateStudentCombo();/ } Note: PopulateStudentCombo() is a function used to populate the ComboBox. The entire code for the above project is available at http://www.java-swing-tutorial.com/student.zip Database Created in Oracle* (Toggle Plain Text) create table student_details ( reg_no VARCHAR(30), name VARCHAR(30), address VARCHAR(50), fname VARCHAR(30), dob VARCHAR(30), phone INTEGER, gender VARCHAR(2), year VARCHAR(30), course VARCHAR(30), degree INTEGER, charcert INTEGER, ncccert INTEGER ); create table student_login ( login VARCHAR(30), password VARCHAR(30) ); insert into student_login values('system', 'password'); create table student_details ( reg_no VARCHAR(30), name VARCHAR(30), address VARCHAR(50), fname VARCHAR(30), dob VARCHAR(30), phone INTEGER, gender VARCHAR(2), year VARCHAR(30), course VARCHAR(30), degree INTEGER, charcert INTEGER, ncccert INTEGER ); create table student_login ( login VARCHAR(30), password VARCHAR(30) ); insert into student_login values('system', 'password'); These are the Database Specific settigns for JDBC (Toggle Plain Text) static String userid="scott", password = "tiger"; static String url = "jdbc:odbc:bob"; static String userid="scott", password = "tiger"; static String url = "jdbc:odbc:bob"; Regards, Hemanth Beginner Java Tutorial

Dec 23rd, 2006, 7:11 PM	#2
BinarySurfer Programmer Join Date: Dec 2006 Posts: 53 Rep Power: 0	I finished a student database a week ago. I made a method that loaded the students onto a JList. When a student was deleted, it ran the method after the deletion was completed, basically refreshing the list being viewed. Do keep in mind to not forget to erase contents on the list before refreshing (depending on how you do it of course). No offense, but I will never trust another programmer enough to download their code, sorry. I would look back on how you are loading the data with the "PopulateStudentCombo()". Do you have it broken down to a decent number of operations because if you did it right, it should be working. I mean, there could be something interfering in that class. Another possiblility is in your "deleteStudentRecord(student_regNo)". Are you sure the record is deleted from the database? I know it sounds stupid, but you never know. Last edited by BinarySurfer; Dec 23rd, 2006 at 7:25 PM. Reason: One more detail

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PHP sessions/ page refresh???	ktsirig	PHP	2	Jun 1st, 2006 4:16 PM
implementation of cpuid and graph in my benchmark programm	chorijan	C++	0	Sep 7th, 2005 6:27 AM

Dec 24th, 2006, 1:08 AM	#3
Game_Ender Professional Programmer Join Date: May 2006 Location: Maryland, USA Posts: 306 Rep Power: 3	How is downloading a bunch of text going to hurt you computer? You do run Linux, Mac, or Windows with a virus scanner right? This just looks it was copied right from a homework assignment.

Dec 24th, 2006, 8:49 AM	#4
BinarySurfer Programmer Join Date: Dec 2006 Posts: 53 Rep Power: 0	I don't want to risk it. Is that such a bad thing? I care for my computer and I find it silly to make a risk without any return of benefit or profit. I know it should be text, but that doesn't mean it is. You know as well as I know that antiviruses are not perfect and all knowing, so how would it pick up on a good custom made virus? I'm just a very cautious person. Besides, I think the help was sufficient. If he or she wants more, I'll be more than happy to comply.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Programming Forums > Application Development > Java

Automatic Refresh of JComboBox Implementation