示例#1
0
  /** update a field */
  public void update(Field field) {
    PreparedStatement stmt = null;
    try {
      String sql =
          "update Fields "
              + "set XCoord = ?, Width = ?, HelpHTML = ?, "
              + "KnownData = ?, ProjectID = ?, Title = ? "
              + "where FieldID = ?";
      stmt = db.getConnection().prepareStatement(sql);
      stmt.setInt(1, field.getxCoord());
      stmt.setInt(2, field.getWidth());
      stmt.setString(3, field.getHelpHTML());
      stmt.setString(4, field.getKnownData());
      stmt.setInt(5, field.getProjectID());
      stmt.setInt(7, field.getFieldID());
      stmt.setString(6, field.getTitle());

      if (stmt.executeUpdate() == 1) {
        System.out.println("Update success");
      } else {
        System.out.println("Update fail");
      }
    } catch (SQLException e) {
      System.out.println("Can't execute update");
      e.printStackTrace();
    } finally {
      try {
        if (stmt != null) stmt.close();
      } catch (SQLException e) {
        System.out.println("Can't execute connect");
        e.printStackTrace();
      }
    }
  }
示例#2
0
  /** add a field */
  public void add(Field field) {
    PreparedStatement stmt = null;
    Statement keyStmt = null;
    ResultSet keyRS = null;
    try {
      String sql =
          "insert into Fields (XCoord, Title, Width, HelpHTML, "
              + "KnownData, ProjectID) values (?, ?, ?, ?, ?, ?)";
      stmt = db.getConnection().prepareStatement(sql);
      stmt.setInt(1, field.getxCoord());
      stmt.setInt(3, field.getWidth());
      stmt.setString(4, field.getHelpHTML());
      stmt.setString(5, field.getKnownData());
      stmt.setInt(6, field.getProjectID());
      stmt.setString(2, field.getTitle());

      if (stmt.executeUpdate() == 1) {
        keyStmt = db.getConnection().createStatement();
        keyRS = keyStmt.executeQuery("select last_insert_rowid()");
        keyRS.next();
        int id = keyRS.getInt(1);
        field.setFieldID(id);
      } else {
        System.out.println("Add fail");
      }
    } catch (SQLException e) {
      System.out.println("Can't execute add");
      e.printStackTrace();
    } finally {
      try {
        if (keyRS != null) keyRS.close();
        if (stmt != null) stmt.close();
        if (keyStmt != null) keyStmt.close();
      } catch (SQLException e) {
        System.out.println("Can't execute connect");
        e.printStackTrace();
      }
    }
  }