Thread: Variable Loosing Data?

I am having some trouble with the below code for my assignment. I am trying to display the

line

in the

JTextArea

. But for some reason the

line

displays blank when called in

void addComponents()

Does anyone know how I can go about getting the information from

line

in

public searchProps(int propID)

import java.awt.Container;
import java.sql.*;
import java.util.*;
import javax.swing.*;
 
 
public class searchProps 
{
    protected String price, area, query, suburb, date, SaleOrRent, strQuery, line="";
    protected int agentID, upid, StreetNum, numBeds, numBaths, numGarages, ownerID, size;
    protected boolean spool;
    PropertyObject PropertyArray[] = new PropertyObject[3];
    JFrame jf;
    JTextArea txtArea = new JTextArea();
     {
        initialFrame();
        addComponents();
    }
 
 public searchProps(int propID) //search using UPID only
   {
       try 
               {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection conn = DriverManager.getConnection("jdbc:odbc:PropertyOracleDatabase");
            Statement s = conn.createStatement();
 
 
 
            query = ("SELECT * FROM Properties WHERE UPID = "+propID);
 
            // Fetch table
            s.execute(query);
            ResultSet rs = s.getResultSet();
            while((rs!=null) && (rs.next()))
            {
                upid=rs.getInt(1);
                StreetNum=rs.getInt(2);
                suburb=rs.getString(3);
                area=rs.getString(4);
                price=rs.getString(5);
                agentID= rs.getInt(6);
                numBeds=rs.getInt(7);
                numBaths=rs.getInt(8);
                spool=rs.getBoolean(9);
                numGarages=rs.getInt(10);
                date=rs.getString(11);
                ownerID=rs.getInt(12);
                SaleOrRent=rs.getString(13);
                size++;
 
 
              //  line = (line+upid+"\t"+StreetNum+"\t"+suburb+"\t"+area+"\t"+price+"\t"+agentID+"\t"+numBeds+"\t"+numBaths+"\t"+spool+"\t"+numGarages+"\t"+date+"\t"+ownerID+"\t"+SaleOrRent+"\n");
                System.out.println(line);
            }
 
 
 
            // close and cleanup
            s.close();
            conn.close();
               }
 
        catch(Exception ex)
        {
            ex.printStackTrace();
        }
 
 
 
   }
 
void initialFrame()
    {
        jf=new JFrame();
        jf.setSize (1300,700);
        jf.setTitle("Property Oracle | Results Page");
        jf.setVisible(true);
        jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
 
    }
 
     void addComponents()
     {
 
         Container con = jf.getContentPane();
         String out = this.getLine();
         con.setLayout(null);
         txtArea.setBounds(20,30,1200,600);
         con.add(txtArea);
         txtArea.setText("UPID\tStreetNum\tSuburb\tArea\tPrice\tAgentID\tBedrooms\tBathrooms\tSwimming Pool\tGarages\tDate\tOwner\tSale/Rent\n");
         System.out.println(line);
 
 
 
     }
 
}

Thanks!

The String variable line is initialized to "" (the empty string) and never given another value.
What did you expect it to print?
Maybe uncomment the line that assigns a value to the variable?

I've tried without initializing line first, then it just prints out null.

It prints out the data fine in the searchProps method but null when called from addComponents

Follow the flow of the code. The value of the variable never changes from "" when addComponents is called
As suggested, initialize the variable to something besides "", like "initial value" and see what happens then

You commented out the only line that assigns any data to the line variable. It's not losing data; you never gave it any.

I have created a LineObject which takes line in as a parameter. I call getLine() from the void addComponents() but returns a null pointer exception?

Is that a question or a statement with a misplaced question mark?

If you want help, post the code and the error/stack trace exactly as it occurs at your end, copied and pasted.

Here's the searchProps class:

import java.awt.Container;
import java.sql.*;
import java.util.*;
import javax.swing.*;
 
 
public class searchProps 
{
    protected String price, area, query, suburb, date, SaleOrRent, strQuery, out, line="";
    protected int agentID, upid, StreetNum, numBeds, numBaths, numGarages, ownerID, size;
    protected boolean spool;
    PropertyObject PropertyArray[] = new PropertyObject[3];
    LineObject obj;
    JFrame jf;  
    JTextArea txtArea = new JTextArea();
     {
        initialFrame();
        addComponents();
    }
 
public searchProps(int propID) //search using UPID only
   {
       try 
               {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection conn = DriverManager.getConnection("jdbc:odbc:PropertyOracleDatabase");
            Statement s = conn.createStatement();
 
 
 
            query = ("SELECT * FROM Properties WHERE UPID = "+propID);
 
            // Fetch table
            s.execute(query);
            ResultSet rs = s.getResultSet();
            while((rs!=null) && (rs.next()))
            {
                upid=rs.getInt(1);
                StreetNum=rs.getInt(2);
                suburb=rs.getString(3);
                area=rs.getString(4);
                price=rs.getString(5);
                agentID= rs.getInt(6);
                numBeds=rs.getInt(7);
                numBaths=rs.getInt(8);
                spool=rs.getBoolean(9);
                numGarages=rs.getInt(10);
                date=rs.getString(11);
                ownerID=rs.getInt(12);
                SaleOrRent=rs.getString(13);
                size++;
 
 
              line = (line+upid+"\t"+StreetNum+"\t"+suburb+"\t"+area+"\t"+price+"\t"+agentID+"\t"+numBeds+"\t"+numBaths+"\t"+spool+"\t"+numGarages+"\t"+date+"\t"+ownerID+"\t"+SaleOrRent+"\n");
              obj= new LineObject(line);
              System.out.println(line);
              String out = obj.getLine();
              System.out.println(out);
            }
 
 
 
            // close and cleanup
            s.close();
            conn.close();
               }
 
        catch(Exception ex)
        {
            ex.printStackTrace();
        }
 
 
 
   }
    void initialFrame()
    {
        jf=new JFrame();
        jf.setSize (1300,700);
        jf.setTitle("Property Oracle | Results Page");
        jf.setVisible(true);
        jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
 
    }
 
     void addComponents()
     {
 
         Container con = jf.getContentPane();
         con.setLayout(null);
         txtArea.setBounds(20,30,1200,600);
         con.add(txtArea);
         txtArea.setText("UPID\tStreetNum\tSuburb\tArea\tPrice\tAgentID\tBedrooms\tBathrooms\tSwimming Pool\tGarages\tDate\tOwner\tSale/Rent\n");
         out = obj.getLine();
         System.out.println(out);
 
 
 
     }
 
}

And Here's the Line Object:

public class LineObject 
{
    protected String line;
 
 
    public LineObject(String a)
    {
        line = a;
    }
 
 
    public String getLine()
    {
        return line;
    }
 
}

The error I am getting is:
Exception in thread "main" java.lang.NullPointerException
at searchProps.addComponents(searchProps.java:488)
at searchProps.<init>(searchProps.java:19)
at test.main(test.java:10)

Respect Java's naming conventions and name your classes with capital letters.

Where is the variable 'con' initialized?

in the public searchProps(int propID) class:

Connection conn = DriverManager.getConnection("jdbc:odbc:PropertyOracleDatabase");

But that is not the issue

If you say so. Besides, I was talking about Container con, not Connection conn. 'con' shouldn't need initializing as long as 'jf' has been.

Somewhere in the method addComponents() is a reference to a null. Add print statements or one that reveals all variables to figure out which it is and then fix it.