xinxiugaiframe1.java~20~

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

package student;

import java.awt.BorderLayout;

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

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class xinxiugaiFrame1 extends JFrame {
    public xinxiugaiFrame1() {
        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.setBorder(BorderFactory.createEtchedBorder());
        jTabbedPane1.setToolTipText("");
        jTabbedPane1.setBounds(new Rectangle(16, 17, 321, 383));
        jPanel1.setLayout(null);
        jPanel2.setBorder(BorderFactory.createEtchedBorder());
        jPanel2.setBounds(new Rectangle(2, 6, 321, 44));
        jPanel2.setLayout(null);
        xuehao.setBounds(new Rectangle(142, 7, 85, 26));
        jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel1.setText("请输入要修改的学号");
        jLabel1.setBounds(new Rectangle(5, 4, 129, 29));
        jButton1.setBounds(new Rectangle(236, 7, 71, 26));
        jButton1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jButton1.setText("搜索");
        jButton1.addActionListener(new xinxiugaiFrame1_jButton1_actionAdapter(this));
        jPanel3.setBorder(BorderFactory.createEtchedBorder());
        jPanel3.setBounds(new Rectangle(4, 57, 315, 272));
        jPanel3.setLayout(null);
        jLabel2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel2.setText("学生姓名");
        jLabel2.setBounds(new Rectangle(16, 14, 111, 29));
        xingming.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        xingming.setText("");
        xingming.setBounds(new Rectangle(143, 19, 150, 33));
        jLabel3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel3.setText("专业名称");
        jLabel3.setBounds(new Rectangle(16, 144, 113, 36));
        dizhi.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        dizhi.setText("");
        dizhi.setBounds(new Rectangle(143, 59, 150, 33));
        jLabel4.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel4.setText("家庭住址");
        jLabel4.setBounds(new Rectangle(16, 56, 113, 36));
        jLabel5.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel5.setText("电话号码");
        jLabel5.setBounds(new Rectangle(16, 97, 113, 36));
        dianhua.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        dianhua.setText("");
        dianhua.setBounds(new Rectangle(143, 100, 150, 33));
        zhuanye.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        zhuanye.setText("");
        zhuanye.setBounds(new Rectangle(142, 144, 150, 33));
        zhuanye.addActionListener(new
                                  xinxiugaiFrame1_jTextField5_actionAdapter(this));
        jLabel6.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel6.setText("备注");
        jLabel6.setBounds(new Rectangle(16, 185, 113, 36));
        beizhu.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        beizhu.setLineWrap(true);
        beizhu.setBounds(new Rectangle(133, 188, 157, 70));
        jButton2.setBounds(new Rectangle(333, 327, 70, 28));
        jButton2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        jButton2.setText("取消");
        jButton3.setBounds(new Rectangle(334, 281, 70, 28));
        jButton3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        jButton3.setText("修改");
        this.getContentPane().add(jTabbedPane1);
        this.getContentPane().add(jButton3);
        this.getContentPane().add(jButton2);
        jTabbedPane1.add(jPanel1, "修改学生信息");
        jPanel1.add(jPanel2);
        jPanel3.add(jLabel2);
        jPanel3.add(jLabel4);
        jPanel3.add(jLabel6);
        jPanel3.add(beizhu);
        jPanel3.add(jLabel3);
        jPanel3.add(jLabel5);
        jPanel3.add(xingming);
        jPanel3.add(dizhi);
        jPanel3.add(dianhua);
        jPanel3.add(zhuanye);
        jPanel2.add(jLabel1);
        jPanel2.add(xuehao);
        jPanel2.add(jButton1);
        jPanel1.add(jPanel3);
    }

    JTabbedPane jTabbedPane1 = new JTabbedPane();
    JPanel jPanel1 = new JPanel();
    JPanel jPanel2 = new JPanel();
    JTextField xuehao = new JTextField();
    JLabel jLabel1 = new JLabel();
    JButton jButton1 = new JButton();
    JPanel jPanel3 = new JPanel();
    JLabel jLabel2 = new JLabel();
    JTextField xingming = new JTextField();
    JLabel jLabel3 = new JLabel();
    JTextField dizhi = new JTextField();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JTextField dianhua = new JTextField();
    JTextField zhuanye = new JTextField();
    JLabel jLabel6 = new JLabel();
    JTextArea beizhu = new JTextArea();
    JButton jButton2 = new JButton();
    JButton jButton3 = new JButton();
    public void jTextField5_actionPerformed(ActionEvent e) {

    }

    public void jButton1_actionPerformed(ActionEvent e) {
        String XH = xuehao.getText();
        String XM = xingming.getText();
        String DZ = dizhi.getText();
        String DH = dianhua.getText();
        String ZY = zhuanye.getText();
        String BZ = beizhu.getText();
        if (xuehao.getText().length() == 0) {
            JOptionPane.showMessageDialog(this, "请输入你要修改的学号");
            xuehao.setText("");
            return;

        }
         for(int i=0;i<XH.length();i++){
             if (!Character.isDigit(XH.charAt(i))) {
             JOptionPane.showMessageDialog(null, "学号必须是数字！");
            return;
         }
                }
        try {
            Connectionsql s = new Connectionsql();
            Connection con = s.getConnection();
            Statement pstmt = con.createStatement();
            String sql = "select * from student where num='" + XH + "' ";
            ResultSet rs = pstmt.executeQuery(sql);
            if (!rs.next()) {
                JOptionPane.showMessageDialog(this, "本学校无此学生");
                xuehao.setText("");
                return;
            } else {
                xingming.setText(rs.getString(2));
                dizhi.setText(rs.getString(4));
                dianhua.setText(rs.getString(5));
                zhuanye.setText(rs.getString(6));
                beizhu.setText(rs.getString(11));
            }
        } catch (Exception xx) {
            xx.printStackTrace();
        }

    }
}


class xinxiugaiFrame1_jButton1_actionAdapter implements ActionListener {
    private xinxiugaiFrame1 adaptee;
    xinxiugaiFrame1_jButton1_actionAdapter(xinxiugaiFrame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class xinxiugaiFrame1_jTextField5_actionAdapter implements ActionListener {
    private xinxiugaiFrame1 adaptee;
    xinxiugaiFrame1_jTextField5_actionAdapter(xinxiugaiFrame1 adaptee) {
        this.adaptee = adaptee;
    }

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