cstuadddlg.java

java版的windows界面的学生管理系统

package ui;

import java.awt.event.*;
import java.util.ArrayList;

import javax.swing.*;
import javax.swing.border.LineBorder;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableModel;

import main.CMain;

import value.*;

/**
 * 
 * <p>标题:CStuAddDlg</p>
 * <p>描述:添加学生信息窗体类</p>
 * <p>作者@author:陈新</p>
 * <p>公司:com.thinkbank.04024</p>
 * <p>版权:Copyrigth (c) 2005 </p>
 * <p>编写日期:2005-10-10</p>
 * <p>版本号@version 1.0.06.01 
 */

public class CStuAddDlg extends javax.swing.JDialog {
    private JButton jBtnCancel;//取消
    private JButton jBtnSubmit;//确定
    

    private JComboBox jCmbStuSex;//性别选择
    private JComboBox jStuClass;//班级选择
    private JTextField jStuNameTxt;//姓名
    
    private JLabel jStuNewId;//生成的新学号
    
    //只显示，不使用
    private JLabel jStuClsid;
    private JLabel jStuID;
    private JLabel jStuName;
    private JLabel jStuSex;

    
    public CStuAddDlg(JFrame frame) {
        super(frame);
        initGUI();
        showNewID();
        
    }
    /**
     * 
     * <p>描述:显示新生成学号方法</p>
     *
     *
     */
    private void showNewID(){
        String newID = null;
        CStuDAO stuDAO = new CStuDAO();
        newID = stuDAO.newStuID();
        this.jStuNewId.setText(newID);
    }
/**
 * 
 * <p>描述:窗体初始化方法</p>
 *
 *
 */
    private void initGUI() {
        try {
            this.setResizable(false);
            this.setTitle("添加学员信息");
            this.getContentPane().setLayout(null);
            {
                jStuName = new JLabel();
                this.getContentPane().add(jStuName);
                jStuName.setText("学员姓名");
                jStuName.setLayout(null);
                jStuName.setBounds(54, 61, 85, 25);
            }
            {
                jStuClsid = new JLabel();
                this.getContentPane().add(jStuClsid);
                jStuClsid.setText("所在班级");
                jStuClsid.setLayout(null);
                jStuClsid.setBounds(53, 91, 85, 25);
            }
            {
                jStuSex = new JLabel();
                this.getContentPane().add(jStuSex);
                jStuSex.setText("学员性别");
                jStuSex.setLayout(null);
                jStuSex.setBounds(54, 121, 85, 25);
            }
            {
                jStuID = new JLabel();
                this.getContentPane().add(jStuID);
                jStuID.setText("学员学号");
                jStuID.setLayout(null);
                jStuID.setBounds(55, 31, 85, 25);
            }
            {
                jStuNewId = new JLabel();
                this.getContentPane().add(jStuNewId);
                jStuNewId.setText("新学员号");
                jStuNewId.setLayout(null);
                jStuNewId.setBounds(153, 31, 91, 23);
                jStuNewId.setBorder(new LineBorder(new java.awt.Color(0,0,0), 1, false));
            }
            {
                jStuNameTxt = new JTextField();
                this.getContentPane().add(jStuNameTxt);
                jStuNameTxt.setBounds(151, 65, 97, 23);
            }
            {


                jStuClass = new JComboBox();
                this.getContentPane().add(jStuClass);
                this.cmbInit();
                jStuClass.setBounds(151, 94, 96, 20);
            }
            {
                ComboBoxModel jComboBox1Model = new DefaultComboBoxModel(
                    new String[] {"","男", "女" });
                jCmbStuSex = new JComboBox();
                this.getContentPane().add(jCmbStuSex);
                jCmbStuSex.setModel(jComboBox1Model);
                jCmbStuSex.setBounds(151, 122, 97, 20);
            }
            {
                jBtnSubmit = new JButton();
                this.getContentPane().add(jBtnSubmit);
                jBtnSubmit.setText("确定");
                jBtnSubmit.setBounds(77, 166, 60, 30);
                jBtnSubmit.addActionListener(new ActionListener() {
                    public void actionPerformed(ActionEvent evt) {
                        jBtnSubmitActionPerformed(evt);
                    }
                });
            }
            {
                jBtnCancel = new JButton();
                this.getContentPane().add(jBtnCancel);
                jBtnCancel.setText("取消");
                jBtnCancel.setBounds(156, 167, 60, 30);
                jBtnCancel.addActionListener(new ActionListener() {
                    public void actionPerformed(ActionEvent evt) {
                        jBtnCancelActionPerformed(evt);
                    }
                });
            }
           this.setSize(293, 247);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    /**
     * 
     * <p>描述:班级下拉列表初始更新方法</p>
     *
     *
     */
    public void cmbInit(){
        CClsDAO clsDao = new CClsDAO();
        ArrayList clsList = clsDao.executeQuery();
        String[] strList = new String[clsList.size()+1];
        strList[0]="";
        for(int j=0;j<clsList.size();j++){
            CClasses cls = new CClasses();
            cls = (CClasses) clsList.get(j);
            String clsID = cls.getStrClsId();
            strList[j+1] = clsID;
        }
        ComboBoxModel jStuClassModel = new DefaultComboBoxModel(strList);
        jStuClass.setModel(jStuClassModel);
    }
    /**
     * 
     * <p>描述:取消按钮事件实现方法</p>
     *
     * @param evt
     */
    private void jBtnCancelActionPerformed(ActionEvent evt) {
        this.setVisible(false);
    }
	public TableModel stuTableChanged(){
		CStuDAO stuDao = new CStuDAO();
		ArrayList list = null;
		TableModel jResultTabModel=null;
        
		String ClassId = (String)this.jStuClass.getSelectedItem();
		String sql = "select * from T_student where cClassId='" + ClassId + "'";
		list = stuDao.executeQuery(sql); 


		if(list!=null){
			Object[][] tabValue = new Object[list.size()][];
			for (int i = 0; i < list.size(); i++) {
				CStudents stu = (CStudents) list.get(i);
				String[] value = {stu.getStrStuId(), stu.getStrStuName(), stu.getStrSex(),
								  stu.getStrClsID()};
				tabValue[i] = value;
			 }
			String[] name = {"学号", "名字", "性别", "班级号"};
			jResultTabModel = new DefaultTableModel(tabValue, name);
			//jResultTab.setModel(jResultTabModel);   
		}  
		return jResultTabModel;
	}
    /**
     * 
     * <p>描述:提交按钮事件实现方法</p>
     *
     * @param evt
     */
    private void jBtnSubmitActionPerformed(ActionEvent evt){
        String strStuName = this.jStuNameTxt.getText();
        String strStuSex = (String)this.jCmbStuSex.getSelectedItem();
        String strStuCls = (String)this.jStuClass.getSelectedItem();
    
        CStudents stu = new CStudents();
        stu.setStrStuName(strStuName);
        stu.setStrSex(strStuSex);
        stu.setStrClsID(strStuCls);
        
        if(jStuNameTxt.getText().equals("")){
            JOptionPane.showConfirmDialog(this,"请输入学生姓名","提示",
					JOptionPane.CLOSED_OPTION,
					JOptionPane.WARNING_MESSAGE);
        }
        else if(jStuClass.getSelectedItem().equals("")){
            JOptionPane.showConfirmDialog(this,"请选择班级","提示",
					JOptionPane.CLOSED_OPTION,
					JOptionPane.WARNING_MESSAGE);
        }
        else if(jCmbStuSex.getSelectedItem().equals("")){
            JOptionPane.showConfirmDialog(this,"请选择性别","提示",
					JOptionPane.CLOSED_OPTION,
					JOptionPane.WARNING_MESSAGE);
        }
        else{
            CStuDAO stuDAO = new CStuDAO();
            boolean b =stuDAO.excuteInsert(stu);
            if(b == false){
                int re = JOptionPane.showConfirmDialog(this,"学生添加成功","提示",
                  								JOptionPane.CLOSED_OPTION,
                  								JOptionPane.WARNING_MESSAGE);
                this.showNewID();
                CMain.stuTableUpdate();
            }  
        }

    }
   
}