panel1.java

[徐贵军]2004毕业设计重要资料 [徐贵军]2004毕业设计重要资料

                                .add(jLabel3)
                                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                                .add(jTextField2)
                                .add(1, 1, 1)))))
                .addContainerGap())
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(layout.createSequentialGroup()
                .add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                    .add(layout.createSequentialGroup()
                        .addContainerGap()
                        .add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                            .add(jLabel1)
                            .add(jComboBox1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)))
                    .add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                        .add(jButton3)
                        .add(jButton2)
                        .add(jButton1)))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jLabel3)
                    .add(jTextField2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(jLabel2)
                    .add(jTextField1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                    .add(jLabel4)
                    .add(jScrollPane2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 73, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                .add(18, 18, 18)
                .add(jScrollPane1, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 143, Short.MAX_VALUE)
                .addContainerGap())
        );
    }// </editor-fold>//GEN-END:initComponents

    private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton3ActionPerformed
// TODO 将在此处添加您的处理代码：
        //删除
        //*从数据库、jTable1[删除]当前表格选中行*//
        int x = jTable1.getSelectedRow();//得到jTable1当前选中的行号
        if(x == -1)return;
        if(JOptionPane.CANCEL_OPTION  == JOptionPane.showConfirmDialog(this,"确实要删除当前表格选中行吗？","删除",JOptionPane.OK_CANCEL_OPTION,JOptionPane.QUESTION_MESSAGE  ))return;
        try{
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;//载入JDBC/ODBC桥接驱动程序
        Connection con =DriverManager.getConnection("jdbc:odbc:Graduate","","");//连接数据库
        PreparedStatement pstmt =con.prepareStatement("delete from subject where name=? and year1=?");//年份+题目可唯一标识一条记录
        pstmt.setString(1,jTable1.getValueAt(x,0).toString());//设置SQL语句参数
        pstmt.setInt(2,Integer.parseInt(jComboBox1.getSelectedItem().toString()));
        pstmt.executeUpdate();//执行SQL语句更新数据库
        pstmt.close();//关闭语句句柄
        ((DefaultTableModel)jTable1.getModel()).removeRow(x);//从jTable1中删除该行记录
        }
        catch(Exception e1){e1.printStackTrace();}
        
        refresh();
    }//GEN-LAST:event_jButton3ActionPerformed

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed
// TODO 将在此处添加您的处理代码：
        //修改
        //*[修改]jTable1中选中的行信息到数据库，并更新jTable1*//
        int x = jTable1.getSelectedRow();//得到jTable1当前选中的行号
        if(x == -1)return;
        if(JOptionPane.CANCEL_OPTION  == JOptionPane.showConfirmDialog(this,"确实要修改当前表格选中行吗？","修改",JOptionPane.OK_CANCEL_OPTION,JOptionPane.QUESTION_MESSAGE  ))return;
        try{
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;//载入JDBC/ODBC桥接驱动程序
        Connection con =DriverManager.getConnection("jdbc:odbc:Graduate","","");//连接数据库
        PreparedStatement pstmt =con.prepareStatement(
                "update subject set name=?,number=?,request=?  where name=? and year1=?");
        //*设置SQL语句参数,注意：这里省略了对参数做合法性检查*//
        pstmt.setString(1,jTextField1.getText());
        pstmt.setInt(2,Integer.parseInt(jTextField2.getText()));
        pstmt.setString(3,jTextArea1.getText());
        pstmt.setString(4,jTable1.getValueAt(x,0).toString());//年份+题目可唯一标识一条记录
        pstmt.setInt(5,Integer.parseInt(jComboBox1.getSelectedItem().toString()));//
        pstmt.executeUpdate();//执行SQL语句更新数据库
        pstmt.close();//关闭语句句柄
        }
        catch(Exception e1){e1.printStackTrace();}
        //修改jTable1，所有字段都可按String类型设置，因为...
        DefaultTableModel tm=(DefaultTableModel)jTable1.getModel();
        tm.setValueAt(jTextField1.getText(),x,0);
        tm.setValueAt(jTextField2.getText(),x,1);
        tm.setValueAt(jTextArea1.getText(),x,2);  
        
        refresh();
    }//GEN-LAST:event_jButton2ActionPerformed

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
// TODO 将在此处添加您的处理代码：
        //添加
        //*将新记录[添加]到数据库，并追加到jTable1中*//
         try{
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;//载入JDBC/ODBC桥接驱动程序
        Connection con =DriverManager.getConnection("jdbc:odbc:Graduate","","");//连接数据库
        PreparedStatement pstmt =con.prepareStatement(
                "insert into subject(id,name,number,request,year1)values(?,?,?,?,?)");
        //*设置SQL语句参数,注意：这里省略了对参数做合法性检查*//
     
        //设置参数
        Statement stmt =con.createStatement();
        ResultSet rs = stmt.executeQuery("select max(id) as maxid from subject");
        int maxid = 0;
        while(rs.next()){maxid = rs.getInt(1);}
        maxid++;//计算新记录流水id，即在表subject最大id加1
        pstmt.setInt(1,maxid);
        pstmt.setString(2,jTextField1.getText());
        pstmt.setInt(3,Integer.parseInt(jTextField2.getText()));
        pstmt.setString(4,jTextArea1.getText());
        pstmt.setInt(5,Integer.parseInt(jComboBox1.getSelectedItem().toString()));
        //
        pstmt.executeUpdate();//执行SQL语句更新数据库
        pstmt.close();//关闭语句句柄
        }
        catch(Exception e1){e1.printStackTrace();}
         
         //加入jTable1
        Vector vt = new Vector();
        vt.addElement(jTextField1.getText());
        vt.addElement(Integer.parseInt(jTextField2.getText()));
        vt.addElement(jTextArea1.getText());
        ((DefaultTableModel)jTable1.getModel()).addRow(vt);
  
        refresh();
    }//GEN-LAST:event_jButton1ActionPerformed

    private void jTable1MouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jTable1MouseClicked
// TODO 将在此处添加您的处理代码：
        if(evt.getClickCount()!=2)return;//检测非双击返回
        int x=jTable1.getSelectedRow();//获取选中行号
        jTextField1.setText(jTable1.getValueAt(x,0).toString());
        jTextField2.setText(jTable1.getValueAt(x,1).toString());
        jTextArea1.setText(jTable1.getValueAt(x,2).toString());
    }//GEN-LAST:event_jTable1MouseClicked

    private void jComboBox1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jComboBox1ActionPerformed
// TODO 将在此处添加您的处理代码：
        DefaultTableModel tm=(DefaultTableModel) jTable1.getModel();
        tm.setRowCount(0);
        try{
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con=DriverManager.getConnection("jdbc:odbc:Graduate","","");
            PreparedStatement pstmt=con.prepareStatement("select name,number,request from subject where year1=?");
            pstmt.setInt(1,Integer.parseInt(jComboBox1.getSelectedItem().toString()));
            ResultSet rs=pstmt.executeQuery();
            while(rs.next()){
                Vector vt=new Vector();
                vt.addElement(rs.getString(1));
                vt.addElement(rs.getString(2));
                vt.addElement(rs.getString(3));
                tm.addRow(vt);
            }
        
        }catch(Exception e){e.printStackTrace();}
        
        refresh();
    }//GEN-LAST:event_jComboBox1ActionPerformed
    
    
    // 变量声明 - 不进行修改//GEN-BEGIN:variables
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton2;
    private javax.swing.JButton jButton3;
    private javax.swing.JComboBox jComboBox1;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JTable jTable1;
    private javax.swing.JTextArea jTextArea1;
    private javax.swing.JTextField jTextField1;
    private javax.swing.JTextField jTextField2;
    // 变量声明结束//GEN-END:variables
    
}