mainframe.java

学生信息管理系统

		menu_6.addSeparator();

		final JMenuItem menuItem_11 = new JMenuItem();
		menuItem_11.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_2, 0));
		menuItem_11.setFont(new Font("楷体_GB2312", Font.BOLD, 15));
		menuItem_11.setBackground(new Color(255, 128, 128));
		menuItem_11.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				StudentMarkTableFrame smtf=new StudentMarkTableFrame();
				sql="select * from grade order by math";
				rs=db.getResult(sql);
				smtf.resultShow(rs);
				smtf.setVisible(true);
				smtf.setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);
			}
		});
		menuItem_11.setText("按高数成绩");
		menu_6.add(menuItem_11);

		menu_6.addSeparator();

		menu_6.addSeparator();

		final JMenuItem menuItem_12 = new JMenuItem();
		menuItem_12.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_3, 0));
		menuItem_12.setFont(new Font("楷体_GB2312", Font.BOLD, 15));
		menuItem_12.setBackground(new Color(255, 128, 128));
		menuItem_12.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				StudentMarkTableFrame smtf=new StudentMarkTableFrame();
				sql="select * from grade order by english";
				rs=db.getResult(sql);
				smtf.resultShow(rs);
				smtf.setVisible(true);
				smtf.setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);
			}
		});
		menuItem_12.setText("按英语成绩");
		menu_6.add(menuItem_12);

		menu_6.addSeparator();

		menu_6.addSeparator();

		final JMenuItem menuItem_13 = new JMenuItem();
		menuItem_13.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_4, 0));
		menuItem_13.setFont(new Font("楷体_GB2312", Font.BOLD, 15));
		menuItem_13.setBackground(new Color(255, 128, 128));
		menuItem_13.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				StudentMarkTableFrame smtf=new StudentMarkTableFrame();
				sql="select * from grade order by specialty";
				rs=db.getResult(sql);
				smtf.resultShow(rs);
				smtf.setVisible(true);
				smtf.setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);
			}
		});
		menuItem_13.setText("按专业课成绩");
		menu_6.add(menuItem_13);

		final JMenu menu_3 = new JMenu();
		menu_3.setMnemonic('Q');
		menu_3.setFont(new Font("楷体_GB2312", Font.BOLD, 15));
		menuBar.add(menu_3);
		menu_3.setBackground(new Color(128, 255, 255));
		menu_3.setText("查询(Q)");

		menu_3.addSeparator();

		final JMenuItem menuItem_2 = new JMenuItem();
		menuItem_2.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_Q, 0));
		menuItem_2.setFont(new Font("楷体_GB2312", Font.BOLD, 15));
		menuItem_2.setBackground(new Color(255, 128, 128));
		menuItem_2.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				PeopleQueryFrame1 pqf=new PeopleQueryFrame1();
				pqf.setVisible(true);
				pqf.setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);
			}
		});
		menuItem_2.setText("查询人员");
		menu_3.add(menuItem_2);

		menu_3.addSeparator();

		final JMenuItem menuItem_18 = new JMenuItem();
		menuItem_18.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_0, 0));
		menuItem_18.setFont(new Font("楷体_GB2312", Font.BOLD, 15));
		menuItem_18.setBackground(new Color(255, 128, 128));
		menuItem_18.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				MarkQueryFrame mqf=new MarkQueryFrame();
				mqf.setVisible(true);
				mqf.setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);
			}
		});
		menuItem_18.setText("查询成绩");
		menu_3.add(menuItem_18);

		menu_3.addSeparator();

		final JMenu menu_4 = new JMenu();
		menu_4.setMnemonic('T');
		menu_4.setFont(new Font("楷体_GB2312", Font.BOLD, 15));
		menu_4.setBackground(new Color(128, 255, 255));
		menu_4.setText("统计(T)");
		menuBar.add(menu_4);

		final JMenuItem menuItem_15 = new JMenuItem();
		menuItem_15.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_Q, 0));
		menuItem_15.setFont(new Font("楷体_GB2312", Font.BOLD, 15));
		menuItem_15.setBackground(new Color(255, 128, 128));
		menuItem_15.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				PeopleStatisticFrame psf=new PeopleStatisticFrame();
				psf.setVisible(true);
				psf.setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);
			}
		});
		menuItem_15.setText("人员统计");
		menu_4.add(menuItem_15);

		menu_4.addSeparator();

		final JMenuItem menuItem_16 = new JMenuItem();
		menuItem_16.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_0, 0));
		menuItem_16.setFont(new Font("楷体_GB2312", Font.BOLD, 15));
		menuItem_16.setBackground(new Color(255, 128, 128));
		menuItem_16.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				MarkStatisticFrame msf=new MarkStatisticFrame();
				msf.setVisible(true);
				//msf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
			}
		});
		menuItem_16.setText("成绩统计");
		menu_4.add(menuItem_16);

		final JMenu menu_5 = new JMenu();
		menu_5.setMnemonic('H');
		menu_5.setFont(new Font("楷体_GB2312", Font.BOLD, 15));
		menu_5.setBackground(new Color(128, 255, 255));
		menu_5.setText("帮助(H)");
		menuBar.add(menu_5);

		final JMenuItem menuItem_17 = new JMenuItem();
		menuItem_17.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_H, 0));
		menuItem_17.setFont(new Font("楷体_GB2312", Font.BOLD, 15));
		menuItem_17.setBackground(new Color(255, 128, 128));
		menuItem_17.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				AboutFrame af=new AboutFrame();
				af.setVisible(true);
				af.setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);
			}
		});
		menuItem_17.setText("关于我");
		menu_5.add(menuItem_17);

		final JMenu menu_7 = new JMenu();
		menu_7.setText(" ");
		menuBar.add(menu_7);

		final JPanel panel = new JPanel();
		panel.setBackground(new Color(237, 249, 254));
		panel.setLayout(null);
		getContentPane().add(panel);

		l1 = new JLabel();
		l1.setIcon(SwingResourceManager.getIcon(MainFrame.class, "/images/l3.gif"));
		l1.setText(" ");
		l1.setBounds(0, 56, 550, 400);
		panel.add(l1);

		final JLabel l2 = new JLabel();
		l2.setIcon(SwingResourceManager.getIcon(MainFrame.class, "/images/gifbj199.gif"));
		l2.setText(" ");
		l2.setBounds(444, 56, 106, 120);
		panel.add(l2);

		final JLabel label = new JLabel();
		label.setIcon(SwingResourceManager.getIcon(MainFrame.class, "/images/20070120093247812.gif"));
		label.setText(" ");
		label.setBounds(444, 146, 112, 182);
		panel.add(label);

		final JLabel label_1 = new JLabel();
		label_1.setIcon(SwingResourceManager.getIcon(MainFrame.class, "/images/6.gif"));
		label_1.setText(" ");
		label_1.setBounds(476, 334, 108, 120);
		panel.add(label_1);

		final JLabel label_2 = new JLabel();
		label_2.setIcon(SwingResourceManager.getIcon(MainFrame.class, "/images/m.gif"));
		label_2.setText(" ");
		label_2.setBounds(0, 0, 548, 78);
		panel.add(label_2);

		final JLabel label_3 = new JLabel();
		label_3.setIcon(SwingResourceManager.getIcon(MainFrame.class, "/images/you.gif"));
		label_3.setText(" ");
		label_3.setBounds(0, 411, 500, 45);
		panel.add(label_3);

		final JLabel label_4 = new JLabel();
		label_4.setIcon(SwingResourceManager.getIcon(MainFrame.class, "/images/e.gif"));
		label_4.setText(" ");
		label_4.setBounds(258, 146, 300, 122);
		panel.add(label_4);

		final JLabel label_5 = new JLabel();
		label_5.setIcon(SwingResourceManager.getIcon(MainFrame.class, "/images/he.gif"));
		label_5.setText(" ");
		label_5.setBounds(10, 321, 91, 84);
		panel.add(label_5);

		final JLabel label_6 = new JLabel();
		label_6.setIcon(SwingResourceManager.getIcon(MainFrame.class, "/images/hi.gif"));
		label_6.setText(" ");
		label_6.setBounds(0, 116, 273, 93);
		panel.add(label_6);

		 Thread tdPic = new Thread(new Pictd());
		 tdPic.start();		
		//
	}
	private class Pictd implements Runnable{

		public void run()   {
			int i = 0;
			
			while(true)
			{
					l1.setIcon(SwingResourceManager.getIcon(MainFrame.class, pic[i++]));
				if(i==13){
					i=0;
				}				
				try{
				Thread.sleep(10000);
				}catch(Exception e){
					System.out.println(e);
				}
			}
		}
	}

}