import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
 class Logon extends javax.swing.JFrame implements ActionListener,ItemListener{
        private JLabel uname,pass;
        private JTextField tuname,tpass;
        private JButton btok,btcancel,btclear;
        private JPanel panel=null,panel2=null;
        private Dimension d=Toolkit.getDefaultToolkit().getScreenSize();
        private Connection con=null;
        private Statement st=null;
        private ResultSet rs=null;
        private String s=null;
        private JProgressBar pbar;
        private JRadioButton admin,user;
        private ButtonGroup group;
        private int flag;
        public Logon() {
               super("Loading...");
               setResizable(false);
               setVisible(true);
               //setSize(300,300);
               setLocation(d.width/2-120,d.height/2-80);
               this.addWindowListener(new WindowAdapter(){
               @Override
               public void windowClosing(WindowEvent we){
             dispose();
                     System.exit(0);
                 }
               });
               try{
               Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
               con=DriverManager.getConnection("Jdbc:Odbc:sunil","scott","tiger");
               st=con.createStatement();
               }catch(Exception e){
                   e.printStackTrace();
               }

               pbar=new JProgressBar(0,2000);
               pbar.setStringPainted(true);
               panel=new JPanel();

               panel.add(pbar);
               setSize(300,100);
               getContentPane().add(panel);
               pbare();
              /* try{
                   Thread.sleep(1000);
               }
               catch(Exception e){
                   e.printStackTrace();
               }*/
             //removeAll();
               setTitle("SandeepSchool");
               setSize(300,300);

               panel2=new JPanel();
               panel2.setSize(300,300);
               panel2.setLayout(null);

           uname=new JLabel("UserName:");
               uname.setBounds(15,30,100,30);
               panel2.add(uname);

               tuname=new JTextField();
               tuname.setBounds(100,35,140,20);
               panel2.add(tuname);

               pass=new JLabel("Password:");
               pass.setBounds(15,90,100,30);
               panel2.add(pass);

               tpass=new JTextField();
               tpass.setBounds(100,90,140,20);
               panel2.add(tpass);

               admin=new JRadioButton("Administrator");
               admin.setMnemonic(KeyEvent.VK_A);
               admin.setBounds(10,160,150,20);
               admin.addItemListener(this);
               panel2.add(admin);

               user=new JRadioButton("User");
               user.setMnemonic(KeyEvent.VK_U);
               user.setBounds(170,160,150,20);
               user.addItemListener(this);
               user.setSelected(true);
               panel2.add(user);

               group=new ButtonGroup();
               group.add(admin);
               group.add(user);

               btok=new JButton("OK");
               btok.setBounds(10,220,75,20);
               btok.addActionListener(this);
               panel2.add(btok);

               btcancel=new JButton("Cancel");
               btcancel.setBounds(90,220,75,20);
               btcancel.addActionListener(this);
               panel2.add(btcancel);

               btclear=new JButton("Clear");
               btclear.setBounds(170,220,75,20);
               btclear.addActionListener(this);
               panel2.add(btclear);

               getContentPane().add(panel2);
         }
         public void pbare(){

            int num=100;
             while(num<=2000){
                 try{
                  num+=500;
                  Thread.sleep(500);
                  pbar.setValue(num);
                 }
                 catch(Exception e){
                     e.printStackTrace();
                 }
             }
        }
        public void window(){
            dispose();
             this.addWindowListener(new WindowAdapter(){
               @Override
               public void windowClosing(WindowEvent we){
                     System.exit(0);
                 }
               });
        }
        public void itemStateChanged(ItemEvent ie){
             if(ie.getItemSelectable()==user)
                 flag=1;
             if(ie.getItemSelectable()==admin)
                 flag=2;
        }
         public void actionPerformed(ActionEvent ae){
               if(ae.getSource()==btclear){
                     tuname.setText("");
                     tpass.setText("");
                 }
               if(ae.getSource()==btcancel){
                     System.exit(0);
                 }
               if(ae.getSource()==btok){
                   if(tuname.getText().equals(""))
                  JOptionPane.showMessageDialog(rootPane,"please enter username","Error", WIDTH);
                   else if(tpass.getText().equals(""))
                  JOptionPane.showMessageDialog(rootPane,"please enter password","Error", WIDTH);
                   else if(flag==1){
                       int flag2=0;
                       try{

                             s="select rtrim(user1),rtrim(pwd) from userinfo;";
                             rs=st.executeQuery(s);
                             while(rs.next()){
                              if(tuname.getText().equalsIgnoreCase(rs.getString(1))&& tpass.getText().equalsIgnoreCase(rs.getString(2)))
                                  flag2=1;
                             }
                            if(flag2==1){
                               JOptionPane.showMessageDialog(rootPane, "LoginSuccess");
                                //new SchoolManagement();
                                window();

                            }
                                 else
                                  JOptionPane.showMessageDialog(rootPane, "LoginFailed");
                         }
                       catch(Exception e){
                           e.printStackTrace();
                       }
                   }
                   else if(flag==2){

                   }
               }

             }


    public static void main(String args[]) {
                 Logon l=new Logon();


           }
 }