/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package dlginventory;
import javax.swing.*;

import java.sql.*;
import java.util.logging.Level;
import java.util.logging.Logger;

/**
*
* @author GUTIERREZ
*/
public class login extends javax.swing.JPanel {

/**
 * Creates new form NewJPanel
 */
public login() {
    initComponents();
}

  public static void main (String[] args){

 }
   @SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {

    jLabel1 = new javax.swing.JLabel();
    jLabel2 = new javax.swing.JLabel();
    jLabel3 = new javax.swing.JLabel();
    jLabel4 = new javax.swing.JLabel();
    jLabel5 = new javax.swing.JLabel();
    jLabel6 = new javax.swing.JLabel();
    jPanel1 = new javax.swing.JPanel();
    username = new javax.swing.JTextField();
    jLabel7 = new javax.swing.JLabel();
    password = new javax.swing.JPasswordField();
    jLabel8 = new javax.swing.JLabel();
    jLabel9 = new javax.swing.JLabel();

    setBackground(new java.awt.Color(0, 0, 255));
    setForeground(new java.awt.Color(255, 255, 255));
    setMinimumSize(new java.awt.Dimension(2790, 720));
    setPreferredSize(new java.awt.Dimension(2790, 720));
    setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());

    jLabel1.setFont(new java.awt.Font("Century Gothic", 0, 100)); // NOI18N
    jLabel1.setForeground(new java.awt.Color(255, 255, 255));
    jLabel1.setText("DLG FARMS");
    add(jLabel1, new org.netbeans.lib.awtextra.AbsoluteConstraints(40, 300, 594, 110));

    jLabel2.setFont(new java.awt.Font("Century Gothic", 2, 24)); // NOI18N
    jLabel2.setForeground(new java.awt.Color(255, 255, 255));
    jLabel2.setText("INVENTORY     SUPPLY     PRODUCT");
    add(jLabel2, new org.netbeans.lib.awtextra.AbsoluteConstraints(50, 400, 710, -1));

    jLabel3.setIcon(new javax.swing.ImageIcon(getClass().getResource("/dlginventory/Chicken_96px.png"))); // NOI18N
    jLabel3.setText(" ");
    add(jLabel3, new org.netbeans.lib.awtextra.AbsoluteConstraints(390, 220, -1, -1));

    jLabel4.setIcon(new javax.swing.ImageIcon(getClass().getResource("/dlginventory/Easter Eggs_96px.png"))); // NOI18N
    jLabel4.setText(" ");
    add(jLabel4, new org.netbeans.lib.awtextra.AbsoluteConstraints(270, 220, -1, -1));

    jLabel5.setIcon(new javax.swing.ImageIcon(getClass().getResource("/dlginventory/Sack of Flour_96px.png"))); // NOI18N
    jLabel5.setText(" ");
    add(jLabel5, new org.netbeans.lib.awtextra.AbsoluteConstraints(30, 220, -1, -1));

    jLabel6.setIcon(new javax.swing.ImageIcon(getClass().getResource("/dlginventory/Syringe_96px.png"))); // NOI18N
    jLabel6.setText(" ");
    add(jLabel6, new org.netbeans.lib.awtextra.AbsoluteConstraints(150, 220, -1, -1));

    jPanel1.setBackground(new java.awt.Color(255, 255, 153));
    jPanel1.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());

    username.setFont(new java.awt.Font("Century Gothic", 0, 24)); // NOI18N
    username.setText(" ");
    username.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            usernameActionPerformed(evt);
        }
    });
    jPanel1.add(username, new org.netbeans.lib.awtextra.AbsoluteConstraints(290, 320, 430, 40));

    jLabel7.setFont(new java.awt.Font("Century Gothic", 0, 36)); // NOI18N
    jLabel7.setForeground(new java.awt.Color(0, 0, 255));
    jLabel7.setText("password");
    jPanel1.add(jLabel7, new org.netbeans.lib.awtextra.AbsoluteConstraints(60, 390, -1, -1));

    password.setFont(new java.awt.Font("Century Gothic", 0, 36)); // NOI18N
    password.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            passwordActionPerformed(evt);
        }
    });
    jPanel1.add(password, new org.netbeans.lib.awtextra.AbsoluteConstraints(290, 390, 430, 40));

    jLabel8.setFont(new java.awt.Font("Century Gothic", 0, 36)); // NOI18N
    jLabel8.setForeground(new java.awt.Color(0, 0, 255));
    jLabel8.setText("username");
    jPanel1.add(jLabel8, new org.netbeans.lib.awtextra.AbsoluteConstraints(60, 320, -1, -1));

    jLabel9.setBackground(new java.awt.Color(0, 0, 255));
    jLabel9.setFont(new java.awt.Font("Century Gothic", 0, 36)); // NOI18N
    jLabel9.setForeground(new java.awt.Color(255, 255, 153));
    jLabel9.setText("LOGIN");
    jLabel9.setOpaque(true);
    jLabel9.addMouseListener(new java.awt.event.MouseAdapter() {
        public void mouseClicked(java.awt.event.MouseEvent evt) {
            jLabel9MouseClicked(evt);
        }
    });
    jPanel1.add(jLabel9, new org.netbeans.lib.awtextra.AbsoluteConstraints(320, 490, -1, -1));

    add(jPanel1, new org.netbeans.lib.awtextra.AbsoluteConstraints(630, 0, 780, 720));
}// </editor-fold>

private void usernameActionPerformed(java.awt.event.ActionEvent evt) {
    // TODO add your handling code here:
}

private void passwordActionPerformed(java.awt.event.ActionEvent evt) {
    // TODO add your handling code here:
}

private void jLabel9MouseClicked(java.awt.event.MouseEvent evt) {
try {
    Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
    String connectionUrl = "jdbc:sqlserver://localhost:51691;" +
        "databaseName=DLG;user=sa;password=212617;";


    Connection con = DriverManager.getConnection(connectionUrl);
     String sql = "SELECT * from admin_table WHERE username=? and password=?";
     PreparedStatement pst = con.prepareStatement(sql);
     pst.setString(1, username.getText());
     pst.setString(2, password.getText());
     ResultSet rs = pst.executeQuery(sql);
     if (rs.next())
     {
         JOptionPane.showMessageDialog(null, "Welcome Admin");

     }
     else
     {
         JOptionPane.showMessageDialog(null, "Incorrect Password / Username");
         username.setText("");
         password.setText("");
     }
     con.close();

    }
    catch (SQLException e) {
        JOptionPane.showMessageDialog(null, e);
    } catch (ClassNotFoundException ex) {
        Logger.getLogger(login.class.getName()).log(Level.SEVERE, null, ex);
    }

}


// Variables declaration - do not modify
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel4;
private javax.swing.JLabel jLabel5;
private javax.swing.JLabel jLabel6;
private javax.swing.JLabel jLabel7;
private javax.swing.JLabel jLabel8;
private javax.swing.JLabel jLabel9;
private javax.swing.JPanel jPanel1;
private javax.swing.JPasswordField password;
private javax.swing.JTextField username;
// End of variables declaration