TextFeild value from DataBase not coming

[Rekha Pande]

Hi all,

I'm having this problem, that when i do a System.out.println for variable pass in the while loop, the value is coming right but when i try to use that value as setText for my textField in the createSimpleDialogBox() the variable pass value is empty. Why is it so. and how can i rectify it.???
My code is below..please help.

 
package equipment;
 
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.Box;
import javax.swing.BorderFactory;
import javax.swing.border.Border;
import java.io.*;
import java.util.*;
import java.sql.*;
import java.text.*;
import java.util.Date;
import java.lang.String;
import java.*;
 
public class TextDemo extends JPanel
{
    protected JTextField textField;
    protected JTextField textField1;
    protected JButton button;
    protected JTextArea textArea;
    private final static String newline = "\n";
    JFrame frame;
    String desc1 = "Enter user name";
    String desc2 = "Enter password";
    String user_name = "";
    public String pass = "";
 
    Connection conn = null;
    public Connection connectdb()
    {
      try
      {
        Class.forName("com.mysql.jdbc.Driver");
        conn = DriverManager.getConnection("my connection String");
      }
      catch (Exception e)
      {
 
      }
      return conn;
    }
 
    public void change_pass(String owner)
    {
      try
      {
        Statement stmt = conn.createStatement();
        ResultSet rs = stmt.executeQuery("Select * from owners where it_owner_name = '"+owner+"'");
        while(rs.next())
        {
          user_name = owner;
          pass = rs.getString("password");
          System.out.println(pass); [B]Over here the value is right[/B]
        }
      }
      catch(Exception e)
      {
      }
    }
    public TextDemo()
    {
    
    }
    public TextDemo(JFrame frame)
    {
        super(new BorderLayout());
                this.frame = frame;
                frame.setBounds(250,250,50,250);
                JPanel frequentPanel = createSimpleDialogBox();
                Border padding = BorderFactory.createEmptyBorder(20,20,5,20);
                frequentPanel.setBorder(padding);
                add(frequentPanel);
    }
 
    private JPanel createSimpleDialogBox()
       {
           textField1 = new JTextField(20);
           System.out.println("In JPanel" +  "pass"+pass);[B]Over here the pass value is empty string[/B]
           textField = new JTextField(20);
           textFeild.setText(pass);
           button = new JButton("CHANGE");
           button.addActionListener(new ActionListener()
           {
           public void actionPerformed(ActionEvent e)
           {
             //desc1 = "CCcdcdcdcd"; textField.getText();
             JOptionPane.showMessageDialog(frame,textField.getText());
             return;
           }
         });
 
           return createPane(textField,textField1,desc1,desc2,button);
 
       }
 
       private JPanel createPane(JTextField field1,JTextField field2,String description1,String description2,JButton showButton)
       {
       JPanel box = new JPanel();
       JLabel label = new JLabel(description1);
       JLabel label2 = new JLabel(description2);
       box.setLayout(new BoxLayout(box, BoxLayout.PAGE_AXIS));
       box.add(label);
       box.add(field1);
       box.add(label2);
       box.add(field2);
       box.add(showButton);
       JPanel pane = new JPanel(new BorderLayout());
       pane.add(box, BorderLayout.PAGE_START);
       pane.add(showButton, BorderLayout.PAGE_END); frame.repaint();
       return pane;
   }
    private static void createAndShowGUI()
    {
      JFrame.setDefaultLookAndFeelDecorated(true);
      JFrame frame = new JFrame("Change User Name and Password");
      frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
      JComponent newContentPane = new TextDemo(frame);
      newContentPane.setOpaque(true); //content panes must be opaque
      frame.setContentPane(newContentPane);
      frame.pack();
      frame.setResizable(false);
      frame.setSize(375,200);
      frame.setVisible(true);
      frame.repaint();
    }
 
    public static void main(String[] args)
    {
      TextDemo e = new TextDemo();
      e.connectdb();
      e.change_pass("me");
      javax.swing.SwingUtilities.invokeLater(new Runnable() {
        public void run() {
          createAndShowGUI();
        }
      });
    }
}

Thanxs....

[Ko Ko Naing]

Rekha,
I found out some misplace of the method calls in your code...

 
.......... 
    public void change_pass(String owner)
    {
      try
      {
        Statement stmt = conn.createStatement();
        ResultSet rs = stmt.executeQuery("Select * from owners where it_owner_name = '"+owner+"'");
        while(rs.next())
        {
          user_name = owner;
          pass = rs.getString("password");
          System.out.println(pass); [B]Over here the value is right[/B]
        }
      }
      catch(Exception e)
      {
      }
    }
    public TextDemo()
    {
    
    }
    public TextDemo(JFrame frame)
    {
        super(new BorderLayout());
                this.frame = frame;
                frame.setBounds(250,250,50,250);
                JPanel frequentPanel = createSimpleDialogBox();
                Border padding = BorderFactory.createEmptyBorder(20,20,5,20);
                frequentPanel.setBorder(padding);
                add(frequentPanel);
    }
 
    private JPanel createSimpleDialogBox()
       {
           textField1 = new JTextField(20);
           System.out.println("In JPanel" +  "pass"+pass);[B]Over here the pass value is empty string[/B]
           textField = new JTextField(20);
           textFeild.setText(pass);
           button = new JButton("CHANGE");
           button.addActionListener(new ActionListener()
           {
           public void actionPerformed(ActionEvent e)
           {
             //desc1 = "CCcdcdcdcd"; textField.getText();
             JOptionPane.showMessageDialog(frame,textField.getText());
             return;
           }
         });
 
           return createPane(textField,textField1,desc1,desc2,button);
 
       }
    private static void createAndShowGUI()
    {
      JFrame.setDefaultLookAndFeelDecorated(true);
      JFrame frame = new JFrame("Change User Name and Password");
      frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
      JComponent newContentPane = new TextDemo(frame); [B]// Instance newContentPane of TextDemo never calls that change_pass to retrieve the updated value of pass from database [/B]
      newContentPane.setOpaque(true); //content panes must be opaque
      frame.setContentPane(newContentPane);
      frame.pack();
      frame.setResizable(false);
      frame.setSize(375,200);
      frame.setVisible(true);
      frame.repaint();
    }
 
    public static void main(String[] args)
    {
      TextDemo e = new TextDemo();
      e.connectdb();
      [B]e.change_pass("me"); // change_pass is called only one time on instance e of TextDemo[/B]
      javax.swing.SwingUtilities.invokeLater(new Runnable() {
        public void run() {
          createAndShowGUI();
        }
      });
    }
}

I believe that different instances calling the same method will cause you a problem. So could you check those and give us some feedbacks on that? I hope this helps...

[Rekha Pande]

hi all,

well i think there was a problem in the way how i was declaring the variable .. now that i have changed it to static every thing seems to be working fine...

 protected JTextField textField;
    protected JTextField textField1;
    protected JButton button;
    protected JTextArea textArea;
    private final static String newline = "\n";
    JFrame frame;
    String desc1 = "Enter user name";
    String desc2 = "Enter password";
    [B]static String user_name = "";
    static String pass = "dd";[/B]
    
  

Thanxs all... i'm sure i'll be neading all ranchers help shortly beacuse now i have to call this class file from a web page..... let me try..if i get stuck then i know where to come

[Ko Ko Naing]

Rekha,
Well, as for static variables, you will be able to use it throughout all the instances... It will be fine, as long as you want to use those variables as such manner... But if you do want to use them in different instances, then you cannot avoid using instance variables...