selectexamdialog.java

学生管理系统。使用java编程

package com.hb.stumanagesys.basicinfomaintain;

import java.awt.BorderLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.SQLException;
import java.util.Vector;
import javax.swing.ComboBoxModel;
import javax.swing.DefaultComboBoxModel;

import javax.swing.JButton;
import javax.swing.JComboBox;

import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableModel;

import com.hb.jdbcconnct.JdbcConnct;

/**
 * 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 SelectExamDialog extends javax.swing.JDialog {
	private JPanel examQueryPanel;

	private JTable examQueryTable;

	private DefaultTableModel examSelModel = new DefaultTableModel();

	private String[] column = { "科目号", "科目名", "监考教师工号", "监考人姓名", "开始时间",
			"结束时间", "考试地点", "考试类型", "参考人数", "备注" };;// 表列

	private String[][] row;// 表行

	private JButton turnButton;
	private JComboBox jComboBox1;
	private JLabel jLabel1;

	private JButton selectButton;

	private JTextField subNameTextField;

	private JLabel subNameLabel;

	private JTextField subIDTextField;

	private JLabel subIDLabel;

	private JButton queryButton;

	private JScrollPane examQueryScrollPane;

	/**
	 * Auto-generated main method to display this JDialog
	 */
	public static void main(String[] args) {
		JFrame frame = new JFrame();
		SelectExamDialog inst = new SelectExamDialog(frame);
		inst.setVisible(true);
	}

	public SelectExamDialog(JFrame frame) {
		super(frame);
		initGUI();
	}

	private void initGUI() {
		try {
			this.setTitle("考试安排综合查询");
			{
				examQueryPanel = new JPanel();
				getContentPane().add(examQueryPanel, BorderLayout.CENTER);
				examQueryPanel.setLayout(null);
				examQueryPanel.setBackground(new java.awt.Color(170, 173, 242));
				examQueryPanel.setPreferredSize(new java.awt.Dimension(861, 441));
				{
					examQueryScrollPane = new JScrollPane();
					examQueryPanel.add(examQueryScrollPane);
					examQueryScrollPane.setBounds(7, 7, 756, 420);
					{
						TableModel examQueryTableModel = new DefaultTableModel(
							row,
							column);
						examQueryTable = new JTable();
						examQueryScrollPane.setViewportView(examQueryTable);
						examQueryTable.setModel(examQueryTableModel);
						examQueryTable.setRowHeight(24);
						examQueryTable.setBounds(14, 14, 742, 399);
					}
				}
				{
					queryButton = new JButton();
					examQueryPanel.add(queryButton);
					queryButton.setText("\u5168\u90e8");
					queryButton.setBounds(798, 329, 63, 28);
					queryButton.addActionListener(new ActionListener() {
						public void actionPerformed(ActionEvent evt) {
							queryButtonActionPerformed(evt);
						}
					});
				}
				{
					turnButton = new JButton();
					examQueryPanel.add(turnButton);
					turnButton.setText("\u8fd4\u56de");
					turnButton.setBounds(798, 392, 63, 28);
					turnButton.addActionListener(new ActionListener() {
						public void actionPerformed(ActionEvent evt) {
							turnButtonActionPerformed(evt);
						}
					});
				}
				{
					subIDLabel = new JLabel();
					examQueryPanel.add(subIDLabel);
					subIDLabel.setText("\u79d1\u76ee\u53f7:");
					subIDLabel.setBounds(770, 7, 56, 28);
				}
				{
					subIDTextField = new JTextField();
					examQueryPanel.add(subIDTextField);
					subIDTextField.setBounds(798, 42, 84, 28);
				}
				{
					subNameLabel = new JLabel();
					examQueryPanel.add(subNameLabel);
					subNameLabel.setBounds(770, 91, 56, 28);
					subNameLabel.setText("\u79d1\u76ee\u540d:");
				}
				{
					subNameTextField = new JTextField();
					examQueryPanel.add(subNameTextField);
					subNameTextField.setBounds(798, 126, 84, 28);
				}
				{
					selectButton = new JButton();
					examQueryPanel.add(selectButton);
					selectButton.setText("\u67e5\u8be2");
					selectButton.setBounds(812, 238, 63, 28);
					selectButton.addActionListener(new ActionListener() {
						public void actionPerformed(ActionEvent evt) {
							selectButtonActionPerformed(evt);
						}
					});
				}
				{
					jLabel1 = new JLabel();
					examQueryPanel.add(jLabel1);
					jLabel1.setText("\u6309");
					jLabel1.setBounds(770, 182, 35, 28);
				}
				{
					ComboBoxModel jComboBox1Model = new DefaultComboBoxModel(
						new String[] { "科目号", "科目名" });
					jComboBox1 = new JComboBox();
					examQueryPanel.add(jComboBox1);
					jComboBox1.setModel(jComboBox1Model);
					jComboBox1.setBounds(805, 182, 70, 28);
				}
			}
			this.setSize(900, 475);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	private void turnButtonActionPerformed(ActionEvent evt) {
		this.dispose();
	}

	private void queryButtonActionPerformed(ActionEvent evt) {
		// 建立一个JDBC对象
		JdbcConnct jdbcConnection = new JdbcConnct();
		// 定义Vector变量，存储从数据库查询来的信息
		Vector vecData = new Vector();

		// String[] column
		// ={"科目号","科目名","监考教师工号","监考人姓名","开始时间","结果时间","考试地点","考试类型","参考人数","备注"};
		String sql = "select e.courseid,c.coursename,e.teacherid,t.teachername,e.begintime,e.endtime,e.examplace,e.examtype,e.presentnum,e.remark "
				+ " from exam e,course c,teacher t "
				+ " where e.courseid = c.courseid and t.teacherid = e.teacherid";

		examSelModel = new DefaultTableModel(row, column);
		this.examQueryTable.setModel(examSelModel);
		examQueryTable.getTableHeader().setBounds(0, 0, 169, 234);

		try {
			vecData = jdbcConnection.getData(sql);
			for (int i = 0; i < vecData.size(); i++) {
				examSelModel.addRow((String[]) vecData.get(i));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	private void selectButtonActionPerformed(ActionEvent evt) {
		JdbcConnct jdbcConnection = new JdbcConnct();
		String sql=null;
		// 定义Vector变量，存储从数据库查询来的信息
		Vector vecData = new Vector();
		if(this.jComboBox1.getSelectedItem().toString().equals("科目号")){
		sql = "select * from examQuery_v where courseid = "+getCourseId();
		}
		else{
			sql="select * from examQuery_v where courseName like '%"+getCourseName()+"%'";
		}
		examSelModel = new DefaultTableModel(row, column);
		this.examQueryTable.setModel(examSelModel);
		examQueryTable.getTableHeader().setBounds(0, 0, 169, 234);

		try {
			vecData = jdbcConnection.getData(sql);
			
			if(vecData.size() == 0){
				JOptionPane.showMessageDialog(this, "没有要查询的记录");
			}
			
			for (int i = 0; i < vecData.size(); i++) {
				examSelModel.addRow((String[]) vecData.get(i));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}

	private String getCourseName() {
		String name = this.subNameTextField.getText().toString().trim();
		if(name == null){
			name ="";
		}
		return name;
	}

	private long getCourseId() {
		try{
			long id = Long.parseLong(this.subIDTextField.getText().toString().trim());
			return id;
		}catch(NumberFormatException e)
		{	
//			JOptionPane.showMessageDialog(this,"ID请输入数字 切记");
			return 0;
		}
	}

}