package loginsystem;

import javax.swing.*;
import java.awt.event.*;
import java.sql.*;

public class LoginSystem {

    Connection con;
    Statement st;
    ResultSet rs;
    
    JFrame f = new JFrame("INLOGIN");
    JLabel l = new JLabel("Username");
    JLabel l1 = new JLabel("Password");
    JTextField t = new JTextField(10);
    JTextField t1 = new JTextField(10);
    JButton b = new JButton("Login");
   
    public LoginSystem() 
    {
    
    connect();
    frame();
        
    }
    
    public void connect(){
        
        try{
            
        
        
        String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
        Class.forName(driver);
        
        String db = "jdbc:odbc:innlogin";
        con = DriverManager.getConnection(db);
        st = con.createStatement();
        }
        catch(Exception ex)
        {
            
        }
    }
    
    public void frame()
    {
     
       f.setSize(600, 400);
       f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
       f.setVisible(true);
       
       JPanel p = new JPanel();
       
       p.add(l);
       p.add(t);
       p.add(l1);
       p.add(t1);
       p.add(b);
       
       f.add(p);
       
       b.addActionListener(new ActionListener(){

           @Override
           public void actionPerformed(ActionEvent e) 
           {
             try
             {
                 
             
               String user = t.getText().trim();
               String pass = t1.getText().trim();
               
               String sql = "select user,pass from Table1 where user = '"+user+"'and pass = '"+pass+"'";
               rs = st.executeQuery(sql);
               
               int count = 0;
               while(rs.next())
               {
                   count = count + 1;
               }
               
               if(count == 1)
               {
                   JOptionPane.showMessageDialog(null, "Bruker funnet!");
               }
               else if(count > 1)
                       {
                           JOptionPane.showMessageDialog(null, "duplikerte brukere får ikke tilgang!");
                       }
               else 
               {
                   JOptionPane.showMessageDialog(null, "Bruker ikke funnet!");
               }
             }
             catch(Exception ex){
                 
             }
           }
           
    }
    }
    
    public static void main(String[] args) {
        
        new LoginSystem();
        
    }
    
}