how to load the values in one object?

[maggie karve]

   package myServlets;

import myServlets.Data;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.util.*;

public class Simple extends HttpServlet{


	
 public void doPost(HttpServletRequest request, HttpServletResponse response)
	throws ServletException,IOException
    {
		String url = "jdbc:postgresql://localhost/Books";
	    Connection con=null;
		ResultSet rs;
		String s;
		Statement st=null;
		
String sqlstr = "SELECT \"BillMonthYear\",\"Principal\",\"Interest\",\"Tax\",\"AptRent\",\"CarLoan\","+ 
	       "\"EPB\", \"ATT\", \"ComcastISP\", \"Vonage\",\"HealthInsurance\",\"CarInsurance\","+ 
	       "\"PMI\", \"BankOfAmerica\", \"DCU VISA\", \"DiscoverFlag\", \"Discovermiles\","+ 
	       "\"TrustVISA\", \"HOA Fee\" FROM \"BookSchema\".\"Bill\"";
	try 
		{
			con = DriverManager.getConnection(url,"postgres", "admin123");
			st = con.createStatement();
			rs = st.executeQuery(sqlstr);

			
List<Data> b1=new ArrayList<Data>();
while (rs.next())	
{
Data bm=new Data();	
bm.setBillMonthYear(rs.getString(1));
bm.setPrincipal(rs.getString(2));
bm.setInterest(rs.getString(3));
bm.setTax(rs.getString(4));
bm.setAptRent(rs.getString(5));
bm.setCarLoan(rs.getString(6));
bm.setEPB(rs.getString(7));
bm.setATT(rs.getString(8));
bm.setComcastISP(rs.getString(9));
bm.setVonage(rs.getString(10));
bm.setHI(rs.getString(11));
bm.setCI(rs.getString(12));
bm.setPMI(rs.getString(13));
bm.setBOA(rs.getString(14));
bm.setDCUVISA(rs.getString(15));
bm.setDiscoverFlag(rs.getString(16));
bm.setDiscovermiles(rs.getString(17));
bm.setTrustVISA(rs.getString(18));
bm.setHOAFee(rs.getString(19));
b1.add(bm);
}
//b1.add(bm);
System.out.println(b1.size());
System.out.println(b1);

		rs.close();
}					
		catch(Exception ex) 
		{
			System.err.println("Exception: " + ex.getMessage());
		}
		finally{
		try
		{
		if (st!=null)
		st.close();
		}catch(Exception ep)
		{
		ep.printStackTrace();
		}
		try{
		if (con!=null)
		con.close();
		}
		catch(Exception ie)
		{
		ie.printStackTrace();
		}
		}
		}

	public void doGet(HttpServletRequest request, HttpServletResponse response)
	throws ServletException,IOException{	
  try
  {
  doPost(request,response);
  }
  catch(Exception ie)
  {
  ie.printStackTrace();
  }
  }
  }
 
	

 

when i print for size of table ..i get correct values i.e.4..
but when i want the actual values from the table and i ask System.out.println(b1);

it prints some values like [myServlets.Data@451c0d60, myServlets.Data@34b23d12, myServlets.Data@21c783c5, myServlets.Data@319c0bd6]

i want actual values..
this is silly and it will require a simple java statement,but i don know how to access that..


there is no problem with sql ,no problem with post or get method definition....
Thanks.....

[Bear Bibeault]

This is simple Java -- that's what's returned from the default toString() of the base Object class. If you want to extract and emit the value for the List, you'll need to iterate over the list.

I have moved this to a more appropriate forum.

[Sridhar Santhanakrishnan]

You can override the toString() method in your Data class.

[maggie karve]

the toString method is not working there...i tried doing it....

[Rob Spoor]

You can't override toString for arrays, but you can use the toString methods of java.util.Arrays for that.

[Sridhar Santhanakrishnan]

Overriding the toString() method in Data and then calling <yourList>.toString() should list all objects.

[maggie karve]

it is not happening with toStriing method too....

it is giving me an error as not recognising the method toString.....

[Rob Spoor]

Then it's not an object. Every object, even arrays, has a toString() method.

[Afzal Rehman]

what ever is your data class you should have to override the toString method and gives the appropriate values.
Whatever you expect. toString method will give understandable representation of object.