iNko Posted November 30, 2012 Share Posted November 30, 2012 (edited) 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 Edited November 30, 2012 by iNko Quote Link to comment https://forums.phpfreaks.com/topic/271395-fetching-specific-data-from-mysql-database/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.