stumagdialog.java

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

package com.hb.stumanagesys.basicinfomaintain;

//import FileFilter;

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.io.BufferedReader;
import java.io.File;
import java.io.InputStreamReader;
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.BoxLayout;

import javax.swing.ButtonGroup;
import javax.swing.ComboBoxModel;
import javax.swing.DefaultComboBoxModel;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFileChooser;

import javax.swing.ImageIcon;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JRadioButton;
import javax.swing.JScrollPane;
import javax.swing.JSeparator;
import javax.swing.JTabbedPane;
import javax.swing.JTable;
import javax.swing.JTextArea;
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 StuMagDialog extends javax.swing.JDialog {
	private JPanel stumagPanel;

	private JSeparator student2Separator;

	private JSeparator student1Separator;
	private JPanel stuManagePanel;
	private JTabbedPane stuManageTabbedPane;

	private JButton viewButton1;

	private JTextField commentTextField;

	private JComboBox selectComboBox;

	private JLabel anLabel;

	private JButton exsitButton;

	private JScrollPane stuScrollPane;

	private JTable stuTable;

	private JButton querButton;

	private JButton deleteButton;

	private JButton commitButton;

	private JButton addButton;

	private ButtonGroup genderbuttonGroup;

	// DefaultComboBoxModel majornameComboBoxModel = new DefaultComboBoxModel();

	protected DefaultTableModel stuTableModel; // 定义一个默认模式

	DefaultTableModel jTable1Model;

	String[] coloumn = { "学号", "姓名", "性别", "年龄", "政治面貌", "出生日期", "联系方式", "籍贯",
			"入学时间", "状态", "班级名称", "个人信息", "备注", "照片" };

	String[] coloumn2 = { "学号", "班级名称", "专业", "姓名", "性别", "年龄", "政治面貌", "出生日期",
			"联系方式", "籍贯", "个人信息", "入学时间", "状态", "备注", "照片" };

	String[][] row;

	String[] coloumn1 = { "", "", "", "", "", "", "", "", "", "", "" };

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

	}

	public StuMagDialog(JFrame frame) {
		super(frame);
		initGUI();
		try {
			initTable();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	private void initGUI() {
		try {
			{
				getContentPane().setBackground(new java.awt.Color(0, 128, 255));
				this.setTitle("\u5b66\u751f\u4fe1\u606f\u7ba1\u7406");
				getContentPane().setLayout(null);
				{
					{
						genderbuttonGroup = new ButtonGroup();
					}
					stumagPanel = new JPanel();
					getContentPane().add(stumagPanel);
					stumagPanel
							.setBackground(new java.awt.Color(185, 185, 255));
					stumagPanel.setLayout(null);
					stumagPanel.setBounds(0, 0, 966, 581);
					{
						addButton = new JButton();
						stumagPanel.add(addButton);
						addButton.setText("\u6dfb\u52a0");
						addButton.setBounds(679, 252, 70, 21);
						addButton.addActionListener(new ActionListener() {
							public void actionPerformed(ActionEvent evt) {
								addButtonActionPerformed(evt);

							}
						});
					}
					{
						commitButton = new JButton();
						stumagPanel.add(commitButton);
						commitButton.setText("\u7f16\u8f91");
						commitButton.setBounds(679, 287, 70, 21);
						commitButton.addActionListener(new ActionListener() {
							public void actionPerformed(ActionEvent evt) {
								commitButtonActionPerformed(evt);
							}
						});
					}
					{
						deleteButton = new JButton();
						stumagPanel.add(deleteButton);
						deleteButton.setText("\u5220\u9664");
						deleteButton.setBounds(791, 252, 70, 21);
						deleteButton.addActionListener(new ActionListener() {
							public void actionPerformed(ActionEvent evt) {
								deleteButtonActionPerformed(evt);
							}
						});
					}
					{
						exsitButton = new JButton();
						stumagPanel.add(exsitButton);
						exsitButton.setText("\u9000\u51fa");
						exsitButton.setBounds(798, 357, 70, 28);
						exsitButton.addActionListener(new ActionListener() {
							public void actionPerformed(ActionEvent evt) {
								exsitButtonActionPerformed(evt);
							}
						});
					}
					{
						student1Separator = new JSeparator();
						stumagPanel.add(student1Separator);
						student1Separator.setBounds(637, 0, 28, 560);
						student1Separator
								.setOrientation(SwingConstants.VERTICAL);
					}
					{
						student2Separator = new JSeparator();
						stumagPanel.add(student2Separator);
						student2Separator.setBounds(637, 322, 259, 35);
					}
					{
						viewButton1 = new JButton();
						stumagPanel.add(viewButton1);
						viewButton1.setText("\u67e5\u770b");
						viewButton1.setBounds(791, 287, 70, 21);
						viewButton1.addActionListener(new ActionListener() {
							public void actionPerformed(ActionEvent evt) {
								viewButton1ActionPerformed(evt);
							}
						});
					}
					{
						stuManageTabbedPane = new JTabbedPane();
						stumagPanel.add(stuManageTabbedPane);
						stuManageTabbedPane.setBounds(21, 21, 553, 392);
						{
							stuManagePanel = new JPanel();
							stuManageTabbedPane.addTab(
								"学生管理",
								null,
								stuManagePanel,
								null);
							stuManagePanel.setPreferredSize(new java.awt.Dimension(443, 324));
							stuManagePanel.setLayout(null);
							{
								stuScrollPane = new JScrollPane();
								stuManagePanel.add(stuScrollPane);
								stuScrollPane.setBounds(21, 63, 504, 287);
								stuScrollPane.setFocusable(false);
								{
									stuTableModel = new DefaultTableModel(
										new String[][] {
												{ "1", "张三", "男", "22", "党员",
														"1986-2-3", "13555555",
														"湖北", "2008-6-1", "在读" },
												{ "2", "李四", "男", "22", "共青团员",
														"1986-8-23", "133456",
														"湖北", "2008-6-1", "在读" } },

										new String[] { "学号", "姓名", "性别", "年龄",
												"政治面貌", "出生日期", "联系方式", "籍贯",
												"入学时间", "状态", });
									stuTable = new JTable();
									stuScrollPane.setViewportView(stuTable);
									stuTable.setLayout(null);
									stuTable.setModel(stuTableModel);
									stuTable.setBounds(-14, 70, 497, 70);
									// stuTable.setCellSelectionEnabled(true);
									stuTable.setRowSelectionAllowed(true);
									stuTable
										.addMouseListener(new MouseAdapter() {
										public void mouseClicked(MouseEvent evt) {
											stuTableMouseClicked(evt);
										}
										});
								}
							}
							{
								querButton = new JButton();
								stuManagePanel.add(querButton);
								querButton.setText("\u67e5\u8be2");
								querButton.setBounds(322, 14, 70, 28);
								querButton.setSize(70, 21);
								querButton
									.addActionListener(new ActionListener() {
										public void actionPerformed(
											ActionEvent evt) {
											querButtonActionPerformed(evt);
										}
									});
							}
							{
								commentTextField = new JTextField();
								stuManagePanel.add(commentTextField);
								commentTextField
									.setText("\u8f93\u5165\u67e5\u8be2\u6761\u4ef6");
								commentTextField.setBounds(182, 14, 98, 28);
							}
							{
								ComboBoxModel selectComboBoxModel = new DefaultComboBoxModel(
									new String[] { "全部", "学号", "姓名", "年龄" });
								selectComboBox = new JComboBox();
								stuManagePanel.add(selectComboBox);
								selectComboBox.setModel(selectComboBoxModel);
								selectComboBox.setBounds(77, 14, 77, 28);
								selectComboBox
									.addActionListener(new ActionListener() {
										public void actionPerformed(
											ActionEvent evt) {
											selectComboBoxActionPerformed(evt);
										}
									});
							}
							{
								anLabel = new JLabel();
								stuManagePanel.add(anLabel);
								anLabel.setText("\u6309");
								anLabel.setBounds(21, 14, 42, 28);
							}
						}
					}
				}
			}
			this.setSize(900, 475);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	/**
	 * 取得专业名称
	 * 
	 * @return
	 */

	public String[] getMajorName() {
		try {
			// Class.forName("oracle.jdbc.driver.OracleDriver");
			// String url = "jdbc:oracle:thin:@192.168.111.79:1521:orcl";
			// String user = "zlb";
			// String pwd = "hb2080";
			Connection conn = null;
			Statement stmt = null;
			ResultSet rs = null;
			Vector majorVector = new Vector();
			conn = JdbcConnct.fetchConnection();
			String sql = "select majorname from major ";
			stmt = conn.createStatement();
			rs = stmt.executeQuery(sql);
			while (rs.next()) {
				majorVector.addElement((String) rs.getString(1));
			}
			String[] studentName = new String[majorVector.size()];
			for (int i = 0; i < majorVector.size(); i++) {
				studentName[i] = (String) majorVector.elementAt(i);
				// System.out.println(studentName[i]);
			}
			rs.close();
			stmt.close();
			conn.close();
			return studentName;
		} catch (Exception e) {
			e.printStackTrace();
			return null;
		}
	}

	// public String [] getClassName()

	public int getmajorId(String majorName) {
		try {
			// Class.forName("oracle.jdbc.driver.OracleDriver");
			// String url = "jdbc:oracle:thin:@192.168.111.79:1521:orcl";
			// String user = "zlb";
			// String pwd = "hb2080";
			Connection conn = null;
			PreparedStatement stmt = null;
			ResultSet rs = null;
			int majorid = 0;
			conn = conn = JdbcConnct.fetchConnection();
			String sql = "select majorid from major where majorname = ?";
			stmt = conn.prepareStatement(sql);
			stmt.setString(1, majorName);