Search the Community
Showing results for tags 'fetching data from databse'.
Found 1 result
-
Hello, i have a problem fetching data from database, ill try explain what i need help with.. I got a login frame, that has login textfield, password textfield and a submit button. When i press the submit button, if the login and password was correct, it switches to new frame, the login frame disappears. In the new frame, i want to put a label, that would take 1 specific data field from the database. Something like this - "Select Surname from Users where Loginid = login". How do i take the login textfield data from login frame, and display it in the new frame? After i do this, can i create a new method in the new frame like this, and then just call it? (i took this from a tutorial where instead of updating a label, it updates the whole table) ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// private void whoslogedinLabel(){ String sql = "select Surname from Users where Loginid = Login texfield"; try { pst = conn.prepareStatement(sql); rs = pst.executeQuery(); logininfoLabel.setText(sql); } catch (Exception e){ JOptionPane.showMessageDialog(null, e); } } ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// highlighted the red text where i think is the problem
