Swing框架的学生管理系统实现班级、学生、年级

5 篇文章 0 订阅
1 篇文章 0 订阅

Swing框架的学生管理系统

已实现

登陆

班级的增删改查

学生的增删改查

年级的增删改查

实体类:

学生类:

package com.lq.moder;

public class Student {

    private int id;
    private int studentId;
    private String stuName;
    private String birthday;
    private String place;
    private int classId;
    private String desc;
    
    public Student(){}

    
    
    public Student(int studentId, String stuName, String place, int classId) {
        //super();
        this.studentId = studentId;
        this.stuName = stuName;
        this.place = place;
        this.classId = classId;
    }



    public Student(int studentId, String stuName, String birthday,
            String place, int classId, String desc) {
        super();
        this.studentId = studentId;
        this.stuName = stuName;
        this.birthday = birthday;
        this.place = place;
        this.classId = classId;
        this.desc = desc;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public int getStudentId() {
        return studentId;
    }

    public void setStudentId(int studentId) {
        this.studentId = studentId;
    }

    public String getStuName() {
        return stuName;
    }

    public void setStuName(String stuName) {
        this.stuName = stuName;
    }

    public String getBirthday() {
        return birthday;
    }

    public void setBirthday(String birthday) {
        this.birthday = birthday;
    }

    public String getPlace() {
        return place;
    }

    public void setPlace(String place) {
        this.place = place;
    }

    public int getClassId() {
        return classId;
    }

    public void setClassId(int classId) {
        this.classId = classId;
    }

    public String getDesc() {
        return desc;
    }

    public void setDesc(String desc) {
        this.desc = desc;
    }

}

班级类:

package com.lq.moder;

public class Class {

    private int id;
    private String clasName;
    private int gradeId;
    private String desc;

    public Class() {
    }
    
    

    public Class(int id, String clasName, int gradeId, String desc) {
        super();
        this.id = id;
        this.clasName = clasName;
        this.gradeId = gradeId;
        this.desc = desc;
    }



    public Class(String clasName, int gradeId, String desc) {
        super();
        this.clasName = clasName;
        this.gradeId = gradeId;
        this.desc = desc;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getClasName() {
        return clasName;
    }

    public void setClasName(String clasName) {
        this.clasName = clasName;
    }

    public int getGradeId() {
        return gradeId;
    }

    public void setGradeId(int gradeId) {
        this.gradeId = gradeId;
    }

    public String getDesc() {
        return desc;
    }

    public void setDesc(String desc) {
        this.desc = desc;
    }

    @Override
    public String toString() {
        return getClasName();
    }

    
}

年级类:

package com.lq.moder;

public class Grade {

    private int id;
    private String gradeName;
    private String desc;

    public Grade() {}

    public Grade(int id, String gradeName, String desc) {
        super();
        this.id = id;
        this.gradeName = gradeName;
        this.desc = desc;
    }

    public Grade(String gradeName, String desc) {
        super();
        this.gradeName = gradeName;
        this.desc = desc;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getGradeName() {
        return gradeName;
    }

    public void setGradeName(String gradeName) {
        this.gradeName = gradeName;
    }

    public String getDesc() {
        return desc;
    }

    public void setDesc(String desc) {
        this.desc = desc;
    }

    @Override
    public String toString() {
        return getGradeName();
    }

    
}

用户类 :

package com.lq.moder;

public class mange {

    private String userName;
    private String passWord;
    private int id;

    public mange(String userName, String passWord) {
        super();
        this.userName = userName;
        this.passWord = passWord;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getUserName() {
        return userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public String getPassWord() {
        return passWord;
    }

    public void setPassWord(String passWord) {
        this.passWord = passWord;
    }

}

窗口UI

登陆窗口:

/*
 * Login.java
 *
 * Created on __DATE__, __TIME__
 */

package com.lq.view;

import java.sql.Connection;

import javax.swing.JOptionPane;

import com.lq.dao.mangeDao;
import com.lq.moder.mange;
import com.lq.util.DbUtil;


public class Login extends javax.swing.JFrame {

    DbUtil dbUtil = new DbUtil();

    /** Creates new form Login */
    public Login() {
        initComponents();

        this.setLocation(200, 200);
    }

    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    //GEN-BEGIN:initComponents
    // <editor-fold defaultstate="collapsed" desc="Generated Code">
    private void initComponents() {

        jLabel1 = new javax.swing.JLabel();
        jLabel2 = new javax.swing.JLabel();
        loginJb = new javax.swing.JButton();
        endJb = new javax.swing.JButton();
        userNameTxt = new javax.swing.JTextField();
        jLabel3 = new javax.swing.JLabel();
        passWordTxt = new javax.swing.JPasswordField();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

        jLabel1.setText("用户名:");

        jLabel2.setText("密码:");

        loginJb.setText("登陆");
        loginJb.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                loginJbActionPerformed(evt);
            }
        });

        endJb.setText("退出");
        endJb.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                endJbActionPerformed(evt);
            }
        });

        jLabel3.setFont(new java.awt.Font("微软雅黑", 0, 24));
        jLabel3.setText("\u8001\u72fc\u5b66\u751f\u4fe1\u606f\u7cfb\u7edf\u0056\u0031\u002e\u0030");

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(
                getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(layout
                .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(
                        layout.createSequentialGroup()
                                .addGap(102, 102, 102)
                                .addGroup(
                                        layout.createParallelGroup(
                                                javax.swing.GroupLayout.Alignment.TRAILING)
                                                .addGroup(
                                                        layout.createParallelGroup(
                                                                javax.swing.GroupLayout.Alignment.LEADING)
                                                                .addGroup(
                                                                        layout.createSequentialGroup()
                                                                                .addGap(33,
                                                                                        33,
                                                                                        33)
                                                                                .addComponent(
                                                                                        jLabel2))
                                                                .addGroup(
                                                                        javax.swing.GroupLayout.Alignment.TRAILING,
                                                                        layout.createSequentialGroup()
                                                                                .addComponent(
                                                                                        loginJb)
                                                                                .addPreferredGap(
                                                                                        javax.swing.LayoutStyle.ComponentPlacement.RELATED)))
                                                .addComponent(jLabel1))
                                .addGroup(
                                        layout.createParallelGroup(
                                                javax.swing.GroupLayout.Alignment.LEADING)
                                                .addGroup(
                                                        layout.createSequentialGroup()
                                                                .addGap(27, 27,
                                                                        27)
                                                                .addGroup(
                                                                        layout.createParallelGroup(
                                                                                javax.swing.GroupLayout.Alignment.TRAILING,
                                                                                false)
                                                                                .addComponent(
                                                                                        userNameTxt,
                                                                                        javax.swing.GroupLayout.Alignment.LEADING)
                                                                                .addComponent(
                                                                                        passWordTxt,
                                                                                        javax.swing.GroupLayout.Alignment.LEADING,
                                                                                        javax.swing.GroupLayout.DEFAULT_SIZE,
                                                                                        96,
                                                                                        Short.MAX_VALUE)))
                                                .addGroup(
                                                        layout.createSequentialGroup()
                                                                .addGap(77, 77,
                                                                        77)
                                                                .addComponent(
                                                                        endJb,
                                                                        javax.swing.GroupLayout.PREFERRED_SIZE,
                                                                        65,
                                                                        javax.swing.GroupLayout.PREFERRED_SIZE)))
                                .addContainerGap(92, Short.MAX_VALUE))
                .addGroup(
                        javax.swing.GroupLayout.Alignment.TRAILING,
                        layout.createSequentialGroup()
                                .addContainerGap(116, Short.MAX_VALUE)
                                .addComponent(jLabel3).addGap(145, 145, 145)));
        layout.setVerticalGroup(layout
                .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(
                        layout.createSequentialGroup()
                                .addGap(36, 36, 36)
                                .addComponent(jLabel3,
                                        javax.swing.GroupLayout.PREFERRED_SIZE,
                                        37,
                                        javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addGap(44, 44, 44)
                                .addGroup(
                                        layout.createParallelGroup(
                                                javax.swing.GroupLayout.Alignment.BASELINE)
                                                .addComponent(jLabel1)
                                                .addComponent(
                                                        userNameTxt,
                                                        javax.swing.GroupLayout.PREFERRED_SIZE,
                                                        javax.swing.GroupLayout.DEFAULT_SIZE,
                                                        javax.swing.GroupLayout.PREFERRED_SIZE))
                                .addGap(40, 40, 40)
                                .addGroup(
                                        layout.createParallelGroup(
                                                javax.swing.GroupLayout.Alignment.BASELINE)
                                                .addComponent(jLabel2)
                                                .addComponent(
                                                        passWordTxt,
                                                        javax.swing.GroupLayout.PREFERRED_SIZE,
                                                        javax.swing.GroupLayout.DEFAULT_SIZE,
                                                        javax.swing.GroupLayout.PREFERRED_SIZE))
                                .addGap(64, 64, 64)
                                .addGroup(
                                        layout.createParallelGroup(
                                                javax.swing.GroupLayout.Alignment.BASELINE)
                                                .addComponent(loginJb)
                                                .addComponent(endJb))
                                .addContainerGap(95, Short.MAX_VALUE)));

        pack();
    }// </editor-fold>
    //GEN-END:initComponents

    private void endJbActionPerformed(java.awt.event.ActionEvent evt) {
        // TODO add your handling code here:
        this.dispose();
        return;
    }

    private void loginJbActionPerformed(java.awt.event.ActionEvent evt) {
        // TODO add your handling code here:
        String userName = userNameTxt.getText();
        String passWord = new String(passWordTxt.getPassword());

        if (userName.isEmpty()) {
            JOptionPane.showMessageDialog(null, "用户名不能为空");
            return;
        }
        if (passWord.isEmpty()) {
            JOptionPane.showMessageDialog(null, "密码不能为空");
            return;
        }

        mange mange = new mange(userName, passWord);

        Connection con = null;
        try {
            con = dbUtil.getCon();
            mangeDao mangeDao = new mangeDao();
            boolean loginFlag = mangeDao.login(con, mange);
            if (loginFlag) {
                this.dispose();
                new MangeFrm().setVisible(true);
            } else {
                JOptionPane.showMessageDialog(null, "登录失败,用户名或密码错误");
            }
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } finally {
            try {
                dbUtil.Close(con);
            } catch (Exception e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }

    }

    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new Login().setVisible(true);
            }
        });
    }

    //GEN-BEGIN:variables
    // Variables declaration - do not modify
    private javax.swing.JButton endJb;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JButton loginJb;
    private javax.swing.JPasswordField passWordTxt;
    private javax.swing.JTextField userNameTxt;
    // End of variables declaration//GEN-END:variables

}

班级UI:

/*
 * ClassInteFrm.java
 *
 * Created on __DATE__, __TIME__
 */

package com.lq.view;

import java.sql.Connection;
import java.sql.ResultSet;
import java.util.Vector;

import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;

import com.lq.dao.ClassDao;
import com.lq.dao.GradeDao;
import com.lq.moder.Class;
import com.lq.moder.Grade;
import com.lq.util.DbUtil;
import com.lq.util.StringUtil;


public class ClassInteFrm extends javax.swing.JInternalFrame {
    DbUtil dbUtil = new DbUtil();

    /** Creates new form ClassInteFrm */
    public ClassInteFrm() {
        initComponents();

        setLocation(250, 250);

        fillTable();
        cshCom();
        fillCom();

    }
    
    private void clearTxt(){
        idTxt.setText("");
        classTxt.setText("");
        descTxt.setText("");
    }

    private void cshCom() {
        Grade grade = new Grade();
        grade.setId(-1);
        grade.setGradeName("请选择....");
        graderCom.addItem(grade);
    }

    private void fillTable() {
        Connection con = null;
        DefaultTableModel tableModel = (DefaultTableModel) ClassTable
                .getModel();
        tableModel.setRowCount(0);
        try {
            con = dbUtil.getCon();
            ClassDao classDao = new ClassDao();
            ResultSet rest = classDao.classNameList(con);
            while (rest.next()) {
                Vector v = new Vector();
                v.add(rest.getInt("id"));
                v.add(rest.getString("className"));
                v.add(rest.getString("gradeName"));
                v.add(rest.getString("desc"));
                tableModel.addRow(v);
            }

        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } finally {
            try {
                dbUtil.Close(con);
            } catch (Exception e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
    }

    private void fillCom() {
        Connection con = null;
        Grade grade = null;
        GradeDao gradeDao = new GradeDao();
        try {
            con = dbUtil.getCon();
            ResultSet rest = gradeDao.graderList(con);
            while (rest.next()) {
                grade = new Grade();
                grade.setId(rest.getInt("id"));
                grade.setGradeName(rest.getString("gradeName"));
                graderCom.addItem(grade);
            }
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } finally {
            try {
                dbUtil.Close(con);
            } catch (Exception e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
    }

    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    //GEN-BEGIN:initComponents
    // <editor-fold defaultstate="collapsed" desc="Generated Code">
    private void initComponents() {

jScrollPane1 = new javax.swing.JScrollPane();
ClassTable = new javax.swing.JTable();
jPanel1 = new javax.swing.JPanel();
jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
jLabel4 = new javax.swing.JLabel();
jScrollPane2 = new javax.swing.JScrollPane();
descTxt = new javax.swing.JTextArea();
idTxt = new javax.swing.JTextField();
classTxt = new javax.swing.JTextField();
referJB = new javax.swing.JButton();
alterJB = new javax.swing.JButton();
deleteJB = new javax.swing.JButton();
graderCom = new javax.swing.JComboBox();

setClosable(true);
setIconifiable(true);
setTitle("\u73ed\u7ea7\u4fe1\u606f");

ClassTable.setModel(new javax.swing.table.DefaultTableModel(
    new Object [][] {
        
    },
    new String [] {
        "编号", "班级", "年级", "备注"
    }
) {
    boolean[] canEdit = new boolean [] {
        false, false, false, false
    };

    public boolean isCellEditable(int rowIndex, int columnIndex) {
        return canEdit [columnIndex];
    }
});
ClassTable.addMouseListener(new java.awt.event.MouseAdapter() {
public void mousePressed(java.awt.event.MouseEvent evt) {
ClassTableMousePressed(evt);
}
});
jScrollPane1.setViewportView(ClassTable);

jLabel1.setText("\u7f16\u53f7\uff1a");

jLabel2.setText("\u73ed\u7ea7\uff1a");

jLabel3.setText("\u5e74\u7ea7\uff1a");

jLabel4.setText("\u5907\u6ce8\uff1a");

descTxt.setColumns(20);
descTxt.setRows(5);
jScrollPane2.setViewportView(descTxt);

idTxt.setEditable(false);

classTxt.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
classTxtActionPerformed(evt);
}
});

referJB.setText("\u67e5\u8be2");
referJB.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
referJBActionPerformed(evt);
}
});

alterJB.setText("\u4fee\u6539");
alterJB.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
alterJBActionPerformed(evt);
}
});

deleteJB.setText("\u5220\u9664");
deleteJB.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
deleteJBActionPerformed(evt);
}
});



javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
jPanel1.setLayout(jPanel1Layout);
jPanel1Layout.setHorizontalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGap(70, 70, 70)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel2)
.addComponent(jLabel1))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(classTxt)
.addComponent(idTxt, javax.swing.GroupLayout.PREFERRED_SIZE, 86, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jLabel3)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(graderCom, javax.swing.GroupLayout.PREFERRED_SIZE, 76, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(26, 26, 26)
.addComponent(jLabel4)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 35, Short.MAX_VALUE)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(referJB)
.addComponent(alterJB)
.addComponent(deleteJB))
.addContainerGap())
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGap(22, 22, 22)
.addComponent(jLabel4)
.addContainerGap(95, Short.MAX_VALUE))
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(referJB)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(alterJB)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(deleteJB))
.addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGroup(jPanel1Layout.createSequentialGroup()
.addGap(23, 23, 23)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel3)
.addComponent(jLabel1)
.addComponent(idTxt, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(graderCom, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 40, Short.MAX_VALUE)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel2)
.addComponent(classTxt, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(25, 25, 25))
);

javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 667, Short.MAX_VALUE)
.addGroup(layout.createSequentialGroup()
.addGap(12, 12, 12)
.addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addContainerGap())
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(65, 65, 65)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 197, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(112, Short.MAX_VALUE))
);

pack();
}// </editor-fold>

    //GEN-END:initComponents
    private void deleteJBActionPerformed(java.awt.event.ActionEvent evt) {
        // TODO add your handling code here:
        int id;
        if(StringUtil.isnotEmpty(idTxt.getText()))
            id = Integer.valueOf(idTxt.getText());
        else{
            JOptionPane.showMessageDialog(null, "没有信息");
            return;
        }
        
        Class class1 = new Class();
        class1.setId(id);
        Connection con= null;
        try {
            con = dbUtil.getCon();
            int deleteNumber = new ClassDao().classDelete(con, class1);
            if(deleteNumber>0){
                JOptionPane.showMessageDialog(null, "删除成功");
                fillTable();
                clearTxt();
            }else{
                JOptionPane.showMessageDialog(null, "有学生信息存在,无法删除");
                return;
            }
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
            JOptionPane.showMessageDialog(null, "有学生信息,删除失败");
        }finally{
            try {
                dbUtil.Close(con);
            } catch (Exception e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
    }

    private void classTxtActionPerformed(java.awt.event.ActionEvent evt) {
        // TODO add your handling code here:
    }

    private void alterJBActionPerformed(java.awt.event.ActionEvent evt) {
        // TODO add your handling code here:
        String className = classTxt.getText();
        Grade grade = (Grade) graderCom.getSelectedItem();
        int gradeId = grade.getId();
        String desc = descTxt.getText();
        int id = Integer.valueOf(idTxt.getText());

        if (StringUtil.isEmpty(className)) {
            JOptionPane.showMessageDialog(null, "班级名字不能为空");
        }
        if (gradeId == -1) {
            JOptionPane.showMessageDialog(null, "年级不能不选");
        }
        Class class1 = new Class(id, className, gradeId, desc);
        Connection con = null;
        try {
            con = dbUtil.getCon();
            new ClassDao().classAlter(con, class1);
            JOptionPane.showMessageDialog(null, "修改成功");
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
            JOptionPane.showMessageDialog(null, "修改失败");
        } finally {
            try {
                dbUtil.Close(con);
            } catch (Exception e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }

    }

    private void referJBActionPerformed(java.awt.event.ActionEvent evt) {
        // TODO add your handling code here:
        String className = classTxt.getText();
        Grade grade = (Grade) graderCom.getSelectedItem();
        int gradeId = grade.getId();

        String desc = descTxt.getText();

        DefaultTableModel defaultTableModel = (DefaultTableModel) ClassTable
                .getModel();
        defaultTableModel.setRowCount(0);
        Connection con = null;
        try {
            con = dbUtil.getCon();
            Class class1 = new Class(className, gradeId, desc);
            ResultSet rest = new ClassDao().classRefer(con, class1);
            while (rest.next()) {
                Vector v = new Vector();
                v.add(rest.getInt("id"));
                v.add(rest.getString("className"));
                v.add(rest.getString("gradeName"));
                v.add(rest.getString("desc"));
                defaultTableModel.addRow(v);
            }
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
            JOptionPane.showMessageDialog(null, "查找失败");
        } finally {
            try {
                dbUtil.Close(con);
            } catch (Exception e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }

    }

    private void ClassTableMousePressed(java.awt.event.MouseEvent evt) {
        // TODO add your handling code here:
        int row = ClassTable.getSelectedRow();
        idTxt.setText(String.valueOf((Integer) ClassTable.getValueAt(row, 0)));
        classTxt.setText((String) ClassTable.getValueAt(row, 1));
        String gradeName = (String) ClassTable.getValueAt(row, 2);
        int n = graderCom.getItemCount();
        for (int i = 0; i < n; i++) {
            Grade grade = (Grade) graderCom.getItemAt(i);
            if (grade.getGradeName().equals(gradeName)) {
                graderCom.setSelectedIndex(i);
            }
        }
        descTxt.setText((String) ClassTable.getValueAt(row, 3));

    }

    //GEN-BEGIN:variables
    // Variables declaration - do not modify
    private javax.swing.JTable ClassTable;
    private javax.swing.JButton alterJB;
    private javax.swing.JTextField classTxt;
    private javax.swing.JButton deleteJB;
    private javax.swing.JTextArea descTxt;
    private javax.swing.JComboBox graderCom;
    private javax.swing.JTextField idTxt;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JButton referJB;
    // End of variables declaration//GEN-END:variables

}

资源传送门源码

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

IT老狼

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值