public Vector getData(String query) throws SQLException
	{

		Connection connection = null;
		Statement statement = null;
		ResultSet result = null;
		String val = "";
		Vector value = new Vector();

		try
		{
			Class.forName(driver);
			connection = DriverManager.getConnection(url, username, passwd);
			statement = connection.createStatement();
			result = statement.executeQuery(query);

			while (result.next())
			{
				val = result.getString(1);
				value.add(val);
			}

			result.close();
			result = null;
			statement.close();
			statement = null;

		}
		catch (Exception e)
		{
			System.out.println(e);
		}
		finally
		{
			if (statement != null)
			{
				try
				{
					statement.close();
				}
				catch (SQLException e)
				{
					System.out.println(e);
				}
				statement = null;
			}
			if (connection != null)
			{
				try
				{
					connection.close();
				}
				catch (SQLException e)
				{
					System.out.println(e);
				}
				connection = null;
			}
		}

		return value;
	}