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
}
资源传送门源码