Hi
I seem to have a problem with reurning rows of data, with more than 1 columns.
I am writing a generic method that returns data i get from database. The parameters I take is a query
string, and connection details.
my problem is that when i select more than one column from a table.. instead of returning something like this:
1,Coal
2,Companies
3,Energy
it will return this:
1,Coal,2,Companies,3,Energy
1,Coal,2,Companies,3,Energy
1,Coal,2,Companies,3,Energy
it will display 3 times since there is only 3 dummy entries in database table for
test puposes.
How can i get this right?
Any help is appreciated
Thanx
The method :
public Vector getSQLQueryData(String queryString,String url, String User, String Password){
Statement stmt = null;
ResultSet rs = null;
Connection conn = null;
Vector v = new Vector();
Vector v2 = new Vector();
try{
//getConnection()
conn = getConnection(url,User,Password);
stmt = conn.createStatement();
rs= stmt.executeQuery(queryString);
while ((rs != null) && (rs.next())) {
for(int i = 1;i <= rs.getMetaData().getColumnCount() ;i++) {
v.addElement(rs.getString(i));
}
v2.add(v);
}
} catch (SQLException sqle) {
System.out.println("SQLException :"+ sqle.getMessage());
}finally{
//close rs
try{
if(rs != null){
rs.close();
}
}
catch(Exception e){
System.out.println("Exception: RS cannot close :"+ e.getMessage());
}
//close stmt
try{
if(stmt != null){
stmt.close();
}
}
catch(Exception e){
System.out.println("Exception: stmt cannot close :"+ e.getMessage());
}
//close conn
try{
if(conn != null){
conn.close();
}
}
catch(Exception e){
System.out.println("Exception: conn cannot close :"+ e.getMessage());
}
}//end finally
return v2;
}//end getSQLQueryData(String,String,String,String)
When I call this method ...the code in main():
public static void main(String[] args){
FUtilsRS futils = new FUtilsRS();
String queryString = "select distinct id, folder from tbl_foldername order by folder";
String url = "URL";
String User = "USER";
String Password = "PASSWORD";
Vector v = new Vector();
ResultSet rs = null;
v = futils.getSQLQueryData(queryString,url,User, Password);
for(int i=0; i<v.size();i++){
System.out.println("" + i + v.get(i));
}
}//end main
