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 StudentMessage
//組件的聲名
{
  JFrame frame;
  JPanel panel;
  JLabel lblName,lblPasswd;
  JTextField t1;
  JPasswordField p1;
  JButton b1,b2,b3,b4;
  GridLayout g;
  static int i=0;
  public StudentMessage()
  {
   // 組件的初始化
    frame=new JFrame("登陸");
    panel=new JPanel();
    lblName=new JLabel("姓名:");
    lblPasswd=new JLabel("密碼:");
    t1=new JTextField(10);
    p1=new JPasswordField(10);
    b1=new JButton("登陸");
    b2=new JButton("清空");
    b3=new JButton("注冊");
    b4=new JButton("退出");
    g=new GridLayout(2,4);
    panel.setLayout(g);
    panel.add(lblName);
    panel.add(t1);
    panel.add(lblPasswd);
    panel.add(p1);
    panel.add(b1);
    panel.add(b2);
    panel.add(b3);
    panel.add(b4);
    frame.getContentPane().add(panel);
    frame.setVisible(true);
    frame.setSize(350,100);
    frame.show();
    //創建監聽器對象
    Login lg=new Login();
    //注冊監聽器對象
    b1.addActionListener(lg);
    b2.addActionListener(lg);
    b3.addActionListener(lg);
  }
  //添加事件監聽
  class Login implements ActionListener
  {
    public void actionPerformed (ActionEvent evt)
    {
      Object obj=evt.getSource();//獲取引發事件的事件源
    if(obj==b1)
    {
      i++;
      if(i<=3)
      {
        String UserID, Password;
        UserID = t1.getText().trim();
        Password = String.valueOf(p1.getPassword()).trim();
        try {
          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //加載驅動程序
          Connection conn = DriverManager.getConnection("jdbc:odbc:SDB"); //連接數據庫
          //執行SQL語句
          String sql = "select * from User where UserID=? and Password=?";
          PreparedStatement stmt = conn.prepareStatement(sql);
          stmt.setString(1, UserID);
          stmt.setString(2, Password);
          ResultSet rs = stmt.executeQuery();
          if (rs.next())
          {
            IndexInt index = new IndexInt();
            index.inframe.setVisible(true);
            index.inframe.setSize(500, 400);
            index.inframe.show();
            frame.setVisible(false);
          }
          conn.close();
        }
        catch (ClassNotFoundException e1)
        {
          JOptionPane.showMessageDialog(frame, e1.getMessage());
        }
        catch (SQLException e2)
        {
          JOptionPane.showMessageDialog(frame, e2.getMessage());
        }
      }
      else
      {
        System.exit(0);
      }
      if (obj == b2) {
        //清空用戶名和密碼
        t1.setText("");
        p1.setText("");
      }
    }
    if(obj==b3)
    {
      Systemreg sys=new Systemreg();
      sys.frame.setVisible(true);
      sys.frame.setSize(200,100);
      sys.frame.show();
      frame.setVisible(false);

    }
  }
}

public static void main(String[] s)
{
  new StudentMessage();
}
}