Esempio n. 1
0
  public static void start() throws Exception {
    try {

      SocketConnector connector = new SocketConnector();
      connector.setPort(8080);

      server.setConnectors(new Connector[] {connector});
      WebAppContext context = new WebAppContext();
      context.setServer(server);
      context.setContextPath("/DBService");
      // context.setContextPath("/");
      context.setWar("src/main/webapp");
      server.addHandler(context);
      SQLExecutor.setConfigfile("local_logging.properties");

      server.start();

    } catch (Exception e) {
      if (server != null) {
        try {
          server.stop();
        } catch (Exception e1) {
          throw new RuntimeException(e1);
        }
      }
    }
  }
Esempio n. 2
0
public class DBUtil {

  // protected final Connection conn;
  // protected Statement stmt;
  protected SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ssZ");
  protected SQLExecutor stmt = SQLExecutor.getInstance();

  public DBUtil() {}

  protected String toDateString(Date date) {
    return "TIMESTAMP '" + format.format(date) + "'";
    // return "TIMESTAMP WITH TIME ZONE  'epoch' +" + date.getTime() + "* INTERVAL '1 second'";

  }

  protected List<? extends DBObject> generateObjectList(DBObject element, ResultSet res) {

    try {
      List<DBObject> result = new LinkedList<DBObject>();
      while (res.next()) {
        DBObject dbob = (element.getClass().newInstance()).getDBObject(res);
        result.add(dbob);
      }
      return result;
    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } catch (InstantiationException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } catch (IllegalAccessException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }
    return null;
  }
}