import java.sql.*;
import java.io.*;

class ManipulasiDB {
	public static Connection buatKoneksi() {
            Connection koneksi=null;
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			String sourceURL="jdbc:odbc:tambahDB";
			koneksi=DriverManager.getConnection(sourceURL);
		}
		catch(SQLException sqle) {
			System.err.println(sqle);
		}
		catch(ClassNotFoundException cnfe) {
			System.err.println(cnfe);
		}
            return koneksi;
	}
        
        public static ResultSet execQ(String sqlcommand) throws SQLException {
           ResultSet manipulasi=null;
            //try {
            Connection koneksi=buatKoneksi();
            Statement pernyataan=koneksi.createStatement();
            manipulasi=pernyataan.executeQuery(sqlcommand);
            //}
            //catch(SQLException sqle) {System.out.println(sqle);}
            return manipulasi;
        }
        
        public static int execU(String sqlcommand) throws SQLException {
            Statement pernyataan=null;
            int temp=0;
            // try {
            Connection koneksi=buatKoneksi();
            pernyataan=koneksi.createStatement();
            temp=pernyataan.executeUpdate(sqlcommand);
            //}
            //catch(SQLException sqle) {System.out.println(sqle);}
            return temp;
        }
}

public class SimplePasswd extends javax.swing.JFrame {
    ManipulasiDB data=new ManipulasiDB();
    private static SimplePasswd simple=new SimplePasswd();
    public SimplePasswd() {
        initComponents();
    }
    
    private void initComponents() {//GEN-BEGIN:initComponents
        java.awt.GridBagConstraints gridBagConstraints;

        jPanel1 = new javax.swing.JPanel();
        jPanel3 = new javax.swing.JPanel();
        jPanel5 = new javax.swing.JPanel();
        jPanel7 = new javax.swing.JPanel();
        jLabel4 = new javax.swing.JLabel();
        jPasswordField1 = new javax.swing.JPasswordField();
        jPanel8 = new javax.swing.JPanel();
        jButton1 = new javax.swing.JButton();
        jLabel5 = new javax.swing.JLabel();
        jPanel6 = new javax.swing.JPanel();
        jLabel3 = new javax.swing.JLabel();
        jTextField1 = new javax.swing.JTextField();
        jPanel4 = new javax.swing.JPanel();
        jLabel2 = new javax.swing.JLabel();
        jPanel2 = new javax.swing.JPanel();
        jLabel1 = new javax.swing.JLabel();

        setTitle("Simple Password Program");
        setBackground(new java.awt.Color(255, 255, 255));
        setResizable(false);
        addWindowListener(new java.awt.event.WindowAdapter() {
            public void windowClosing(java.awt.event.WindowEvent evt) {
                exitForm(evt);
            }
        });

        jPanel1.setLayout(new java.awt.BorderLayout());

        jPanel1.setBackground(new java.awt.Color(204, 204, 255));
        jPanel1.setForeground(new java.awt.Color(204, 51, 255));
        jPanel3.setLayout(new java.awt.BorderLayout());

        jPanel3.setPreferredSize(new java.awt.Dimension(300, 125));
        jPanel5.setLayout(new java.awt.BorderLayout());

        jLabel4.setText("Password  :");
        jPanel7.add(jLabel4);

        jPasswordField1.setColumns(10);
        jPasswordField1.setBorder(new javax.swing.border.SoftBevelBorder(javax.swing.border.BevelBorder.LOWERED));
        jPanel7.add(jPasswordField1);

        jPanel5.add(jPanel7, java.awt.BorderLayout.NORTH);

        jPanel8.setLayout(new java.awt.GridBagLayout());

        jButton1.setText("LOGIN");
        jButton1.setBorder(new javax.swing.border.BevelBorder(javax.swing.border.BevelBorder.RAISED));
        jButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton1ActionPerformed(evt);
            }
        });

        jPanel8.add(jButton1, new java.awt.GridBagConstraints());

        gridBagConstraints = new java.awt.GridBagConstraints();
        gridBagConstraints.gridx = 0;
        gridBagConstraints.gridy = 1;
        jPanel8.add(jLabel5, gridBagConstraints);

        jPanel5.add(jPanel8, java.awt.BorderLayout.CENTER);

        jPanel3.add(jPanel5, java.awt.BorderLayout.CENTER);

        jLabel3.setText("User Name :");
        jPanel6.add(jLabel3);

        jTextField1.setColumns(10);
        jTextField1.setBorder(new javax.swing.border.SoftBevelBorder(javax.swing.border.BevelBorder.LOWERED));
        jPanel6.add(jTextField1);

        jPanel3.add(jPanel6, java.awt.BorderLayout.NORTH);

        jPanel1.add(jPanel3, java.awt.BorderLayout.CENTER);

        jPanel4.setBackground(new java.awt.Color(153, 204, 255));
        jLabel2.setForeground(new java.awt.Color(153, 244, 51));
        jLabel2.setText("---   Login   ---");
        jPanel4.add(jLabel2);

        jPanel1.add(jPanel4, java.awt.BorderLayout.NORTH);

        getContentPane().add(jPanel1, java.awt.BorderLayout.CENTER);

        jPanel2.setBackground(new java.awt.Color(102, 204, 255));
        jPanel2.setForeground(new java.awt.Color(255, 255, 255));
        jLabel1.setForeground(new java.awt.Color(255, 255, 255));
        jLabel1.setText("Program Masukan Password Sederhana (Sekali)");
        jPanel2.add(jLabel1);

        getContentPane().add(jPanel2, java.awt.BorderLayout.NORTH);

        pack();
    }//GEN-END:initComponents
    public void tunjukkanRasamu() {
        simple.show();
    }
    public void ciutkanRasamu() {
        simple.dispose();
    }
    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
        String pemakai=jTextField1.getText();
        String kunci=jPasswordField1.getText();
        String hasilpemakai=new String("");
        String hasilkunci=new String("");            
        
        try {
        ResultSet hasil=data.execQ("SELECT * FROM lpasswd WHERE name='"+pemakai+"' AND pass='"+kunci+"'");
        
        
        if (hasil.next()) {
            hasilpemakai=hasil.getString("name");
            hasilkunci=hasil.getString("pass");
            FormHasil kasihtau=new FormHasil();
            jTextField1.setText("");
            jPasswordField1.setText("");
            kasihtau.tunjukkanRasamu();
            ciutkanRasamu();
            jLabel5.setText("");
        }
        else { 
            jLabel5.setText("Invalid Passwod");
            jTextField1.setText("");
            jPasswordField1.setText("");
        }
        
        }
        catch(SQLException sqle) {System.out.println(sqle);}
    }//GEN-LAST:event_jButton1ActionPerformed
    
    /** Exit the Application */
    private void exitForm(java.awt.event.WindowEvent evt) {//GEN-FIRST:event_exitForm
        System.exit(0);
    }//GEN-LAST:event_exitForm
    
    public static void main(String args[]) {
        simple.show();
    }

    private javax.swing.JButton jButton1;
    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.JPanel jPanel1;
    private javax.swing.JPanel jPanel2;
    private javax.swing.JPanel jPanel3;
    private javax.swing.JPanel jPanel4;
    private javax.swing.JPanel jPanel5;
    private javax.swing.JPanel jPanel6;
    private javax.swing.JPanel jPanel7;
    private javax.swing.JPanel jPanel8;
    private javax.swing.JPasswordField jPasswordField1;
    private javax.swing.JTextField jTextField1;
    // End of variables declaration//GEN-END:variables
    
}