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(); }
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(); }
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; }