How to put result of ResultSet in a Array

[Sanam Kumar]

Hello,

I am badly in need of help and it is very urgent.
can someone ppleaseeeeeeeeeeee help

I want to store the result of a resultset in a array,

Eg : i have table tblannotation , n have 3 records with id = 1

and i want to put the result in an array, how can i do that

i.e i want
annoTextArray[1] = "aaaa";
annoTextArray[2] = "bbb";
annoTextArray[3] = "aaaa";

how do i put result of a resultset in an array

pleaseeeeeeeeeeeeee help;

Thanks
Sanam


Class.forName("org.postgresql.Driver");
url1 = "jdbc ostgresql://192.161.0.0:3333/emo";
con1 = DriverManager.getConnection(url1,"an","jwqek");
stmt1 = con1.createStatement();

sql1 = "select * from tblannotation where id =1";

ResultSet rs1 = stmt1.executeQuery(sql1);
rs1.last();
int rowCount = rs1.getRow();
System.out.println("Row Count : " +rowCount);

while(rs1.next())
{
String[] anoTxt = rs1.getString("annotationtext");
//System.out.println(anoTxt1);
annoTextArray = anoTxt1;
}
[ March 03, 2005: Message edited by: Bear Bibeault ]

[Srinivasa Raghavan]

If i come across a situation like this my solution is.

Create a data structure ( A Normal class ) to hold the details of a single row. ( For example if it's a emp table create a emp Class )
For each row in the RecordSet Instantiate & set the value of all members in this class & add it to an array or collection.

But Is this a right way of design for this situation, any experianced people can throw some light.
[ March 02, 2005: Message edited by: Srinivasa Raghavan ]

[Adeel Ansari]

int i=0;
while(rs.next()){
  strArray[i++]= rs.getString(1);
}

[Adeel Ansari]

Originally posted by Srinivasa Raghavan:
If i come across a situation like this my solution is.

Create a data structure ( A Normal class ) to hold the details of a single row. ( For example if it's a emp table create a emp Class )
For each row in the RecordSet Instantiate & set the value of all members in this class & add it to an array or collection.

But Is this a right way of design for this situation, any experianced people can throw some light.

Surely a better way is to use a VO over Collection.
Thanks.

[Srinivasa Raghavan]

Adeel, Whats VO ? A vector ?

[Shailesh Chandra]

Originally posted by Srinivasa Raghavan:
Adeel, Whats VO ? A vector ?

VO means Value Object, It is a Pattern, you can refer
here

alternatively you can refer DTO (Data Transfer Object)
[ March 03, 2005: Message edited by: Shailesh Chandra ]

[Srinivasa Raghavan]

Shailesh, Thanks for the link.

[Shailesh Chandra]

Sanam,

here is solution for you,assuming you have query like

Select,col1,col2, col3 from tblannotation where id =1

create a VO as below

 
import java.io.Serializable;
 
 
public class TableVO implements Serializable
{
private String col1;
private String col2;
private String col3;
 

public String getCol1()
{
return col1;
}
 

public String getCol2()
{
return col2;
}
 

public String getCol3()
{
return col3;
}
 


public void setCol1(String string)
{
col1 = string;
}
 

public void setCol2(String string)
{
col2 = string;
}
 

public void setCol3(String string)
{
col3 = string;
}
 
}

now use Same TableVO in your code

  
 
Class.forName("org.postgresql.Driver");
url1 = "jdbc  ostgresql://192.161.0.0:3333/emo";
con1 = DriverManager.getConnection(url1,"an","jwqek");
stmt1 = con1.createStatement();
 
sql1 = "select * from tblannotation where id =1";
 
ResultSet rs1 = stmt1.executeQuery(sql1);
 
List lstTableVO = new ArrayList();
 
while(rs1.next())
{
TableVo tableVo = new tableVO();

tableVo.setCol1(rs.getString("col1"));
tableVo.setCol2(rs.getString("col2"));
tableVo.setCol2(rs.getString("col3"));

lstTableVO.add(tableVo);
 
 
} 

now use Same TableVO in your code

//If you want data in array then

TableVo[] anoTxt = (TableVo[])lstTableVO.toArray(new TableVo[lstTableVO.size()]);

// for fetching any data


String col1Value = ((TableVo) anoTxt[your_index]).getCol1();




hope this will solve your problem

Shailesh
[ March 03, 2005: Message edited by: Shailesh Chandra ]

[Lee Barney]

Here is an example that returns an ArrayList of ArrayLists. Using arrays is not much different. fieldCount is retained information from the creation of queryString.

 ArrayList retArr = new ArrayList();
       try {
ResultSet results = (ResultSet)aConnection.createStatement().executeQuery(queryString);
results.last();
int resultSize = results.getRow();
results.beforeFirst();
retArr = new ArrayList();
for(int i = 0; results.next(); i++){
ArrayList subArray = new ArrayList();
for(int j = 0; j < fieldCount; j++){
System.out.println("adding "+results.getObject(aFieldsArray[j])+" to "+j+","+i);
subArray.add(results.getObject(aFieldsArray[j]));
}
retArr.add(subArray);
}
} catch (SQLException e) {
e.printStackTrace();
} 

[Sean Sullivan]

The diaz project (diaz.sourceforge.net) demonstrates another approach for JDBC programming.

The main class in the project is net.sf.diaz.AbstractJdbcDao

To execute a query:

1) implement a class that extends AbstractJdbcDao
2) in the class, call executeQuery

The executeQuery method returns a List of net.sf.diaz.Row objects

Caveat: the diaz project is designed for use with J2SE 5.0
The code will not compile with earlier versions of the J2SE platform