BonitaSoftConnector

package BonitaSoftConnector;
public class SetCellContentConnector extends SheetsterConnector {
 
  private String workBookId;
  private String sheetName;
  private String cellAddress;
  private Object value;
  private Object cellContent;
	public Object getValue(){
		return this.value;
	}
 
	
	public void setValue(Object v){
		this.value=v;
	}
 
  public Object getCellContent() {
    return cellContent;
  }
 
  public void setWorkBookId(String workBookId) {
    this.workBookId = workBookId;
  }
 
  public void setSheetName(String sheetName) {
    this.sheetName = sheetName;
  }
 
  public void setCellAddress(String v) {
    this.cellAddress = v;
  }
 
  @Override
  public void executeTask() throws Exception {
    final String cellResponse = "/workbook/id/" + workBookId + "/txt/sheet/addcell/"+sheetName + "/"  + cellAddress + "/" + String.valueOf(value);
    cellContent = getHTTPObject(cellResponse.toString());
  }
 
}

package BonitaSoftConnector;
/**
 * Copyright (C) 2011 BonitaSoft S.A.
 * BonitaSoft, 31 rue Gustave Eiffel - 38000 Grenoble
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 2.0 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */
import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.net.URL;
import java.net.URLConnection;
import java.util.ArrayList;
import java.util.List;
import java.util.zip.GZIPInputStream;
 
import org.ow2.bonita.connector.core.Connector;
import org.ow2.bonita.connector.core.ConnectorError;

 
/**
 *
 * @author Matthieu Chaffotte
 *
 */
public abstract class SheetsterConnector extends Connector {
 
  private String serverURL;
  private String username;
  private String password;
 
  private String session;
 
  public void setServerURL(String serverURL) {
    this.serverURL = serverURL;
  }
 
  public void setUsername(String username) {
    this.username = username;
  }
 
  public void setPassword(String password) {
    this.password = password;
  }
 
  protected void executeConnector() throws Exception {
    authenticate();
    executeTask();
  }
 
  protected abstract void executeTask() throws Exception;
 
  private void authenticate() throws Exception {
    StringBuilder loginURL = new StringBuilder(serverURL);
    loginURL.append("/workbook/id/-2/txt/system/login/?username=").append(username)
    .append("&password=").append(password);
    getHTTPBytes(loginURL.toString());
  }
 
  public byte[] getHTTPBytes(String urlstr) throws Exception {
    if(!urlstr.startsWith(serverURL)){
      urlstr = serverURL + urlstr;
    }
    URL pageURL = new URL(urlstr);
    URLConnection pageConnection;
    pageConnection = pageURL.openConnection();
    if (session != null) {
      pageConnection.addRequestProperty("Cookie", session);
    }
    pageConnection.setConnectTimeout(10000);
 
    InputStream webPageInputStream;
    pageConnection.connect();
    webPageInputStream = pageConnection.getInputStream();
    String enc = pageConnection.getContentEncoding();
    try {
      if (enc.equalsIgnoreCase("gzip"))
        webPageInputStream = new GZIPInputStream(pageConnection.getInputStream());
    } catch (Exception e) {
      ;// normal
    }
 
    ByteArrayOutputStream webPageData = new ByteArrayOutputStream();
    int totalBytesRead = 0;
    boolean moreToRead = true;
    byte[] readBuf = new byte[2048];
    while (moreToRead) {
      int numBytesRead = 0;
      try {
        numBytesRead = webPageInputStream.read(readBuf);
      } catch (IOException e) {
        moreToRead = false;
      }
      if (numBytesRead > 0) {
        totalBytesRead += numBytesRead;
        webPageData.write(readBuf, 0, numBytesRead);
      } else
        moreToRead = false;
    }
    webPageInputStream.close();
    // Pull the session ID out of the connection headers
    if (session == null) {
      try {
        session = pageConnection.getHeaderField("Set-Cookie");
        if (session == null)
          throw new Exception("session cookie not present");
 
        if (!session.startsWith("sessionid="))
          throw new Exception("invalid session cookie");
 
        // Strip off any extraneous header fields
        if (session.contains(";"))
          session = session.substring(0, session.indexOf(";"));
      } catch (Exception e) {
        throw new RuntimeException("failed to parse session cookie", e);
      }
    }
    return webPageData.toByteArray();
  }
 
  public String getHTTPData(String urlstr) throws Exception {
    return new String(getHTTPBytes(urlstr));
  }
 
  public Object getHTTPObject(String urlstr) throws Exception {
    // Create a URL object from urlString
    String ret = new String(getHTTPBytes(urlstr));
    // try numbers
    try{
      Double d = Double.parseDouble(ret);
      return d;
    }catch(NumberFormatException de){
      try{
        Float f = Float.parseFloat(ret);
        return f;
      }catch(NumberFormatException fe){
        try{
          Integer i  = Integer.parseInt(ret);
          return i;
        }catch(NumberFormatException ie){
          // ok not a number
        }
      }
    }
 
    // try boolean
    if(ret.equalsIgnoreCase("true")){
      return Boolean.valueOf(true);
    }else if(ret.equalsIgnoreCase("false")){
      return Boolean.valueOf(false);
    }
    //finally returns string val
    return ret;
  }
 
  @Override
  protected List<ConnectorError> validateValues() {
    List<ConnectorError> errors = new ArrayList<ConnectorError>();
    if (serverURL.length() == 0) {
      ConnectorError error = new ConnectorError("serverURL", new IllegalArgumentException("The server URL is empty!"));
      errors.add(error);
    }
    return errors;
  }
 
}