mainframe.java

学生信息管理系统

package com.sccp.StudentMS.baseFrame;

import java.awt.Color;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.InputEvent;
import java.awt.event.KeyEvent;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JMenu;
import javax.swing.JMenuBar;
import javax.swing.JMenuItem;
import javax.swing.JPanel;
import javax.swing.KeyStroke;

import com.sccp.StudentMS.DBtools.DBtool;
import com.swtdesigner.SwingResourceManager;

import java.sql.ResultSet;
public class MainFrame extends JFrame {
	public static StudentInfoFrame sif=new StudentInfoFrame();
	public static ModifyStudentInfoFrame msif=new ModifyStudentInfoFrame();
    public static DeleteStudentInfoFrame dsif=new DeleteStudentInfoFrame();
    public static MarkInfoFrame mif=new MarkInfoFrame();
    String sql;
    ResultSet rs;
    JLabel l1;
    DBtool db=new DBtool();
    
    private String [] pic = {"/images/sun.gif",   "/images/l6.gif","/images/l8.gif","/images/l9.gif","/images/l10.gif","/images/l3.gif","/images/sun.gif","/images/l12.gif" ,"/images/l14.gif","/images/l15.gif","/images/l11.gif","/images/2.gif","/images/3.gif" };
	/**
	 * Launch the application
	 * @param args
	 */
	public static void main(String args[]) {
		try {
			MainFrame frame = new MainFrame();
			frame.setVisible(true);
				
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	/**
	 * Create the frame
	 */
	public MainFrame() {
		super();
		setResizable(false);
		setTitle("学生管理系统");
		setBounds(100, 100, 566, 515);
		setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);

		final JMenuBar menuBar = new JMenuBar();
		menuBar.setBackground(new Color(237, 249, 254));
	
		setJMenuBar(menuBar);

        final JMenu menu = new JMenu();
		menu.setMnemonic('M');
		menu.setFont(new Font("楷体_GB2312", Font.BOLD, 15));
		menu.setBackground(new Color(128, 255, 255));
		menu.setText("系统管理(M)");
		menuBar.add(menu);

		final JMenuItem menuItem_9 = new JMenuItem();
		menuItem_9.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_F1, 0));
		menuItem_9.setFont(new Font("楷体_GB2312", Font.BOLD, 14));
		menuItem_9.setBackground(new Color(255, 128, 128));
		menuItem_9.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				System.exit(0);
			}
		});
		menuItem_9.setText("退出");
		menu.add(menuItem_9);

		final JMenu menu_1 = new JMenu();
		menu_1.setMnemonic('X');
		menu_1.setFont(new Font("楷体_GB2312", Font.BOLD, 15));
		menu_1.setBackground(new Color(128, 255, 255));
		menu_1.setText("信息管理(X)");
		menuBar.add(menu_1);

		final JMenuItem menuItem = new JMenuItem();
		menuItem.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_I, 0));
		menuItem.setFont(new Font("楷体_GB2312", Font.BOLD, 14));
		menuItem.setBackground(new Color(255, 128, 128));
		menuItem.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
		
				sif.setVisible(true);
				sif.setNull();
				sif.setTextAbled(false);
				sif.setButton(true,false,false,false,false);
				sif.setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);
				
			}
		});
		menu_1.add(menuItem);
		menuItem.setText("信息综合管理");

		menu_1.addSeparator();

		menu_1.addSeparator();

		final JMenuItem menuItem_1 = new JMenuItem();
		menuItem_1.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_0, 0));
		menuItem_1.setFont(new Font("楷体_GB2312", Font.BOLD, 15));
		menuItem_1.setBackground(new Color(255, 128, 128));
		menuItem_1.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				AddStudentInfoFrame asif=new AddStudentInfoFrame();
				asif.setExeType("add");
				asif.setVisible(true);
				asif.setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);
			}
		});
		menu_1.add(menuItem_1);
		menuItem_1.setText("添加信息");

		menu_1.addSeparator();

		menu_1.addSeparator();

		final JMenuItem edit = new JMenuItem();
		edit.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_1, 0));
		edit.setFont(new Font("楷体_GB2312", Font.BOLD, 15));
		edit.setBackground(new Color(255, 128, 128));
		edit.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {

				msif.setVisible(true);
				msif.setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);
			}
		});
		menu_1.add(edit);
		edit.setText("修改信息");

		menu_1.addSeparator();

		menu_1.addSeparator();

		final JMenuItem menuItem_3 = new JMenuItem();
		menuItem_3.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_2, 0));
		menuItem_3.setFont(new Font("楷体_GB2312", Font.BOLD, 15));
		menuItem_3.setBackground(new Color(255, 128, 128));
		menuItem_3.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {

				dsif.setVisible(true);
				dsif.setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);
			}
		});
		menu_1.add(menuItem_3);
		menuItem_3.setText("删除信息");

		final JMenu menu_2 = new JMenu();
		menu_2.setFont(new Font("楷体_GB2312", Font.BOLD, 15));
		menu_2.setMnemonic('C');
		menu_2.setBackground(new Color(128, 255, 255));
		menuBar.add(menu_2);
		menu_2.setText("成绩管理(C)");

		final JMenuItem menuItem_4 = new JMenuItem();
		menuItem_4.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_M, 0));
		menuItem_4.setFont(new Font("楷体_GB2312", Font.BOLD, 15));
		menuItem_4.setBackground(new Color(255, 128, 128));
		menuItem_4.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {

				mif.setVisible(true);
				mif.setButton(true, false, false, false, true);
				mif.setNull();
				mif.setTextAbled(false);
				mif.setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);
			}
		});
		menu_2.add(menuItem_4);
		menuItem_4.setText("成绩综合管理");

		menu_2.addSeparator();

		menu_2.addSeparator();

		final JMenuItem menuItem_5 = new JMenuItem();
		menuItem_5.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_0, 0));
		menuItem_5.setFont(new Font("楷体_GB2312", Font.BOLD, 15));
		menuItem_5.setBackground(new Color(255, 128, 128));
		menuItem_5.addActionListener(new ActionListener() {
			public void actionPerformed(final ActionEvent e) {
				AddMarkInfoFrame amif=new AddMarkInfoFrame();
				amif.setTextAbled(false);
				amif.setVisible(true);
				amif.setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);
			}
		});
		menu_2.add(menuItem_5);
		menuItem_5.setText("添加成绩");

		final JMenu menu_6 = new JMenu();
		menu_6.setMnemonic('S');
		menu_6.setFont(new Font("楷体_GB2312", Font.BOLD, 15));
		menu_6.setBackground(new Color(128, 255, 255));
		menu_6.setText("排序(S)");
		menuBar.add(menu_6);

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

		menu_6.addSeparator();

		menu_6.addSeparator();

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

		menu_6.addSeparator();