学生成绩管理系统实现（Java+Mysql+jdbc+JavaBea）

package com.frame; import java.awt.Dimension; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.SQLException; import java.util.Vector; import javax.swing.Box; import javax.swing.BoxLayout; import javax.swing.JButton; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JPanel; import javax.swing.JScrollPane; import javax.swing.JSplitPane; import javax.swing.JTable; import javax.swing.JTextField; import javax.swing.event.ListSelectionEvent; import javax.swing.event.ListSelectionListener; import javax.swing.table.DefaultTableModel; import com.dao.CourseDao; import com.dao.ScoreDao; import com.dao.StudentDao; import com.frame.commonframe.CommonJTable; import com.frame.commonframe.CommonPanel; import com.model.Score; public class ScorePanel extends CommonPanel { private Vector columns; private Box center = Box.createHorizontalBox(); //学生下拉框 //JComboBox studentComboBox; //课程下拉框 //JComboBox courseComboBox; //学号 JTextField sno; //学生姓名 JTextField sname; //课程号 JTextField cno; //课程名 JTextField cname; //成绩id JTextField id; //学生 JTextField sid; //课程ID JTextField cid; //成绩 JTextField score; JButton clearButton; //删除的按钮 JButton deleButton; JButton saveButton; private final static String DEFAULT_File_Path = "upload/no_pic.gif"; private void initColumns() { this.columns = new Vector(); this.columns.add("id"); this.columns.add("学号"); this.columns.add("姓名"); this.columns.add("课程编号"); this.columns.add("课程"); this.columns.add("成绩"); } public ScorePanel() { setViewDatas(); initColumns(); //设置列表 DefaultTableModel model = new DefaultTableModel(getDatas(), this.columns); JTable table = new CommonJTable(model); setJTable(table); JScrollPane upPane = new JScrollPane(table); upPane.setPreferredSize(new Dimension(1000, 350)); //设置添加, 修改的界面 JPanel downPane = new JPanel(); downPane.setLayout(new BoxLayout(downPane, BoxLayout.X_AXIS)); Box downBox1 = new Box(BoxLayout.X_AXIS); //添加id隐藏域 id = new JTextField(10); id.setVisible(false); downBox1.add(id); //列表下面的box /***************************************************/ Box downBox4 = new Box(BoxLayout.X_AXIS); downBox4.add(new JLabel("学号：")); downBox4.add(Box.createHorizontalStrut(10)); sno = new JTextField(10); downBox4.add(sno); downBox4.add(Box.createHorizontalStrut(30)); downBox4.add(new JLabel("姓名：")); downBox4.add(Box.createHorizontalStrut(10)); sname = new JTextField(20); downBox4.add(sname); downBox4.add(Box.createHorizontalStrut(30)); Box downBox5 = new Box(BoxLayout.X_AXIS); downBox5.add(new JLabel("课程号：")); cno = new JTextField(10); downBox5.add(cno); downBox5.add(Box.createHorizontalStrut(30)); downBox5.add(new JLabel("课程名：")); cname = new JTextField(20); downBox5.add(cname); downBox5.add(Box.createHorizontalStrut(30)); /*******************************************************/ Box downBox2 = new Box(BoxLayout.X_AXIS); downBox2.add(new JLabel("成绩：")); downBox2.add(Box.createHorizontalStrut(10)); score = new JTextField(10); downBox2.add(score); downBox2.add(Box.createHorizontalStrut(30)); /*******************************************************/ Box downBox3 = new Box(BoxLayout.X_AXIS); saveButton = new JButton("保存"); downBox3.add(saveButton); downBox3.add(Box.createHorizontalStrut(30)); deleButton = new JButton("删除"); downBox3.add(deleButton); downBox3.add(Box.createHorizontalStrut(30)); clearButton = new JButton("清空"); downBox3.add(clearButton); downBox3.add(Box.createHorizontalStrut(30)); /*******************************************************/ Box downLeftBox = new Box(BoxLayout.Y_AXIS); downLeftBox.add(getSplitBox()); downLeftBox.add(downBox1); downLeftBox.add(getSplitBox()); downLeftBox.add(downBox4); downLeftBox.add(getSplitBox()); downLeftBox.add(downBox5); downLeftBox.add(getSplitBox()); downLeftBox.add(downBox2); downLeftBox.add(getSplitBox()); downLeftBox.add(downBox3); Box downRightBox = new Box(BoxLayout.Y_AXIS); //downRightBox.add(p); downPane.add(downLeftBox); downPane.add(downRightBox); JPanel queryPanel = new JPanel(); Box queryBox = new Box(BoxLayout.X_AXIS); queryBox.add(Box.createHorizontalStrut(30)); queryPanel.add(queryBox); this.add(queryPanel); //列表为添加界面 JSplitPane split = new JSplitPane(JSplitPane.VERTICAL_SPLIT, upPane, downPane); split.setDividerSize(5); this.add(split); //添加监听器 initListeners(); } private void initListeners() { //表格选择监听器 getJTable().getSelectionModel().addListSelectionListener(new ListSelectionListener() { public void valueChanged(ListSelectionEvent event) { //当选择行时鼠标释放时才执行 if (!event.getValueIsAdjusting()) { //如果没有选中任何一行, 则返回 if (getJTable().getSelectedRowCount() != 1) return; view(); } } }); //清空按钮监听器 clearButton.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { clear(); } }); //保存按钮监听器 saveButton.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { //验证空值 if (sno.getText().trim().equals("")) { showWarn("请输入学号"); return; } if (cno.getText().trim().equals("")) { showWarn("请输入课程号"); return; } if (score.getText().trim().equals("")) { showWarn("请输入成绩"); return; } save(); } }); //删除按钮监听器 deleButton.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent arg0) { dele(); } }); // 添加回车键监听 sno.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { String stno = sno.getText().trim(); if (!stno.isEmpty()) { StudentDao studentDao = new StudentDao(); String stname = studentDao.getNameByNo(stno); if(stname==null) { JOptionPane.showMessageDialog(center, "学号错误", "查询失败", JOptionPane.INFORMATION_MESSAGE); sno.setText(null); } else { sname.se