informationupdate.java

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

			jpCenter[4].add(new JLabel("联系电话"));
			jpCenter[5].add(new JLabel("邮        箱"));
			jpCenter[6].add(new JLabel("教师编号"));
			jpCenter[0].add(txtStuNumber);
			jpCenter[1].add(txtDormName);
			jpCenter[2].add(txtBedchamberNumber);
			jpCenter[3].add(txtFloorPhone);
			jpCenter[4].add(txtTouchPhone);
			jpCenter[5].add(txtMailbox);
			jpCenter[6].add(txtTeacherNumber);
			jpCen.add(jpCenter[0]);
			jpCen.add(jpCenter[1]);
			jpCen.add(jpCenter[2]);
			jpCen.add(jpCenter[3]);
			jpCen.add(jpCenter[4]);
			jpCen.add(jpCenter[5]);
			jpCen.add(jpCenter[6]);
			JPanel jpBottom = new JPanel();
			jpBottom.setLayout(new GridLayout(2,1));
			JPanel jpBottom1 = new JPanel();
			jpBottom1 = new JPanel(new FlowLayout(FlowLayout.CENTER,30,5));
			JPanel jpBottom2 = new JPanel();
			jpBottom1.add(jbModify);
			jpBottom1.add(jbContinue);
			jpBottom1.add(jbExit);
			jpBottom.add(jpBottom1);
			jpBottom.add(jpBottom2);
			txtTeacherNumber.addActionListener(this);
			jbModify.addActionListener(this);
			jbContinue.addActionListener(this);
			jbExit.addActionListener(this);
			container.add("North",jpTop);
			container.add("Center",jpCen);
			container.add("South",jpBottom);
			setSize(390,460);
 			Dimension screen = Toolkit.getDefaultToolkit().getScreenSize();
			setLocation((screen.width - 370) / 2,(screen.height - 480) / 2);
    		setTitle("学生住址修改");
    		setResizable(false);
    		setVisible(true);	
		}
	}//end of class ModifyStudent
	////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
	/*--------------------------------------ModifyMaster----------------------------------------------*/
	class ModifyMaster extends JFrame implements ActionListener{
		JTextField txtInputMasterNumber = new JTextField(15);
		JButton ascertain = new JButton("确定");
		JButton exit = new JButton("退出");			///11.9----------------------------------------------------
		JTextField txtMasterNumber = new JTextField(15);
		JTextField txtMasterName = new JTextField(15);
		ButtonGroup group=new ButtonGroup();    
		JRadioButton rabSexM = new JRadioButton("男",false);
		JRadioButton rabSexF = new JRadioButton("女",false);
		JTextField txtMasterPhone = new JTextField(15);
		JButton jbModify = new JButton("更  改");
		JButton jbContinue = new JButton("继  续");
		JButton jbExit = new JButton("退  出");
		String sex;		
		//--------------------------------ModifyMaster----------------------------------
	 	ModifyMaster(){
			Container container = this.getContentPane();
			container.setLayout(new BorderLayout());
			JPanel jpTop = new JPanel();
			JPanel jpTop1 = new JPanel();
			JPanel jpTop2 = new JPanel();
			JPanel jpTop3 = new JPanel();
			jpTop.setLayout(new GridLayout(3,1));
			jpTop2 = new JPanel(new FlowLayout(FlowLayout.LEFT));
			jpTop2.add(new JLabel("输入编号"));
			jpTop2.add(txtInputMasterNumber);
			ascertain.setPreferredSize(new Dimension(60,22));
			exit.setPreferredSize(new Dimension(60,22));	//11.9-------------------------------------------
			jpTop2.add(ascertain);
			jpTop2.add(exit);		//11.9----------------------------------------------------------------
			jpTop.add(jpTop1);
			jpTop.add(jpTop2);
			jpTop.add(jpTop3);
			txtMasterNumber.addActionListener(this);
			ascertain.addActionListener(this);
			exit.addActionListener(this);	//11.9---------------------------------------------
			container.add("North",jpTop);
			setSize(390,375);
 			Dimension screen = Toolkit.getDefaultToolkit().getScreenSize();
			setLocation((screen.width - 370) / 2,(screen.height - 480) / 2);
    		setTitle("教师信息修改");
    		setResizable(false);
    		setVisible(true);	
		}//ModifyMaster
		//-----------------------------------------actionPerformed---------------------------------
	 	public void actionPerformed(ActionEvent e){///1
			if(e.getSource() == txtInputMasterNumber || e.getSource() == ascertain){   
				if(txtInputMasterNumber.getText().equals("")){
					JOptionPane.showMessageDialog(null,"请输入教师编号！");	
					txtInputMasterNumber.requestFocus();
				}
				else{
					Statement stm = null;
    				ResultSet rs = null;	
    				boolean flag = false;
					ConnectServer.mainLink();		//建立和数据库的连接。
		   			try{//3
		   				stm = ConnectServer.con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
        				rs = stm.executeQuery("select * from master");
        				while(rs.next()){//4		//****************only for test*****************
     						if( txtInputMasterNumber.getText().trim().equals(rs.getString("master_number"))){//5
								flag = true;
								txtMasterNumber.setText(rs.getString("master_number"));
								txtMasterName.setText(rs.getString("master_name"));
								sex = rs.getString("master_sex");
        						if(sex.equals("男")){
									rabSexM.setSelected(true);
								}
								else{
									rabSexF.setSelected(true);	
								}
								txtMasterPhone.setText(rs.getString("master_phone"));		
							}
						}
			 			stm.close();
	           			ConnectServer.con.close();	
					}//try
					catch(Exception ee){//10
     					JOptionPane.showMessageDialog(null,"数据库操作失败！");	
     					System.exit(0);
	   				}
	   				txtInputMasterNumber.setEditable(false);
	   				ascertain.setEnabled(false);	
	   				exit.setEnabled(false);		//11.9--------------------------------------------
					dispose();
					ModifyPane();	
				}	
			}//if
			else if(e.getSource() == exit){		//11.9--------------------------------------------------------------
				dispose();
				new InformationUpdate(userPriority);
			}	
			else if(e.getSource() == jbModify || e.getSource() == txtMasterPhone){//11
				//数据库读出数据信息
 				Statement stm = null;
    			ResultSet rs = null;
    			boolean flag = false;
    			String sql;		
    			ConnectServer.mainLink();		//建立和数据库的连接。
		  	 	try{//12
		   			stm = ConnectServer.con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
        			rs = stm.executeQuery("select * from master");
        			while(rs.next()){		//****************only for test*****************
     					if(txtInputMasterNumber.getText().trim().equals(rs.getString("master_number"))){//13
     						flag = true;
   							if(rabSexM.isSelected()){//14
        						sex = "男";
        					}
        					else{//15
        						sex = "女";	
        					}
					  		System.out.println(""+rs.getString("master_number")+" "+rs.getString("master_name")+" "+sex+" "+rs.getString("master_phone"));	//for test
				 			sql = "update master set master_number = '"+txtMasterNumber.getText();
        					sql = sql+"',master_name = '"+txtMasterName.getText();
        					sql = sql+"',master_sex = '"+sex;
        					sql = sql+"',master_phone = '"+txtMasterPhone.getText();
        					sql = sql+"' where master_number = '"+txtInputMasterNumber.getText()+"'";
        			 		System.out.println(""+sql);
        		 	  		stm.executeUpdate(sql);
    						JOptionPane.showMessageDialog(null,"信息更改已成功！");			
        		 			stm.close();
					 		ConnectServer.con.close();				
						}
					}
				}//try
				catch(NullPointerException en){//16
				}
				catch(SQLException ee){//17
     				JOptionPane.showMessageDialog(null,"数据库操作失败！");	
     				System.exit(0);
	   			}		
			}//if
			else if(e.getSource() ==  jbContinue){
				dispose();
				new ModifyMaster();
			}
			else if(e.getSource() == jbExit){//18
				dispose();
				new InformationUpdate(userPriority);	
			}
		}//end of actionPerformed 
		//-------------------------------------ModifyPane-----------------------------------------
 		public void ModifyPane(){
			Container container = this.getContentPane();
			container.setLayout(new BorderLayout());
			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.setLayout(new GridLayout(10,1));
			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(4,1));
			JPanel jpCenter[] = new JPanel[4];
			for(int i = 0;i < 4;i++){
				jpCenter[i] = new JPanel(new FlowLayout(FlowLayout.LEFT));	
			}
			group.add(rabSexM);
 		 	group.add(rabSexF);	
			jpCenter[0].add(new JLabel("教师编号"));
			jpCenter[1].add(new JLabel("教师姓名"));
			jpCenter[2].add(new JLabel("性        别"));
			jpCenter[3].add(new JLabel("联系电话"));
			jpCenter[0].add(txtMasterNumber);
			jpCenter[1].add(txtMasterName);
			jpCenter[2].add(rabSexM);
			jpCenter[2].add(rabSexF);		
			jpCenter[3].add(txtMasterPhone);
			JPanel jpCent = new JPanel();
			jpCent.setLayout(new GridLayout(4,1));
			jpCent.add(jpCenter[0]);
			jpCent.add(jpCenter[1]);
			jpCent.add(jpCenter[2]);
			jpCent.add(jpCenter[3]);
			JPanel jpBottom = new JPanel();
			JPanel jpBottom1 = new JPanel();
			JPanel jpBottom2 = new JPanel();
			jpBottom.setLayout(new GridLayout(2,1));
			jpBottom1 = new JPanel(new FlowLayout(FlowLayout.CENTER,30,5));
			jpBottom1.add(jbModify);
			jpBottom1.add(jbContinue);
			jpBottom1.add(jbExit);
			jpBottom.add(jpBottom1);
			jpBottom.add(jpBottom2);
			txtMasterPhone.addActionListener(this);
			jbModify.addActionListener(this);
			jbContinue.addActionListener(this);
			jbExit.addActionListener(this);
			container.add("North",jpTop);
			container.add("Center",jpCent);
			container.add("South",jpBottom);
			setSize(390,375);
 			Dimension screen = Toolkit.getDefaultToolkit().getScreenSize();
			setLocation((screen.width - 370) / 2,(screen.height - 480) / 2);
    		setTitle("教师信息修改");
    		setResizable(false);
    		setVisible(true);	
		} 
	}//end of class ModifyStudent
}