xxscframe.java~17~

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 xxscFrame extends JFrame {
    public xxscFrame() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        setSize(480, 580);
        jTabbedPane1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jTabbedPane1.setBounds(new Rectangle(6, 22, 459, 459));
        jPanel3.setBackground(Color.pink);
        jPanel3.setBorder(BorderFactory.createEtchedBorder());
        jPanel3.setBounds(new Rectangle(5, 73, 444, 364));
        jPanel3.setLayout(null);
        jLabel2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jLabel2.setText("姓    名  :");
        jLabel2.setBounds(new Rectangle(4, 12, 74, 28));
        jLabel3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jLabel3.setText("性    别  :");
        jLabel3.setBounds(new Rectangle(197, 11, 69, 30));
        jLabel4.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jLabel4.setText("地    址  :");
        jLabel4.setBounds(new Rectangle(4, 52, 75, 38));
        jLabel5.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jLabel5.setText("电    话  :");
        jLabel5.setBounds(new Rectangle(197, 59, 73, 31));
        jLabel6.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jLabel6.setText("专    业  :");
        jLabel6.setBounds(new Rectangle(4, 100, 73, 32));
        jLabel7.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jLabel7.setText("学    院  :");
        jLabel7.setBounds(new Rectangle(197, 100, 70, 36));
        xueyuan.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        xueyuan.setBounds(new Rectangle(280, 105, 131, 27));
        jLabel8.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jLabel8.setText("出生日期:");
        jLabel8.setBounds(new Rectangle(4, 148, 73, 34));
        jLabel9.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jLabel9.setText("籍    贯  :");
        jLabel9.setBounds(new Rectangle(4, 188, 66, 30));
        jLabel10.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jLabel10.setText(" 入学日期:");
        jLabel10.setBounds(new Rectangle(4, 224, 77, 31));
        ruxue.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        ruxue.setText("");
        ruxue.setBounds(new Rectangle(89, 227, 204, 27));
        jLabel11.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jLabel11.setText("备    注  :");
        jLabel11.setBounds(new Rectangle(4, 260, 76, 27));
        jButton1.setBounds(new Rectangle(41, 304, 110, 38));
        jButton1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jButton1.setText("删 除");
        jButton1.addActionListener(new xxscFrame_jButton1_actionAdapter(this));
        jButton2.setBounds(new Rectangle(162, 303, 125, 38));
        jButton2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jButton2.setText("取  消");
        jButton2.addActionListener(new xxscFrame_jButton2_actionAdapter(this));
        xingming.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        xingming.setBounds(new Rectangle(89, 11, 103, 30));
        xingbie.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        xingbie.setBounds(new Rectangle(280, 15, 129, 31));
        dizhi.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        dizhi.setBounds(new Rectangle(89, 55, 103, 33));
        dianhua.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        dianhua.setBounds(new Rectangle(280, 60, 129, 29));
        jiguan.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jiguan.setBounds(new Rectangle(89, 191, 102, 29));
        zhuanye.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        zhuanye.setBounds(new Rectangle(89, 100, 101, 29));
        chusheng.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        chusheng.setBounds(new Rectangle(89, 146, 206, 30));
        beizhu.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        beizhu.setBounds(new Rectangle(89, 262, 207, 28));
        xuehao.setBounds(new Rectangle(187, 16, 133, 30));
        jButton3.setBounds(new Rectangle(326, 13, 104, 36));
        jButton3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        jButton3.setText("查询");
        jButton3.addActionListener(new xxscFrame_jButton3_actionAdapter(this));
        this.getContentPane().setBackground(Color.white);
        jPanel2.setBackground(Color.pink);
        jLabel12.setText("jLabel12");
        jLabel12.setBounds(new Rectangle(3, 2, 445, 494));
        jLabel13.setText("jLabel13");
        jLabel13.setBounds(new Rectangle(2, 2, 442, 353));
        this.getContentPane().add(jTabbedPane1);
        jPanel1.setLayout(null);
        jPanel1.setBackground(Color.lightGray);
        jPanel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jPanel1.setBorder(BorderFactory.createEtchedBorder());
        jPanel2.setBorder(BorderFactory.createEtchedBorder());
        jPanel2.setBounds(new Rectangle(3, 5, 443, 63));
        jPanel2.setLayout(null);
        jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jLabel1.setForeground(Color.black);
        jLabel1.setText("请选择要删除学员的学号:");
        jLabel1.setBounds(new Rectangle(12, 14, 184, 33));
        jTabbedPane1.add(jPanel1, "信息删除");
        jPanel1.add(jPanel2);
        jPanel1.add(jPanel3);
        jPanel3.add(jLabel3);
        jPanel3.add(xueyuan);
        jPanel3.add(jButton1);
        jPanel3.add(jButton2);
        jPanel3.add(jLabel7);
        jPanel3.add(jLabel5);
        jPanel3.add(dizhi);
        jPanel3.add(xingming);
        jPanel3.add(xingbie);
        jPanel3.add(jLabel2);
        jPanel3.add(jLabel4);
        jPanel3.add(jLabel6);
        jPanel3.add(jLabel8);
        jPanel3.add(jLabel11);
        jPanel3.add(jLabel9);
        jPanel3.add(jLabel10);
        jPanel3.add(ruxue);
        jPanel3.add(dianhua);
        jPanel3.add(jiguan);
        jPanel3.add(zhuanye);
        jPanel3.add(chusheng);
        jPanel3.add(beizhu);
        jPanel3.add(jLabel13);
        jPanel2.add(jLabel1);
        jPanel2.add(xuehao);
        jPanel2.add(jButton3);
        jPanel2.add(jLabel12);
        jButton1.setIcon(new ImageIcon("an086.gif"));
        jButton2.setIcon(new ImageIcon("an088.gif"));
        jButton3.setIcon(new ImageIcon("an086.gif"));
        jLabel12.setIcon(new ImageIcon("11.jpg"));
        jLabel13.setIcon(new ImageIcon("11.jpg"));
        try{
           Connectionsql c=new Connectionsql();
           Connection con=c.getConnection();
           Statement pstmt=con.createStatement();
           String sql="select * from student";
           ResultSet rs=pstmt.executeQuery(sql);
           while(rs.next()){
              xuehao.addItem(rs.getString(1));
              }
       }catch(Exception xx){
           xx.printStackTrace();
       }

    }

    String XH;
    JTabbedPane jTabbedPane1 = new JTabbedPane();
    JPanel jPanel1 = new JPanel();
    JPanel jPanel2 = new JPanel();
    JLabel jLabel1 = new JLabel();
    JPanel jPanel3 = new JPanel();
    JLabel jLabel2 = new JLabel();
    JTextField xingming = new JTextField();
    JLabel jLabel3 = new JLabel();
    JTextField xingbie = new JTextField();
    JLabel jLabel4 = new JLabel();
    JTextField dizhi = new JTextField();
    JLabel jLabel5 = new JLabel();
    JTextField dianhua = new JTextField();
    JLabel jLabel6 = new JLabel();
    JTextField zhuanye = new JTextField();
    JLabel jLabel7 = new JLabel();
    JTextField xueyuan = new JTextField();
    JLabel jLabel8 = new JLabel();
    JTextField chusheng = new JTextField();
    JLabel jLabel9 = new JLabel();
    JLabel jLabel10 = new JLabel();
    JTextField ruxue = new JTextField();
    JLabel jLabel11 = new JLabel();
    JTextField beizhu = new JTextField();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JTextField jiguan = new JTextField();
    JComboBox xuehao = new JComboBox();
    JButton jButton3 = new JButton();
    JLabel jLabel12 = new JLabel();
    JLabel jLabel13 = new JLabel();


    class xxscFrame_jButton2_actionAdapter implements ActionListener {
        private xxscFrame adaptee;
        xxscFrame_jButton2_actionAdapter(xxscFrame adaptee) {
            this.adaptee = adaptee;
        }

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


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

    public void jButton1_actionPerformed(ActionEvent e) {
        String XX=dianhua.getText();
        String xb=xingbie.getText();
        if(xingming.getText().length()==0){
            JOptionPane.showMessageDialog(null,"姓名不能为空");
            return;
        }
        if (!(xb.equals("男") || xb.equals("女"))) {
                     JOptionPane.showMessageDialog(null, "请输入男或女！");
                     return;
                 }

        if(dianhua.getText().length()>13){
            JOptionPane.showMessageDialog(null,"请输入正确的电话号码");
            return;
        }
        for(int i=0;i<XX.length();i++){
            if (!Character.isDigit(XX.charAt(i))) {
                       JOptionPane.showMessageDialog(null, "电话号码必须是数字！");
                       return;
                   }
       }
       if (chusheng.getText().indexOf("-", 0) == -1 ||
           chusheng.getText().indexOf("-", 0) != 4 ||
           chusheng.getText().substring(chusheng.getText().indexOf("-", 0) + 1).indexOf("-") != 2
           || chusheng.getText().length() != 10) {
           JOptionPane.showMessageDialog(this, "日期格式错误!\n正确格式:YYYY-MM-DD");
           return;
       }
       if (ruxue.getText().indexOf("-", 0) == -1 ||
           ruxue.getText().indexOf("-", 0) != 4 ||
           ruxue.getText().substring(ruxue.getText().indexOf("-", 0) + 1).indexOf("-") != 2
           || ruxue.getText().length() != 10) {
           JOptionPane.showMessageDialog(this, "日期格式错误!\n正确格式:YYYY-MM-DD");
           return;
       }



        try{
          Connectionsql c=new Connectionsql();
          Connection con=c.getConnection();
          Statement pstmt=con.createStatement();
          String sql="delete from student where num like '"+XH+"' ";
          pstmt.executeUpdate(sql);
          JOptionPane.showMessageDialog(this,"删除成功");
      }catch(Exception xx){
          xx.printStackTrace();
      }

    }

    public void jButton3_actionPerformed(ActionEvent e) {
        try{
            XH=(String)xuehao.getSelectedItem();
            Connectionsql c=new Connectionsql();
                   Connection con=c.getConnection();
                   Statement pstmt=con.createStatement();
                   String sql="select * from student where num='"+XH+"'";
                   ResultSet rs=pstmt.executeQuery(sql);
                   while(rs.next()){
                       xingming.setText(rs.getString(2));
                       xingbie.setText(rs.getString(3));
                       dizhi.setText(rs.getString(4));
                       dianhua.setText(rs.getString(5));
                       zhuanye.setText(rs.getString(6));
                       xueyuan.setText(rs.getString(7));
                       chusheng.setText(rs.getString(8));
                       jiguan.setText(rs.getString(9));
                       ruxue.setText(rs.getString(10));
                       beizhu.setText(rs.getString(11));
                    }
               }catch(Exception xx){
                   xx.printStackTrace();
        }
    }

}





class xxscFrame_jButton3_actionAdapter implements ActionListener {
    private xxscFrame adaptee;
    xxscFrame_jButton3_actionAdapter(xxscFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class xxscFrame_jButton1_actionAdapter implements ActionListener {
    private xxscFrame adaptee;
    xxscFrame_jButton1_actionAdapter(xxscFrame adaptee) {
        this.adaptee = adaptee;
    }

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