xxzjframe.java~17~

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.*;


/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class xxzjFrame extends JFrame {

    public xxzjFrame() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        jPanel1.setBackground(Color.pink);
        jPanel1.setBorder(BorderFactory.createEtchedBorder());
        jPanel1.setBounds(new Rectangle(9, 10, 415, 503));
        jPanel1.setLayout(null);
        this.getContentPane().setBackground(Color.white);
        jLabel2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jLabel2.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel2.setText("地址");
        jLabel2.setBounds(new Rectangle(42, 175, 69, 29));
        jLabel3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jLabel3.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel3.setText("性别");
        jLabel3.setBounds(new Rectangle(42, 135, 69, 29));
        jLabel5.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jLabel5.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel5.setText("电话");
        jLabel5.setBounds(new Rectangle(42, 214, 69, 29));
        jLabel7.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jLabel7.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel7.setText("籍贯");
        jLabel7.setBounds(new Rectangle(42, 254, 69, 29));
        jLabel8.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jLabel8.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel8.setText("出生年月");
        jLabel8.setBounds(new Rectangle(42, 293, 69, 29));
        jLabel9.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jLabel9.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel9.setText("入学年月");
        jLabel9.setBounds(new Rectangle(42, 333, 69, 29));
        dh.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        dh.setText("");
        dh.setBounds(new Rectangle(141, 214, 153, 32));
        xb.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        xb.setBounds(new Rectangle(141, 135, 68, 31));
        jg.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jg.setText("");
        jg.setBounds(new Rectangle(141, 254, 153, 32));
        cs.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        cs.setText("");
        cs.setBounds(new Rectangle(141, 293, 153, 32));
        xh.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        xh.setText("");
        xh.setBounds(new Rectangle(141, 56, 153, 32));
        dz.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        dz.setText("");
        dz.setBounds(new Rectangle(141, 175, 153, 32));
        xm.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        xm.setBounds(new Rectangle(141, 96, 153, 32));
        rx.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        rx.setBounds(new Rectangle(141, 333, 153, 32));
        jLabel4.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jLabel4.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel4.setText("学号");
        jLabel4.setBounds(new Rectangle(42, 56, 69, 29));
        jLabel19.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jLabel19.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel19.setText("姓名");
        jLabel19.setBounds(new Rectangle(42, 96, 69, 29));
        qd.setBackground(Color.pink);
        qd.setBounds(new Rectangle(73, 437, 113, 40));
        qd.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        qd.setForeground(UIManager.getColor("windowBorder"));
        qd.setText("确定");
        qd.addActionListener(new xxzjFrame_qd_actionAdapter(this));
        qx.setBounds(new Rectangle(222, 439, 116, 38));
        qx.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        qx.setText("取消");
        qx.addActionListener(new xxzjFrame_qx_actionAdapter(this));
        bz.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        bz.setBounds(new Rectangle(141, 372, 215, 49));
        jLabel6.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jLabel6.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel6.setText("备注");
        jLabel6.setBounds(new Rectangle(42, 372, 69, 29));
        jPanel2.setBackground(Color.pink);
        jPanel2.setBorder(BorderFactory.createEtchedBorder());
        jPanel2.setBounds(new Rectangle(19, 6, 371, 41));
        jPanel2.setLayout(null);
        jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jLabel1.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel1.setText("学生信息增加");
        jLabel1.setBounds(new Rectangle(67, 7, 207, 27));
        jLabel10.setText("jLabel10");
        jLabel10.setBounds(new Rectangle(3, 47, 410, 448));
        jPanel1.add(dh);
        jPanel1.add(xm);
        jPanel1.add(dz);
        jPanel1.add(xb);
        jPanel1.add(xh);
        jPanel1.add(jg);
        jPanel1.add(cs);
        jPanel1.add(rx);
        jPanel1.add(bz);
        jPanel1.add(jLabel4);
        jPanel1.add(jLabel19);
        jPanel1.add(jLabel3);
        jPanel1.add(jLabel2);
        jPanel1.add(jLabel5);
        jPanel1.add(jLabel7);
        jPanel1.add(jLabel8);
        jPanel1.add(jLabel9);
        jPanel1.add(jLabel6);
        jPanel1.add(jPanel2);
        jPanel2.add(jLabel1);
        jPanel1.add(qd);
        jPanel1.add(qx);
        jPanel1.add(jLabel10);
        this.getContentPane().add(jPanel1);
        xb.addItem("男");
        xb.addItem("女");
        qd.setIcon(new ImageIcon("an086.gif"));
        qx.setIcon(new ImageIcon("an088.gif"));
        jLabel10.setIcon(new ImageIcon("10.jpg"));
    }

    JPanel jPanel1 = new JPanel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JLabel jLabel7 = new JLabel();
    JLabel jLabel8 = new JLabel();
    JLabel jLabel9 = new JLabel();
    JTextField dh = new JTextField();
    JComboBox xb = new JComboBox();
    JTextField jg = new JTextField();
    JTextField cs = new JTextField();
    JTextField xh = new JTextField();
    JTextField dz = new JTextField();
    JTextField xm = new JTextField();
    JTextField rx = new JTextField();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel19 = new JLabel();
    JButton qd = new JButton();
    JButton qx = new JButton();
    JTextArea bz = new JTextArea();
    JLabel jLabel6 = new JLabel();
    JPanel jPanel2 = new JPanel();
    JLabel jLabel1 = new JLabel();
    JLabel jLabel10 = new JLabel();
    public void qd_actionPerformed(ActionEvent e) {

        String XH=xh.getText();
        String XM=xm.getText();
        String DZ=dz.getText();
        String DH=dh.getText();
        String BZ=bz.getText();
        String JG=jg.getText();
        String CS=cs.getText();
        String RX=rx.getText();
        String XB= xb.getSelectedItem().toString();
        if(xh.getText().equals("")||xm.getText().equals("")||dz.getText().equals("")
           ||dh.getText().equals("")||jg.getText().equals("")||cs.getText().equals("")
           ||rx.getText().equals("")){
           JOptionPane.showMessageDialog(this,"请将表格填写完整！");
           return;
       }
       if (cs.getText().indexOf("-", 0) == -1 ||
               cs.getText().indexOf("-", 0) != 4 ||
               cs.
               getText().substring(cs.getText().indexOf("-", 0) + 1).
               indexOf("-") != 2
               || cs.getText().length() != 10) {
               JOptionPane.showMessageDialog(this, "日期格式错误!\n正确格式:YYYY-MM-DD");
               return;
           }
           if (rx.getText().indexOf("-", 0) == -1 ||
               rx.getText().indexOf("-", 0) != 4 ||
               rx.
               getText().substring(rx.getText().indexOf("-", 0) + 1).
               indexOf("-") != 2
               || rx.getText().length() != 10) {
               JOptionPane.showMessageDialog(this, "日期格式错误!\n正确格式:YYYY-MM-DD");
               return;
           }
           for (int i = 0; i < DH.length(); i++) {
            if (!Character.isDigit(DH.charAt(i))) {
                JOptionPane.showMessageDialog(null, "电话必须是数字！");
                return;
            }
        }
        if (DH.length()>15) {
               JOptionPane.showMessageDialog(null, "电话号码长度不能超过15位！");
               return;
           }





        try{
            Connectionsql sqlx=new Connectionsql();
            Connection con=sqlx.getConnection();
            Statement stmt=con.createStatement();
            String sql1="insert into student(num,name,sex,dizhi,dianhua,jiguan,chusheng,beizhu) values ('"+XH+"','"+XM+"','"+XB+"','"+DZ+"','"+DH+"','"+JG+"','"+CS+"','"+BZ+"') ";
            stmt.executeUpdate(sql1);
            con.close();
           JOptionPane.showMessageDialog(this, "添加成功", "success",
                                         JOptionPane.INFORMATION_MESSAGE);
        }catch(Exception bug){
                bug.printStackTrace();
        }
    }

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


class xxzjFrame_qd_actionAdapter implements ActionListener {
    private xxzjFrame adaptee;
    xxzjFrame_qd_actionAdapter(xxzjFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class xxzjFrame_qx_actionAdapter implements ActionListener {
    private xxzjFrame adaptee;
    xxzjFrame_qx_actionAdapter(xxzjFrame adaptee) {
        this.adaptee = adaptee;
    }

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