majormagdialog.java

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

package com.hb.stumanagesys.basicinfomaintain;

import java.awt.BorderLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
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.JSeparator;
import javax.swing.JTabbedPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.SwingConstants;
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 MajorMagDialog extends javax.swing.JDialog {
	private JPanel majormagPanel;

	private JTextField majorNameTextField;

	private JLabel anLabel;

	private JComboBox querComboBox;

	private JScrollPane majorScrollPane;

	private JTabbedPane majorMagTabbedPane;

	private JButton newButton;

	private JSeparator jSeparator1;

	private JTextField majInfoTextField;

	private JLabel majInfoLabel;

	private JTextField commentTextField;

	private JButton querButton;

	private JButton exitButton;

	private JButton deleteButton;

	private JButton modifyButton;

	private JButton saveButton;

	private JLabel majorNameLabel;

	private JTextField majorIdTextField;

	private JLabel majorIdLabel;

	private JPanel MajorQueryPanel;

	private JSeparator majorEditSeparator2;

	private String[][] row;

	private String[] column = { "专业号", "专业名", "专业介绍" };

	private DefaultTableModel dataModel;

	private JTable majorTable;

	private DefaultTableModel majorTableModel;

	Vector rowData = new Vector();

	// String[][] rows = new String[][]{};

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

	public MajorMagDialog(JFrame frame) {
		super(frame);
		initGUI();
		// 初始化表格
		try {
			initTable();
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}

	private void initTable() throws Exception {
		// 建立一个JDBC对象
		JdbcConnct jdbcConnection = new JdbcConnct();
		// 定义Vector变量，存储从数据库查询来的信息
		Vector vecData = new Vector();
		// 定义SQL语句
		String strSQL = "select * from  major order by majorid ";

		majorTableModel = new DefaultTableModel(row, column);
		this.majorTable.setModel(majorTableModel);
		majorTable.getTableHeader().setBounds(0, 0, 469, -273);
		// this.CourseQueryTable.setRowMargin(20);
		// 获得数据
		vecData = jdbcConnection.getData(strSQL);
		// 依次为各行插入数据
		for (int i = 0; i < vecData.size(); i++) {
			majorTableModel.addRow((String[]) vecData.get(i));
		}

	}

	private void initGUI() {
		try {
			{
				this.setTitle("\u4e13\u4e1a\u7ba1\u7406");
				{
					majormagPanel = new JPanel();
					getContentPane().add(majormagPanel, BorderLayout.CENTER);
					majormagPanel.setLayout(null);
					majormagPanel.setBackground(new java.awt.Color(170, 173,
							242));
					{
						majorIdLabel = new JLabel();
						majormagPanel.add(majorIdLabel);
						majorIdLabel.setText("\u4e13\u4e1a\u53f7");
						majorIdLabel.setBounds(658, 56, 63, 28);
					}
					{
						majorIdTextField = new JTextField();
						majormagPanel.add(majorIdTextField);
						majorIdTextField.setBounds(728, 56, 133, 28);
					}
					{
						majorNameLabel = new JLabel();
						majormagPanel.add(majorNameLabel);
						majorNameLabel.setText("\u4e13\u4e1a\u540d");
						majorNameLabel.setBounds(658, 112, 63, 28);
					}
					{
						majorNameTextField = new JTextField();
						majormagPanel.add(majorNameTextField);
						majorNameTextField.setBounds(728, 112, 133, 28);
					}
					{
						saveButton = new JButton();
						majormagPanel.add(saveButton);
						saveButton.setText("\u4fdd\u5b58");
						saveButton.setBounds(798, 294, 70, 21);
						saveButton.addActionListener(new ActionListener() {
							public void actionPerformed(ActionEvent evt) {
								saveButtonActionPerformed(evt);
							}
						});
					}
					{
						modifyButton = new JButton();
						majormagPanel.add(modifyButton);
						modifyButton.setText("\u4fee\u6539");
						modifyButton.setBounds(686, 294, 70, 21);
						modifyButton.addActionListener(new ActionListener() {
							public void actionPerformed(ActionEvent evt) {
								modifyButtonactionPerformed(evt);
								// TODO add your code for
								// modifyButton.actionPerformed
							}
						});
					}
					{
						deleteButton = new JButton();
						majormagPanel.add(deleteButton);
						deleteButton.setText("\u5220\u9664");
						deleteButton.setBounds(798, 252, 70, 21);
						deleteButton.addActionListener(new ActionListener() {
							public void actionPerformed(ActionEvent evt) {
								deleteButtonActionPerformed(evt);
							}
						});
					}
					{
						exitButton = new JButton();
						majormagPanel.add(exitButton);
						exitButton.setText("\u9000\u51fa");
						exitButton.setBounds(805, 364, 63, 28);
						exitButton.addActionListener(new ActionListener() {
							public void actionPerformed(ActionEvent evt) {
								exitButtonActionPerformed(evt);
							}
						});
					}
					{
						majInfoLabel = new JLabel();
						majormagPanel.add(majInfoLabel);
						majInfoLabel.setText("\u4e13\u4e1a\u4ecb\u7ecd");
						majInfoLabel.setBounds(658, 168, 63, 28);
					}
					{
						majInfoTextField = new JTextField();
						majormagPanel.add(majInfoTextField);
						majInfoTextField.setBounds(728, 168, 133, 28);
					}
					{
						jSeparator1 = new JSeparator();
						majormagPanel.add(jSeparator1);
						jSeparator1.setBounds(651, 0, 14, 455);
						jSeparator1.setOrientation(SwingConstants.VERTICAL);
					}
					{
						majorMagTabbedPane = new JTabbedPane();
						majormagPanel.add(majorMagTabbedPane);
						majorMagTabbedPane.setBounds(21, 14, 525, 399);
						{
							MajorQueryPanel = new JPanel();
							MajorQueryPanel.setLayout(null);
							majorMagTabbedPane.addTab("专业查询", null,
									MajorQueryPanel, null);
							MajorQueryPanel
									.setPreferredSize(new java.awt.Dimension(
											470, 198));
							{
								majorScrollPane = new JScrollPane();
								MajorQueryPanel.add(majorScrollPane);
								majorScrollPane.setBounds(21, 98, 476, 266);
								{
									DefaultTableModel majorTableModel = new DefaultTableModel(
											row, column);
									majorTable = new JTable();
									majorScrollPane.setViewportView(majorTable);
									majorTable.setLayout(null);
									majorTable.setRowHeight(24);
									majorTable.setModel(majorTableModel);
									majorTable.setBounds(35, 196, 448, 322);
									majorTable
											.addMouseListener(new MouseAdapter() {
												public void mouseClicked(
														MouseEvent evt) {
													majorTableMouseClicked(evt);
												}
											});
									majorTableModel.addRow(rowData);
								}
							}
							{
								anLabel = new JLabel();
								MajorQueryPanel.add(anLabel);
								anLabel.setText("\u6309");
								anLabel.setBounds(28, 21, 35, 28);
							}
							{
								ComboBoxModel querComboBoxModel = new DefaultComboBoxModel(
										new String[] { "全部", "专业号", "专业名" });
								querComboBox = new JComboBox();
								MajorQueryPanel.add(querComboBox);
								querComboBox.setModel(querComboBoxModel);
								querComboBox.setBounds(70, 21, 77, 28);
							}
							{
								querButton = new JButton();
								MajorQueryPanel.add(querButton);
								querButton.setText("\u67e5\u8be2");
								querButton.setBounds(378, 14, 70, 21);
								querButton
										.addActionListener(new ActionListener() {
											public void actionPerformed(
													ActionEvent evt) {
												try {
													querButtonActionPerformed(evt);
												} catch (Exception e) {
													// TODO Auto-generated catch
													// block
													e.printStackTrace();
												}
												// TODO add your code for
												// querButton.actionPerformed
											}
										});
							}
							{
								commentTextField = new JTextField();
								MajorQueryPanel.add(commentTextField);
								commentTextField
										.setText("\u8bf7\u8f93\u5165\u67e5\u8be2\u6761\u4ef6");
								commentTextField.setBounds(161, 21, 119, 28);
								commentTextField
										.addMouseListener(new MouseAdapter() {
											public void mouseClicked(
													MouseEvent evt) {
												commentTextFieldMouseClicked(evt);
											}
										});
							}
						}
					}
					{
						majorEditSeparator2 = new JSeparator();
						majormagPanel.add(majorEditSeparator2);
						majorEditSeparator2.setBounds(651, 322, 245, 126);
					}
					{
						newButton = new JButton();
						majormagPanel.add(newButton);
						newButton.setText("\u65b0\u589e");
						newButton.setBounds(686, 252, 70, 21);
						newButton.addActionListener(new ActionListener() {
							public void actionPerformed(ActionEvent evt) {
								newButtonActionPerformed(evt);
							}
						});
					}
				}
			}
			this.setSize(900, 475);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	/**
	 * 获得最大专业号
	 * 
	 * @return
	 * @throws SQLException
	 */
	private long getMajorId() throws SQLException {

		// try {
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		long majorid = 0;
		conn = JdbcConnct.fetchConnection();
		stmt = conn.createStatement();
		String sql = "select max(majorid) from  major";
		rs = stmt.executeQuery(sql);

		while (rs.next()) {
			majorid = rs.getLong(1);
			System.out.println(majorid);
		}
		// while (rs.next()) {
		// majorid = rs.getLong("majorid");
		// }
		rs.close();
		stmt.close();
		conn.close();
		if (majorid == 0) {
			return 0;
		} else
			return majorid + 1;
		// } catch (Exception e) {
		// // e.printStackTrace();
		// return 0;
		// }

	}

	/**
	 * 获得majorName
	 * 
	 * @return
	 */
	private String getMajorName() {
		String majorName = this.majorNameTextField.getText();
		// if (majorName.equals("")) {
		// JOptionPane.showMessageDialog(this, "专业名不可为空!");
		// }
		return majorName;