allstudentnameframe.java

学生成绩管理系统

import javax.swing.*;
import java.sql.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.tree.*;
public class AllStudentNameFrame extends JFrame {

	
	public AllStudentNameFrame(Connection connect){
		
		
		setTitle("AllStudentNameFrame");
		 con=connect;
		///////////////////////////////////
		 
		 try{
				
				
				DefaultMutableTreeNode top=new DefaultMutableTreeNode("学生信息");
				Statement stmt = con.createStatement();
				ResultSet rs = stmt.executeQuery("select * from  class");
				//stmt.close();
				String[] a=new String[100];
				String[] b=new String[100];
				int i=0;
				while(rs.next()){
					a[i]=rs.getString(1);
					b[i]=rs.getString(2);
					i++;
				}
				//stmt.close();
				int len=a.length;
				i=0;
				while(i<len){
					 Statement st=con.createStatement();
					 String sql="select * from student where cno= '"+a[i]+"'";
					 ResultSet rs1=st.executeQuery(sql);
					
					 DefaultMutableTreeNode node=new DefaultMutableTreeNode(b[i]);
					 top.add(node);
					 while(rs1.next()){
					  DefaultMutableTreeNode leaf=new DefaultMutableTreeNode(rs1.getString(1)+","+rs1.getString(2)+","+rs1.getString(3));
	                     node.add(leaf);    
					 }
					i++;
				}
				
			  tree=new JTree(top);
			js=new JScrollPane(tree);
	        }catch(SQLException e1){
	        	JOptionPane.showMessageDialog(null, e1.getMessage());
	        }
		 ////////////////////////////////////
		 label=new JLabel(" For all the students");
		 Container c=getContentPane();
		 c.setLayout(new BorderLayout());
		 c.add(label,BorderLayout.NORTH);
		 c.add(js,BorderLayout.CENTER);
		
	}
	
	
	void showValues(){
		

	}

	
	JTree tree;
	JLabel label;
	JButton jb;
	JScrollPane js;             
	Connection con;
}