dataentry.java

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

	}// end of class EntryStudent
	/*--------------------------------------EntryAddress--------------------------------------------*/
	class EntryAddress extends JFrame implements ActionListener{
		String title[] = {"学         号","宿舍名称","寝室编号","楼层电话",
								  "寝室电话","邮         箱","教师编号"};
		JTextField txtNumber = new JTextField(15);
		JComboBox cobDormName = new JComboBox();
		JTextField txtDormNumber = new JTextField(15);
		JTextField txtFloorPhone = new JTextField(15);
		JTextField txtBedchamberPhone = new JTextField(15);
		JTextField txtMailbox = new JTextField(15);
		JTextField txtTeacherNumber = new JTextField(15);
		JButton save = new JButton("保 存");
		JButton exit = new JButton("退 出");						  						  				  
		EntryAddress(){
			Container container = this.getContentPane();
 			container.setLayout(new BorderLayout());
 			cobDormName.addItem("锦地苑");
 			cobDormName.addItem("临江苑");
 			cobDormName.addItem("德馨苑");
 			cobDormName.setSelectedIndex(0);
 			JPanel p[] = new JPanel[7];
 	 		for(int i = 0;i < 7;i++){
 	 			p[i] = new JPanel(new FlowLayout(FlowLayout.LEFT));
 	 		}
 			for(int i = 0;i < 7;i++){
 				p[i].add(new JLabel(title[i]));		
 			}
 			p[0].add(txtNumber);
 			p[1].add(cobDormName);
 			p[2].add(txtDormNumber);
 			p[3].add(txtFloorPhone);
 			p[4].add(txtBedchamberPhone );
 			p[5].add(txtMailbox);
 			p[6].add(txtTeacherNumber);
 			JPanel jpCenter = new JPanel();
 			jpCenter.setLayout(new GridLayout(7,1));
 			for(int i = 0;i < 7;i++){
 				jpCenter.add(p[i]);	
 			}
 			JPanel jpTop = new JPanel();
 			JPanel jpBottom1 = new JPanel();
 			JPanel jpBottom2 = new JPanel();
 			JPanel jpBottom = new JPanel();
 			jpBottom1 = new JPanel(new FlowLayout(FlowLayout.CENTER,50,5));
 			jpBottom1.add(save);
 			jpBottom1.add(exit);
 			jpBottom.setLayout(new GridLayout(2,1));
 			jpBottom.add(jpBottom1);
 			jpBottom.add(jpBottom2);
 			txtTeacherNumber.addActionListener(this);
 			save.addActionListener(this);
 			exit.addActionListener(this);
 			container.add("North",jpTop);
 			container.add("Center",jpCenter);
 			container.add("South",jpBottom);
 			setSize(360,400);
 			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() == save || e.getSource() == txtTeacherNumber){
				Statement stm = null;
    			ResultSet rs = null;
    			String addrStuNumber;
    			String addrDormName;
    			String addrDormNumber;
    			String addrFloorPhone;
    			String addrBedchamberPhone;
    			String addrMailbox;
    			String addrTeacherNumber;
    			ConnectServer.mainLink();		//建立和数据库的连接。
		     	try{
		   			stm = ConnectServer.con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
        			rs = stm.executeQuery("select * from address");
        			while(rs.next()){		// for testing
     					System.out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3)+" "+rs.getString(4)+" "+rs.getString(5)+" "+rs.getString(6));
  					}
					addrStuNumber = txtNumber.getText();
					addrDormName = (String)cobDormName.getSelectedItem();
					addrDormNumber = txtDormNumber.getText();
					addrFloorPhone = txtFloorPhone.getText();
					addrBedchamberPhone = txtBedchamberPhone.getText();
					addrMailbox = txtMailbox.getText();
					addrTeacherNumber = txtTeacherNumber.getText();
					System.out.println(" "+addrStuNumber+"   "+addrDormName+"  "+addrDormNumber+
					"  "+addrFloorPhone+"  "+addrBedchamberPhone+"  "+addrMailbox+" "+addrTeacherNumber);		// for testing
					String sql;	
				 	sql = "insert into address(stu_number,dorm_name,bedchamber_number,floor_phone,touch_phone,mailbox,master_number)";
			     	sql = sql+" values('"+addrStuNumber+"','"+addrDormName+"','"+addrDormNumber+"','"+addrFloorPhone;
			     	sql = sql+"','"+addrBedchamberPhone+"','"+addrMailbox+"','"+addrTeacherNumber+"')";
			 		System.out.println(sql);
			 		stm.executeUpdate(sql);		//执行SQL语句
			 		JOptionPane.showMessageDialog(null,"增添信息已成功！");	
			 		txtNumber.setText("");
			 		cobDormName.setSelectedIndex(0);
			 		txtDormNumber.setText("");
			 		txtFloorPhone.setText("");
					txtBedchamberPhone.setText("");
					txtMailbox.setText("");
					txtTeacherNumber.setText("");
					txtNumber.requestFocus();
					stm.close();
					ConnectServer.con.close();				
				}
				catch(Exception ee){
     				JOptionPane.showMessageDialog(null,"数据库操作失败！");	
     				System.exit(0);
	   			}	
			}// end if
			else if(e.getSource() == exit){
				dispose();
				new DataEntry(userPriority);	
			}
		}
	}// end of class EntryAddress
	/*------------------------------------EntryMaster-------------------------------------------------*/
	class EntryMaster extends JFrame implements ActionListener{
		String title[] = {"教师编号","教师姓名","性         别","电         话"};
		JTextField txtTeacherNumber = new JTextField(15);
		JTextField txtTeacherName = new JTextField(15);
		ButtonGroup group=new ButtonGroup();    
		JRadioButton rabSexM = new JRadioButton("男",true);
		JRadioButton rabSexF = new JRadioButton("女",false);
		JTextField txtPhone = new JTextField(15);
		JButton save = new JButton("保 存");
		JButton exit = new JButton("退 出");					
		EntryMaster(){
			Container container = this.getContentPane();
 			container.setLayout(new BorderLayout());
			group.add(rabSexM);
 			group.add(rabSexF);	
 			
 			JPanel p[] = new JPanel[4];
 	 		for(int i = 0;i < 4;i++){
 	 			p[i] = new JPanel(new FlowLayout(FlowLayout.LEFT));
 	 		}
 			for(int i = 0;i < 4;i++){
 				p[i].add(new JLabel(title[i]));		
 			}
 			p[0].add(txtTeacherNumber);
 			p[1].add(txtTeacherName);
 			p[2].add(rabSexM);
 			p[2].add(rabSexF);
 			p[3].add(txtPhone);
 			JPanel jpCenter = new JPanel();
 			jpCenter.setLayout(new GridLayout(4,1));
 			for(int i = 0;i < 4;i++){
 				jpCenter.add(p[i]);	
 			}
 		 	JPanel jpTop = new JPanel();
 			JPanel jpBottom1 = new JPanel();
 			JPanel jpBottom2 = new JPanel();
 			JPanel jpBottom = new JPanel();
 			jpBottom1 = new JPanel(new FlowLayout(FlowLayout.CENTER,50,5));
 			jpBottom1.add(save);
 			jpBottom1.add(exit);
 			jpBottom.setLayout(new GridLayout(2,1));
 			jpBottom.add(jpBottom1);
 			jpBottom.add(jpBottom2);
 			txtPhone.addActionListener(this);
 			save.addActionListener(this);
 			exit.addActionListener(this);
 			container.add("North",jpTop);
 			container.add("Center",jpCenter);
 			container.add("South",jpBottom);
 			setSize(270,270);
 			Dimension screen = Toolkit.getDefaultToolkit().getScreenSize();
			setLocation((screen.width - 230) / 2,(screen.height - 450) / 2);
    		setTitle("教师信息录入");
    		setResizable(false);
    		setVisible(true);	
		}// end of EntryMaster
		public void actionPerformed(ActionEvent e){
			if(e.getSource() == save || e.getSource() == txtPhone){
				Statement stm = null;
    			ResultSet rs = null;
    			String teacherNumber;
    			String teacherName;
    			String teacherSex;
    			String teacherPhone;
    			ConnectServer.mainLink();		//建立和数据库的连接。
		     	try{
		   			stm = ConnectServer.con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
        			rs = stm.executeQuery("select * from master");
        			while(rs.next()){		// for testing
     					System.out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3)+" "+rs.getString(4));
  					}
					teacherNumber = txtTeacherNumber.getText();
					teacherName = txtTeacherName.getText();
					boolean judge1 = false;
		    		judge1 = rabSexM.isSelected();
					if(judge1 == true){
						teacherSex = "男";
					}
					else{
						teacherSex = "女";
					}
					teacherPhone = txtPhone.getText();
					System.out.println(" "+teacherNumber+"   "+teacherName+"  "+teacherSex+"  "+teacherPhone);		// for testing
					String sql;	
				 	sql = "insert into master(master_number,master_name,master_sex,master_phone)";
			     	sql = sql+" values('"+teacherNumber+"','"+teacherName+"','"+teacherSex+"','"+teacherPhone+"')";
			 		stm.executeUpdate(sql);		//执行SQL语句
			    	JOptionPane.showMessageDialog(null,"增添信息已成功！");	
			 		txtTeacherNumber.setText("");
			 		txtTeacherName.setText("");
			 		rabSexM.setSelected(true);
			 		txtPhone.setText("");
			 		txtTeacherNumber.requestFocus();
					stm.close();
					ConnectServer.con.close();				
				}
				catch(Exception ee){
     				JOptionPane.showMessageDialog(null,"数据库操作失败！");	
     				System.exit(0);
	   			}	
			}// end if
			else if(e.getSource() == exit){
				dispose();
				new DataEntry(userPriority);			
			}
		}// end of actionPerformed
	}// end of class EntryMaster
}// end of class DataEntry