数据库作业 JAVa 嵌入式SQL

package 数据统计; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.Connection; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.SQLException; import java.sql.Statement; import java.util.Vector; import javax.swing.JOptionPane; import javax.swing.JScrollPane; import javax.swing.JTable; import javax.swing.event.TableModelEvent; import javax.swing.event.TableModelListener; import javax.swing.table.DefaultTableModel; import util.DataBaseManager; /** * * @author dell */ public class ChengJiStu extends javax.swing.JFrame implements TableModelListener, ActionListener { DataBaseManager db = null; Connection conn = null; Statement stmt = null; ResultSet rs = null; private JTable table; Vector rows; public DefaultTableModel dtm; int rowCount = 0; /** Creates new form StuReportsFrame */ public ChengJiStu() { super("成绩统计"); db = new DataBaseManager(); conn = db.con; stmt = db.stmt; initComponents(); // getTable(); } /** 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. */ @SuppressWarnings("unchecked") private void initComponents() { buttonGroup1 = new javax.swing.ButtonGroup(); jPanel1 = new javax.swing.JPanel(); jScrollPane1 = new javax.swing.JScrollPane(); jTable1 = new javax.swing.JTable(); jLabel1 = new javax.swing.JLabel(); jPanel2 = new javax.swing.JPanel(); stuAvgRBtn = new javax.swing.JRadioButton(); jLabel2 = new javax.swing.JLabel(); jLabel3 = new javax.swing.JLabel(); stuNoTF1 = new javax.swing.JTextField(); stuYrTF1 = new javax.swing.JTextField(); stuTotalScoreRBtn = new javax.swing.JRadioButton(); jLabel4 = new javax.swing.JLabel(); jLabel5 = new javax.swing.JLabel(); stuNoTF2 = new javax.swing.JTextField(); stuYrTF2 = new javax.swing.JTextField(); jPanel3 = new javax.swing.JPanel(); courseAvgRBtn = new javax.swing.JRadioButton(); jLabel6 = new javax.swing.JLabel(); cNoTF1 = new javax.swing.JTextField(); courseScoreHigherRBtn = new javax.swing.JRadioButton(); jLabel7 = new javax.swing.JLabel(); jLabel8 = new javax.swing.JLabel(); cNoTF2 = new javax.swing.JTextField(); selectTF1 = new javax.swing.JTextField(); courseScoreLowerRBtn = new javax.swing.JRadioButton(); jLabel9 = new javax.swing.JLabel(); jLabel10 = new javax.swing.JLabel(); cNoTF3 = new javax.swing.JTextField(); selectTF2 = new javax.swing.JTextField(); courseScoreBetweenRBtn = new javax.swing.JRadioButton(); jLabel11 = new javax.swing.JLabel(); jLabel12 = new javax.swing.JLabel(); jLabel13 = new javax.swing.JLabel(); selectTF3 = new javax.swing.JTextField(); selectTF4 = new javax.swing.JTextField(); cNoTF4 = new javax.swing.JTextField(); statBtn = new javax.swing.JButton(); cancleBtn = new javax.swing.JButton(); jTable1.setModel(new javax.swing.table.DefaultTableModel( new Object [][] { {null, null, null, null}, {null, null, null, null}, {null, null, null, null}, {null, null, null, null} }, new String [] { "", "", "", "" } )); jScrollPane1.setViewportView(jTable1); javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1); jPanel1.setLayout(jPanel1Layout); jPanel1Layout.setHorizontalGroup( jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 318, Short.MAX_VALUE) ); jPanel1Layout.setVerticalGroup( jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 211, Short.MAX_VALUE) ); jLabel1.setText("统计结果"); jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder("统计条件")); buttonGroup1.add(stuAvgRBtn); stuAvgRBtn.setText("学生平均成绩统计"); jLabel2.setText("学 号:"); jLabel3.setText("统计学年:"); buttonGroup1.add(stuTotalScoreRBtn); stuTotalScoreRBtn.setText("学生总分统计"); jLabel4.setText("学 号:"); jLabel5.setText("统计学年:"); javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2); jPanel2.setLayout(jPanel2Layout); jPanel2Layout.setHorizontalGroup( jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel2Layout.createSequentialGroup() .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(stuAvgRBtn) .addGroup(jPanel2Layout.createSequentialGroup() .addGap(21, 21, 21) .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel2) .addComponent(jLabel3))) .addComponent(stuTotalScoreRBtn) .addGroup(jPanel2Layout.createSequentialGroup() .addGap(21, 21, 21) .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel5) .addComponent(jLabel4)))) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(stuYrTF2, javax.swing.GroupLayout.DEFAULT_SIZE, 115, Short.MAX_VALUE) .addComponent(stuNoTF2, javax.swing.GroupLayout.DEFAULT_SIZE, 115, Short.MAX_VALUE) .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(stuYrTF1) .addComponent(stuNoTF1, javax.swing.GroupLayout.DEFAULT_SIZE, 115, Short.MAX_VALUE))) .addGap(64, 64, 64)) ); jPanel2Layout.linkSize(javax.swing.SwingConstants.HORIZONTAL, new java.awt.Component[] {jLabel2, jLabel3}); jPanel2Layout.setVerticalGroup( jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel2Layout.createSequentialGroup() .addComponent(stuAvgRBtn) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 15, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(stuNoTF1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel3) .addComponent(stuYrTF1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREF