예제 #1
0
  /** update a project */
  public void update(Project project) {

    PreparedStatement stmt = null;
    try {
      String sql =
          "update Projects "
              + "set Title = ?, RecordSperImage = ?, FirstYCoord = ?, RecordHeight = ? "
              + "where ProjectID = ?";
      stmt = db.getConnection().prepareStatement(sql);
      stmt.setString(1, project.getTitle());
      stmt.setInt(2, project.getRecordsPerImage());
      stmt.setInt(3, project.getFirstYCoord());
      stmt.setInt(4, project.getRecordHeight());
      stmt.setInt(5, project.getProjectID());

      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 project */
  public void add(Project project) {
    PreparedStatement stmt = null;
    Statement keyStmt = null;
    ResultSet keyRS = null;
    try {
      String sql =
          "insert into Projects "
              + "(Title, RecordSperImage, "
              + "FirstYCoord, RecordHeight) "
              + "values (?, ?, ?, ?)";
      stmt = db.getConnection().prepareStatement(sql);
      stmt.setString(1, project.getTitle());
      stmt.setInt(2, project.getRecordsPerImage());
      stmt.setInt(3, project.getFirstYCoord());
      stmt.setInt(4, project.getRecordHeight());

      if (stmt.executeUpdate() == 1) {
        keyStmt = db.getConnection().createStatement();
        keyRS = keyStmt.executeQuery("select last_insert_rowid()");
        keyRS.next();
        int id = keyRS.getInt(1);
        project.setProjectID(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();
      }
    }
  }