Jump to content


Photo

Fetching Specific Data From Mysql Database

fetching data from databse

  • Please log in to reply
No replies to this topic

#1 iNko

iNko

    Advanced Member

  • Members
  • PipPipPip
  • 49 posts

Posted 30 November 2012 - 06:10 AM

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 by iNko, 30 November 2012 - 06:11 AM.





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

Cheap Linux VPS from $5
SSD Storage, 30 day Guarantee
1 TB of BW, 100% Network Uptime

AlphaBit.com