Exemplo n.º 1
0
  public static void test01() throws Exception {
    Page p = new Page();
    p.setTmsp("2011-03-04 10:30:00");
    p.setUrl("http://www.google.com");
    p.setBody("my body");
    p.insert();

    Page e = new Page("2011-03-04 10:31:00", "http://www.usp.br", "o corpo");
    e.insert();
    e.setBody("usp usp usp");
    e.update();

    Database db = new Database();
    db.connect();
    ResultSet rs = Page.findAll(db);

    /*
    while (rs.next()) {
    	System.out.println(rs.getString("tmsp")
    		+", "+ rs.getString("url")
    		+", "+ rs.getString("body"));
    }*/

    Page p0 = null;
    while ((p0 = Page.next(rs)) != null) {
      System.out.println(p0.getTmsp());
      System.out.println(p0.getUrl());
      System.out.println(p0.getBody());
    }

    db.close();

    p.remove();
    e.remove();
  }
Exemplo n.º 2
0
  public static void newUrl(String url) throws Exception {
    String body = Robot.get(url);

    Page p = new Page();
    p.setTmsp("2011-03-11 11:00:00");
    p.setUrl(url);
    p.setBody(body);
    p.insert();
  }
Exemplo n.º 3
0
  public static Page next(ResultSet rs) throws Exception {
    Page p = null;

    if (rs.next()) {
      p = new Page();
      p.setTmsp(rs.getString("tmsp"));
      p.setUrl(rs.getString("url"));
      p.setBody(rs.getString("body"));
    }

    return p;
  }