Forum:

List pointer value is getting printed instead of data

Ranch Hand

Posts: 153

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi,

I've the below DAO File.

package org.DAO;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.RequestDispatcher;

import org.bean.UserBean;
import org.code.general.DBConnection;

public class GetDataDAO {
	DBConnection dbConnection = new DBConnection();

public List<UserBean> list() throws Exception {
		List<UserBean> userBeans = new ArrayList<UserBean>();
		try {
			Connection conn = dbConnection.conn;
			Statement stmt = dbConnection.stmt;
			ResultSet rs = dbConnection.rs;
			PreparedStatement ps = dbConnection.ps;
			String excelPath = dbConnection.excelPath;
			String queryString = null;
			dbConnection.createClassForName();
			conn = DriverManager.getConnection(
					"jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=" + excelPath + "; READONLY=FALSE;");
			System.out.println("Connecting to database…");
			System.out.println("Oracle JDBC Driver Registered!");
			if (conn != null) {
				System.out.println("You made it, take control your database now!");
			} else {
				System.out.println("Failed to make connection!");
			}
			stmt = conn.createStatement();
			queryString = "Select * from [report1448039568905$] where ([Case Owner] = 'SSHD' or [Case Owner] = 'Hyderabad Operations' or [Case Owner] = 'Customer Service- Core')";
			rs = stmt.executeQuery(queryString);
			ResultSetMetaData rsmd = rs.getMetaData();
			int rowCount = rsmd.getColumnCount();
			System.out.println("bno of cols are " + rsmd.getColumnCount());
			for (int i = 0; i < rowCount; i++) {
				System.out.print(rsmd.getColumnName(i + 1) + "  \t");
				System.out.println(rsmd.getColumnTypeName(i + 1));
			}

while (rs.next()) {
				UserBean userBean = new UserBean();
				userBean.setCaseNumber(rs.getString(1));
				userBean.setCaseOwner(rs.getString(2));
				userBean.setStatus(rs.getString(4));
				userBean.setIssue(rs.getString(5));
				userBean.setReason(rs.getString(6));
				userBean.setDateOpened(rs.getString(7));
				userBean.setAge(rs.getInt(8));
				userBeans.add(userBean);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		return userBeans;
	}
}

And the below Servlet

Here i'm trying to print the first value (caseNumber) in a jsp textbox using the below code.

But the output i getting is as below

but instead of this i need the exact value at there. please let me know where am i going wrong and how do i fix it.

Thanks,
Sunny

K. Tsang

Bartender

Posts: 3648

I like...

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Are you meant to display just the first item or all the records in the list?

If the latter, better to use the <c:foreach> to loop through the list.

K. Tsang CEng MBCS PMP PMI-ACP OCMJEA OCPJP

Bear Bibeault

Sheriff

Posts: 67753

173

I like...

posted 9 years ago

1
Number of slices to send:

Optional 'thank-you' note:

Send

Why use toString() rather than a getter (accessor) that gives you the value that you want?

[Asking smart questions] [About Bear] [Books by Bear]

HTML 5 (verified skill)
Skill verified by Jeanne Boyarsky

CSS 3 (verified skill)
Skill verified by Jeanne Boyarsky

JavaScript (verified skill)
Skill verified by Jeanne Boyarsky

Rakesh Keerthi

Ranch Hand

Posts: 153

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

K. Tsang wrote:Are you meant to display just the first item or all the records in the list?

If the latter, better to use the <c:foreach> to loop through the list.

Hi Tsang, I don't want to retrieve all the values, i want only the first value to be retrieved.

Rakesh Keerthi

Ranch Hand

Posts: 153

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Bear Bibeault wrote:Why use toString() rather than a getter (accessor) that gives you the value that you want?

Hi Bear,

Thanks for this tip. I did it (using below) and got the result as expected.

Thanks Again
:beerchug:

Barry's not gonna like this. Barry's not gonna like this one bit. What is Barry's deal with tiny ads?

We need your help - Coderanch server fundraiser

https://coderanch.com/wiki/782867/Coderanch-server-fundraiser