title: getting text from password field
body: <p>Hello I am trying to create a login form in java netbeans IDE. My aim is to create multiple user ID's and their respective passwords. I have given textfields to userID and passwordField for passwords to get the values but the problem is i want to get the text from the password field and i am unable to get it its showing some error i think there is some problem with syntax my research is as follows can there be any solution? Need your help</p>
  
  <pre><code>private void lb_loginMouseClicked(java.awt.event.MouseEvent evt) {                                      
         DBUtil util = new DBUtil();
         String value1=tb_uid.getText();
         String value2=tb_pwd.getPassword();
         String user1="";
         String pass1="";
         try {
  
              Connection con = util.getConnection();
              PreparedStatement stmt = con.prepareStatement("SELECT * FROM login where username='"+value1+"' &amp;&amp; password='"+value2+"'");
              ResultSet res = stmt.executeQuery();
              res = stmt.executeQuery();
              while (res.next()) {
                  user1 = res.getString("username");
                  pass1 = res.getString("password");
              }
              if (value1.equals(user1) &amp;&amp; value2.equals(pass1)) {
              JOptionPane.showMessageDialog(this,"correct");
              }
              else{
              JOptionPane.showMessageDialog(this,"Incorrect login or password","Error",JOptionPane.ERROR_MESSAGE);
              }
              JOptionPane.showMessageDialog(null, "COMMITED SUCCESSFULLY!");
          } catch (Exception ex) {
              JOptionPane.showMessageDialog(null, ex.getMessage());
  
          }
  
      }  
  </code></pre>