package xiangmu;

import java.awt.BorderLayout;
import java.awt.Dimension;
import javax.swing.ImageIcon;
import javax.swing.JFrame;
import javax.swing.JPanel;
import java.awt.Rectangle;
import javax.swing.JLabel;
import javax.swing.JCheckBox;
import javax.swing.JTextField;
import javax.swing.JPasswordField;
import javax.swing.JComboBox;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.BorderFactory;
import java.awt.Color;
import javax.swing.border.Border;
import javax.swing.JButton;
import java.awt.Font;
import java.sql.DriverManager;
import javax.swing.JOptionPane;
import java.sql.ResultSet;
import java.awt.Toolkit;
import java.sql.PreparedStatement;
import java.sql.Connection;
import javax.swing.border.TitledBorder;
import javax.swing.border.EtchedBorder;


/**
 * <p>Title: 第四學習小組-教學管理系統</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class denglu extends JFrame {
    public static String userName="";
    public static String userType="";
    JPanel contentPane;
    ImageIcon con1=new ImageIcon(getClass().getResource("images\\jiemian.JPG"));
    JLabel txttubian = new JLabel(con1);
    JLabel lblName = new JLabel();
    JLabel lblpass = new JLabel();
    JTextField txtUserName = new JTextField();
    JPasswordField txtPassword = new JPasswordField();
    Border border1 = BorderFactory.createLineBorder(Color.white, 2);
    JButton btnqd = new JButton();
    JButton btnExit = new JButton();
    JLabel jLabel2 = new JLabel();
    JButton btnzhuce = new JButton();
    TitledBorder titledBorder1 = new TitledBorder("");
    JButton jButton1 = new JButton();
    JLabel jLabel1 = new JLabel();
     String usertype[]={"普通用戶","系統管理員"};
    JComboBox cmbUserType = new JComboBox(usertype);
    Border border2 = BorderFactory.createEtchedBorder(EtchedBorder.RAISED,
            Color.white, new Color(178, 178, 178));
    public denglu() {
        try {
            setDefaultCloseOperation(EXIT_ON_CLOSE);
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    /**
     * Component initialization.
     *
     * @throws java.lang.Exception
     */
    private void jbInit() throws Exception {
        this.setResizable(false);
        contentPane = (JPanel) getContentPane();
        contentPane.setLayout(null);
        setSize(new Dimension(400, 328));
        setTitle("T64第四學習小組-教學管理系統");
        txttubian.setForeground(Color.red);
        txttubian.setBounds(new Rectangle( -137, 0, 669, 297));
        lblName.setFont(new java.awt.Font("宋體", Font.BOLD, 15));
        lblName.setText("用戶名:");
        lblName.setBounds(new Rectangle(193, 156, 81, 21));
        lblpass.setFont(new java.awt.Font("宋體", Font.BOLD, 15));
        lblpass.setText("密  碼:");
        lblpass.setBounds(new Rectangle(193, 193, 72, 21));
        txtUserName.setFont(new java.awt.Font("宋體", Font.BOLD, 12));
        txtUserName.setBounds(new Rectangle(254, 153, 97, 24));
        txtPassword.setFont(new java.awt.Font("Dialog", Font.BOLD, 13));
        txtPassword.setBounds(new Rectangle(254, 190, 97, 24));
        txtPassword.addActionListener(new denglu_txtpass_actionAdapter(this));
        btnqd.setBounds(new Rectangle(196, 237, 81, 32));
        btnqd.setFont(new java.awt.Font("宋體", Font.BOLD, 13));
        btnqd.setText("確  定");
        btnqd.addActionListener(new denglu_btnqd_actionAdapter(this));
        btnExit.setBounds(new Rectangle(303, 237, 81, 32));
        btnExit.setFont(new java.awt.Font("宋體", Font.BOLD, 13));
        btnExit.setText("取  消");
        btnExit.addActionListener(new denglu_btnExit_actionAdapter(this));
        jLabel2.setFont(new java.awt.Font("楷體_GB2312", Font.ITALIC, 25));
        jLabel2.setForeground(Color.blue);
        jLabel2.setText("   歡迎進入教學管理系統");
        jLabel2.setBounds(new Rectangle(97, 51, 300, 45));
        btnzhuce.setBounds(new Rectangle(354, 155, 32, 23));
        btnzhuce.setForeground(Color.red);
        btnzhuce.setBorder(BorderFactory.createEtchedBorder());
        btnzhuce.setText("注冊");
        btnzhuce.addActionListener(new denglu_btnzhuce_actionAdapter(this));
        jButton1.setBounds(new Rectangle(355, 191, 31, 23));
        jButton1.setForeground(Color.red);
        jButton1.setBorder(BorderFactory.createEtchedBorder());
        jButton1.setText("重置");
        jButton1.addActionListener(new denglu_jButton1_actionAdapter(this));
        jLabel1.setFont(new java.awt.Font("宋體", Font.BOLD, 15));
        jLabel1.setText("類  型：");
        jLabel1.setBounds(new Rectangle(193, 113, 96, 31));
        cmbUserType.setBorder(border2);
        cmbUserType.setBounds(new Rectangle(254, 114, 97, 27));
        contentPane.add(txtUserName);
        contentPane.add(btnzhuce);
        contentPane.add(jButton1);
        contentPane.add(txtPassword);
        contentPane.add(btnExit);
        contentPane.add(btnqd);
        contentPane.add(lblName);
        contentPane.add(lblpass);
        contentPane.add(jLabel1);
        contentPane.add(cmbUserType);
        contentPane.add(jLabel2);
        contentPane.add(txttubian);
    }

    public void txtpass_actionPerformed(ActionEvent e) {

    }
    public void btnqd_actionPerformed(ActionEvent e) {
        try {
                 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                 Connection con=DriverManager.getConnection("jdbc:odbc:xiangmu");
                 PreparedStatement pre=con.prepareStatement("select UserName,Password,UserType from SysUser where UserName=? and Password=? and UserType=?");
                 pre.setString(1,this.txtUserName.getText());
                 pre.setString(2,String.valueOf(this.txtPassword.getPassword()));
                 pre.setString(3,this.cmbUserType.getSelectedItem().toString());
                 ResultSet re=pre.executeQuery();
                 if(re.next()){
                     userName=this.txtUserName.getText();
                     userType=this.cmbUserType.getSelectedItem().toString();
                     String type = re.getString(1);
                     jiemian obj = new jiemian();
                Dimension screenSize = Toolkit.getDefaultToolkit().
                                             getScreenSize();
                obj.setSize(screenSize);

                obj.setLocation(0,0);
                obj.setVisible(true);
                this.dispose();

                 }else{
                     JOptionPane.showMessageDialog(this,"用戶名或密碼錯誤！");
                     this.txtUserName.setText("");
                     this.txtPassword.setText("");
                 }
                 re.close();
                 pre.close();
                 con.close();

             } catch (Exception ex) {
                 ex.printStackTrace();
                  System.out.println(ex.getMessage());
             }
    }

    public void btnExit_actionPerformed(ActionEvent e) {
    if (JOptionPane.showConfirmDialog(this, "是否確定退出系統登陸", "溫馨提示",
                                               JOptionPane.OK_CANCEL_OPTION) ==
                 JOptionPane.OK_OPTION) {
                         Dimension screenSize = Toolkit.getDefaultToolkit().
                                                getScreenSize();
                          this.dispose();
                     }

    }

    public void btnzhuce_actionPerformed(ActionEvent e) {
        try {
           ZhuceInfo obj=new ZhuceInfo();
           obj.setSize(350,350);
           obj.setLocation(300,100);
           obj.setVisible(true);
       } catch (Exception ex) {

       }

    }

    public void jButton1_actionPerformed(ActionEvent e) {
           this.txtUserName.setText("");
           this.txtPassword.setText("");
    }
}


class denglu_jButton1_actionAdapter implements ActionListener {
    private denglu adaptee;
    denglu_jButton1_actionAdapter(denglu adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton1_actionPerformed(e);
    }
}


class denglu_btnzhuce_actionAdapter implements ActionListener {
    private denglu adaptee;
    denglu_btnzhuce_actionAdapter(denglu adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnzhuce_actionPerformed(e);
    }
}


class denglu_btnExit_actionAdapter implements ActionListener {
    private denglu adaptee;
    denglu_btnExit_actionAdapter(denglu adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnExit_actionPerformed(e);
    }
}


class denglu_btnqd_actionAdapter implements ActionListener {
    private denglu adaptee;
    denglu_btnqd_actionAdapter(denglu adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnqd_actionPerformed(e);
    }
}


class denglu_txtpass_actionAdapter implements ActionListener {
    private denglu adaptee;
    denglu_txtpass_actionAdapter(denglu adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.txtpass_actionPerformed(e);
    }
}