frame1.java~21~

学生管理系统

package student;

import java.awt.BorderLayout;
import java.awt.Dimension;

import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JLabel;
import java.awt.Rectangle;
import javax.swing.JTextField;
import javax.swing.JComboBox;
import javax.swing.JButton;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JOptionPane;
import java.sql.ResultSet;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class Frame1 extends JFrame {
    JPanel contentPane;
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JTextField textname = new JTextField();
    JComboBox cbxgrade = new JComboBox();
    JComboBox cbxsex = new JComboBox();
    JTextField textscore = new JTextField();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JButton jButton3 = new JButton();
    JButton jButton4 = new JButton();
    dbmanager join=new dbmanager();
    public Frame1() {
        try {
            setDefaultCloseOperation(EXIT_ON_CLOSE);
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    /**
     * Component initialization.
     *
     * @throws java.lang.Exception
     */
    private void jbInit() throws Exception {
        contentPane = (JPanel) getContentPane();
        contentPane.setLayout(null);
        setSize(new Dimension(337, 291));
        setTitle("学生管理系统");
        jLabel1.setText("姓名:");
        jLabel1.setBounds(new Rectangle(45, 50, 42, 15));
        jLabel2.setText("年级:");
        jLabel2.setBounds(new Rectangle(45, 106, 42, 15));
        jLabel3.setText("性别:");
        jLabel3.setBounds(new Rectangle(45, 156, 42, 15));
        jLabel4.setText("成绩");
        jLabel4.setBounds(new Rectangle(45, 210, 42, 15));
        textname.setBounds(new Rectangle(89, 43, 101, 25));
        cbxgrade.setBounds(new Rectangle(90, 102, 98, 24));
        cbxsex.setBounds(new Rectangle(90, 153, 98, 24));
        textscore.setBounds(new Rectangle(89, 209, 101, 25));
        jButton1.setBounds(new Rectangle(223, 42, 66, 27));
        jButton1.setText("增加");
        jButton1.addActionListener(new Frame1_jButton1_actionAdapter(this));
        jButton2.setBounds(new Rectangle(223, 100, 66, 27));
        jButton2.setText("删除");
        jButton2.addActionListener(new Frame1_jButton2_actionAdapter(this));
        jButton3.setBounds(new Rectangle(223, 157, 66, 27));
        jButton3.setText("更新");
        jButton4.setBounds(new Rectangle(223, 208, 66, 27));
        jButton4.setText("查询");
        jButton4.addActionListener(new Frame1_jButton4_actionAdapter(this));
        contentPane.add(jLabel1);
        contentPane.add(jLabel3);
        contentPane.add(jLabel2);
        contentPane.add(textname);
        contentPane.add(cbxgrade);
        contentPane.add(cbxsex);
        contentPane.add(jLabel4);
        contentPane.add(textscore);
        contentPane.add(jButton1);
        contentPane.add(jButton2);
        contentPane.add(jButton3);
        contentPane.add(jButton4);
        this.cbxgrade.addItem("1");
              this.cbxgrade.addItem("2");
                    this.cbxgrade.addItem("3");
                    this.cbxgrade.setSelectedIndex(1);
       this.cbxsex.addItem("男");
       this.cbxsex.addItem("女");
       this.cbxsex.setSelectedIndex(0);



    }

    public void jButton1_actionPerformed(ActionEvent e) {
        int rows=0;
     String name=this.textname.getText().trim();
     String score=this.textscore.getText().trim();
     int grade=-1;
     int index=this.cbxgrade.getSelectedIndex();
     if( index==0)
     {
         grade = 1;
     } else if (index == 2) {
         grade = 2;
     } else {
         grade = 3;
     }
      String sex=null;
      int inx=this.cbxsex.getSelectedIndex();
      if(inx==0)
      {
      sex="F";
      }    else
      {
      sex="M";
      }
      if(name.length()>5||name.length()==0)
      {
      JOptionPane.showMessageDialog(this,"姓名输入不合法");
      return;
      }
      int score_int=Integer.parseInt(score);
      if(score_int<=16||score_int>=28)
      {
        JOptionPane.showMessageDialog(this,"成绩输入不合法");
        return;
      }
      String sql=
      "insert into student values('"+name+"','"+sex+"',"+grade+","+score_int+",'')";
      try {
          rows=join.exeupdate(sql);
      } catch (Exception ex) {
          System.out.println(ex);
      }
      if(rows!=0)
      {
        JOptionPane.showMessageDialog(this,"记录插入成功");
        return;
      }
     JOptionPane.showMessageDialog(this,"记录插入失败");


    }

    public void jButton2_actionPerformed(ActionEvent e) {
        int rows=0;
        String name=this.textname.getText().trim();
        if(name.equals(""))
        {
               JOptionPane.showMessageDialog(this, "请输入姓名");
               return;

        }
        String sql="delete student where name='"+name+"'";
        try {
            rows = join.exeupdate(sql);
        } catch (Exception ex) {
            System.out.println(ex);
        }
        if (rows != 0) {
            JOptionPane.showMessageDialog(this, "删除插入成功");
            return;
        }
        JOptionPane.showMessageDialog(this, "删除失败");


        }

    public void jButton4_actionPerformed(ActionEvent e) {
        String name=this.textname.getText().trim();
        ResultSet rs=null;
        String sql;
        if(name.equals(""))
     {
            JOptionPane.showMessageDialog(this, "请输入姓名");
            return;

     }
     sql="select * from student where name='"+name+"'";
     try {
         rs=join.exeselect(sql);
         if(rs==null)
         {
               JOptionPane.showMessageDialog(this, "没有些用户");
               return;
         }
         Object [] strname=new Object[6];
        while(rs.next())
        {
             for(int i=0;i<6;i++)
             {
             strname[i]=rs.getString(i+1);
             }
         JOptionPane.showMessageDialog(this, "成功");
          }
            JOptionPane.showMessageDialog(this, ((Object)strname[0]).toString());

          this.textscore.setText(((Object)strname[5]).toString());


         this.cbxgrade.setSelectedIndex( Integer.parseInt(((Object)strname[5]).toString()) );

     } catch (Exception ex) {

     }



    }

}


class Frame1_jButton4_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jButton4_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame1_jButton2_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jButton2_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame1_jButton1_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jButton1_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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