我的user DB表如下所示:
CREATE TABLE user (
username VARCHAR(32) PRIMARY KEY,
first_name VARCHAR(256) NOT NULL,
last_name VARCHAR(256) NOT NULL,
password VARCHAR(32) NOT NULL,
enabled BOOL
) ENGINE = InnoDB;以下是我的实体的字段定义:
@Entity
public class User implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@Column(nullable = false)
private String username;
@Column(nullable = false)
private String firstName;
@Column(nullable = false)
private String lastName;
@Column(nullable = false)
private String password;字段username是我的表/实体的键,由我来设置它的值。当我需要创建另一个用户时,我在我的服务中这样做:
public User insertUserImpl(String username, String firstName, String lastName) {
Assert.hasText(username);
Assert.hasText(firstName);
Assert.hasText(lastName);
String password = UUID.randomUUID().toString().substring(0, 4); // temp
User user = new User(username, password);
user.setFirstName(firstName);
user.setLastName(lastName);
user.setEnabled(false);
this.userRepository.save(user);
// FIXME - assegnare un ruolo
return user;
}无论如何,如果用户名已经被占用,那么存储库只会进行一次更新,因为指定的标识符不为空。这不是我想要的行为,我需要它抛出类似重复条目异常的东西。有没有办法防止这种情况发生?我一定要自己做吗?例如:
User user = this.userRepository.findOne(username);
if(user != null) {
throw new RuntimeException("Username already taken"); // FIXME - eccezione applicativa
}发布于 2019-01-10 00:35:30
如果userRepository扩展了CrudRepository,也许可以使用existsById(ID primaryKey)来测试它:
if(userRepository.existsById(username)){
//Throw your Exception
} else {
this.userRepository.save(user);
}请参阅https://docs.spring.io/spring-data/jpa/docs/current/reference/html/
https://stackoverflow.com/questions/35817584
复制相似问题