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;
  JButton btnreg,btnexit;
  JTextField t1,t2;
  GridLayout g;
  public Systemreg()
  {
    panel=new JPanel();
    lblUserName=new JLabel("姓名");
    lblPassword=new JLabel("密碼");
    btnreg=new JButton("注冊");
    btnexit=new JButton("退出");
    t1=new JTextField(10);
    t2=new JTextField(10);
    g=new GridLayout(3,2);
    panel.setLayout(g);
    panel.add(lblUserName);
    panel.add(t1);
    panel.add(lblPassword);
    panel.add(t2);
    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 || t2.getText().length() <= 0)
       {
         JOptionPane.showMessageDialog(null, "填入信息不能為空");
       }
       else
       {
         try {
           String strUserName = t1.getText().trim();
           String strPass = t2.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) {
             JOptionPane.showMessageDialog(null, "添加記錄成功！");
             con.close();
             t1.setText("");
             t2.setText("");
           }
           else {
             JOptionPane.showMessageDialog(null, "添加記錄失敗！");
             t1.setText("");
             t2.setText("");
           }
         }
         catch (ClassNotFoundException e1)
         {
           JOptionPane.showMessageDialog(null, e1.getMessage());
         }
         catch (SQLException e2)
         {
           JOptionPane.showMessageDialog(null, e2.getMessage());
         }
       }
     }
     if (obj == btnexit)
       {
        System.exit(0);
       }
    }
  }
}