Пример #1
0
  public void InsertItem(String URL, String Text, String HTML) throws SQLException {
    WebURL curURL = new WebURL();
    curURL.setURL(URL);

    Statement stmt = null;
    try {
      stmt = c.createStatement();
    } catch (SQLException e) {
      System.out.println("Error, can't create statement in AddLink");
      e.printStackTrace();
    }

    PreparedStatement statement =
        c.prepareStatement("INSERT INTO PAGES (URL,SUBDOMAIN,BODY,HTML) values (?, ?, ?, ?)");
    statement.setString(1, URL);
    statement.setString(2, curURL.getSubDomain());
    statement.setString(3, Text);
    statement.setString(4, HTML);
    statement.executeUpdate();
  }