Vectors

[steph rinert]

Help,
I am using a vector to insert some data into a database but since a vector is wrapped in brackets, I do not get desired affects. Is there a way of inserting a vector into an Oracle DB without inserting the [] brackets thats comes with a vector.
Thanks

[steph rinert]

ohh and I wanted to insert the entire vector and not have to go though field by field.

[Michael Zalewski]

If you are writing the Vector into a single column, single row in the database, you could always override the Vector.toString() method to get rid of the brackets:

  
  Vector myVector = new Vector() {
    public String toString() {
      StringBufer sVector = new StringBuffer( super.toString());
      return sVector.substring( 1, sVector.length() - 1);
    }
  };
  ...
  myVector.add( "Adam");
  myVector.add( "Beatrice");
  myVector.add( "Charles");
  ...
  // Write to DB here
  String sSQL = "INSERT INTO MyTable(Field)"
     + " VALUES( " + myVector + ")";

You can also use the copy constructor just before you write to the database:

  Vector myVector = new Vector();
  myVector.add(...);
  ...
  String sSQL = "INSERT INTO MyTable(Field)"
     + " VALUES( "
     + new Vector( myVector) {
          public String toString() {
            StringBufer sVector = new StringBuffer( super.toString());
            return sVector.substring( 1, sVector.length() - 1);
          }
       }
     + ")";

Aren't inner classes neat?

[steph rinert]

This worked great,
Thanks