Beispiel #1
0
  private void display() {
    if (!String.valueOf(viewtype.getSelectedItem()).equalsIgnoreCase("ATM PIN")) {
      if (jLabel5.isEnabled()) {
        jLabel5.setEnabled(false);
        jTextField1.setEnabled(false);
      }
    }
    String str;
    Object row[] = new Object[5];
    DefaultTableModel dm = (DefaultTableModel) display.getModel();
    while (dm.getRowCount() > 0) dm.removeRow(0);
    if (viewtype.getSelectedIndex() == 0) {
      str = "select * from " + Login.user + ";";
    }
    /* new changes made as per the new requirements*/

    else if (String.valueOf(viewtype.getSelectedItem()).equalsIgnoreCase("ATM PIN")) {
      jTextField1.setEnabled(true);
      jLabel5.setEnabled(true);
      if (jTextField1.getText().trim().equals(""))
        str =
            "select * from "
                + Login.user
                + " where type='"
                + String.valueOf(viewtype.getSelectedItem())
                + "';";
      else
        str =
            "select * from "
                + Login.user
                + " where type='"
                + String.valueOf(viewtype.getSelectedItem())
                + "' AND accountname ='"
                + jTextField1.getText().trim()
                + "';";

    } else {
      str =
          "select * from "
              + Login.user
              + " where type='"
              + String.valueOf(viewtype.getSelectedItem())
              + "';";
    }
    try {
      ResultSet rs = PasswordManager.st.executeQuery(str);
      while (rs.next()) {
        for (int i = 0; i < 5; i++) {
          if (i != 2) row[i] = rs.getString(i + 1);
          else row[i] = PasswordManager.decrypt(String.valueOf(rs.getString(3)));
        }
        dm.addRow(row);
      }
      display.setModel(dm);
    } catch (SQLException se) {
      JOptionPane.showMessageDialog(this, "Database Error", "Error", JOptionPane.ERROR_MESSAGE);
    }
  }
Beispiel #2
0
 /** Creates new form Home */
 public Home() {
   initComponents();
   try {
     PasswordManager.connect();
     String str = "select name from details where username='******';";
     ResultSet rs = PasswordManager.st.executeQuery(str);
     rs.next();
     jLabel1.setText("Welcome , " + rs.getString("name"));
   } catch (SQLException se) {
     System.out.println("Connection to Database failed ...");
   }
   jLabel5.setEnabled(false);
   jTextField1.setEnabled(false);
 }
Beispiel #3
0
 private void jButton2ActionPerformed(
     java.awt.event.ActionEvent evt) { // GEN-FIRST:event_jButton2ActionPerformed
   if (name.getText().equals("") || pass.getText().equals("")) {
     JOptionPane.showMessageDialog(
         this, "Account Name & Password cannot be left blank", "Error", JOptionPane.ERROR_MESSAGE);
   } else {
     Calendar cl = Calendar.getInstance();
     Date cr =
         Date.valueOf(
             cl.get(Calendar.YEAR)
                 + "-"
                 + (cl.get(Calendar.MONTH) + 1)
                 + "-"
                 + cl.get(Calendar.DAY_OF_MONTH));
     String str =
         "insert into "
             + Login.user
             + "(`accountname`,`password`,`type`,`created`) values('"
             + name.getText()
             + "','"
             + PasswordManager.encrypt(pass.getText())
             + "','"
             + String.valueOf(type.getSelectedItem())
             + "','"
             + cr
             + "');";
     try {
       PasswordManager.st.executeUpdate(str);
       JOptionPane.showMessageDialog(
           this, "Password saved successfully ...", "Success", JOptionPane.INFORMATION_MESSAGE);
       reset();
     } catch (SQLException se) {
       JOptionPane.showMessageDialog(
           this, "Failed to write to database", "Error", JOptionPane.ERROR_MESSAGE);
     }
   }
 } // GEN-LAST:event_jButton2ActionPerformed