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 Systemreg extends JFrame
{
  JPanel panel;
  JLabel lblUserName,lblPassword,lblPasswd;
  JButton btnreg,btnexit;
  JTextField t1;
  JPasswordField p1,p2;
  GridLayout g;
  public Systemreg()
  {
    panel=new JPanel();
    lblUserName=new JLabel("姓名");
    lblPassword=new JLabel("密碼");
    lblPasswd=new JLabel("確認密碼");
    btnreg=new JButton("注冊");
    btnexit=new JButton("退出");
    t1=new JTextField(10);
    p1=new JPasswordField(10);
    p2=new JPasswordField(10);
    g=new GridLayout(3,2);
    panel.setLayout(g);
    panel.add(lblUserName);
    panel.add(t1);
    panel.add(lblPassword);
    panel.add(p1);
    panel.add(lblPasswd);
    panel.add(p2);
    panel.add(btnreg);
    panel.add(btnexit);
    getContentPane().add(panel);
    Reg r=new Reg();
    btnreg.addActionListener(r);
    btnexit.addActionListener(r);
  }
  class Reg implements ActionListener
  {
    public void actionPerformed (ActionEvent evt)
    {
      Object obj=evt.getSource();
     if(obj==btnreg)
     {
       //判斷注冊的姓名和密碼是否為空
       if (t1.getText().length() <= 0 || p1.getText().length() <= 0)
       {
         JOptionPane.showMessageDialog(null, "填入信息不能為空");
       }
       else
       {
         try {
           String strUserName = t1.getText().trim();
           String strPass = p1.getText().trim();
           Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
           Connection con = DriverManager.getConnection("jdbc:odbc:SDB");
           String str = "insert into User values(?,?)";
           PreparedStatement stmt = con.prepareStatement(str);
           stmt.setString(1, strUserName);
           stmt.setString(2, strPass);
           ResultSet rs;
           int i = stmt.executeUpdate();
           //返回結果不為空時
           if (i != 0)
           {
             if(p1.getText().equals(p2.getText()))
             {
               JOptionPane.showMessageDialog(null, "添加記錄成功！");
               con.close();
               t1.setText("");
               p1.setText("");
             }
             else
             {
              JOptionPane.showMessageDialog(null,"密碼不一致");
             }
           }
           else
           {
             JOptionPane.showMessageDialog(null, "添加記錄失敗！");
             t1.setText("");
             p1.setText("");
           }
         }
         catch (ClassNotFoundException e1)
         {
           JOptionPane.showMessageDialog(null, e1.getMessage());
         }
         catch (SQLException e2)
         {
           JOptionPane.showMessageDialog(null, e2.getMessage());
         }
       }
     }
     if (obj == btnexit)
       {
        System.exit(0);
       }
    }
  }
}