informationupdate.java

用java刚刚写了不久的学生管理系统

		//--------------------------------------ModifyPane-----------------------------------------
		public void ModifyPane() {
			System.out.println("-----------------------------------------ModifyStudent()-InformationPane()");
			String title[] = {"学         号","姓         名","性         别","年         龄",
								  "专业方向","所在系名","所在学院"};
	 		Container container = this.getContentPane();
 	 		container.setLayout(new BorderLayout());
	 		group.add(rabSexM);
 	 		group.add(rabSexF);		
 			JPanel p[] = new JPanel[8];
 	 		for(int i = 1;i < 8;i++){
 	 			p[i] = new JPanel(new FlowLayout(FlowLayout.LEFT));
 	 		}
 			for(int i = 1;i < 8;i++){
 				p[i].add(new JLabel(title[i - 1]));		
 			}
 			p[1].add(txtNumber);
 			p[2].add(txtName);
 			p[3].add(rabSexM);
 			p[3].add(rabSexF);
 			p[4].add(txtAge);
 			p[5].add(txtSpeciality);
 			p[6].add(txtDepartment);
 			p[7].add(txtAcademy);
 			JPanel jpCenterPane = new JPanel();
			jpCenterPane.setLayout(new GridLayout(8,1));
 			for(int i = 1;i < 8;i++){
 				jpCenterPane.add(p[i]);	
 			}
    		JPanel jpTopPane = new JPanel();
    		JPanel jpTopPane1 = new JPanel();
    		JPanel jpTopPane2 = new JPanel();
    		JPanel jpTopPane3 = new JPanel();
    		JPanel jpTopPane4 = new JPanel();
    		JPanel jpTopPane5 = new JPanel();
     		JPanel jpTopPane6 = new JPanel();
     		JPanel jpTopPane7 = new JPanel();
     		JPanel jpTopPane8 = new JPanel();
     		JPanel jpTopPane9 = new JPanel();
    		jpTopPane.setLayout(new GridLayout(10,1));
    		jpTopPane.add(jpTopPane1);
    		jpTopPane.add(jpTopPane2);
    		jpTopPane.add(jpTopPane3);
    		jpTopPane.add(jpTopPane4);
    		jpTopPane.add(jpTopPane5);
    		jpTopPane.add(jpTopPane6);
    		jpTopPane.add(jpTopPane7);
    	   	jpTopPane.add(jpTopPane8);
    		jpTopPane.add(jpTopPane9);	
 			JPanel jpBottomPane1 = new JPanel();
 			JPanel jpBottomPane2 = new JPanel();
 			JPanel jpBottomPane = new JPanel();
 			jpBottomPane1 = new JPanel(new FlowLayout(FlowLayout.CENTER,30,5));
 			jpBottomPane1.add(modifyPane);
 			jpBottomPane1.add(jbContinue);
 			jpBottomPane1.add(exitPane);
 			jpBottomPane.setLayout(new GridLayout(2,1));
 			jpBottomPane.add(jpBottomPane1);
 			jpBottomPane.add(jpBottomPane2);
			txtAcademy.addActionListener(this);
 			modifyPane.addActionListener(this);
 			jbContinue.addActionListener(this);
 			exitPane.addActionListener(this);
 			container.add("North",jpTopPane);
 			container.add("Center",jpCenterPane);
 			container.add("South",jpBottomPane); 
 			setSize(380,460);
 			Dimension screen = Toolkit.getDefaultToolkit().getScreenSize();
			setLocation((screen.width - 370) / 2,(screen.height - 480) / 2);
    		setTitle("学生个人信息修改");
    		setResizable(false);
    		setVisible(true);	
		}
	}//end of class ModifyStudent
	/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
	/*---------------------------------------ModifyAddress--------------------------------------------*/
	class ModifyAddress extends JFrame implements ActionListener{
		JTextField txtInputNumber = new JTextField(15);
		JButton ascertain = new JButton("确定");
		JButton exit = new JButton("退出");			///11.9----------------------------------------------------
		JTextField txtStuNumber = new JTextField(15);
		JTextField txtDormName = new JTextField(15);
		JTextField txtBedchamberNumber = new JTextField(15);
		JTextField txtFloorPhone = new JTextField(15);
		JTextField txtTouchPhone = new JTextField(15);
		JTextField txtMailbox = new JTextField(15);
		JTextField txtTeacherNumber = new JTextField(15);
		JButton jbModify = new JButton("更   改");
		JButton jbContinue = new JButton("继  续");
		JButton jbExit = new JButton("退  出");
		String inputNumber;
		ModifyAddress(){
			ascertain.setPreferredSize(new Dimension(60,22));
			exit.setPreferredSize(new Dimension(60,22));	//11.9-------------------------------------------
			Container container = this.getContentPane();
			container.setLayout(new BorderLayout());
			JPanel jpTop = new JPanel();
			jpTop.setLayout(new GridLayout(3,1));
			JPanel jpTop1 = new JPanel();
			JPanel jpTop2 = new JPanel();
			JPanel jpTop3 = new JPanel();
			jpTop2 = new JPanel(new FlowLayout(FlowLayout.LEFT));
			jpTop2.add(new JLabel("输入学号"));
			jpTop2.add(txtInputNumber);
			jpTop2.add(ascertain);
			jpTop2.add(exit);		//11.9----------------------------------------------------------------
			jpTop.add(jpTop1);
			jpTop.add(jpTop2);
			jpTop.add(jpTop3);
			txtInputNumber.addActionListener(this);
			ascertain.addActionListener(this);
			exit.addActionListener(this);				//11.9----------------------------------------------
			container.add("North",jpTop);
			setSize(390,460);
 			Dimension screen = Toolkit.getDefaultToolkit().getScreenSize();
			setLocation((screen.width - 370) / 2,(screen.height - 480) / 2);
    		setTitle("学生住址修改");
    		setResizable(false);
    		setVisible(true);	
		}
		public void actionPerformed(ActionEvent e){
			if(e.getSource() == txtInputNumber || e.getSource() == ascertain){
				if(txtInputNumber.getText().equals("")){
					JOptionPane.showMessageDialog(null,"请输入学生学号！");	
					txtInputNumber.requestFocus();
				}
				else{
					Statement stm = null;
    				ResultSet rs = null;	
    				inputNumber = txtInputNumber.getText();
					ConnectServer.mainLink();		//建立和数据库的连接。
		   			try{
		   				stm = ConnectServer.con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
        				rs = stm.executeQuery("select * from address");
        				while(rs.next()){		//****************only for test*****************
     						if( txtInputNumber.getText().trim().equals(rs.getString("stu_number"))){
					    		txtStuNumber.setText(rs.getString("stu_number"));
								txtDormName.setText(rs.getString("dorm_name"));
								txtBedchamberNumber.setText(rs.getString("bedchamber_number"));
								txtFloorPhone.setText(rs.getString("floor_phone"));
								txtTouchPhone.setText(rs.getString("touch_phone"));
								txtMailbox.setText(rs.getString("mailbox"));
								txtTeacherNumber.setText(rs.getString("master_number"));
						 		txtStuNumber.setEditable(false);
							}
						}	
						txtInputNumber.setEditable(false);
	   					ascertain.setEnabled(false);	
	   					exit.setEnabled(false);		//11.9--------------------------------------------
			 			stm.close();
	            		ConnectServer.con.close();	
					}
					catch(Exception ee){
     					JOptionPane.showMessageDialog(null,"数据库操作失败！");	
     					System.exit(0);
	   				}			
					dispose();
					ModifyPane();
				}
			}
			else if(e.getSource() == exit){		//11.9--------------------------------------------------------------
				dispose();
				new InformationUpdate(userPriority);
			}	
			else if(e.getSource() == jbModify || e.getSource() == txtTeacherNumber){
				//数据库读出数据信息
 				Statement stm = null;
    			ResultSet rs = null;
    			String stuNumber;
    			String dormName;
    			String bedchamberNumber;
    			String floorPhone;
    			String touchPhone;
    			String mailbox;
    			String teacherNumber;		
    			boolean flag = false;
    			String sql;		
    			ConnectServer.mainLink();		//建立和数据库的连接。
		   		try{
		   			stm = ConnectServer.con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
        			rs = stm.executeQuery("select * from address");
        			while(rs.next()){		//****************only for test*****************
     					if(inputNumber.equals(rs.getString("stu_number"))){
     						flag = true;
     						stuNumber = rs.getString("stu_number");
     						dormName = rs.getString("dorm_name");
     						bedchamberNumber = rs.getString("bedchamber_number");
							floorPhone = rs.getString("floor_phone");
							touchPhone = rs.getString("touch_phone");
							mailbox = rs.getString("mailbox");
							teacherNumber = rs.getString("master_number");  
					 		System.out.print(""+stuNumber+" "+dormName+" "+bedchamberNumber);//for test
					 		System.out.println(" "+floorPhone+" "+touchPhone+" "+mailbox+" "+teacherNumber);	
				 			sql = "update address set stu_number = '"+txtStuNumber.getText();
        					sql = sql+"',dorm_name = '"+txtDormName.getText();
        					sql = sql+"',bedchamber_number = '"+txtBedchamberNumber.getText();
        					sql = sql+"',floor_phone = '"+txtFloorPhone.getText();
        					sql = sql+"',touch_phone = '"+txtTouchPhone.getText();
        					sql = sql+"',mailbox = '"+txtMailbox.getText();
        					sql = sql+"',master_number = '"+txtTeacherNumber.getText();
        					sql = sql+"' where stu_number = '"+inputNumber+"'";
        			 		System.out.println(""+sql);
        			  		stm.executeUpdate(sql);
    						JOptionPane.showMessageDialog(null,"信息更改已成功！");				
        		 			stm.close();
					 		ConnectServer.con.close();				
						}
					}
				}
				catch(NullPointerException en){
					
				}
				catch(SQLException ee){
     				JOptionPane.showMessageDialog(null,"数据库操作失败！");	
     				System.exit(0);
	   			}		
			}	
			else if(e.getSource() == jbContinue){
				dispose();
				new ModifyAddress();
			}
			else if(e.getSource() == jbExit){
				dispose();
			    new	InformationUpdate(userPriority);		//////////////////////bug????????????????
			}	
		}
		public void ModifyPane(){
			Container container = this.getContentPane();
			container.setLayout(new BorderLayout());
			JPanel jpTop = new JPanel();
			jpTop.setLayout(new GridLayout(10,1));
			JPanel jpTop1 = new JPanel();
			JPanel jpTop2 = new JPanel();
			JPanel jpTop3 = new JPanel();
			JPanel jpTop4 = new JPanel();
			JPanel jpTop5 = new JPanel();
			JPanel jpTop6 = new JPanel();
			JPanel jpTop7 = new JPanel();
	 		JPanel jpTop8 = new JPanel();
			jpTop.add(jpTop1);
			jpTop.add(jpTop2);
			jpTop.add(jpTop3);
			jpTop.add(jpTop4);
			jpTop.add(jpTop5);
			jpTop.add(jpTop6);
			jpTop.add(jpTop7);
		 	jpTop.add(jpTop8);
			JPanel jpCen = new JPanel();
			jpCen.setLayout(new GridLayout(7,1));
			JPanel jpCenter[] = new JPanel[7];
			for(int i = 0;i < 7;i++){
				jpCenter[i] = new JPanel(new FlowLayout(FlowLayout.LEFT));	
			}
			jpCenter[0].add(new JLabel("学        号"));
			jpCenter[1].add(new JLabel("宿舍名称"));
			jpCenter[2].add(new JLabel("寝室编号"));
			jpCenter[3].add(new JLabel("楼层电话"));