add.java

本系统是一个简单的学生信息管理系统

package studentmessage;

import java.sql.*;
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2006</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class Add
{
  JFrame addframe;
  JPanel panel,panelup,paneldown;
  JLabel lblCustID,lblxm,lblNumber,lblUserName,lblSex,lblAge,lblTel,lblMail,lblAddr,lblyw,lblsx,lblyy,lblzy;
  JTextField txtCustID,txtxm,txtNumber,txtName,txtSex,txtAge,txtTel,txtMail,txtAddr,txtyw,txtsx,txtyy,txtzy;
  JButton  btnInsert,btnback;
  GridLayout gl;
  GridBagLayout g;
  GridBagConstraints c;
  static int i=0;
  public Add()
    {
      addframe=new JFrame("添加");
      panel=new JPanel();
      panelup=new JPanel();
      paneldown=new JPanel();
      lblNumber = new JLabel("学号:");
      lblUserName = new JLabel("姓名:");
      lblSex = new JLabel("性别:");
      lblAge = new JLabel("年龄:");
      lblTel = new JLabel("电话号码:");
      lblMail = new JLabel("邮箱地址:");
      lblAddr = new JLabel("家庭住址:");
      lblyw = new JLabel("语文:");
      lblsx = new JLabel("数学:");
      lblyy = new JLabel("英语:");
      lblzy=new JLabel("专业:");
      btnInsert = new JButton("增加");
      btnback=new JButton("返回");
      txtNumber = new JTextField(12);
      txtName = new JTextField(12);
      txtSex = new JTextField(12);
      txtAge = new JTextField(12);
      txtTel = new JTextField(12);
      txtMail = new JTextField(12);
      txtAddr = new JTextField(12);
      txtyw = new JTextField(12);
      txtsx = new JTextField(12);
      txtyy = new JTextField(12);
      txtzy=new JTextField(12);
      gl = new GridLayout(1, 2);
      g = new GridBagLayout();
      c = new GridBagConstraints();
      panelup.setLayout(g);
      paneldown.setLayout(gl);
      paneldown.add(btnInsert);
      paneldown.add(btnback);

      c.anchor = GridBagConstraints.WEST;
      c.gridx = 0;
      c.gridy = 1;
      g.setConstraints(lblNumber, c);
      panelup.add(lblNumber);

      c.anchor = GridBagConstraints.WEST;
      c.gridx = 1;
      c.gridy = 1;
      g.setConstraints(txtNumber, c);
      panelup.add(txtNumber);

      c.anchor = GridBagConstraints.WEST;
      c.gridx = 0;
      c.gridy = 2;
      g.setConstraints(lblUserName, c);
      panelup.add(lblUserName);

      c.anchor = GridBagConstraints.WEST;
      c.gridx = 1;
      c.gridy = 2;
      g.setConstraints(txtName, c);
      panelup.add(txtName);

      c.anchor = GridBagConstraints.WEST;
      c.gridx = 0;
      c.gridy = 3;
      g.setConstraints(lblSex, c);
      panelup.add(lblSex);

      c.anchor = GridBagConstraints.WEST;
      c.gridx = 1;
      c.gridy = 3;
      g.setConstraints(txtSex, c);
      panelup.add(txtSex);

      c.anchor = GridBagConstraints.WEST;
      c.gridx = 0;
      c.gridy = 4;
      g.setConstraints(lblAge, c);
      panelup.add(lblAge);

      c.anchor = GridBagConstraints.WEST;
      c.gridx = 1;
      c.gridy = 4;
      g.setConstraints(txtAge, c);
      panelup.add(txtAge);

      c.anchor = GridBagConstraints.WEST;
      c.gridx = 0;
      c.gridy = 5;
      g.setConstraints(lblTel, c);
      panelup.add(lblTel);

      c.anchor = GridBagConstraints.WEST;
      c.gridx = 1;
      c.gridy = 5;
      g.setConstraints(txtTel, c);
      panelup.add(txtTel);

      c.anchor = GridBagConstraints.WEST;
      c.gridx = 0;
      c.gridy = 6;
      g.setConstraints(lblMail, c);
      panelup.add(lblMail);

      c.anchor = GridBagConstraints.WEST;
      c.gridx = 1;
      c.gridy = 6;
      g.setConstraints(txtMail, c);
      panelup.add(txtMail);

      c.anchor = GridBagConstraints.WEST;
      c.gridx = 0;
      c.gridy = 7;
      g.setConstraints(lblAddr, c);
      panelup.add(lblAddr);

      c.anchor = GridBagConstraints.WEST;
      c.gridx = 1;
      c.gridy = 7;
      g.setConstraints(txtAddr, c);
      panelup.add(txtAddr);

      c.anchor = GridBagConstraints.WEST;
      c.gridx = 0;
      c.gridy = 8;
      g.setConstraints(lblyw, c);
      panelup.add(lblyw);

      c.anchor = GridBagConstraints.WEST;
      c.gridx = 1;
      c.gridy = 8;
      g.setConstraints(txtyw, c);
      panelup.add(txtyw);

      c.anchor = GridBagConstraints.WEST;
      c.gridx = 0;
      c.gridy = 9;
      g.setConstraints(lblsx, c);
      panelup.add(lblsx);

      c.anchor = GridBagConstraints.WEST;
      c.gridx = 1;
      c.gridy = 9;
      g.setConstraints(txtsx, c);
      panelup.add(txtsx);

      c.anchor = GridBagConstraints.WEST;
      c.gridx = 0;
      c.gridy = 10;
      g.setConstraints(lblyy, c);
      panelup.add(lblyy);

      c.anchor = GridBagConstraints.WEST;
      c.gridx = 1;
      c.gridy = 10;
      g.setConstraints(txtyy, c);
      panelup.add(txtyy);

      c.anchor = GridBagConstraints.WEST;
      c.gridx = 0;
      c.gridy = 11;
      g.setConstraints(lblzy, c);
      panelup.add(lblzy);

      c.anchor = GridBagConstraints.WEST;
      c.gridx = 1;
      c.gridy = 11;
      g.setConstraints(txtzy, c);
      panelup.add(txtzy);
      panel.add(panelup);
      panel.add(paneldown);
      addframe.getContentPane().add(panel);

      AddInf a =new AddInf();
      btnInsert.addActionListener(a);
      btnback.addActionListener(a);
  }
  class AddInf implements ActionListener
{
    public void actionPerformed(ActionEvent evt)
    {
      Object obj = evt.getSource();
      if (obj == btnInsert)
      {
        String strNumber = txtNumber.getText().trim();
        String strName = txtName.getText().trim();
       if(txtNumber.getText().length() <= 0||txtName.getText().length() <= 0)
       JOptionPane.showMessageDialog(addframe, "学号、姓名均不能为空!");

     else
        { String strSex = txtSex.getText().trim();
          String s1="0";
          String s2="1";
          if(!strSex.equals(s1)&&!strSex.equals(s2))
          {
            JOptionPane.showMessageDialog(addframe, "请用0代表男、1代表女!");
           }
        else
        {
        if(strSex.equals(s1)) strSex="男";
        if(strSex.equals(s2)) strSex="女";
        String strAge = txtAge.getText().trim();
        String strTel = txtTel.getText().trim();
        String strMail = txtMail.getText().trim();
        String strAddr = txtAddr.getText().trim();
        String stryw = txtyw.getText().trim();
        String strsx = txtsx.getText().trim();
        String stryy = txtyy.getText().trim();
        String strzy = txtzy.getText().trim();
                if (txtSex.getText().length() > 1
                    || txtAge.getText().length() > 3
                    || txtTel.getText().length() >= 12
                    || txtyw.getText().length() > 3
                    || txtsx.getText().length() > 3
                    || txtyy.getText().length() > 3
                    || txtzy.getText().length() > 3)
            JOptionPane.showMessageDialog(addframe, "请检查输入格式!");
        else
        {
          try
          {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con = DriverManager.getConnection("jdbc:odbc:SDB");
            String str = "insert into Tabel values(?,?,?,?,?,?,?,?,?,?,?)";
            PreparedStatement stmt = con.prepareStatement(str);
            //传递参数
            stmt.setString(1, strNumber);
            stmt.setString(2, strName);
            stmt.setString(3, strSex);
            stmt.setString(4, strAge);
            stmt.setString(5, strTel);
            stmt.setString(6, strMail);
            stmt.setString(7, strAddr);
            stmt.setString(8, stryw);
            stmt.setString(9, strsx);
            stmt.setString(10, stryy);
            stmt.setString(11, strzy);
            ResultSet rs;
            int i = stmt.executeUpdate();
            //返回结果不为空时
            if (i != 0)
            {
              JOptionPane.showMessageDialog(addframe, "添加记录成功！");
              txtNumber.setText("");
              txtName.setText("");
              txtSex.setText("");
              txtAge.setText("");
              txtTel.setText("");
              txtMail.setText("");
              txtAddr.setText("");
              txtyw.setText("");
              txtsx.setText("");
              txtyy.setText("");
              txtzy.setText("");
              con.close();
            }
            else
            {
              JOptionPane.showMessageDialog(addframe, "添加记录失败！");
              txtNumber.setText("");
              txtName.setText("");
              txtSex.setText("");
              txtAge.setText("");
              txtTel.setText("");
              txtMail.setText("");
              txtAddr.setText("");
              txtyw.setText("");
              txtsx.setText("");
              txtyy.setText("");
              txtzy.setText("");
            }
          }
          catch (ClassNotFoundException e1) {
            JOptionPane.showMessageDialog(addframe, e1.getMessage());
          }
          catch (SQLException e2)
          {
            JOptionPane.showMessageDialog(addframe, e2.getMessage());
          }
          }
        }
      }
     }


if (obj == btnback)
        {
          IndexInt index = new IndexInt();
          index.inframe.setVisible(true);
          index.inframe.setBounds(300,200,500,350);
          index.inframe.show();
          addframe.setVisible(false);
      }
    }
  }
}