presentdialog.java

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

package com.hb.stumanagesys.basicinfomaintain;
import com.cloudgarden.layout.AnchorConstraint;
import com.cloudgarden.layout.AnchorLayout;
import com.hb.jdbcconnct.JdbcConnct;
import com.hb.stumanagesys.CalendarJDialog;
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.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.JCheckBox;
import javax.swing.JComboBox;

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.JTextField;
import javax.swing.SwingConstants;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableModel;

/**
* 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 presentDialog extends javax.swing.JDialog {

	{
		//Set Look & Feel
//		try {
//			javax.swing.UIManager.setLookAndFeel("com.jgoodies.looks.plastic.Plastic3DLookAndFeel");
//		} catch(Exception e) {
//			e.printStackTrace();
//		}
	}

	private JPanel presentPanel;
	private JTextField presentDateTextField;
	private JButton querButton;
	private JLabel jLabel1;
	private JCheckBox misCheckBox;
	private JTextField presentIdTextField;
	private JLabel presentIdLabel;
	private JButton saveButton;
	private JScrollPane presentScrollPane1;
	private JTable prensentTable1;
	private JTextField querTextField1;
	private JComboBox querConditionComboBox1;
	private ButtonGroup buttonGroup1;
	private JButton exitButton;
	private JButton deleteButton;
	private JButton modifyButton;
	private JPanel presentManagePanel;
	private JTabbedPane presentManageTabbedPane1;
	private JSeparator jSeparator2;
	private JButton addButton;
	private JSeparator jSeparator1;
	private JComboBox presentStatusComboBox;
	private JTextField studentIdTextField;
	private JLabel presentStatusLabel;
	private JLabel studentIdLabel;
	private JLabel presentDateLabel;
	//定义表格模型
	DefaultTableModel dataModel;
	DefaultTableModel prensentTable1Model;
	//定义输入的正则表达式
    //出勤号表达式
	public final static String REG_DIGPRESENTID = "[1-9]\\d{0,6}";
	//查询条件输入中的学号
	public final static String REG_DIGSTUDENTID = "[1-9]\\d{0,6}";
	

	/**
	* Auto-generated main method to display this JDialog
	*/
	public static void main(String[] args) {
		JFrame frame = new JFrame();
		presentDialog inst = new presentDialog(frame);
		inst.setVisible(true);
	}
	
	public presentDialog(JFrame frame) {
		super(frame);
		initGUI();
	}
	
	private void initGUI() {
		try {
			{
				getContentPane().setLayout(null);
				this.setTitle("\u51fa\u52e4\u7ba1\u7406");
				{
					{
						buttonGroup1 = new ButtonGroup();
					}
					presentPanel = new JPanel();
					getContentPane().add(presentPanel);
					presentPanel.setBounds(0, 0, 896, 553);
					presentPanel.setLayout(null);
					presentPanel.setBackground(new java.awt.Color(185,185,255));
					{
						saveButton = new JButton();
						presentPanel.add(saveButton);
						saveButton.setText("\u786e\u5b9a");
						saveButton.setBounds(770, 294, 70, 21);
						saveButton.addActionListener(new ActionListener() {
							public void actionPerformed(ActionEvent evt) {
								okButtonActionPerformed(evt);
							}
						});
					}
					{
						exitButton = new JButton();
						presentPanel.add(exitButton);
						exitButton.setText("\u9000\u51fa");
						exitButton.setBounds(798, 378, 63, 28);
						exitButton.addActionListener(new ActionListener() {
							public void actionPerformed(ActionEvent evt) {
								exitButtonActionPerformed(evt);
							}
						});
					}
					{
						deleteButton = new JButton();
						presentPanel.add(deleteButton);
						deleteButton.setText("\u5220\u9664");
						deleteButton.setBounds(770, 245, 70, 21);
						deleteButton.addActionListener(new ActionListener() {
							public void actionPerformed(ActionEvent evt) {
								deleteButtonActionPerformed(evt);
							}
						});
					}
					{
						modifyButton = new JButton();
						presentPanel.add(modifyButton);
						modifyButton.setText("\u4fee\u6539");
						modifyButton.setBounds(665, 294, 70, 21);
						modifyButton.addActionListener(new ActionListener() {
							public void actionPerformed(ActionEvent evt) {
								modifyButtonActionPerformed(evt);
							}
						});
					}
					{
						addButton = new JButton();
						presentPanel.add(addButton);
						addButton.setText("\u589e\u52a0");
						addButton.setBounds(665, 245, 70, 21);
						addButton.addActionListener(new ActionListener() {
							public void actionPerformed(ActionEvent evt) {
								addButtonActionPerformed(evt);
							}
						});
					}
					{
						jSeparator1 = new JSeparator();
						presentPanel.add(jSeparator1);
						jSeparator1.setBounds(623, 0, 35, 448);
						jSeparator1.setOrientation(SwingConstants.VERTICAL);
					}
					{
						ComboBoxModel presentStatusComboBoxModel = new DefaultComboBoxModel(
							new String[] { "出勤"
									, "迟到" 
									, "早退"
									, "病假"
									, "事假"});
						presentStatusComboBox = new JComboBox();
						presentPanel.add(presentStatusComboBox);
						presentStatusComboBox
							.setModel(presentStatusComboBoxModel);
						presentStatusComboBox.setBounds(749, 161, 63, 28);
					}
					{
						studentIdTextField = new JTextField();
						presentPanel.add(studentIdTextField);
						studentIdTextField.setBounds(749, 119, 91, 28);
						
					}
					{
						presentDateTextField = new JTextField();
						presentPanel.add(presentDateTextField);
						presentDateTextField.setBounds(749, 84, 91, 28);
						presentDateTextField
							.addMouseListener(new MouseAdapter() {
							public void mouseClicked(MouseEvent evt) {
								presentDateTextFieldMouseClicked(evt);
							}
							});
					}
					{
						presentStatusLabel = new JLabel();
						presentPanel.add(presentStatusLabel);
						presentStatusLabel.setText("\u72b6\u6001\uff1a");
						presentStatusLabel.setBounds(686, 161, 63, 28);
					}
					{
						studentIdLabel = new JLabel();
						presentPanel.add(studentIdLabel);
						studentIdLabel.setText("\u5b66\u53f7");
						studentIdLabel.setBounds(686, 119, 63, 28);
					}
					{
						presentDateLabel = new JLabel();
						presentPanel.add(presentDateLabel);
						presentDateLabel.setText("\u8bb0\u5f55\u65e5\u671f");
						presentDateLabel.setBounds(686, 84, 63, 28);
					}
					{
						presentIdLabel = new JLabel();
						presentPanel.add(presentIdLabel);
						presentIdLabel.setText("\u51fa\u52e4\u53f7\uff1a");
						presentIdLabel.setBounds(686, 42, 63, 28);
					}
					{
						presentIdTextField = new JTextField();
						presentPanel.add(presentIdTextField);
						presentIdTextField.setBounds(749, 42, 91, 28);
						presentIdTextField.setEditable(false);
						
					}
					{
						jSeparator2 = new JSeparator();
						presentPanel.add(jSeparator2);
						jSeparator2.setBounds(623, 343, 273, 105);
					}
					{
						presentManageTabbedPane1 = new JTabbedPane();
						presentPanel.add(presentManageTabbedPane1);
						presentManageTabbedPane1.setBounds(21, 7, 553, 420);
						{
							presentManagePanel = new JPanel();
							presentManageTabbedPane1.addTab(
								"出勤管理",
								null,
								presentManagePanel,
								null);
							presentManagePanel.setLayout(null);
							{
								presentScrollPane1 = new JScrollPane();
								presentManagePanel.add(presentScrollPane1);
								presentScrollPane1.setBounds(21, 63, 483, 315);
								{
									prensentTable1Model = new DefaultTableModel(
										new String[][] {},
										new String[] { "出勤号", "出勤时间", "学号",
												"姓名", "出勤状态" });
									prensentTable1 = new JTable();
									BorderLayout prensentTable1Layout = new BorderLayout();
									presentScrollPane1
										.setViewportView(prensentTable1);
									prensentTable1
										.setLayout(prensentTable1Layout);
									prensentTable1
										.setModel(prensentTable1Model);
									prensentTable1.setBounds(0, 133, 427, 735);
									prensentTable1
										.setPreferredSize(new java.awt.Dimension(
											430,
											575));
									prensentTable1.getTableHeader()
										.setPreferredSize(
											new java.awt.Dimension(430, 16));
								}
							}
							{
								jLabel1 = new JLabel();
								presentManagePanel.add(jLabel1);
								jLabel1.setText("\u6309\uff1a");
								jLabel1.setBounds(35, 14, 56, 28);
							}
							{
								ComboBoxModel querjComboBox1Model = new DefaultComboBoxModel(
									new String[] { "全部", "流水号", "学号" });
								querConditionComboBox1 = new JComboBox();
								presentManagePanel.add(querConditionComboBox1);
								querConditionComboBox1
									.setModel(querjComboBox1Model);
								querConditionComboBox1.setBounds(91, 14, 70, 28);
								querConditionComboBox1.setSize(98, 28);
								querConditionComboBox1
									.addActionListener(new ActionListener() {
										public void actionPerformed(
											ActionEvent evt) {
											querjComboBox1ActionPerformed(evt);
										}
									});
							}
							{
								querTextField1 = new JTextField();
								presentManagePanel.add(querTextField1);
								querTextField1.setBounds(203, 14, 98, 28);
							}
							{
								misCheckBox = new JCheckBox();
								presentManagePanel.add(misCheckBox);
								misCheckBox.setText("\u6a21\u7cca\u67e5\u8be2");
								misCheckBox.setBounds(322, 14, 91, 28);
								misCheckBox.setEnabled(false);
							}
							{
								querButton = new JButton();
								presentManagePanel.add(querButton);
								querButton.setText("\u67e5\u8be2");
								querButton.setBounds(441, 14, 63, 28);
								querButton
									.addActionListener(new ActionListener() {
										public void actionPerformed(
											ActionEvent evt) {
											querButtonActionPerformed(evt);
										}
									});
							}
						}
					}
				}
			}
			setSize(900,475);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	/**
	 * 根据用户选择在数据库中查询
	 * @param sql
	 */
	 
	public void initialTable(String sql)
	{
		//定义可变长向量 来存储查询出来的信息
		Vector temp = new Vector();
		//定义连接
		Connection conn = null;
		//定义Statement
		Statement stmt = null;
		//定义结果集
		ResultSet rs = null;
	
		try {
			//获取一个连接
			conn = JdbcConnct.fetchConnection();
           //用来查询的SQL语句
			String sql1 = "select presentid,to_char(presentDate,'yyyy-mm-dd ') presentDate,studentId,stuname,presentStatus from " +
					" present_stu " +sql;
			//创建一个statment
			stmt = conn.createStatement();
			//得到一个结果集
			rs = stmt.executeQuery(sql1);
			//对结果集进行操作
			while(rs.next()){
				//定义一个status，并按照数据字典转化。
				String status = rs.getString("presentStatus");
				String presentStatus = null;
				if(status.equals("1"))
					presentStatus = "出勤";
				else if(status.equals("2"))
					presentStatus ="迟到" ;
				else if(status.equals("3"))
					presentStatus = "早退" ;
				else if(status.equals("4"))
					presentStatus ="病假" ;
				else if(status.equals("5"))
					presentStatus ="事假" ;	
				//将结果显示到向量中
				temp.addElement((String)rs.getString("presentId"));
				temp.addElement((String)rs.getString("presentDate"));
				temp.addElement((String)rs.getString("studentId"));
				temp.addElement((String)rs.getString("stuname"));
				temp.addElement(presentStatus);
			}
			 int row = temp.size()/5;
			 if(row!=0){
			 String [] title=new String[]{"出勤号","出勤时间","学号","姓名","出勤状态"};
			 String[][] aa = new String [row][5] ;
			
			 for(int i=0;i<row;i++)
			 {
				for(int k=0;k<5;k++)
				{
					aa[i][k] = (String)temp.elementAt(i*5+k);