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,lblTel,lblMail,lblAddr,lblyw,lblsx,lblyy,lblzy;
  JTextField txtCustID,txtxm,txtNumber, txtName,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("姓名:");
      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(10);
      txtName = new JTextField(10);
      txtTel = new JTextField(10);
      txtMail = new JTextField(10);
      txtAddr = new JTextField(10);
      txtyw = new JTextField(10);
      txtsx = new JTextField(10);
      txtyy = new JTextField(10);
      txtzy=new JTextField(10);
      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(lblTel, c);
      panelup.add(lblTel);

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

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

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

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

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

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

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

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

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

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

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

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

      c.anchor = GridBagConstraints.WEST;
      c.gridx = 1;
      c.gridy = 9;
      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)
      {
        i++;
        if(i<2)
        {
          String strNumber = txtNumber.getText().trim();
        String strName = txtName.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 (txtNumber.getText().length() <= 0 ||
            txtName.getText().length() <= 0
            || txtTel.getText().length() <= 0 ||
            txtMail.getText().length() <= 0
            || txtAddr.getText().length() <= 0 || txtyw.getText().length() <= 0
            || txtsx.getText().length() <= 0 || txtyy.getText().length() <= 0
            || txtzy.getText().length() <= 0)
        {
          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, strTel);
            stmt.setString(4, strMail);
            stmt.setString(5, strAddr);
            stmt.setString(6, stryw);
            stmt.setString(7, strsx);
            stmt.setString(8, stryy);
            stmt.setString(9, strzy);
            ResultSet rs;
            int i = stmt.executeUpdate();
            //返回結果不為空時
            if (i != 0)
            {
              JOptionPane.showMessageDialog(addframe, "添加記錄成功！");
              txtNumber.setText("");
              txtName.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("");
              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());
          }
          }
        }
else
        {
          JOptionPane.showMessageDialog(addframe,"記錄已經存在");
        }
        }
        if (obj == btnback)
        {

          IndexInt index = new IndexInt();
          index.inframe.setVisible(true);
          index.inframe.setSize(500,400);
          index.inframe.show();
          addframe.setVisible(false);
      }
    }
  }
}