shanyonghuframe1.java

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

package student;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import javax.swing.JPanel;
import java.awt.*;
import javax.swing.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Statement;
import java.sql.*;
import javax.swing.table.JTableHeader;
import javax.swing.table.DefaultTableModel;

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

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        jPanel1.setBackground(Color.white);
        jPanel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jPanel1.setBorder(BorderFactory.createEtchedBorder());
        jPanel1.setBounds(new Rectangle(22, 10, 393, 52));
        jPanel1.setLayout(null);
        yonghu.setBounds(new Rectangle(149, 9, 229, 32));
        jButton1.setBounds(new Rectangle(131, 65, 85, 32));
        jButton1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jButton1.setText("取消");
        jButton1.addActionListener(new shanyonghuFrame1_jButton1_actionAdapter(this));
        jButton2.setBounds(new Rectangle(40, 65, 91, 31));
        jButton2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jButton2.setText("删除");
        jButton2.addActionListener(new shanyonghuFrame1_jButton2_actionAdapter(this));
        jTable1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        jTable1.setBounds(new Rectangle(23, 118, 390, 275));
        jTableHeader2.setBackground(Color.white);
        jTableHeader2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        jTableHeader2.setBounds(new Rectangle(17, 97, 395, 22));
        jTableHeader2.setLayout(null);
        jButton3.setBounds(new Rectangle(217, 65, 89, 31));
        jButton3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jButton3.setText("搜索");
        jButton3.addActionListener(new shanyonghuFrame1_jButton3_actionAdapter(this));
        jButton4.setBounds(new Rectangle(307, 65, 88, 31));
        jButton4.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jButton4.setText("刷新");
        jButton4.addActionListener(new shanyonghuFrame1_jButton4_actionAdapter(this));
        jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel2.setBackground(Color.white);
        jLabel2.setBounds(new Rectangle( -3, 0, 477, 425));
        jLabel3.setBounds(new Rectangle(12, 110, 420, 300));
        jLabel4.setBounds(new Rectangle(17, 55, 408, 75));
        jLabel5.setBounds(new Rectangle(7, 90, 418, 46));
        jPanel1.add(jLabel1);
        jPanel1.add(yonghu);
        this.getContentPane().add(jPanel1);
        this.getContentPane().add(jTable1);
        this.getContentPane().add(jTableHeader2);
        this.getContentPane().add(jButton2);
        this.getContentPane().add(jButton1);
        this.getContentPane().add(jButton3);
        this.getContentPane().add(jButton4);
        this.getContentPane().add(jLabel2);
        this.getContentPane().add(jLabel3);
        this.getContentPane().add(jLabel4);
        this.getContentPane().add(jLabel5);
        jLabel1.setText("请输入要删除的用户名");
        jLabel2.setIcon(new ImageIcon("11.jpg"));
         jLabel3.setIcon(new ImageIcon("11.jpg"));
          jLabel4.setIcon(new ImageIcon("11.jpg"));
           jLabel5.setIcon(new ImageIcon("11.jpg"));
       jLabel1.setBounds(new Rectangle(9, 9, 139, 32));
    }

    JPanel jPanel1 = new JPanel();
    JLabel jLabel1 = new JLabel();
    JTextField yonghu = new JTextField();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    Object[][] cells = { {" ", " ", " ", " "},
    };
    String tableheader[] = {"用户名", "密码", "权限", "状态"};
    JTable jTable1 = new JTable(cells, tableheader);
    JTableHeader jTableHeader1 = jTable1.getTableHeader();
    JTableHeader jTableHeader2 = jTable1.getTableHeader();
    JButton jButton3 = new JButton();
    JButton jButton4 = new JButton();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    public void jButton1_actionPerformed(ActionEvent e) {

    }

    public void jButton2_actionPerformed(ActionEvent e) {
        String yh = yonghu.getText();
        if (yh.length() == 0) {
            JOptionPane.showMessageDialog(null, "请输入要删除的用户名");
            return;
        }
        try {
            Connectionsql s = new Connectionsql();
            Connection con = s.getConnection();
            Statement pstmt = con.createStatement();
            String sql = "delete from zhanghu where zhanghao='" + yh + "'";
            pstmt.executeUpdate(sql);
            JOptionPane.showMessageDialog(null, "删除成功");
            yonghu.setText("");
        } catch (Exception xa) {
            xa.printStackTrace();
        }
    }

    public void jButton3_actionPerformed(ActionEvent e) {
        try {
            Connectionsql s = new Connectionsql();
            Connection con = s.getConnection();
            Statement pstmt = con.createStatement();
            String sql = "select * from zhanghu";
            ResultSet rs = pstmt.executeQuery(sql);
            DefaultTableModel model1 = new DefaultTableModel();
            model1.setColumnIdentifiers(tableheader);
            while (rs.next()) {
                model1.addRow(new Object[] {rs.getString(1), rs.getString(2),
                              rs.getString(3), rs.getString(4)});
            }
            jTable1.setModel(model1);
            JTable jTable1 = new JTable(cells, tableheader);
            jTable1.setPreferredSize(new Dimension(800, 600));
            jTable1.setRowHeight(25);
            jTable1.setShowGrid(false);
        } catch (Exception xx) {
            xx.printStackTrace();
        }
    }

    public void jButton4_actionPerformed(ActionEvent e) {
        jTable1.removeAll();
        try {
            Connectionsql s = new Connectionsql();
            Connection con = s.getConnection();
            Statement pstmt = con.createStatement();
            String sql = "select * from zhanghu";
            ResultSet rs = pstmt.executeQuery(sql);
            DefaultTableModel model1 = new DefaultTableModel();
            model1.setColumnIdentifiers(tableheader);
            while (rs.next()) {
                model1.addRow(new Object[] {rs.getString(1), rs.getString(2),
                              rs.getString(3), rs.getString(4)});
            }
            jTable1.setModel(model1);

        } catch (Exception yy) {
            yy.printStackTrace();
        }
    }
}


class shanyonghuFrame1_jButton4_actionAdapter implements ActionListener {
    private shanyonghuFrame1 adaptee;
    shanyonghuFrame1_jButton4_actionAdapter(shanyonghuFrame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class shanyonghuFrame1_jButton3_actionAdapter implements ActionListener {
    private shanyonghuFrame1 adaptee;
    shanyonghuFrame1_jButton3_actionAdapter(shanyonghuFrame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class shanyonghuFrame1_jButton2_actionAdapter implements ActionListener {
    private shanyonghuFrame1 adaptee;
    shanyonghuFrame1_jButton2_actionAdapter(shanyonghuFrame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class shanyonghuFrame1_jButton1_actionAdapter implements ActionListener {
    private shanyonghuFrame1 adaptee;
    shanyonghuFrame1_jButton1_actionAdapter(shanyonghuFrame1 adaptee) {
        this.adaptee = adaptee;
    }

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