学生成绩管理信息系统

package com.scm; import java.sql.*; import java.text.NumberFormat; import java.util.List; import java.util.Vector; import javax.swing.*; import java.awt.*; import java.awt.event.*; import javax.swing.table.DefaultTableModel; public class GeneralSort extends JInternalFrame { private JComboBox JComBox_Classes; private JComboBox JComBox_Course; private JComboBox JComBox_order; private JTextField badField; private JButton btn_action; private JTextField goodField; private JScrollPane jScrollPane1; private JLabel label_bad; private JLabel label_good; private JLabel label_max; private JLabel label_min; private JTextField maxField; private JTextField minField; private JRadioButton radio_asc; private JRadioButton radio_desc; private JTable table; private ButtonGroup bg; private UserDao userDao=new UserDao(); private Connection conn = null; private PreparedStatement ps = null; private ResultSet rs = null; //无参构造函数 public GeneralSort() { try { initComponents(); } catch (Exception e) { e.printStackTrace(); } //界面居中 Dimension dimension = Toolkit.getDefaultToolkit().getScreenSize(); this.setLocation(dimension.width / 2 - 300, dimension.height / 2 - 340); } //初始化界面 private void initComponents() throws Exception { JComBox_Classes = new JComboBox(); //班级复选框 JComBox_Course = new JComboBox(); //课程复选框 radio_asc = new JRadioButton(); //单选按钮 升序 radio_desc = new JRadioButton(); //单选按钮 降序 JComBox_order = new JComboBox(); //排序复选框 btn_action = new JButton(); //开始按钮 jScrollPane1 = new JScrollPane(); //滚动条 table = new JTable(); //表格 label_max = new JLabel(); label_min = new JLabel(); label_good = new JLabel(); label_bad = new JLabel(); maxField = new JTextField(); //最高分输入框 minField = new JTextField(); //最低分输入框 goodField = new JTextField(); //优秀率 badField = new JTextField(); //不及格率 setClosable(true); //设置窗体可关闭 setIconifiable(true); //设置窗体可最小化 setTitle("排序界面"); //动态生成班级下拉列表 conn=DBUtils.getConnection(); ps=conn.prepareStatement("select distinct classes from student"); rs=ps.executeQuery(); Vector classesV=new Vector(); classesV.add("--班级--"); while(rs.next()){ classesV.add(rs.getString("classes")); } DBUtils.closeAll(rs, ps, conn); DefaultComboBoxModel classes_model=new DefaultComboBoxModel(classesV); JComBox_Classes.setModel(classes_model); JComBox_Classes.setFont(new Font("仿宋", 0, 12)); //动态生成课程名称下拉列表 conn=DBUtils.getConnection(); ps=conn.prepareStatement("select distinct cname from course"); rs=ps.executeQuery(); Vector courseV=new Vector(); courseV.add("--课程--"); while(rs.next()){ courseV.add(rs.getString("cname")); } DBUtils.closeAll(rs, ps, conn); DefaultComboBoxModel course_model=new DefaultComboBoxModel(courseV); JComBox_Course.setModel(course_model); JComBox_Course.setFont(new Font("仿宋", 0, 12)); //升序 ，降序单选框 radio_asc.setFont(new Font("仿宋", 0, 14)); radio_asc.setText("升序"); radio_desc.setFont(new Font("仿宋", 0, 14)); radio_desc.setText("降序"); bg=new ButtonGroup(); bg.add(radio_asc); bg.add(radio_desc); radio_asc.setSelected(true); //默认选择升序 JComBox_order.setFont(new Font("仿宋", 0, 12)); JComBox_order.setModel(new DefaultComboBoxModel( new String[] { "学号", "分数" })); btn_action.setFont(new Font("仿宋", 0, 12)); btn_action.setText("开始"); table.setFont(new Font("仿宋", 0, 14)); table.setModel(new DefaultTableModel(new Object[][] { }, new String[] { "学号", "姓名", "班级", "课程名称", "分数" }) { boolean[] canEdit = new boolean[] { false, false, false, false, false }; public boolean isCellEditable(int rowIndex, int columnIndex) { return canEdit[columnIndex]; } }); jScrollPane1.setViewportView(table); label_max.setFont(new Font("仿宋", 0, 12)); label_max.setText(" 最高分"); label_min.setFont(new Font("仿宋", 0, 12)); label_min.setText(" 最低分"); label_good.setFont(new Font("仿宋", 0, 12)); label_good.setText(" 优秀率"); label_bad.setFont(new Font("仿宋", 0, 12)); label_bad.setText("不及格率"); maxField.setEditable(false); //设置不可编辑 minField.setEditable(false); goodField.setEditable(false); badField.setEditable(false); //布局 GroupLayout layout = new GroupLayout( getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup(layout .createParallelGroup(GroupLayout.Alignment.LEADING) .addGroup( layout.createSequentialGroup() .addGap(178, 178, 178) .addComponent(JComBox_Course, GroupLayout.PREFERRED_SIZE, 92, GroupLayout.PREFERRED_SIZE) .addGap(33, 33, 33) .addComponent(radio_asc) .addGap(18, 18, 18) .addComponent(radio_desc) .addGap(27, 27, 27) .addComponent(JComBox_order, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE) .addContainerGap(208, Short.MAX_VALUE)) .addGroup( GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addGroup( layout.createParallelGroup( GroupLayout.Alignment.TRAILING) .addGroup( layout.createSequentialGroup() .addContainerGap( 571, Short.MAX_VALUE) .addComponent( btn_action)) .addGroup( GroupLayout.Alignment.LEADING, layout.createSequentialGroup() .addGap(51, 51, 51) .addGroup( layout.createParallelGroup( GroupLayout.Alignment.LEADING) .addComponent( JComBox_Classes, GroupLayout.PREFERRED_SIZE, 94, GroupLayout.PREFERRED_SIZE) .addGroup( layout.createSequentialGroup() .addComponent( jScrollPane1, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18) .addGroup( layout.createParallelGroup( GroupLayout.Alignment.LEADING) .addGroup( layout.createSequentialGroup() .addComponent( label_bad) .addGap(18, 18, 18) .addComponent( badField, GroupLayout.PREFERRED_SIZE, 41, GroupLayout.PREFERRED_SIZE)) .addGroup( layout.createParallelGroup( GroupLayout.Alignment.TRAILING, false) .addGroup( layout.createSequentialGroup() .addComponent( label_good) .addPreferredGap( LayoutStyle.ComponentPlacement.RELATED, Grou