keshanframe3.java~2~

Java学生管理系统学生及成绩记录的查询删除修改

package student;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import javax.swing.JTabbedPane;
import java.awt.*;
import java.sql.*;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.Connection;

import javax.swing.JPanel;
import javax.swing.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class keshanFrame3 extends JFrame {
    public keshanFrame3() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        setSize(420,520);
        jTabbedPane1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jTabbedPane1.setBorder(BorderFactory.createEtchedBorder());
        jTabbedPane1.setBounds(new Rectangle(21, 13, 418, 470));
        jPanel1.setBackground(Color.lightGray);
        jPanel1.setBorder(BorderFactory.createEtchedBorder());
        jPanel1.setLayout(null);
        jPanel2.setBackground(Color.pink);
        jPanel2.setBorder(BorderFactory.createEtchedBorder());
        jPanel2.setBounds(new Rectangle(3, 5, 399, 54));
        jPanel2.setLayout(null);
        jPanel3.setBackground(Color.pink);
        jPanel3.setBorder(BorderFactory.createEtchedBorder());
        jPanel3.setBounds(new Rectangle(4, 61, 401, 355));
        jPanel3.setLayout(null);
        jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jLabel1.setForeground(Color.black);
        jLabel1.setText("请输入要删除课程的编号:");
        jLabel1.setBounds(new Rectangle(4, 14, 178, 33));
        bianhao.setBounds(new Rectangle(193, 12, 82, 24));
        bianhao.addActionListener(new keshanFrame3_jComboBox1_actionAdapter(this));
        jButton1.setBounds(new Rectangle(295, 13, 79, 28));
        jButton1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jButton1.setForeground(Color.black);
        jButton1.setText("搜索");
        jButton1.addActionListener(new keshanFrame3_jButton1_actionAdapter(this));
        jLabel2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jLabel2.setText("课  程  语  言");
        jLabel2.setBounds(new Rectangle(7, 10, 96, 37));
        yuyan.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        yuyan.setBounds(new Rectangle(118, 10, 174, 41));
        jLabel3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jLabel3.setText("课  程  教  师");
        jLabel3.setBounds(new Rectangle(7, 70, 95, 39));
        jiaoshi1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        jiaoshi1.setBounds(new Rectangle(119, 71, 174, 42));
        jLabel4.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jLabel4.setText("课  程  教  室");
        jLabel4.setBounds(new Rectangle(4, 133, 102, 40));
        jiaoshi2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        jiaoshi2.setBounds(new Rectangle(118, 133, 173, 39));
        jLabel5.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jLabel5.setText("课  程  类  型");
        jLabel5.setBounds(new Rectangle(4, 205, 105, 37));
        leixing.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        leixing.setText("");
        leixing.setBounds(new Rectangle(118, 202, 175, 41));
        jButton2.setBounds(new Rectangle(46, 265, 99, 31));
        jButton2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jButton2.setForeground(new Color(200, 0, 0));
        jButton2.setText("删 除");
        jButton2.addActionListener(new keshanFrame3_jButton2_actionAdapter(this));
        jButton3.setBounds(new Rectangle(206, 265, 96, 31));
        jButton3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jButton3.setForeground(new Color(200, 0, 0));
        jButton3.setText("取 消");
        jButton3.addActionListener(new keshanFrame3_jButton3_actionAdapter(this));
        this.getContentPane().setBackground(Color.pink);
        this.getContentPane().add(jTabbedPane1);
        jTabbedPane1.add(jPanel1, "课程删除");
        jPanel1.add(jPanel2);
        jPanel2.add(jLabel1);
        jPanel2.add(bianhao);
        jPanel2.add(jButton1);
        jPanel1.add(jPanel3);
        jPanel3.add(jLabel2);
        jPanel3.add(yuyan);
        jPanel3.add(jLabel3);
        jPanel3.add(jLabel4);
        jPanel3.add(jiaoshi2);
        jPanel3.add(jLabel5);
        jPanel3.add(leixing);
        jPanel3.add(jiaoshi1);
        jPanel3.add(jButton3);
        jPanel3.add(jButton2);
        try{
           Connectionsql c=new Connectionsql();
           Connection con=c.getConnection();
           Statement pstmt=con.createStatement();
           String sql="select * from kechengxinxi";
           ResultSet rs=pstmt.executeQuery(sql);
           while(rs.next()){
              bianhao.addItem(rs.getString(1));
              }
       }catch(Exception xx){
           xx.printStackTrace();
       }

    }
    String BH;
    JTabbedPane jTabbedPane1 = new JTabbedPane();
    JPanel jPanel1 = new JPanel();
    JPanel jPanel2 = new JPanel();
    JPanel jPanel3 = new JPanel();
    JLabel jLabel1 = new JLabel();
    JComboBox bianhao = new JComboBox();
    JButton jButton1 = new JButton();
    JLabel jLabel2 = new JLabel();
    JTextField yuyan = new JTextField();
    JLabel jLabel3 = new JLabel();
    JTextField jiaoshi1 = new JTextField();
    JLabel jLabel4 = new JLabel();
    JTextField jiaoshi2 = new JTextField();
    JLabel jLabel5 = new JLabel();
    JTextField leixing = new JTextField();
    JButton jButton2 = new JButton();
    JButton jButton3 = new JButton();
    public void jButton3_actionPerformed(ActionEvent e) {
        this.dispose();
    }

    public void jButton2_actionPerformed(ActionEvent e) {
        try{
          Connectionsql a=new Connectionsql();
          Connection con=a.getConnection();
          Statement pstmt=con.createStatement();
          String sql="delete from kechengxinxi where kechengbm1 like '"+BH+"' ";
          pstmt.executeUpdate(sql);
          JOptionPane.showMessageDialog(this,"删除成功");
      }catch(Exception xx){
          xx.printStackTrace();
      }

    }

    public void bianhao_actionPerformed(ActionEvent e) {

    }

    public void jButton1_actionPerformed(ActionEvent e) {
        try{
            BH=(String)bianhao.getSelectedItem();
            Connectionsql c=new Connectionsql();
                   Connection con=c.getConnection();
                   Statement pstmt=con.createStatement();
                   String sql="select * from kechengxinxi where kechengbm1='"+BH+"'";
                   ResultSet rs=pstmt.executeQuery(sql);
                   while(rs.next()){
                       yuyan.setText(rs.getString(2));
                       jiaoshi1.setText(rs.getString(3));
                       jiaoshi2.setText(rs.getString(4));
                       leixing.setText(rs.getString(5));
                    }
               }catch(Exception xx){
                   xx.printStackTrace();
        }

    }
}


class keshanFrame3_jButton2_actionAdapter implements ActionListener {
    private keshanFrame3 adaptee;
    keshanFrame3_jButton2_actionAdapter(keshanFrame3 adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton2_actionPerformed(e);
    }
}


class keshanFrame3_jButton1_actionAdapter implements ActionListener {
    private keshanFrame3 adaptee;
    keshanFrame3_jButton1_actionAdapter(keshanFrame3 adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton1_actionPerformed(e);
    }
}


class keshanFrame3_jComboBox1_actionAdapter implements ActionListener {
    private keshanFrame3 adaptee;
    keshanFrame3_jComboBox1_actionAdapter(keshanFrame3 adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {

        adaptee.bianhao_actionPerformed(e);
    }
}


class keshanFrame3_jButton3_actionAdapter implements ActionListener {
    private keshanFrame3 adaptee;
    keshanFrame3_jButton3_actionAdapter(keshanFrame3 adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton3_actionPerformed(e);
    }
}