xiuke3frame1.java

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

package student;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import javax.swing.JPanel;
import java.awt.*;
import javax.swing.*;
import java.sql.*;
import java.sql.ResultSet;
import java.sql.Connection;
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 xiuke3Frame1 extends JFrame {
    public xiuke3Frame1() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        jTabbedPane1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jTabbedPane1.setBounds(new Rectangle(12, 17, 399, 428));
        jPanel1.setLayout(null);
        jPanel2.setBackground(Color.white);
        jPanel2.setBorder(BorderFactory.createEtchedBorder());
        jPanel2.setBounds(new Rectangle(12, 10, 356, 54));
        jPanel2.setLayout(null);
        jPanel3.setBorder(BorderFactory.createEtchedBorder());
        jPanel3.setBounds(new Rectangle(13, 70, 351, 263));
        jPanel3.setLayout(null);
        jButton1.setBounds(new Rectangle(52, 350, 107, 34));
        jButton1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jButton1.setText("修改");
        jButton1.addActionListener(new xiuke3Frame1_jButton1_actionAdapter(this));
        jButton2.setBounds(new Rectangle(187, 350, 114, 34));
        jButton2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jButton2.setText("取消");
        jButton2.addActionListener(new xiuke3Frame1_jButton2_actionAdapter(this));
        bianhao.setBounds(new Rectangle(15, 11, 123, 30));
        jButton3.setBounds(new Rectangle(185, 12, 87, 28));
        jButton3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jButton3.setText("搜索");
        jButton3.addActionListener(new xiuke3Frame1_jButton3_actionAdapter(this));
        jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel1.setText("课程名称");
        jLabel1.setBounds(new Rectangle(25, 15, 127, 31));
        kecheng.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        kecheng.setBounds(new Rectangle(140, 14, 179, 29));
        jLabel2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel2.setText("上课地点");
        jLabel2.setBounds(new Rectangle(24, 58, 96, 30));
        didian.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        didian.setText("");
        didian.setBounds(new Rectangle(140, 58, 179, 29));
        shijian.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        shijian.setText("");
        shijian.setBounds(new Rectangle(140, 100, 179, 29));
        jiage.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jiage.setText("");
        jiage.setBounds(new Rectangle(140, 151, 179, 30));
        jLabel4.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel4.setText("课程价格");
        jLabel4.setBounds(new Rectangle(24, 155, 96, 30));
        jLabel5.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel5.setText("上课时间");
        jLabel5.setBounds(new Rectangle(25, 105, 96, 30));
        jLabel3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel3.setText("授课老师");
        jLabel3.setBounds(new Rectangle(26, 197, 88, 32));
        laoshi.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        laoshi.setBounds(new Rectangle(139, 196, 179, 33));
        this.getContentPane().setBackground(Color.white);
        jPanel1.setBackground(Color.white);
        jLabel6.setText("");
        jLabel6.setBounds(new Rectangle(1, 3, 420, 482));
        jLabel7.setText("");
        jLabel7.setBounds(new Rectangle(1, 0, 422, 292));
        jLabel8.setText("jLabel8");
        jLabel8.setBounds(new Rectangle(2, 5, 393, 392));
        jLabel9.setText("jLabel9");
        jLabel9.setBounds(new Rectangle(0, 4, 348, 256));
        jLabel10.setText("jLabel10");
        jLabel10.setBounds(new Rectangle( -3, 0, 367, 107));
        this.getContentPane().add(jTabbedPane1);
        this.getContentPane().add(jLabel6);
        this.getContentPane().add(jLabel7);
        jTabbedPane1.add(jPanel1, "课程修改");
        jPanel1.add(jPanel2);
        jPanel2.add(bianhao);
        jPanel2.add(jButton3);
        jPanel1.add(jPanel3);
        jPanel3.add(jLabel1);
        jPanel3.add(kecheng);
        jPanel3.add(didian);
        jPanel3.add(shijian);
        jPanel3.add(jiage);
        jPanel3.add(jLabel5);
        jPanel3.add(jLabel2);
        jPanel3.add(laoshi);
        jPanel3.add(jLabel3);
        jPanel3.add(jLabel4);
        jPanel3.add(jLabel9);
        jPanel1.add(jButton1);
        jPanel1.add(jButton2);
        jPanel1.add(jLabel8);
        jPanel1.add(jLabel10);
        jButton1.setIcon(new ImageIcon("an086.gif"));
        jButton2.setIcon(new ImageIcon("an088.gif"));
        jLabel7.setIcon(new ImageIcon("11.jpg"));
        jLabel6.setIcon(new ImageIcon("11.jpg"));
        jLabel8.setIcon(new ImageIcon("11.jpg"));
        jLabel9.setIcon(new ImageIcon("11.jpg"));
        jLabel10.setIcon(new ImageIcon("11.jpg"));
        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();
        }

    }

    JTabbedPane jTabbedPane1 = new JTabbedPane();
    JPanel jPanel1 = new JPanel();
    JPanel jPanel2 = new JPanel();
    JPanel jPanel3 = new JPanel();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JComboBox bianhao = new JComboBox();
    JButton jButton3 = new JButton();
    JLabel jLabel1 = new JLabel();
    JTextField kecheng = new JTextField();
    JLabel jLabel2 = new JLabel();
    JTextField didian = new JTextField();
    JTextField shijian = new JTextField();
    JTextField jiage = new JTextField();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JTextField laoshi = new JTextField();
    JLabel jLabel6 = new JLabel();
    JLabel jLabel7 = new JLabel();
    JLabel jLabel8 = new JLabel();
    JLabel jLabel9 = new JLabel();
    JLabel jLabel10 = new JLabel();
    public void jButton1_actionPerformed(ActionEvent e) {
        float money;
        money=Float.parseFloat(jiage.getText());
        String JG=jiage.getText();
        if(kecheng.getText().length()==0){
             JOptionPane.showMessageDialog(this, "课程名不能为空");
             return;
        }
        if(money<0){
             JOptionPane.showMessageDialog(this, "请输入正确的价格");
             return;
        }
       for(int i=0;i<JG.length();i++){
           if (!Character.isDigit(JG.charAt(i))) {
               JOptionPane.showMessageDialog(null, "价格必须是数字！");
               return;
           }

       }
        try {
            Connectionsql sqlx = new Connectionsql();
            Connection con = sqlx.getConnection();
            Statement stmt = con.createStatement();
            String sql = "update kechengxinxi set kechengmc='" +
                         kecheng.getText() + "',shangkedd='" + didian.getText() +
                         "',shangkesj='" + shijian.getText() + "',kechengjg='" +
                         jiage.getText() + "',laoshi='" + laoshi.getText() +
                         "' where kechengbm1='" + bianhao.getSelectedItem() +
                         "'";
            stmt.executeUpdate(sql);
            JOptionPane.showMessageDialog(this, "课程信息修改成功");
        } catch (Exception xs) {
            xs.printStackTrace();
        }
    }

    public void jButton3_actionPerformed(ActionEvent e) {
        String bh = (String) bianhao.getSelectedItem();
        try {
            Connectionsql sqlx = new Connectionsql();
            Connection con = sqlx.getConnection();
            Statement stmt = con.createStatement();
            String sql = "select * from kechengxinxi where kechengbm1='" + bh +
                         "'";
            ResultSet rs = stmt.executeQuery(sql);
            while (rs.next()) {
                kecheng.setText(rs.getString(2));
                didian.setText(rs.getString(4));
                shijian.setText(rs.getString(6));
                jiage.setText(rs.getString(7));
                laoshi.setText(rs.getString(3));
            }
        } catch (Exception xx) {
            xx.printStackTrace();
        }
    }

    public void jButton2_actionPerformed(ActionEvent e) {
        this.dispose();
    }
}


class xiuke3Frame1_jButton2_actionAdapter implements ActionListener {
    private xiuke3Frame1 adaptee;
    xiuke3Frame1_jButton2_actionAdapter(xiuke3Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class xiuke3Frame1_jButton3_actionAdapter implements ActionListener {
    private xiuke3Frame1 adaptee;
    xiuke3Frame1_jButton3_actionAdapter(xiuke3Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class xiuke3Frame1_jButton1_actionAdapter implements ActionListener {
    private xiuke3Frame1 adaptee;
    xiuke3Frame1_jButton1_actionAdapter(xiuke3Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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