Account.java

@Entity
@NamedQuery(name = “Account.FindByName”, query = “SELECT a FROM Account a WHERE name like :name”)
public class Account {

	@Id
	@GeneratedValue(strategy = GenerationType.AUTO)
	@Column(name = “id”, updatable = false, nullable = false)
	private Long id;

	@Column
	private String name;

	@Column
	@Enumerated(EnumType.STRING)
	private AccountState state;

	…

}

DeleteAccount.java

Account a = em.find(Account.class, a.getId());
em.remove(a);

DeleteAccount.log

16:07:59,511 DEBUG SQL:92 – select account0_.id as id1_0_0_, account0_.name as name2_0_0_, account0_.state as state3_0_0_ from Account account0_ where account0_.id=? and ( account0_.state <> ‘DELETED’)
16:07:59,534 DEBUG SQL:92 – UPDATE account SET state = ‘DELETED’ WHERE id = ?

EntityManager.java

Account a = em.find(Account.class, a.getId());

EntityManager.log

16:07:59,540 DEBUG SQL:92 – select account0_.id as id1_0_0_, account0_.name as name2_0_0_, account0_.state as state3_0_0_ from Account account0_ where account0_.id=? and ( account0_.state <> ‘DELETED’)

JPQL.java

TypedQuery<Account> q = em.createNamedQuery(“Account.FindByName”, Account.class);
q.setParameter(“name”, “%ans%”);
Account a = q.getSingleResult();

JPQL.log

16:07:59,511 DEBUG SQL:92 – select account0_.id as id1_0_, account0_.name as name2_0_, account0_.state as state3_0_ from Account account0_ where ( account0_.state <> ‘DELETED’) and (account0_.name like ?)

PreRemove.java

@Entity
@SQLDelete(sql = “UPDATE account SET state = ‘DELETED’ WHERE id = ?”, check = ResultCheckStyle.COUNT)
public class Account {

…
@PreRemove
public void deleteUser() {
this.state = AccountState.DELETED;
}

}

SqlDelete.java

@Entity
@SQLDelete(sql = “UPDATE account SET state = ‘DELETED’ WHERE id = ?”, check = ResultCheckStyle.COUNT)
public class Account { … }

Where.java

@Entity
@SQLDelete(sql = “UPDATE account SET state = ‘DELETED’ WHERE id = ?”, check = ResultCheckStyle.COUNT)
@Where(clause = “state <> ‘DELETED'”)
@NamedQuery(name = “Account.FindByName”, query = “SELECT a FROM Account a WHERE name like :name”)
public class Account { … }