spesubmainframe.java

包含了学生管理系统的一些基本操作以及相关窗口页面实现。

package com.hb.studentmanager.ui;
import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTabbedPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.WindowConstants;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableModel;

import com.hb.studentmanager.action.SpeAction;
import com.hb.studentmanager.action.SpeSubAction;
/**
* This code was edited or generated using CloudGarden's Jigloo
* SWT/Swing GUI Builder, which is free for non-commercial
* use. If Jigloo is being used commercially (ie, by a corporation,
* company or business for any purpose whatever) then you
* should purchase a license for each developer using Jigloo.
* Please visit www.cloudgarden.com for details.
* Use of Jigloo implies acceptance of these licensing terms.
* A COMMERCIAL LICENSE HAS NOT BEEN PURCHASED FOR
* THIS MACHINE, SO JIGLOO OR THIS CODE CANNOT BE USED
* LEGALLY FOR ANY CORPORATE OR COMMERCIAL PURPOSE.
*/
public class SpeSubMainFrame extends javax.swing.JFrame {
	private JPanel panel;
	private JTable table;
	private JTextField jTextField2;
	private JLabel jLabel4;
	private JTextField subIdTextField;
	private JTextField jTextField1;
	private JTextField speNameTextField;
	private JTextField speIdTextField;
	private JLabel jLabel3;
	private JLabel jLabel2;
	private JButton selectjButton;
	private JLabel jLabel1;
	private JPanel panel2;
	private JLabel classjLabel;
	private JButton addjButton;
	private JButton updatejButton;
	private JButton deljButton;
	private JButton backjButton;
	private JTabbedPane tabbedPane;
	private JButton endButton;
	private JButton jButton2;
	private JButton jButton1;
	private JButton firstButton;
	private int row;
    private int page=1;
    private boolean selectflag=false;
	/**
	* Auto-generated main method to display this JFrame
	*/
	public static void main(String[] args) {
		SpeSubMainFrame inst = new SpeSubMainFrame();
		inst.setVisible(true);
	}
	
	public SpeSubMainFrame() {
		super("专业科目管理");
		initGUI();
		int width=Toolkit.getDefaultToolkit().getScreenSize().width;
		int height=Toolkit.getDefaultToolkit().getScreenSize().height;
		this.setLocation((width-630)/2, (height-450)/2);
		this.setResizable(false);
	}
	
	private void initGUI() {
		try {
			setDefaultCloseOperation(WindowConstants.DISPOSE_ON_CLOSE);
			getContentPane().setLayout(null);
			{
				panel = new JPanel();
				getContentPane().add(panel);
				panel.setBounds(2, 0, 616, 420);
				panel.setLayout(null);
				{
					TableModel tableModel = new DefaultTableModel(
						new String[][] { {"专业代号", "专业名称","科目代号", "科目名称", "科目学分" }, 
								{ "", "","", "", "" },
								{ "", "","", "", ""},
								{ "", "","", "", "" },
								{ "", "","", "", ""},
								{ "", "","", "", "" }},
						new String[] { "", "","", "", "" });
					table = new JTable();
					panel.add(table);
					table.setModel(tableModel);
					table.setBounds(0, 7, 616, 98);
					table.addMouseListener(new MouseAdapter() {
						public void mouseReleased(MouseEvent evt) {
							tableMouseReleased(evt);
						}
						public void mousePressed(MouseEvent evt) {
							tableMousePressed(evt);
						}
						public void mouseExited(MouseEvent evt) {
							tableMouseExited(evt);
						}
						public void mouseEntered(MouseEvent evt) {
							tableMouseEntered(evt);
						}
						public void mouseClicked(MouseEvent evt) {
							tableMouseClicked(evt);
						}
					});
					SpeSubAction ssa=new SpeSubAction();
					ssa.init(table,1);
					
				}
				{
					firstButton = new JButton();
					panel.add(firstButton);
					firstButton.setText("\u9996\u9875");
					firstButton.setBounds(21, 119, 77, 28);
					firstButton.addActionListener(new ActionListener() {
						public void actionPerformed(ActionEvent evt) {
							firstButtonActionPerformed(evt);
						}
					});
				}
				{
					jButton1 = new JButton();
					panel.add(jButton1);
					jButton1.setText("\u4e0a\u4e00\u9875");
					jButton1.setBounds(154, 119, 77, 28);
					jButton1.addActionListener(new ActionListener() {
						public void actionPerformed(ActionEvent evt) {
							jButton1ActionPerformed(evt);
						}
					});
				}
				{
					jButton2 = new JButton();
					panel.add(jButton2);
					jButton2.setText("\u4e0b\u4e00\u9875");
					jButton2.setBounds(364, 119, 77, 28);
					jButton2.addActionListener(new ActionListener() {
						public void actionPerformed(ActionEvent evt) {
							jButton2ActionPerformed(evt);
						}
					});
				}
				{
					endButton = new JButton();
					panel.add(endButton);
					endButton.setText("\u5c3e\u9875");
					endButton.setBounds(518, 119, 70, 28);
					endButton.addActionListener(new ActionListener() {
						public void actionPerformed(ActionEvent evt) {
							endButtonActionPerformed(evt);
						}
					});
				}
				{
					tabbedPane = new JTabbedPane();
					panel.add(tabbedPane);
					tabbedPane.setBounds(0, 168, 616, 189);
					{
						panel2 = new JPanel();
						tabbedPane.addTab("查询条件", null, panel2, null);
						panel2.setPreferredSize(new java.awt.Dimension(616, 163));
						panel2.setLayout(null);
						{
							classjLabel = new JLabel();
							panel2.add(classjLabel);
							classjLabel.setText("\u79d1\u76ee\u540d\u79f0\uff1a");
							classjLabel.setBounds(322, 77, 70, 14);
						}
						{
							jLabel1 = new JLabel();
							panel2.add(jLabel1);
							jLabel1.setText("\u79d1\u76ee\u4ee3\u53f7\uff1a");
							jLabel1.setBounds(28, 77, 77, 14);
						}
						{
							selectjButton = new JButton();
							panel2.add(selectjButton);
							selectjButton.setText("\u67e5\u8be2");
							selectjButton.setBounds(511, 126, 63, 28);
							selectjButton
								.addActionListener(new ActionListener() {
								public void actionPerformed(ActionEvent evt) {
									selectjButtonActionPerformed(evt);
								}
								});
						}
						{
							jLabel2 = new JLabel();
							panel2.add(jLabel2);
							jLabel2.setText("\u4e13\u4e1a\u540d\u79f0\uff1a");
							jLabel2.setBounds(322, 21, 70, 14);
						}
						{
							jLabel3 = new JLabel();
							panel2.add(jLabel3);
							jLabel3.setText("\u4e13\u4e1a\u4ee3\u53f7\uff1a");
							jLabel3.setBounds(28, 21, 77, 14);
						}
						{
							speIdTextField = new JTextField();
							panel2.add(speIdTextField);
							speIdTextField.setBounds(112, 21, 175, 28);
						}
						{
							speNameTextField = new JTextField();
							panel2.add(speNameTextField);
							speNameTextField.setBounds(399, 21, 189, 28);
						}
						{
							subIdTextField = new JTextField();
							panel2.add(subIdTextField);
							subIdTextField.setBounds(112, 70, 175, 28);
						}
						{
							jTextField1 = new JTextField();
							panel2.add(jTextField1);
							jTextField1.setBounds(399, 70, 189, 28);
						}
						{
							jLabel4 = new JLabel();
							panel2.add(jLabel4);
							jLabel4.setText("\u79d1\u76ee\u5b66\u5206\uff1a");
							jLabel4.setBounds(28, 126, 70, 21);
						}
						{
							jTextField2 = new JTextField();
							panel2.add(jTextField2);
							jTextField2.setBounds(112, 119, 175, 28);
						}
					}
				}
				{
					backjButton = new JButton();
					panel.add(backjButton);
					backjButton.setText("\u8fd4\u56de");
					backjButton.setBounds(399, 385, 77, 28);
					backjButton.addActionListener(new ActionListener() {
						public void actionPerformed(ActionEvent evt) {
							backjButtonActionPerformed(evt);
						}
					});
				}
				{
					deljButton = new JButton();
					panel.add(deljButton);
					deljButton.setText("\u5220\u9664");
					deljButton.setBounds(266, 385, 77, 28);
					deljButton.addActionListener(new ActionListener() {
						public void actionPerformed(ActionEvent evt) {
							deljButtonActionPerformed(evt);
						}
					});
				}
				{
					updatejButton = new JButton();
					panel.add(updatejButton);
					updatejButton.setText("\u4fee\u6539");
					updatejButton.setBounds(140, 385, 77, 28);
					updatejButton.addActionListener(new ActionListener() {
						public void actionPerformed(ActionEvent evt) {
							updatejButtonActionPerformed(evt);
						}
					});
				}
				{
					addjButton = new JButton();
					panel.add(addjButton);
					addjButton.setText("\u6dfb\u52a0");
					addjButton.setBounds(14, 385, 77, 28);
					addjButton.addActionListener(new ActionListener() {
						public void actionPerformed(ActionEvent evt) {
							addjButtonActionPerformed(evt);
						}
					});
				}
			}
			pack();
			this.setSize(630, 450);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	private void backjButtonActionPerformed(ActionEvent evt) {
		StudentManagerFrame smf=new StudentManagerFrame();
		this.setVisible(false);
		smf.setVisible(true);
	}	
	
	private void addjButtonActionPerformed(ActionEvent evt) {
		this.page=1;
		SpeSubAddFrame ssaf=new SpeSubAddFrame(table,page);
		this.selectflag=false;
		ssaf.setVisible(true);
	}
	
	private void updatejButtonActionPerformed(ActionEvent evt) {
		if(row==0||table.getValueAt(row, 0).equals("")){
			JOptionPane.showMessageDialog(this,"请先选择要修改的记录");	
		}
		else{
			SpeSubUpdateFrame ssuf=new SpeSubUpdateFrame(row,page,table);
		    ssuf.setVisible(true);
		}
	}
	
	private void firstButtonActionPerformed(ActionEvent evt) {
		SpeSubAction ssa=new SpeSubAction();
		if(this.page==1) JOptionPane.showMessageDialog(this,"本页为首页!");
		else {
			if(this.selectflag==false)
			ssa.init(table,1);
			else{
				String speId=speIdTextField.getText();
				String speName=speNameTextField.getText();
				String subId=subIdTextField.getText();
				String subName=jTextField1.getText();
				String subScore=jTextField2.getText();
				ssa.speSubSelect(table, 1, speId, speName, subId, subName,subScore);
			}
			this.page=1;
		}
	}
	
	private void jButton1ActionPerformed(ActionEvent evt) {
		SpeSubAction ssa=new SpeSubAction();
		if(this.page==1) JOptionPane.showMessageDialog(this,"本页为首页，没有上一页！");
		else {
			if(this.selectflag==false)
			ssa.init(table,--this.page);
			else{
				String speId=speIdTextField.getText();
				String speName=speNameTextField.getText();
				String subId=subIdTextField.getText();
				String subName=jTextField1.getText();
				String subScore=jTextField2.getText();
				ssa.speSubSelect(table, --this.page, speId, speName, subId, subName,subScore);
			}
		}
	}
	
	private void jButton2ActionPerformed(ActionEvent evt) {
		SpeSubAction ssa=new SpeSubAction();
		int temPage;
		String speId=speIdTextField.getText();
		String speName=speNameTextField.getText();
		String subId=subIdTextField.getText();
		String subName=jTextField1.getText();
		String subScore=jTextField2.getText();
		if(this.selectflag==false)
			temPage=ssa.pageCount();
		else
			temPage=ssa.pageCountSelect(speId, speName, subId, subName,subScore);
		if(this.page==temPage) JOptionPane.showMessageDialog(this,"本页为尾页，没有下一页！");
		else{
			if(this.selectflag==false)
			ssa.init(table,++this.page);
			else{
				ssa.speSubSelect(table, ++this.page, speId, speName, subId, subName,subScore);
			}
			}
	}
	
	private void endButtonActionPerformed(ActionEvent evt) {
		SpeSubAction ssa=new SpeSubAction();
		int temPage;
		String speId=speIdTextField.getText();
		String speName=speNameTextField.getText();
		String subId=subIdTextField.getText();
		String subName=jTextField1.getText();
		String subScore=jTextField2.getText();
		if(this.selectflag==false)
			temPage=ssa.pageCount();
		else
			temPage=ssa.pageCountSelect(speId, speName, subId, subName,subScore);
		System.out.println(temPage);
		if(this.page==temPage) JOptionPane.showMessageDialog(this,"本页为尾页！");
		else {
			if(this.selectflag==false){
				this.page=ssa.pageCount();
				ssa.init(table,page);
			}
			else{
				this.page=ssa.pageCountSelect(speId, speName, subId, subName,subScore);
				ssa.speSubSelect(table, page, speId, speName, subId, subName,subScore);
			}
			
		}	
	}
	
	private void selectjButtonActionPerformed(ActionEvent evt) {
		String speId=speIdTextField.getText();
		String speName=speNameTextField.getText();
		String subId=subIdTextField.getText();
		String subName=jTextField1.getText();
		String subScore=jTextField2.getText();
		if(speId.equals("")&&speName.equals("")&&subId.equals("")&&subName.equals("")&&subScore.equals("")){
			JOptionPane.showMessageDialog(this,"查询条件不能为空，请先输入查询条件！");
		}else if(speId.indexOf("'")!=-1||speId.indexOf("%")!=-1||speId.indexOf("_")!=-1||speName.indexOf("'")!=-1||speName.indexOf("%")!=-1||speName.indexOf("_")!=-1){
			JOptionPane.showMessageDialog(new JFrame(), "找不到和您的查询条件相符的记录。！");
		}else if(subId.indexOf("'")!=-1||subId.indexOf("%")!=-1||subId.indexOf("_")!=-1||subName.indexOf("'")!=-1||subName.indexOf("%")!=-1||subName.indexOf("_")!=-1||subScore.indexOf("'")!=-1||subScore.indexOf("%")!=-1||subScore.indexOf("_")!=-1){
			JOptionPane.showMessageDialog(new JFrame(), "找不到和您的查询条件相符的记录。！");
		}
		else{
			SpeSubAction sa=new SpeSubAction();
			this.selectflag=sa.speSubSelect(table,1,speId,speName,subId,subName,subScore);
			this.page=1;
		}
	}
	
	private void tableMouseClicked(MouseEvent evt) {
		row=table.getSelectedRow();
	}
	
	private void tableMouseEntered(MouseEvent evt) {}
	
	private void tableMouseExited(MouseEvent evt) {}
	
	private void tableMousePressed(MouseEvent evt) {}
	
	private void tableMouseReleased(MouseEvent evt) {}
	
	private void deljButtonActionPerformed(ActionEvent evt) {
		if(row==0||table.getValueAt(row, 0).equals("")){
			JOptionPane.showMessageDialog(this,"请先选择要删除的记录");	
		}
		else{
			int control=JOptionPane.showConfirmDialog(this, "真的要删除吗？","警告！",JOptionPane.OK_OPTION);
			if(JOptionPane.OK_OPTION==control){
			String speId=(String)table.getValueAt(row,0);
			String subId=(String)table.getValueAt(row,2);
			SpeSubAction ssa=new SpeSubAction();
			ssa.speSubDelete(speId,subId);
			ssa.init(table,this.page);
			}
		}
	}
}