//package?stu;//??刪除信息
import??java.awt.*;
import??javax.swing.*;
import??javax.swing.tree.*;
import??javax.swing.event.*;
import??java.awt.event.*;
import??java.io.*;
import??java.sql.*;

class?Dsdialog?extends?JDialog?implements?ActionListener{
	
	JLabel?l1=new?JLabel（“要刪除的記錄在查詢表中的序列號：“）;
	object?items[]=new?object[Pane1.N+1];
	JComboBox?cb;
	Jframe?f;
	JButton?bs=new?JButton（“刪除“）;
	JButton?bt=new?JButton（“退出“）;
	JPanel?p1=new?JPanel（）;
	JPanel?pl1=new?JPanel（）;
	JPanel?pl2=new?JPanel（）;
	JPanel?p2=new?JPanel?（）;
	JPanel?p21=new?JPanel?（）;
	JPanel?p22=new?JPanel（）;
	JButton?bs2=new?JButton（“繼續?“）;
	JButton?bt2=new?JButton（“退出“）;
	
	JLabel?l2=new?JLabel（“已清除數據庫中該記錄。“）;
	CardLayout?car=new?CardLayout（）;
	Container?con=getContentPane（）;
	
	Dsdialog（Jframe?F?String?s）{
		super（）;
		for（int?i=1;?i<=Pane1.N;?i++）{
			items[i]=i;
			
	?????}
	?????
	???items[0]=“所有“;??
	???setSize（400?115）;
	???setLocation（300?250）;
	???//settitle（“刪除信息“）;
	???
	???con.setLayout（car）;
??	???cb=new?JComboBox（items）;
???????p1.setLayout（new?GridLayout（21））;
???????pl1.add（l1）;
???????pl1.add（cb）;
???????p1.add（pl1）;
???????bs.addActionListener（this）;
???????bt.addActionListener（this）;
???????bs2.addActionListener（this）;
???????bt2.addActionListener（this）;
???????pl2.add（bs）;
???????pl2.add（bt）;
???????p1.add（pl2）;
???????con.add（“1“?p1）;
???????p2.setLayout（new?GridLayout（21））;
???????p21.add（l2）;
???????p22.add（bs2）;
???????p2.add（bt2）;
???????p2.add（p21）;
???????p2.add（p22）;
???????con.add（“2“?p2）;
???????setVisible（true）;
???????
???????	???
	}
	
	public?void?actionPerformed（ActionEvent?e?）{
		
		if（e.getSource（）==bs）{
			
			String?temp;
			
			try{
				int?n=cb.getSelectedIndex（）;
				
				if（n>0）{
					
					temp=“DELETE??FROM?stuTable?WHERE??Num=‘“+Pane1.a[n-1][3]+“‘“;
					Stu.conn=DriverManager.getConnection（“jdbc:odbc:stu“?“stu“?““）;
????????????????????Stu.stmt.executeUpdate（temp）;
????????????????????
????????????????????Stu.conn.close（）;
????????????????????
????????????????????					
					
					
					}
					
					else{
						for（int?i=0;?i							
							temp=“DELETE?FROM?stuTable?WHERE??Num=‘“+Pane1.a[i][3]+“‘“;
							Stu.conn=DriverManager.getConnection（“jdbc:odbc:stu““stu“?““）;
							Stu.stmt.executeUpdate（temp）;
							Stu.conn.close（）;
							
							
							}
						
						
						}
						
						
						car.show（con?“2“）;
						
				
				
				}
				
				catch（SQLException?ee?）{
					
					System.out.println（ee.toString（））;
					
				}
				
			
			}
			
			if（e.getSource（）==bt）{
				
				this.dispose（）;
			}
			
			if（e.getSource（）==bs2）{
				
				car.show（con?“1“）;
			}
			
			if（e.getSource（）==bt2）{
				
				this.dispose（）;
			}
			
			
		
		}
	
	
	}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????3923??2008-05-29?10:28??學生信息管理系統\Controllsystem\Dsdialog.class

?????文件???????2909??2008-05-20?23:51??學生信息管理系統\Controllsystem\Dsdialog.java

?????文件???????2804??2008-05-29?10:27??學生信息管理系統\Controllsystem\Dxdialog.class

?????文件???????1864??2008-05-20?23:51??學生信息管理系統\Controllsystem\Dxdialog.java

?????文件???????7115??2008-05-29?10:27??學生信息管理系統\Controllsystem\Pane1.class

?????文件???????7389??2008-05-22?15:10??學生信息管理系統\Controllsystem\Pane1.java

?????文件???????6243??2008-05-29?10:28??學生信息管理系統\Controllsystem\Pane2.class

?????文件???????5726??2008-05-20?23:51??學生信息管理系統\Controllsystem\Pane2.java

?????文件???????5028??2008-05-29?10:27??學生信息管理系統\Controllsystem\Pane3.class

?????文件???????4093??2008-05-20?23:51??學生信息管理系統\Controllsystem\Pane3.java

?????文件????????872??2008-05-29?17:23??學生信息管理系統\Controllsystem\Stu$Pane.class

?????文件???????3495??2008-05-29?17:23??學生信息管理系統\Controllsystem\Stu.class

?????文件???????3038??2008-05-29?17:23??學生信息管理系統\Controllsystem\Stu.java

?????目錄??????????0??2008-05-31?15:39??學生信息管理系統\Controllsystem

?????目錄??????????0??2008-05-31?15:39??學生信息管理系統

-----------?---------??----------?-----??----

????????????????54499????????????????????15